Frederick Community College

CIS101-ONL1  Introduction to Computers and Information Processing

Summer 2009 Eight-Week Session

Instructor Information:

Name: Frank (Francis M.) Seidel

Office: By Appointment Only. Contact via e-mail.

E-mail: fseidel@frederick.edu

NOTE: In order to help ensure a quick response, all e‑mail must be sent to your instructor through Blackboard where your e-mail subject line will have the following prefix added automatically.

CIS_101_Summ09_SecONL1

Phone Number: Contact via e-mail.

Office Hours:  Contact with instructor via e-mail.

Campus Mail Box Number: 156  (NOTE: All assignments are to be submitted via Blackboard)

Course Information:

Credits: 3

Last Day to Withdraw: Wednesday, July 8, 2009

Prerequisites: EN 50A and EN 52 or

                          ESL 95 and ESL 99

Co-requisites: None

Meeting Day(s): Monday through Thursday

Meeting Times: On-Line

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 summarizing 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 then summarizing the research findings in a written report and a class 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:

Lecture, discussion board, software demonstration, 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 and contains only chapters 1-9. Chapter 12 is a separate black and white booklet.)

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, which can be purchased separately from the bookstore or the publisher.

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 a 180 day trial version of Office 2007 (ISBN 0-7638-3388-6) or without (ISBN 0-7638-3389-4). However, the trial version of Office 2007 cannot be purchased separately.

 

Evaluation Methods:

Activities

 

Final Grade Scale

Tests

Assignments* using applications and the Internet

Microsoft Office assessments

In-class activities

Note:   See the Grade Worksheet 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.

Makeup Tests

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

 

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 through Blackboard no later than the end of the third week of the semester. 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 attending class discussions, their behavior during class sessions and their desire to learn. Disruptive behavior diminishes the learning environment for the entire class and will not be tolerated. Students surfing the Web during class for material not related to the course is considered disruptive behavior. Please refer to the "Classroom Behavior" section in the Student Handbook for more information on expected behavior.

 

Students are expected to assume responsibility for attending class discussion boards. Students will find that class discussions are required in order to complete course work satisfactorily. Students are expected to attend every class and complete the discussion on time. Tests are normally scheduled to be held at the testing and will not be available for students who arrive late or after the last date available. Students who attend regularly will be better prepared to complete testing and in-class activities. The official class attendance policy for this class is the following.

 

