Skip to main content

Section Schedule for TR Sections

The schedule below summarizes most important subject material covered throughout the semester. It is subject to change.

Homeworks, MyITLab Lessons, and MyITLab Bonus Projects are due at 11:59pm Eastern Time on the dates listed. Exams will be given on the dates shown. We suggest you work on the assignments as they're shown in the Assignments to Work On column below so that you stay on track.

Day Unit Content Readings & Resources [1]-[3] Assignments to Work On
Thu 08/18 Excel & Data Analysis
  • Course Introduction
    • Course policies
    • Course websites
    • Resources
  • Data Analysis Supplemental Content
    • Effective Internet searches

Required

  • Syllabus
  • First Day Presentation

Recommended

  • MyITLab Lesson A
    • Excel Chapter 1
    • Excel Chapter 10
Tue 08/23 Excel & Data Analysis
  • Data Analysis Supplemental Content
    • Download data and extract ZIP file contents
    • Answer analysis questions
  • Excel Chapter 1
    • Create a new workbook
    • Adjust sheets
    • Enter data
  • Excel Chapter 10
    • Import XML and CSV data
    • Import from an Access database

Recommended

  • MyITLab Lesson A
    • Excel Chapter 4
    • Excel Chapter 12
Wed 08/24   MyITLab Lesson A Due
Thu 08/25 Excel & Data Analysis
  • Excel Chapter 1
    • Insert rows and/or columns
  • Excel Chapter 4
    • Create and format tables
    • Use the table total row
    • Sort data

Recommended

  • Excel Chapter 4
    • Volume 1 Pages 565-591
 
Tue 08/30 Excel & Data Analysis
  • Excel Chapter 1
    • Format cells
    • Specify page orientation and scaling
  • Excel Chapter 4
    • Freeze panes
    • Apply conditional formatting
    • Apply color scale formatting
  • Excel Chapter 12
    • Apply cell styles

Recommended

  • Excel Chapter 1
    • Volume 1 Pages 414-431
  • Excel Chapter 4
    • Volume 1 Pages 556-564
    • Volume 1 Pages 594-604
  • Excel Chapter 12
    • Volume 2 Pages 535-540
  • MyITLab Lesson B
    • Excel Chapter 2
    • Excel Chapter 8
Thu 09/01 Excel & Data Analysis
  • Excel Chapter 1
    • Write formulas
    • Use AutoFill
  • Excel Chapter 2
    • Use statistical functions
    • Use cell references
  • Excel Chapter 8
    • Use the RANK.EQ function

Recommended

  • Excel Chapter 1
    • Volume 1 Pages 384-393
  • Excel Chapter 2
    • Volume 1 Pages 448-470
  • Excel Chapter 8
    • Volume 2 Pages 354-366
  • MyITLab Lesson B
    • Excel Chapter 7
    • Excel Chapter 9
Mon 09/05   No Classes - Labor Day
Tue 09/06 Excel & Data Analysis
  • Excel Chapter 2
    • Use the IF functions
  • Excel Chapter 7
    • Use AND/OR criteria
    • Use nested IF functions
  • Excel Chapter 9
    • Create 3-D formulas

Recommended

  • Excel Chapter 2
    • Volume 1 Pages 471-487
  • Excel Chapter 7
    • Volume 2 Pages 310-320
  • Excel Chapter 9
    • Volume 2 Pages 407-415
  • Homework #1
  • MyITLab Lesson B
    • Excel Chapter 3
    • Excel Chapter 5
Wed 09/07   MyITLab Lesson B Due
Thu 09/09 Excel & Data Analysis
  • Excel Chapter 3
    • Create charts
    • Format charts
    • Use a trendline
    • Insert a sparkline
  • Excel Supplemental Content
    • Evaluate trendlines
    • Format chart axes

Recommended

  • Homework #1
  • MyITLab Lesson C
    • Excel Chapter 6
    • Excel Chapter 11
Fri 09/09 Excel & Data Analysis Homework #1 Due  
Tue 09/13 Excel & Data Analysis
  • Excel Chapter 5
    • Create and use PivotTables
    • Add and format PivotCharts
  • Excel Supplemental Content
    • Group PivotTable data

Recommended

  • Excel Chapter 5
    • Volume 2 Pages 224-253
  • Homework #2
  • MyITLab Lesson C
    • Access Chapter 1
Thu 09/15 Excel & Data Analysis
  • Excel Chapter 6
    • Use Goal Seek
    • Use Scenario Manager
  • Excel Chapter 8
    • Perform correlation analysis

