Technical Details

Current Release Version: 2024.1.3

Release Date: 20 Dec 2024

Report Location: PowerBI / Apps / SPS Academics

Security Roles: Academic Affairs

Requested Features

Current Cycle

Release 2025.1.0 [January 2025]

Features to Complete

• None

Features to Consider

• Add row level security to allow program directors to view their own evaluation data based on their login profiles

Features Ready for Release

Previous Cycles

Release 2024.1.3 [December 2024]

• Created a table named EVAL_QUESTIONS and uploaded the data to it.
• A page named 'Survey Questions' was added to the Evaluation Management Power BI report.

Release 2024.1.2 [March 2024]

• SQL ONLY: Removed duplicate rows from the EXT_SRC_EVALKIT table
• Removed the underlying Term row from the Response Rate page

Release 2024.1.1 [January 2024]

• Add a 'Response Rate by Term' page

Release 2023.1.1 [December 2023]

• Add summative response rate of programs per semester
• Add Course Summary page
• SQL Only: Added codes for course summary

Release 2023.1.0 [January 2023]

• Move all Power Query manipulations into the SQL procedure that is pulling down the data from the warehouse to make it easier to transform inconsistent source data
  • New procedure: a2_evaluation_management
• Add course code to the grid for the Instructors page
• Added replaced value for SPS_ course numbers
  • Fixed in SQL, so no need to push the report for this fix, but added for future data loads

Release 2022.1.1 [March 2022]

• Turn on the underlying data export feature
• Add heat map coloring to the response rate column
  • Red = <50%, Yellow = 50.01% to Green 100%

Release 2022.1.0 [January 2022]

• Cosmetic updates to bring the report in line with the latest SPS design standard
• Updated info link to the new Confluence documentation
• Added filters for instructor, course code, title, enrollments, respondents, and section
• Clean course rows that are not mapping correctly to program codes due to naming inconsistencies

Release 2021.1.0 [September 2021]

• Courses
• Include question 4 in the matrix output
• Instructors
• Include question 18 in the matrix output

Release 2020.1.0 [September 2020]

• The courses report page shows a heat map view of course-specific questions
• Instructors report page shows a heat map view of instructor specific questions
• Trends report page shows how courses are rated from high to low with low, high and median watermarks
• Created EXT_SRC_TABLE and loaded with EvalKit data for the following terms
• Fall 2018, Spring 2019, Summer 2019, Fall 2019, Summer 2020
• Note: Spring 2020 did not include evaluations