Sprint Retrospective Tool

This tool consists of a Google Sheets file, and accompanying Google Scripts. The sheets involved are:

  • Sprint retrospective

Purpose

This tool is meant to randomly distribute Process group members as interviewers for the other groups during sprint retrospective.

Setup

The tool needs to be setup with data about the current GIRAF team in order to function. The data is entered into some of the sheets, and the Google Scripts found at Tools>Script Editor in the menus bar.

In the API.gs file found with the script editor, the SEMESTER_START_DATE needs to be updated to the start date of the current GIRAF teams semester. In the same file, the ACCESS_TOKEN needs to be updated with a GitHub access token from one of the team members. An access token can be generated here.

Usage

The tool is used with the Sprint retrospective sheet by pressing the Update button. This button has been assigned the dividePGMembersBetweenGroups script from the SprintRetrospective.gs file.


Last update: December 12, 2023