Skip to main content

Section Schedule for Online Sections

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

Homeworks, MyLab Lessons, and MyLab Bonus Projects are due at 11:59pm Eastern Time on the dates listed. Exams will be given on the dates shown. Participation Projects are not shown on the schedule below and are due on the date listed on your instuctor's Assignments page.

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.

Lec Day Date Unit Content Readings & Resources [1]-[5] Assignments to Work On
 1 Mon 01/08 Excel & Data Analysis
  • Course Introduction
    • Course policies
    • Course websites
    • Resources
  • Data Analysis Supplemental Content
    • Effective Internet searches

Required

  • Syllabus
  • First Day Presentation

Recommended

  •  MyLab Lesson A
    • Module A1
    • Module A2
    • Module A3
 2 Thu 01/11 Excel & Data Analysis
  • Data Analysis Supplemental Content
    • Download data and extract ZIP file contents
    • Answer analysis questions
  • Office 2016 Common Features
    • Create a new workbook
  • Excel Chapter 1
    • Adjust sheets
    • Enter data
  • Excel Chapter 10
    • Import XML and CSV data
    • Import from an Access database

Recommended

  • Data Analysis Supplemental Content
    • Pages 6-9
  • Office 2016 Common Features
    • Pages E5-E8
  • Excel Chapter 1
    • Pages E73-E78
    • Pages E121-E123
  • Excel Chapter 10
    • Pages E618-E623
    • Pages E640-E641
  •  MyLab Lesson A
    • Module A4
    • Module A5
    • Module A6
  Mon 01/15   No Classes - Martin Luther King Day
  Wed 01/17   MyLab Lesson A Due
 3 Thu 01/18 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 1
    • Pages E93-E98
  • Excel Chapter 4
    • Pages E275-E281
    • Pages E288-E290
    • Pages E302-E303

 

 4 Mon 01/22 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
    • Pages E110-E115
    • Pages E123-E130
  • Excel Chapter 4
    • Pages E265-E266
    • Pages E304-E311
  • Excel Chapter 12
    • Pages E741-E744
  •  MyLab Lesson B
    • Module B1
    • Module B2
 5 Thu 01/25 Excel & Data Analysis
  • Excel Chapter 1
    • Write formulas
    • Use AutoFill
  • Excel Chapter 2
    • Use statistical functions
    • Use cell references
  • Excel Chapter 4
    • Use structured cell references
  • Excel Chapter 8
    • Use the RANK.EQ function

Recommended

  • Excel Chapter 1
    • Pages E83-E87
  • Excel Chapter 2
    • Pages E154-E168
  • Excel Chapter 8
    • Pages E516-E517
  • MyLab Lesson B
    • Module B3
    • Module B4
 6 Mon 01/29 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
    • Pages E174-E176
  • Excel Chapter 7
    • Pages E457-E462
  • Excel Chapter 9
    • Pages E574-E580
  • Homework #1
  Wed 01/31   MyLab Lesson B Due
 7 Thu 02/01 Excel & Data Analysis
  • Excel Chapter 3
    • Create charts
    • Format charts
    • Insert a sparkline
  • Excel Supplemental Content
    • Use a trendline
    • Evaluate trendlines
    • Format chart axes

Recommended

  • Homework #1
  Fri 02/02 Excel & Data Analysis Homework #1 Due  
 8 Mon 02/05 Excel & Data Analysis
  • Excel Chapter 5
    • Create and use PivotTables
    • Add and format PivotCharts
  • Excel Supplemental Content
    • Group PivotTable data

Recommended

  • Homework #2
  • MyLab Lesson C
    • Module C1
 9 Thu 02/08 Excel & Data Analysis
  • Excel Chapter 6
    • Use Goal Seek
    • Use Scenario Manager
  • Excel Chapter 8
    • Perform correlation analysis

Recommended

  • Excel Chapter 6
    • Pages E418-E423
  • Excel Chapter 8
    • Pages E525-E530
  • Homework #2
  • MyLab Lesson C
    • Module C2
  Fri 02/09 Excel & Data Analysis Homework #2 Due  
 10 Mon 02/12 Excel & Data Analysis
  • Excel Chapter 2
    • Use the VLOOKUP function
    • Use the PMT function
  • Excel Chapter 7
    • Use the FV function
  • Excel Chapter 8
    • Use the SUMIF and COUNTIF functions
  • Excel Chapter 10
    • Use the CONCATENATE function

Recommended

  • Excel Chapter 2
    • Pages E177-E181
  • Excel Chapter 7
    • Pages E482-E483
  • Excel Chapter 8
    • Pages E512-E515
  • Excel Chapter 10
    • Page E631
  • Homework #3
  Wed 02/14   MyLab Lesson C Due
 11 Thu 02/15 Excel & Data Analysis
  • Excel Chapter 6
    • Use Solver
  • Excel Chapter 11

Recommended

  • Excel Chapter 6
    • Pages E428-E434
  • Homework #3
  • MyLab Lesson D
    • Module D1
  Fri 02/16 Excel & Data Analysis Homework #3 Due  
  Mon 02/19 to Wed 02/21 Excel & Data Analysis Exam #1
 12 Thu 02/22 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
    • Pages A71-A92
  • MyLab Lesson D
    • Module D2
    • Module D3
    • Module D4
 13 Mon 02/26 Access
  • Access Chapter 2
    • Determine appropriate field types
    • Select primary and composite keys
    • Identify appropriate table relationships

