Epic: Time Card Dashboard

sofiatajide commented 2 months ago

Overview

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

Action Items

[x] Go to the time card tab for the time card 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 time card into a comment on this issue
[x] Remove duplicates
[ ] ~Remove the public private status~
[ ] Revise Time Card Dashboard Roadmap

Time Card Dashboard Prototype Links and Notes

V2
- Looker Dashboard All Interns
  - located in the internship-ba@hackforla.org account
  - Form (Edit): TWE: ISS Time Card - Form
  - Responses Sheet: Spreadsheet used by the looker dashboard TWE: IS22 Time Card (Responses), Instructions tab - This tab, explains the other tabs
  - Form (View):TWE: IS22 Time Card - 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 Time Card (Responses), Data tab
v1
- Spreadsheet Prototype: Time Card and Attendance Sheet (IS21)
  - Notes: This is the original time card spreadsheet before we had the form and the dashboard.

Spreadsheet Dashboard - Time Card - Competitive or Comparative Analysis Template

ExperimentsInHonesty commented 2 months ago

Outstanding issues to resolve

[x] IS21 Time Card
- 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
[x] Time Card 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] TWE: Time Card (Work Hours Calculated) - Intern #
- [ ] Have access, its located in ____
- [x] public - this is a folder, not a document Internship > IS22 cohort > Time Card (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 Time Card (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] Time card 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 time card for all people, and you can look yourself up by number.
- [ ] public
[x] Time Card - 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 time card for all people, and you can look yourself up by number.
- [ ] public
- [ ] 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

Rabia2219 commented 2 months ago

Time Card Dashboard Link and Notes

All Interns
it is located in the internship-ba@hackforla.org 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

ExperimentsInHonesty commented 1 month ago

@Rabia2219 The dashboard only is showing intern choices for null and 11. Where is the version where we can see all interns?

ExperimentsInHonesty commented 1 month ago

I renamed all the dashboards so it's clearer what is on them.

ExperimentsInHonesty commented 1 month ago

@Rabia2219 Please explain the tabs on the TWE: IS22 Time Card (Responses) spreadsheet by updating the instructions tab. and let us know here

Rabia2219 commented 1 month ago

@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 commented 1 month ago

@Rabia2219 Please explain the tabs on the TWE: IS22 Time Card (Responses) spreadsheet by updating the instructions tab. and let us know here

@ExperimentsInHonesty Done

Rabia2219 commented 1 month ago

@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

HackforLABot commented 1 month ago

@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.}

HackforLABot commented 1 month ago

@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.}

Rabia2219 commented 1 month ago

Notes

the data has been processed and the dashboard is working as intended
~new org requirements gathered, delivery ETA Tuesday, October 22nd~ - on hold

ExperimentsInHonesty commented 1 month ago

@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: Time Card

ExperimentsInHonesty commented 1 month ago

@sofiatajide Add all the links from the time card issues to this comment; don't copy in duplicates.

Issues

TWE: ISS Time Card - Form
- [ ] Have access, its located in ____
- [x] public
TWE: IS22 Time Card - Spreadsheet(Responses)
- [ ] Have access, its located in ____
- [x] public
TWE: IS22 Time Card - makeup entry
- [ ] Have access, its located in ____
- [x] public
TWE: IS22 Time Card - Form depreciated
- [ ] Have access, its located in ____
- [x] public
TWE: IS22 Time Card - 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 Time Card
- [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
Time Card dashboard - example intern 1
- [x] Do not have access - it's an old depreciated version. Still looking for current version
- [ ] public
Time Card
- [ ] Have access, its located in ____
- [x] public - this is a folder, Internship > IS22 cohort > Time Card (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 time card made by a PM who was trying to fix the dashboard. It is no longer neededs
- Time Card dashboard - Intern # - deprecated
- [x] Do not have access - this is currently broken, but it was a demo of a dashboard for one person.
- [ ] public
Time Card - Intern 2 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 3 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 4 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 5 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 6 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 7 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 8 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 9 - deprecated
- [x] Do not have access
- [ ] public
Time Card - Intern 10 - deprecated
- [x] Do not have access
- [ ] public
Time Card - 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)
Time Card Spreadsheet
- [ ] Have access, its located in ____
- [x] public

HackforLABot commented 1 month ago

@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.}

ExperimentsInHonesty commented 1 month ago

Discuss with @Rabia2219

[x] Time Card
- this is a folder, Internship > IS22 cohort > Time Card (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 Time Card - do we still need this?
  - Copy of TWE: IS22 Time Card - 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"?
[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

ExperimentsInHonesty commented 1 month ago

[x] Time Card 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

ExperimentsInHonesty commented 1 month ago

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
- IS21 Time Card

Completed de-identifying and its been added to resources

ExperimentsInHonesty commented 1 month ago

[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

ExperimentsInHonesty commented 1 month ago

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: Time Card

Added some info to document re this topic

HackforLABot commented 1 month ago

@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.}

ExperimentsInHonesty commented 1 month ago

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.

ExperimentsInHonesty commented 4 weeks ago

Requirement update https://github.com/hackforla/website/issues/7640#issuecomment-2486583954

HackforLABot commented 3 weeks ago

@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.}

sofiatajide commented 3 weeks ago

Progress: worked on Spreadsheet Dashboard - Time Card - 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.

ExperimentsInHonesty commented 2 weeks ago

@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
[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

sofiatajide commented 1 week ago

Instructions

1. Progress: "What is the current status of your project? What have you completed and what is left to do?" 2. Blockers: "Difficulties or errors encountered." 3. Availability: "How much time will you have this week to work on this issue?" 4. ETA: "When do you expect this issue to be completed?" 5. 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

ExperimentsInHonesty commented 1 week ago

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

hackforla / website