Skip to main content

Section Schedule

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

Homeworks, MyLab Lessons, and MyLab Extra Credit 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 instructor's Assignments page. A list of due dates for MyLabs, Homeworks, and Exams (Participation Projects are not shown on the schedule) can be found on the main CS 101 Due Dates 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.

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

Required

  • Syllabus
  • First Day Presentation

Recommended

Mon 08/26 Excel & Data Analysis
  • Data Analysis Supplemental Content
    • Download data and extract ZIP file contents
    • Answer analysis questions
  • Exploring Microsoft 365: 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
  • Exploring Microsoft 365: Common Features
    • Pages 5-8
  • Excel Chapter 1
    • Pages 73-78
    • Pages 121-123
  • Excel Chapter 10
    • Pages 618-623
    • Pages 640-641
Wed 08/28   MyLab Lesson A Due
Thu 08/29 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 93-98
  • Excel Chapter 4
    • Pages 275-281
    • Pages 288-290
    • Pages 302-303

 

 

Thu 09/05 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 110-115
    • Pages 123-130
  • Excel Chapter 4
    • Pages 265-266
    • Pages 304-311
  • Excel Chapter 12
    • Pages 741-744
Mon 09/09 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 83-87
  • Excel Chapter 2
    • Pages 154-168
  • Excel Chapter 8
    • Pages 516-517
Wed 09/11   MyLab Lesson B Due
Thu 09/12 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 174-176
  • Excel Chapter 7
    • Pages 457-462
  • Excel Chapter 9
    • Pages 574-580

 

Mon 09/16 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

Thu 09/19 Excel & Data Analysis
  • Excel Chapter 5
    • Create and use PivotTables
    • Add and format PivotCharts
  • Excel Supplemental Content
    • Group PivotTable data

Recommended

Fri 09/20 Excel & Data Analysis Homework #1 Due
Mon 09/23 Excel & Data Analysis
  • Excel Chapter 6
    • Use Goal Seek
    • Use Scenario Manager
  • Excel Chapter 8
    • Perform correlation analysis

Recommended

  • Excel Chapter 6
    • Pages 418-423
  • Excel Chapter 8
    • Pages 525-530
Wed 09/25   MyLab Lesson C Due
Thu 09/26 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 177-181
  • Excel Chapter 7
    • Pages 482-483
  • Excel Chapter 8
    • Pages 512-515
  • Excel Chapter 10
    • Page 631
  • Homework #2
Fri 09/27 Excel & Data Analysis Homework #2 Due  
Mon 09/30 Excel & Data Analysis
  • Excel Chapter 6
    • Use Solver
  • Excel Chapter 11

Recommended

  • Excel Chapter 6
    • Pages 428-434
Thu 10/03 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 71-92
Mon 10/7 to Tue 10/8 Excel & Data Analysis Exam #1
Wed 10/09   MyLab Lesson D Due
Thu 10/10 Access
  • Access Chapter 2
    • Determine appropriate field types
    • Select primary and composite keys
    • Identify appropriate table relationships

Recommended

  • Access Chapter 2
    • Pages 140-149
    • Pages 160-164

 

Mon 10/14 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 608-616
Thu 10/17 Access
  • Access Chapter 2
    • Plan and normalize databases
  • Access Chapter 9
    • Normalize databases

Recommended

  • Access Chapter 9
    • Pages 608-616

 

Mon 10/21 Access
  • Access Chapter 2
    • Plan and normalize databases
  • Access Chapter 9
    • Normalize databases
 
Wed 10/23   MyLab Lesson E Due
Thu 10/24 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 113-119
  • Access Chapter 2
    • Pages 144-149
    • Pages 160-164
  • Access Chapter 5
    • Pages 341-344
  • Access Chapter 8
    • Pages 546-553
  • Access Supplemental Content
    • Page 18
    • Page 23
 
Mon 10/28 Access
  • Access Chapter 2
    • Create queries
    • Use criteria
    • Specify query sort order
  • Access Chapter 10
    • Create SQL queries

Recommended

  • Access Chapter 2
    • Pages 173-193
  • Access Chapter 10
    • Pages 660-666
Thu 10/31 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 180-181
  • Access Chapter 3
    • Pages 218-237
Mon 11/04 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

Wed 11/06   MyLab Lesson F Due
Thu 11/07 Access
  • Access Chapter 4
    • Create forms
    • Modify forms
    • Create reports
    • Modify reports
  • Access Chapter 7

Recommended

  • Homework #3
Fri 11/08 Access Homework #3 Due
Mon 11/11 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 179
    • Pages 182-183
  • Access Chapter 5
    • Pages 352-355
  • Access Chapter 6
    • Pages 392-403
  • Access Supplemental Content
    • Pages 18-19

 

Thu 11/14 Access
  • Access Supplemental Content
    • Understand SQL SELECT queries
    • Write custom SQL queries

 Recommended

Mon 11/18 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
Wed 11/20   MyLab Lesson G Due    
Thu 11/21 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
  • Homework #4
Fri 11/22 Access Homework #4 Due
Mon 12/02 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

 

Thu 12/05 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 87-89
    • Pages 99-103
  • PowerPoint Chapter 2
    • Pages 160-167
  • PowerPoint Chapter 4
    • Pages 262-279
  • PowerPoint Supplemental Content
    • Pages 32-35
  • Homework #5
Mon 12/09 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 #5
Thu 12/12   Exam #2 Review

 

  • Homework #5
Thu 12/12   MyLab Extra Credit Projects #1, #2, #3, and #4 Due
Thu 12/12   MyLab Lessons Late Submission Deadline  
Fri 12/13 Word & PowerPoint Homework #5 Due
Mon 12/16 to Wed 12/18   Exam #2

References

  1. M. A. Poatsy, J. Davidson, and K. Mulbery, Exploring Microsoft 365: Excel 2021. Upper Saddle River, NJ: Pearson, 2022.
  2. M. A. Poatsy, J. Williams, and A. Rutledge, Exploring Microsoft 365: Access 2021. Upper Saddle River, NJ: Pearson, 2022.
  3. M. A. Poatsy and L. Hogan, Exploring Microsoft 365: Word 2021. Upper Saddle River, NJ: Pearson, 2022.
  4. M. A. Poatsy and D. Kosharek, Exploring Microsoft 365: PowerPoint 2021. Upper Saddle River, NJ: Pearson, 2022.
  5. B. M. Powell, Supplemental Content for Microsoft 365. Morgantown, West Virginia: West Virginia University, 2023. Available: http://cs101.wvu.edu/materials/supplemental-content/.