Prince George’s Community College

Computer Literacy

CIS 101 – FALL 2003

 

Instructor: Sonia Washington                             Reference #: 6339 & 6341

E-mail: swashington@pgcc.edu                       Class Time: 11:00 – 11:50am & 12:00 – 12:50pm

Phone: (301) 322-0098                                          Classroom: Lanham

Office: M2013 inside M2011                                Class Days: MWF

 

Monday

Wednesday

Friday

12:50 – 1:50pm

12:50 – 1:50pm

7:50am – 10:50am

 

 

 

Other Hours By Appointment

 

Department Chair: Prof. Barry Bugg

           

Instructional Dean: Dr. Eric Grosse

 

Prerequisite: Reading Proficiency Level

 

Required Materials:

q       Discovering Computers 2003 Brief, Concepts for a Digital World Web and XP Enhanced By: Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat

q       Microsoft Office XP Brief Concepts and Techniques (Word, Excel, Access, PowerPoint 2002) By: Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat

q       Microsoft Windows XP Brief Concepts & Techniques By: Shelly, Cashman, Forsythe

q       The SAM & TOM Student Tutorial Booklet – with New User Key Code. Keep for future courses.

q       3 ½ Floppy Disk (minimum qty: 6)

q       One Spiral Notebook for CIS 101 Notes

q       Four Folders with two pockets (with FASTENERS - 3 holes)& two number 2 pencils for Concepts Exams

q       Optional: A Student Planner & Pocket Stapler

 

Course Description:

3 Credits.  Prerequisite: Acceptable reading level on the College’s placement test.  Three hours lectures, with an open computer lab for hands-on use of application software.  Also offered in a telecredit format and in an online format.

 

Computer Literacy is a combination of a survey course in computer information systems and a skills development course in Microsoft computer application packages.  Topics in the survey portion of the course include the development of the digital computer, methods of operation (hardware and software concepts), and the role of information technology in business organizations and in modern society.  Topics in the skills portion of the course include the utilization of software tools needed for competent computer use: Windows Operating System, Microsoft Word, Microsoft Excel and the INTERNET.

 

The on-campus computer labs are used by students for exercises and class assignments that are designed to develop competency in the various software packages, prior to testing.  Students are also encouraged to use home systems if software is available.

 

ALL work on the computer should be saved in more than one place!  Please backup your work!!


 

EXPECTED COURSE OUTCOMES

Course Survey Topics:

q       Explain what computers are and how computers work (electronic processing of data into information).

q       Describe basic computer categories, components and concepts (sizes, central processing unit, memory, input/output and data storage).

q       Describe types of computer software (operating systems, utilities, programming languages and, applications) their uses and evolution.

q       Explain the impact (benefits and limitations) of computer technology and information systems on modern society.

q       Explain data security risks and computer viruses.

q       Describe basic hardware, software, and computer work environment risk management strategies.

q       Explain general data communications concepts and the basic principles of connectivity.

q       Describe the structure of the Internet; anticipated Internet evolution (Internet II) and how on-line resources are located.

Software Skills Topics:

Microsoft Windows Operating System Skills:

Microsoft Word Skills:

Microsoft Excel Skills:

q       Use the Taskbar and Desktop icons to access computer resources.

q       Format a 3½ “ floppy disk.

q       Scan disks for viruses.

q       List folders and files on any disk drive attached to a PC or LAN, including filenames, filetypes, file sizes, file creation/modification dates, and attributes.

q       Examine the properties of a file, of a folder and a disk.

q       Open a file from the Windows Explorer or My Computer.

q       Open application programs from the Start menu.

q       Copy and move contiguous as well as non-contiguous files and folders from one disk to another and from one folder to another.

q       Close an application or end a process.

q       Find a file or specific text using Start | Find.

q       Delete files and folders.

 

q       Open, save, print and close Word files.

q       Enter text using wordwrap; edit text efficiently.

q       Select text; use cut, copy, and paste; use bold, italics, and underline.

q       Change typefont and size and color.

q       Change page margins, line spacing, indentation, alignment, and styles.

q       Insert headers, footers, and page numbers.

q       Create, move, and delete footnotes.

q       Save a file under new filename, in a different location, or in a different format.

 

q       Open, save, print, and close Excel files.

q       Identify and describe the basic components of a Microsoft Excel spreadsheet: title bar, menu bar, toolbars, formula bar, status bar, work area, rows, columns, cells, operating modes, values, labels, and formulas.

q       Enter labels, values, and formulas into a spreadsheet.

q       Select cells: use cut, copy, and paste; use bold, italics, and underline.

q       Select columns and rows; change width and height size.

q       Implement common spreadsheet functions such as sum, average, max, and min.

q       Create and print charts in the three basic chart types (line, bar, and pie).

q       Save a file under a new filename in a different location or different format

 

 

A Brief Overview of the CIS 101 Course (Subject to Change):

Each Student will receive a detail schedule for the Fall 2002 Semester!

WEEK

CONCEPT TEXTBOOK TOPICS

MICROSOFT OFFICE XP WORKBOOK TOPICS

