Skip to main content

Section Schedule for Second-Half Online 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.

Lec Day Date Unit Content Readings & Resources [1]-[5] Assignments to Work On
1/2 Mon 06/26 Excel & Data Analysis
  • Course Introduction
    • Course policies
    • Course websites
    • Resources
  • Data Analysis Supplemental Content
    • Effective Internet searches
    • Download data and extract ZIP file contents
    • Answer analysis questions
  • Excel Chapter 1
    • Create a new workbook
    • Adjust sheets
    • Enter data
  • Excel Chapter 10
    • Import XML and CSV data
    • Import from an Access database

Required

  • Syllabus
  • First Day Presentation

Recommended

  •  MyITLab Lesson A
    • Module A1
    • Module A2
    • Module A3
3/4 Wed 06/28 Excel & Data Analysis
  • Excel Chapter 1
    • Insert rows and/or columns
    • Format cells
    • Specify page orientation and scaling
  • Excel Chapter 4
    • Create and format tables
    • Use the table total row
    • Sort data
    • Freeze panes
    • Apply conditional formatting
    • Apply color scale formatting
  • Excel Chapter 12
    • Apply cell styles

Recommended

  • Excel Chapter 1
    • Pages E93-E98
    • Pages E110-E115
    • Pages E123-E130
  • Excel Chapter 4
    • Pages E265-E266
    • Pages E275-E281
    • Pages E288-E290
    • Pages E302-E311
  • Excel Chapter 12
    • Pages E741-E744
  • Homework #1
  • MyITLab Lesson A
    • Module A4
    • Module A5
    • Module A6
5 Fri 06/30 Excel & Data Analysis
  • Excel Chapter 1
    • Write formulas
    • Use AutoFill
  • Excel Chapter 2
    • Use statistical functions
    • Use cell references
  • Excel Chapter 8
    • Use the RANK.EQ function

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 B1
    • Module B2
    • Module B3
    • Module B4
  Fri 06/30  

MyITLab Lesson A Due

  Tue 07/04  

No Classes - Independence Day

6 Wed 07/05 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 E174-E176
  • Excel Chapter 7
    • Pages E457-E462
  • Excel Chapter 9
    • Pages E574-E580
  • Homework #2
  Wed 07/05 Excel & Data Analysis

Homework #1 Due

  Wed 07/05  

MyITLab Lesson B Due

7/8 Fri 07/07 Excel & Data Analysis
  • Excel Chapter 3
    • Create charts
    • Format charts
    • Insert a sparkline
  • Excel Chapter 5
    • Create and use PivotTables
    • Add and format PivotCharts
  • Excel Supplemental Content
    • Use a trendline
    • Evaluate trendlines
    • Format chart axes
    • Group PivotTable data

Recommended

  • Homework #2
  • Homework #3
  • MyITLab Lesson C
    • Module C1
  Fri 07/07 Excel & Data Analysis Homework #2 Due
9 Mon 07/10 Excel & Data Analysis
  • Excel Chapter 6
    • Use Goal Seek
    • Use Scenario Manager
  • Excel Chapter 8
    • Perform correlation analysis

Recommended

  • Excel Chapter 6
    • Pages E418-E423
  • Excel Chapter 8
    • Pages E525-E530
  • Homework #3
  • MyITLab Lesson C
    • Module C2
  • MyITLab Lesson D
    • Module D1
  Tue 07/11 Excel & Data Analysis Homework #3 Due
  Wed 07/12 Excel & Data Analysis Exam #1  
  Wed 07/12   MyITLab Lesson C Due
12/13 Fri 07/14 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
  • Access Chapter 2
    • Determine appropriate field types
    • Select primary and composite keys
    • Identify appropriate table relationships

Recommended

  • Access Chapter 1
    • Pages A71-A92
  • Access Chapter 2
    • Pages A140-A149
    • Pages A160-A164
  •  MyITLab Lesson D
    • Module D2
    • Module D3
    • Module D4
14/15 Mon 07/17 Access
  • Access Chapter 1
    • Selecting a database or spreadsheet
    • Create and save databases
  • Access Chapter 2
    • Plan and normalize databases
    • 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 Chapter 9
    • Normalize databases
  • Access Supplemental Content
    • Import XML data
    • Answering analysis questions

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 Chapter 9
    • Pages A608-A616
  • Access Supplemental Content
    • Page 18
    • Page 23
  •  MyITLab Lesson E
    • Module E1
    • Module E2
  Mon 07/17   MyTLab Lesson D Due
16 Wed 07/19 Access
  • Access Chapter 2
    • Create queries
    • Use criteria
    • Specify query sort order
  • Access Chapter 10
    • Create SQL queries

Recommended

  • Access Chapter 2
    • Pages A173-A193
  • Access Chapter 10
    • Pages A660-A666
  •  MyITLab Lesson E
    • Module E3
