Maricopa Community Colleges  BPC114AC   19926-19956 
Official Course Description: MCCCD Approval: 12/12/95
BPC114AC 19926-19956 L+L 1 Credit(s) 2 Period(s)
Supercalc: Level I
Computer spreadsheet skills for solving business problems using Supercalc, including calculations, forecasting, and projections. Prerequisites: None.
Cross-References: CIS114AC
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC114AC   19926-19956 Supercalc: Level I
1. Load and set up the spreadsheet program. (I)
2. Create a properly formatted worksheet file. (II)
3. Build a template using labels, numbers, and formulas. (III)
4. Enter, delete, and alter spreadsheet data. (IV)
5. Save a spreadsheet on disk and retrieve it. (V)
6. Print a spreadsheet on the printer and on disk. (VI)
7. Sort a spreadsheet in a variety of ways. (VII)
8. Create and print a graph. (VIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC114AC   19926-19956 Supercalc: Level I
    I. Speadsheet Concepts
        A. Loading
        B. Terminology
        C. Set up
      II. Creating a Worksheet file
          A. Using proper keys
          B. Aligning data within cells
          C. Reformatting data within cells
        III. Building an electronic spreadsheet template
            A. Entering formulas
            B. Using proper symbols
            C. Algebraic hierarchy
          IV. Entering Data
              A. Entering new data
              B. Deleting existing data
              C. Modifying existing data
            V. Saving and retrieving files
                A. Saving a spreadsheet file on disk
                B. Updating and correcting a spreadsheet file
                C. Replacing a spreadsheet
              VI. Printing a spreadsheet
                  A. Controlling margins and options
                  B. Printing on the printer
                  C. Printing on the disk
                VII. Sorting a spreadsheet
                    A. Sorting in ascending order on rows or columns
                    B. Sorting in descending order on rows or columns
                  VIII. Creating and printing graphs
                  Go to Description    Go to top of Competencies    Go to top of Outline