Dec 22, 2024  
2016-2017 Undergraduate Catalog 
    
2016-2017 Undergraduate Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

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)