Skip to main content

Section Schedule for MW Sections

The below schedule is an approximation of the most important subject material covered each day and 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 and Resources Assignments to Work On
Mon 01/11 Excel & Data Analysis
  • Course Introduction
    • Course policies
    • Course websites
    • Resources

Required

  • Syllabus
  • First Day Presentation

Recommended

 
Wed 01/13 Excel & Data Analysis

Recommended

  • Excel Chapter 1
    • Volume 1 Pages 373-383
    • Volume 1 Pages 394-405
  • Excel Chapter 10
    • Volume 2 Pages 441-469
  • Data Analysis: Online Scavenger Hunt Participation Project
  • MyITLab Lesson A
    • Excel Chapter 1
Mon 01/18   No Class - Martin Luther King Day
Wed 01/20 Excel & Data Analysis
  • Excel Chapter 1
    • Write basic formulas
    • Select cells
    • Use AutoFill
    • Apply cell formatting

Recommended

  • Excel Chapter 1
    • Volume 1 Pages 384-393
    • Volume 1 Pages 406-431
  • MyITLab Lesson A
    • Excel Chapter 10
Mon 01/25 Excel & Data Analysis
  • Excel Chapter 2
    • Understand relative, absolute, and mixed cell references
    • Use basic math and statistical functions

Recommended

  • Excel Chapter 2
    • Volume 1 Pages 447-470
  • MyITLab Lesson A
    • Excel Chapter 2

 

Wed 01/27 Excel & Data Analysis

Recommended

  • Excel Chapter 2
    • Volume 1 Pages 471-487
  • Excel Chapter 12
    • Volume 2 Pages 535-540
  •  MyITLab Lesson A
    • Excel Chapter 12
Fri 01/29 Excel & Data Analysis MyITLab Lesson A Due
Mon 02/01 Excel & Data Analysis
  • Excel Chapter 4
    • Freeze rows and columns
    • Create and format tables
    • Use table total rows
    • Apply conditional formatting

Recommended

  • Excel Chapter 4
    • Volume 1 Pages 555-604
  • Homework #1
  • MyITLab Lesson B
    • Excel Chapter 4
Wed 02/03 Excel & Data Analysis

Recommended

  • Homework #1
  • MyITLab Lesson B
    • Excel Chapter 3
    • Excel Chapter 8
Fri 02/05 Excel & Data Analysis Homework #1 Due
Mon 02/08 Excel & Data Analysis

Recommended

  • Homework #2
  • MyITLab Lesson B
    • Excel Chapter 5
    • Excel Chapter 9
Wed 02/10 Excel & Data Analysis

Recommended

  • Excel Chapter 6
    • Volume 2 Pages 277-296
  • Homework #2
  • MyITLab Lesson B
    • Excel Chapter 6
Fri 02/12 Excel & Data Analysis Homework #2 Due
Mon 02/15 Excel & Data Analysis

Recommended

  • Excel Chapter 7
    • Volume 2 Pages 309-338
  • Excel Chapter 8
    • Volume 2 Pages 354-356
  • Excel Chapter 11
    • Volume 2 Pages 481-513
  • Homework #3
  • MyITLab Lesson B
    • Excel Chapter 7
    • Excel Chapter 11
Wed 02/17 Access
  • Access Chapter 1
    • Identify real-world uses
    • Selecting a database or spreadsheet
    • Explore Microsoft Access interface
    • Recognize object types and uses
    • Create, edit, and delete records
    • Use Compact and Repair Database tool
    • Use sort and filter tools in Datasheet View

Recommended

  • Access Chapter 1
    • Volume 1 Pages 617-648
  • Homework #3
  • MyITLab Lesson C
    • Access Chapter 1
Fri 02/19 Excel & Data Analysis Homework #3 Due
Mon 02/22 Access

For Sections 1, 5, 6, 9, 10, 13, 14, 17, and 21:

Recommended

  • Access Chapter 2
    • Volume 1 Pages 675-680
  • Access Chapter 9
    • Volume 2 Pages 791-802
  •  MyITLab Lesson C
    • Access Chapter 2
Mon 02/22 Excel & Data Analysis Exam #1 for Sections 3, 4, 7, 8, 11, 12, 15, and 19
Wed 02/24 Access

For Sections 3, 4, 7, 8, 11, 12, 15, and 19:

Recommended

  • Access Chapter 2
    • Volume 1 Pages 675-680
  • Access Chapter 9
    • Volume 2 Pages 791-802
  • MyITLab Lesson C
    • Access Chapter 2
Wed 02/24 Excel & Data Analysis Exam #1 for Sections 1, 5, 6, 9, 10, 13, 14, 17, and 21
Fri 02/26 Excel & Data Analysis MyITLab Lesson B Due  
Mon 02/29 Access

Recommended

  • Access Chapter 1
    • Volume 1 Pages 653-660
  • Access Chapter 2
    • Volume 1 Pages 680-690
  • MyITLab Lesson C
    • Access Chapter 1
Wed 03/02 Access