Recommended

  • Excel Chapter 6
    • Volume 2 Pages 277-285
  • Excel Chapter 8
    • Volume 2 Pages 367-373
  • Homework #2
  • MyITLab Lesson C
    • Access Chapter 2
Fri 09/16 Excel & Data Analysis Homework #2 Due  
Tue 09/20 Excel & Data Analysis
  • Excel Chapter 2
    • Use the VLOOKUP function
    • Use the PMT/FV function
  • Excel Chapter 8
    • Use the SUMIF and COUNTIF functions
  • Excel Chapter 10
    • Use the CONCATENATE function

Recommended

  • Excel Chapter 10
    • Volume 2 Pages 456-462
  • Homework #3
Wed 09/21   MyITLab Lesson C Due
Thu 09/22 Excel & Data Analysis
  • Excel Chapter 6
    • Use Solver
  • Excel Chapter 11

Recommended

  • Excel Chapter 6
    • Volume 2 Pages 286-296
  • Homework #3
Fri 09/23 Excel & Data Analysis Homework #3 Due  
Tue 09/27 Excel & Data Analysis Exam #1  
Thu 09/29 Access
  • Access Chapter 1
    • Add, edit, and delete records
    • View query results
    • Use views for tables
    • Use views for queries
    • View forms
    • View reports
    • Compact and repair the database

Recommended

  • Access Chapter 1
    • Volume 1 Pages 617-644
  • MyITLab Lesson D
    • Access Chapter 3
    • Access Chapter 5
Tue 10/04 Access
  • Access Chapter 2
    • Determine appropriate field types
    • Select primary and composite keys
    • Identify appropriate table relationships

Recommended

  • Access Chapter 2
    • Volume 1 Pages 676-690
  • MyITLab Lesson D
    • Access Chapter 8
    • Access Chapter 10
Wed 10/05   MyITLab Lesson D Due
Thu 10/06 Access
  • Access Chapter 1
    • Selecting a database or spreadsheet
  • Access Chapter 2
    • Plan and normalize databases
  • Access Chapter 9
    • Normalize databases

Recommended

  • Access Chapter 9
    • Volume 2 Pages 791-802
 
Tue 10/11 Access
  • Access Chapter 1
    • Create and save databases
  • Access Chapter 2
    • Create tables
    • Define relationships and use referential integrity
  • Access Chapter 5
    • Create lookup fields
  • Access Chapter 8
    • Import data from text files
    • Import data from Excel workbooks
  • Access Supplemental Content
    • Import XML data
    • Answering analysis questions

Recommended

  • Access Chapter 1
    • Volume 1 Pages 653-660
  • Access Chapter 2
    • Volume 1 Pages 691-698
  • Access Chapter 5
    • Volume 2 Pages 587-591
  • Access Chapter 8
    • Volume 2 Pages 756-767
  • Access Supplemental Content
    • Pages 18-19
    • Page 22
 
Thu 10/13 Access
  • Access Chapter 2
    • Create queries
    • Use criteria
    • Specify query sort order
  • Access Chapter 10
    • Create SQL queries

Recommended

  • Access Chapter 2
    • Volume 1 Pages 705-726
  • Access Chapter 10
    • Volume 2 Pages 865-874

 

Tue 10/18 Access
  • Access Chapter 3
    • Use Expression Builder
    • Create calculated fields
    • Specify field aliases
    • Format query fields

Recommended

  • Access Chapter 3
    • Volume 1 Pages 745-766
  • MyITLab Lesson E
    • Access Chapter 4
    • Access Chapter 6
Wed 10/19   MyITLab Lesson E Due
Thu 10/20 Access
  • Access Chapter 2
    • Specify outer join relationships
    • Control if query fields are shown
  • Access Chapter 3
    • Use aggregate functions and grouping
  • Access Chapter 5
    • Use conditional functions

Recommended

  • Access Chapter 3
    • Volume 1 Pages 767-776
  • Access Chapter 5
    • Volume 2 Pages 597-615
  • Homework #4
Tue 10/25 Access
  • Access Chapter 4
    • Create forms
    • Modify forms

Recommended

  • Access Chapter 4
    • Volume 1 Pages 791-811
  • Homework #4
  • MyITLab Lesson F
    • Word Chapter 2
    • Word Chapter 5
Thu 10/27 Access
  • Access Chapter 4
    • Create reports
    • Modify reports

Recommended

  • Access Chapter 4
    • Volume 1 Pages 812-829
  • Homework #4
  • MyITLab Lesson F
    • Word Chapter 1
    • Word Chapter 8
