Skyline College CAOT 225 SpreadSheet I:Excel Syllabus - Fall 2009 Instructor: Sita Motipara Phone: 650.738-4356 Office: Building 8, Room 8207 E-mail: motipara@smccd.edu Office Hours: MW 12:00-2:30 Web Site http://www.smccd.net/accounts/motipara/index.htm Class Duration: 8/19/09-9/25/09   Class schedule and assignments Instructions on How to check grades Check Grades

PREREQUISITE & RECOMMENDATIONS:

Recommended: CAOT 104 or Equivalent

COURSE DESCRIPTION:

CAOT 225 AS - 88294 AS SpreadSheet I: Excel | 1.0 unit - 16 hours | Transfer: CSU

In this class we learn to use MS Excel software to create, format, modify and print spreadsheets. We also learn to use formulas and functions and basics of creating charts. Classroom instruction will include lecture and hands on demo. All the assignments are from the required textbook or the instructions will be given in the classroom.

STUDENT LEARNING OUTCOMES:

Upon successful completion of this course, you will be able to:

• create, open, edit, save and print spreadsheets
• understand and apply formulas
• create charts based on spreadsheet information
• use the speller, find and replace features
• understand file management
• use font color to enhance worksheets
• display and print formulas
• apply the average, max, and min functions
• use absolute and relative cell references
• use multiple sheets to organize information
• apply Auto Format to a spreadsheet
• use the if function to perform a logical test

TEXTBOOK AND OTHER MATERIAL:
Text

Microsoft Excel 2007: Complete Concepts and Techniques by Shelly, Cashman, Quasney published by Course Technology/ITP. ISBN: 978-1-4188-4344-1. Published August 29, 2007.

Hardware
System Requirements:

Software
We will be using MS Excel version 2007 in this class. Using MS Excel version 2003 will create problems because the text we are using for the course has directions for 2007 version and it is frustrating when the directions in the book does not match with your screen. If you have older version and are thinking to upgrading, it is available at a great bargain price for community college students at journeyed.com or is available at Skyline College Bookstore at a discounted price with your student ID. Do not buy the standard version of MS Office. It does not include MS Access, which you might use in the future.

You may also download the trial version from Microsoft's web site.

If you are not updating yet, but still need an access to office 2007, you can complete your work during lab hours in Building 8 Room 8119 or 8121only. The other labs on campus do not have the software or can provide support.

ASSIGNMENTS:

• Assignments will be graded only once, so it is important to proofread all work the work carefully. If you have omissions or errors, you may revise your work; however, your grade will not change.
• In order to receive credit or grade for any turned in assignments or project, it should be completely completed as instructed in the PDF documents or in the textbook. PDF documents will be usually linked through assignment page.

Homework assignments.....................40%
Quizzes/final exam............................... 40%
Final Project...........................................20%

GRADING POLICY:

You may take this class for either a letter grade or for credit. (To receive credit for the course, you need an average grade of 70 percent or higher.) You can select your option though Websmart.

Please refer to the Skyline College Catalog, pages 28-29, for a complete discussion of Academic Integrity. The two most common kinds of academic dishonesty are: cheating and plagiarism. Any student who is caught obtaining or attempting to obtain academic work through the use of dishonest, deceptive, or fraudulent acts may be dropped from the class and issued a grade of F. Please refer to these pages to make sure you understand all the examples of what may be considered academic dishonesty.

How to Check Grade Online:

How to Check Grade:

To check grades: Click on the above check grade link. To view your grade, type your name and ID code as shown in the example below. You have to include your middle initial only if you registered with it. Notice the required comma after last name, and period after initial. First character of last name and first name should be uppercase. G should be in uppercase when you type your ID.

Student Name: Motipara, Sita R.
Student ID: G00112233

 

CLASS FORMAT:

Microsoft Excel concepts and features will be introduced each week with assigned exercises You should plan on scheduling a minimum of three to four hours each week to complete the reading and the assignments. Excel must be used to complete assignments which will be uploaded to your instructor's folder on a shared drive.

Instructor Availability

Please refer to my office hours. If you cannot make it during office hours, make an appointment to see at a convenient mutual time.

ClASS PARTICIPATION:

WITHDRAWL POLICY:

LAB AVAILABILITY:

Assignments may be completed in the Skyline CAOT labs which are located in Building 8, Rooms 8119 and 8121 only. Generally, the labs are open between 8:00-4:30 pm Monday through Friday, with lab hours available on some evenings and saturdays. The specific lab hours are posted on the classroom doors. The other labs on the campus - in Building 2 or learning center - do not have the software or any support.

*The syllabus is subject to change in the event of extenuating circumstances.