Skip to main content

Section Schedule

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.

Lec Day Date Unit Content Readings & Resources [1]-[5] Assignments to Work On Reference ppt
 1 Wed 08/16 Excel & Data Analysis  

Required

  • Syllabus
  • First Day Presentation

Recommended

  •  MyITLab Lesson A
    • Module A1
    • Module A2
    • Module A3

day1 ppt

MyITLab Instruction

 

 2 Mon 08/21 Excel & Data Analysis  

Recommended

  •  MyITLab Lesson A
    • Module A4
    • Module A5
    • Module A6
 Excel intro
 3 Wed 08/23 Excel & Data Analysis  

Recommended

  • Excel Chapter 1
    • Pages E93-E98
  • Excel Chapter 4
    • Pages E275-E281
    • Pages E288-E290
    • Pages E302-E303

 

 Excel:Tables
  Wed 08/23   MyITLab Lesson A Due
 4 Mon 08/28 Excel & Data Analysis  

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
  •  MyITLab Lesson B
    • Module B1
    • Module B2
 Excel : Formatting
 5 Wed 08/30 Excel & Data Analysis  

Recommended

  • Excel Chapter 1
    • Pages E83-E87
  • Excel Chapter 2
    • Pages E154-E168
  • Excel Chapter 8
    • Pages E516-E517
  • Homework #1
  •  MyITLab Lesson B
    • Module B3
    • Module B4
 Excel : Formulas
  Mon 09/04   No Classes - Labor Day
 6 Wed 09/06 Excel & Data Analysis  

Recommended

  • Excel Chapter 2
    • Pages E174-E176
  • Excel Chapter 7
    • Pages E457-E462
  • Excel Chapter 9
    • Pages E574-E580
  • Homework #1
 Excel : Formula-2
  Wed 09/06   MyITLab Lesson B Due
  Fri 09/08 Excel & Data Analysis Homework #1 Due  
 7 Mon 09/11 Excel & Data Analysis  

Recommended

  • Homework #2
 Excel Charts
 8 Wed 09/13 Excel & Data Analysis  

Recommended

  • Homework #2
  • MyITLab Lesson C
    • Module C1
 Excel PivotTables
  Fri 09/15 Excel & Data Analysis Homework #2 Due  
 9 Mon 09/18 Excel & Data Analysis  

Recommended

  • Excel Chapter 6
    • Pages E418-E423
  • Excel Chapter 8
    • Pages E525-E530
  • Homework #3
  • MyITLab Lesson C
    • Module C2
 What If Analysis
 10 Wed 09/20 Excel & Data Analysis  

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 09/20   MyITLab Lesson C Due
  Fri 09/22 Excel & Data Analysis Homework #3 Due  
 11 Mon 09/25 Excel & Data Analysis  

Recommended

  • Excel Chapter 6
    • Pages E428-E434
  • MyITLab Lesson D
    • Module D1
 
  Wed 09/27 Excel & Data Analysis      

Exam 1 Study Guide

 12 Mon 10/02 Access  

Recommended

  • Access Chapter 1
    • Pages A71-A92
  • MyITLab Lesson D
    • Module D2
    • Module D3
    • Module D4
 Access Basics
 13 Wed 10/04 Access  

Recommended

  • Access Chapter 2
    • Pages A140-A149
    • Pages A160-A164
    Fields and Keys
  Wed 10/04   MyITLab Lesson D Due
 14 Mon 10/09 Access  

Recommended

  • Access Chapter 9
    • Pages A608-A616

 

 
 15 Wed 10/11 Access  

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
  •  MyITLab Lesson E
    • Module E1
    • Module E2
 
 16 Mon 10/16 Access  

Recommended

  • Access Chapter 2
    • Pages A173-A193
  • Access Chapter 10
    • Pages A660-A666
  •  MyITLab Lesson E
    • Module E3
    • Module E4
 Query1
 17 Wed 10/18 Access  

Recommended

  • Access Chapter 2
    • Pages A180-A181
  • Access Chapter 3
    • Pages A218-A237
   Query2
  Wed 10/18   MyITLab Lesson E Due
 18 Mon 10/23 Access  

Recommended

  • Homework #4
  • MyITLab Lesson F
    • Module F1
 Query 3
 19 Wed 10/25 Access  

Recommended

  • Homework #4
  • MyITLab Lesson F
    • Module F2
 
  Fri 10/27 Access Homework #4 Due    
 20 Mon 10/30 Access  

Recommended

  • Access Chapter 4
    • Pages A295-A308
  • Homework #5
  • MyITLab Lesson F
    • Module F3
 
 21 Wed 11/01 Access  

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
  • Homework #5
 
  Wed 11/01   MyITLab Lesson F Due
  Fri 11/03 Access Homework #5 Due  
 22 Mon 11/06 Access  

 Recommended

  •  MyITLab Lesson G
    • Module G1
 
  Wed 11/08 Access Exam #2       Exam #2 Study Guide
 23 Mon 11/13 Word & PowerPoint  

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
  •  MyITLab Lesson G
    • Module G2
 
 24 Wed 11/15 Word & PowerPoint  

Recommended

  • Word Chapter 1
    • Pages 42-50
  • Word Chapter 2
    • Pages 151-153
    • Pages 161-163
  • Word Chapter 3
    • Pages 208-216
  • Word Chapter 4
    • Page 283
   
  Wed 11/15          
  Mon 11/20 to Fri 11/24   No Classes - Thanksgiving Break
 25 Mon 11/27 Word & PowerPoint  

Recommended

  • Homework #6
 
 26 Wed 11/29 Word & PowerPoint  

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
 
  Fri 12/01 Word & PowerPoint Homework #6 Due
 27 Mon 12/04 Word & PowerPoint  

Recommended

   
  Tue 12/05   MyITLab Bonus Projects #1, #2, and #3 Due
  Tue 12/05   MyITLab Lessons Late Submission Deadline  
  Thu 12/07 to Wed 12/13   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/.