Frederick Community College

CIS101-ONL2  Introduction to Computers and Information Processing

Summer - 2nd Three Week Session 2009 (July 6 – July 25)

Instructor Information:

Name: Susan Trost

Office: Science & Technology Hall C-217

E-mail: strost@frederick.edu

NOTE: In order to help ensure a quick response, all e‑mail must be sent to your instructor through Blackboard and all Bb profiles must use the FCC issued email address as the student’s email address.

 

Office Phone Number: (301) 846-2549           (not regularly accessed during summer – please use email)

Office Hours:  By appointment

Campus Mail Box Number: 143 (all assignments are to be submitted via Blackboard)

 

Course Information:

Credits: 3

Last Day to Withdraw: July 18, 2009

Prerequisites: EN 50A and EN 52 or ESL 95 and ESL 99

Co-requisites: None

Meeting Day(s): Net class with one on‑campus test

Meeting Times: N/A

 

Course Description:

Emphasizes microcomputer hardware and software, data organization and an overview of programming and application software. Uses application software in the areas of database management, spreadsheets, word processing and graphics.

 

Core Learning Outcomes: By the completion of the course:

The Students will demonstrate college-level communications skills by-

·         Explaining the basic concepts and vocabulary of computer information systems in effective, clear and grammatically correct English.

·         Using research techniques to locate current articles on issues related to societal impact of computers and summarizes research findings in a written report and a class presentation.

The Students will demonstrate critical thinking skills by-

·         Creating and using graphs, tables and diagrams to interpret and analyze quantitative information.

·         Creating appropriate queries and synthesizing data retrieved from databases.

The Students will demonstrate an understanding of technology and its uses by-

·         Relating the history of the development of the computer and the way in which the computer has changed society.

·         Using appropriate computer terminology related to hardware, software and communication.

·         Using a computer to analyze data retrieved from a database.

·         Using a computerized spreadsheet to solve algebraic problems.

The Students will understand and be able to interpret social and educational values by-

·         Researching current articles on issues related to the impact of computers on the economic, political and cultural development of society summarize research findings in a written report and a class presentation. Note: Net students will create (not present) a presentation.

·         Displaying an understanding of academic honesty and copyright law.

In addition to the above, the Students will demonstrate Computer Literacy by-

·         Configuring a computer system for purchase.

·         Examining the security and privacy issues and implications of public and private databases.

·         Integrating data from one application into another.

Describing software development methods.

 

Instructional Methods:

Discussion board, software training, and hands-on activities.

 

Textbooks and Materials for Course:

COMPUTERS Understanding Technology, 3rd Edition, Fuller and Larson. Paradigm 2008, ISBN 978-0-76382-936-0. (This book is referenced as CUT in the topical outline.)

Marquee Series Microsoft Office 2007 with Windows XP and Internet Explorer 7.0, Rutkosky, Seguin, and Rutkosky. Paradigm 2008, ISBN 978-0-76382-958-2. (This book is referenced as Office in the topical outline.)

SNAP, Web-Based Training and Assessment for Microsoft Office 2007.

Microsoft Office 2007 (Word, Excel, PowerPoint, and Access) is required for completing assignments. The above textbooks and materials can be purchased in the FCC bookstore bundled either with or without a 180 day trial version of Office 2007. However, the trial version of Office 2007 cannot be purchased separately.

A portable USB storage device (e.g., "pen" drive) is highly recommended to save your files.

 

Evaluation Methods:

Activities

 

Final Grade Scale

Quizzes (online)

Tests (one on campus in the Testing Center)

Assignments* using applications and the Internet

Online participation via Discussion Board

 

Note:   See the Grade Worksheet on page 5 for point values.

 

90% - 100%

  A*

 

80% -   89%

B

 

70% -   79%

C

 

60% -   69%

D

 

59% and below

F

* Note:  It will be necessary to hand in every assignment to receive an “A” grade in this course.

Make Up Tests:

It is a policy to not issue make up tests or quizzes for this course. If, for extraordinary circumstances, a make up test or quiz is permitted (arrangements must be made before the next scheduled class) the type of make up test or quiz is left to the instructor's discretion and may include essay questions.

 

Online versus Proctored Tests:

If the graded performance for online testing differs significantly from the grade average for proctored testing, the instructor reserves the right to administer additional tests.

 

Assignments:

Unless otherwise instructed, all assignments are due at the beginning of the class on their due dates and are to be submitted via Blackboard, not e-mail. If an assignment is late, ten percent (10%) will be deducted for each calendar day it is late and it will be accepted ONLY at the instructor’s discretion and provided that the assignment has NOT been graded and has NOT been returned to the class. Absolutely no work will be accepted after the last class.

 

