Schedule

ATTENTION: The following lecture notes and homework assignments are copyrighted material and are intended for use by students enrolled in CE En 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
01 Brief Orientation, Course Intro            
02 CAEDM, Zipping files, Cloud Storage, FTP, VPN, Citrix, Zoom  

Cloud Storage

FTP Instructions

       
03 Basic Computer Concepts (compsci)   Basic Computer Concepts       HW#1
04 Web Page Authoring (html)   Web Authoring w/ Nvu
Web Authoring w/ Komp
HTML Guide

    HW#2
05 Word (word)     xmdf paper
grids.gif
xmdf paper (key)   HW#3
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