Maricopa Community Colleges  CIS114DB   19926-19956 
Official Course Description: MCCCD Approval: 12/12/95
CIS114DB 19926-19956 L+L 3 Credit(s) 5 Period(s)
Multiplan Spreadsheet
Computer spreadsheet skills for solving business problems using Multiplan, including calculations, forecasting, projections, macro programming, database searching, extraction, linking, statistics, and matrix manipulation. Production of graphs and reports. Project design using multiple, integrated spreadsheets. Prerequisites: None.
Cross-References: BPC114DB
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS114DB   19926-19956 Multiplan Spreadsheet
1. Load and set up the spreadsheet program. (I)
2. Create a properly-formatted worksheet file. (II)
3. Organize a problem for solution with spreadsheet software. (III)
4. Apply the principles of effective worksheet and database layout in building a spreadsheet template, using labels, numbers, and formulas. (III)
5. Enter, delete, and alter spreadsheet data. (IV)
6. Save a spreadsheet to disk and retrieve it. (V)
7. Print a spreadsheet on the printer and on disk, using spreadsheet print capabilities to enhance printed output. (VI)
8. Sort a spreadsheet in a variety of ways. (VII)
9. Use spreadsheet functions to prepare and print graphs. (VIII)
10. Create and use complex spreadsheet macros. (IX)
11. Use the spreadsheet's database techniques to locate, link, extract, and combine data from multiple spreadsheets. (X)
12. Use built-in statistical analysis features of spreadsheet software. (XI)
13. Manipulate matrices with spreadsheet software. (XII)
14. Design and implement a spreadsheet project which includes multiple, integrated spreadsheets. (XIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS114DB   19926-19956 Multiplan Spreadsheet
    I. Spreadsheet concepts
        A. Loading
        B. Terminology
        C. Set up
      II. Creating worksheet file
          A. Using proper keys
          B. Aligning data within cells
          C. Reformatting data within cells
        III. Spreadsheet template definition and design
            A. Defining and organizing the problem
            B. Designing a template to solve the problem
              1. Entering the formulas
              2. Using proper symbols
              3. Algebraic hierarchy
              4. Using the spreadsheet's built-in functions
          IV. Entering and modifying data
              A. Entering new data
              B. Deleting existing data
              C. Modifying existing data
            V. Saving and retrieving files
                A. Saving a spreadsheet on disk
                B. Updating and correcting a spreadsheet file
                C. Replacing a spreadsheet file
              VI. Printing a spreadsheet
                  A. Controlling margins and options
                  B. Printing on the printer
                  C. Printing on the disk
                  D. Enhancing reports
                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
                      A. Creating graphs
                      B. Printing graphs
                    IX. Spreadsheet macros
                        A. Creation
                        B. Use
                      X. Spreadsheet database techniques
                          A. Searching
                          B. Linking
                          C. Extracting
                          D. Combining
                        XI. Use of spreadsheet statistical functions
                          XII. Matrix manipulation
                            XIII. Integrated spreadsheet project
                                A. Design of spreadsheets for integrated systems
                                B. Building of templates
                                C. Entry and manipulation of data
                                D. Production of appropriate reports and graphs
                            Go to Description    Go to top of Competencies    Go to top of Outline