Progress Report:

You will receive your progress report no later than the end of the sixth class of the term. Your Gradebook in Blackboard will have all your graded activities and represents your progress report. However, feel free to discuss any problems or conflicts concerning this course with your instructor at any time.

 

Attendance/Behavior Policy:

Students in this class are expected to assume responsibility for participating in class, respecting their classmates and their desire to learn. Disruptive behavior diminishes the learning environment for the entire class and will not be tolerated. Please refer to the "Classroom Behavior" section in the Student Handbook for more information on expected behavior.

 

Students will find that regular activity in Blackboard is required in order to complete course work satisfactorily. Students that participate regularly will be better prepared to complete testing and assignment requirements. Participation is given in the Discussion Board and your participation will be reflected in the participation portion of your grade.

 

E-Mail Policy:

E-mail is an instructional tool essential to student-instructor and student-student communication. Each student is given an FCC e-mail account which should be used in this class. In the Blackboard environment by default, your e-mail address is available to all students in this course. However, students are permitted to use e-mail addresses of other students in this course only for the purpose and the duration of this course.

 

The instructor can be expected to respond to regular student e-mail inquiries (grades, posted assignments, and tests excluded) within the time frame of 24 to 48 hours except during weekends and holidays.

 

Software Piracy:

Software that is copyrighted is intended for use in its original form. Duplicate copies can be produced only if written permission is obtained from the software manufacturer. The U.S. law states that noncompliance may result in civil damages not exceeding $50,000 and criminal penalties of up to one (1) year and/or a $10,000 fine. Note that minors are not exempt from copyright law.

 

Academic Honesty:

Each student is expected to perform his/her own academic work. If students work together, they are expected to each be working on separate computers and completing assignments on their own. Two students who work together but submit two copies of the same assignment (even if minor changes like names are made) are violating college policies. Plagiarism and other forms of academic dishonesty are considered extremely serious offenses. As little as one sentence copied from the Internet (or another source) into a research paper without citing the source will result in, as a minimum, a zero for the assignment and disqualification from presenting the paper. Students are personally responsible for understanding the various forms of academic dishonesty as explained in the "Code of Academic Honesty" section of the Student Handbook. Failure to comply with any requirement for academic honesty may trigger disciplinary proceedings. Any form of cheating or plagiarism is considered grounds for failure of the course.

 

Modification of Schedule:

The instructor reserves the right to adjust the assignments or schedule. This may also change the date(s) of one or more of the tests. Any affected assignment due dates may also be adjusted. In the event the schedule is adjusted, the student will remain responsible for all the assignments listed in this syllabus.

 

Students with Disabilities:

FCC provides reasonable accommodations to otherwise qualified students with disabilities in accordance with the Americans with Disabilities Act of 1990 (ADA) and Section 504 of the Rehabilitation Act of 1973 (Section 504) and amendments.  Students with disabilities who are in need of accommodations must contact the Services for Students with Disabilities (SSD) office at 301-846-2408 (A Building, Room 106A) in order to request and apply for services.  The SSD office will require appropriate documentation of a disability.  Questions related to accommodations or services can be directed to the SSD office.  Additional information related to services can be viewed at the following FCC web page:  http://www.frederick.edu/student_services/disability.aspx. 

If you currently receive services from the SSD office, please submit your Student Success Plan to me and make an appointment with me to discuss your accommodations and needs in class.  I will hold any information you share with me in strict confidence unless you give me permission to do otherwise.

 

 

No food or drinks allowed in the computer labs or classrooms.

FCC is a smoke-free campus. Smoking is permitted only in designated areas.

 


 

 

 

 

CIS101 Grade Worksheet

 

Graded Activities

Maximum Points

Available

Your

Actual Score

Your Total Points

Quiz 1 (Chapters 1-2)

10

 

 

Quiz 2 (Chapters 3-4)

10

 

 

Quiz 3 (Chapter 5)

5

 

 

Quiz 4 (Chapter 6)

5

 

 

Quiz 5 (Chapters 7-8)

10

 

 

Quiz 6 (Chapters 9 & 12)

10

 

 

Subtotal

50

 

 

 

Blackboard Homepage Assignment

5

 

 

Internet Research Assignment

10

 

 

Research Reaction Paper – Article Approval

5

 

 

Research Reaction Paper Assignment

15

 

 

Integrated PowerPoint Assignment (PowerPoint)

15

 

 

Research Outline Assignment – Second Article Approval

5

 

 

Research Outline Assignment

5

 

 

Corrected Research Outline Assignment

5

 

 

Integrated Computer Purchase Assignment (Word & Excel)

20

 

 

Research Report Assignment

30

 

 

Research Presentation Assignment