TEST/EXAMS/ASSIGNMENTS DUE DATES

1

Course Orientation & Overview

 

 

2/3

Introduction to Computers and Windows

Windows Project

Windows Software Assignment Due

4

The Internet and the World Wide Web (WWW)

On-Line Resources WWW Research & Email

 

5

Application Software & Microsoft Word

MS Word

 

6

Components of the System Unit  & Microsoft Word

MS Word

Concepts Exam #1

7

Input

MS Word

 

8/9

Output & Microsoft Excel

 

MS Excel

MS Word Test – take on your own time

10/11

Storage & Microsoft Excel

MS Excel

Concepts Exam #2

Word Software Assignment Due

12/13

Operating Systems and Utility Programs

 

MS Excel

Excel Software Assignment Due

MS Excel Test – take on your own time

14

Data Security

 

 

15

Future Trends in Technology Wrap-UP & Review

 

Concept Exam #3

Final Exam

Group Presentations

 

 

Computer Purchase Project is due: ________________________

Microsoft Windows, Word & Excel Test must be taken on your own time in Room L-______.

Check the hours on the door.

NO EXCUSES!  NO EXCUSES!  NO EXCUSES!

 

SPECIAL NOTE:

                        1. Microsoft Windows, Word and Excel Test is held in Lanham ____

2. All work should be BACKED UP on diskettes and hard drives.  You don’t want to retype your assignments. 

LAB DAYS: 

 

 


 

 


 

GRADING CRITERIA

Students can earn a possible 1000 points.  Of these, 700 will be consistently earned for every CIS 101 section.  These 700 points will be standard for the entire course.  The other 300 points is based on the Instructor’s Selected Options.

Student’s Performance

Maximum Points

Student’s Points

Windows Software Assignment

30

 

Windows Test - SAM (own time)

100

 

Internet Assignment

50

Text Box: GRADING SCORE
1000 – 900 A
899 – 800 B
799 – 700 C
699 – 600 D
599 – below F
 
 
599 – below F

Word Software Assignment

90

 

Concept Exam # 1 – Ch 1, 8 & 2

100

 

Word Test – SAM (own time)

100

 

Excel Software Assignment (Part A/B)

60

 

Concept Exam # 2 – Ch 4, 3, 5 & 6

100

 

Excel Test – SAM (own time)

100

 

Concept Exam # 3 – Ch 7,9 & 12

100

 

Computer Purchase Project

100

 

Group Presentation

70

 

TOTAL POINTS

1000

 

 

Windows Software Assignment (30 points):

Complete the attached handout and turn it in on time.  No Late work!

 

Internet Assignment (50 points):

Complete the attached handout and turn it in on time.  No Late work!

 

Microsoft Word Assignment (90 points):

Part A:  Create a creative (3 column) brochure on one of the topics assigned by your instructor using Microsoft Word 2000.  You must include the following features: bold, italic, clip art, word art, underline, bullet list, center, borders or text box, 2 different font size and two different font styles.  Use the Spell Check feature too. Part B: Create a resume using Microsoft Word Resume Wizard.  Then, create a job cover letter using the Letter or Professional Wizard.  Print all three documents and save on a diskette.  Turn in the three documents with diskette in a two-pocket folder.

 

Microsoft Excel Assignment (60 points):

Office 2000 Book – Part A: Do page E1.06 – E1.53 Turn in your printouts and diskette.

                               Part B: Do page E2.04 – E2.57 Turn in your printouts and diskette.

 

All work must be in a two-pocket folder.

 

All Assignments are due the beginning of each class. 
NO Excuses!

 

 

 

 

 


 

The students conduct the STUDENT REVIEWS.  All students will provide 5 questions and answers from each chapter (using the class notes as a guide) and a selected student will conduct the review.  Some students play Jeopardy using the computer concepts.  The choice is up to you.  The instructor needs to view the material before the review.  All typed Review Questions and Answers are due the class before the Review.

 

 

 

 

 

Group PresentationsYou will form a group of 4-5 students (depends on the size of the class) to create another Brochure using Microsoft Word 2000.  Each brochure must include the features, advantages, disadvantages, manufacturers names, best 10 popular names, and costs.  Each group must have a creative brochure and presentation. 

Topics:

q       How to purchase a Digital Camera? Scanner? Printer?

If for any reason, a student withdraws from the class, the other students in the group must finish the project.  Each student is graded as a team.  Each group will discuss their skills and assign different tasks with deadlines to each person in the group.  The tasks consist of roles such as Editor/writer, Microsoft Word features producer, and Computer graphics.  If for any reason a member is not doing any work, this may cause that student to receive a zero for the project.  Turn in the following: Diskette and Brochure in a two-pocket folder.

 

Grading Criteria for Group Presentations

Grading Items

Earned Points

Length of Presentation – at least 5-7 minutes

5 points

State your topic and purpose of the Brochure

5 points

Research Methods

5 points

Findings (explaining the information in brochure)

5 points

Creative Presentation

20 points

Creative Brochure

10 points

Obstacles

5 points

Lesson Learned

5 points

Speaking clearly and maintain eye contact

