Frederick Community College

CIS101-ONL2  Introduction to Computers and Information Processing

Spring 2012

Course Dates

Class Begins: 1/30/12

Class Ends: 5/21/12

Last Day to Withdraw: 4/16/12

Instructor Information

Name: Walter Martynenko

Office: Science & Technology Hall C-215

E-mail: wmartynenko@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_Spri12_SecONL2_Sess15W: 

Phone Number: (301) 846-2553

Contact Hours: e-mail and by appointment for in‑person meeting

Campus Mail Box #: 281 (all assignments are to be submitted via Blackboard assignment links)

Course Information

Credits: 3

On-Campus Meetings: None

On-Campus Exams: 2

Prerequisites: EN50A and EN52 or

                          ESL95 and ESL99

Co-requisites: None

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. Note: Online 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

Hands-on activities

 

Course Organization

With the exception of an optional orientation and two on-campus examinations, all correspondence, class instruction and notes, communication (both with students and instructor), assignments, and quizzes are to be completed online. Students are expected to be weekly participants in online discussions between themselves and the instructor. Assignments will be submitted via Blackboard, not e-mail. Questions are to be asked of the instructor and answered by the instructor via e-mail or through an online discussion board where either the instructor or students may provide answers. Training in Microsoft Office applications will be accomplished by using a training textbook or online training using MyITLab.

 

Textbooks and Materials

Technology in Action, 8th Edition, Complete, Alan Evans, Kendall Martin and Mary Anne Poatsy. Pearson Prentice Hall, © 2011, ISBN 978-0-13-139157-4. This book is referenced as TiA in the topical outline.

Skills for Success with Microsoft Office 2010, Kris Townsend. Pearson Prentice Hall, © 2011, ISBN 978-0-13-703257-0. This book is referenced as Office in the topical outline. A Windows 7 book is also included for students moving to Windows 7.

MyITLab, Web-Based Training and Assessment for TiA and Microsoft Office 2010. The access code is packaged with the book bundle in the bookstore.

The above textbooks and materials are bundled together and can be purchased in the FCC bookstore. One option has physical textbooks, an e-book, and MyITLab (ISBN 9781256088660). A second option has only an e-book and MyITLab (ISBN 9780132119566).

Microsoft Office 2010 (Word, Excel, and PowerPoint) is required for completing assignments. The software is available for a discount at the FCC bookstore or through the Microsoft Office Ultimate Steal at the following URL when you register using your myFCC e-mail account.

 

http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx

 

Students using PCs at FCC should have a portable USB storage device (e.g., “pen” drive) to store their files.

 

Progress Report

By the end of the sixth week of the semester, you will have an opportunity to evaluate your progress in this course and decide if you need to make any adjustments (additional study, tutoring, conference with instructor) to assure your success in this course. 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.

 

Evaluation Methods

Activities

 

Final Grade Scale

Quizzes (online)

Tests (two on campus in the Testing Center)

Assignments using Microsoft Office applications and the Internet

Microsoft Office assessments using MyITLab

Online participation using the Discussion Board

Note:  See the Grade Worksheet for point values.

 

90% - 100%

  A*

 

80% -   89%

B

 

70% -   79%

C

 

60% -   69%

D

 

59% and below

F

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.

 

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 assignment links, 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. Any assignment that is submitted within 24 hours after the due date/time is considered to be one calendar day late. Absolutely no work will be accepted after the last class.

 

Student Services

A variety of services are available to assist students in succeeding at FCC. Students can learn more about these services by visiting the Student Services Web page.

http://www.frederick.edu/student_services/index.aspx

Students with disabilities who are in need of accommodations or who have questions related to disabilities services should contact the Services for Students with Disabilities (SSD) office at 301-846-2408. Students can learn more about these services by visiting the Services for Students with Disabilities 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.

 

Participation Policy

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. The Discussion Board is used for online participation and your participation will be reflected in the online participation portion of your grade.

 

E-Mail Policy

With the exception of MOL students all FCC students are expected to use their FCC assigned e-mail address for correspondence with faculty and staff at the college. E-mail must be sent via Blackboard. However, received e-mail is available only through the myFCC Web site. Login instructions for myFCC are available through the following link.

https://myfcc.frederick.edu

Email is an instructional tool essential to student-instructor and student-student communication. In the Blackboard environment by default, your email address is available to all students in this course. However, students are permitted to use email 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.

 

Academic Integrity

Work in this course is subject to the provisions of the FCC Code of Academic Integrity. Plagiarism in any form will not be tolerated. As a student, it is your job to practice academic honesty at ALL times.  Make sure that all sources, particularly Internet sources, get proper credit for quotations, paraphrases, and ideas. More information about this and the Student Conduct Code are available at the following Web page.

