Development (Eval)

Owned by Bryon Vaughn
Last updated: Mar 19, 2024 by Mohammed
2 min read

Technical Details

Current Release Version: 2024.1.2

Release Date:

Report Location: PowerBI / Apps / SPS Academics

Security Roles: Academic Affairs

Requested Features

Current Cycle

Release 2024.1.3 [April 2024]

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.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