CIS 106 Computer Literacy

Sections:

• Formalities
• Lectures
• Schedule
• Goal
• Grading

Formalities

• Class Meetings:Tuesday/Thursday 9:00-10:50/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/29	PDF (Slides) Review Assignment Case Problem 1		Word Tutorial 1
01/30	Case Problem 2 Case Problem 3		Word Tutorial 1
02/05	cuny_colleges.docx Quiz Word Tutorial 1	Read/Learn: WD 4-WD 5 (Fig. 1-2, Fig. 1-3) WD 6-WD 11 (up to Fig. 1-12)	Word Tutorial 2 Cut/Copy/Paste Numbered and bulleted lists
02/07			Word Tutorial 2 Indentation Format painter
02/14	Juicer (Unformatted) Juicer (Formatted) Gurus Assignment (Gurus) Juggling Assignment (Juggling)	Read/Learn: WD54-WD60 (Cut/Copy/Paste) WD80-WD84 (Styles/Themes)
02/21	tables 1 tables 2
02/26	Hunter Class Textiles
02/26	vangogh (example) vangogh (assignment) assignment (assignment)
03/04	Juggling2 (Formatted) Juggling2 (Plain)		Word Tutorial 4 Word Art Clip Art Newspaper Columns
03/06	Assignment 1 Skyscrapers Assignment 2 Architecture NYC		Word Review Tutorial 1/2/3/4
03/11	Assignment Finder		Word Test
03/13	Excel Example		Excel Tutorial 1
03/18			Excel Tutorial 1
03/20	Formatting Example		Excel Tutorial 2
03/25
03/27
04/01			Excel Tutorial 3
04/03	Order Form		Excel Tutorial 3
04/08	Charts Example		Excel Tutorial 4
04/10	Charts Example 2		Excel Tutorial 4
04/15	Excel Review: Assignment Work Book Word Retake: Assignment Finder		Excel Review/Word Retake
04/17	Excel Test: Assignment Work Book		Excel Test
04/29	NFL AFC		Access Turotial 1
05/01	NFL2 Supplier (Review) Pinehill (Case 1) Fitness (Case 2)		Access Turotial 2
05/06			Access Turotial 2
05/08	NFL3 Supplier (Review) Pinehill (Case 1) Fitness (Case 2)		Access Turotial 3
05/20	Football Assignment		Access Test

Schedule

01/29 Introduction 01/31 Start Word 02/05 02/07 02/12 No Class 02/14 02/19 02/21 02/26 02/28 03/04 03/06 03/11 Test on Word 03/13 Start Excel 03/18 03/20 03/25

03/27 04/01 04/03 04/08 04/10 04/15 Word Test (retake) 04/17 Excel Test 04/22 No Class 04/24 No Class 04/29 05/01 05/06 05/08 05/13 05/15 No Class 05/20 Finals 05/22 Finals

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:

• Word,
• Excel,
• Access.

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.