Requirements for the Participant Record Dashboard v3

### Dependency
- After either of these issues are completed, update the requirements documented in this issue and in the roadmap
- [ ] https://github.com/hackforla/website/issues/7759
- [ ] https://github.com/hackforla/website/issues/7761

### Overview
We need to outline the requirements for the Participant Record Dashboard to ensure clear priorities, resource allocation, and effective management as we move forward with development.

### Action Items
- [x] Create Spreadsheet (version analysis feature sets)
- [x] Go through the Roadmap and find any features/requirements it mentions, adding to a comment below
- [x] move the data to the sheet
- [x] Review V1
- [x] find additional features
- [x] indicate all the features it has and write any notes
- [x] Get sign-off
- [x] Review V2
- [x] find additional features
- [ ] indicate all the features it has and write any notes
- [x] Get sign-off
- [ ] Review each open and closed issue to determine if there were other requirements, not developed, but talked about (even if they were dismissed)

### Resources/Instructions
- Google Drive Folder: [Participant Record Card](https://drive.google.com/drive/folders/1QrfRAD0_IvrDww0I01cihKT7C_1Jcvk3)
- Roadmap this dashboard: [HfLA website: Dashboard Roadmap: Participant Record](https://docs.google.com/document/d/1SEjVIfDms0fBjksddBbDgp30GsApCICU3HlILPpyt2k/edit)
- Requirements Document [HfLA website: Dashboard Requirements: Participant Reocrd v3](https://docs.google.com/document/d/1lYeY2T_sNU4gjyj_P8C2LBrnzsuIZcR4-bd7GxzbWr8/)

### Related Issues
- Project Board (see all issues): [HfLA Dashboards: Project Board, Participant record](https://github.com/orgs/hackforla/projects/88/views/6)
- This issue is part of this epic: https://github.com/hackforla/website/issues/7509
- https://github.com/hackforla/website/issues/7710
- https://github.com/hackforla/website/issues/7759
- https://github.com/hackforla/website/issues/7761
- https://github.com/hackforla/website/issues/8063

#### Participant Record Card Dashboard Prototype Links and Notes
We provide a custom URL in the offer letter (PDF), that delivers arguments to the script, that populates the _User Report_ see Report_Lookup-Draft2. Program managers can see all the User Reports by going to _List of Users, IDs and Passcodes_ and using the ID and Passcode with the _User Report_, or see aggregate data by going to the _All Users Report_. _Engagements_ will be recorded on a tab of the _List of Users, IDs and Passcodes_.
- V3 (WIP)
- Spreadsheet [TWE: ISXX Participant Record Card: Week XX](https://docs.google.com/spreadsheets/d/1GImzqV3Sol4TZ2rHEPBWlptNGyjJ5HJfbxrRcdgl6Y4/edit?gid=0#gid=0) - WIP
- Draft Spreadsheet [User_Report_Lookup-Draft2](https://docs.google.com/spreadsheets/d/10oqrFfqMELuBUPwQQGgBscmdF7FTG61aSLbXqju3wSM/edit?gid=1018556720#gid=1018556720)
- Draft Spreadsheet [All Users Report]
- Draft Spreadsheet [List of Users, IDs and Passcodes]
- Draft Spreadsheet [List of Users, IDs and Passcodes, Engagements]
- V2
- Looker Dashboard [All Interns](https://lookerstudio.google.com/reporting/c1b6fec1-7fe1-4524-ad49-de96f2ba5b31)
- located in the internship-ba@hackforla.org account
- Form (Edit): [TWE: ISS Participation Record - Form](https://docs.google.com/forms/d/1yc49thgEFeQ0AQS3b6QHHDXehPqkyX9J8tTw8tvBQbI/edit)
- Responses Sheet: Spreadsheet used by the looker dashboard [TWE: IS22 Participation Record (Responses), Instructions tab](https://docs.google.com/spreadsheets/d/10oqrFfqMELuBUPwQQGgBscmdF7FTG61aSLbXqju3wSM/edit?gid=2026057936#gid=2026057936) - This tab, explains the other tabs
- Form (View):[TWE: IS22 Participation Record - makeup entry](https://docs.google.com/forms/d/e/1FAIpQLSdjRSZRoUU17y88J0DKq2QZ2TqqKqNZ3uzO2KEdJkvAPPe3Ig/viewform)
- Notes: The process worked fine as long as the interns remembered to fill in the form to time out once done, which they often forgot to. We started using the makeup form to get tentative time out times, after which the data was manually manipulated to fill in the missing time outs, in [TWE: IS22 Participation Record (Responses), Data tab](https://docs.google.com/spreadsheets/d/10oqrFfqMELuBUPwQQGgBscmdF7FTG61aSLbXqju3wSM/edit?gid=1079713090#gid=1079713090)
- v1
- Spreadsheet [Prototype: Participation Record and Attendance Sheet (IS21)](https://docs.google.com/spreadsheets/d/1AditpEvpqf0BmxXaS-pyAoRg6tA_HU6rHww9cMh9Nys/)
- Notes: This is the original Participation Record spreadsheet before we had the form and the dashboard.

#### Requirements
- Presented in Spreadsheet Form [Dashboard - Participation Record - Competitive or Comparative Analysis](https://docs.google.com/spreadsheets/d/1cjFO93F-fnSLU5KaJeElUGNqIMPR2ZoHMA04KJz8th4/edit?gid=471535750#gid=471535750) - enables you to see the difference between versions and is a simplified list of all the features across versions (past, present and future).
- Requirements Document [HfLA website: Dashboard Requirements: Participation Record v3](https://docs.google.com/document/d/1lYeY2T_sNU4gjyj_P8C2LBrnzsuIZcR4-bd7GxzbWr8/) - for the new features for the next MVP

#### Reason for major redesign
- Through discussion with Rabia (the original dashboard builder/maintainer), we determined that the V2 makeup entry required too much manual intervention. Additionally, it was too similar to a job where you have to clock in/out, instead of how contract tech workers report their hours via a weekly reporting tool.

#### Who will build
- Rabia's role is at a CTS administrative representative for the OPT program. So with Bonnie she figures out what we need to get from the users and what we can provide. She built the previous prototypes but will not be building v3. That will happen with people from Data Science

#### Emojis
Emojis and their meanings to the dashboard

Emojis
🤩 = Over expectation
😎 = Meets Expectation
😓 = 99.9 to 71% of expected
😭 = 70% or less of expected

Over expectation
```
🤩
```
Meets Expectation
```
😎
```
99.9 to 71% of expected
```
😓
```
70% or less of expected
```
😭
```