http://www.frederick.edu/student_services/studentpolicies.aspx

You must send your Academic Integrity Pledge to the instructor. The form is available at the following Web page.

http://courses.frederick.edu/_utilities/regform.htm

 

CIS101 Grade Worksheet

Graded Activities

Maximum

Activity

Points

Maximum

Total

Points

Your

Earned

Points

Your

Total

Points

1.    Orientation Assignment

10

10

 

 

2.    Forum 1

10

20

 

 

3.    Quiz 1

10

30

 

 

4.    Research Report – First Article Approval Assignment

10

40

 

 

5.    Forum 2

15

55

 

 

6.    Word Assessment

15

70

 

 

7.    Quiz 2

10

80

 

 

8.    Quiz 3

5

85

 

 

9.    Forum 3

15

100

 

 

10.  PowerPoint Assessment

15

115

 

 

11.  Research Report - Second Article Approval Assignment

10

125

 

 

12.  Midterm Exam

100

225

 

 

13.  Forum 4

15

240

 

 

14.  Research Report Outline Assignment

10

250

 

 

15.  Quiz 4

5

255

 

 

16.  Forum 5

15

270

 

 

17.  Excel Assessment

15

285

 

 

18.  Computer Software Assignment

20

305

 

 

19.  Corrected Research Report Outline Assignment

5

310

 

 

20.  Integrated Computer Purchase Assignment

30

340

 

 

21.  Quiz 5

10

350

 

 

22.  Forum 6

15

365

 

 

23.  Research Report Assignment

30

395

 

 

24.  Quiz 6

10

405

 

 

25.  Research Presentation Assignment

20

425

 

 

26.  Forum 7

15

440

 

 

27.  Access Assessment

10

450

 

 

28.  Web Page Programming Assignment

10

460

 

 

29.  Forum 8

10

470

 

 

30.  Final Exam

100

570

 

 

 

 

 

 

TOTAL POINTS

570

 

 

 

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

 

Topical Outline

Every effort will be made to keep to the topical outline schedule; however, the instructor reserves the right to alter or amend it as necessary. Additional dates, as published in the academic schedule of classes and listed in the topical outline that follows, may be required as make-up days for inclement weather.

 


CIS101 Topical Outline

 

Class

Date

Content

Hands‑On Activities

Activities Due

  1.  

1/30

TiA Ch 1 Why Computers Matter to You: Becoming Computer Literate

·       Why Should You Become Computer Literate?

·       Becoming a Savvy Computer User and Consumer

·       Being Prepared for Your Career

·       Computers in Today’s Careers

·       Understanding the Challenges Facing a Digital Society

 

Orientation Assignment Issued

 

Forum 1

 

 

  1.  

2/6

TiA Focus: The History of the PC

 

TiA Ch 2 Looking at Computers: Understanding the Parts

·       Understanding Your Computer

·       Input Devices

·       Output Devices

·       Processing and Memory on the Motherboard

·       Storing Data and Information

·       Connecting Peripherals to the Computer

·       Power Controls

·       Setting It All Up

 

Office Word Ch 1: Creating Documents with Word 2010

·       Skills 1-10

·       More Skills 11-14

 

Activate MyITLab

 

Research Report – First Article Approval Assignment Issued

 

Forum 2

 

Orientation Assignment Due

 

Forum 1 Thread Due

 

  1.  

2/13

TiA Ch 3 Using the Internet: Making the Most of the Web’s Resources

·       The Internet

·       Communicating Through the Internet: E‑Mail and Other Technologies

·       Web 2.0 Technologies: Collaborating and Communicating Through the Internet

·       Web Entertainment: Multimedia and Beyond

·       Conducting Business over the Internet: E-Commerce

·       Accessing the Web: Web Browsers

·       Getting Around the Web: URLs, Hyperlinks, and Other Tools

·       Searching the Web Effectively

·       The Internet and How It Works

·       Connecting to the Internet

·       The Future of the Internet

 

Office Word Ch 2: Format and Organize Text

·       Skills 1-10

 

Practice CIS101 Test

 

Forum 1 Replies Due

 

Forum 2 Thread Due

 

  1.  

2/20

TiA Ch 4 Application Software: Programs That Let You Work and Play

·       The Nuts and Bolts of Software

·       Productivity Software for Home and Office

·       Media Software for Home

·       Software Fun for Home

·       Business Software for Home and Office

·       Getting Help with Software

·       Buying Software

·       Installing, Uninstalling, and Starting Software

 

TiA Focus: Under the Hood

 