Class attendance is required. Absence does not excuse a student from knowing what was covered in class or from completing assignments, tests, or other requirements of the course on time. Excused absences include illness (with doctor's note), emergencies deemed as such by your instructor, religious holidays, and official College functions. The instructor may issue makeup work for the student to complete in order for the absence to qualify as an excused absence. A 5% percent penalty will be deducted from the student's final grade percentage for every unexcused absence after one (1) unexcused absence.

 

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.

 

 

Text Box: 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

Maximum

Total

Points

Your

Actual

Score

Your

Total

Points

1.         Orientation Assignment

5

5

 

 

2.         Internet Research Assignment

10

15

 

 

3.         Research Reaction Discussion - Article Approval

5

20

 

 

4.         Word Assessment

15

35

 

 

5.         Research Reaction Discussion Assignment

20

55

 

 

6.         Test 1 at Testing Center (Ch. 1, 2, 3, 4)

70

125

 

 

7.         PowerPoint Assessment

15

140

 

 

8.         Integrated PowerPoint Assignment (PowerPoint & Word)

20

160

 

 

9.         Research Report - Second Article Approval

5

165

 

 

10.       Research Outline Assignment

10

175

 

 

11.      Excel Assessment

15

190

 

 

12.       Computer Software Assignment

10

200

 

 

13.       Corrected Research Outline Assignment

5

205

 

 

14.       Integrated Computer Purchase Assignment (Word & Excel)

10

215

 

 

15.      Test 2 at Testing Center (Ch. 5, 6, 7 and 8)

70

285

 

 

16.       Research Report Assignment

30

315

 

 

17.      On-Line Security, Privacy and Ethics Assessment

5

320

 

 

18.       Research Presentation Assignment

20

340

 

 

19.      On-Line Quiz (Ch. 9 & 12)

25

365

 

 

20.      Database Assessment

10

375

 

 

21.       On-line discussions and activities (directed by instructor)

25

400

 

 

 

 

 

 

TOTAL POINTS

400

 

 

 

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

 


CIS101 Topical Outline

8 Weeks – Two On-Line Sessions per Week

Class

Date

Content

Hands‑On Activities

Activities Due

  1.  

6/1

to

6/2

Orientation

·         Syllabus

·         CUT Companion Web Site

·         myFCC E-Mail Account

·         Blackboard

o   Organization

o   Forums

§  Q&A

o   Gradebook

o   E-mail

CUT Tech Insight: Working with PDF Files (between pages 356 & 357)

 

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

 

Orientation Assignment Issued

 

 

  1.  

6/3

to

6/4

CUT Chapter 1: Our Digital World

·         Computers and Computer Systems

·         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

 

File Management Activity

 

Office: Internet Explorer 7.0

·         Section 1 Browsing the Internet Using Internet Explorer 7.0

 

Internet Research Assignment Issued

Orientation Assignment Due

 

  1.  

6/8

to

6/9

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

 

Office: Introducing Word 2007

·         Section 1 Creating and Editing a Document

·         Section 2 Formatting Characters and Paragraphs

 

Backing Up Files

·         myFCC

·         ZIP files

 

Research Reaction Discussion – Article Selection Assignment Issued

 

Research Reaction Discussion Assignment Issued

Practice CIS101 Test

 

Internet Research Assignment Due

 

  1.  

6/10

to

6/11

CUT Chapter 2: Input and Processing

·         The Motherboard

 

CUT Chapter 3: Output and Storage

·         Output

·         Display Devices

·         Printers

·         Audio Output

Office: Introducing Word 2007

·         Section 3 Formatting and Enhancing a Document

·         Section 4 Formatting with Special Features

 

System of Interactive Guidance and Information (SIGI)

·         Career Decision Making

Practice CIS101 Test - Review

 

Research Reaction Paper - Article Selection Assignment Due

 

  1.  

6/15

to

6/16

CUT Chapter 3: Output and Storage

·         Storage Devices and Media

·         Magnetic Storage Devices and Media

·         Optical Storage Devices

·         Large Computer Storage Devices

 

Microsoft Office PowerPoint 2007

 

Office: Introducing PowerPoint 2007

·         Section 1 Preparing a Presentation

·         Section 2 Editing and Enhancing Slides

 

Word Assessment

 

Integrated PowerPoint Assignment Issued

Research Reaction Paper Assignment Due

 

 

  1.  

6/17

to

6/18

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

 

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

 

Test 1 Review

Word Assessment Due

  1.  

6/22

to

6/23

CUT Chapter 5: Application Software

·         Types of Application Software

·         Productivity Software

 

Microsoft Office Excel 2007

 

Office: Introducing Excel 2007

·         Section 1 Analyzing Data Using Excel

·         Section 2 Editing and Formatting Worksheets

 

PowerPoint Assessment

 

Research Outline – Second Article Approval Assignment Issued

 

Research Outline Assignment Issued

Test 1

·         CUT Ch. 1

·         CUT Ch. 2

·         CUT Ch. 3

·         CUT Ch. 4

(Testing Center)

 

Integrated PowerPoint Assignment Due

 

  1.  

6/24

to

6/25

CUT Chapter 5: Application Software

·         Software for Household Use

·         Graphics and Multimedia Software

·         Communications Software

 

CUT Chapter 6:  Telecommunications and Networks

·         The Evolution of Networking

·         Data Transmission Characteristics

·         Communications Media

In-Class Activity

 

Office: Introducing Excel 2007

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

 

Presenting Integrated PowerPoint Presentations

 

Computer Software Assignment Issued

PowerPoint Assessment Due

 

Research Outline - Second Article Approval Assignment Due

 

  1.  

6/29

to

6/30

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

 

Excel Assessment

 

Integrated Computer Purchase Assignment Issued

Research Outline Assignment Due

 

  1.  

7/1

to

7/2

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

 

On-Line Activity

 

Corrected Research Outline Assignment Issued

 

Research Report Assignment Issued

 

Computer Software Assignment Due

 

Excel Assessment Due

7/3-7/4

Independence day break - college closed

  1.  

7/6

to

7/7

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

On-Line Security, Privacy and Ethics Assessment

 

Test 2 Review

Corrected Research Outline Assignment Due

 

Integrated Computer Purchase Assignment Due

 

7/8

Last day to withdraw

  1.  

7/8

to

7/9

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

 

Research Presentation Assignment Issued

 

Test 2

·         CUT Ch. 5

·         CUT Ch. 6

·         CUT Ch. 7

·         CUT Ch. 8

(Testing Center)

 

Research Report Assignment Due

  1.  

7/13

to

7/14

CUT Chapter 9:  Database and Information Management

·         Planning and Designing Database Systems

·         Using Databases

·         Database Administration

 

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

 

ARTSYS Activity

 

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

·         Activities 2.1 - 2.5

 

On-Line Security, Privacy and Ethics Assessment Due

  1.  

7/15

to

7/16

CUT Chapter 12: Programming Concepts and Languages

·         Programming Development and Documentation Tools

·         Programming Errors

·         The Software Development Life Cycle

·         Major Programming Languages

·         Programming

HTML Activity

 

Web Page Programming Activity

 

 

 

  1.  

7/20

to

7/21

Research Presentation Discussion Board Posts

 

Database Assessment (using Excel, Access and Peoplesoft).

 

On-Line Quiz Review

Research Presentation Assignment Due

 

Database Assessment Due

  1.  

7/22

to

7/23

Research Presentation Discussions

On-Line Quiz

·         CUT Ch. 9

·         CUT Ch. 12

 

Additional Notes: