CISY 261 Microcomputer Applications / Fall 2008 / Monday & Wednesday
Prerequisite: Computer Literacy or equivalent.
| Date | Lecturer and / or In-Class Labs | Home Work Labs. |
|
1 Wed, 09/03 |
Word Chapter 5: Productivity Tools: Templates, Themes, and Mail Merge |
|
|
1 Mon, 09/08 |
Word Chapter 5: Hands-on Exercises |
Exercise 4, Pg 44 |
|
2 Wed, 09/10 |
Word Chapter 6: Desktop Publishing |
|
|
2 Mon, 09/15 |
Word Chapter 6: Hands-on Exercises |
Exercise 2, Pg 97-98 |
|
3 Wed, 09/17 |
Word Chapter7: Forms and Protection | |
|
3 Mon, 09/22 |
Word Chapter 7:
Hands-on Exercises
Exam I - Word 2007 |
Exercise 1, Pg 150-151 |
|
4 Wed, 09/24 |
Excel Chapter 5: Data to Information |
|
|
4 Mon, 09/29 |
Excel Chapter 5:
Hands-on Exercises
11, (In Class) & 4 (Home work) Word files are due |
Exercise 2, Pg 277-278 |
|
5 Wed, 10/01 |
Exam II - Word 2007 |
|
|
5 Mon, 10/06 |
Excel Chapter 6: Data Tables and Amortization Tables |
|
|
6 Wed, 10/08 |
Excel Chapter 6: Hands-on Exercises |
Exercise 3, Pg 338-339 |
|
6 Mon, 10/13 |
Excel Chapter 7: Data Consolidation |
|
|
7 Wed, 10/15 |
Excel Chapter 7: Hands-on Exercises |
Exercise 1, Pg 399-400 |
|
7 Mon, 10/20 |
Exam I - Excel 2007 | |
|
8 Wed, 10/22 |
Excel Chapter 8: What IF Analysis |
|
|
8 Mon, 10/27 |
Excel Chapter 8: Hands-on Exercises | Exercise 4, Pg 460-461 |
|
9 Wed, 10/29 |
Excel Practice |
|
|
9 Mon, 11/03 |
Exam II - Excel 2007 3 (In Class) & 3 (Home work) Excel files are due |
|
|
10 Wed, 11/05 |
Access Chapter 6: Data Protection: Integrity, Validation, and Reliability | |
|
10 Mon, 11/10 |
Access Chapter 6: Hands-on Exercises
|
Exercise 4, Pg 716-717 |
|
11 Wed, 11/12 |
Access Chapter 7: Advanced Queries |
|
|
11Mon, 11/17 |
Access Chapter 7: Hands-on Exercises |
Exercise 3, Pg 784-785 |
|
Wed, 11/19 |
Access Practice |
|
|
12 Mon, 11/24 |
Exam - Access 2007 | |
|
12 Wed, 11/26 |
No class. | |
|
13 Mon, 12/01 |
PowerPoint Chapter 5: Charts and Graphs PowerPoint Chapter 5: Hands-on Exercises 3 (In Class) & 3 (Home work) Access files are due |
Exercise 2, Pg 1024-1025 |
|
13 Wed, 12/03 |
PowerPoint Chapter 6: Presentation Customization |
|
|
14Mon, 12/08 |
PowerPoint Chapter 6: Hands-on Exercises |
Exercise 2 on Pg 1100-1101 |
|
14 Wed 12/10 |
3, (In Class) & 3 (Home work) Power Point files are due |
|
|
15 Mon 12/15 |
PP 2007 Exam
|
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) When you are completed with a quiz /exam, handed / e-mail and turn off any web browsers. You may remain in the room at my discretion.
3) After end of each Exam (Word, Excel, Access & PP), e-mail me your work. Make sure I've received it before leaving the class room.
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) All exams must be e-mailed to me.
4) When submitting your work, 25% penalty will be applied per each late class beyond the due date.
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 3pm), I will deduct points from your grade.
6) You must be in for all exams on the following dates (10/01, 11/03, 11/24 & 12/15). If you miss an exam without a valid reason such as sickness or death in immediate family, a make up exam will be given with a penalty of 20%.
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 (09/22), the Word Exam II will weigh 25% and/or if you miss Excel Exam I (10/20), the Excel Exam II will weigh 30%.
8) 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.
9) In the event if a scheduled lab is completed early, work on the corresponding home work labs. If the home work labs are completed, work on the next class lab.
10) Do not print any material to hand in to me through out the course. Generally avoid print anything unless you absolutely have a need.
11) All work must be completed by 12/15/08.
12) 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.
Text: Microsoft Office 2007, Volume II, Grauer & Barber ISBN: 0-13-613037-6
Course Description: Applications of microcomputer software to solve problems. The software packages studied are: text processing, spreadsheet, data base and graphics. Students will acquire "hands on" experience in the use and application of the packages using state-of-the-art microcomputers. Hands-on training in software application programs includes word processing, spreadsheet, and database. Assignments will include problem solving and critical thinking development components.