Calumet College of Saint Joseph

Syllabus for Computer Literacy

TERM: Spring 03 (20022) COURSE NUMBER: CIS115B

INSTRUCTOR: Charlie Myers OFFICE: 414

PHONE: (219) 473-4367 CREDITS: 3

OFFICE HOURS: Monday ~ Friday 8AM to 4PM E-MAIL: cmyers@ccsj.edu

INSTRUCTOR BACKGROUND:

EDUCATION: AS, BS in Computer Information Systems, Calumet College of St. Joseph;

MA LS, Valparaiso University

Certifications/Licenses: Microsoft MCSE, COMPTIA A+ , Network+, Security+

FCC Radio Telecommunications Engineering License

EXPERIENCE: College Level Teaching of Computers and Electronics – 14 yrs

Technical Employment In Telecommunications, Networking, & Hardware – 20 years

CURRENTLY: Full-time – Assistant Director of Computer Services at CCSJ

Part-time – Instructor in CIS and History

COURSE TIME: Wednesdays, 1:00 PM to 4:00 PM, January 8 thru April 16, 2003 in LAB 418

PREREQUISITES: None

COURSE DESCRIPTION: The course introduces the student to computer and information systems. Topics include computer hardware, software, and the Internet. Microsoft Office will be used to introduce students to the fundamentals of word processing, spreadsheets, databases, and presentation software.

COURSE COMPETENCIES: The course will consist of three modules, each built around a central theme (i.e., hardware, software, networks, etc.)and designed to provide the successful student with skills necessary to use computers during their academic and professional careers. A module will consist of lectures, presentations, discussions, and hands-on computer projects. Each module concludes with a production (hands-on ) examination which requires the student to use the skills he/she has learned and thus demonstrate proficiency. The skills and competencies are listed separately on each module’s outline and collectively at the end of this syllabus.

TEXTBOOK(S): Microsoft Windows 98: Introductory Concepts and Techniques; Shelly, Cashman, and

Forsythe; Course Technology, MA; 1999.

Microsoft Office 2000: Essential Concepts and Techniques; Shelly, Cashman, and

Vermaat; Course Technology, MA; 1999.

Microsoft Internet Explorer 6: Introductory Concepts and Techniques; Shelly, Cashman.

and Forsythe; Course Technology, MA; 2002.

MATERIALS: One 3.5 inch floppy disk for storing work and projects

Pen/pencil and paper for note-taking and project outlines

OTHER: Module outlines will be handed out at the beginning of each module. Each outline will present a week-by-week schedule of requirements and activities, (i.e., topics, lectures, reading, texts, projects, and exams.)

Center for Academic Excellence: Tutoring assistance is free to all students of CCSJ. Call the CAE office to make an appointment (473-4287). The Center has experienced and well-trained tutors in most subject areas to help students who are struggling in a course or who are doing well and would like to do better.

ASSESSMENT: Final Grade is computed using a combination of exam scores and hands-on projects.

Module One Exam 100 pts Projects 75 pts

Module Two Exam 100 pts Projects 100 pts

Module Three Exam 100 pts Projects 75 pts

Total Possible Exam Pts 300

Total Possible Project Pts 250

Total Pts Possible for the Course : 550

Letter Grades are based upon the percentage of the total possible points a student earns, ie:

A 90% -100% at least 495pts

A- 88% - 89% 484pts

B+ 86% - 87% 473pts

B 83% - 85% 466pts

B- 80% - 82% 440pts

C+ 76% - 79% 418pts

C 73% - 75% 401pts

C- 70% - 72% 385pts

D 60% - 69% 330pts

F 0% - 59% 329pts or less

COURSE POLICIES:

Missed Exams - The lab will be available for missed exams ONLY during finals week.

Anyone who needs to make-up an exam must be in class at that time.

Make-up exams are not an entitlement.

Missed Projects – Projects are due by the end of the week, (Friday). Generally there is time

to complete them in class. Projects turned in one week late will receive a 10%

point deduction. Projects more than one week late receive zero points.

Attendance - Experience has shown that poor attendance will most often result in missed assignments,

missed exams, lower grades, and/or failure..

COLLEGE POLICIES:

Statement of Plagiarism – If an instructor or other CCSJ personnel find that a student has plagiarized or been involved in another form of academic dishonesty, the instructor or other personnel may elect to bring the matter up for judicial review. The maximum penalty for any form of academic dishonesty is dismissal from the College. The procedures for judicial review are listed under the section of the CCSJ handbook that addresses student grievances. (Academic Planner 2002/2003)

Withdrawal From Class – After the last day for class changes has passed, (see Academic Calendar), students may withdraw from a course with permission of the instructor. A written request detailing the reason(s) for the withdrawal must be filed with the Registrar. The Registrar must receive a written request for withdrawal by the last day of class prior to the final examination dates specified in the catalogue. Written requests may be mailed or faxed to the Registrar. Students are to make note of the refund schedule when withdrawing from courses. The request is forwarded from the Registrar to the faculty member who makes the final determination to accept or deny the request. If the request is honored, the student will receive notification of official withdrawal; if denied, the notification will indicate why the withdrawal was disallowed. Note: Degree Completion Division (DCD) students should consult the DCD Student Handbook for information on DCD withdrawals.

