Instructor: Karen O Connor E-Mail

Instructor: Karen O’Connor E-mail:

Room:

LRC 710

Class Time: 6:45-8:55 p.m

Dates: Mon. and Wed. January 20, 2010 to May 12, 2010

(February 15th is a holiday)

Office Phone: 760 384 –6172

CRN: 30125

Units: 1.0 (36 hours – 27 lab and 9 lecture)

Attendance/Make-Up Policies: Cerro Coso Community College policy states that you may be dropped from the class after four un-excused absences. If a student wishes to drop the class it is the student’s responsibility to officially drop the class by contacting the admissions and records office.

Required text and software:

New Perspectives Microsoft Office Excel Comprehensive - Parsons, Oja, Ageloff & Carey Publisher: Thompson Course Technology 2008 ISBN 978-1-4239-0585-1

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Excel 2007.

Case Grader for Excel ISBN 978-1-4239-9823-5

PLEASE NOTE that the “bundled” ISBN for these items combined in our bookstore is a unique ISBN.

Course Description:

This hands-on microcomputer course is designed to provide a basic understanding of spreadsheets. Spreadsheet design, creation, revision, formatting, and printing are covered. This course begins to prepare students for the Microsoft Certified Application Specialist exam in Excel 2007 (Prerequisites: None.) Advisory: CSCI C070 or CSCI C101 or equivalent.

Course Outcomes:

Upon successful completion of the course, the learner will be able to:

• Work with cells, worksheets, workbooks, and MS Excel files
• Format worksheets
• Set up MS Excel page formats
• Print worksheets and workbooks
• Work with formulas and functions
• Work with charts and objects

Class Schedule for Fall 2009

You will be provided with a folder to keep your printouts organized. Please bring your folder to class each week, and use these handouts to help keep organized. You may wish to use a “travel” drive if you are working both at home and on campus. Always back up your files.

Never skip a class just because you don’t have your textbook or folder with you.

Sign in on the attendance sheet for each class and if you miss a class make a note on the previous or subsequent attendance sheet.

Grading Guide for CSCI C123 Beginning Excel Name: ______

Use the checklist above to keep track of which files you need to print for grading.

Please keep this grading guide on the top of your folder printouts

You are responsible for comparing your sessions (chapter) work at the end of each tutorial with the printouts in the binder. Make sure your work matches the work that is shown and you will earn your sessions points. Print the tutorial spreadsheets and check your tutorial work with the sample in the binder BEFORE you show me you have completed the tutorial assignments.

I will grade the review (green pages) and case study one for each tutorial, using the rubrics in the binder. Sample printouts of the review and case studies are shown in the Excel samples binder in your classroom. Matching your work with the work in the binder will help you earn the highest points for each worksheet. Please do not remove the samples binders from the classroom.

You are responsible for showing me that your work is completed for each tutorial before the end of the class indicated on the schedule for the timely completion bonus due date. Absence from class is not an excuse for missing the timely completion bonus due date. The purpose of the timely completion bonus is to simulate a work environment where due dates are due dates, but to also allow for submission of work up to the end of class. Those who complete the work on time will earn the highest possible points for their work.

Grading Policy: Course grades will be based on the following:

Duplicate Files: The time and date stamp for files will be spot checked. No duplicate files between students will be awarded points for either student.

Accommodations: The College will make reasonable accommodations and/or academic adjustments to ensure that students with disabilities have an equal opportunity to participate in the college’s courses. Students with disabilities, who are requesting academic accommodations, auxiliary aides or services, contact Special Services at 760-384-6250.

Changes: The instructor holds the right to change the syllabus when necessary and appropriate. If there is a revision it will be clearly communicated to you in writing.

Survey for CSCI C123 Beginning Excel

Name:Date:

1. How would you describe your comfort level with using a computer?

1. Briefly describe your experience with MS Excel if any.

1. Do you use or need to use Excel for your current job?

1. Have you previously used earlier versions of Excel?

1. In general, what are you hoping to learn in this class? Or, What are your expectations for your learning experience in this class?

1. Do you have Excel at home (or work) and if so which version?

1. Have you taken either CSCI C070 Computer Literacy OR CSCI C101 Introduction to Computer Information Systems at Cerro Coso? (or do you have a similar course from another college.)

1. How comfortable are you with computer file management? Have you ever downloaded a file from the Internet? Do you know how to find files on your computer?

Other comments:

Critical Thinking – Problem Solving – Using Help

Five percent of your grade will be calculated directly as a result of documenting your critical thinking, problem solving, and “Help” research experiences as you progress through the course. Four times in the course you may submit a written record of a situation where you solved a problem in a creative way.

Today’s employee is required to show good problem solving skills using the sophisticated applications now available for our use. It is also critical that you practice using “Help” and other resources while you learn and use this application program.

Individuals will experience a variety of situations that require problem solving. What works easily for one person may not work easily for another. This exercise is intended to honor the increasing need to develop ability and comfort with using available resources to extend your understanding of each application program.

Keep track of situations and submit the BEST one for each tutorial. To earn full marks, you will need to briefly describe the situation or problem, what you did to solve it, and identify any resources you used. Half marks will be deducted for spelling or incomplete sentences. One sentence is not enough to earn full marks for this exercise. To submit your experiences for possible credit, use Microsoft Word to create a document containing the following information and print the document for your folder. The topic must be related to use of the application program itself.

Name:

Date:

Course Name:

Problem:

Resources used:

Solution:

File Audit Record for ______