Office Word Ch 3: Working with Graphics, Tabs, and Tables

·       Skills 1-10

 

Office Word Ch 4: Applying Special Text, Paragraph, and Document Formats

·       Skills 1-10

·       More Skills 12   Create Outlines

·       More Skills 14   Preview and Save Documents as Web Pages

 

Research Report – Second Article Approval Assignment Issued

 

Forum 3

 

Research Report – First Article Approval Assignment Due

 

Forum 2 Replies Due

 

Quiz 1

·       TiA Chapters 1-3

  1.  

2/27

TiA Focus: Careers in IT

 

TiA Ch 5 Using System Software: The Operating System, Utility Programs, and File Management

·       System Software Basics

·       Types of Operating Systems

·       What the Operating System Does

·       The Boot Process: Starting Your Computer

·       The Desktop and Windows Features

·       Organizing Your Computer: File Management

·       Utility Programs

 

Word Assessment in MyITLab

 

Office PP Ch 1:  Getting Started with PowerPoint 2010

·       Skills 1-10

 

Office PP Ch 2:  Format a Presentation

·       Skills 1-10

·       More Skills 13   Create Slides from Microsoft Word

 

Forum 3 Thread Due

 

  1.  

3/5

TiA Focus: Computing Alternatives

 

TiA Ch6  Understanding and Assessing Hardware: Evaluating Your System

·       Is It and Computer or Me?

·       What Is Your Ideal Computer?

·       Choosing a Desktop or Notebook System

·       Assessing Your Hardware: Evaluating Your System

·       Evaluating the CPU Subsystem

·       Evaluating RAM: The Memory Subsystem

·       Optical Storage

·       Evaluating the Video Subsystem

·       Evaluating the Audio Subsystem

·       Evaluating System Reliability

·       Making the Final Decision

 

Office PP Ch 3:  Enhance a Presentation with Graphics

·       Skills 1-10

 

Office PP Ch 4:  Present Data using Tables, Charts, and Animation

·       Skills 1-10

 

Research Report Outline Assignment Issued

 

Forum 4

 

Research Report - Second Article Approval Assignment Due

 

Forum 3 Replies Due

 

Word Assessment Due

Quiz 2

·       TiA Chapters 4-5

  1.  

3/12

TiA Ch 7 Networking: Connecting Computing Devices

·       Networking Fundamentals

·       Network Architectures

·       Network Components

·       Home Ethernet Networks

·       Home Ethernet Equipment

·       Connecting Other Devices to Networks

·       Securing Wireless Networks

·       Configuring Software for Your Home Network

 

PowerPoint Assessment in MyITLab

 

Office Excel Ch 1: Create Workbooks with Excel 2010

·       Skills 1-10

 

Office Excel Ch 2: Construct Formulas and Charts

·       Skills 1-10

·       More Skills 13   Copy Excel Data to Word Documents

 

Computer Software Assignment Issued

 

Forum 4 Thread Due

 

Quiz 3

·       TiA Chapter 6

3/19-3/20

Spring break - college open, no classes

3/21-3/25

Spring break, college closed

  1.  

3/26

 

Office Excel Ch 4: Use Excel Functions and Tables

·       Skills 1-10

 

Integrated Computer Purchase Assignment Issued

 

Forum 5

 

Research Report Outline Assignment Due

 

Forum 4 Replies Due

 

PowerPoint Assessment Due

Midterm Exam (closed book) in the Testing Center

·       TiA Chapters 1-7

·       TiA Focus: The History of the PC

·       TiA Focus: Under the Hood

  1.  

4/2

TiA Ch 12  Behind the Scenes: Networking and Security in the Business World

·       Networking Advantages

·       Client/Server Networks

·       Classifications of CLient/Server Networks: LANs, WANs, and MANs

·       Constructing Client/Server Networks

·       Servers

·       Network Topologies

·       Transmission Media

·       Network Operating Systems

·       Network Adapters

·       Network Navigation Devices

·       Network Security for Client/Server Networks

 

Object Linking and Embedding (OLE)

 

Office Excel Ch 3: Manage Multiple Worksheets in a Workbook

·       Skills 1-10

 

Forum 5 Thread Due

 

  1.  

4/9

TiA Focus: Information Technology Ethics

 

TiA Ch 8 Digital Lifestyle: Managing Digital Data and Devices

·       A Digital Lifestyle

·       Digital Telephony: Communicating with Bits

·       Digital Media and Information

·       Digital Mobility and Access

 

Excel Assessment in MyITLab

 

Corrected Research Report Outline Assignment Issued

 

Research Report Assignment Issued

 

Forum 6

 

Computer Software Assignment Due

 

Forum 5 Replies Due

 

