Section Schedule for Second-Half Sections | Computer Science 101

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.

Day	Unit	Content	Readings and Resources	Assignments to Work On
Tues 06/28	Excel & Data Analysis	Course Introduction Course policies Course websites Resources Data Analysis Supplemental Content Effective Internet searches	Required Syllabus Recommended Data Analysis Supplemental Content Pages 22-23	Data Analysis: Online Scavenger Hunt Participation Project
Wed 06/29	Excel & Data Analysis	Excel Chapter 1 Enter and modify cell data Insert, delete, and rename worksheets Adjust rows and columns Write basic formulas Select cells Use AutoFill Excel Chapter 10 Import data	Recommended Excel Chapter 1 Volume 1 Pages 373-431 Excel Chapter 10 Volume 2 Pages 441-469	MyITLab Lesson A Excel Chapter 1
Thu 06/30	Excel & Data Analysis	Excel Chapter 1 Apply cell formatting Excel Chapter 2 Understand relative, absolute, and mixed cell references Use basic math and statistical functions Use logical functions Use financial functions Excel Chapter 9 Create 3-D formulas	Recommended Excel Chapter 1 Volume 1 Pages 406-431 Excel Chapter 2 Volume 1 Pages 447-487 Excel Chapter 9 Volume 2 Pages 409-415	MyITLab Lesson A Excel Chapter 2 Excel Chapter 9 Excel Chapter 10
Tue 07/05	Excel & Data Analysis	Excel Chapter 3 Create and format charts Use trendlines Insert sparklines Excel Chapter 4 Freeze rows and columns Create and format tables Use table total rows Apply conditional formatting Excel Chapter 12 Apply cell styles	Recommended Excel Chapter 3 Volume 1 Pages 505-543 Excel Chapter 4 Volume 1 Pages 555-604	Homework #1 MyITLab Lesson A Excel Chapter 12 MyITLab Lesson B Excel Chapter 3 Excel Chapter 4
Wed 07/06	Excel & Data Analysis	Excel Supplemental Content Evaluate trendlines Format chart axes Group PivotTable data Excel Chapter 5 Create and use PivotTables Add and format PivotCharts Excel Chapter 8 Use ranking functions	Recommended Excel Chapter 5 Volume 2 Pages 215-253 Excel Chapter 8 Volume 2 Pages 357-366 Excel Supplemental Content Pages 2-6	Homework #1 MyITLab Lesson B Excel Chapter 5 Excel Chapter 8 Excel Chapter 9
Wed 07/06	Excel & Data Analysis	MyITLab Lesson A Due
Wed 07/06	Excel & Data Analysis	Homework #1 Due
Thu 07/07	Excel & Data Analysis	Excel Chapter 6 Use Goal Seek Use Scenario Manager Use Solver Excel Chapter 7 Use nested and conditional logical functions Excel Chapter 8 Use conditional math and statistical functions Excel Chapter 11 Insert comments	Recommended Excel Chapter 6 Volume 2 Pages 277-296 Excel Chapter 7 Volume 2 Pages 309-338 Excel Chapter 8 Volume 2 Pages 354-356 Excel Chapter 11 Volume 2 Pages 481-513	Homework #2 MyITLab Lesson B Excel Chapter 6 Excel Chapter 7 Excel Chapter 11
Fri 07/08	Excel & Data Analysis	Homework #2 Due
Tue 07/12	Excel & Data Analysis	Exam #1
Wed 07/13	Access	Access Chapter 1 Identify real-world uses Selecting a database or spreadsheet Explore Microsoft Access interface Recognize object types and uses Create, edit, and delete records Use Compact and Repair Database tool Use sort and filter tools in Datasheet View	Recommended Access Chapter 1 Volume 1 Pages 617-648	Homework #3 MyITLab Lesson C Access Chapter 1
Wed 07/13	Excel & Data Analysis	MyITLab Lesson B Due
Wed 07/13	Excel & Data Analysis	Homework #3 Due
Thu 07/14	Access	Access Chapter 1 Create and save databases Access Chapter 2 Plan and normalize databases Create tables Access Chapter 9 Normalize databases	Recommended Access Chapter 1 Volume 1 Pages 653-660 Access Chapter 2 Volume 1 Pages 675-690 Access Chapter 9 Volume 2 Pages 791-802	MyITLab Lesson C Access Chapter 2
Tue 07/19	Access	Access Chapter 2 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	Recommended Access Chapter 2 Volume 1 Pages 695-698 Access Chapter 5 Volume 2 Pages 587-591 Access Chapter 8 Volume 2 Pages 756-767 Access Supplemental Content Page 8	MyITLab Lesson C Access Chapter 5 Access Chapter 8
Wed 07/20	Access	Access Chapter 2 Create queries Use criteria Specify query sort order Access Chapter 3 Use Expression Builder Create calculated fields Specify field aliases Format query fields	Recommended Access Chapter 2 Volume 1 Pages 675-726 Access Chapter 3 Volume 1 Pages 745-766	Homework #4 MyITLab Lesson C Access Chapter 3
Thu 07/21	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 Access Chapter 10 Create SQL queries Access Supplemental Content Display unique records Access Chapter 4 Create forms	Recommended Access Chapter 3 Volume 1 Pages 767-776 Access Chapter 4 Volume 1 Pages 791-811 Access Chapter 5 Volume 2 Pages 597-615 Access Chapter 10 Volume 2 Pages 865-874 Access Supplemental Content Pages 8-9	Homework #4 MyITLab Lesson C Chapter 4 Chapter 10
Fri 07/22	Access	Homework #4 Due
Tue 07/26	Access	Access Chapter 4 Create forms Create reports Modify reports Access Chapter 5 Access Chapter 6 Create update queries Create delete queries Create queries to find duplicate records Create queries to find unmatched records Access Chapter 10 Understand SQL SELECT queries Write custom SQL queries	Recommended Access Chapter 4 Volume 1 Pages 791-829 Access Chapter 5 Volume 2 Pages 581-596 Access Chapter 6 Volume 2 Pages 629-662	Homework #5 MyITLab Lesson C Access Chapter 6
Wed 07/27	Access	Exam #2
Thu 07/28	Word & PowerPoint	Word Chapter 1 Display non-printing characters Create headers and footers Adjust margins and orientation Word Chapter 2 Apply paragraph formatting Create, modify, and use formatting styles Insert and format pictures Word Chapter 5 Insert Excel charts Word Chapter 8 Insert hyperlinks Word Supplemental Content Use the Equation Editor	Recommended Word Chapter 1 Volume 1 Pages 137-173 Word Chapter 2 Volume 1 Pages 197-244 Word Chapter 5 Volume 2 Pages 34-41 Word Chapter 8 Volume 2 Pages 174-183 Word Supplemental Content Page 12	Homework #5 MyITLab Lesson D Word Chapter 1 Word Chapter 2 Word Chapter 5 Word Chapter 8
Thu 07/28	Access	Homework #5 Due
Thu 07/28	Access	MyITLab Lesson C Due
Tue 08/02	Word & PowerPoint	Word Chapter 2 Create section breaks Word Chapter 3 Insert captions Create tables Word Chapter 4 Insert a cover page Create footnotes and endnotes Insert a table of contents Manage and insert citations Insert a bibliography Word Chapter 6 Compare and combine versions of a document Word Chapter 7	Recommended Word Chapter 2 Volume 1 Pages 217-230 Word Chapter 3 Volume 1 Pages 259-273 Volume 1 Pages 281-287 Word Chapter 4 Volume 1 Pages 313-331 Word Chapter 6 Volume 2 Pages 69-86	MyITLab Lesson D Word Chapter 3 Word Chapter 4 Word Chapter 6 Word Chapter 7
Tue 08/02	Word & PowerPoint	MyITLab Lesson D Due
Wed 08/03	Word & PowerPoint	PowerPoint Chapter 1 Use slide layouts and add content Apply transitions Apply animations Add headers and footers Run a slideshow Add speaker notes PowerPoint Chapter 2 Understand principles of slide design Apply themes Modify slide masters PowerPoint Chapter 3 Format objects PowerPoint Chapter 4 Insert pictures Embed video PowerPoint Chapter 6 PowerPoint Chapter 7 Hide slides PowerPoint Supplemental Content Design effective presentations Embed Excel charts Insert automatically updating dates Rehearse timings	Recommended PowerPoint Chapter 1 Volume 1 Pages 843-883 PowerPoint Chapter 2 Volume 2 Pages 920-930 PowerPoint Chapter 3 Volume 1 Pages 977-993 PowerPoint Chapter 4 Volume 1 Pages 1007-1040 PowerPoint Chapter 7 Volume 2 Pages 1031-1035 PowerPoint Supplemental Content Pages 16-20	Homework #6 MyITLab Lesson E PowerPoint Chapter 1 PowerPoint Chapter 2 PowerPoint Chapter 3 PowerPoint Chapter 4 PowerPoint Chapter 6 PowerPoint Chapter 7
Thu 08/04		Final Exam
Fri 08/05	Word & PowerPoint	MyITLab Bonus Projects #1, #2, and #3 Due
Fri 08/05	Word & PowerPoint	MyITLab Lesson E Due
Fri 08/05	Word & PowerPoint	Homework #6 Due (No Late Submissions)
Fri 08/05		MyITLab Lessons Late Submission Deadline