MODULE I - Computer Concepts

Module Description: The student is introduced to basic computer operations and terminology, including hardware, peripheral devices, binary numbers, digital devices, and operating systems

Module Competencies: Upon the successful completion of this module, the student will be able to:

1. Describe the data-processing cycle

2. Describe and use primary and secondary data storage devices

3. Use a mouse to select, drag, copy, and move objects

4. Use a keyboard to input data

5. Use a printer and monitor to output data

6. Use the Windows 98 operating system to input, modify, store, and output basic text documents

7. Communicate with Windows prompts, menus, wizards, and help interfaces

8. Define the basic function of input, output, storage, and peripheral hardware

9. Define the functions of Operating System software

10. Open, close, arrange, re-size, and switch between windows

Text and materials: CIS115 – Computer Concepts (Handout), Windows 98 Introductory Concepts and Techniques(text), note-taking materials, one 3.5” floppy disk.

Week by week breakdown: (Lectures, Demonstrations, Handouts, Projects)

Week 1 (1/8) Orientation

Week 2 (1/15) Hardware Concepts, Read Computer Concepts handout, Complete: Hardware Project 10pts

Week 3 (1/22) Windows 98, Read Projects 1-2, Complete: Projects1and 2, Project 2 Lab #2 (pg 2.73) 30 pts

Week 4 (1/29) Windows 98, Read Project 3, Complete: Project 3, Project 3 Lab #2 (pg 3.60) 35 pts;

Review for Module I exam

Week 5 ( 2/5) Module I exam, 100pts

IMPORTANT: Make sure your name is on your floppy disk and any printouts that you turn in!

MODULE II - Application Software

Module Description: This module introduces the student to modern applications software and its use in the academic and professional environment. The student will use four software packages and complete word-processing, spreadsheet, database, and graphics projects.

Module Competencies: Upon the successful completion of this module, the student will be able to:

1. Use the Windows GUI to start applications programs

2. Identify word processing document types (i.e., letter, resume, report, list, etc.)

3. Enter, delete, paste, modify, and format document text using MS WORD

4. Save, delete, modify, rename, move, and copy document files

5. Print word processing documents in standard or landscape format

6. Identify different types of spreadsheet files (i.e., tables, lists, budgets, charts, graphs, etc.)

7. Create and edit basic spreadsheets using a professional program such as EXCEL

8. Use spreadsheet formulas and auto-calculation features

9. Print spreadsheets in standard or landscape format

10. Identify features of and uses for database programs

11. Identify the basic components and terms of a database (i..e., records, tables, keys, indexes, etc.)

12. Create a simple database using MS ACCESS

13. Enter, edit, sort, and delete data and records

14. Query and locate specific data or records in a database

15. Print simple reports using database print/report options

16. Identify the features of and uses for the MS Powerpoint program

17. Create and organize graphics and text onto slides

18. Use the Powerpoint program to display a automated slide show

19. Edit and reorganize slides

20. Print slides, slideshow notes, and handouts

Text and materials: Office 2000: Essential Concepts and Techniques (text), note-taking materials,

one 3.5” floppy disk.

Week by week breakdown: (Lectures, Demonstrations, Handouts, Projects)

Week 6 (2/12) Word Processing

Week 7 (2/19) Spreadsheets

Week 8 (2/26) Databases

Week 9 (3/5) Powerpoint

Review for Module II exam

Week 10 ( 3/12) Module II exam, 100pts

IMPORTANT: Make sure your name is on your floppy disk and any printouts that you turn in!

MODULE III - Networks, the Internet, and Email

Module Description: This module presents the basic operations, uses, and advantages of networked computers. Network terminology, applications, and equipment are discussed. Operation of the Internet World Wide Web is discussed along with explanations of the structure of web pages, file transferring, and internet site addressing. The use of internet resources which aid in academic research are practiced. Finally, the student is introduced to additional network applications which have become commonplace as the result of networks and the WWW, such as Email and Online Learning

Module Competencies: Upon the successful completion of this module, the student will be able to:

1. Identify the advantages of networked vs stand-alone computer systems

2. Define common network terms

3. Identify various types of basic network hardware

4. Explain the origins and recent development of the “Internet”

5. Explain the basic construction of the “Internet”

6. Utilize the Internet Explorer web browser to locate specific internet addresses

7. Use the web browser to access search engines to locate information

8. Conduct basic research using internet tools and resources

9. Use a web browser to save web pages and graphics

10. Print Internet web pages

11. Explain the process by which internet messaging is accomplished (i.e., email and MSN)

12. Create, modify, and send Email messages

13. Download, save, and print email messages.

14. Send email to multiple recipients

15. Forward a email to another recipient

16. Access online courses (Blackboard)

Text and materials: Internet Explorer 6: Introductory Concepts and Techniques (text), note-taking materials, one 3.5” floppy disk.

Week by week breakdown: (Lectures, Demonstrations, Handouts, Projects)

Week 11 (3/19) Networks

Week 12 (3/26) Internet

Week 13 (4/2) Email, Blackboard, Review for Module III

Week 14 ( 4/9) Module III exam

IMPORTANT: Make sure your name is on your floppy disk and any printouts that you turn in!