Syllabus

Introduction to Spreadsheet Applications

INSTRUCTOR:	Prof. Karen Penn de Martinez  Office: Macklin Tower 408 Phone: (240) 567-7661 E-Mail: kpenndem@mc.cc.md.us
OFFICE HOURS:	M: 4:00-6:00, W: 5:00-6:00 or by appointment
DEPARTMENT:	Computer Applications
COURSE NUMBER:	CA 151
CREDIT HOURS:	3
PRE- or COREQUISITES	CA106 or consent of department. Assessment levels: EN101/101A, MA100, RD 110

CATALOG DESCRIPTION:

A practical introduction to the creation, design, and use of spreadsheets in the business environment. Emphasis will be placed on basic functions including creation, formatting, maintenance, graphing and printing of spreadsheets. This course is designed for beginning spreadsheet users. Lessons can be applied to budgets, marketing, and sales reports, expense reports, invoices and purchase orders, basic financial statements, and spreadsheet information for use on the Intranet/Internet

TEXTS/MATERIALS (Required):

EXCEL 2002:CORE+EXPERT, Stewart.

Three 3 ½;" double-sided, high density disks.

OBJECTIVES:

Development and Enhancement of Non-technical Skills

• Speak and write about the course topics with sufficient proficiency
• Apply critical thinking to a variety of topics in the course

Electronic Spreadsheet Software

• Explain the purpose of electronic spreadsheet software and its application to solve common business problems

Spreadsheet creation

• Open electronic workbooks
• Enter text and numbers
• Enter formulas
• Save workbooks
• Close workbooks

Modify spreadsheet data

• Delete cell contents and worksheets
• Revise text, numbers and formulas
• Rotate and indent text
• Copy and move data
• Insert, modify and delete rows and columns
• Use references
• Sort data

Print spreadsheet

• Preview and print worksheets
• Print screen and ranges
• Print using headers and footers

Save spreadsheets for web use

• Save spreadsheets as HTML files

Format spreadsheet data

• Modify cell size and alignment
• Apply general numbers formats
• Apply font formats
• Apply outlines

Create and apply ranges to data

• Create and name ranges
• Clear and format ranges
• Copy and move ranges
• Integrate range names

Use functions and solve mathematical problems

• Use AVERAGE, MAX, MIN functions
• Use worksheet and date functions
• Use the Scenario Managers
• Use the Goal Seeker and the Solver

Use draw tools to enhance worksheets

• Create and modify lines and objects Create and modify 3D shapes

Use charts

• Create, format and modify charts
• Preview and print charts

 

GRADING:

Attendance/Participation	10
Homework Assignments	25
Quizzes	20
Midterm Exam	15
Final Project	10
Final Exam	20

Course Grade: <59=F, 60-69=D, 70-79=C, 80-89=B, 90=A

CLASS ATTENDANCE/PARTICIPATION:

Students are expected to attend all class sessions. In the case of absence, it is the student’s responsibility to get class material/work assignments from the course website or other class members. You will be responsible for all work assigned whether you are present or absent. Assignments and announcements will be posted regularly at the course website at http://distance.montgomerycollege.org. Check the site regularly, as you are responsible for all posted information.

Due Dates: All assignments are due at the beginning of class on the due date. Spreadsheet files must be uploaded to the course website, where instructions for the upload process will be provided. Any papers handed in must contain your name, the document or assignment title, and be stapled in order. No folders, please. Assignments turned in after their due date will be subject to a 10-point penalty for each calendar day late.

Tardiness: Class begins promptly at the scheduled time. Students are expected to be on time. If you miss more than ten minutes of class, your attendance/participation grade for that day will be reduced by 50%.

Missed Quizzes/Exams: In the case of legitimate, documented emergencies, the instructor may, at her discretion offer a make-up. If no documentation is available, and the instructor does permit a make-up, you will automatically lose 15% on the grade of that quiz or exam.

PARTICIPATION/APPROPRIATE IN-CLASS ACTIVITIES:

Students are expected to spend class time working on activities for this class. Use of the Internet shall be strictly limited to activities for this class. Behavior that impedes the learning of others, or failure to participate in class activities will cause your attendance/participation grade for that day to be a zero.

POLICY ON ACADEMIC INTEGRITY:

Cheating, plagiarism and/or other forms of academic dishonesty will not be tolerated. Refer to the Code of Conduct section of the Student Handbook.

Any occurrence of academic dishonesty, including cheating, plagiarism, submitting someone else's work, or helping another student to cheat, or any violation of the Code of Conduct will result in a zero for that assignment as well as an automatic 10-point reduction of your total semester grade.

HARDWARE AND SOFTWARE:

It is necessary for the student to have access to a computer with the XP version of Excel in order to practice some of the assignments given in class. If your machine does not have that version, you will have access to the campus computer labs. Locations, hours, rules and guidelines are published by the Academic Computing Team.

POLICIES:

Students should refer to the Student Handbook for the official wording of all academic, classroom, and collegewide policies. Students are expected to abide by the Code of Conduct of the Student Handbook.

AUDIT POLICY:

• The grade of "AU" (registered for Audit) will be recorded if the student so requests and if approved by the instructor before the deadline date.
• Students registered for audit are required to participate in all course activities unless otherwise agreed upon by the student and instructor at the time registration for audit occurs. Failure to participate may result in the grade of "W" being awarded.

STATEMENT ON DISABILITIES:

All classes offered at Montgomery College must meet the requirements of the Americans with Disabilities Act of 1990. If you have a disability that will require accommodations, please see me after class or during my office hours. We should be able to work out whatever arrangements are necessary, including special seating, testing, or other accommodations. If you have not already contacted the Disability Support Services office (CAB 122), [Rockville: (240) 567-5058; TDD (301)294-9672] please do so to obtain a letter authorizing your accommodations.

WEATHER ALERT

Occasionally it becomes necessary to delay the opening of school, send students home early, or close the College entirely because of bad weather. The following stations, among others, have agreed to broadcast information about Montgomery College closings or delayed openings because of inclement weather:

AM	FM	TELEVISION
WTOP 1500	WWDC 101.1	CHANNEL 9

For a recorded announcement call (240) 777-6500. You may also check the main college page at: www.montgomerycollege.edu.