CISY 102, Computer Literacy / Fall 2008 (Mon and Wed)
Web Site for the Text book: http://www.course.com/catalog/product.cfm?isbn=978-1-4239-1228-6&CFID=6031619&CFTOKEN=86546813
|
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 Wed, 09/03 |
Introduction, E-Mail and Contact |
|
|
1 Mon, 09/08 |
Graphics
Supplement 1 |
|
|
2 Wed, 09/10 |
Project 1, Creating and Editing a Word Document, WD
2 to WD 62 |
|
|
2 Mon, 09/15 |
Graphics
Supplement 1 Supplement on Data Representation and Networking |
|
|
3 Wed, 09/17 |
Project 1, Lab #2, Pg WD 69 WD70 |
Lab #3, Pg WD 70 WD71 |
|
3 Mon, 09/22 |
Graphics
Supplement 1 Supplement on Data Representation and Networking |
|
|
4 Wed, 09/24 |
Project 2, Creating a Research Paper, WD 73 to WD 132 | |
|
4 Mon, 09/29 |
Exam - based on supplementary material multiple choice, closed book format |
|
|
5 Wed, 10/01 |
Project 2, Lab #2, Pg WD140-WD141 |
Lab #3, Pg WD142 |
|
5 Mon, 10/06 |
Project 3, Creating a Cover Letter and a Resume ,
WD 146 to WD 204
Exam I - Word (based on concepts covered in Labs 1 & 2) |
|
|
6 Wed, 10/08 |
Project 3, Lab #1, Pg WD209-WD210 | Lab #2, Pg WD210 WD211 |
|
6 Mon, 10/13 |
6 (In Class) &
3 (Home work)
Word files are due Project 1, Creating a Worksheet and Embedded Chart, EX 1 to EX 69 |
|
|
7 Wed, 10/15 |
Exam II - Word (based on concepts covered in Labs 2 & 3) | |
|
7 Mon, 10/20 |
Project 1, Lab #1 Pg, EX74-EX75 | Lab #2 Pg, EX75-EX77 |
|
8 Wed, 10/22 |
Project 2, Formulas, Functions, Formatting and Web Queries, EX 81 to EX 144 |
|
|
8 Mon, 10/27 |
Project 2, Lab #2 Pg, EX149-EX151 |
Lab #2 Pg, EX151-EX154 |
|
9 Wed, 10/29 |
Project 3, What-If Analysis, Charting and Working with Large Worksheets, EX 161 to EX 228 |
|
|
9 Mon, 11/03 |
Project 3, What-If Analysis, Charting and Working with Large Worksheets, EX 161 to EX 228 |
|
|
10 Wed, 11/05 |
Project 3, Lab #1, Pg EX233-EX235 | Lab #2, Pg EX237-EX241 |
|
10 Mon, 11/10 |
Excel Practice | |
|
11 Wed, 11/12 |
Project 1, Creating and Using a Database, AC 1 to AC 64
|
|
|
11Mon, 11/17 |
Project 1, Lab#1, Pg AC67-AC68 | Lab#2, Pg AC68 AC69 |
|
Wed, 11/19 |
|
|
|
12 Mon, 11/24 |
Project 2, Querying a Database, AC 73 to AC 119 |
|
|
12 Wed, 11/26 |
School closed | |
|
13 Mon, 12/01 |
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 |
|
13 Wed, 12/03 |
Project 1,
Creating and Editing a Presentation, PP 1 to PP 65 Project 1, Lab #2, Pg PP69-PP71 |
Lab #2, Pg PP71-PP73 |
|
14Mon, 12/08 |
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 |
|
14 Wed 12/10
|
Exam - Access (based on concepts covered in Labs 1) Exam - PowerPoint (based on concepts covered in Labs 1 & 2) |
|
| 15 Mon 12/15 |
Exam
- PowerPoint
(based on concepts covered in Labs 1 & 2) 4 (In Class) & 2 (Home work) Access files are due 4 (In Class) & 2 (Home work) Power Point files are due |
| 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 (09/29, 10/15, 11/19, 12/10 & 12/15). 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/06), the Word Exam II will weigh 15% and/or if you miss Excel Exam I (11/03), 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/15/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.