Syllabus - CIS 235 IT in Business

Fall 2009

Description

CIS 235 - Information Technology in Business uses advanced software (Word 2007, Excel 2007, PowerPoint 2007 and Access 2007) to solve and analyze business problems using integration of the applications in a business environment.


Recommended prerequisite: CIS 120 and CIS 131
Credits: 4 (Lecture: 3; Lab: 2)

Course Outcomes

There are three primary outcomes for this course. Students will show their achievement of these outcomes by demonstrating their skills and understanding with individual competencies as measured by the course activities.


  1. Use Office suite software for communication, sharing/promoting ideas, and documenting procedures.
  2. Create and manage a database for efficient and effective decision-making.
  3. Demonstrate problem-solving with software.


Some of the specific skills I'll ask students to demonstrate during the course via assignments and exams will be...


Prerequisite Skills

Prior to starting class, CIS 235 students need to possess digital literacy skills as demonstrated by successful completion of CIS 120 or IC3 Certification and software skills as demonstrated by successful completion of CIS 131. These skills include, but are not limited to...


Meeting Time/Location

This course meets Mondays and Wednesdays from 10:15am to 12:30pm.

Exams

This course has a mid-term exam and a final exam. The final exam is cumulative and will assess understanding and skills practiced throughout the entire course. Check the schedule below for exam dates.

Instructor

Ralph R Phillips, Assistant Professor

My e-mail address is rrphillips [at] cocc.edu. Please use descriptive subjects when sending an e-mail. "Problem changing page orientation for one page" is a better subject line than "Help!". E-mails without a subject are filtered to get automatically trashed. See http://rrphillips.cocc.edu for more contact information.

Course Text and Supplies

Microsoft Office 2007 In Business Core (2nd Edition) (Paperback)
by Joseph J. Manzo (Author), Dee Piziak (Author), Christine J. Rhoads (Author)

The course text is requied and will be used for graded activities including quiz and exam preparation. This course will also make extensive use of resources online:



For the greatest convenience, students should use a portable USB drive for file management. Portable USB drives are readily available for under $10 at office supply and electronics/computer stores.

Students will also need to use 2007 versions of Microsoft Word, Excel, PowerPoint, and Access during the course. These programs are available at school labs and students can acquire Microsoft Office Ultimate for only $59.95. This is a great deal and worth the money.

Course Topics and Activities Schedule

Unless stated otherwise, the activities are due at 11:59pm. Although quizzes aren't listed in the schedule, we will tend to have at least one quiz per week, sometimes two. Some quizzes will be taken in class and some will be taken at home depending on time available and the topic.

Row
Week
Date
Topic
Activities Due
1
1
09/21/09
PowerPoint: Creating a Basic Presentation
Assignment 1 due Friday, 09/25
2
1
09/23/09
PowerPoint: Enhancing Your Presentation
Assignment 2 due Monday, 09/28
3
2
09/28/09
Excel: Basics
Assignment 3 due Friday, 10/02
4
2
09/30/09
Excel: Calculating DataAssignment 4 due Monday, 10/05
5
3
10/05/09
Excel: Evaluating DataAssignment 5 due Friday, 10/09
6
3
10/07/09
Excel: Evaluating DataAssignment 6 due Wednesday, 10/14
7
4
10/12/09
Columbus Day - college Closed
Assignment 7 due Sunday, 10/18
8
4
10/14/09
Excel: Presenting InformationAssignment 8 due Monday, 10/19
9
5
10/19/09
Excel: Presenting Informationn/a
10
5
10/21/09
n/a
Mid-term Exam
11
6
10/26/09
Word: Basic ReportsAssignment 9 due Friday, 10/30
12
6
10/28/09
Word: Document EnhancementsAssignment 10 due Monday, 11/02
13
7
11/02/09
Creating an Online PresenceAssignment 11 due Friday, 11/06
14
7
11/04/09
Video and ImagesAssignment 12 due Monday, 11/09
15
8
11/09/09
Access: Tables and Database BasicsAssignment 13 due Monday, 11/16
16
8
11/11/09
Veteran's Day - college closed