20

 

 

Web Page Programming Assignment

10

 

 

Subtotal

145

 

 

 

Word Assessment: Concept Exam

5

 

 

Word Assessment: Document Assessment

10

 

 

PowerPoint Assessment: Concept Exam

5

 

 

PowerPoint Assessment: Presentation Assessment

10

 

 

Excel Assessment: Concept Exam

5

 

 

Excel Assessment: Workbook Assessment

10

 

 

Subtotal

45

 

 

 

Midterm Exam (Chapters 1-6)

100

 

 

Final Exam at the Testing Center (Chapters 6-9 & 12)

100

 

 

Subtotal

200

 

 

 

Online Participation in Forums (Discussion Board)

60

 

 

 

TOTAL POINTS

500

 

 

Note: Point values and total points are subject to change.

 


CIS101 Topical Outline

 

Class

Date

Content

Hands‑On Activities

Activities Due

  1.  

7/6

CUT Tech Insight: Working with PDF Files

 

CUT Chapter 1: Our Digital World

·         Immersed in Digital Technology

·         The Computer Advantage

·         How Computers Work

 

Office: Information Technology Essentials

 

Office: Windows XP

·         Section 1 Exploring Windows XP

 

Homepage Assignment Issued

 

Forum 1

 

 

  1.  

7/7

CUT Chapter 1: Our Digital World

·         Components of a Computer System

·         Categories of Computers

 

CUT Appendix: Internet Tutorials

·         Tutorial 2: Conducting a Basic Web Search

·         Tutorial 3: Conducting an Advanced Web Search

 

CUT Chapter 7:  The Internet and the World Wide Web

·         Searching for Information on the Internet

 

Office: Windows XP

·         Section 2 Maintaining Files

 

Office: Internet Explorer 7.0

·         Section 1 Browsing the Internet Using Internet Explorer 7.0

 

Internet Research Assignment Issued

 

Forum 2

 

Forum 1 Thread Due

 

  1.  

7/8

Introduction to SNAP

 

Microsoft Office Word 2007

 

CUT Chapter 2: Input and Processing

·         Input Technology

·         Data Processing by Computers

·         The System Unit

·         The Power Supply

·         Storage Bays

·         The Motherboard

 

Office: Introducing Word 2007

·         Section 1 Creating and Editing a Document

·         Section 2 Formatting Characters and Paragraphs

 

Research Reaction Paper – Article Assignment Issued

 

Research Reaction Paper – Article Assignment Issued

 

Practice CIS101 Test

 

 

Homepage Assignment Due

 

Internet Research Assignment Due

 

Forum 1 Replies Due

 

Forum 2 Thread Due

 

  1.  

7/9

CUT Chapter 3: Output and Storage

·         Output

·         Display Devices

·         Printers

·         Audio Output

·         Storage Devices and Media

·         Magnetic Storage Devices and Media

·         Optical Storage Devices

·         Large Computer Storage Devices

 

Office: Introducing Word 2007

·         Section 3 Formatting and Enhancing a Document

·         Section 4 Formatting with Special Features

 

Forum 3

Research Reaction Paper Assignment - Article Approval Assignment Due

 

Forum 2 Replies Due

 

Quiz 1

·         CUT Chapters 1-2

  1.  

7/10

CUT Chapter 4: System Software

·         The Function of System Software

·         The Function of the Operating System

·         Software User Interfaces

·         Personal Computer Operating Systems

·         Server Operating Systems

·         Operating Systems for Handheld Devices

·         Utility Programs and Translators

 

Microsoft Office PowerPoint 2007

 

Office: Introducing PowerPoint 2007

·         Section 1 Preparing a Presentation

·         Section 2 Editing and Enhancing Slides

 

Integrated PowerPoint Assignment Issued

 

Forum 4

Research Reaction Paper Assignment Due

 

Forum 3 Thread Due

 

  1.  

7/13

CUT Chapter 5: Application Software

·         Types of Application Software

·         Productivity Software

·         Software for Household Use

·         Graphics and Multimedia Software

·         Communications Software

 

Office: Integrating Programs Word, Excel, and PowerPoint (located after PowerPoint 2007 Section 3)

·         Activity 3.1 Exporting a PowerPoint Presentation to Word

·         Activity 3.2 Exporting a Word outline to a PowerPoint Presentation

·         Activity 3.5 Embedding and Editing a Word Table in a PowerPoint Presentation

 

Office: Introducing PowerPoint 2007

·         Section 3 Customizing a Presentation

 

Forum 3 Replies Due

 

Word Skills Exam and Document Assessment Due

Quiz 2

·         CUT Chapters 3-4

  1.  

7/14

