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 
stringsreplace
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 builtin 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 





