KReeves CSE 200 - Autumn 2009 Syllabus

Lec#

date

day

topic

Reading

HW assignment

Extra Problems in Course Notes

1

9/24

Thr

Intro, Our System - Window Vista, Computer Basics

CSE200 online materials: Chapter 1 p. 1-38, Chapter 2 p.41-106

 

 

 

lab 1

 

Lab 1 - Logging in, Intro to Our System (pre-lab & lab assignment in course notes)

 

2

9/29

Tue

Intro to Excel,Writing Formulas, Relative/Absolute Addresses

Chapter 6 - Level 1 p.361-379, Level 3 p. 391-407 , Supplemental materials for learning to use spreadsheets: In a Flash Excel Lessons 1,2,3 (video)

Course Notes Excel Section
Exercise 2 p. 8, Exercise 5 p. 11

Excel Section:
Simple Formulas Exercise 1 - p7, Cell Addressing Exercise 3 p.9, Mult. Table Exercise 4 p.10,

3

10/1

Thr

Using Functions

Chapter 6 - Level 2 p. 381-391 Chapter 7 - Levels 1 & 2 p.415-458

Course Notes Excel Section
Exercise 9, p.18,

Gradebook Exercise 6 p.12, Expenditures Exercise 7 14

 

lab2

 

Using formulas and functions (pre-lab in course notes, in-lab given out in lab)

 

4

10/6

Tue

Units problems, Spreadsheet design & using multiple worksheets,  Goal Seek

Chapter 7- Level 3 p. 458-479, review Chapter 6 Level 3 p.391-394

Course Notes Excel Section
Exercise 12 p. 24

Excel Section:
Water problem Ex.10 p.20

5

10/8

Thr

Charts,
Relational operators & Boolean Logical Functions, Quiz 1

Chapter 8 - Level 1 p.487-506, Chapter 9 - Level 1 p.541-570, Supplemental materials for learning to use charts: In a Flash Excel Lessons 5 (chapter 8)

Course Notes  Excel Section
Exercise 18 p. 36

Excel Section:
 Stocks - Exercise 13 p. 26,
Drug Team Assign - Exercise 14 p.28
Art logic Exercise 15 p. 30

 

lab3

 

Spreadsheet Design,  Solving Units Problems (pre-lab in course notes, in lab given out in lab)

 

6

10/13

Tue

If's and Nested If's

Chapter 9 - Level 2,3  p.571-603

Course Notes Excel Section
Exercise 21 p. 40

Excel Section:
Simple if's Ex.19 p.38,Nested If's Ex.20 p.39,. BB's - Ex. 22 p.41

7

10/15

Thr

Reference functions, Quiz 2

Chapter 11 - Level 1 p.683-703

Course Notes Excel Section
Exercise 29 p.53

Excel Section:
Pricing Copies Ex 26 - p.50,
Grades Ex. 27 p.51,
Sales Order Pricing Ex. 28 p.52

 

lab 4

 

Using Boolean Logic to solve problems (pre-lab in course notes, in-lab given out in lab)

 

8

10/20

Tue

Financial Functions

Chapter 10 - Level 1 p.611-628

Course Notes Excel Section
Exercise 25 p.48

Excel Section:
Financial problems Ex. 23 p.44

9

10/22

Thr

Putting it all Together
Quiz 3

Excel Section of Course notes - Snow Removal Problem p.55

Excel Section Prepare before coming to class: Playground Problem Ex. 31 p. 65, Anna & the King p.69

 

lab5

 

Designing a worksheet, Reference/Financial Functions (pre-lab in course notes, in-lab given out in lab)

10

10/27

Tue

PowerPoint,
Review for midterm, Start Access Introduction

PowerPoint Chapter 13-15 p. 811-1008, Supplemental materials for learning to use presentation graphics: In a Flash PowerPoint Lessons (all)

Sample Midterm 1

Sample Midterm 2

11

10/29

Thr

MIDTERM

 

 

 

 

lab6

 

PowerPoint presentations (pre-lab in course notes, in-lab given out in lab)

 

12

11/3

Tue

Database Concepts & Introduction to Access, Writing Queries

Course Notes Access Section Chapter 2.1, Supplemental materials for learning to use databases: In a Flash Access Lessons 1,2,3

Course Notes Access Section
Exercise 2.1-1 p.15

Setup a new database, MySnacks.mdb file on Carmen look at filtering, sorting

13

11/5

Thr

Writing Access Queries

Course Notes Access Section Chapter 2.2

Course Notes Access Section Exercise 2.2-2 p.47

Course Notes Access Section Employee database Exercise 2.2-1 p.39

 

lab7

 

Access - designing tables & queries (pre-lab in course notes, in-lab to be given out in lab)

 

14

11/10

Tue

Inner Joins,
Quiz 4

Course Notes Access Section Chapter 2.3

 Course Notes Access Section Exercise 2.3-3 p.79 Lone Star

Access Section
Employee database Ex. 2.3-1 p.68
Music database Ex. 2.3-2 p.72

15

11/12

Thr

Outer Joins

Course Notes Access Section Chapter 2.4

Course Notes Access Section Exercise 2.4-4 p.110 Antique Car

Access Section Employee database -
Exercise 2.4-1 p.91

 

lab8

 

Access queries - advanced (pre-lab in course notes, addl assignment given in lab)

16

11/17

Tue

Additional Problems in Access

 prepare these problems for class: Course Notes Conference Database Access Section Ex. 2.4-2 p.96 & Web Services database Ex. 2.4-3 p.103

17

11/19

Thr

Excel Database Functions, Quiz 5

Chapter 12 Levels 1-2 p.749-793

 

 

lab9

 

Project Integration  (pre-lab in course notes, addl assignment given in lab)

 

18

11/24

Tue

Internet Topics

Slides in course notes

 

 

11/26

Thr

Thanksgiving Holiday

 

 

 

No Labs - Thanksgiving Break

 

 

19

12/1

Tue

Review for Final Exam

 

Sample Final 2 from Course Notes

 

 

12/3

Thr

TBD

 

Lab 10

 

Internet and HTML (pre-lab assignment in course notes, wait to have this graded in lab)

FINAL EXAM: Thursday December 10th 9:30am-11:18am