Quiz 4

·       TiA Chapter 12

4/16

Last day to withdraw

  1.  

4/16

TiA Ch 9 Securing Your System: Protecting Digital Data and Devices

·       Keeping Your Data Safe

·       Computer Threats: Computer Viruses

·       Computer Safeguard: Antivirus Software and Software Updates

·       Computer Threats: Hackers

·       Restricting Access to Your Digital Assets

·       Managing Online Annoyances

·       Protecting Yourself ... from Yourself!

·       Protecting Your Physical Computing Assets

 

Research Presentation Assignment Issued

 

Corrected Research Report Outline Assignment Due

 

Forum 6 Thread Due

 

Excel Assessment Due

  1.  

4/23

TiA Ch 11  Behind the Scenes: Databases and Information Systems

·       Life Without Databases

·       Database Building Blocks

·       Database Types

·       Database Management Systems: Basic Operations

·       Relational Database Operations

·       Managing Data: Information Systems

·       Data Mining

 

Office Access Ch 1:  Work with Databases and Create Tables

·       Skills 1-10

 

Office Access Ch 2:  Manage Databases and Create Queries

·       Skills 1-10

 

Forum 7

 

Integrated Computer Purchase Assignment Due

 

Forum 6 Replies Due

 

Quiz 5

TiA Chapters 8-9

  1.  

4/30

TiA Ch 10  Behind the Scenes: Building Applications

·       Understanding Software Programming

·       The Life Cycle of an Information System

·       The Life Cycle of a Program

·       Programming Languages: Many Languages for Many Projects

 

Office Access Ch 3:  Create Forms

·       Skills 1-10

 

Web Page Programming Assignment Issued

 

Research Report Assignment Due

 

Forum 7 Thread Due

 

  1.  

5/7

TiA Ch 13  Behind the Scenes: How the Internet Works

·       The Management of the Internet

·       Internet Networking

·       Data Transmission and Protocols

·       IP Addresses and Domain Names

·       Other Protocols: FTP and Telnet

·       HTTP, HTML, and Other Web Jargon

·       Communications Over the Internet

·       Using the Internet to Deliver Computer Services

 

Access Assessment in MyITLab

 

Forum 8

 

Research Presentation Assignment Due

 

Forum 7 Replies Due

 

Quiz 6

·       TiA Chapters 10-11

  1.  

5/14

Final Exam (closed book) in the Testing Center

·       TiA Chapters 8-13

·       TiA Focus: Information Technology Ethics

 

Web Page Programming Assignment Due

 

Forum 8 Thread Due

 

Access Assessment Due

 

 

5/21

 

Forum 8 Replies Due

 

Additional Notes:

 

CIS101 Estimated Homework Times

Total Estimated Times: 78¼ Hours

1.   Textbooks: 31 Hours

Technology in Action

 

Skills for Success

1

¾

 

Word

Ch. 1

1

2

¾

 

 

Ch. 2

3

¾

 

 

Ch. 3

1

4

¾

 

 

Ch. 4

1

5

¾

 

PP

Ch. 1

1

6

¾

 

 

Ch. 2

1

7

¾

 

 

Ch. 3

1

8

¾

 

 

Ch. 4

1

9

¾

 

Excel

Ch. 1

10

¾

 

 

Ch. 2

11

¾

 

 

Ch. 3

12

¾

 

 

Ch. 4

13

¾

 

Access

Ch. 1

History of the PC

½

 

 

Ch. 2

Under the Hood

¾

 

 

Ch. 3

Careers in IT

½

 

Total

18½ hrs

Computing Alternatives

½

 

 

 

 

Information Technology Ethics

½

 

 

 

 

Total

12½ hrs

 

 

 

 

2.   Assignments/Forums: 32½ Hours

Assignments

 

Forums

Orientation

½

 

1

1

First Article Approval

 

2

2

Second Article Approval

 

3

2

Research Report Outline

 

4

2

Computer Software

3

 

5

2

Corrected Research Report Outline

½

 

6

2

Integrated Computer Purchase

4

 

7

2

Research Report

3

 

8

1

Research Presentation

 

Total

14 hrs

Web Page Programming

 

 

 

Total

18½ hrs

 

 

 

3.   Quizzes/Exams/Assessments: 14¾ Hours

Quizzes

 

Exams

 

Assessments

1

1

 

Midterm

3

 

Word

¾

2

1

 

Final

3

 

PP

¾

3

1

 

Total

6 hrs

 

Excel

¾

4

1

 

 

 

 

Access

½

5

1

 

 

 

 

Total

2¾ hrs

6

1

 

 

 

 

 

 

Total

6 hrs