/
Development (QA Tracker)

Development (QA Tracker)

Owned by Bryon Vaughn
Last updated: Aug 16, 2023

Technical Details

Current Release Version: 2023.1.0

Release Date:

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.2.0 [December 2022 - Spring QA Cycle]

Features to Complete

  • Not started

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
  • Move menu items to an admin panel at the right and make the order of execution more clear
    • Show details about when the actions were last performed (or if at all)
  • Incorporate the "Cycle Open Checklist" into the tracker
    • This can be as simple as a new tab with a checklist of the tasks to be performed for the cycle
    • Include in the Reset MST code to clear the checklist and revert to the default state
  • Process Improvement
    • Dynamically pull the list of available terms using the Canvas API
      • Add to the Reset MTS code to get the latest values
      • Eliminates the manual step of adding the new term to the sheet before a cycle starts
    • Move the QA Cycle Notes to a tab in the sheet to keep all feedback in one place for review
      • Add to the Reset MST code to clear for new cycles
    • Function to spin up a new MST for a new term using the current sheet as the basis
      • Copy the current sheet to a new folder
      • Update the sharing permissions on the new folder to grant all of the users from the bench editor privileges
      • Grant access to edit the Control Panel tab to all managers
    • Show/hide tabs based on the user that is logged into Google
      • Managers should see everything
      • Testers should see the tabs for courses that were assigned to them, and any shared info sheets that make sense
      • Designers should see the tabs for their courses, and any shared info sheets that make sense 

Features Ready for Release

  • Not started

Previous Cycles

Release 2023.1.0

  • Link Checking
    • Reinstated the Zendesk ignore filter on the link checker
    • Added 403 responses to the ignore filter

Release 2022.1.0 [April 2022 - Summer QA Cycle]

  • 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
      • BUG: Fixed issue with updates applying to the Tracking Detail sheet when they should not
  • Cleaned up the Control Panel and relocated some of the cells to make it more compact

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: