CISY 102, Computer Literacy / Fall 2008 (Tue and Thu)

Web Site for the Text book: http://www.scsite.com/catalog/product.cfm?isbn=978-1-4239-1228-6

 

Asignments / Exams

%

10, In-Class labs and 20 HW labs (3 word, 3 Excel, 2 Access & 2 PP) 

20%

Exam I - Word 2007                  (based on concepts covered in Labs 1 & 2)             open book format

5%

Exam II - Word 2007                (based on concepts covered in Labs 2 & 3)             open book format

10%

Exam I - Excel 2007                   (based on concepts covered in Labs 1 & 2)             open book format

5%

Exam II - Excel 2007                 (based on concepts covered in Labs 2 & 3)             open book format

10%

Exam - Access 2007                   (based on concepts covered in Labs 1 & 2)             open book format

15%

Exam - PowerPoint 2007         (based on concepts covered in Labs 1 & 2)            open book format

10%

Exam - based on supplementary material                                              closed book format 20%

Class Attendance

5%

 

Date

In-Class Labs, Windows XP, Vol 1. 

Home Work Labs

1 Thu,

10/02

 Introduction, E-Mail and Contact

 

 Graphics Supplement 1
 Supplement on Data Representation and Networking
 Introduction to Windows Vista

 

 Project 1, Creating and Editing a Word Document, WD 2 to WD 62

 

1 Tue,

10/07

 Graphics Supplement 1
 Supplement on Data Representation and Networking

 Project 1, Lab #2, Pg WD 69  WD70

Lab #3, Pg WD 70  WD71

 

2 Thu,

10/09

 Graphics Supplement 1
 Supplement on Data Representation and Networking

 Project 2, Creating a Research Paper, WD 73 to WD 132 

 

2 Tue,

10/14

 Project 2,  Lab #2, Pg WD140-WD141

Lab #3, Pg

WD142  

3 Thu,

10/16

 Project 3, Creating a Cover Letter and a Resume , WD 146 to WD 204 

 

3 Tue,

10/21

 Project 3, Lab #1,  Pg WD209-WD210

 Exam I  - Word (based on concepts covered in Labs 1 & 2)

Lab #2,  Pg WD210 WD211

4 Thu,

10/23

 Project 1, Creating a Worksheet and Embedded Chart, EX 1 to EX 69  

 Exam - based on supplementary material                   multiple choice, closed book format

 

4 Tue,

10/28

Project 1, Lab #1  Pg, EX74-EX75

 6 (In Class) & 3 (Home work) Word files are due

Lab #2  Pg, EX75-EX77

 

5 Thu,

10/30

 Project 2, Formulas, Functions, Formatting and Web Queries, EX 81 to EX 144   

 Exam II - Word (based on concepts covered in Labs 2 & 3)

 

5 Tue,

11/04

 Project 2,  Lab #2  Pg, EX149-EX151

Lab #2  Pg, EX151-EX154

6 Thu,

11/06

 Project 3, What-If Analysis, Charting and Working with Large Worksheets, EX 161 to EX 228

 

6 Tue,

11/11

 Project 3,  Lab #1,  Pg EX233-EX235

 Exam I  - Excel (based on concepts covered in Labs 1 & 2)

Lab #2,  Pg EX237-EX241

7 Thu,

11/13

 Excel Practice

 

 

7 Tue,

11/18

 Project 1, Creating and Using a Database, AC 1 to AC 64  

8 Thu,

11/20

 Project 1, Lab#1, Pg AC67-AC68

Exam II  - Excel (based on concepts covered in Labs 2 & 3)

Lab#2, Pg AC68 AC69

8 Tue,

11/25

 Project 2, Querying a Database, AC 73 to AC 119

 

 

 Thu,

11/27

college is closed  

9 Tue,

12/02

 Project 2, Querying a Database, AC 73 to AC 119

 Project 2, Lab#1, Pg AC131-AC132

 6 (In Class) & 3 (Home work) Excel files are due

