CIS 106 Computer Literacy Spring 2009
Sections:
Formalities
- Class Meetings:Tuesday/Thursday 11:00-12:50
- Room: G221
- Instructor:Evan Goris evangoris@gmail.com
- Web page:http://www.cs.gc.cuny.edu/~evangoris
- Office hours:Thursday 13:00-14:00, room 305A
- Book: Microsoft Office 2007 (New Perspectives On), Windows XP Edition
- Syllabus: PDF
- Student Data link (use this link for IE7)
Lectures
| Date |
Files |
Homework for this week |
Material covered |
| 01/27 |
|
|
Word Tutorial 1 |
| 02/03 |
|
|
Word Tutorial 2 |
| 02/05 |
|
|
Word Tutorial 3 |
| 02/10 |
|
|
|
| 02/12 |
|
|
|
| 02/17 |
|
|
|
| 02/19 |
|
|
Word Tutorial 4 |
| 02/24 |
|
|
Word Test |
| 02/26 |
|
|
Excel Tutorial 1 |
| 03/05 |
|
|
Excel Tutorial 2 |
| 03/12 |
|
|
Excel Tutorial 3 |
| 03/19 |
|
|
Excel Tutorial 4 |
| 03/26 |
|
|
Excel Review |
| 03/31 |
|
|
Excel Test |
| 04/02 |
|
|
Access Tutorial 1 |
| 04/28 |
|
|
Access Tutorial 3 |
| 04/30 |
|
|
Access Tutorial 1,2,3 |
| 05/05 |
|
|
Access Tutorial 4 |
| 05/07 |
|
|
Access Tutorial 4 |
| 05/12 |
|
|
Access Tutorial 1,2,3,4 |
| 05/14 |
|
|
Access Test |
Schedule
| 01/27 | Start Word |
| 01/29 | |
| 02/03 | |
| 02/05 | |
| 02/10 | |
| 02/12 | No Class |
| 02/17 | |
| 02/19 | |
| 02/24 | Test on Word |
| 02/26 | Start Excel |
| 03/03 | |
| 03/05 | |
| 03/10 | |
| 03/12 | |
| 03/17 | |
| 03/19 | |
| 03/24 | |
|
| 03/26 | |
| 03/31 | Test on Excel |
| 04/02 | |
| 04/07 | |
| 04/09 | No Class |
| 04/14 | No Class |
| 04/16 | No Class |
| 04/21 | Start Access |
| 04/23 | |
| 04/28 | |
| 04/30 | |
| 05/05 | |
| 05/07 | |
| 05/12 | |
| 05/14 | Last Day of Class |
| 05/19 | Test on Access |
| 05/21 | |
|
Goal of the Course
To get familiar with computers in general and in particular with the three
main components of the Microsoft Office 2007 Suite:
We will be going through the Chapters on Word, Excel, and Access of the
text that belongs to this course (see above).
Word
By the end of the Word section you will be able to do
simple formatting tasks such as change the font face, font size,
and set the line spacing in a document. But also more elaborate
tasks such as setting tabs stops, adding headers and footers with
possibly page numbering to a document, inserting images,
and applying styles.
Excel
By the end of the Excel section you will be able to
format an excel worksheet such that it looks professionally,
do simple calculations
on data and more elaborate calculations involving absolute and
relative cell references.
Access
By the end of the Access section you will be able to distinguish
the different elements a data base is made out of (tables, queries,
forms and reports) and will have a good idea of what
a relational database is.
You will create and modify tables, create forms and reports and
design queries.
Grading
- Test on Word (1/4), Excel (1/4), and Access (1/4).
- Remaining 1/4: Quizzes and short, in class, problem sets.
