# Schedule

ATTENTION: The following lecture notes and homework assignments are copyrighted material and are intended for use by students enrolled in CCE 170 only. Any other use or reproduction without express written consent from Dr. Jones is strictly prohibited. The dates shown for the HW assignments and the Quizes represent the due date.

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