Class 1 Introduction to CS1100 Overview of Excel: Functions, Formulas Slides: PPT | PDF Submit Syllabus Quiz Class 2 Introduction to Excel Filtering & Summarizing Data Using IF, STDEV, AVERAGE and COUNT Slides: PPT | PDF Video Lecture (AVI | WMV) Videos: Named Ranges, Formatting, Copyable Formulas Examples: Examples| Example Solutions Lab: Lab 1 Instructions | Starter File Start Excel Lab 1 Class 3 Lab Period Excel Lab 1 due at 11:59pm Class 4 Table Lookup Slides: PPT | PDF Videos: Part 1, Part 2, Part 3, Part 4, Example: Payroll Example Lab: Lab 2 Instructions | Starter File Start Excel Lab 2 Class 5: 1/22 Lab Period Excel Lab 2 due at 11:59pm 1/21/2014 Class 6: Friday 1/24 Text Processing Slides: PPT| PDF Video Lecture (MP4) Videos: Hiding Columns Examples: Text Parsing Example Lab: Lab 3 Instructions | Starter File Start Excel Lab 3 Class 7: Wednesday 1/29 Excel QuizClass 8: Friday 1/31 Lab Period Excel Lab 3 due at 11:59pm Class 9: Wednesday 2/5 Report Generation, Charts and Graphs Slides: PPT| PDF Frequency Function Videos: Creating a Pie Chart | Creating a Column Chart | Entering the Frequency Function | Creating a Histogram | What is Binning? Examples: Sample Data | Chart Examples | Frequency Sample Data Lab: Lab 4 Instructions | Starter File Start Excel Lab 4 Class 10: Wednesday 2/12 Lab Period Excel Lab 4 due at 11:59pm Class 11: Friday 2/14 Pivot Tables Slides: PPT | PDF Step-by-Step | Online Tutorial | Calculated Fields | List of Tutorials | Video Tutorial Example: Pivot Table Data Lab: Lab 5 Instructions | Starter File Start Excel Lab 5 Class 12:Wednesday 2/19 Lab Period Excel Lab 5 due at 11:59pm Class 13: Friday 2/21 Excel Test |
Class 14 Relational Databases, Defining Tables & Relations, Populating Tables, Simple Queries Materials: PPT | PDF Video Lecture (AVI | WMV) Videos: Creating Databases & Tables | Establishing Relationships | Adding Data | Simple Queries | GROUP BY, COUNT, WHERE Example: Example Database Lab: Access Lab 1 Instructions| There is no starter file Start Access Lab 1 Class 15 Lab Period Access Lab 1 due at 11:59pm Class 16 Query Formulation, Aggregate Functions Materials: PPT | PDF Videos: Simple Queries | GROUP BY, COUNT, WHERE Example: Example Database Lab: Access Lab 2 Instructions| Starter File Start Access Lab 2 Class 17 Lab Period Work on Access Lab 2 Class 18 Nested & Advanced Queries Materials: PPT | PDF | Video Lecture Videos: Finding Min/Max/Avg | Parameterized Queries Lab: Access Lab 3 Instructions | Starter File Start Access Lab 3 Class 19 Lab Period Work on Access Lab 3 Class 20 Access Quiz
Class 21 Action Queries Materials: PPT | PDF Videos: Update Query | Append Query | Make-Table Query | Delete Query Example: Example Database | Append Data Lab: Lab 4 Instructions | Starter File Start Access Lab 4 Class 22 Lab Period Access Lab 4 due at 11:59pm Class 23 Report Generation Slides: PPT | PDF Videos: Creating Reports | Formatting Reports | Headers and Footers Lab: Access Lab 5 Instructions | Starter File Start Access Lab 5 Class 24 Lab Period Access Lab 5 due at 11:59pm Class 25 Review for Access TestClass 26 Access TestClass 27 TBDFinal Exam - Optional Date TBD All sections in 210WVH |

*Note: the instructor reserves the right to change the order of topics or dates if necessary.