Week 1:

Topic 1: Introduction to CS1100 and Overview of Excel: Functions, Formulas

Slides

Slide Deck 1

Videos

Flipped Classroom | Navigating Blackboard | | Academic Honesty | How to Study and Learn


Topic 2: Excel Basics, Formatting and Rounding

Slides

T02L01 - Excel Basics-2.pptx | Formatting and Rounding | T02L02- Formatting _ Rounding.pptx

Videos

Excel Basics | Formatting and Rounding

Examples

T01 Example Worksheets.xlsx | T01 Example Worksheets Completed.xlsx

Assignment

HW2 Instructions | Starter File
HW2 Instructions | Starter file | Help with Problem 2


Week 2:

Topic 3: Conditional Logic

Slides

Slide Deck 1 | Slide Deck 2 | Slide Deck 3

Videos

Conditional Logic, Building Flexible Models | Miscellaneous Functions

Examples

Counting Blank and Empty Cells | T01 Example Worksheets.xlsx | T01 Example Worksheets Completed.xlsx

Assignment

HW3 Instructions | Starter File
HW3 Instructions | Starter File


Week 3:

Topic 4: References

Slides

Slide Deck1 | Slide Deck 2 | Slide Deck 3

Videos

Visualizing Dependencies | Multi-Dimensional References | Data Validation

Examples

Multi-Dimensional References

Assignment (Optional)

HW4 (Optional) Instructions | Starter File
HW4 (Optional) Instructions | Starter File-Dashboard | Starter file-Sales


Topic 5: Table Lookup

Slides

Slide Deck1 | Slide Deck 2 | Slide Deck 3 | Slide Deck 4

Videos

Error Handling | Advanced Lookup | VLOOKUP vs INDEX-MATCH

Examples

Payroll Example | Error Handling | Advanced Lookup

Assignment

HW5 Instructions | Starter File
HW5 Instructions | Starter File

Week 4:

Topic 6: Text Processing

Slides

Slide Deck 1 | Slide Deck 2

Videos

String Parsing | Advanced Text Processing | Worked Example | Worked Example 2

Examples

Text Parsing Example | Transaction Example | Worked Example | Worked Example 2

Assignment

HW6 Instructions | Starter File
HW6 Instructions | Starter File

Week 5:

Take-Home released on Thursday 10/3 for W, Th sections and Due Sunday 10/6

Take-Home released on Monday 10/7 for Monday sections and Due Thursday 10/10

Topic 7: Visualization

Slides

Slide Deck 1 | Slide Deck 2

Videos

Charts & Graphs | Frequency Graphs

Examples

Chart Example | Frequency Example 1 | Frequency Example 2

Assignment

HW7 Instructions | Starter File
HW7 Instructions | Starter File


Topic 8: Pivot Tables

Slides

Slide Deck 1 | Slide Deck 2

Videos

Pivot Tables | Additional Resources 1 | Additional Resources 2

Examples

Pivot Table Sample Data & Examples

Assignment

HW8 Instructions | Starter File
HW8 Instructions | Starter File


Topic 9: Exploring Scenarios (Not part of the curriculum)

Slides

Slide Deck 1

Videos

Computational Forms | Data Tables | Goal Seek

Examples

Forms

Week 6:

Topic 10: Automation

Slides

Slide Deck 1

Videos

Automation

Examples

HW10 Instructions | Starter File
Macro Example Starter File | Macro Examples (Completed) HW 10 Instructions | Starter File


Review Week

Week 7:

Excel In-Class Exam

Week 8:

Topic 11: Large Data Sets

Slides

Slide Deck 1

Videos

Analyzing Data in Access

Examples

Bird Strikes (Excel) | Bird Strikes DB (Access)

Assignment

HW11 Instructions | Starter File
HW11 Instructions Amazon Referrals

Instructions on how to install Horizon and VPN for Off-Campus use

VPN Download | MFA Setup for VPN Horizon Setup


Topic 12: Data, Databases, and Queries

Slides

Slide Deck 1 | Slide Deck 2

Videos

Creating Databases in Access

Examples

RegistrarExampleDatabase | Orders Database

Assignment

HW12 Instructions | Starter File
HW12 Instructions | No Starter File

Week 9:

Topic 13: Query Formulation

Slides

Slide Deck 1 | Slide Deck 2 | Slide Deck 3

Videos

Building Queries | Query Design Principles

Examples

Orders Example DB | Sailors DB

Assignment

HW13 Instructions | Starter File
HW13 Instructions | Starter File

Week 10:

Topic 14: Advanced Queries

Slides

Slide Deck 1

Videos

Nested Queries

Examples

Orders Example
Practice Problems | Solutions

Assignment

HW14 Instructions | Starter File
HW14 Instructions | Starter File


Topic 15: Action Queries

Slides

Slide Deck 1

Examples

Registrar Database | Incoming Freshmen Excel File

Assignment

HW15 Instructions | HW15 Instructions with decomposition | Starter File
HW15 Instructions | Starter File


Week 11:

HW15 Due this Week | Access In-Class Exam Review

Practice problems (optional) | Database for practice | DB with solutions


Week 12:

In-Class Exam

Topic 16: Reports (optional)

Slides

Slide Deck 1

Examples

Orders Example | Orders Database -Report(for video)

Assignment

HW16 Instructions | Starter File
HW16 Instructions | Starter File


Week 13:

Project Instructions | Starter File


Week 14:

Make-Up Exams on December 5th | Final Project due date is Sunday, December 8th at 11:59p.m. (Information and submission links can be found on Canvas)
*Note: the instructor reserves the right to change the order of topics or dates if necessary.