Diversity Checkpoints report

NormaJAC commented 7 months ago

Background

We are looking to automate the calculation of the difference in % points between stages and enable the information to be downloadable in the format used in SCC papers and AA reports and by EFT for quality assurance purposes.

User Story

As Diversity & Engagement admin, I want to download a Diversity checkpoint report so that I can see the % change in the diversity of candidates at each stage of the process,

Feature(s) Description

[ ] Add a new column titled % Change from previous and will reflect the percentage change in each category from the previous tab
[ ] The content of the new report will appear under the summary tab on the Diversity page and will download when Export all data button is clicked:
[ ] On each of the preceding tabs (shortlisted, selected, recommended, handover,) an additional column should be added to the right of the Applications column:

[ ] For exercises where there are multiple shortlisting methods, we would have Post-application, Post-QT, Post-ST

Ticket Champion

Nick Wood

Acceptance Criteria

[ ] Scenario: Diversity Checkpoints report download
- Given the Diversity & Engagement admin is on the Diversity page, when the admin clicks on the "Export all data" button, then the new Diversity Checkpoints report should download in Excel format

[ ] Scenario: New report columns
- Given the Diversity & Engagement admin is on the Diversity page, when the admin clicks on the "Export all data" button, then the new report should have an additional column to the right of the Applications column on each tab: [ ] % Change from previous stage
[ ] Scenario: Multiple shortlisting methods
- Given there are multiple shortlisting methods: Post-application, Post-QT, Post-ST, when the Diversity & Engagement admin clicks on the "Export all data" button, then the new report should display the percentage change in each category from the previous stage for each shortlisting method

NormaJAC commented 7 months ago

Created a Diversity checkpoint report draft, sent it to Nick Woods for his input, he replied, that he will respond within a week because he has passed it on to Rachael and Sean for their input.

nickaddy commented 7 months ago

Hey team! Please add your planning poker estimate with Zenhub @HalcyonJAC @tomlovesgithub @warrensearle

warrensearle commented 7 months ago

Please add your planning poker estimate with Zenhub @drieJAC

NormaJAC commented 7 months ago

Some comments to be considered: Some exercises have multiple shortlisting stages. (shortlisting being broken into two steps, a QT and Scenario Test).

NormaJAC commented 6 months ago

Comments from Rachael: For exercises where there are two shortlisting methods, we would have “post-application”, “post-QT”, “post-ST”, “post-selection day”.

NormaJAC commented 5 months ago

This 2nd requirement of this ticket was blocked at the sprint planning meeting on 19/12/2023, requires further information?

NormaJAC commented 4 months ago

Charlotte's email gave some specifics: says: the diversity report figures SETs sent around needed redoing as they had only selected those who met the VR even though there were more selectable candidates post SD. e.g. the VR was 10 so they only selected the top 10 for the report even though (say for example) they had 15 selectable candidates. So the post SD diversity checkpoint should have been for the 15 selectable candidates and then those who were eventually recommended to make the 10 would then form the next checkpoint.

nickaddy commented 4 months ago

This can be delayed until April.

nickaddy commented 4 months ago

@NormaJAC Can you please reach out to the secretariat to confirm that this is the best format for all instances of its usage, e.g. SCC paper, JO, other?

NormaJAC commented 2 months ago

@nickaddy this was dealt with after diversity checkpoints meeting with the Rachael and Nick W on 08/03/2024

jac-uk / admin