Section Schedule for First-Half Sections | Computer Science 101

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.

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	Mon 05/13	Excel & Data Analysis	Course Introduction Course policies Course websites Resources Data Analysis Supplemental Content Effective Internet searches	Required Syllabus First Day Presentation Recommended Data Analysis Supplemental Content Pages 2-3	MyLab Lesson A Module A1 Module A2 Module A3
2	Tue 05/14	Excel & Data Analysis	Data Analysis Supplemental Content Download data and extract ZIP file contents Answer analysis questions 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 Office 2016 Common Features Pages 5-8 Excel Chapter 1 Pages 73-78 Pages 121-123 Excel Chapter 10 Pages 618-623 Pages 640-641	MyLab Lesson A Module A4 Module A5 Module A6
3	Wed 05/15	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
4	Thu 05/16	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
5	Fri 05/17	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	MyLab Lesson B Module B1 Module B2
	Sun 05/19		MyLab Lesson A Due
6	Mon 05/20	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	MyLab Lesson B Module B3 Module B4
7	Tue 05/21	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 Excel Chapter 3 Pages 200-245 Excel Supplemental Content Pages 12-14
	Wed 05/22		MyLab Lesson B Due
8	Wed 05/22	Excel & Data Analysis	Excel Chapter 5 Create and use PivotTables Add and format PivotCharts Excel Supplemental Content Group PivotTable data	Recommended Excel Chapter 5 Pages 339-349 Pages 372-373 Excel Supplemental Content Pages 15-16	Homework #1 MyLab Lesson C Module C1
	Thu 05/23	Excel & Data Analysis	Homework #1 Due
9	Thu 05/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	Homework #1 MyLab Lesson C Module C2
10	Fri 10/24	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 MyLab Lesson C Module C3
	Sun 05/26		MyLab Lesson C Due
11	Mon 05/27	Excel & Data Analysis	Excel Chapter 6 Use Solver Excel Chapter 11	Recommended Excel Chapter 6 Pages 428-434	Homework #2
	Tue 05/28	Excel & Data Analysis	Homework #2 Due
12	Tue 05/28	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	MyLab Lesson D Module D1
	Tue 05/28 to Wed 05/29	Excel & Data Analysis	Exam #1
13	Thu 05/30	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	MyLab Lesson D Module D2 Module D3
	Fri 05/31		MyLab Lesson D Due
14	Fri 05/31	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
15	Mon 06/03	Access	Access Chapter 2 Plan and normalize databases Access Chapter 9 Normalize databases	Recommended Access Chapter 9 Pages 608-616	MyLab Lesson E Module E1 Module E2
16	Tue 06/04	Access	Access Chapter 2 Plan and normalize databases Access Chapter 9 Normalize databases		MyLab Lesson E Module E3
17	Wed 06/05	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	MyLab Lesson E Module E4
	Thu 06/06		MyLab Lesson E Due
18	Thu 06/06	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
19	Fri 06/07	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	MyLab Lesson F Module F1 Module F2
20	Mon 06/10	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 Access Chapter 3 Pages 243-249 Access Chapter 5 Pages 355-369 Access Supplemental Content Pages 19-20 Pages 23-24	Homework #3 MyLab Lesson F Module F3
21	Tue 06/11	Access	Access Chapter 4 Create forms Modify forms Create reports Modify reports Access Chapter 7	Recommended Access Chapter 4 Pages 270-285 Pages 295-308 Access Chapter 7 Pages 451-453 Pages 463-478 Access Supplemental Content Pages 24-25	Homework #3 MyLab Lesson F Module F4
	Wed 06/12		MyLab Lesson F Due
22	Wed 06/12	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	Homework #3 Homework #4
	Thu 06/13	Access	Homework #3 Due
23	Thu 06/13	Access	Access Supplemental Content Understand SQL SELECT queries Write custom SQL queries	Recommended Access Supplemental Content Pages 20-22	Homework #4
24	Fri 06/14	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	Homework #4 MyLab Lesson G Module G1
	Mon 06/17	Access	Homework #4 Due
25	Mon 06/17	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	MyLab Lesson G Module G2
	Tue 06/18		MyLab Lesson G Due
26	Tue 06/18	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 Word Chapter 3 Pages 233-235 Word Chapter 4 Pages 272-297 Word Chapter 6 Pages 419-422 Word Supplemental Content Page 29	Homework #5
27	Wed 06/19	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
28	Thu 06/20	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 PowerPoint Chapter 1 Pages 70-79 PowerPoint Chapter 4 Pages 289-298 PowerPoint Chapter 7 Pages 481-482 PowerPoint Supplemental Content Page 36	Homework #5
	Thu 06/20 to Fri 06/21		Exam #2 for online sections
	Fri 06/21		MyLab Extra Credit Projects #1, #2, and #3 Due
	Fri 06/21		MyLab Lessons Late Submission Deadline
	Fri 06/21	Word & PowerPoint	Homework #5 Due

References

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