Section Schedule for First-Half Online Sections | Computer Science 101

The schedule below summarizes most important subject material covered throughout the semester. It 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. Participation Projects are not shown on the schedule below and are due on the date listed on your instuctor'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/2	Mon 05/15	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 Data Analysis Supplemental Content Pages 2-3 Pages 6-9 Excel Chapter 1 Pages E5-E8 Pages E73-E78 Pages E121-E123 Excel Chapter 10 Pages E618-E623 Pages E640-E641	MyITLab Lesson A Module A1 Module A2
3/4	Wed 05/17	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	MyITLab Lesson A Module A3 Module A4
5	Fri 05/19	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 A Module A5 Module A6 MyITLab Lesson B Module B1
	Fri 05/19		MyITLab Lesson A Due
6	Mon 05/22	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 #1 MyITLab Lesson B Module B2 Module B3 Module B4
	Tue 05/23	Excel & Data Analysis	Homework #1 Due
	Tue 05/23		MyITLab Lesson B Due
7/8	Wed 05/24	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 Excel Chapter 3 Pages E200-E245 Excel Chapter 5 Pages E339-E349 Pages E372-E373 Excel Supplemental Content Pages 12-16	Homework #2
9	Fri 05/26	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 #2 Homework #3 MyITLab Lesson C Module C1
	Fri 05/26	Excel & Data Analysis	Homework #2 Due
10/11	Mon 05/29	Excel & Data Analysis	Excel Chapter 2 Use the VLOOKUP function Use the PMT function Excel Chapter 6 Use Solver Excel Chapter 7 Use the FV function Excel Chapter 8 Use the SUMIF and COUNTIF functions Excel Chapter 10 Use the CONCATENATE function Excel Chapter 11	Recommended Excel Chapter 2 Pages E177-E181 Excel Chapter 6 Pages E428-E434 Excel Chapter 7 Pages E482-E483 Excel Chapter 8 Pages E512-E515 Excel Chapter 10 Page E631	Homework #3 MyITLab Lesson C Module C2 MyITLab Lesson D Module D1
	Tue 05/30	Excel & Data Analysis	Homework #3 Due
	Wed 05/31	Excel & Data Analysis	Exam #1
	Wed 05/31		MyITLab Lesson C Due
12/13	Fri 06/02	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 06/05	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 06/05		MyTLab Lesson D Due
16	Wed 06/07	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 06/09	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 06/09		MyITLab Lesson E Due
18	Mon 06/12	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 A243-A249 Access Chapter 5 Pages A355-A369 Access Supplemental Content Pages 19-20 Pages 23-24	Homework #4 MyITLab Lesson F Module F2 Module F3
	Tue 06/13		MyITLab Lesson F Due
19/20	Wed 06/14	Access	Access Chapter 4 Create forms Modify forms Create reports Modify reports	Recommended Access Supplemental Content Pages 24-25 Word Chapter 4 Pages 270-285 Pages 295-308	Homework #4 Homework #5 MyITLab Lesson G Module G1
	Wed 06/14	Access	Homework #4 Due
23/24 /25	Fri 06/16	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 06/19	Access	Homework #5 Due
	Tue 06/20	Access	Exam #2
	Tue 06/20		MyITLab Lesson G Due
26/27	Wed 06/21	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 PowerPoint Supplemental Content Pages 32-36	Homework #6
	Thu 06/22		Final Exam
	Fri 06/23	Word & PowerPoint	Homework #6 Due (no late submissions)
	Fri 06/23		MyITLab Bonus Projects #1, #2, and #3 Due
	Fri 06/23		MyITLab Lessons Late Submission Deadline

References

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.
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.
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.
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.
B. M. Powell, Supplemental Content for Microsoft Office 2016. Morgantown, West Virginia: West Virginia University, 2017. Available: http://cs101.wvu.edu/materials/supplemental-content/.