Recommended

  • Access Chapter 2
    • Volume 1 Pages 695-698
  • Access Chapter 5
    • Volume 2 Pages 587-591
  • Access Chapter 8
    • Volume 2 Pages 756-767
  • Access Supplemental Content
    • Page 8
  • MyITLab Lesson C
    • Access Chapter 5
    • Access Chapter 8
Mon 03/07 Access

Recommended

  • Access Chapter 2
    • Volume 1 Pages 675-726

 

Wed 03/09 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 C
    • Access Chapter 3
Mon 03/14 Access

Recommended

  • Access Chapter 3
    • Volume 1 Pages 767-776
 
Wed 03/16 Access

Recommended

  • Access Chapter 4
    • Volume 1 Pages 791-811
  • Access Chapter 5
    • Volume 2 Pages 597-615
  • Access Chapter 10
    • Volume 2 Pages 865-874
  • Access Supplemental Content
    • Pages 8-9
  • MyITLab Lesson C
    • Chapter 4
    • Chapter 10
Mon 03/21   No Class - Spring Recess    
Wed 03/23   No Class - Spring Recess    
Mon 03/28 Access

Recommended

  • Access Chapter 4
    • Volume 1 Pages 812-829
  • Access Chapter 5
    • Volume 2 Pages 581-596
  • Homework #4
Wed 03/30 Access  
  • Homework #4
Fri 04/01 Access Homework #4 Due  
Mon 04/04 Access
  • Access Chapter 6
    • Create update queries
    • Create delete queries
    • Create queries to find duplicate records
    • Create queries to find unmatched records

Recommended

  • Access Chapter 6
    • Volume 2 Pages 629-662
  • Homework #5
  • MyITLab Lesson C
    • Access Chapter 6
Wed 04/06 Word & PowerPoint

Recommended

  • Word Chapter 2
    • Volume 1 Pages 197-244
  • Word Chapter 5
    • Volume 2 Pages 34-41
  • Word Chapter 8
    • Volume 2 Pages 174-183
  • Word Supplemental Content
    • Page 12
  • Homework #5
  • MyITLab Lesson D
    • Word Chapter 2
    • Word Chapter 5
    • Word Chapter 8
Fri 04/08 Access Homework #5 Due
Mon 04/11 Word & PowerPoint

For Sections 1, 5, 6, 9, 10, 13, 14, 17, and 21:

Recommended

  • Word Chapter 1
    • Volume 1 Pages 137-173
  • Word Chapter 2
    • Volume 1 Pages 217-230
  • Word Chapter 3
    • Volume 1 Pages 259-273
  •  MyITLab Lesson D
    • Word Chapter 1
    • Word Chapter 3
Mon 04/11 Access Exam #2 for Sections 3, 4, 7, 8, 11, 12, 15, and 19  
Wed 04/13 Word & PowerPoint

For Sections 3, 4, 7, 8, 11, 12, 15, and 19:

Recommended

  • Word Chapter 1
    • Volume 1 Pages 137-173
  • Word Chapter 2
    • Volume 1 Pages 217-230
  • Word Chapter 3
    • Volume 1 Pages 259-273

 

  • MyITLab Lesson D
    • Word Chapter 1
    • Word Chapter 3
Wed 04/13 Access Exam #2 for Sections 1, 5, 6, 9, 10, 13, 14, 17, and 21
Fri 04/15 Access MyITLab Lesson C Due    
Mon 04/18 Word & PowerPoint

Recommended

  • Word Chapter 3
    • Volume 1 Pages 281-287
  • Word Chapter 4
    • Volume 1 Pages 313-331
  • Word Chapter 6
    • Volume 2 Pages 69-86
  • MyITLab Lesson D
    • Word Chapter 4
    • Word Chapter 6
    • Word Chapter 7
Wed 04/20 Word & PowerPoint

Recommended

  • MyITLab Lesson E
    • PowerPoint Chapter 1
    • PowerPoint Chapter 2
Fri 04/22 Word & PowerPoint MyITLab Lesson D Due  
Mon 04/25 Word & PowerPoint

Recommended

  • PowerPoint Chapter 3
    • Volume 1 Pages 977-993
  • PowerPoint Chapter 4
    • Volume 1 Pages 1007-1040
  • PowerPoint Chapter 7
    • Volume 2 Pages 1031-1035
  • PowerPoint Supplemental Content
    • Pages 18-20
  • Homework #6
  • MyITLab Lesson E
    • PowerPoint Chapter 3
    • PowerPoint Chapter 4
    • PowerPoint Chapter 6
    • PowerPoint Chapter 7
Mon 04/25 Word & PowerPoint MyITLab Bonus Projects #1, #2, and #3 Due
Wed 04/27 Word & PowerPoint
  • Semester Review
 
  • Homework #6
Fri 04/29 Word & PowerPoint MyITLab Lesson E Due  
Fri 04/29 Word & PowerPoint Homework #6 Due
Fri 04/29   MyITLab Lessons Late Submission Deadline  
Mon 05/02 to Fri 05/06   Final Exam - see schedule for day and time