RARITAN VALLEY COMMUNITY COLLEGE

COMPUTER LITERACY

Prof. J. Sullivan, Ph.D.                                                                                                                                                  Office W 319                                                                          Phone (908) 526 - 1200 x 8237

Fall  2009                                                                                E-mail jsulliva@raritanval.edu                                         

 

COURSE OUTLINE

 

WEEK

CHAPTER

TOPIC

 

1  Week starting
    9/2/09

Introduction - 2007
Outlook Chap. 1
Supplemental Material

Essential Introduction to Computer

E-mail accounts & Navigating the Web with Internet Explorer

Data Representation, Graphics Supplement. 1 & 2

2 
    9/8/09

Office 2007
Supplemental Material

Introduction to Windows Vista

Web & Networking (assignments due different dates)

Page 56 1-5, P 61, P 63, P 64, P 66 1-3, P 67 1-3, P 68, P 69, P 70 1, 1-3, P 71  ( 1 point each to final grade)

WORD-PROCESSING

Microsoft Word 2007

3
    9/15/09  

Supplemental Material
TEST ONE

The Web

On Essential Computer Concepts. Introduction to Windows Vista and Supplemental Material.

Chapter One

Creating and Editing a Word Document

Chapter Two

Creating a Research Paper 

5
    9/22/09

Chapter Three

Lecture

Creating a Creating a Cover Letter and Resume

Creating Web Pages Using Word
Lecture on DTP

6

TEST TWO

WORD, Essential Computer Concepts, Windows, & the Web.

    9/29/09

WORD PROJECT DUE

SPREADSHEETS

Microsoft Excel  -- Introduction by Me

7
    10/6/09

Chapter One

Creating a Worksheet and Embedded Chart

8
    10/13/09

Chapter Two

Formulas, Functions, Formatting, and Web Queries

9
    10/20/09

Chapter Three

Web Feature

What-If Analysis, Charting, and Working with Large Worksheets - Do not read EX 223 to EX 228

Creating Web Pages Using Excel

10 
    10/27/09

TEST THREE
EXCEL PROJECT DUE

EXCEL 2008

POWERPOINT 2008 Chapter One

11
    11/3/09

Chapter Two
Supplemental Material

Creating a Presentation with Illustrations
Audio Page 71, and Video page 86 Putting Youtube into PowerPoint

12
    11 /10/09

Web Feature

TEST FOUR

Creating Web Pages Using PowerPoint

POWERPOINT

POWERPOINT PROJECT DUE

 

13
    11/17/09

DATABASES
Chapter One

ACCESS 2008
Creating and Using a Database

14
    12/1/09

Chapter Two

Querying a Database
OPEN LAB

15  
    12/8/09

16

ACCESS PROJECT DUE

    12/15/09

FINAL EXAM

ACCESS & LITERACY

 

GENERAL INFORMATION

 

1.  Cheating or copying: Any person found cheating or copying will be given a zero for that particular test or project.

 

2.  Grading:                Tests..........…..50%

                                    Projects............50%

 

            Missed Tests: If you are going to miss a test you must let me know before or ahead of time via email or phone.  Otherwise, there will be a 10% penalty on the test.

Reports or Labs:  If you do everything as asked you receive a 90.  To get higher than a 90 you must do more than the assignment requires.

 

3.  Required Materials:

            CD-RW and USB memory stick

            Folder for projects

 

4.  Reports will be accepted up to two (2) weeks late, except for the final report.  The final report will not be accepted after the due date.  Any late reports will be graded and ten (10) percent will be deducted for each week late for day classes (5) percent will be deducted for each class late.  Any reports submitted later than two (2) weeks after the due date will receive a zero.

 

5.   Office Hours: 

Tuesday

Wednesday

9:30 to 10:00 AM

10:00 to 10:30 AM

11:55 to 1:25 PM

Thursday

9:30 to 10:00 AM

3:30 – 4:30 PM

Friday

10:00 to 10:30 AM
11:55 to 1:25 PM

3:30 to 4:30 PM


6.  Cell Phones:  Turn off your cell phones in class.  Every time your cell phone rings a point will be deducted from your final grade point average

 

COURSE DESCRIPTION:

(Prerequisite: Recommend student know how to type) A computer literate person is referred to as one who understands how computers work, uses them, and identifies the role of computers in society.  Students should have a basic understanding of computers and how to access information on the World Wide Web.  Emphasis is placed on the application of microcomputers; the use of productivity software (word processing, spreadsheet management, presentation management, database management, search tools, and multimedia) to gather, analyze, organize, and present information; and the social ethical, and privacy aspects of the impact of computer on society.

 

Students may not enroll for credit in this course if they have earned credit for a higher-level computer science course.  Open lab time required. 

 

COURSE OBJECTIVES:

            1.  To provide the student with an understanding of microcomputer concepts and uses.

            2.  To learn, understand, and use basic Operating System software. 

3.  To learn, understand, and use Graphical User Interface (GUI) software, and understand Common User Interface (CUI) so the skills you learn are transferable. 

            4.  To learn, understand, and use Word Processing software

            5.  To learn, understand, and use Spreadsheet software 

            6.  To learn, understand, and use Relational Data Base Management software.

            7.  To build a working vocabulary of microcomputer terms.

8.  To provide a solid foundation in computer concepts which will enable the student to integrate knowledge gained in other computer and non-computer courses.

9.     To learn, understand, a Multitasking Environment

            10. To learn how to utilize the World Wide Web and e-mail as a resource for this course.

 

TEXT:

G. Shelly, T. Cashman, & M. Vermaat, (2008), Office 2007: Introductory Concepts and Techniques,  Windows Vista Edition, Cambridge, MA: Pub. Course Technology Inc.

 

J. Sullivan, S. Brower, & S. Schwarz, (2009) Computer Literacy Supplement