CIS1 & CIS23 Syllabus Winter 2009

 

CIS1 Principles of Business Computer Systems provides in-depth coverage of the selection and use of computer hardware and software. CIS1 and 23 are required in all CIS degree and certificate options and is the computer skills transfer requirement for many universities. This is a semester class starting February 9th and ending June 8th.

 

With the successful completion of this course, you will be able to:
(1) Describe the function of computer hardware components; processor, memory, input/output, peripherals
(2) Describe how data are represented in the computer system
(3) Select the proper type of software and licensing to solve an information processing need
(4) Organize files and programs using the Windows system software
(5) Prepare common business documents using Microsoft Word
(6) Construct a spreadsheet model of a problem using Microsoft Excel
(7) Organize data into a database system using Microsoft Access
(8) Collect information from the Internet using browser software
(9) Operate an email system to send and receive text and files
(10) Compare the strengths and weaknesses of various types of storage media and backup systems
(11) Describe the connection methods and operation of computer networks
(12) Explain how interactive web sites are created
(13) Discuss threats to data and protection methods; viruses, hacking,
(14) Compare popular formats for digitizing graphics, sound and video
(15) Explain how programs are designed, coded and tested
(16) Describe the activities that occur during the system development life cycle
(17) Describe the structure of the computer industry and types of careers available

 

Course Requirements:

Textbooks: The books are sold as a bundled set in the campus bookstore with a special ISBN number. ISBN numbers for each book are provided in case you want to shop somewhere other than the campus.

 

Book 1 (Office 2007):

Authors: Gary, Shelly, Thomas Cashman and Misty Vermaat

Title: Microsoft Office 2007 Brief Concepts and Techniques

Publisher: Thomson/Course Technology

Single Book ISBN: 1418843253

The introductory edition is OK.

 

Book 2 (Understanding Computers):

Authors: Morley, Deborah and Charles Parker

Title: Understanding Computers Today and Tomorrow 12th Ed. Comprehensive

Publisher: Thomson/Course Technology

Single Book ISBN: 1423925211

Do NOT get the introductory version.  You need the full version.

 

CIS23 Lab: You must be enrolled in a section of CIS23 Programming Laboratory. CIS23 is one unit Credit/No Credit. You receive credit in the lab if you pass the CIS1 class. If you are not enrolled, contact me right away for an add slip. If you plan to do your assignments at home, I recommend that you take the CIS23 #3061 section with Kotelyan. If you prefer to do your work at a scheduled time on campus, talk to me about which section of CIS23 to enroll in.

 

Office Software: Lessons are based on Microsoft Office 2007 Professional (Word, Excel, PowerPoint and
Access) and Windows XP or Vista. The non-professional version of Office does not include the Access database.
Office 2007 Professional software can be purchased at a student discount through http://www.journeyed.com/fccc/

 

Time: The class time for CIS1 and the CIS23 lab is about 4 hours and 15 minutes per week. You need to allow additional time to complete assignments and study the textbooks outside of class. Block out at least 6 hours per week for the class. Some people will need more time and others need less depending on computer experience and reading speed. If the computer you are using breaks down, keep up with the work by using the campus computer labs in the Business building or the Library.

 

How to Contact Me:

On-Campus Hours: 10:00pm – 10:30pm, Mondays

Email: Send email to mark@chastek.com. Mail sent to me must include a descriptive subject line, your full name and the class you are enrolled in.  Do not send me jokes or chain letters.

 

What You Will Be Doing:

In Class: Most weeks, there is one lesson that may include lectures, in-class activities, guided computer practice and an assignment. You receive points for each class meeting you attend. There is no makeup for attendance credit.

Outside of Class:

Reading and Practice: Read chapters in the textbook and practice skills.

Assignments: Assignments may include study questions and hands-on practice with software. Assignments are due one week after they are assigned. Keep backup copies of everything you turn in just in case. Assignments can be submitted up to 1 week late, but will receive a 10% (one grade) lower score for each half week it is late. Assignments will not be accepted after the late submission period is over. The last assignments do not have this extra time.

 

Grades:

Your course grade is based on the points you earn of the total 700. A's are 90% or better, B's are 80% or better, C's 70% or better, D's 60% or better, F below.

