# CISC127 Spreadsheet Concepts and Applications

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

I. Course Number and Title
II. Number of Credits
3 credits
III. Number of Instructional Minutes
2250
IV. Prerequisites
Math Placement Test score of 5 or better or MATH095 (C or better)
Corequisites
None
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