Fri 10/28 Access Homework #4 Due    
Tue 11/01 Access
  • Access Chapter 2
    • Use wildcard criteria
  • Access Chapter 5
    • Create parameter queries
  • Access Chapter 6
    • Create update queries
    • Create delete queries
  • Access Supplemental Content
    • Display unique records

Recommended

  • Homework #5
  • MyITLab Lesson F
    • Word Chapter 3
    • Word Chapter 4
Wed 11/02   MyITLab Lesson F Due
Thu 11/03 Access
  • Access Supplemental Content
    • Understand SQL SELECT queries
    • Write custom SQL queries

Recommended

  • Homework #5
  • MyITLab Lesson G
    • Word Chapter 6
    • Word Chapter 7
    • PowerPoint Chapter 2
Fri 11/04 Access Homework #5 Due  
Thu 11/10 Access Exam #2  
Tue 11/15 Word & PowerPoint
  • Word Chapter 2
    • Apply paragraph formatting
    • Create, modify, and use formatting styles
    • Insert and format pictures
    • Adjust paragraph spacing, indentation, and alignment
  • Word Chapter 5
    • Insert Excel charts
  • Word Chapter 8
    • Insert hyperlinks

Recommended

  • Word Chapter 2
    • Volume 1 Pages 197-231
  • Word Chapter 5
    • Volume 2 Pages 34-41
  • Word Chapter 8
    • Volume 2 Pages 174-185
  • MyITLab Lesson G
    • PowerPoint Chapter 1
    • PowerPoint Chapter 4
Wed 11/16   MyITLab Lesson G Due    
Thu 11/17 Word & PowerPoint
  • Word Chapter 1
    • Create headers and footers
    • Adjust margins and orientation
  • Word Chapter 2
    • Create section breaks
    • Use bulleted and numbered lists
  • Word Chapter 3
    • Create tables
  • Word Chapter 4
    • Insert a cover page
  • Word Supplemental Content
    • Use the Equation Editor

Recommended

  • Word Chapter 1
    • Volume 1 Pages 137-173
  • Word Chapter 3
    • Volume 1 Pages 259-273
  • Word Chapter 4
    • Volume 1 Pages 313-331
  • Word Supplemental Content
    • Page 24
 
Mon 11/21 to Fri 11/25   No Classes - Thanksgiving Break
Tue 11/29 Word & PowerPoint
  • Word Chapter 3
    • Add captions
  • Word Chapter 4
    • Create footnotes and endnotes
    • Insert a table of contents
    • Manage and insert citations
    • Insert a bibliography
    • Track changes
  • Word Chapter 6
    • Compare and combine versions of a document
  • Word Chapter 7

Recommended

  • Word Chapter 3
    • Volume 1 Pages 281-287
  • Word Chapter 4
    • Volume 1 Pages 332-339
  • Word Chapter 6
    • Volume 2 Pages 69-86
  • Homework #6
  • MyITLab Lesson H
    • PowerPoint Chapter 3
    • PowerPoint Chapter 6
    • PowerPoint Chapter 7
Wed 11/30   MyITLab Lesson H Due
Thu 12/01 Word & PowerPoint
  • PowerPoint Chapter 1
    • Use slide layouts and add content
    • Apply slide transitions
    • Apply animations
    • Add headers and footers
  • PowerPoint Chapter 2
    • Understand principles of slide design
    • Apply themes
  • PowerPoint Chapter 4
    • Insert pictures
    • Resize, move, align, and crop pictures
  • PowerPoint Supplemental Content
    • Design effective presentations

Recommended

  •  Homework #6
Fri 12/02 Word & PowerPoint Homework #6 Due
Tue 12/06 Word & PowerPoint
  • PowerPoint Chapter 1
    • Add speaker notes
    • Run a slideshow
  • PowerPoint Chapter 3
  • PowerPoint Chapter 4
    • Embed video
  • PowerPoint Chapter 6
  • PowerPoint Chapter 7
    • Hide slides
  • PowerPoint Supplemental Content
    • Embed Excel charts
    • Insert automatically updating dates and times

Recommended

 
Tue 12/06   MyITLab Bonus Projects #1, #2, and #3 Due
Tue 12/06   MyITLab Lessons Late Submission Deadline  
Thu 12/08 to Wed 12/14   Final Exam - see schedule for day and time

References

  1. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 1. Upper Saddle River, NJ: Pearson Education, 2013.
  2. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.
  3. B. M. Powell, Supplemental Content for Microsoft Office 2013. Morgantown, West Virginia: West Virginia University, 2016. Available: http://cs101.wvu.edu/materials/supplemental-content/.