| Lecture |
Topic (code) |
Quiz |
Reading & Extra Materials |
Exercises |
Solutions |
Videos |
HW |
| 06 |
Excel - Introduction, Data Entry, Formatting (excel) |
Quiz 1 |
Cells and Formulas |
grades1
concrete1 |
grades1_key
concrete1_key |
grades1
concrete1 |
HW#4 |
| 07 |
Excel - VLOOKUP, naming cells, equations (excel) |
Quiz 2 |
VLOOKUP
Naming Cells
Operators & Precedence
|
grades2
concrete2
projectile |
grades2_key
concrete2_key
projectile_key |
grades2
concrete2
projectile |
HW#5 |
| 08 |
Excel - IF function, data validation, goal seek, solver (excel)
Manning's Equation |
Quiz 3 |
IF Function
Data Validation
Goal Seek & Solver |
circchan1
snowball |
circchan1_key |
circchan1, pt 1
circchan1, pt 2 |
HW#6 |
| 09 |
Excel - Charting, Drawing, Arrays (excel) |
Quiz 4 |
Creating Charts
Annotation
Array Formulas |
proj_plot
surface
arrayform |
proj_plot_key
surface_key
arrayform_key |
drawing tools
equation editor
charts
array formulas |
HW#7 |
| |
Exam #1 - Online |
|
|
|
|
|
|
| 10 |
Intro to VB in Excel, Recording Macros (macros) |
Quiz 5 |
Getting Started
Recording Macros |
mymacros |
mymacros_key |
macros, dev tab
macros, abs
macros, rel
macros, launch |
HW#8 |
| 11 |
Working with Cells, Controls, MsgBox (ranges, controls, msgbox) |
Quiz 6 |
Cells and Ranges*
Controls*
MsgBox*
|
controls |
controls_key |
controls, pt 1
controls, pt 2
controls, pt 3 |
HW#9 |
| 12 |
Variables, Constants, and Calculations (variables) |
Quiz 7 |
Variables
Good Coding Practices
|
variables
brakes |
variables_key
brakes_key |
variables
brakes |
HW#10 |
| 13 |
Variables, Constants, and Calculations (variables), Introduction to Objects (objects) |
Quiz 8 |
Objects |
comments |
comments_key
|
comments, pt 1
comments, pt 2
comments, pt 3 |
HW#11 |
| 14 |
Decisions and Conditions (ifthen) |
Quiz 9 |
If Statements |
simple_if
qualify_pe |
simple_if_key
qualify_pe_key |
simple if
qualify pe |
HW#12 |
| 15 |
Debugging, More Controls (debug, controls) |
Quiz 10 |
Debugging*
Controls* |
controls2b
brakes2 |
controls2b_key
brakes2_key |
controls2b
brakes |
HW#13 |
| 16 |
For Loops (loops) |
Quiz 11 |
Loops*
|
inverse
prime
factorial |
inverse_key
prime_key
factorial_key |
inverse
prime
factorial |
HW#14 |
| 17 |
Do Loops (loops) |
Quiz 12 |
Loops*
|
doloops
conccurve |
doloops_key
conccurve_key |
doloops
conccurve |
HW#15 |
| 18 |
Arrays (loops, arrays)
Numerical Integration |
Quiz 13 |
Arrays
|
integration |
integration_key |
integration |
HW#16 |
| |
Exam #2 - Online |
|
|
|
|
|
|
| 19 |
String Functions, InputBox Function (strings, msgbox) |
Quiz 14 |
Strings
InputBox* |
strings
names |
strings_key
names_key |
strings
names |
HW#17 |
| 20 |
Custom User Forms (forms) |
Quiz 15 |
Custom User Forms |
progreport |
progreport key |
strings-replace
progreport |
HW#18 |
| 21 |
Custom Functions (functions) |
Quiz 16 |
Custom Functions |
quadfunction
alpha
names2
|
quadfunction_key
alpha_key
names2_key
|
quadfunction
alpha
names2 |
HW#19 |
| 22 |
Custom Functions, cont. (functions) |
|
Custom Functions |
fibonacci
numneg |
fibonacci_key
numneg_key |
fibonacci
fib2 (recursion)
numneg |
HW#20
|
| 23 |
Using built-in Excel Functions, sub procedures (functions, subs) |
Quiz 17 |
Excel Functions
Custom Subs |
dropsum
estimator |
dropsum_key
estimator_key |
dropsum
estimator |
HW#21
|
| 24 |
Subs, cont., Updating Charts, Advanced MsgBox (subs, msgbox), |
|
Custom Subs
MsgBox
|
chartupdate
gentable |
chartupdate_key
gentable_key
|
chartupdate
gentable |
HW#22 |
| 25 |
Working with Excel's Events (events) |
Quiz 18 |
Events |
qualify_pe2
onkey |
qualify_pe2_key
onkey_key |
qualify_pe2
onkey |
HW#23 |
| 26 |
Google Sheets and the Google Apps Script API |
|
Google Sheets and GAS |
names3
conccurve2 |
names3_key
names3_notes
conccurve2_key
conccurve2_notes |
gas_intro
names3
conccurve2 |
HW#24 |
| |
Term Project Reports |
|
Term projects due at midnight |
|
|
|
HW#25 |
| |
Final Exam - Online |
|
|
|
|
|
|