17 Fri 07/21 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 A180-A181
  • Access Chapter 3
    • Pages A218-A237
  •  MyITLab Lesson E
    • Module E4
  • MyITLab Lesson F
    • Module F1
  Fri 07/21   MyITLab Lesson E Due
18 Mon 07/24 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

  • Homework #4
  • MyITLab Lesson F
    • Module F2
    • Module F3
  Tue 07/25   MyITLab Lesson F Due
19/20 Wed 07/26 Access
  • Access Chapter 4
    • Create forms
    • Modify forms
    • Create reports
    • Modify reports

Recommended

  • Homework #4
  • Homework #5
  • MyITLab Lesson G
    • Module G1
  Wed 07/26 Access Homework #4 Due
23/24 /25 Fri 07/28 Word & PowerPoint
  • Word Chapter 1
    • Create headers and footers
    • Adjust margins and orientation
  • Word Chapter 2
    • Apply paragraph formatting
    • Create, modify, and use formatting styles
    • Insert and format pictures
    • Adjust paragraph spacing, indentation, and alignment
    • Create section breaks
    • Use bulleted and numbered lists
  • Word Chapter 3
    • Create tables
    • Add captions
  • Word Chapter 4
    • Insert a cover page
    • Create footnotes and endnotes
    • Insert a table of contents
    • Manage and insert citations
    • Insert a bibliography
    • Track changes
  • Word Chapter 5
    • Insert Excel charts
  • Word Chapter 6
    • Compare and combine versions of a document
  • Word Chapter 7
  • Word Chapter 8
    • Insert hyperlinks
  • Word Supplemental Content
    • Import RTF data
    • Use the Equation Editor
    • Use cross-reference

Recommended

  • Word Chapter 1
    • Pages 42-50
  • Word Chapter 2
    • Pages 138-147
    • Pages 151-153
    • Pages 161-168
    • Pages 175-179
  • Word Chapter 3
    • Pages 208-216
    • Pages 233-235
  • Word Chapter 4
    • Pages 272-297
  • Word Chapter 5
    • Pages 376-380
  • Word Chapter 6
    • Pages 419-422
  • Word Chapter 8
    • Pages 529-531
  • Word Supplemental Content
    • Pages 28-30
  • Homework #5
  • MyITLab Lesson G
    • Module G2
  Mon 07/31 Access Homework #5 Due  
  Tue 08/01 Access Exam #2
  Tue 08/01   MyITLab Lesson G Due    
 26/27 Wed 08/02 Word & PowerPoint
  • PowerPoint Chapter 1
    • Use slide layouts and add content
    • Apply slide transitions
    • Apply animations
    • Add headers and footers
    • Add speaker notes
    • Run a slideshow
  • PowerPoint Chapter 2
    • Understand principles of slide design
    • Apply themes
  • PowerPoint Chapter 3
  • PowerPoint Chapter 4
    • Insert pictures
    • Resize, move, align, and crop pictures
    • Embed video
  • PowerPoint Chapter 6
  • PowerPoint Chapter 7
    • Hide slides
  • PowerPoint Supplemental Content
    • Design effective presentations
    • Insert automatically updating dates and times
    • Embed Excel charts
    • Rehearse timings

Recommended

  • PowerPoint Chapter 1
    • Pages P70-P79
    • Pages P87-P89
    • Pages P99-P103
  • PowerPoint Chapter 2
    • Pages P160-P167
  • PowerPoint Chapter 4
    • Pages P262-P279
    • Pages P289-P298
  • PowerPoint Chapter 7
    • Pages P481-P482
  • Homework #6
  Thu 08/03   Final Exam  
  Fri 08/04 Word & PowerPoint Homework #6 Due (No Late Submissions)
  Fri 08/04   MyITLab Bonus Projects #1, #2, and #3 Due  
  Fri 08/04   MyITLab Lessons Late Submission Deadline  

References

  1. M. A. Poatsy, K. Mulbery, J. Davidson, A. Rutledge, and R. Grauer, Exploring Microsoft Office Excel 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  2. M. A. Poatsy, E. Cameron, J. Williams, A. Rutledge, and R. Grauer, Exploring Microsoft Office Access 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  3. M. A. Poatsy, L. Hogan, L. K. Lau, A. Rutledge, and R. Grauer, Exploring Microsoft Office Word 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  4. M. A. Poatsy, C. Krebs, R. Lawson, A. Rutledge, and R. Grauer, Exploring Microsoft Office PowerPoint 2016 Comprehensive, 1st ed. Upper Saddle River, NJ: Pearson Education, 2016.
  5. B. M. Powell, Supplemental Content for Microsoft Office 2016. Morgantown, West Virginia: West Virginia University, 2017. Available: http://cs101.wvu.edu/materials/supplemental-content/.