/ Cerro Coso Community College
CSCI C123 Beginning Excel
Course Syllabus

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

Date / Topics / Class / Your progress
01/20/10 / Introductions, Survey, Course Syllabus,
Download data files
Tutorial 1 Getting Started With Excel
Session 1.1 / 1
01/25/10 / Session 1.2
Review / 2
01/27/10 / Case problem one
Case problem two / 3
02/01/10 / Tutorial 2 Formatting a Financial Report
Session 2.1 and Session 2.2 / 4
02/03/10 / Review
Case problem one / 5
02/08/10 / Case problem two
Turn in Midterm Theory for One and Two
Tutorial 3 Working with Formulas and Functions / 6
02/10/10 / Session 3.1 and Session 3.2 / 7
02/15/10 / Review / 8
02/17/10 / Case problem one / 9
02/22/10 / Case problem two / 10
03/01/10 / Tutorial 4 Working with Charts and Graphics
Session 4.1 and Session 4.2 / 11
03/03/10 / Review / 12
03/08/10 / Case problem one / 13
03/10/10 / Case problem two
Turn in Final Theory for Tutorials Three and Four / 14
REFER to the first page of each tutorial for a list of required files for each session.
Don’t skip anything, but READ before you follow steps…
Ask yourself what you are doing BEFORE you try to do it…
DO your Quick Check reviews and check your answers.
ASK for help when you don’t understand.

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: ______

Your Record / Grading Guide / Files and completion Checklist /
Files for Grading
Introduction and Orientation
Survey (Class Assignment)
Data SetUp (Class Assignment) Tutorial One, Session 1.1 / End of Tutorial One:
RipCity Digital Orders.xlsx
25
15 / Session 1.2
Review / Order Report.xlsx
Revised Report.xlsx
15 / Case problem one / Altac Bicycles.xlsx
25 / Case problem two
25 / Timely completion bonus for Tutorial 1 / Timely completion bonus for all Tutorial 1 work available to the end of class January 27
25 / Session 2.1 and Session 2.2 / End of Tutorial Two
ExerComp Sales Report.xlsx
25 / Review / X410 Sales Comparison.xlsx
15 / Case problem one / FrostiWear Sales Report.xlsx
25 / Case problem two
25 / Timely completion bonus for Tutorial 2 / Timely completion bonus for all Tutorial Two work available to the end of class February 8
50 / Tutorial One & Two - Mid-term Theory
25 / Session 3.1
Session 3.2 / End of Tutorial Three
Drake Family Budget.xlsx
20 / Review / Timov Family Budget.xlsx
15 / Case problem one / Chemistry 303 Final Scores.xlsx
25 / Case problem two
25 / Timely completion bonus for Tutorial 3 / Timely completion bonus for all Tutorial three work available to the end of class February 22.
25 / Session 4.1
Session 4.2 / End of Tutorial Four
New Century Fund.xlsx
20 / Review / Crockett Portfolio.xlsx
10 / Case problem one / Kenjai Fjords Park.xlsx
25 / Case problem two
50 / Tutorial Three and Four Final
25 / Timely completion bonus for Tutorial 4 / Timely completion bonus for Tutorial four work available to the end of class March 10
60 / Critical Thinking/Using Help
15 15 15 15 / Submit a printed Word document for each critical thinking submission.

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:

Assignment / Points / Your Grade
4 Session Assignments
Self Checked / Each @ 25 / 100
4 Review Assignments / 15, 25, 20, 20 / 80 / Point Grading Scale
4 Case Study One / 15, 15, 15, 15 / 60 / 540 and up / A
4 Case Study Two / 25 / 100 / 480 and up / B
Timely Completion Bonus / 4 @ 25 / 100 / 420 and up / C
Mid-term (1 & 2) / 50 / 50 / 360 and up / D
Final (3 & 4) / 50 / 50 / Below 360 / F
Critical Thinking/Problem Solving/Using Help / 4 @ 15 / 60
File Audit Report / 60
Total Points / 600

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 ______

File Name / Date Created / Time Created / Time Printed / Revision Number
Files at end of Tutorial One
Tutorial Chapter: Rip City Digital Orders.xlsx
Review: Order Report.xlsx
Review: Revised Report.xlsx
Case One: Altac Bicycles.xlsx
Case Two: Halley Foods.xlsx
Files at end of Tutorial Two
Tutorial: ExerComp Sales Report.xlsx
Review: X410 Sales Comparison.xlsx
Case One: Frosti Wear Sales Report.xlsx
Case Two: GrillRite Grills Packing Slip.xlsx
Files at end of Tutorial Three
Tutorial: Drake Family Budget.xlsx
Review: Timov Family Budget.xlsx
Case One: Chemistry 303 Final Scores.xlsx
Case Two: WizardWorks Order Form.xlsx
Files at end of Tutorial Four
Tutorial: New Century Fund.xlsx
Review: Crockett Portfolio.xlsx
Case One: Kenai Fjords Park.xlsx
Case Two: Tornado Sightings.xlsx