Prince George

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.

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
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.

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.

You 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
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:

Attend all classes
Do all assignments and turn in on time
Practice hands-on assignments and study the concepts daily

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 1^st 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 1^st half-semester classes
Oct 16, 2003	Beginning of 2^nd half-semester classes
Oct 17, 2003	End of late registration for 2^nd 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

· 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.

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

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

· 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.

· 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.

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

· 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.

· 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.

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

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

Other Hours By Appointment

EXPECTED COURSE OUTCOMES

Course Survey Topics:

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

WEEK

MS Word Test – take on your own time

Computer Purchase Project is due: ________________________

GRADING CRITERIA

TOTAL POINTS

Grading Criteria for Group Presentations

IMPORTANT DATES

Aug 30 – Sept 1

College Closed – Labor Day

Oct 29, 2003

Professional Development Day – No Classes

Dec 8-14, 2003

Final Examination period/last week of classes