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 |
| Sept 1 | Brief Orientation, Course Intro | ||||||
| Sept 3 | Basic Computer Concepts | ||||||
| Sept 8 | Zipping files, FTP, Citrix, Email, RouteY, CAEDM | ||||||
| Sept 10 | Web Page Authoring | ||||||
| Sept 15 | Word | ||||||
| Sept 17 | Powerpoint | ||||||
| Sept 22 | Excel - Introduction, Data Entry, Formatting | Chapters 1-7,11,25 |
|||||
| Sept 24 | Excel - VLOOKUP, naming cells, equations | Chapters 5,11,15 |
|||||
| Sept 29 | Excel - IF function, goal seek, solver | Chapters 25,37 |
|||||
| Oct 1 | Excel - Charting, Drawing, Arrays | Chapter 17-18,
19-20 |
|||||
| Oct 6-7 | Exam #1 - Online | ||||||
| Oct 6 | Intro to VB in Excel, Recording Macros, Review for exam |
Chapter 39 |
|||||
| Oct 8 | Working with Cells, Controls, MsgBox | Chapter 42 |
|||||
| Oct 13 | Variables, Constants, and Calculations | Chapter 39 |
|||||
| Oct 15 | Variables, cont., Introduction to Objects | Chapter 39 |
|||||
| Oct 20 | Decisions and Conditions | Chapter 39 |
|||||
| Oct 22 | Debugging, More Controls (combo boxes, spin controls, etc.) | Chapter 42 |
|||||
| Oct 27 | Do Loops and For Loops | Chapter 39 Intro to Looping PPT |
|||||
| Oct 29 | Looping, cont. | Chapter 39 |
|||||
| Nov 3 | Looping over files, 1D arrays | 8.270.5 | Chapter 39 Numerical Integration |
||||
| Nov 5-7 | Exam #2 - Online | ||||||
| Nov 5 | Custom Functions | Chapter 40 |
|||||
| Nov 10 | Custom Functions, cont. | Chapter 40 |
|||||
| Nov 12 | Using built-in Excel Functions, sub procedures | ||||||
| Nov 17 | Subs, cont., Updating Charts, Advanced MsgBox | ||||||
| Nov 19 | Working with Excel's Events | Chapter 43 |
|||||
| Nov 24 | No Class - Friday Instruction | ||||||
| Nov 26 | No Class - Thanksgiving | ||||||
| Dec 1 | Top-Down design, Developing complex algorithms | ||||||
| Dec 3 | String Functions, InputBox Function | ||||||
| Dec 8 | Custom User Forms | Chapter 41 |
|||||
| Dec 10 | Using VBA in other applications, Review for Final | ||||||
| Dec 11-12 | Exam prep days | ||||||
| Dec 14-16 | Final Exam - Online |
