Skip to main content

Section Schedule for TR 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
Tues 01/12 Excel & Data Analysis
  • Course Introduction
    • Course policies
    • Course websites
    • Resources

Required

  • Syllabus
  • First Day Presentation

Recommended

 
Thurs 01/14 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
Thurs 01/21 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
Tues 01/26 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
Thurs 01/28 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
Tues 02/02 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
Thurs 02/04 Excel & Data Analysis

Recommended

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

Recommended

  • Homework #2
  • MyITLab Lesson B
    • Excel Chapter 5
    • Excel Chapter 9
Thurs 02/11 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
Tues 02/16 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
Thurs 02/18 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
Tues 02/23 Excel & Data Analysis Exam #1 for Sections 51,53, 55, 56, 57, 58, 60, 61 and 63
Thurs 02/25 Access

Recommended

  • Access Chapter 2
    • Volume 1 Pages 675-680
  • Access Chapter 9
    • Volume 2 Pages 791-802
  • MyITLab Lesson C
    • Access Chapter 2
Fri 02/26 Excel & Data Analysis MyITLab Lesson B Due  
Tues 03/01 Access

Recommended

  • Access Chapter 1
    • Volume 1 Pages 653-660
  • Access Chapter 2
    • Volume 1 Pages 680-690
  • MyITLab Lesson C
    • Access Chapter 1
Thurs 03/03 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
Tues 03/08 Access

Recommended

  • Access Chapter 2
    • Volume 1 Pages 675-726
 
Thurs 03/10 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
Tues 03/15 Access

Recommended

  • Access Chapter 3
    • Volume 1 Pages 767-776
 
Thurs 03/17 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
Tues 03/22   No Class - Spring Recess    
Thurs 03/24   No Class - Spring Recess    
Tues 03/29 Access

Recommended

  • Access Chapter 4
    • Volume 1 Pages 812-829
  • Access Chapter 5
    • Volume 2 Pages 581-596
  • Homework #4
Thurs 03/31 Access  
  • Homework #4
Fri 04/01 Access Homework #4 Due  
Tues 04/05 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
Thurs 04/07 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
Tues 04/12 Access Exam #2 for Sections 51, 53, 55, 56, 57, 58, 60, 61 and 63  
Thurs 04/14 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
Fri 04/15 Access MyITLab Lesson C Due    
Tues 04/19 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
Thurs 04/21 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 MyITLab Bonus Projects #1, #2, and #3 Due    
Tues 04/26 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
Thurs 04/28 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