Section Schedule | Computer Science 101 | West Virginia University

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 01/13	Excel & Data Analysis	Course Introduction Course policies Course websites Resources Data Analysis Supplemental Content Effective Internet searches Search for newspaper articles Locate scholarly articles	Required Syllabus Course Overview Video for Asynchronous Online Sections Recommended Data Analysis Supplemental Content Pages 2-3	MyLab Lesson A Module A1 Module A2 Module A3
2	Thu 01/16	Excel & Data Analysis	Data Analysis Supplemental Content Download data and extract ZIP file contents Answer analysis questions Excel 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 3-9 Excel Common Features Pages 50-53 Pages 63-64 Excel Chapter 1 Pages 120-130 Pages 163-166 Pages 172-173 Excel Chapter 10 Pages 676-681 Pages 696-697	MyLab Lesson A Module A4 Module A5 Module A6
	Mon 01/20		No Class - Martin Luther King Day
	Wed 01/22		MyLab Lesson A Due
3	Thu 01/23	Excel & Data Analysis	Excel Chapter 1 Insert and delete rows and columns Excel Chapter 4 Create tables Format tables Use the table total row Sort data	Recommended Excel Chapter 1 Pages 138-139 Pages 147-148 Excel Chapter 4 Pages 315-325 Pages 328-331 Pages 338-341
4	Mon 01/27	Excel & Data Analysis	Excel Chapter 1 Adjust font settings Use cell borders Specify cell fill colors Format cells Specify page orientation and scaling Apply cell styles Excel Chapter 4 Apply conditional formatting Apply color scale formatting	Recommended Excel Chapter 1 Pages 153-162 Pages 166-167 Pages 173-174 Excel Chapter 4 Pages 345-355	MyLab Lesson B Module B1
5	Thu 01/30	Excel & Data Analysis	Excel Chapter 1 Write formulas Use AutoFill Excel Chapter 2 Use basic statistical functions Use absolute, mixed, and relative cell references Excel Chapter 4 Use structured cell references in tables Excel Chapter 8 Use the RANK.EQ function	Recommended Excel Chapter 1 Pages 122-123 Pages 128-129 Pages 131-132 Page 135 Excel Chapter 2 Pages 194-200 Pages 204-206 Pages 210-213 Excel Chapter 4 Pages 326-327 Page 337 Excel Chapter 8 Pages 561-562	MyLab Lesson B Module B2 Module B3
6	Mon 02/03	Excel & Data Analysis	Excel Chapter 2 Use the IF function Excel Chapter 7 Use AND/OR criteria Use nested IF functions Excel Chapter 9 Write 3-D formulas	Recommended Excel Chapter 2 Pages 223-225 Pages 229-230 Excel Chapter 7 Pages 502-504 Pages 510-511 Excel Chapter 9 Pages 620-622 Pages 628-629	MyLab Lesson B Module B4
	Wed 02/05		MyLab Lesson B Due
7	Thu 02/06	Excel & Data Analysis	Excel Chapter 3 Create charts Format chart elements Modify chart data series Insert a sparkline Excel Chapter 8 Add chart trendlines Excel Supplemental Content Adjust chart horizontal axis labels Project future values with trendlines Use R-squared values to evaluate trendlines	Recommended Excel Chapter 3 Pages 242-286 Excel Chapter 8 Pages 581-583 Pages 586-587 Excel Supplemental Content Pages 12-15
8	Mon 02/10	Excel & Data Analysis	Excel Chapter 5 Create and use PivotTables Add and format PivotCharts Use PivotTable filters Group PivotTable data	Recommended Excel Chapter 5 Pages 377-394 Pages 397-398 Page 402	Homework #1
9	Thu 02/13	Excel & Data Analysis	Excel Chapter 6 Use Goal Seek Use Scenario Manager Excel Chapter 8 Perform correlation analysis	Recommended Excel Chapter 6 Pages 458-468 Excel Chapter 8 Pages 557-558 Page 567	Homework #1 MyLab Lesson C Module C1
	Fri 02/14	Excel & Data Analysis	Homework #1 Due