5 points

Dress Professional – NO Sneakers, jeans, shorts, sleeveless shirts, and hats

5 points

EXTRA CREDIT!Total Points:

70 points

 

 

 

 

Extra Credit is to help increase your grade where you may have fallen short on an assignment or exam.  It is recommended that each student perform the following tasks:

Each student will be assigned to a group before each Concept Exam.  Each group will earn points from different review activities in the class.  The more you do your work the better off the group is as a whole.  Those students who miss class regularly can hurt the group points.  Attendance is key.  At the end of the semester the points will be calculated and finalized with a point system.  Each student will be able to add points to their final grade.  Everyone in that group will get the same points.  We should all work together.  RECOMMENDATION: Students should study in groups and alone for exams on your own time.  Exchange numbers and work together.  We can all learn from one another.

IMPORTANT DATES

Aug 25, 2003

Classes Begin – Fall 2003

Aug 30 – Sept 1

College Closed – Labor Day

Oct 3, 2003

Last Day to withdraw from 1st half-semester classes

Oct 13, 2003

Last Day to change from “credit” to “audit” or from “audit” to “credit” for 16 week classes

Oct 15, 2003

Midterm/End of 1st half-semester classes

Oct 16, 2003

Beginning of 2nd half-semester classes

Oct 17, 2003

End of late registration for 2nd half semester classes

Oct 29, 2003

Professional Development Day – No Classes

Nov 21, 2003

Last day to withdraw from 15-week classes

Nov27 – Nov30

College Closed – Thanksgiving Vacation

Dec 8-14, 2003

Final Examination period/last week of classes


 

 

CIS 101 - GENERAL CLASS POLICIES

 


 

ATTENDANCE:

·         You are expected to attend each class and be ON TIME.  The first 15 minutes and last 15 minutes is the most important time of the class.  It is your responsibility to get the missing notes from a classmate.

·         Absences with a written medical, judicial or occupation excuse will be counted as attendance.   The official documentation is due the next class you attend or your excuse will be counted as unexcused.

 

BOOKSTORE HOURS:

·         Aug 25-29; 8:30am – 9pm (Mon.-Thurs.); 8:30am –7pm (Fri.) Sept 2-5; 9am-8pm (Tues.-Thurs.) 9am-7pm (Fri.).

 

CHEATING:

·         Any student caught looking at someone else’s exam or cheating in any way will receive a zero (0) for that exam/assignment.

 

COMMON COURTESY:

·         You are expected to be quiet while the lecture is in progress, as well as when another student is participating in the classroom discussion.  Also, if you come late or leave early, please do so quietly. Do Not “POP” GUM in Class.

 

COLLEGE POLICY:

·         Smoking is prohibited in all buildings on campus.

·         Prince George’s Community College is committed to a policy of reasonable accommodation and services to persons with disabilities.  In order to receive services, students with disabilities must register with the Disability Support Services.  Call between 8:30 and 4:30 pm, Monday through Friday, 301-322-0838 to schedule an appointment.

 

OPEN COMPUTER LABS:

·         Accokeek Microcomputer Lab & Lanham Room 112 Lab is available to all students. Windows, Word & Excel Test in Lanham _____.

·         All students MUST have diskettes with labels during the Lab sessions.

 

WEATHER:.

·         The following radio and television stations are notified and carry the announcements regarding college closings or delayed openings: TV channels 4, 5, 7, 9, WMAL, WPGC, WASH, WRC, WTOP, WGAY, WAVA, WHUR, and WKYS. 

 

ASSIGNMENTS:

·         All written assignments must be typed and hand-in on time.  Otherwise, you will receive a ZERO.

·         All assignments must be backed up on at least two diskettes.  NO EXCUSES when the assignment is DUE.

·         If you are absent from class, you will be held responsible for all material covered and assignments DUE.  No Assignments will be accepted after the due date.  (Automatic zero for that assignment)

·         An exam can be taken early if necessary.  However, there will be no make-up exams.  If you miss an exam the next exam will be counted double.  You must take the last exam. 

·         Three non-cumulative exams will be given from the Computer Concepts textbook (Format options: multiple choice, true-false, matching, fill in the blanks, essays and/or short answers).  Don’t ask the instructor for a pencil because you are always prepared for class.

·         You are at risk if you print out your assignments the day before it is DUE.  Problems do occur.  Printers! Computers! Diskettes! This is a warning!  Remember – NO EXCUSES! Assignments can be turned in early

·         Any assignment or note that is placed in my mailbox must be signed and dated by the Department Secretary (time must be included).  Do not slide any items under any office door.

·         All diskettes must have a label on it with your name, class, reference number, and semester/year.

 

 

OTHER RULES:

·         All students will participant in class (individual & group work).

·         No food, music playing, smoking, profanity, loud conversations, and visitors. 

·         Tape recorders may be used for recording lectures only.

·         Cell phones, pagers and watch alarms must be non-audible.

·         A FREE PGCC Student Handbook can be picked up at the College Life Office in Largo Student Center (near the Bookstore).

SAVE all your work in two different places!(BACKUP)