Feb 21, 2024  
2023-2024 Official General Catalog 
2023-2024 Official General Catalog

CST 158 - Data Analysis with Spreadsheets

A comprehensive course in data analysis using spreadsheet software. Students will use innovative techniques for composing spreadsheets, solving problems, analyzing data, and presenting results. Areas of research include statistical functions, financial functions, iterative solutions, information sharing, table data analysis, what-if analysis, pivot tables and charts, XML schemas, macros and user-written functions, and programming with VBA.

Prerequisite- Corequisite
Prerequisite:  CST 119 Computer Concepts and Applications or permission of chair.

Credits: 3
2 Class Hours, 2 Laboratory Hours
Course Profile
Learning Outcomes of the Course:

Upon successful completion of this course the student will be able to:

  1. Be proficient at managing and analyzing data using complex formulas and tables.
  2. Effectively enhance data with charts.
  3. Be proficient at automating worksheet tasks with macros.
  4. Effectively analyze data using what-if analysis, pivot tables, and pivot charts.
  5. Use data exchange with other programs, share files, and incorporate Web information.
  6. Customize spreadsheets and perform advanced worksheet management.
  7. Use the Visual Basic Editor, analyze and write VBA code.