Epic: Participant Record Dashboard

[sofiatajide]

Overview

We need to manage the work for the participant record dashboard, so that we can prioritize and recruit.

Action Items

• 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.
• Copy all of the link lists from the participant record into a comment on this issue
• Remove duplicates
• Remove the public private status
• 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: Initiative: Dashboards planning #6614
• Project Board (see all issues): HfLA Dashboards: Project Board, Participant Record
• Requirements for the Participant Record Dashboard v3 #7640
  • Create participant record sample for V3+ of participant record dashboard #7710
    • Create script that rolls up the data from the participant record sheets #7759
• Rebuild the dashboard using the new STATIC data source #7724
• Refine the dashboard using a live data source from 0 data - to partially populated - to full #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)
  • see requirements doc: HfLA website: Dashboard Requirements: Participant Record v3
  • see v3 column Dashboard - Participant Record - Competitive or Comparative Analysis Template
  • Mockups folder in Google Drive
  • Permissions analysis
• V2
  • Looker Dashboard All Interns
    • located in the internship-ba@hackforla.org 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
• 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.

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

---

• Spreadsheet Dashboard - Participant Record - Competitive or Comparative Analysis Template