ITEC 281 - Data Management and Analysis with Spreadsheets

Credits: (3)

Instructional Method: Three hours lecture.
A study of basic and advanced techniques for data analysis and management using electronic spreadsheets. Coverage includes the study of features for gathering, managing, manipulating, and filtering data sets including multidimensional data. Techniques for collaborative use of a spreadsheet are covered including multi-user access, formula protection, and security. Advanced analysis coverage includes built-in and user defined functions, goal seeking, sensitivity analysis, scenario management, and data visualization.

Note(s): A $75 Certiport fee will be charged for students enrolled in ITEC 281 in the Fall or Spring terms. The fee covers the cost of Microsoft Excel testing, Specialized Certiport software, use of center equipment, and exam proctoring.