|
Dec 22, 2024
|
|
|
|
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.
|
Add to Portfolio (opens a new window)
|
|