Epic: Participant Record Dashboard
Overview
We need to manage the work for the participant record dashboard, so that we can prioritize and recruit.
Action Items
- [x] Go to the participant record tab for the participant record dashboard and copy all of the links in the issue to a comment at the bottom of the issue and indicate whether they are public or private.
- [x] Copy all of the link lists from the participant record into a comment on this issue
- [x] Remove duplicates
- [ ] ~Remove the public private status~
- [x] Review all the links and organize them into the Resources section below
- [ ] Revise Participant Record Dashboard Roadmap
Resources/Instructions
- Google Drive Folder: Participant Record
- Roadmap this dashboard: HfLA website: Dashboard Roadmap: Participant Record
- Roadmap all dashboards: HfLA website: HfLA Dashboard Development Roadmap
Related issues
- Epic: All Dashboards Epic: #6614
- Project Board (see all issues): HfLA Dashboards: Project Board, Participant Record
- https://github.com/hackforla/website/issues/7640
- https://github.com/hackforla/website/issues/7710
- https://github.com/hackforla/website/issues/7759
- https://github.com/hackforla/website/issues/7710
- https://github.com/hackforla/website/issues/7724
- https://github.com/hackforla/website/issues/7761
Participant Record Dashboard Prototype Links and Notes
- V4 (future features)
- Size/points of completed issues.
- Discrepancies between reported hours and completed work.
- V3 (what we are currently working towards - MVP)
- V2
- Looker Dashboard All Interns
- located in the [email protected] account
- Form (Edit): TWE: ISS Participant Record - Form
- Responses Sheet: Spreadsheet used by the looker dashboard TWE: IS22 Participant Record (Responses), Instructions tab - This tab, explains the other tabs
- Form (View):TWE: IS22 Participant Record - makeup entry
- 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 Participant Record (Responses), Data tab
- Looker Dashboard All Interns
- v1
- Spreadsheet Prototype: Participant Record and Attendance Sheet (IS21)
- Notes: This is the original participant record spreadsheet before we had the form and the dashboard.
- Spreadsheet Prototype: Participant Record and Attendance Sheet (IS21)
Tutorials
The below link is from an issue that had been worked on related to the dashboard. Because we have several dashboards being developed we have organized a list of all tutorials on the Hack for LA Data Science repo wiki, called Dashboard Resources. If you add a new tutorial to any issues related to this dashboard, make sure they get added to the wiki.
- Video Tutorial Timecard spreadsheet Clock In, Clock Out System w/ Google Sheets & Google Forms, Spreadsheet Template
Outstanding issues to resolve
- [x] IS21 Participant Record
- Do not have access- it currently has PII in it. We have to make a version of it that has intern numbers instead of names
- discuss with rabia
- update this issue when that is completed https://github.com/hackforla/internship/issues/193#issuecomment-2357006553
- Do not have access- it currently has PII in it. We have to make a version of it that has intern numbers instead of names
- [x] Participant Record dashboard - example intern 1
- [x] Do not have access - it's an old depreciated version.
- Still looking for current version
- Found current prototype, see top of issue
- [ ] public
- [x] Do not have access - it's an old depreciated version.
- [x] TWE: Participant Record (Work Hours Calculated) - Intern #
- [ ] Have access, its located in ____
- [x] public - this is a folder, not a document Internship > IS22 cohort > Participant Record (need to look through this to figure out what is in here and how to link it to the dashboard roadmap.
- [ ] discuss with rabia
- [x] Time Sheet (Recorded)
- [ ] Have access, its located in ____
- [x] public - The name of this document is TWE: IS22 Participant Record (Responses) - Annie - workbook for a dashboard
- This was made by a previous PM on the internship project as a practice copy
- This is no longer needed
- [x] Participant Record dashboard - Intern 3
- [x] Do not have access - this is currently broken, but it was a demo of a dashboard for one person.
- This is no longer needed. We are now only doing a participant record for all people, and you can look yourself up by number.
- [ ] public
- [x] Do not have access - this is currently broken, but it was a demo of a dashboard for one person.
- [x] Participant Record - Intern 10
- [x] Do not have access - this one still has its formatting but 1/2 the data is broken. For a full list of these dashboards https://github.com/hackforla/internship/issues/213#issuecomment-2357024291
- This is no longer needed. We are now only doing a participant record for all people, and you can look yourself up by number.
- [ ] public
- [x] Do not have access - this one still has its formatting but 1/2 the data is broken. For a full list of these dashboards https://github.com/hackforla/internship/issues/213#issuecomment-2357024291
- [ ] Talk with Data Science CoP leads for formal names of the type of analysis we want to do.
- [x] Looking for dashboard
- found it Looker Dashboard All Interns
Participant Record Dashboard Link and Notes
- All Interns
- it is located in the [email protected] account
- 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 the sheet called 'Data' in the TWE: IS22 Time Card (Responses) spreadsheet
@Rabia2219 The dashboard only is showing intern choices for null and 11. Where is the version where we can see all interns?
I renamed all the dashboards so it's clearer what is on them.
@Rabia2219 Please explain the tabs on the TWE: IS22 Participant Record (Responses) spreadsheet by updating the instructions tab. and let us know here
@Rabia2219 The dashboard only is showing intern choices for null and 11. Where is the version where we can see all interns?
@ExperimentsInHonesty the data source was broken, it has been fixed and all the intern numbers are showing now
@Rabia2219 Please explain the tabs on the TWE: IS22 Participant Record (Responses) spreadsheet by updating the instructions tab. and let us know here
@ExperimentsInHonesty Done
@ExperimentsInHonesty Although the dashboard is working as expected, there is some additional processing that is required for the data to be accurate. ETA: Tuesday, October 15th
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, October 8, 2024 at 12:05 AM PST.
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, October 15, 2024 at 12:04 AM PST.
Notes
- the data has been processed and the dashboard is working as intended
- ~new org requirements gathered, delivery ETA Tuesday, October 22nd~ - on hold
@Rabia2219 when we meet next week, we also need to do the following
- [ ] review the outstanding items in this comment https://github.com/hackforla/website/issues/7509#issuecomment-2381575569
Bonnie needs to Talk with Data Science CoP leads for formal names of the type of analysis we want to do in the HfLA website: Dashboard Roadmap: Participant Record
@sofiatajide Add all the links from the participant record issues to this comment; don't copy in duplicates.
Issues
-
TWE: ISS Participant Record - Form
- [ ] Have access, its located in ____
- [x] public
-
TWE: IS22 Participant Record - Spreadsheet(Responses)
- [ ] Have access, its located in ____
- [x] public
-
TWE: IS22 Participant Record - makeup entry
- [ ] Have access, its located in ____
- [x] public
-
TWE: IS22 Participant Record - Form depreciated
- [ ] Have access, its located in ____
- [x] public
-
TWE: IS22 Participant Record - Spreadsheet(Responses) deprecated
- [ ] Have access, its located in ____
- [x] public
-
Source Tutorial
- [ ] Have access, its located in ____
- [x] public
- https://github.com/hackforla/internship/issues/254
- [ ] Have access, its located in ____
- [x] public
-
IS21 Participant Record
- [x] Do not have access- it currently has PII in it. We have to make a version of it that has intern numbers instead of names
- [ ] public
-
Internship Wiki, Join the team page
- [ ] Have access, its located in ____
- [x] public
-
Participant Record dashboard - example intern 1
- [x] Do not have access - it's an old depreciated version. Still looking for current version
- [ ] public
-
Participant Record
- [ ] Have access, its located in ____
- [x] public - this is a folder, Internship > IS22 cohort > Participant Record (need to look through this to figure out what is in here and how to link it to the dashboard roadmap.
-
Time Sheet (Recorded) - deprecated
- [ ] Have access, its located in ____
- [x] public - this is a copy of the participant record made by a PM who was trying to fix the dashboard. It is no longer neededs
-
Participant Record dashboard - Intern # - deprecated
- [x] Do not have access - this is currently broken, but it was a demo of a dashboard for one person.
- [ ] public
-
Participant Record - Intern 2 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 3 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 4 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 5 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 6 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 7 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 8 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 9 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 10 - deprecated
- [x] Do not have access
- [ ] public
-
Participant Record - Intern 11 - deprecated
- [x] Do not have access
- [ ] public
-
Intern Dashboard Links - deprecated
- [ ] Have access, its located in ____
- [x] public, When we were using individual intern dashboards, this was a spreadsheet of all of the dashboards (per intern and one all interns)
-
Participant Record Spreadsheet
- [ ] Have access, its located in ____
- [x] public
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, October 22, 2024 at 12:04 AM PST.
Discuss with @Rabia2219
- [x] Participant Record
- this is a folder, Internship > IS22 cohort > Participant Record (need to look through this to figure out what is in here and how to link it to the dashboard roadmap.
- Copy of TWE: IS22 Participant Record - do we still need this?
- Copy of TWE: IS22 Participant Record - makeup entry - do we still need this?
- Folder: Depreciated form and spreadsheet - if we are keeping, this needs to be de-identified (it has interns names in it). Do we need to mark it and the files inside it as "- deprecated"?
- this is a folder, Internship > IS22 cohort > Participant Record (need to look through this to figure out what is in here and how to link it to the dashboard roadmap.
- [x] Figure out where these files should be located
- [ ] option 1 items are staying in this folder with a shortcut in the dashboards folder to the current folder
- [x] option 2 moving to the Dashboards Google Drive with a shortcut in the original folder
- [x] Participant Record dashboard - example intern 1
- watch research interview and see if this version is the one we showed and we need to keep it.
Interview details
- WIKI page: Research Plan 17: Activity Dashboard Interviews
- Research Plan: Research Plan 17 - Activity Dashboard Interview
- Recording: Interview Recording on 2022-07-13
- Transcript: De-identified Transcript
- This interview was not relevant. I have moved the info from this comment to this issue https://github.com/hackforla/website/issues/7539
Discuss with Rabia
This spreadsheet (IS21: TWE: Intern Roster - including applicants) has the intern names and numbers of the applicants
- [x] We need to discuss if it's even possible to de-identify this sheet by replacing all the names with numbers
Completed de-identifying and its been added to resources
- [x] Go through all the files that we have indicated are "deprecated" (in this comment and add the following to the end of their filename
- deprecated
On Monday
- [x] Bonnie needs to Talk with Data Science CoP leads for formal names of the type of analysis we want to do in the HfLA website: Dashboard Roadmap: Participant Record
Added some info to document re this topic
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, October 29, 2024 at 12:04 AM PST.
- Progress: Created a new issue https://github.com/hackforla/website/issues/7640
- Blockers: none
- Availability:
- ETA:
- Pictures or links* (if necessary): N/A
- remember to add links to the top of the issue if they are going to be needed again.
- Requirement update https://github.com/hackforla/website/issues/7640#issuecomment-2486583954
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Monday, November 4, 2024 at 11:04 PM PST.
- Progress: worked on Spreadsheet Dashboard - Participant Record - Competitive or Comparative Analysis Template to add checkboxes for each of the features of the versions
- Blockers: none
- Availability: at least 6 hrs
- ETA:
- Pictures or links* (if necessary): N/A
- remember to add links to the top of the issue if they are going to be needed again.
@sofiatajide
- [x] Create issue: https://github.com/hackforla/website/issues/7759
- Add issue link to the following issues, where indicated in the top part
- [x] https://github.com/hackforla/website/issues/7640#issue-2616739845
- [x] https://github.com/hackforla/website/issues/7710#issue-2641751322
- Add issue link to the following issues, where indicated in the top part
- [x] Create issue: https://github.com/hackforla/website/issues/7761
- Add issue link to the following issues, where indicated in the top part
- [x] https://github.com/hackforla/website/issues/7640#issue-2616739845
- [x] https://github.com/hackforla/website/issues/7509#issue-2543914963
- Add issue link to the following issues, where indicated in the top part
Instructions
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."
- Progress: Populated sample sheet data (resource 1.01) with data from resource 1.03. issue #7710 Populated sample sheet data (resource 1.02) with data from resource 1.04. issue #7710 Created new Issue #7759 Created new Issue #7761
- Blockers: none
- Availability: at least 6 hrs
- ETA:
- Pictures (if necessary): N/A
We created a new page in the Hack for LA Data Science repo wiki, called Dashboard Resources - this page has all the tutorial links from each of the issues
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Monday, December 30, 2024 at 11:04 PM PST.
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Monday, January 6, 2025 at 11:04 PM PST.
@sofiatajide
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Monday, January 13, 2025 at 11:04 PM PST.
