|
| |
ATTENTION:
The following lecture notes and homework assignments are copyrighted material
and are intended for use by students enrolled in CE En 270 only. Any other use
or reproduction without express written consent from Dr. Jones is strictly
prohibited.
|
Date |
Topic |
Virtual
Lecture |
Obj. |
Reading
& Extra Materials |
In Class
Tasks |
Task Solutions |
HW |
HW Due Date |
|
Jan 8 |
Brief Orientation,
Course Intro |
|
|
|
|
|
|
|
|
Jan 10 |
Basic Computer Concepts |
- |
8.2.1 |
- |
- |
- |
HW #1
|
- |
|
Jan 15 |
Zipping files, FTP, Citrix,
Email, RouteY, CAEDM |
- |
8.2.1, 8.2.2 |
- |
- |
- |
HW #2 |
- |
|
Jan 17 |
No lecture |
- |
- |
- |
- |
- |
- |
- |
|
Jan 22 |
Web Page Authoring with
FrontPage |
- |
8.2.2 |
Setting up
a FrontPage Web, HTML Quick
Reference |
- |
- |
HW #3 |
- |
|
Jan 24 |
Frontpage, cont.,
Creating Presentations with PowerPoint |
- |
8.2.1 |
- |
- |
- |
HW #4 |
- |
|
Jan 29 |
Excel - Introduction, Data
Entry, Formatting |
Excel
Intro |
8.2.1 |
Chapters 1-5 |
grades1
concrete1 |
grades1_key
concrete1_key |
HW #5 |
- |
|
Jan 31 |
Excel - VLOOKUP, naming
cells, equations |
- |
8.2.1 |
Chapters 8-9, 11-12 |
grades2
concrete2
projectile |
grades2_key
concrete2_key
projectile_key |
HW#6
HW#6b |
- |
|
Feb 5 |
Excel - IF function, goal
seek, solver |
- |
8.2.1 |
Chapters 23 |
circchan1 |
circchan1_key |
HW #7 |
- |
|
Feb 7 |
Excel - Charting, Drawing, Arrays |
- |
8.2.1 |
Chapter 14-17 |
proj_plot
surface
arrayform |
proj_plot_key
surface_key
arrayform_key |
HW #8 |
- |
|
Feb 12 |
Intro to VB in Excel,
Recording Macros, Review for exam
|
- |
7.1,
8.2.3, 8.2.4 |
Chapter 34, pg 379-391,
Intro to VB in Excel,
recording macros |
mymacros |
mymacros_key |
HW #9 |
- |
|
Feb 12-13 |
Exam #1 (on-line) |
- |
- |
- |
- |
- |
- |
- |
|
Feb 14 |
Working with Cells, Controls, MsgBox |
- |
7.1,
8.2.3, 8.2.4 |
Chapter 37, Controls |
controls |
controls_key |
HW #10 |
- |
|
Feb 19 |
No lecture -
Monday Instruction |
- |
- |
- |
- |
- |
- |
- |
|
Feb 21 |
Review Exam Results,
Variables, Constants, and Calculations |
- |
7.1,
8.2.3, 8.2.4 |
- |
variables
brakes |
variables_key
brakes_key |
HW #11 |
3/4 |
|
Feb 26 |
Variables, cont.,
Introduction to Objects
|
- |
7.1,
8.2.3, 8.2.4 |
- |
landfill
comments |
landfill_key
comments_key |
HW #12 |
3/6 |
|
Feb 28 |
Missed Lecture |
- |
- |
- |
- |
- |
- |
- |
|
Mar 4 |
Decisions and Conditions |
- |
7.1,
8.2.3, 8.2.4 |
Notes |
simple_if
qualify_pe |
simple_if_key
qualify_pe_key |
HW #13 |
- |
|
Mar 6 |
Debugging,
More Controls (combo boxes, spin controls, etc.) |
- |
7.1,
8.2.1, 8.2.4 |
Debugging Notes
|
controls2b
colorcombo1
colorcombo2 |
controls2b_key
colorcombo1_key
colorcombo2_key |
HW #14 |
- |
|
Mar 11 |
Do Loops and For Loops |
Loops
Pt 1 |
7.1,
8.2.1, 8.2.4 |
Notes |
conccurve
factorial |
conccurve_key
factorial_key |
HW #15 |
- |
|
Mar 13 |
Looping, cont. |
Loops
Pt 2 |
7.1,
8.2.3, 8.2.4 |
- |
prime
factors |
prime_key
factors_key |
HW #16 |
3/25 |
|
Mar 18 |
Looping over files,
1D arrays |
Loops
Pt 3 |
7.1,
8.2.3, 8.2.4 |
- |
integration |
looping_files1
looping_files2
integration_key |
HW #17 |
3/27 |
|
Mar 18-20 |
Exam #2 |
- |
- |
- |
- |
- |
- |
- |
|
Mar 20 |
Custom Functions |
- |
7.1,
8.2.3, 8.2.4 |
Chapter 35
Notes |
quadfunction
numneg |
quadfunction_key
numneg_key |
- |
- |
|
Mar 25 |
Custom Functions, cont. |
- |
7.1,
8.2.3, 8.2.4 |
- |
scale
statetax |
scale_key
statetax_key |
HW #18 |
- |
|
Mar 27 |
Using built-in Excel
Functions, sub
procedures |
- |
7.1,
8.2.3, 8.2.4 |
Sub Notes |
dropsum
subs |
dropsum_key1
dropsum_key2
subs_key |
HW #19 |
- |
|
Apr 1 |
Subs, cont., Updating Charts,
Advanced MsgBox |
- |
7.1,
8.2.3, 8.2.4 |
- |
chartupdate |
chartupdate_key |
HW #20 |
- |
|
Apr 3
|
Working with Excel's Events |
Events |
- |
Chapter 38
Notes |
no button |
no_button_key |
HW #21 |
- |
|
Apr 8 |
Top-Down design, Developing
complex algorithms |
- |
7.1,
8.2.3, 8.2.4 |
- |
- |
- |
HW #22 |
- |
|
Apr 10 |
String Functions, InputBox Function |
- |
7.1,
8.2.3, 8.2.4 |
String Fun Notes |
strings
names |
strings_key
names_key |
HW #23 |
- |
|
Apr 15 |
Custom User Forms |
- |
7.1,
8.2.3, 8.2.4 |
Chapter 36-37 |
- |
- |
HW #24
HW #25 |
- |
|
Apr 16-17 |
Reading Days |
- |
- |
- |
- |
- |
-
|
- |
|
Apr 18-21 |
Final Exam (on-line) |
- |
- |
- |
- |
- |
- |
- |
|
