Skip to main content

Section Schedule for Second-Half 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 06/28 Excel & Data Analysis

Required

Recommended

  • Data Analysis: Online Scavenger Hunt Participation Project
Wed 06/29 Excel & Data Analysis
  • Excel Chapter 1
    • Enter and modify cell data
    • Insert, delete, and rename worksheets
    • Adjust rows and columns
    • Write basic formulas
    • Select cells
    • Use AutoFill
  • Excel Chapter 10
    • Import data

Recommended

  • Excel Chapter 1
    • Volume 1 Pages 373-431
  • Excel Chapter 10
    • Volume 2 Pages 441-469
  • MyITLab Lesson A
    • Excel Chapter 1
Thu 06/30 Excel & Data Analysis
  • Excel Chapter 1
    • Apply cell formatting
  • Excel Chapter 2
    • Understand relative, absolute, and mixed cell references
    • Use basic math and statistical functions
    • Use logical functions
    • Use financial functions
  • Excel Chapter 9
    • Create 3-D formulas

Recommended

  • Excel Chapter 1
    • Volume 1 Pages 406-431
  • Excel Chapter 2
    • Volume 1 Pages 447-487
  • Excel Chapter 9
    • Volume 2 Pages 409-415
  • MyITLab Lesson A
    • Excel Chapter 2
    • Excel Chapter 9
    • Excel Chapter 10
Tue 07/05 Excel & Data Analysis

Recommended

  • Excel Chapter 3
    • Volume 1 Pages 505-543
  • Excel Chapter 4
    • Volume 1 Pages 555-604
  • Homework #1
  • MyITLab Lesson A
    • Excel Chapter 12
  • MyITLab Lesson B
    • Excel Chapter 3
    • Excel Chapter 4
Wed 07/06 Excel & Data Analysis

Recommended

  • Homework #1
  • MyITLab Lesson B
    • Excel Chapter 5
    • Excel Chapter 8
    • Excel Chapter 9
Wed 07/06 Excel & Data Analysis MyITLab Lesson A Due    
Wed 07/06 Excel & Data Analysis Homework #1 Due    
Thu 07/07 Excel & Data Analysis

Recommended

  • Excel Chapter 6
    • Volume 2 Pages 277-296
  • 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 #2
  • MyITLab Lesson B
    • Excel Chapter 6
    • Excel Chapter 7
    • Excel Chapter 11
Fri 07/08 Excel & Data Analysis Homework #2 Due
Tue 07/12 Excel & Data Analysis Exam #1    
Wed 07/13 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
Wed 07/13 Excel & Data Analysis MyITLab Lesson B Due    
Wed 07/13 Excel & Data Analysis Homework #3 Due    
Thu 07/14 Access

Recommended

  • Access Chapter 1
    • Volume 1 Pages 653-660
  • Access Chapter 2
    • Volume 1 Pages 675-690
  • Access Chapter 9
    • Volume 2 Pages 791-802
  • MyITLab Lesson C
    • Access Chapter 2
Tue 07/19 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
Wed 07/20 Access
  • Access Chapter 2
    • Create queries
    • Use criteria
    • Specify query sort order
  • Access Chapter 3
    • Use Expression Builder
    • Create calculated fields
    • Specify field aliases
    • Format query fields

Recommended

  • Access Chapter 2
    • Volume 1 Pages 675-726
  • Access Chapter 3
    • Volume 1 Pages 745-766
  • Homework #4
  • MyITLab Lesson C
    • Access Chapter 3
Thu 07/21 Access

Recommended

  • Access Chapter 3
    • Volume 1 Pages 767-776
  • 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
  • Homework #4
  • MyITLab Lesson C
    • Chapter 4
    • Chapter 10
Fri 07/22 Access Homework #4 Due    
Tue 07/26 Access

Recommended

  • Access Chapter 4
    • Volume 1 Pages 791-829
  • Access Chapter 5
    • Volume 2 Pages 581-596
  • Access Chapter 6
    • Volume 2 Pages 629-662
  • Homework #5
  • MyITLab Lesson C
    • Access Chapter 6
Wed 07/27 Access Exam #2    
Thu 07/28 Word & PowerPoint

Recommended

  • Word Chapter 1
    • Volume 1 Pages 137-173
  • 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 1
    • Word Chapter 2
    • Word Chapter 5
    • Word Chapter 8
Thu 07/28 Access Homework #5 Due
Thu 07/28 Access MyITLab Lesson C Due
Tue 08/02 Word & PowerPoint

Recommended

  • Word Chapter 2
    • Volume 1 Pages 217-230
  • Word Chapter 3
    • Volume 1 Pages 259-273
    • 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 3
    • Word Chapter 4
    • Word Chapter 6
    • Word Chapter 7
Tue 08/02 Word & PowerPoint MyITLab Lesson D Due    
Wed 08/03 Word & PowerPoint

Recommended

  • PowerPoint Chapter 1
    • Volume 1 Pages 843-883
  • PowerPoint Chapter 2
    • Volume 2 Pages 920-930
  • 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 16-20
  • Homework #6
  • MyITLab Lesson E
    • PowerPoint Chapter 1
    • PowerPoint Chapter 2
    • PowerPoint Chapter 3
    • PowerPoint Chapter 4
    • PowerPoint Chapter 6
    • PowerPoint Chapter 7
Thu 08/04   Final Exam    
Fri 08/05 Word & PowerPoint MyITLab Bonus Projects #1, #2, and #3 Due    
Fri 08/05 Word & PowerPoint MyITLab Lesson E Due
Fri 08/05 Word & PowerPoint Homework #6 Due (No Late Submissions)
Fri 08/05   MyITLab Lessons Late Submission Deadline