CISC127 Spreadsheet Concepts and Applications

Department of Science, Technology, Engineering & Mathematics: Computer/Information Science

I. Course Number and Title
CISC127 Spreadsheet Concepts and Applications
II. Number of Credits
3 credits
III. Number of Instructional Minutes
IV. Prerequisites
Math Placement Test score of 5 or better or MATH095 (C or better)
V. Other Pertinent Information
This course meets the General Education requirement for Quantitative Literacy.
VI. Catalog Course Description
This course is an in-depth study of spreadsheets used to perform calculations and communicate quantitative information. Topics include: worksheets and templates, functions and formulas, charts and graphs, business intelligence and data analysis tools, validating and auditing workbooks, sorting and filtering data, automation with macros, and database functions.
VII. Required Course Content and Direction
  1. Course Learning Goals

    Students will:

    1. create complex spreadsheets to effectively communicate quantitative information [Quantitative Literacy];
    2. use financial, lookup, statistical, and logical functions, and construct complex formulas, using absolute, relative, and mixed cell referencing [Quantitative Literacy];
    3. analyze data with appropriate graphs and charts [Quantitative Literacy];
    4. validate data and audit a worksheet for errors;
    5. solve "what if," "goal-seek," and other problems, using built-in data analysis and business intelligence tools;
    6. write macros, which eliminate detailed repetitive routine; and
    7. create a database and perform data manipulation, including sorting and extraction of data.
  2. Planned Sequence of Topics and/or Learning Activities

    1. Creating and Formatting a Worksheet
    2. Absolute, Relative, and Mixed Cell Referencing
    3. Formulas and Functions
    4. Charts, Sparklines, and Graphs
    5. Data Validation and Auditing Worksheets
    6. Creating Tables
    7. Conditional Formatting
    8. Defined Names
    9. Sorting and Filtering
    10. Creating and Using Templates
    11. Business Intelligence (BI) and Data Analysis Tools
    12. PivotTables and PivotCharts
    13. Building Complex Functions
    14. Macros and Visual Basic for Applications
    15. Database Functions
    16. Collaborating with Others and Preparing a Workbook for Distribution
  3. Assessment Methods for Course Learning Goals

    The assessment of Course Learning Goals is based on written tests, labs, and other assignments, as well as performance-based tasks as appropriate, and a departmental final exam.
  4. Reference, Resource, or Learning Materials to be used by Student:

    Departmentally-selected textbook and other learning materials. Details provided by the instructor of each course section. See course syllabus.

Review/Approval Date - 9/98; Revised 10/2010; New Core 8/2015