10	Mon 02/17	Excel & Data Analysis	Excel Chapter 2 Use lookup functions Use the PMT function Excel Chapter 7 Use the FV function Use the SUMIF and COUNTIF functions Excel Chapter 11 Use the CONCAT function	Recommended Excel Chapter 2 Pages 215-223 Pages 226-229 Excel Chapter 7 Pages 512-514 Pages 518-520 Pages 524-527 Excel Chapter 11 Page 739	Homework #2 MyLab Lesson C Module C2 Module C3
	Wed 02/19		MyLab Lesson C Due
11	Thu 02/20	Excel & Data Analysis	Excel Chapter 6 Use Solver	Recommended Excel Chapter 6 Pages 469-479	Homework #2
	Fri 02/21	Excel & Data Analysis	Homework #2 Due
12	Mon 02/24	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 Open tables in Design View	Recommended Access Chapter 1 Pages 72-97 Access Chapter 2 Pages 138-143	MyLab Lesson D Module D1 Module D2
13	Thu 02/27	Access	Access Chapter 2 Determine appropriate field types Designate primary and composite keys Identify appropriate table relationships	Recommended Access Chapter 2 Pages 134-148	MyLab Lesson D Module D3
	Mon 03/03 to Tue 03/04	Excel & Data Analysis	Exam #1
	Wed 03/05		MyLab Lesson D Due
14	Thu 03/06	Access	Access Chapter 2 Plan databases Access Chapter 9 Normalize databases	Recommended Access Chapter 9 Pages 502-514
15	Mon 03/10	Access	Access Chapter 2 Plan and normalize databases Access Chapter 9 Normalize databases	Recommended Access Chapter 9 Pages 502-514
16	Thu 03/13	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 Access Supplemental Content Import XML data Answering analysis questions	Recommended Access Chapter 1 Pages 72-74 Pages 88-92 Page 97 Pages 109-110 Access Chapter 2 Pages 138-147 Pages 152-156 Pages 161-163 Access Chapter 5 Pages 309-310 Pages 314-316 Access Chapter 8 Pages 477-479 Pages 486-488 Access Supplemental Content Page 18 Pages 23-24	MyLab Lesson E Module E1 Module E2
	Mon 03/17 to Fri 03/21		No Classes - Spring Break
17	Mon 03/24	Access	Access Chapter 2 Create queries Specify query sort order Access Chapter 10 Create SQL queries	Recommended Access Chapter 2 Pages 164-168 Pages 172-174 Pages 176-185 Access Chapter 10 Pages 578-583	MyLab Lesson E Module E3 Module E4
	Wed 03/26		MyLab Lesson E Due
18	Thu 03/27	Access	Access Chapter 2 Use criteria to restrict results 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 169-171 Page 175 Access Chapter 3 Pages 204-209 Pages 212-214	Homework #3
19	Mon 03/31	Access	Access Chapter 3 Use aggregate functions and grouping Access Chapter 5 Use IIF function Access Supplemental Content Specify outer join relationships Control if query fields are shown in results	Recommended Access Chapter 3 Pages 226-231 Access Chapter 5 Pages 321-324 Page 330 Access Supplemental Content Page 20 Page 24	Homework #3 MyLab Lesson F Module F1 Module F2
20	Thu 04/03	Access	Access Chapter 4 Create forms Modify forms Access Chapter 7 Work with subforms Access Supplemental Content Create forms using the Form Wizard	Recommended Access Chapter 4 Pages 250-270 Access Chapter 7 Pages 396-398 Access Supplemental Content Pages 24-26	Homework #3 MyLab Lesson F Module F3
	Fri 04/04	Access	Homework #3 Due
21	Mon 04/07	Access	Access Chapter 4 Create reports Modify reports	Recommended Access Chapter 4 Pages 271-287	MyLab Lesson F Module F4
	Wed 04/09		MyLab Lesson F Due
