Lecture Video Archive

ICS-7: Spreadsheets for Problem Solving



I will post a video for eachlecture that I record this quarter, typically just a few hours after I have delivered the lecture. Entries that appear with a green background have been posted with this quarter's lectures.

Based on student input, I will leave all these lectures online for the entire quarter (formerly I removed them after a few days), so you can review them at your lesuire. But I strongly suggest that you not get behind viewing these lectures, if you are not synchronously attending class. Of course, you can always view them at a high(er) speed, going backward and then reviewing slowly any material that was unclear.


Week # DayDate Lecture Video
Week 1 Monday3/29 Introduction to Spreadsheets and Excel
Wednesday3/31 Fundamentals of Excel Formulas
Friday4/2 Some Special/Useful Functions
Week 2 Monday4/5 Scatter Charts
Wednesday4/7 Intermediate Worksheets, Cells, and Data Tables
Friday4/9 Finish Lecture 5 and Start Example Models
Week 3 Monday4/12 Example Models (continued) + Questions for In-Lab Exam #1
Wednesday4/14 Basic Reference Functions
Friday4/16 Reference Functions (continued)
Week 4 Monday4/19 Names for Values/Cells/Formulas and Actions (macros)(lost 1st 5 minutes)
Wednesday4/21 Charts with Names, More Controls, and Data Validation
Friday4/23 A Quick Tour of Other Charts
Week 5 Monday4/26 Arrays and Array Formulas
Wednesday4/28 Arrays and Array Formulas (continued)
Friday4/30 Introducing Data Bases and Simple Queries via Autofilter and Sorting
Week 6 Monday5/3 More Complicated Queries via Cells
Wednesday5/5 Complicated Queries by Example
Friday5/7 Introducing Pivot Tables and Pivot Charts
Week 7 Monday5/10 More Examples of Pivot Tables
Wednesday5/12 Importing Data into Excel (from Spring 2020)
Friday5/14 Introducing Visual Basic (VBA) Subroutines
Week 8 Monday5/17 Visual Basic Functions and Parameters/Arguments
Wednesday5/19 Selection, Assignment, and IF Statements: Compute PI Example
Friday5/21 Indefinite Looping: Do Until (missing 1st 15 mins)
Week 9 Monday5/24 More on Input/Two Examples
Wednesday5/26 VBA Review Skipped this Lecture
Friday5/28 Excel's Solver
Week 10 Monday5/31 Holiday (no classes) Memorial Day
Wednesday6/2 Course Wrap-up/Other Special Topics
Friday6/4 Review for Final Exam