Frederick Community
College
CIS101-ONL1
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_SecONL1_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. |
|
Discussion board Software training Hands-on activities |
|
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. |
|
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. |
|
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. |
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. |
|||
|
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. |
|
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. |
|
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. 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. |
|
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. |
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.
|
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 |
||
|
|
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 |
|
|
|
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 |
|
|
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 |
|
|
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 |
||||
|
|
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 |
|
|
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 |
||||
|
|
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 |
|||
|
|
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 |
||||
|
|
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 |
|
|
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 |
|||
|
|
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 |
|
|
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 |
||||
|
|
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 |
|
|
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 |
||||
|
|
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:
Technology in Action
|
|
Skills for Success
|
|||
|
1 |
¾ |
|
Word |
Ch. 1 |
1 |
|
2 |
¾ |
|
|
Ch. 2 |
1½ |
|
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 |
1½ |
|
10 |
¾ |
|
|
Ch. 2 |
1½ |
|
11 |
¾ |
|
|
Ch. 3 |
1½ |
|
12 |
¾ |
|
|
Ch. 4 |
1½ |
|
13 |
¾ |
|
Access |
Ch. 1 |
1¼ |
|
History of the PC |
½ |
|
|
Ch. 2 |
1¼ |
|
Under the Hood |
¾ |
|
|
Ch. 3 |
1½ |
|
Careers in IT |
½ |
|
Total |
18½ hrs |
|
|
Computing Alternatives |
½ |
|
|
|
|
|
Information Technology Ethics |
½ |
|
|
|
|
|
Total |
12½
hrs |
|
|
|
|
Assignments
|
|
Forums
|
||
|
Orientation |
½ |
|
1 |
1 |
|
First Article Approval |
1½ |
|
2 |
2 |
|
Second Article Approval |
1½ |
|
3 |
2 |
|
Research Report Outline |
1½ |
|
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 |
1½ |
|
Total |
14 hrs |
|
Web Page Programming |
1½ |
|
|
|
|
Total |
18½ hrs |
|
|
|
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 |
|
|
|
|
|
|