17
9
11/16/09
Access: Selecting and Summarizing Data
Assignment 14 due in class, 11/18 and Assignment 15 due Friday, 11/20
18
9
11/18/09
Access: Calculating Data
Assignment 16 due Monday, 11/30
19
10
11/30/09
Access: Reports
Assignment 17 due Friday, 12/04
20
10
12/02/09
Access: Reports
n/a
21
Finals
12/07/09
n/a
Final Exam

Calculating Your Grade

Activities completed will be worth a certain amount of points depending on the activity category. A student will know their current standing in class by dividing the total number of points earned by the points possible up that time. So, if by week seven a student has earned 550 points and 720 points have been possible, then that student would have 76.4% (550/720) at week seven. A course will have approximately 1,000 points possible.


Quizzes
about 200 points
Assignments
about 450 points
Mid-term Exam
150 points
Final Exam
200 points


By keeping track of the number of points earned a student will know their percentage grade by dividing points earned by points possible. With percentage grade known, the letter grades will be...


A
94% or higher
A-
90% - 93.9%
B+
87% - 89.9%
B
84% - 86.9%
B-
80% - 83.9%
C+
77% - 79.9%
C
70% - 76.9%
D
60% - 69.9%*

*CIS students must earn a C or higher for the credits in that course to count as part of their degree. For courses that offer a pass/fail, a C or higher must be earned in order to be considered a pass.

Late or Incomplete Assignments/Activities


Students that miss a class are responsible double-checking the topics schedule and for getting notes from classmates and reviewing class recordings/handouts (if available). Asking "what did I miss in the last class?" will get a needle poked into the voodoo doll likeness I keep of every student.

Incomplete Course Grades

Getting an Incomplete for a course grade is very rare. To be considered for an incomplete grade, students must...



Students who haven't shown they were on track to earn a C or higher should withdraw from the course prior to the eighth week.

Commitment

Being busy does not always mean real work. The object of all work is production or accomplishment and to either of these ends there must be forethought, system, planning, intelligence, and honest purpose, as well as perspiration. Seeming to do is not doing. -- Thomas Edison



Success in any class depends greatly on the student's commitment. A full-term, 4-credit course requires approximately 12-15 hours of work, each week, away from class. This includes reading the text, working on assignments/projects, and practicing the skills demonstrated in class or online. Students seeking exceptional grades often need to put forth exceptional effort, working for more than 12 hours in a week for a particular class.


Disability Accommodations

Students with documented disabilities who may need accommodations, who have any emergency medical information the instructor should know of, or who need special arrangements in the event of evacuation, should make an appointment with the instructor as early as possible, no later than the first week of the term. Students any also wish to contact the COCC Disabilities Services Office in Boyle Education Center, extension 7583.


Personal Counseling, to help with time management, stress, depression and the many other personal situations affecting students. Call the CAP Center at 383-7200 to schedule an appointment.

Insurance

Students are not covered by medical insurance while on campus or involved in college classes and activities. Students are responsible for their own medical and dental insurance coverage. Information on student insurance coverage can be obtained at the student health center in Grandview or at the cashier in the Boyle Education Center. If you have specific questions or concerns regarding student insurance coverage you should discuss them with the Program Coordinator or Department Chairperson.

Plagiarism

All students are expected to practice the highest standards of academic honesty. Cheating on assignments, quizzes or exams or plagiarizing other people's work is unacceptable and may lead to a failing grade. Plagiarism is using, borrowing or stealing someone else's words or ideas without giving appropriate credit to the original author. This includes copying definitions and sentences from textbooks, other student's papers, the Internet or any other source. Students are expected to complete all assignments independently, unless it is a designated group project. In addition to traditional forms of cheating, cheating in a computer class includes:



When in doubt, ask.

Equal Opportunity Policy

COCC has a continuing commitment to programs of equal opportunity and affirmative action to extend community services and educational, employment and promotional opportunities to all legally protected classes.


COCC does not discriminate on the basis of age, disability, gender, marital status, national origin, race, religion, sexual orientation or veteran status. The College complies with all federal legislation and civil rights laws of the State of Oregon.