Section Schedule for MW 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. 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.

Day	Unit	Content	Readings & Resources [1]-[3]	Assignments to Work On
Wed 08/17	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	MyITLab Lesson A Excel Chapter 1 Excel Chapter 10
Mon 08/22	Excel & Data Analysis	Data Analysis Supplemental Content 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	Recommended Data Analysis Supplemental Content Pages 6-9 Excel Chapter 1 Volume 1 Pages 373-383 Volume 1 Pages 394-405 Excel Chapter 10 Volume 2 Pages 441-469	MyITLab Lesson A Excel Chapter 4 Excel Chapter 12
Wed 08/24	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 4 Volume 1 Pages 565-591
Wed 08/24		MyITLab Lesson A Due
Mon 08/29	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 Volume 1 Pages 414-431 Excel Chapter 4 Volume 1 Pages 556-564 Volume 1 Pages 594-604 Excel Chapter 12 Volume 2 Pages 535-540	MyITLab Lesson B Excel Chapter 2 Excel Chapter 8
Wed 08/31	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 Volume 1 Pages 384-393 Excel Chapter 2 Volume 1 Pages 448-470 Excel Chapter 8 Volume 2 Pages 354-366	Homework #1 MyITLab Lesson B Excel Chapter 3 Excel Chapter 5 Excel Chapter 7 Excel Chapter 9
Mon 09/05		No Classes - Labor Day
Wed 09/07	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 Volume 1 Pages 471-487 Excel Chapter 7 Volume 2 Pages 310-320 Excel Chapter 9 Volume 2 Pages 407-415	Homework #1
Wed 09/07		MyITLab Lesson B Due
Fri 09/09	Excel & Data Analysis	Homework #1 Due
Mon 09/12	Excel & Data Analysis	Excel Chapter 3 Create charts Format charts Use a trendline Insert a sparkline Excel Supplemental Content Evaluate trendlines Format chart axes	Recommended Excel Chapter 3 Volume 1 Pages 505-543 Excel Supplemental Content Pages 12-16	Homework #2 MyITLab Lesson C Excel Chapter 6 Excel Chapter 11
Wed 09/14	Excel & Data Analysis	Excel Chapter 5 Create and use PivotTables Add and format PivotCharts Excel Supplemental Content Group PivotTable data	Recommended Excel Chapter 5 Volume 2 Pages 224-253	Homework #2 MyITLab Lesson C Access Chapter 1
Fri 09/16	Excel & Data Analysis	Homework #2 Due
Mon 09/19	Excel & Data Analysis	Excel Chapter 6 Use Goal Seek Use Scenario Manager Excel Chapter 8 Perform correlation analysis	Recommended Excel Chapter 6 Volume 2 Pages 277-285 Excel Chapter 8 Volume 2 Pages 367-373	Homework #3 MyITLab Lesson C Access Chapter 2
Wed 09/21	Excel & Data Analysis	Excel Chapter 2 Use the VLOOKUP function Use the PMT/FV function Excel Chapter 8 Use the SUMIF and COUNTIF functions Excel Chapter 10 Use the CONCATENATE function	Recommended Excel Chapter 10 Volume 2 Pages 456-462	Homework #3
Wed 09/21		MyITLab Lesson C Due
Fri 09/23	Excel & Data Analysis	Homework #3 Due
Mon 09/26	Excel & Data Analysis	Excel Chapter 6 Use Solver Excel Chapter 11	Recommended Excel Chapter 6 Volume 2 Pages 286-296	MyITLab Lesson D Access Chapter 3 Access Chapter 5
Wed 09/28	Excel & Data Analysis	Exam #1
Mon 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 Volume 1 Pages 617-644	MyITLab Lesson D Access Chapter 8 Access Chapter 10
Wed 10/05	Access	Access Chapter 2 Determine appropriate field types Select primary and composite keys Identify appropriate table relationships	Recommended Access Chapter 2 Volume 1 Pages 676-690
Wed 10/05		MyITLab Lesson D Due
Mon 10/10	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 Volume 2 Pages 791-802
Wed 10/12	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 Volume 1 Pages 653-660 Access Chapter 2 Volume 1 Pages 691-698 Access Chapter 5 Volume 2 Pages 587-591 Access Chapter 8 Volume 2 Pages 756-767 Access Supplemental Content Pages 18-19 Page 22
Mon 10/17	Access	Access Chapter 2 Create queries Use criteria Specify query sort order Access Chapter 10 Create SQL queries	Recommended Access Chapter 2 Volume 1 Pages 705-726 Access Chapter 10 Volume 2 Pages 865-874	MyITLab Lesson E Access Chapter 4 Access Chapter 6
Wed 10/19	Access	Access Chapter 3 Use Expression Builder Create calculated fields Specify field aliases Format query fields	Recommended Access Chapter 3 Volume 1 Pages 745-766	Homework #4
Wed 10/19		MyITLab Lesson E Due
Mon 10/24	Access	Access Chapter 2 Specify outer join relationships Control if query fields are shown Access Chapter 3 Use aggregate functions and grouping Access Chapter 5 Use conditional functions	Recommended Access Chapter 3 Volume 1 Pages 767-776 Access Chapter 5 Volume 2 Pages 597-615	Homework #4 MyITLab Lesson F Word Chapter 2 Word Chapter 5
Wed 10/26	Access	Access Chapter 4 Create forms Modify forms	Recommended Access Chapter 4 Volume 1 Pages 791-811	Homework #4 MyITLab Lesson F Word Chapter 1 Word Chapter 8
Fri 10/28	Access	Homework #4 Due
Mon 10/31	Access	Access Chapter 4 Create reports Modify reports	Recommended Access Chapter 4 Volume 1 Pages 812-829	Homework #5 MyITLab Lesson F Word Chapter 3 Word Chapter 4
Wed 11/02	Access	Access Chapter 2 Use wildcard criteria Access Chapter 5 Create parameter queries Access Chapter 6 Create update queries Create delete queries Access Supplemental Content Display unique records	Recommended Access Chapter 6 Volume 2 Pages 629-662 Access Supplemental Content Pages 18-19	Homework #5
Wed 11/02		MyITLab Lesson F Due
Fri 11/04	Access	Homework #5 Due
Mon 11/07	Access	Access Supplemental Content Understand SQL SELECT queries Write custom SQL queries	Recommended Access Supplemental Content Pages 19-22	MyITLab Lesson G Word Chapter 6 Word Chapter 7 PowerPoint Chapter 2
Wed 11/09	Access	Exam #2
Mon 11/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	Recommended Word Chapter 2 Volume 1 Pages 197-231 Word Chapter 5 Volume 2 Pages 34-41 Word Chapter 8 Volume 2 Pages 174-185	MyITLab Lesson G PowerPoint Chapter 1 PowerPoint Chapter 4
Wed 11/16	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 Word Supplemental Content Use the Equation Editor	Recommended Word Chapter 1 Volume 1 Pages 137-173 Word Chapter 3 Volume 1 Pages 259-273 Word Chapter 4 Volume 1 Pages 313-331 Word Supplemental Content Page 24
Wed 11/16		MyITLab Lesson G Due
Mon 11/21 to Fri 11/25		No Classes - Thanksgiving Break
Mon 11/28	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	Recommended Word Chapter 3 Volume 1 Pages 281-287 Word Chapter 4 Volume 1 Pages 332-339 Word Chapter 6 Volume 2 Pages 69-86	Homework #6 MyITLab Lesson H PowerPoint Chapter 3 PowerPoint Chapter 6 PowerPoint Chapter 7
Wed 11/30	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	Recommended PowerPoint Chapter 1 Volume 1 Pages 843-883 PowerPoint Chapter 2 Volume 2 Pages 920-930 PowerPoint Supplemental Content Pages 28-30	Homework #6
Wed 11/30		MyITLab Lesson H Due
Fri 12/02	Word & PowerPoint	Homework #6 Due
Mon 12/05	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 Embed Excel charts Insert automatically updating dates and times	Recommended PowerPoint Chapter 4 Volume 1 Pages 1007-1040 PowerPoint Chapter 7 Volume 2 Pages 1031-1035 PowerPoint Supplemental Content Pages 31-32
Tue 12/06		MyITLab Bonus Projects #1, #2, and #3 Due
Tue 12/06		MyITLab Lessons Late Submission Deadline
Thu 12/08 to Wed 12/14		Final Exam - see schedule for day and time

References

A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 1. Upper Saddle River, NJ: Pearson Education, 2013.
A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.
B. M. Powell, Supplemental Content for Microsoft Office 2013. Morgantown, West Virginia: West Virginia University, 2016. Available: http://cs101.wvu.edu/materials/supplemental-content/.