Maricopa Community Colleges  BPC133AA   19872-19925 
Official Course Description: MCCCD Approval: 11/26/91
BPC133AA 19872-19925 L+L 1 Credit(s) 2 Period(s)
LOTUS 1-2-3 Spreadsheet Projects
Use of integrated electronic spreadsheets to solve business problems. Emphasis on designing and installing spreadsheets, using database techniques and macro programming techniques to process data records to obtain prescribed reports and graphs. Spreadsheet projects in areas of business, education and personal applications. Prerequisites: BPC 103AA and BPC 104AA or BPC 114 or instructor permission.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC133AA   19872-19925 LOTUS 1-2-3 Spreadsheet Projects
1. Organize the problem for solution with LOTUS 1-2-3. (I)
2. Apply the principles of effective worksheet and database layout in building a LOTUS 1-2-3 spreadsheet template. (I)
3. Solve real-world business problems working with LOTUS 1-2-3 spreadsheet models. (V)
4. Create and manipulate data files. (II)
5. Prepare charts and graphs utilizing the graphics module to support business reports. (III)
6. Prepare comprehensive business reports utilizing data from several data files, supported by quantitative data from an electronic spreadsheet and clarified by appropriate charts and tables generated from the integrated data and the graphics module. (IV)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC133AA   19872-19925 LOTUS 1-2-3 Spreadsheet Projects
    I. ELECTRONIC SPREADSHEETS
        A. Spreadsheet parameters
        B. Spreadsheet formulas
      II. DATABASE FILES
          A. Building user files
          B. Editing user files
        III. BUSINESS GRAPHICS
            A. Data extraction from files
            B. Designing business graphics
          IV. INTEGRATED REPORTS
              A. Data retrieval
              B. Data integration
              C. Report preparation
          Go to Description    Go to top of Competencies    Go to top of Outline