Lab#2, PgAC132 AC6133

9 Thu,

12/04

 Project 1, Creating and Editing a Presentation, PP 1 to PP 65

 Project 1, Lab #2, Pg PP69-PP71

Lab #2, Pg PP71-PP73

10 Tue,

12/09

 Project 2, Creating a Presentation with Illustrations and Shapes, PP 82 to PP 131

 Project 2,  Lab #1, Pg PP 136

Lab #2, Pg PP 137-PP139

10 Thu

12/11

 

 Exam  - Access (based on concepts covered in Labs 1 & 2) 

Exam  - PowerPoint (based on concepts covered in Labs 1 & 2) 

 
 Tue 12/16 No Class

4 (In Class) & 2 (Home work) Access files are due

4 (In Class) & 2 (Home work) Power Point files are due

 

Thu

12/18

Exam  - PowerPoint (based on concepts covered in Labs 1 & 2)   

 

grade % range
A 90 to 100
B+ 85 to 89.9
B 80 to 84.9
C+ 75 to 79.9
C 70 to 74.9
D 60 to 69.9
F 0 to 59.9

This course is designed to introduce students to microcomputer and various application software associated with Microsoft Office XP with Word 2007, Excel 2007, Access 2007, and PowerPoint 2007. Topics to be discussed include use of the computer and the hardware components of a computer system. Students will receive hands-on experience with word processing, computer graphics, spreadsheets, database management, presentation graphics, disk operating system and the basic use of the Internet.

For full-credit, follow the "file naming conventions carefully" for all files e-mailed to me or handed on flash drives.

1) Project assignments will be email to apieris@raritanval.edu. Name the file with your last name and page number. Ex: Pieris_pg_78.

2) 25% penalty for files not renamed exactly as above.  

The following rules will be strictly imposed during Quizzes / Exams

Cheating of any format is not allowed.  All parties involved in cheating will be dealt with according to the school’s policy on cheating.

1) Do not talk, whisper to anybody or to yourself. Anything you say including "hello" or "good bye" is also considered cheating.

2) After end of each quiz (Word, Excel, Access & PP), e-mail me your work. Make sure I've received it before leaving the class room.

4) No one will be allowed to share textbooks during exams. Every student is responsible for making sure they have a textbook during exams.

 

Other course rules:

1) No electronic devices such as cell phones or mp3 players are not permitted in class. Cell phones must be turned off in class.

2) Homework files must be placed in separate folders. The folders must be renamed with your last name, zipped and e-mailed to me. If the files are e-mailed without being zipped, you will get a zero. Keep the reference of your e-mail in the "Sent Items" as proof that you did e-mailed me.

3) When submitting your work, 25% penalty will be applied per each late class beyond the due date.

4) All quizzes must be e-mailed to me.

5) 5) If you miss more than six classes without prior approval, I will drop you from this class (college policy). Any time you miss a class or leave class early (before 12 pm), I will deduct points from your grade.

6) You must be in for five of the seven exams (10/23, 10/28, 11/18, 12/11 & 12/16).  If you miss any of these five exams without a valid reason such as sickness or death in immediate family, a make up exam will be given with a penalty of 20%.  A make-up exam/s may be given in the form of a closed book "short answer/mcq" exam. 

7) Regardless of the reason, no make up exams are given if you miss Word Exam I and/or Excel Exam I. If you miss Word Exam 1 (10/21), the Word Exam II will weigh 15% and/or if you miss Excel Exam I (11/11),  the Excel Exam II will weigh 15%.    

8) Do not print any material to hand in to me through out the course. Generally avoid print anything unless you absolutely have a need.

9) All work must be completed by 12/16/08.

10) All exams in this course are scheduled as above. Do not follow the official college exam schedule. If there is a conflict with another exam, let me know at least one week in advance.

11) Note: Any portion of the above schedule can change due to any number of reasons. You are responsible for viewing this web site on a daily basis to track announcements/changes.