Activity

Points

Percent

Attendance Credit

80

11

Assignments

320

46

Tests

300

43

Total

700

 

 

 

 

 

 

 

 

Dropping the Class and Incompletes:
It is your responsibility to drop the class AND the lab. If you do not drop by the deadline, you will receive a letter grade. See the Schedule of Classes for important drop dates. I do not give incompletes. Instead, I give you the grade you have earned by the end of the semester and change the grade after you have completed the work. This consideration will only be given only for medical or other reasons beyond your control. You must be up-to-date with all work and passing the class at the time you notify me that you have had an emergency. Let me know as quickly as possible and submit a detailed schedule for completing the rest of the class. You will not be allowed to do this because you fell behind with your assignments, had computer problems, or don't like your grade so far.

 

Cheating:

Your submissions should be your own independent work unless the instructions indicate that you may work with others. If I feel that two submissions are too similar, I will give both a lower score or even a zero depending on how much was copied. I will not be open to discussion about the reasons why it happened or who actually did the work. The second incident will result in an F in the class.

 

Website:

The website for this class will be http://www.chastek.com/CIS1.  This syllabus, along with all homework assignments, will be posted on the website.
Schedule (Subject to Change)

Date/Lesson

Textbook Topic

UC: Understanding Computers textbook

OF: Office 2007 textbook

Assignment

Test

2/9 Mon

Get Textbooks.

Set up email and send me an message

10 Extra Credit points

 

2/16 Mon

LINCOLN/WASHINGTON’S BIRTHDAY (No Class)

 

2/23 Mon

UC: Ch. 1 Introduction to the World of Computers

 

Introduction to Computers

Due 2/23

Ends 3/2

 

3/2 Mon

UC: Ch. 5 System Software

OF: Windows Ch. 1

 

System Software and Windows

Due 3/2

Ends 3/9

 

3/9 Mon

UC: Ch. 6 Application Software

OF: Word Ch. 1

Application Software and Word

Due 3/9

Ends 3/16

 

3/16 Mon

UC: Ch. 2 The System Unit: Processing and Memory

OF: Word Ch. 2 Creating a Research Paper

System Unit and Research Paper

Due 3/16

Ends 3/23

 

3/23 Mon

UC: Ch. 3 Storage and Ch. 4 Input and Output

Storage and Input/Output

Due 3/23

Ends 3/30

Test on first 4 meetings

75 points

3/30 Mon

UC: Ch. 7 Computer Networks

UC: Ch. 8 The Internet and World Wide Web

Networks and Internet

Due 3/30

Ends 4/6

 

4/6 Mon

SPRING BREAK (No Class)

 

4/13 Mon

OF: PowerPoint Ch. 1 Creating and Editing a Presentation

OF: PowerPoint Ch. 2 Creating a Presentation with Illustrations and Shapes

PowerPoint

Due 4/20

Ends 4/27

 

4/20 Mon

UC: Ch. 10 Multimedia

Multimedia

Due 4/27

Ends 5/4

 

4/27 Mon

UC: Ch. 14 Databases and Database Management Systems

OF: Access Ch. 1 Creating a Database

Databases

Due 5/4

Ends 5/11

 

5/4 Mon

OF: Access Ch. 2 Querying a Database

Database Queries

Due 5/11

Ends 5/18

Test on previous 4 meetings

75 points

5/11 Mon

UC: Ch. 15 Computer Security and Privacy

OF: Excel Ch. 1 Creating a Worksheet  and Embedded Chart

Security and Excel Worksheet

Due 5/18

Ends 5/25

 

5/18 Mon

OF: Excel Ch. 2 Formulas, Functions, Formatting and Web Queries

Worksheet Formulas and Formatting

Due 6/1

Ends 6/8

 

5/25 Mon

MEMORIAL DAY HOLIDAY (No Class)

 

6/1 Mon

UC: Ch. 12 Information Systems & System Dev

UC: Ch. 13 Program Dev & Programming Languages

Information Systems & Programming

Due 6/8

No late submission

 

6/8 Mon

End of class, all work due

 

Final Exam

150 points