CUT Chapter 6:  Telecommunications and Networks

·         The Evolution of Networking

·         Data Transmission Characteristics

·         Communications Media

 

Microsoft Office Excel 2007

 

Office: Introducing Excel 2007

·         Section 1 Analyzing Data Using Excel

·         Section 2 Editing and Formatting Worksheets

 

Research Outline – Second Article Approval Assignment Issued

 

Research Outline Assignment Issued

 

Integrated PowerPoint Assignment Due

 

Forum 4 Thread Due

 

Quiz 3

·         CUT Chapter 5

  1.  

7/15

Microsoft Office Excel 2007

 

Office: Introducing Excel 2007

·         Section 3 Using Functions, Setting Print Options, and Adding Visual Elements

 

Computer Software Assignment Issued

 

Forum 5

 

Research Outline Assignment - Second Article Approval Due

 

Forum 4 Replies Due

 

PowerPoint Skills Exam and Presentation Assessment Due

 

Midterm Exam CUT Chapters 1-5

  1.  

7/16

CUT Chapter 6:  Telecommunications and Networks

·         Network Classifications

·         Network Topologies

·         Network Hardware

·         Network Software

·         Communications Software and Protocols

 

Integrating Programs

 

Office: Introducing Excel 2007

·         Section 4 Working with Multiple Worksheets, Tables, and Other File Formats

 

Office: Integrating Programs Word and Excel (located after Excel 2007 Section 4)

·         Activities 1.1 - 1.5

 

Office: Integrating Programs Word, Excel, and PowerPoint (located after PowerPoint 2007 Section 3)

·         Activity 3.3 Linking an Excel Chart with a Word Document and a PowerPoint Presentation

·         Activity 3.4 Editing a Linked Object

 

Integrated Computer Purchase Assignment Issued

 

Corrected Research Outline Assignment Issued

 

Forum 5

Research Outline Assignment Due

 

Forum 4 Thread Due

 

  1.  

7/17

CUT Chapter 7:  The Internet and the World Wide Web

·         The Internet: A Global Network

·         Connecting to the Internet

·         Navigating the Internet

·         Viewing Web Pages

·         Searching for Information on the Internet

·         Using Newer Internet Applications

·         Respecting the Internet Community

 

 

Research Outline Assignment Issued

 

 

Research Outline Assignment - Corrected Outline Due

 

Forum 4 Replies Due

 

Quiz 4

·         CUT Chapter 6

7/18

Last day to withdraw

  1.  

7/20

CUT Chapter 8:  Security Issues and Strategies

·         Risk Assessment

·         Network and Internet Security Risks

·         Computer Viruses

·         Hardware and Software Security Risks

·         Security Strategies for Protecting Computer Systems and Data

 

Research Presentation Assignment Issued

 

Excel Skills Exam and Presentation Assessment Due

 

Forum 5 Thread Due

 

  1.  

7/21

CUT Chapter 9:  Database and Information Management

·         Database Basics

·         Databases and Information Systems

·         Database Management System Software

·         Types of Databases

 

Microsoft Office Access 2007

 

Office: Introducing Access 2007

·         Section 1 Maintaining Data in Access Tables

·         Section 2 Creating Tables and Relationships

 

Forum 6

 

Integrated Computer Purchase Assignment Due

 

Forum 5 Replies Due

 

Quiz 5

CUT Chapters 7-8

  1.  

7/22

CUT Chapter 9:  Database and Information Management

·         Planning and Designing Database Systems

·         Using Databases

·         Database Administration

·         Data Validation

 

CUT Chapter 12: Programming Concepts and Languages

·         Programming Concepts

·         Problem Solving Techniques

·         The Evolution of Programming Approaches

 

Office: Introducing Access 2007

·         Section 3 Creating Queries, Forms, and Reports

 

Office: Integrating Programs Word, Excel, and Access (located after Access 2007 Section 4)

·         Activities 2.1 - 2.5

 

Web Page Programming Assignment Issued

 

Research Report Assignment Due

 

Forum 6 Thread Due

 

  1.  

7/23

CUT Chapter 12: Programming Concepts and Languages

·         Programming Development and Documentation Tools

·         Programming Errors

·         The Software Development Life Cycle

·         Major Programming Languages

 

Programming

 

 

 

Research Presentation Assignment Due

 

Quiz 6

·         CUT Chapters 9 & 12

  1.  

7/24

Final Exam (closed book) in the Testing Center

·        CUT Chapters 6-9 & 12

 

Web Page Programming Assignment Due

 

Additional Notes:

  • Assignments that are shaded with this color in a bold style in the Hands‑On Activities column must be submitted through Blackboard for grading no later than the beginning of the class specifically noted in the Activities Due column.