CISY 102 - Computer Literacy

Course Syllabus – Spring 2009

CRN - 20214 - Section - 53X
 

 

 

 

Room:

Monday 05:30 PM-09:20 PM West Building W306

 

 

 

Book:


Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat
ISBN 13: 978-1-4239-1228-6 © 2008
ISBN 10: 1-4239-1228-4
Publish date: April 24, 2007
1216 pages
Softcover
 

 

 

 

Supplement:

Computer Literacy Supplement

Dr John Sullivan
Prof Stephen Brower
Prof Stephen Schwarz   

 

 

 

Instructor:

Mr. John M. Wong
E-Mail: jwong@raritanval.edu

 

 

 

Web Site:

http://www.raritanval.edu/departments/cis/part-time/jwong
(Or from school’s web site, Pick Academic Departments, then Computer Science, click Faculty then click John Wong)

 

 

 

Office Hours:

 

By appointment

 

 

 

Course Overview:

This course is designed to introduce students to microcomputer and various application software.  Topics to be discussed include the 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, disk operating system and the use of the internet.

Course Routine:

The class will be separated into a lecture and Lab.

The lecture will be from the Office book as well as some other topics.

The in-class lab problems are assigned almost every night. You are strongly encouraged to work on the labs in the lab with the instructor questions in case you have questions.

The instructor would like to grade the lab and provide feedback prior to the next class.

Please check the schedule below for any deviations from this routine (Such as exams).

In-Class Labs

The intention of the in-class labs is to provide you with practice for the material that was covered in class. The hope is that you stay and work on the labs while the instructor is there so that you may ask questions.

The In-Class assignments must be completed either on campus or at home. If you choose to work at home, please e-mail the work as attachments to the instructor by Saturday so that feedback can be provided by Monday.

 Exams

Exams are open note / open book / open computer (e-mail and instant messaging are excluded).

The format of the exam is similar to the in-class labs

Cheating Policy

You must work alone on the Projects and In-Class Assignments. Working with someone is considered cheating. Taking a file that someone else created is considered cheating. Having your neighbor work on your computer is considered cheating. Cheating is not allowed.

Cheating is also not allowed on Exams. If you have questions during an exam ask the instructor.

All parties involved in cheating (including the one who shares) will be dealt with according to the school’s policy on cheating. The penalty can range from 0 on the assignment to F for the course.

Attendance Policy

Attendance will be taken at the beginning of the class. If you are late it is your responsibility to see the instructor and ask to be marked as present. If the instructor is lecturing, please wait until the break.

What everything is worth...

Item

Percent

In-Class Lab Assignments

35

Tests

35

Final Exam

30

 

Grades

% Range

A

90-100

B+

87-89.9

B

80-86.9

C+

77-79.9

C

70-76.9

D

60-69.9

F

0-59.9


Class Schedule (check website for latest changes)

Week #

Week Of
(Monday)

Topic

Readings

Work Due

1

1/26/2009

Introduction 
Course Overview
Introduction to Computers 
Windows Vista

COM 1-38

 

2

2/2/2009

Windows Vista       
Microsoft Outlook Web Access   
Computer Literacy Supplement    

Data Representation 

WIN 1-66
Supplement:
Data Representation 

 

3

2/9/2009

Microsoft Word  Chapter 1
Creating A Flier
Computer Literacy Supplement    

Networking

WD 1-62

 Lab1  WD 67

4

2/16/2009

Word Chapter 2          
Research Paper               

WD 73-132

 Lab2  WD 140

5

2/23/2009

Word Chapter 3       
Resume and Cover Letter   

WD 145-223

 Lab1 WD 209-210

6

3/2/2009

Excel  Chapter 1   
Worksheet with Embedded Chart       
Word Test

EX 2-69

 Lab1 EX   74 - 75

7

3/9/2009

NO CLASS - SPRING BREAK

 

 

8

3/16/2009

Excel Chapter 2              
Formulas, Functions and Formatting

EX 82-144

 Lab1 EX 149-151

9

3/24/2008

Excel Chapter 3   
What if Analysis, Charting  
Excel Web Feature   
Creating Web Pages using Excel

EX 162-228
EX 250-261

 Lab3 Ex 241-244

10

3/30/2009

PowerPoint Chapter 1  
Creating and Editing a Presentation 
Excel Test

PPT  1-65

 Lab3 PPT 74- 77

11

4/6/2009

PowerPoint Chapter 2  
Creating a Presentation with Illustrations  
PowerPoint Web Feature

PPT  82-131

 Lab2 PPT 137-139
 Lab2 PPT  159

12

4/13/2009

PowerPoint Test 

PowerPoint Presentations

Study for Test

 

12

4/20/2009

Access Database  Chapter 1
Creating and Using a Database

AC 1-64

 Lab2 AC 68-69

13

4/27/2009

Access Database  Chapter 2   
Querying a Database

AC 74- 127

 Lab2 AC 132-133

14

5/4/2009

TBD

 

 

Final

5/11/2009

Final Exam (5:30 - 7:30)