| CSE101 SYLLABUS AUTUMN 2008 | |||||||
| lec # | date | day | class | topic | Assigned Reading | In-class Practice Problems | On your own Chap. Reviews |
| 1 | 25-Sep | Thu | lecture | Class Overview, Computer Basics, Our System with Vista |
Shelly-Cashman (S/C) p.COM1-38, WIN 1-66 | ||
| 26-Sep | Fri | lab1 | Intro to Computers & Ours System | ||||
| 2 | 30-Sep | Tue | lecture | Intro to Excel, Writing Formulas incl. Relative & Absolute Cell Referencing | Course Notes Excel Chapter 1.1, 1.2 p.1-30 | Meal Pricing p.18 Cell Addressing p.28 |
C.R. p.19 |
| 3 | 2-Oct | Thu | lecture | Writing formulas - & solving problems | Mult. Table p29 | C.R. p.31 | |
| 3-Oct | Fri | lab2 | Creating Simple Spreadsheets & Cell Referencing | ||||
| 4 | 7-Oct | Tue | lecture | Functions | Course Notes Excel Chapter 1.3 p.31-53 | Gradebook p.49, Rock Concert p.50 | |
| 5 | 9-Oct | Thu | lecture | Solving Problems w/Functions, Goal Seek, Charts | Course Notes Excel Chapter 1.4, 1.5 p.55-66 | Expenditure p.51 | C.R. p.52 |
| 10-Oct | Fri | lab3 | Using Formulas & Functions, Intro to Charts | ||||
| 6 | 14-Oct | Tue | lecture | Boolean logic - relational expressions, and, or, not | Course Notes Excel Chapters 1.6 p.67-83 | Stock Analysis p.79 | |
| 7 | 16-Oct | Thu | lecture | Boolean Logic - problem solving Exam 1 |
Logic Airline p.81 or another logic problem | C.R. p.82 | |
| 17-Oct | Fri | lab4 | Charting, Solving Problems with Boolean Logic | ||||
| 8 | 21-Oct | Tue | lecture | If's and nested ifs, Using Multiple worksheets & workbook designs |
Course Notes Excel Chapters 1.7 & 1.8 p.85-104 | Simple If's - p.92, Travel Prices p.93 | C.R. p.94 |
| 9 | 23-Oct | Thu | lecture | Lookup Functions | Course Notes Chapter 1.9 p.105-113 | Pricing Copies p.110, Gradebook p.111, sales ordering p.112 | C.R. p.113 |
| 24-Oct | Fri | lab5 | Solving problems with If's & Lookups | ||||
| 10 | 28-Oct | Tue | lecture | Units Problems & Financial functions | Course Notes Excel Chapters 1.10,1.11 p.115-144 | Water Problem p.119. Practice w/Financial functions p.140-141 | C.R. p.121 & p. 143 |
| 11 | 30-Oct | Thu | lecture | Spreadsheet design, Additional problem solving | Course Notes Excel -Review chapter 1.8 | ||
| 31-Oct | Fri | lab6 | Designing your own Worksheet | ||||
| 12 | 4-Nov | Tue | lecture | Some features of Word & PowerPoint Exam 2 |
S/C Word and PowerPoint Chapters | ||
| 13 | 6-Nov | Thu | Intro to Access | Course Notes Access Chapter 2.1 | Concepts Review p15 | ||
| 7-Nov | Fri | lab7 | Working with PowerPoint & Word & Access Tables | ||||
| 11-Nov | Tue | lecture | Veteran's Day - No Class | ||||
| 14 | 13-Nov | Thu | lecture | Access Queries | Course Notes Access Chapter 2.2 | ||
| 14-Nov | Fri | No lab | |||||
| 15 | 18-Nov | Tue | lecture | Solving problems w/simple queries & Inner Joins | Course Notes Access Chapter 2.3 | Employee database p.39-46 | C.R. p 47 |
| 16 | 20-Nov | Thu | lecture | Working with Access Queries, Intro to final project | Music database P.73 - 79 | C.R. p 80 | |
| 21-Nov | Fri | lab 8 | Access Queries | ||||
| 17 | 25-Nov | Tue | lecture | Excel Database commands & pivot tables Exam 3 |
|||
| 27-Nov | Thu | No classes Thanksgiving | |||||
| 28-Nov | Fri | No classes Thanksgiving | |||||
| 18 | 2-Dec | Tue | Work on Final Project.. Due wed at noon | ||||
| 19 | 4-Dec | Thu | lecture | Review for Final Exam | |||
| 5-Dec | Fri | TBD | |||||
| 9:30 lecture class FINAL EXAM Thu Dec 11 9:30-11:18am | |||||||
| 12:30 lecture class FINAL EXAM Wed Dec 10 11:30-1:18pm | |||||||