hackforla / hackforla/internship

TWE: Research: RP014: PII removal

Open
#732 0 comments 0 reactions 0 assignees View on GitHub
complexity: small draft feature: research feature: research audits Participant Type: Mentor PBV: research ready for research lead Research: RP014 role: UI/UX research size: 0.50pt
Dominant language
CSS
Stars
20
Forks
6
PR merge metrics
No merged PRs in 30d

Description

### Dependencies
- #579

### Overview
We need to de-identify the content in RP014' s folder saved in Internship > Internships > Research

### Action Items

### Proposed solution to de-identify the [responses to the questions](https://docs.google.com/forms/d/1oJIf5Me_ZpfGL0cMRFle8dujcY_d-IZYjsGiSlrpXFs/edit#responses)
- De-identify [TWE: Research: Mentor Exit Interview Script/Form](https://docs.google.com/forms/d/1oJIf5Me_ZpfGL0cMRFle8dujcY_d-IZYjsGiSlrpXFs/edit#responses) responses:
- [x] Create a spreadsheet that corresponds with the responses by choosing 'Link to Sheets'. This sheet will be named as the `Form Responses` spreadsheet in the following steps.
- [x] Unlink the Google form from the `Form Responses` spreadsheet
- [x] Add a spreadsheet as a new tab to the `Form Responses` spreadsheet you just generated by choosing the `+` in the lower left of the spreadsheet.
- In the new spreadsheet tab,
- [x] Rename spreadsheet B as `Links to original Google form and Wiki page`
- [x] In Cell 1A, type in `Link to the original Google form`
- [x] In Cell 1B, add a link of the Google form
- [x] In Cell 2A, type in `Link to RP014's Wiki page`
- [x] In Cell 2B, add a link of the research plan's wiki page
- There are now two tabs in the spreadsheet document you just created, and the two tabs look like these: Image
- [x] Rename the entire spreadsheet document that contains both the `Form Responses` tab and the `Links to original Google form and Wiki page` tab by adding the research plan number in the document name so team members can identify the research plan the spreadsheets are associated with easily.
- [x] Move the spreadsheet document that contains both the `Form Responses` tab and the `Links to original Google form and Wiki page` tab to the corresponding research plan folder under a folder on the Internship - PII drive called: delete when research plan complete.
- The path is Internship - PII > Delete when research plan complete > RP014
- If RP014's folder is not set up yet, please go ahead and set up RP014's folder in the `Delete when research plan complete` folder
- [ ] De-identify the responses in the spreadsheet document that contains both the `Form Responses` tab and the `Links to original Google form and Wiki page` tab if needed
- [ ] After removing all PII, make a copy of the spreadsheet document that contains both the `Form Responses` tab and the `Links to original Google form and Wiki page` tab so there is no version history can trace any PII
- [ ] Move the new de-identified spreadsheet document with no version history to the research plan folder on the Internship > Internships > Research > Research by Plan # and Name > RP014 folder
- [ ] Rename the new de-identified sheet by removing `Copy of Copy of ` and adding `[De-identified]` to the beginning of the file name
- [ ] Go to the interview script/form that has the original responses in RP014's folder, and RP014 folder's path is Internship > Internships > Research > Research by Plan # and Name > RP014 folder
- [ ] Delete the existing responses from the Google form
- [ ] Go to Internship - PII > Delete when research plan complete > RP014 (if it is not already open)
- [ ] Delete the copy of the spreadsheet document that contains spreadsheets A and B you previously made to de-identify PII
- [ ] If you can't delete the file in the Internship - PII drive, please link the file in a new comment in this issue, and let the lead know so they can delete the file for you.

- For more context: A similar research plan that we de-identified can be found in issue #577 and [this comment](https://github.com/hackforla/internship/issues/577#issuecomment-2290080512).

### Resources/Instructions
REPLACE THIS TEXT -If there is a website which has documentation that helps with this issue provide the link(s) here.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.