Recommended

  • Access Chapter 2
    • Pages A140-A149
    • Pages A160-A164
 
  Wed 02/28   MyLab Lesson D Due
 14 Thu 02/29 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
    • Pages A608-A616

 

 15 Mon 03/05 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
    • Pages A113-A119
  • Access Chapter 2
    • Pages A144-A149
    • Pages A160-A164
  • Access Chapter 5
    • Pages A341-A344
  • Access Chapter 8
    • Pages A546-A553
  • Access Supplemental Content
    • Page 18
    • Page 23
  •  MyLab Lesson E
    • Module E1
    • Module E2
 16 Thu 03/08 Access
  • Access Chapter 2
    • Create queries
    • Use criteria
    • Specify query sort order
  • Access Chapter 10
    • Create SQL queries

Recommended

  • Access Chapter 2
    • Pages A173-A193
  • Access Chapter 10
    • Pages A660-A666
  •  MyLab Lesson E
    • Module E3
    • Module E4
  Mon 03/12 to Fri 03/16   No Classes - Spring Break

 

 17 Mon 03/19 Access
  • Access Chapter 2
    • Use AND, OR, and NOT criteria
  • Access Chapter 3
    • Use Expression Builder
    • Create calculated fields
    • Specify field aliases
    • Format query fields

Recommended

  • Access Chapter 2
    • Pages A180-A181
  • Access Chapter 3
    • Pages A218-A237
  • Homework #4
  Wed 03/21   MyLab Lesson E Due
 18 Thu 03/22 Access
  • Access Chapter 3
    • Use aggregate functions and grouping
  • Access Chapter 5
    • Use conditional functions
  • Access Supplemental Content
    • Specify outer join relationships
    • Control if query fields are shown

Recommended

  • Homework #4
  • MyLab Lesson F
    • Module F1
  Fri 03/23 Access Homework #4 Due
 19 Mon 03/26 Access
  • Access Chapter 4
    • Create forms
    • Modify forms
  • Access Chapter 7

Recommended

  • Homework #5
  • MyLab Lesson F
    • Module F2
 20 Thu 03/29 Access
  • Access Chapter 4
    • Create reports
    • Modify reports
  • Access Chapter 7

Recommended

  • Access Chapter 4
    • Pages A295-A308
  • Access Chapter 7
    • Pages A463-A478
  • Homework #5
  • MyLab Lesson F
    • Module F3
  Fri 03/30 Access Homework #5 Due  
  Fri 03/30   No Classes - Friday Before Easter Recess
 21 Mon 04/02 Access
  • Access Chapter 2
    • Use wildcard criteria
    • Copy a query
  • Access Chapter 5
    • Create parameter queries
  • Access Chapter 6
    • Create update queries
    • Create delete queries
  • Access Supplemental Content
    • Display unique records

Recommended

  • Access Chapter 2
    • Page A179
    • Pages A182-A183
  • Access Chapter 5
    • Pages A352-A355
  • Access Chapter 6
    • Pages A392-A403
  • Access Supplemental Content
    • Pages 18-19

 

  Wed 04/04   MyLab Lesson F Due
 22 Thu 04/05 Access
  • Access Supplemental Content
    • Understand SQL SELECT queries
    • Write custom SQL queries

 Recommended

  •  MyLab Lesson G
    • Module G1
  Thu 04/05 to Mon 04/09 Access Exam #2
 23 Thu 04/12 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
  • Word Supplemental Content
    • Import RTF data
    • Use the Equation Editor

Recommended

  • Word Chapter 2
    • Pages 138-147
    • Pages 164-168
    • Pages 175-179
  • Word Chapter 5
    • Pages 376-380
  • Word Chapter 8
    • Pages 529-531
  • Word Supplemental Content
    • Page 28
    • Page 30
  •  MyLab Lesson G
    • Module G2
 24 Mon 04/16 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

Recommended

  • Word Chapter 1
    • Pages 91-94
  • Word Chapter 2
    • Pages 151-153
    • Pages 161-163
  • Word Chapter 3
    • Pages 208-216
  • Word Chapter 4
    • Page 283
 
  Wed 04/18   MyLab Lesson G Due    
 25 Thu 04/19 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
  • Word Supplemental content
    • Use cross-reference

Recommended

 

 26 Mon 04/23 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
    • Insert automatically updating dates and times
    • Embed Excel charts

Recommended

  • PowerPoint Chapter 1
    • Pages P87-P89
    • Pages P99-P103
  • PowerPoint Chapter 2
    • Pages P160-P167
  • PowerPoint Chapter 4
    • Pages P262-P279
  • PowerPoint Supplemental Content
    • Pages 32-35
  •  Homework #6
 27 Thu 04/26 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
    • Rehearse timings

Recommended

  •  Homework #6
  Thu 04/26 to Fri 04/27   Final Exam for online Section 7D1
  Fri 04/27 Word & PowerPoint Homework #6 Due
  Fri 04/27   MyLab Bonus Projects #1, #2, and #3 Due
  Fri 04/27   MyLab Lessons Late Submission Deadline

References

  1. M. A. Poatsy, K. Mulbery, J. Davidson, A. Rutledge, and R. Grauer, Exploring Microsoft Office Excel 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  2. M. A. Poatsy, E. Cameron, J. Williams, A. Rutledge, and R. Grauer, Exploring Microsoft Office Access 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  3. M. A. Poatsy, L. Hogan, L. K. Lau, A. Rutledge, and R. Grauer, Exploring Microsoft Office Word 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  4. M. A. Poatsy, C. Krebs, R. Lawson, A. Rutledge, and R. Grauer,Exploring Microsoft Office PowerPoint 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  5. B. M. Powell, Supplemental Content for Microsoft Office 2016. Morgantown, West Virginia: West Virginia University, 2017. Available: http://cs101.wvu.edu/materials/supplemental-content/.