22	Thu 04/10	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 values	Recommended Access Chapter 2 Page 169 Page 172 Access Chapter 5 Pages 317-318 Pages 327-328 Access Chapter 6 Pages 346-350 Pages 355-356 Pages 358-359 Pages 362-363 Access Supplemental Content Page 19	Homework #4
23	Mon 04/14	Access	Access Supplemental Content Understand SQL SELECT queries Write custom SQL queries	Recommended Access Supplemental Content Pages 20-23	Homework #4
24	Thu 04/17	Word & PowerPoint	Word Chapter 1 Create a new document Insert text from a file Apply formatting styles Create and modify formatting styles Word Chapter 2 Insert and format pictures Adjust paragraph spacing, indentation, and alignment Word Chapter 5 Insert Excel charts Insert hyperlinks Word Supplemental Content Use the Equation Editor	Recommended Word Chapter 1 Pages 117-119 Pages 128-129 Pages 138-141 Page 150 Word Chapter 2 Pages 186-190 Page 198 Word Chapter 5 Pages 364-365 Page 380 Page 387 Word Supplemental Content Page 28	Homework #4 MyLab Lesson G Module G1
	Fri 04/18	Access	Homework #4 Due
25	Mon 04/21	Word & PowerPoint	Word Common Features Adjust margins and orientation Create headers and footers Word Chapter 1 Create section breaks Word Chapter 2 Use bulleted and numbered lists Word Chapter 3 Create tables Word Chapter 4 Insert a cover page	Recommended Word Common Features Pages 89-91 Pages 96-97 Word Chapter 1 Pages 135-137 Page 148 Word Chapter 2 Page 194 Page 201 Word Chapter 3 Pages 242-255 Word Chapter 4 Page 309 Page 314	MyLab Lesson G Module G2
	Wed 04/23		MyLab Lesson G Due
26	Thu 04/24	Word & PowerPoint	Word Chapter 3 Add captions Word Chapter 4 Manage and insert citations Insert a bibliography Create footnotes and endnotes Insert a table of contents Track changes Word Chapter 6 Compare and combine versions of a document Word Supplemental content Use cross-references	Recommended Word Chapter 3 Pages 263-264 Pages 268-269 Word Chapter 4 Pages 298-313 Pages 315-317 Page 324 Word Chapter 6 Pages 430-432 Pages 436-438 Word Supplemental Content Page 29	Homework #5
27	Mon 04/28	Word & PowerPoint	PowerPoint Chapter 1 Create a new presentation Use slide layouts and add content Add headers and footers Apply themes Insert pictures Resize, move, align, and crop pictures PowerPoint Chapter 2 Apply animations Apply slide transitions PowerPoint Chapter 3 Embed Excel charts PowerPoint Chapter 5 Modify slide masters PowerPoint Supplemental Content Design effective presentations Insert automatically updating dates	Recommended PowerPoint Chapter 1 Pages 117-122 Pages 128-129 Pages 132-143 Pages 147-150 PowerPoint Chapter 2 Pages 218-231 PowerPoint Chapter 3 Pages 305-315 PowerPoint Chapter 5 Pages 398-404 Pages 409-411 PowerPoint Supplemental Content Pages 32-35	Homework #5 MyLab Extra Credit Projects #1-#2 (optional)
28	Thu 05/01	Word & PowerPoint	PowerPoint Chapter 1 Use speaker notes Run a slideshow PowerPoint Chapter 2 Embed video PowerPoint Chapter 5 Hide slides PowerPoint Chapter 6 Rehearse timings	Recommended PowerPoint Chapter 1 Pages 152-155 Page 160 PowerPoint Chapter 2 Pages 232-239 Pages 246-247 PowerPoint Chapter 5 Page 432 Page 439 PowerPoint Chapter 6 Pages 482-483 Pages 494-495	Homework #5 MyLab Extra Credit Projects #3-#4 (optional)
	Fri 05/02		MyLab Extra Credit Projects #1, #2, #3, and #4 Due
	Fri 05/02		MyLab Lessons Late Submission Deadline
	Fri 05/02	Word & PowerPoint	Homework #5 Due
	Mon 05/05 to Wed 05/07		Exam #2

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, 2025. Available: http://cs101.wvu.edu/materials/supplemental-content/.