hackforla / hackforla/internship
TWE: Research: RP014: PII removal
- 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:
- [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
Assessment
This issue has not been assessed yet.