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.

Validate the following features
- Add SPS Courses
- Open QA Cycle
- Close QA Cycle
Possible bugs
- Sort Sheets automation does not work
- Automation for Check Links takes a long time
- 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.

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

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

Previous development cycle documentation can be found here: