SADDLEBACK COLLEGE, BUSINESS SCIENCE DIVISION, COURSE SYLLABUS

 

CIM 1 - INTRODUCTION TO COMPUTER INFORMATION SYSTEMS

 

 

 

 

 

Instructor:

Professor Patricia Sullivan

Semester:

Summer 2011, INTERNET BASED

 

Email:

psullivan@saddleback.edu

Tickets:

11910, 11970

 

 

 

 

 

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.

12. Demonstrate the ability to locate, evaluate, synthesize, use and communicate information in its various formats.

 

STUDENT RESOURCES:

1)      Textbook Bundle: Discovering Computers - Fundamentals 2011 Edition, Author: Shelly, Edition: 7th, Copyright Year: 2011, Publisher: Cengage Learning, (Saddleback Bookstore Price $125.25 used, $166.75 new, and they also have books to rent).

This Textbook Bundle includes the following 3 books:

Shelly/Vermaat, Discovering Computers-Fundamentals 2011, 7/E, ISBN: 978-1-4390-7945-4

Shelly/Quasney, Microsoft Office 2010 Excel, Complete, ISBN: 978-0-538-75005-9

Shelly/Pratt, Microsoft Office 2010 Access, Complete, ISBN: 978-0-538-74862-9

 

As you know, books are expensive. I negotiated long and hard with the publisher to get the book prices down from their original price of $235.00 net (this price did not include the bookstores mark-up). You can purchase the “Bundle” at the Saddleback College Bookstore ($166.75), at the Bookstore across the street from Saddleback, on Amazon, EBay…

You can also rent textbooks. Check out the following sites:
ecampus.com    Chegg.com  BookRenter.com   Textbooks.com   CampusBookRentals.com    Rent-a-Text.com  

Storage: You will need one 1GB (or larger) USB flash disk to store your files. 

 

2)      Class Website:

·         http://socccd.blackboard.com/

 

3)      Information Management Center (IMC) computer lab: Complete your computer work on-campus or off?

Depending on your available computer hardware and software, you can complete all hands-on assignments and tests in our on-campus IMC Computer Lab (Room BGS 248) or use your own computer and never come on campus.

 

** You DO NOT need to purchase software for this class. Use our On-Campus Computers: Students may use the computers in the Information Management Center (IMC)-BGS 248. All hardware (computers) and software (Microsoft Office 2010 Professional and Firefox) that you need to complete the class are available for you to use-FREE.
IMC Hours: Monday-Thursday from Noon to 9:00 p.m. IMC will be closed on 5/30 and 7/4.

 

**Computers at Home or Work:

If you plan on completing your computer assignments off campus, you need: 

--Windows XP including Service Pack 2, Windows Vista, or Windows 7

--Microsoft Office Professional Plus 2010 (Excel, Access, Word)

--Internet access and the FIREFOX Web Browser: We have had problems using Internet Explorer version 8 (IE 8) when working in Blackboard and taking QUIZZES. Use Firefox instead. You can download Firefox to your computer for free (click here to download). If you are using our on-campus computer lab, be sure to use Firefox when accessing Blackboard.

 

Note:

Students should always search for discounted software. For example, when you are ready to purchase Office 2010 - students can purchase a fully-licensed, fully functional copy (Microsoft Office 2010 Professional Plus) @ http://www.journeyed.com/fccc/ JourneyED requires proof that you are a student – best way is to fax or email them a copy of your class schedule. They do not accept a copy of your Student ID because it does not have a date on it. Download Software (<$80.00) http://www.journeyed.com/fccc/ -- Disk Mailed to you (<$100.00) http://www.journeyed.com/item/Microsoft/Office+Professional/100973759  

 

If you wish to explore Microsoft Office 2010 prior to purchasing it, you can download a free 60 day trial @ http://office.microsoft.com/en-us/try/try-office-2010-FX101868838.aspx?WT%2Emc%5Fid=MSCOM%5Fbnr%5Fenus%5Ftry

 

Before purchasing new software you should always check to see if your computer hardware can run the software. Minimum system requirements for MS Office 2010 Professional:
http://office.microsoft.com/en-us/products/microsoft-office-2010-system-requirements-HA101810407.aspx#_Toc250543107

 

POLICIES AND PROCEDURES:

  1. Courteous and proper behavior is expected and required in this class.

2.       Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the College. For more information refer to the "Code of Conduct" policy in the Saddleback College Student Handbook (available online at http://www.saddleback.edu/media/pdf/handbook.pdf). 
For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. HOWEVER, each student must develop his or her own solutions to all assigned work (Quizzes, Microsoft Office Assignments, Practical Hands-On Tests, Projects, Discussion Boards...  ) In other words, students may NOT "work together or help each other" on any Graded Work.

  1. Attendance:  Regular “online” attendance is expected. “Deadline dates’ have been assigned to all Quizzes, Microsoft Office Assignments, Practical Hands-On Tests, Project(s), Discussion Boards...  If you wish for your work to count, you must complete and submit the work before the assigned “deadline date”. You can submit work early.

 


SPECIAL NOTE FOR MACINTOSH/APPLE USERS: I have had students successfully complete this class using a Macintosh/Apple computer. However, there are a few challenges. 1) The books’ instructions tell you how to complete the documents using the PC version of Microsoft Office 2010. The Mac version IS different. Plus, it is missing some of the Excel commands. 2) Office for Apple does not have Access. 3) I do not have an Macintosh computer, so I cannot help you with the programs (questions such as: where do I find this command?)