IT 359 - Advanced Spreadsheet Applications

Description:
Advanced spreadsheets for business applications such as design of multiple sheet workbooks and templates, advanced functions and formulas, enhanced formats, lists, and pivot tables.

Prerequisites:
Prerequisites: IT 258 or IT 260.

Credits: (4)

Learner Outcomes, Activities and Assessments

Learner Outcome	Activity (optional)	Assessment
Construct simple and compound statements and selected functions.	Lectures, group work and lab work.	Rubric based assignments, projects, and/or exams.
Examine lists, data filters and subtotals.	Lectures, group work and lab work.	Rubric based assignments, projects, and/or exams.
Employ macros.	Lectures, group work and lab work.	Rubric based assignments, projects, and/or exams.
Apply What if analysis, goal seek, forecasts.	Lectures, group work and lab work.	Rubric based assignments, projects, and/or exams.
Analyze data with Pivot Tables and Pivot Charts.	Lectures, group work and lab work.	Rubric based assignments, projects, and/or exams.
Demonstrate the application of common statistical methods using spreadsheet formulas.	Lectures, group work and lab work.	Rubric based assignments, projects, and/or exams.