SADDLEBACKCOLLEGE
BUSINESS SCIENCE DIVISION
COURSE SYLLABUS
CIM 1 - INTRODUCTION TO COMPUTER INFORMATION SYSTEMS
8/22/05 to 12/18/05Instructor: / Rae Fisher / Semester: / Fall 2005
Phone: / 582-4904 / Ticket #: / 19450Monday, 7-10 p.m.
Email: / / Room: / BGS 205-2
COURSE DESCRIPTION:
Basic computer concepts including computer system components, operating systems, application programs, databases, communication networks, business information systems development, ethical issues, and Internet usage. Emphasizes spreadsheets, entering data, using formulas, creating charts, formatting worksheets, using functions, what-if analysis, absolute vs. relative addresses, and linking worksheets. Focuses on database software; entering and editing data; defining fields; creating tables, forms, queries, and reports; and sorting data. Exposes students to word processing and presentation graphics software. May be offered by mediated mode of instruction.
COURSE OBJECTIVES:
Upon completion of this course, the student will be able to:
1.Define terms that are unique to the field of computers and information systems.
2.Describe the functions and uses of the hardware and software comprising a computer system.
3.Describe the Information Systems Development process.
4.Describe computer ethics, crime, and security.
5.Demonstrate the ability to interface with an operating system by:
a.Loading two or more application programs into main memory, and switching from one application program to the other.
b.Moving and re-sizing windows.
c.Opening windows such as Date/Time, Printers, and Display, and performing such operations as changing the date and time, changing the assigned printer, and creating a screen saver.
d.Creating folders and moving files from one folder to another.
e.Copying, re-naming, and deleting files.
6.Demonstrate the ability to utilize a word processing program by:
a.Creating such documents as business letters and reports.
b.Saving and printing copies of documents.
c.Using a spell checker.
d.Selecting, inserting, and deleting text and objects.
e.Formatting text.
7.Demonstrate the ability to utilize a spreadsheet program by:
a.Creating spreadsheets utilizing formulas to make calculations.
b.Saving and printing spreadsheets.
c.Loading existing spreadsheets, revising the data, and re-saving them as separate spreadsheets.
d.Formatting spreadsheets.
e.Using the AutoSum and AutoFill features.
f.Creating Line Charts, Pie Charts, and Column Charts.
g.Using the Hide and UnHide tools to Hide, and then UnHide, rows and columns.
h.Using the Function feature to calculate such statistics as Sum, Average, Maximum, and Minimum for a range of values.
i.Using the Copy-and-Paste feature to insert a spreadsheet and chart in a word processing document.
j.Using the Embedding feature to link a spreadsheet and chart with a word processing document.
k.Describing the difference between an Absolute vs Relative cell reference.
l.Copying, pasting, inserting, and deleting data.
8.Demonstrate the ability to utilize a database management program by:
a.Creating databases.
b.Creating tables in databases.
c.Designating Primary Key fields in tables.
d.Saving and printing tables.
e.Sorting data in tables.
f.Creating forms.
g.Creating queries.
h.Creating compound queries.
i.Creating reports.
j.Creating mailing labels.
k.Joining tables and querying joined tables.
9.Demonstrate the ability to utilize a presentation graphics program by:
a.Creating slides containing text, charts, and images.
b.Printing slides and handouts.
10.Demonstrate the ability to utilize the Internet by:
a.Using a browser to open Web pages having known Uniform Resource Locators (URL's).
b.Using a search engine to locate web pages when no specific URL is known.
c.Creating and sending e-mail.
11.Compile a portfolio of hands-on computer laboratory assignments.
STUDENT RESOURCES (PURCHASE IN BOOKSTORE):
TEXTBOOK PACKET (SaddlebackCollegeBundle ISBN 1418821950):19450—BGS 205-2, Monday
Discovering Computers, Fundamentals Second Edition, Shelly/Cashman/Vermaat; Course Technology 2005, ISBN 0-619-25509-9
Microsoft Office 2003, (SaddlebackCollegeCustom Edition), Shelly/Cashman/Vermaat, Course Technology, 2006
Microsoft Office Excel 2003, Complete Edition, Shelly/Cashman/Vermaat, Course Technology, 2006,ISBN 1-4188-4359-8
One USB flash disk or three 3 1/2” High Density Disks (One for Word\Excel, one for Access, one for PowerPoint) and a pencil.
POLICIES AND PROCEDURES:
Tests and Exercises: There will be several tests and a final. Each exam will cover only material presented since the last test. Written tests are multiple-choice and true-false. SCANTRON Test Form and a pencil must be used for all written tests—bent or wrinkled forms will not be accepted. If homework is not turned in at the beginning of class, it is considered late.
FINAL EXAMINATION is on Monday, December, 12, 2005.
MISSED TESTS: MAKE UP TESTS ARE NOT GIVEN. If you need to miss a test, please make arrangements to take the test before it is given in class.
ATTENDANCE: Regular attendance is expected. Roll will be taken in each class meeting. You may be dropped from a course after 6 hours (two class meetings) of non-attendance. It is the responsibility of non-attending students to officially withdraw from classes; failure to do so will result in a course grade of F. Various handouts are distributed throughout the semester--should you be absent, contact your instructor OR copy the work from the Blackboard site listed on the weekly schedule.
LAST DATE for CR/NCR or DROP without a W gradeSeptember 23, 2005
LAST DATE for WITHDRAWAL with a W gradeNovember 3, 2005
FINAL EXAMINATION isMonday, December 12, 2005.
COMPUTERS TO BE USED:
All assignments must be completed using a personal computer (IBM or compatible). Students may use the computers in the Information Management Center (IMC). The IMC hours are: 3:00 p.m. to 9:00 p.m. Monday and Thursday.
When you registered for this course, you were required to enroll in a computer lab section--which meets on specific days and times. Please note that you may use the lab anytime it is open, and that you do not need to go to the lab until you have been given an assignment in class. No children, food and/or drinks (including water) areallowedin the classroom and the IMC lab. THERE IS AN ANSWER KEY AVAILABLE AT THE DESK. Check your papers for accuracy before turning them into your instructor. If you use the LAP there is also an answer key there.
Computers at home or work may be used if the following software is available: Windows XP, Microsoft Office 2003, Internet Explorer 5.0 or higher. Lower versions of Windows operating systems and MS Office can be used except for Access and PowerPoint.
LAP on the lower level of the Library, Room Lib 114 has Windows and Office software. They are open from 8 a.m. to 8 p.m. Monday through Thursday and 8 a.m. – 2 p.m. Friday. There is an answer key that you can look at during your visit there.The second floor of the Library has computers also, but there is NO answer key.
COMPUTER LAB ASSIGNMENTS:
Several lab assignments are given where students work with a computer. Due dates are shown on the attached schedule. Assignments will be collected at the beginning of class. Printouts for each assignment must be stapled in order, and attached to a cover sheet that is properly filled-out. Assignments CANNOT be accepted in parts. They can be turned in early.
If you cannot attend class when an assignment is due, you may turn the assignment in EARLYto your instructor. DO NOT TURN IN an assignment in the IMC or give it to another instructor!
Students are expected to do their own work—do not give copies of your files or printouts to other students or work in groups. Duplicate assignments are given 0 points for both students.
*There are no make ups for missed test or other assignments. Pop quizzes are given. ALL STUDENTS ARE REQUIRED TO TAKE THE FINAL EXAM.
GRADING SCALE:
A - 410-369,B – 368-328, C – 327-287, D – 286-246, F 245
PRACTICE TESTS, CHAPTER CHECKPOINT WEBSITES
for Discovering Computers Fundamentals Second Edition textbook
for Microsoft Office 2003 textbook (Mainly Learn It Online Section)
GAINING ACCESS AT OR TO SITESLOCATION / ADDRESS / USERNAME OR ID / PASSWORD
College Mysite / / Student ID Number / PIN Number
College Email / Mysite / SaddlebackCollege Email account username / PIN Number
IMC LAB / Saddleback College Email address is your username(lowercase letters only) / SaddlebackPIN Number
Blackboard.com / / Saddleback College Email account up to the @ symbol (cjones9)
(lowercase letters only) / PIN Number plus 2 zeros
Shelly\Cashman /
/ See CoursePort for Discovering Computers text
LAP LAB / Email address / Email password
*PIN NUMBER COULD BE THE LAST FOUR (4) DIGITS OF YOUR SOCIAL SECURITY NUMBER
Week / Date / Monday Class Activity / Tests1 / 8/22 / Meet class members, Syllabus Review, Mysite, Tour of IMC Lab, Logins for LAP, IMC, and Websites—Blackboard, Shelly Cashman (Show login steps)
Present Chapter 1, Intro to Computers, Discovering Computers text
Homework:Bringbooks to class to register at website for DC Textbook.Complete the Checkpoint questions for Chapter 1.
2 / 8/29 / Review Checkpoint questions in class—Chapter 1
Logins for Websites and Practice Test, Complete in class with textbooks
Complete and review Classwork with Groups for Chapter 1
Present Chapter 2, The Internet and WWW
Present Windows—Office 2003 textbook, Lab Login
Read, review and complete Intro. to MS Windows XP & Office 2003, Project 1
Copy class files from IMC S-Drive\Blackboard (Do if no Office 2003 at home)
Homework:Read Chapter 1 then complete, grade online and printto turn in a Practice Test for Chapter 1, 2 to turn in 9/12. Complete Checkpoint questions for Chapter 2, Do a Practice Test for Windows to turn in 9/12.
3 / 9/5 / Holiday
4 / 9/12 / Turn in: Practice Testsfor Chapter 1, 2 Windows at beginning of class
Review Checkpoint questions in class—Chapter 2
Complete and review Chapter 2, Classwork Groups
Complete Word Project 1 (Specific graphic needed, found in IMC Lab)
Present Chapter 3, Application Software, Review for Test 1
Homework:Study for test. Complete Word Project 1(See answer key in the IMC lab before turning in Word Project 1), Practice test for Chapter 3 and Word Project 1, Checkpoint questions for Chapter 3.
5 / 9/19 / Turn in: Word Project 1 andPractice test for Word Project 1 and Chapter 3
Review Checkpoint questions for Chapter 3
Present Chapter 4, Components of System Unit
Complete Word Project 2 (This is an extremely long keyboarding project)
Homework:Take home class work sheet for Chapter 3, Complete Word Project 2, Practice tests for Chapters 4 & Word Project 2, Checkpoint questions Chpt.4. / Test 1 covers Windows and Chapters 1 & 2
6 / 9/26 / Turn in: Word Project 2, Practice test for Word Project 2 and Chapters 4
Review Test 1, Review Checkpoint questions—Chapter 4
Complete Excel Project 1, Present Chapter 5, Input Output
Review and Prepare for Test 2
Homework: Take home class work sheet for Chapter 4,Excel Project 1, Checkpoint questions for Chapter 5 and Practice tests for Excel Project 1 and Chapter 5, Prepare for Word & Chapters 3 and 4 Test next week.
7 / 10/3 / Turn in: Excel Project 1, Practice test for Excel Project 1 & Chapter 5
Review Checkpoint questions for Chapter 5, Complete Excel 1 classwork
Complete Excel Project 2
Homework: Excel Project 2 and the Practice Test for Project 2 / Test 2 covers Word and Chapter 3 & 4
8 / 10/10 / Turn in: Excel Project 2 and the Practice Test
Review results of Test 2,
Complete class work sheet for Excel 2, Present and complete Excel Project 3
Homework: Excel Project 3 and the Practice Test for Project 3
9 / 10/17 / Turn in: Excel Project 3 and Practice test
Complete class work sheet for Excel 3, Present and complete Excel Project 4
Review and prepare for Test 3
Homework: Excel Project 4 and the Practice Test for Project 4
10 / 10/24 / Turn in: Excel Project 4 and the Practice Test
Complete class work sheet for Excel 4, Present and complete Excel Project 5
Homework: Excel Project 5 and the Practice Test for Project 5 / Test 3 covers Excel 1, 2, 3 and Chapter 5
11 / 10/31 / Turn in: Excel Project 5 and the Practice Test
Review results for Test 3—show grades
Complete class work sheet for Excel 5, Present and complete Excel Project 6
Homework: Excel Project 6 and the Practice Test for Project 6
12 / 11/7 / Turn in: Excel Project 6 and the Practice Test
Complete Chapter 6, Storage,
Complete Access 1, Review and prepare for Test 4
Homework: Access Project 1, Practice tests for Access Project 1 and Chapter 6
13 / 11/14 / Turn in: Access Project 1, Practice tests for Access Project 1 and Chapter 6
Review Checkpoint questions for Chapter 6
Complete Access Project 2
Homework: Access Project 2, Practice test for Access Project 2 / Test 4, covers Excel 4, 5, 6
14 / 11/21 / Turn in: Access Project 2, and Practice test
Review results from Test 4
Complete Access Project 3, Review and prepare for Test 5
Homework: Access Project 3, Practice test for Access Project 3
15 / 11/28 / Turn in: Access Project 3 and the Practice Test for Access Project 3
Complete PowerPoint, Projects 1, Instructions for Extra credit
Homework: PowerPoint, Projects 1 and Practice test / Test 5, covers Access and Chapter 6
16 / 12/5 / Turn in: PowerPoint Projects 1 and Extra Credit
Review results from Test 5, Extra Credit Presentation,
Complete PowerPoint, Project 2 and Review for final
Homework: PowerPoint Projects 2
17 / 12/12 / Turn in: PowerPoint Projects 2 and Practice Test
Complete Extra Credit presentations and Final Exam / Final Exam covers only PowerPoint
Page 1