Description:

This course is a continuation of CPCA 110, Spreadsheets on the Microcomputer I, and will provide the student with intermediate level of spreadsheet concepts. Using typical business scenarios, the student will perform manual and automated "what-if" analyses, manage data in worksheets with tables and database functions, and use multiple worksheets to build consolidated statements. Basic macros will be introduced. 1 hr. lecture/wk.

Associated Costs: These are additional (out-of-pocket) expense considerations that students should expect in addition to the course tuition, fees, and textbooks. $10 to $20.

Supplies: Refer to the instructor's course syllabus for details about any supplies that may be required.

Textbook(s): For information see - http://bookstore.jccc.net

Course Fees: NONE

Course Objectives:

Upon successful completion of this course the student should be able to:

1. Perform what-if analysis by manual substitution of pertinent data.
2. Apply the program's automated what-if analysis tool(s).
3. Identity the elements of a database list.
4. Sort data, query and maintain data lists.
5. Filter records, and use the VLOOKUP function in database lists.
6. Insert, delete, and copy worksheets in a workbook.
7. Combine multiple worksheet files.
8. Group worksheets for group editing.
9. Create consolidated reports by referencing cells and ranges in multiple worksheets.
10. Define and use named ranges in a worksheet.
11. Record and run macros.

Content Outline & Competencies:

I. Review 
   A. Use command lines
   B. Generate charts
   C. Print Worksheets

II. Prepare and Examine What-If Alternatives
   A. Seek Solutions by Trial and Error Method
   B. Use Software Specific Goal Seeking Features
      1. Solver
      2. Create Versions and Scenarios

III. Create Worksheet Databases
   A. Create Database
   B. Set Up and Make Data Entries
   C. Sort on Single or Multiple Keys
   D. Do Criteria Searches
   E. Use Filters in Searches
   F. Use VLOOKUP

IV. Work with Multiple Worksheets
   A. Organize Worksheets in a Workbook
   B. Name/Rename Worksheets
   C. Insert Worksheets
   D. Delete Worksheets
   E. Move Worksheets
   F. Define and Use Range Names
   G. Create a Consolidation Worksheet
   H. Use Group Edits

V. Use Macros
   A. Record a Macro
   B. Run a Macro
   C. Briefly describe complex macros

Methods of Evaluation of Competencies:

Evaluation of student mastery of course competencies will be accomplished using the following methods:

A minimum of four projects     40% of grade
A minimum of two examinations  60% of grade
                              100%
Grade Criteria:
   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

Caveats: NONE

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.