Information Systems Technology Department Syllabus

MIDLANDS TECHNICAL COLLEGE
Information Systems Technology Syllabus

Course Name:	Microcomputer Spreadsheets
Course No.:	CPT 174
Credit:	3.0
Prerequisite:	CPT 170 or CPT 101 or CPT 104

Course Description:

This course introduces the use of spreadsheet software on the microcomputer. Topics include creating, editing, using formulas, using functions, and producing graphs. Microsoft Excel 2007 is used in this course.

Required Textbook:

Additional Materials Required

Internet access (required for online students)

Microsoft Office 2007 software

USB (Universal Serial Bus) device for document storage

Course Learning Objectives:

Upon successful completion, the student will be able to use Excel 2007’s features to:

1. Organize, analyze, and present information in an electronic spreadsheet.

2. Demonstrate the ability to use worksheet functions and commands.

4. Demonstrate the ability to add visual interest to a workbook, create charts, and summarize and consolidate data.

5. Print worksheets using typical printing options.

6. Demonstrate knowledge of linking worksheets and exchanging data.

7. Demonstrate knowledge of how worksheets can be used as an analytical and decision-making tool.

Course Outcomes and Competencies

Intended Outcome 1: Design effective worksheets.

Course Competency: Demonstrate the ability to use worksheet functions and commands to produce effective worksheets, charts, and consolidated workbooks.

Measurement Instrument and Success Criteria: The success criteria is 75% of the students will score 80 or above on instructor assigned Excel projects (using an evaluation rubric) chapter quizzes, and tests.

Evaluation Methods and Grading Criteria

The final grade will be computed as follows:

10%

Chapter Quizzes

40%

Mid-Term and Final Exam

10%

40%

Assessing Proficiency (Unit Projects)

Projects

Grading Scale

A	94-100
B	87-93
C	78-86
F	77-0

Note: Students must earn a grade of "C" or better in all the courses offered within the Information Systems Technology Department in order for the grade to be counted toward graduation.

Late Assignments

Assignments are to be turned in on or before the announced due date. Late work will be accepted at the instructor’s discretion.

Special Accommodations

If you would like to request academic accommodations due to a disability, please contact a counselor in the Disability Resource Center,

(803) 822-3510 and (803) 738-7678 TTY telephone Airport (803) 822-3401, Beltline (803) 738-7800.

Academic Integrity

The academic honesty policy in the Student Handbook will be implemented in this course. (See Appendix I, Student Code, Section III-C, MTC Student Handbook, page 121.) All academic honesty issues will be referred to the Office of the Director of Student Life.

Attendance Policy

Students are expected to attend all class sessions and are responsible for class work, homework, lecture notes, reading assignments, etc., regardless if you are present or not. Record keeping for attendance purposes will begin the first day the class meets.

Students may not miss more than twice the number of days the class meets per week. After exceeding this limit, the instructor may take extenuating circumstances (e.g. withdrawing student from course).

There is no such thing as an EXCUSED ABSENCE. On certain occasions, circumstances may arise such as illness, personal issues, or transportation problems that prevent you from attending class. In such cases, the maximum number of absences (regardless of the reason) is still twice the number of meeting times per week. If a student must be absent, it is the student’s responsibility to notify the instructor as quickly as possible of the absence and complete missed assignments as a result of the absence at the instructor’s discretion.

For classes that meet twice a week, you are allowed no more than 4 absences; classes meeting 3 times a week, you are allowed no more than 6 absences. It is the student’s responsibility to keep track of the number of classes missed. If the number of classes missed exceeds the allowed absences, the student will be dropped from the class and will receive a “W” or “WF” as the final grade based upon the grade status as of the last class attendance.

Late arrivals disrupt class and interfere with student learning. To eliminate this, students should not be late for class or leave before class has been dismissed. If you arrive after attendance has been taken, you will be marked absent. It is your responsibility to see the instructor after class on the day of the late arrival to have your absence changed to a tardy. Three tardies is equivalent to one absence.

Withdrawals

You must officially withdraw from the course to obtain a refund and not be held responsible for coursework. If you withdraw after midterm, you will receive either a “W” or “WF” based on your grade on the last day you attended class (“W” if passing, “WF” if not). A “WF is computed in your GPA and counted as an “F.” Please check with the cashier’s office for further information regarding refunds.

Inclement Weather

The College may be closed because of inclement weather. This news should be available on the website at http://www.midlandstech.edu/at the main phone number at 738-1400, and announced on WIS-TV and radio. Please check frequently in changeable weather for closings and re-openings. If the College closing or reopening means that you will have at least 30 minutes of a class, you should come to class. Please do not call the IST Department office or the President’s office with closure questions.

Campus Emergency Protocol

Students and employees are asked to report safety concerns or suspicious activities to Campus Security at 7199 (on campus) or 738-7199 (cell phone and off campus). In the event of an emergency, student and employee protocol is to immediately call Campus Security or local 911. If an emergency occurs, employees and students may seek additional information and instructions via MTC Information Centers, email, college Intranet, the MTC website, campus voice mail and loud speakers.