Description:

Students will learn concepts and uses of spreadsheet software on the personal computer. Business decision-making worksheet models will be created and modified by entering labels, functions and formulas. Various formatting techniques will be applied to enhance the appearance of printed worksheets. Students will also learn to display the worksheet data graphically with the charting capabilities of the software. 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. Analyze problems to determine whether they can be solved with spreadsheet software.
2. Work through sample problems, such as budget preparation and expense monitoring.
3. Enter and align labels and numbers.
4. Enter functions, formulas with relative and absolute cell referencing.
5. Copy formulas and data from a cell or range to another cell or range on the worksheet.
6. Edit the contents of cells.
7. Erase a specific area of the worksheet
8. Insert and delete rows and columns in a worksheet
9. Format numbers to display specific attributes.
10. Format cells or ranges to display lines, shading and fonts that differ from default settings.
11. Save a worksheet file to a specific directory or drive.
12. Retrieve a worksheet file from a specific directory or drive.
13. Define and create charts (graphs) from specified data in a worksheet.
14. Add or modify specific titles and legends in a chart.
15. Print ranges, entire worksheets and charts with specified headers and footers.

Content Outline & Competencies:

I. Introduction to Spreadsheets 
   A. Overview of Spreadsheets
   B. Characteristics of the Specific Spreadsheet Program

II. Work with the Specific Spreadsheet
   A. Load the Program
   B. Move Around the Spreadsheet
   C. Enter Labels, Values and Formulas
   D. Save and Retrieve
   E. Use the Command Menus and Tool Icons
   F. Enter Headers and Footers

III. Utilize Spreadsheet commands
   A. Copy Formulas
   B. Use Predefined Functions
   C. Insert and Delete Rows and Columns
   D. Use Help Features
   E. Perform Range Operations

IV. Employ Charts
   A. Define Manual and Automated Charts
   B. Position in Same Worksheet or Separate Worksheet
   C. Specify Bar, Pie and Line Styles
   D. Enter Titles, Legends, and Data Display

Methods of Evaluation of Competencies:

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

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
Total                          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.