This course concentrates on advanced spreadsheet techniques that will transform data into information to improve decision making; designing and creating Decision Support Systems (DSS). In addition to the creation of multiple DSS, students will also incorporate design best practices that will support effective solutions and ensure data quality. Students will utilize analysis tools such as Solver, Scenario Manager, Pivot Tables, and Power View and visualization tools such as Graphs and Pivot Graphs. Students will demonstrate these techniques through industry related assignments and the use of case studies.
Not all courses are offered each term.Spring 2022 registration opens February 7, 2022. Fall 2022 registration opens July 4, 2022.
In person: classes held in person on a campus/site in a classroom/lab/shop/studio for the course duration
Online - Asynchronous: 100% online delivery with no assigned day or time requirements, independent course completion
Online - Synchronous: 100% online delivery with scheduled day and time course requirements
Hybrid: any combination of: in person, timetabled, on campus, online, and hyflex delivery