days

Document Sample

```					                                           CSE 200 - Spring '08 Syllabus KReeves
Wk# date      day                topic                     Reading                 HW assignment
CSE200 text: Intro to Computers 1-38, Windows
Intro, Our System, Computer   Fundatmentals - CSE200 text Windows Explorer p.194-
1   3/25    Tue    Basics                                                 234

Course Notes Intro to Excel
p.1-6, CSE200 text Excel   Course Notes Excel
Intro to Excel,Writing         Intro p.293-362, CSE200          Section
Formulas, Relative/Absolute   Excel Succeeding Chapter Exercise 2 p. 8, Exercise 5
2   3/27    Thr    Addresses,                      1 p.504-520,p.532-545             p. 11
lab 1          Lab 1 - Logging in, Intro to Our System (pre-lab & lab assignment in course notes)

CSE200 Excel Succeeding         Course Notes Excel
Chapter 1 Level 2 p. 522-            Section
2   4/1     Tue    Using Functions               531, Chapter 2 p.556-599         Exercise 9, p.18,
Using multiple worksheets,    CSE200 Excel Succeeding         Course Notes Excel
Units problems, Goal Seek,    Chapter 2 Level 3 p. 599-            Section
2   4/3     Thr    Charts                                  617                    Exercise 12 p. 24
lab2           Using formulas and functions (pre-lab in course notes, in-lab given out in lab)

CSE200 Excel Succeeding
Relational operators &        text Chapter 3 Level 1 p.630-   Course Notes Excel
Boolean Logical Functions,       646, Chapter 4 - Level 1          Section
3   4/8     Tue    Quiz 1                                  p.682-710              Exercise 18 p. 36
CSE200 Excel Succeeding        Course Notes Excel
textChapter 4 - Level 2 and         Section
3   4/10    Thr    If's and Nested If's                   3 p.712-735             Exercise 21 p. 40
lab3           Spreadsheet Design, Solving Units Problems (pre-lab in course notes, in-lab given out in lab)
CSE200 Excel Succeeding       Course Notes Excel
Reference functions, Quiz text Chapter 6 Level 1 p.826-        Section
4   4/15    Tue    2                                     842                  Exercise 25 p.48

CSE200 Excel Succeeding        Course Notes Excel
text Chapter 5 Level 1 p.754-        Section
4   4/17    Thr    Financial Functions                       768                  Exercise 29 p.53
lab 4          Using Boolean Logic to solve problems (pre-lab in course notes, in-lab given out in lab)
Course Notes - Excel
Putting it all Together     Section Snow Removal         Excel Section Prepare before comi
5   4/22    Tue    Quiz 3                      Problem Ex.30 p. 55-64                Problem Ex. 31 p. 65, Anna
Shelly Cashman
5   4/24    Thr    Review for midterm             assignment in pre-lab       Sample Midterm 1
lab5           Designing a worksheet, Reference/Financial Functions (pre-lab in course notes, in-lab given o
Course Notes Access
Section
6   4/29    Tue    Intro to Access, querying   Course Notes Chapter 2.1       Exercise 2.1-1 p.15
6   5/1     Thr    MIDTERM
lab6           PowerPoint presentations (pre-lab in course notes, in-lab given out in lab)
Course Notes Access
Section Exercise 2.2-2
7   5/6     Tue    Writing Access Queries      Course Notes Chapter 2.2                p.47
Course Notes Access
Section Exercise 2.3-3
7   5/8      Thr   Inner Joins, Outer Joins        Course Notes Chapter 2.3       p.79 Lone Star
lab7           Access - designing tables & queries (pre-lab in course notes, in-lab to be given out in lab)
Course Notes Access
Outer Joins, continued Quiz                                Section Exercise 2.4-4
8   5/13     Tue   4                            Course Notes Chapter 2.4        p.110 Antique Car
prepare these problems for class: Course Notes Conference D
8   5/15     Thr   Additional Problems in Access                 Ex. 2.4-2 p.96 & Web Services database Ex. 2.4
lab8           Access queries - advanced (pre-lab in course notes, addl assignment given in lab)
Excel Database Functions,
9  5/20      Tue   Quiz 5                          slides in course notes
9  5/22      Thr   Internet Topics                 Slides in course notes                               Assign lab 1
lab9            Project Integration (pre-lab in course notes, addl assignment given in lab)
10 5/27      Tue   Review For final
10 5/29      Thr   TBD
Lab 10          Internet and HTML (pre-lab assignment in course notes, wait to have this graded in lab)

Final Exam Time: MONDAY JUNE 2nd 1:30-3:
ves
Extra Problems in Course Notes

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

Expenditures Exercise 7 14

Excel Section:
Water problem Ex.10 p.20
in lab)

Excel Section:
Stocks - Exercise 13 p. 26,
Drug Team Assign - Exercise 14 p.28
Art logic Exercise 15 p. 30
Excel Section:
Simple if's Ex.19 p.38,Nested If's Ex.20
p.39,. BB's - Ex. 22 p.42
in-lab given out in lab)

Excel Section:
Financial problems Ex. 23 p.44
Excel Section:
Pricing Copies Ex 26 - p.50,
Sales Order Pricing Ex. 28 p.52
given out in lab)

n Prepare before coming to class: Playground
lem Ex. 31 p. 65, Anna & the King p.69

Sample Midterm 2
e notes, in-lab given out in lab)

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

ab)
Course Notes Access Section
Employee database Exercise 2.2-1
p.39
Access Section
Employee database Ex. 2.3-1 p.68
Music database Ex. 2.3-2 p.72
e given out in lab)

Access Section Employee database -
Exercise 2.4-1 p.91
se Notes Conference Database Access Section
vices database Ex. 2.4-3 p.103
ven in lab)

Assign lab 10
ab)

nd 1:30-3:18pm
CSE 200 - Spring '08 Syllabus
Wk# date     day                topic                     Reading                 HW assignment
CSE200 text: Intro to Computers 1-38, Windows
Intro, Our System, Computer     Fundatmentals - CSE200 text Windows Explorer p.194-
1   3/24    Mon   Basics                                                   234

Course Notes Intro to Excel
p.1-6, CSE200 text Excel   Course Notes Excel
Intro to Excel,Writing           Intro p.293-362, CSE200          Section
Formulas, Relative/Absolute     Excel Succeeding Chapter Exercise 2 p. 8, Exercise 5
2   3/26    Wed   Addresses,                        1 p.504-520,p.532-545             p. 11
lab 1         Lab 1 - Logging in, Intro to Our System (pre-lab & lab assignment in course notes)

CSE200 Excel Succeeding        Course Notes Excel
Chapter 1 Level 2 p. 522-           Section
2   3/31    Mon   Using Functions                 531, Chapter 2 p.556-599        Exercise 9, p.18,
Using multiple worksheets,      CSE200 Excel Succeeding        Course Notes Excel
Units problems, Goal Seek       Chapter 2 Level 3 p. 599-           Section
2   4/2     Wed   Quiz 1                                    617                   Exercise 12 p. 24
lab2          Using formulas and functions (pre-lab in course notes, in-lab given out in lab)

CSE200 Excel Succeeding
Charts,                        text Chapter 3 Level 1 p.630-   Course Notes Excel
Relational operators &            646, Chapter 4 - Level 1          Section
3   4/7     Mon   Boolean Logical Functions                p.682-710              Exercise 18 p. 36
CSE200 Excel Succeeding        Course Notes Excel
textChapter 4 - Level 2 and         Section
3   4/9     Wed   If's and Nested If's                    3 p.712-735             Exercise 21 p. 40
lab3          Spreadsheet Design, Solving Units Problems (pre-lab in course notes, in-lab given out in lab)
CSE200 Excel Succeeding      Course Notes Excel
text Chapter 6 Level 1 p.826-      Section
4   4/14    Mon   Financial Functions, Quiz 2             842                Exercise 25 p.48

CSE200 Excel Succeeding        Course Notes Excel
text Chapter 5 Level 1 p.754-        Section
4   4/16    Wed   Reference functions                        768                  Exercise 29 p.53
lab 4         Using Boolean Logic to solve problems (pre-lab in course notes, in-lab given out in lab)
Course Notes - Excel
Putting it all Together     Section Snow Removal         Excel Section Prepare before comi
5   4/21    Mon   Quiz 3                      Problem Ex.30 p. 55-64                Problem Ex. 31 p. 65, Anna
Shelly Cashman
5   4/23    Wed   Review for midterm             assignment in pre-lab       Sample Midterm 1
lab5          Designing a worksheet, Reference/Financial Functions (pre-lab in course notes, in-lab given o
6   4/28    Mon                 midterm - 1st hour of class                      Course Notes Access
6   4/30    Wed   Intro to Access, querying      Course Notes Chapter 2.1              Section
lab6          PowerPoint presentations (pre-lab in course notes, in-lab given out in lab)
Course Notes Access
Section Exercise 2.2-2
7   5/5     Mon   Writing Access Queries      Course Notes Chapter 2.2                p.47
Course Notes Access
Section Exercise 2.3-3
7   5/7     Wed   Inner Joins, Quiz 4             Course Notes Chapter 2.3       p.79 Lone Star
lab7          Access - designing tables & queries (pre-lab in course notes, in-lab to be given out in lab)
Course Notes Access
Section Exercise 2.4-4
8   5/12    Mon   Outer Joins                  Course Notes Chapter 2.4        p.110 Antique Car
prepare these problems for class: Course Notes Conference D
8   5/14    Wed   Additional Problems in Access                 Ex. 2.4-2 p.96 & Web Services database Ex. 2.4
lab8          Access queries - advanced (pre-lab in course notes, addl assignment given in lab)
Excel Database Functions,
9  5/19     Mon   Quiz 5                          slides in course notes
9  5/21     Wed   Internet Topics                 Slides in course notes                               Assign lab 1
lab9           Project Integration (pre-lab in course notes, addl assignment given in lab)
10 5/26     Mon                                          NO CLASSES IN OBSERVANCE OF MEMORIAL DAY
10 5/28     Wed   Review For final
Lab 10         Internet and HTML (pre-lab assignment in course notes, wait to have this graded in lab)
Final Exam Time:
Extra Problems in Course Notes

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

Expenditures Exercise 7 14

Excel Section:
Water problem Ex.10 p.20

Excel Section:
Stocks - Exercise 13 p. 26,
Drug Team Assign - Exercise 14 p.28
Art logic Exercise 15 p. 30
Excel Section:
Simple if's Ex.19 p.38,Nested If's Ex.20
p.39,. BB's - Ex. 22 p.42
in-lab given out in lab)

Excel Section:
Financial problems Ex. 23 p.44
Excel Section:
Pricing Copies Ex 26 - p.50,
Sales Order Pricing Ex. 28 p.52
given out in lab)

n Prepare before coming to class: Playground
lem Ex. 31 p. 65, Anna & the King p.69

Sample Midterm 2
e notes, in-lab given out in lab)
Setup a new database, MySnacks.mdb
file on Carmen look at filtering, sorting

Course Notes Access Section
Employee database Exercise 2.2-1
p.39
Access Section
Employee database Ex. 2.3-1 p.68
Music database Ex. 2.3-2 p.72
e given out in lab)

Access Section Employee database -
Exercise 2.4-1 p.91
se Notes Conference Database Access Section
vices database Ex. 2.4-3 p.103
ven in lab)

Assign lab 10

MORIAL DAY

1   Sun
2   Mon
3   Tue
4   Wed
5   Thr
6   Fri
7   Sat

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 9 posted: 12/25/2011 language: English pages: 9