days

Document Sample
days Powered By Docstoc
					                                           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
                    PowerPoint,                   PowerPoint text - reading
 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)


              Gradebook Exercise 6 p.12,
              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,
              Grades Ex. 27 p.51,
              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)



s graded in lab)

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
                   PowerPoint,                   PowerPoint text - reading
 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,




            Gradebook Exercise 6 p.12,
            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,
            Grades Ex. 27 p.51,
            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

s graded in lab)
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