Technical Details

Current Release Version: 2021.1.0

Release Date: 06 Dec 2021

Application Location: Google Drive / QA Cycles

Security Roles: OCI Operations

Notes

• The development of this tool was handled internally by the OCI team, but staffing changes has made maintenance problematic. As long as there are resources to handle this work, this project will be moved to the AIS team.

Requested Features

Current Cycle

Release 2022.1.0 [April 2022 - Summer QA Cycle]

Features to Complete

• Validate the following features
  • Add SPS Courses
  • Open QA Cycle
  • Close QA Cycle
• Possible bugs
  • The automatic flip of the fixes complete is not working
    • This is a case where the code is looking for "Not Started" or "In Progress" which will not always be the case
    • Should automatically erase the values in the Fix Assigned To and Fix Status column for cases where the case has been passed
  • Automation Check Links automation triggers Check Publish for some reason, so now Check Publish says "pass" even though I haven't started that automation at this point.
  • Automation for Check Publish goes TOO quickly, making me think that something was done in the previous step
  • QA Fixes Completed? Yes / No automatically switches to “Yes”, even though the cycle hasn’t started.

Features to Consider

• Make QA Fixes Completed? Yes / No automatic if “Complete” or “deferred to faculty” selected.
• Remove automation that has no purpose (ones added in by different developer)
• Change reminder time and/or prevent weekend reminders
• Pull courses only from the SPS subfolder (not all over A&S)
• Linking/adding a “Courses to be QA’d” tab to keep everything in one spot
• Change column title from “ALL QA Users” to "Active" or "QA users to receive emails".
• Additional test cases
  • Possibly add in test cases to account for media team gaps
• Improved security
  • API keys and access to advanced functionality

Features Ready for Release

• Remove need to add “fixer” since this is always the designer, or make that section optional
  • Changed the Fixer column to Instructional Designer, but kept all of the fixer logic in place
• Remove the AEC test cases and supporting code
• Validate the following features
  • Reset Master Tracking Sheet
  • Sort Sheets automation
  • Automation for Check Links takes a long time
    • This is normal for large courses or a cycle with many courses

Previous Cycles

Release 2021.1.0 [December 2021 - Spring QA Cycle]

• Tracker Google sheet
• Modified Canvas API page management code to handle new format

Previous development cycle documentation can be found here: