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

• Linking/adding a “Courses to be QA’d” tab to keep everything in one spot
• Pull courses only from the SPS subfolder (not all over A&S)

Features to Consider

• 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

• Change reminder time to 9AM and prevent weekend reminders
• Make QA Fixes Completed? Yes / No automatic if “Complete” or “deferred to faculty” selected.
• FIX: When all fixes are complete, and the completed flag is set, reverting an item back to in process does not unset the flag
• Change column title from “ALL QA Users” to "Active" or "QA users to receive emails".
• Remove automation that has no purpose (ones added in by different developer)
• Remove need to add “fixer” since this is always the designer
  • 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/bugs
  • Add SPS Courses
  • Open QA Cycle
  • Close QA Cycle
  • 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
  • Completing all tests and fixes trigger Yes on the Tracking Detail and in the individual test sheet
    • The automatic flip of the fixes complete was not working
      • This is a case where the code is looking for "Not Started" or "In Progress" which will not always be the case
      • Now clears the values in the Fix Assigned To and Fix Status column for cases where the test has 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
    • Resolved and confirmed
  • QA Fixes Completed? Yes / No automatically switches to “Yes”, even though the cycle hasn’t started.
    • Resolved and confirmed
• Cleaned up the Control Panel and relocated some of the cells to make it more compact

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: