Computer Science and Its Applications

Topic 1:
Introduction to CS1100
Overview of Excel: Functions, Formulas
Slides: Slide Deck 1
Videos: Flipped Classroom, Navigating Blackboard, Submitting Assignments, Academic Honesty, How to Study and Learn



Topic 2:
Excel Basics
Formatting & Rounding
Slides: T02L01 - Excel Basics-2.pptx, T02L02- Formatting _ Rounding.pptx
Videos: Excel Basics, Formatting and Rounding
Exercise Files: T01 Example Worksheets.xlsx, T01 Example Worksheets Completed.xlsx


Topic 3:
Conditional Logic
Slides: Slide Deck 1 | Slide Deck 2 | Slide Deck 3
Videos: Conditional Logic, Building Flexible Models, Miscellaneous Functions
Example: COUNTing Blank and Empty Cells


Topic 4:
References
Slides: Slide Deck1 | Slide Deck 2 | Slide Deck 3
Videos: Visualizing Dependencies, Multi-Dimensional References, Data Validation
Example: Multi-Dimensional References



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



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



Topic 7:
Visualization
Slides: Slide Deck 1| Slide Deck 2
Videos: Charts & Graphs, Frequency Graphs
Examples: Chart Example| Frequency Example 1| Frequency Example 2|

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


Topic 9:
Exploring Scenarios (Not part of the curriculum)
Slides: Slide Deck 1| Slide Deck 2 Slide Deck 3
Videos: Computational Forms | Data Tables | Goal Seek
Examples: Sliders & What-If Analysis | Data Table Sample Data & Examples | Goal Seek Data & Examples


Topic 10:
Automation (Not part of curriculum)
Slides: Slide Deck 1
Videos: Automation
Examples: Macro Example Starter File | Macro Examples (Completed)


Topic 11:
Large Data Sets
Slides: Slide Deck 1
Videos: Analyzing Data in Access
Examples: Bird Strikes (Excel) | Bird Strikes DB (Access)


Topic 12:
Data, Databases, and Queries
Slides: Slide Deck 1 | Slide Deck 2
Videos: Creating Databases in Access
Examples: RegistrarExampleDatabase| Orders Database



Topic 13:
Query Formulation
Slides: Slide Deck 1 | Slide Deck 2 | Slide Deck 3
Videos: Building Queries| Query Design Principles



Topic 14:
Advanced Queries
Slides: Slide Deck 1
Videos: Nested Queries



Topic 15:
Action Queries
Slides: Slide Deck 1
Examples: Registrar Database| Incoming Freshmen Excel File



Topic 16:
Reports (optional)