TWE: IS22: RP023: Intern Application Interview Transcription: Set Up

[pandanista]

Dependencies

• The research plan's interview recordings folder has been created on Internship - PII's "My Drive"

Overview

We need to set up a few spreadsheets and a folder for RP023's Intern Application interview transcripts so that we can move on to transcribe the interviews.

During these tasks you will be asked to add link to the Resources/Instructions section, and that section is at the bottom of this issue (go view it now).

Another tip is to use split browser windows side by side when working on any GitHub issue, so you can edit the issue on one window, and check the resources or click through links on the other window to avoid a lot of back and forth. Make sure to refresh both windows to reflect any changes you made, including updating the issue or checking the boxes on one of them.

Action Items

• UX lead asks admin to add the team member working on this issue to the 1Password internship-UX's vault so that they can have access to internship-UX's email and other software account information in case they need it.
• UX lead adds the assignee to the Internship - PII's "My Drive" as a Content Manager so that they have access to internship - PII's My Drive where the recordings and transcriptions with PII are stored.
  • UX lead accesses the Internship - PII's "My Drive"
  • Choose "Manage members", which is located towards the top right side of the browser
  • Enter the assignee's email address and select the role as "Content Manager"
  • Confirm with the assignee that they have access to the Internship - PII's "My Drive"

Customize Resource Links

• Customize Resource for Wiki Page Link

  • Go to the wiki page: Research Output Overview (Resources # 1.01)
  • Find relevant wiki page for RP023
  • Copy the link for the wiki page
  • In Resources # 2.01, place the link you just copied between parentheses at the end of the line with no space in between the right bracket ] and the left parenthesis (, so it turns into a hyperlink
  • Choose "Update comment" in GitHub and make sure all the checkboxes above have been checked

• Customize Resource for this Research Plan's Google Drive Folder

  • Open the Google Drive's Research by Plan # and Name Folder (Resources # 1.02)
  • Choose the RP023 folder
  • Copy the link of the RP023 folder
    1. Choose the three vertical dots on the right side of the RP023 folder
    2. Choose "Share"
    3. Choose "Copy Link" and "Done"
  • In Resources # 2.02, place the link you just copied between parentheses at the end of the line with no space in between the right bracket ] and the left parenthesis (, so it turns into a hyperlink
  • Choose "Update comment" in GitHub and make sure all the checkboxes above have been checked

• Customize Resource for Interview Recordings and Transcriptions Tracking Sheet

  • Choose "TWE: Template: Interview Recordings and Transcriptions Tracking Sheet" (Resources # 1.03)
  • Choose "USE TEMPLATE" to make a copy of the document
  • Rename and customize the file by following the steps
    • Copy 

    TWE: IS22: RP023: Intern Application Interview Recordings and Transcriptions Tracking Sheet
    

    • Choose "File" > "Rename", and paste the text you copied into the top field
      f
    • The name of the file is now updated
    • Copy

    TWE: IS22: RP023: Intern Application Interview Recordings and Transcriptions Tracking Sheet
    

    • Choose the header row (row 1)
    • Choose the formula bar, and paste the text you copied into it
    • The title of the spreadsheet is now updated
    • Copy 

    Intern Number
    

    • Choose cell A2
    • Choose the formula bar, paste the text you copied
    • The cell of the spreadsheet is now updated
  • Save the spreadsheet into this Research Plan's Google Drive folder in the Internship's shared drive (Resource # 2.02)
    1. Choose File > Move (or Move icon)
    2. Choose "All locations"
    3. Choose Shared drives > Internship > Internships > Research > Research by Type > Intern > folder for RP023
    4. Choose "Move"
    5. Choose "Move" when it asks if you want to change ownership to a shared drive
    6. Dismiss the notification that says the file in now in the shared drive
  • Choose "Share"
  • Choose "Copy link" and "Done"
  • In Resources # 2.03, place the link you just copied between parentheses at the end of the line with no space in between the right bracket ] and the left parenthesis (, so it turns into a hyperlink
  • Choose "Update comment" in GitHub and make sure all the checkboxes above have been checked

• Customize Resource for De-identified Participants List Spreadsheet in the Shared Google Drive to Keep Track of Any Stakeholders Mentioned in Interview Sessions

  • Choose "TWE: Template: De-identified Participants List from Interviews (UXR Excluded)" (Resources # 1.04)
  • Choose "USE TEMPLATE" to make a copy of the document
  • Rename and customize the file by following the steps
    • Copy 

    TWE: IS22: RP023: De-identified Participants List from Interviews (UXR Excluded)
    

    • Choose "File" > "Rename", and paste the text you copied into the top field
    • The name of the file is now updated
    • Copy

    TWE: IS22: RP023: De-identified Participants List from Interviews (UXR Excluded)
    

    • Choose the header row (row 1)
    • Choose the formula bar, and paste the text you copied into it
    • The title of the spreadsheet is now updated
  • Move the file to RP023's folder in the shared Google Drive
    1. Choose File > Move > All Locations > Shared drives > Internship > Internships > Research > Research by Plan # and Name > RP023 > Move
    2. Choose "Move" when it asks if you want to change ownership to a shared drive
    3. Dismiss the notification that says the file in now in the shared drive
  • Choose "Share" on the top right corner of the spreadsheet
  • Choose "Copy link" and "Done"
  • In Resources # 2.04, place the link you just copied between parentheses at the end of the line with no space in between the right bracket ] and the left parenthesis (, so it turns into a hyperlink
  • Choose "Update comment" in GitHub and make sure all the checkboxes above have been checked

• Customize Resource for Interview Recording Folder stored in the Internship - PII's My Drive

  • Make sure you are logged into your Google account associated with TWE project so you will be able to access the Internship - PII's 'My Drive' in the next steps
  • Choose Shared drives > Internship - PII > Internship - PII
  • Choose TWE Interview Recordings by Plan # folder in Internship - PII's My drive (Resources # 1.05)
  • Locate the video recording folder for RP023 inside the folder TWE Interview Recordings by Plan #
  • Copy the link of the video recording folder for RP023
    1. Choose the three vertical dots on the right side of the folder
    2. Choose "Share"
    3. Choose "Get link"
    4. Choose "Copy Link" and "Done"
  • In Resources # 2.05, place the link you just copied between parentheses at the end of the line with no space in between the right bracket ] and the left parenthesis (, so it turns into a hyperlink
  • Choose "Update comment" in GitHub and make sure all the checkboxes above have been checked

• Customize Resource for Participants List Spreadsheet to Save in the Video Recording Folder for RP023 in the Internship - PII's My Drive

  • Choose "TWE: Template: Participants List from Interviews (UXR Excluded)" (Resources # 1.06)
  • Choose "USE TEMPLATE" to make a copy of the document
  • Rename and customize the file by following the steps
    • Copy 

    TWE: IS22: RP023: Participants List from Interviews (UXR Excluded)
    

    • Choose "File" > "Rename", and paste the text you copied into the top field
    • The name of the file is now updated
    • Copy

    TWE: IS22: RP023: Participants List from Interviews (UXR Excluded)
    

    • Choose the header row (row 1)
    • Choose the formula bar, and paste the text you copied into it
    • The title of the spreadsheet is now updated
  • Save the spreadsheet into RP023 Interview Recording Folder in the Internship's PII drive (Resource # 2.04)
    1. Choose File > Move (or Move icon)
    2. Choose "All locations"
    3. Choose Shared drives > Internship - PII > Internship - PII > TWE Interview Recordings by Plan # > folder for RP023
    4. Choose "Move"
    5. Choose "Move" when it asks if you want to change ownership to a shared drive
    6. Dismiss the notification that says the file in now in the shared drive
  • Choose "Share" on the top right corner of the spreadsheet
  • Choose "Copy link" and "Done"
  • In Resources # 2.06, place the link you just copied between parentheses at the end of the line with no space in between the right bracket ] and the left parenthesis (, so it turns into a hyperlink
  • Choose "Update comment" in GitHub and make sure all the checkboxes above have been checked

Set Up A Folder for De-identified Transcripts in the RP023 folder (Resources # 2.02)

• Go to RP023 folder (Resources # 2.02)
• Create a new folder for the de-identified transcripts in the RP023 folder by choosing "New" and "New folder" on the left side bar
• Name the "New folder" by copying

RP023 De-identified Transcripts

• Paste the text you copied into the folder name
• Copy the link of the folder
  1. Choose the three vertical dots on the right side of the folder
  2. Choose "Share"
  3. Choose "Get link"
  4. Choose "Copy Link" and "Done"
• Paste the copied link into parentheses at the end of the line in Resources # 2.07
• Choose "Update comment" in GitHub and make sure all the checkboxes above have been checked

Rename Uploaded Recording Video Files If Needed

• Go to the interview recording folder linked in Resource # 2.05
• Make sure each recording video file in the folder is named as RP023-UX Researcher Abbreviation###-Intern Abbreviation###
  • If the recording video files are not in the format above, please rename the recording files in the format above first before taking any more actions
  • An example looks like this: RP006-U007-I001.mp4, which means this is an interview transcript for research plan 006, conducted by UX Researcher 007, and the interviewee is Intern 001
  • In case if you would like to double check to ensure the accuracy of the interviewer and interviewees' numbers, both UX Researcher Abbreviation### and Intern Abbreviation### can be found in the session table tab of TWE: IS22: RP023: Intern Application Interview Roll Call and Session Table in RP023 folder (linked in Resources # 2.02)

Update the wiki page for this research plan (Resources # 2.01)

• Open the link in Resource 2.01
• Find the "Interview Recordings & Transcripts" section
• Copy and paste Resource 2.07 (both the text and URL) into the "Interview Recordings & Transcripts" section
• Choose "Save Page"

Review and hand off

• Review with UXR Leads on the spreadsheets, de-identified transcript folder setup, renamed recording files, and updated wiki section
• The assignee checks in with UXR Leads to create new issues for transcribing the interview recordings if needed
• UXR Lead or PM removes the assignee from the Internship - PII's "My Drive" when closing the issue if the assignee does not need to access the Internship - PII's "My Drive" any longer
• Product sign-off

Resources/Instructions

Resources for creating this issue

1.01 Wiki: Research Output Overview
1.02 Google Drive Folder: Research by Plan # and Name
1.03 TWE: Template: Interview Recordings and Transcriptions Tracking Sheet
1.04 TWE: Template: De-identified Participants List from Interviews (UXR Excluded)
1.05* TWE Interview Recordings by Plan #
1.06 TWE: Template: Participants List from Interviews (UXR Excluded)

Resources gathered during the completion of this issue

2.01 Wiki: Research Plan: RP023
2.02 Google Drive Folder: RP023
2.03 TWE: IS22: RP023: Intern Application Interview Recordings and Transcriptions Tracking Sheet
2.04 TWE: IS22: RP023: De-identified Participants List from Interviews (UXR Excluded)
2.05* RP023 Interview Recording Folder
2.06* TWE: IS22: RP023: Participants List from Interviews (UXR Excluded)
2.07 RP023 De-identified Transcripts

• indicates this folder can only be accessed from the Internship - PII's "My Drive"Application

[mh-faraji]

@pandanista I completed the issue. Please let me know if there is anything else.

[pandanista]

@mh-faraji All the resources gathered from 2.01 to 2.07 look good. Appreciate your work!
One thing I did notice was that the intern application interviews' files were not renamed in the RP###-U###-I### format.

• I found the IS22 intern roster here. Would you please double check and see if the interns' name and number could match? No need to edit the file names until we can match each person.
• Would you also watch the first 5 mins of each video and see who the interviewers were? Please list out the interviewers and we can check with Product to see how we should proceed. I am thinking either using U000 or give each person a specific number if they were not the same researchers conducted the intake and exit interviews. Intake interviews RP006 and exit interviews RP012 have roll call and session table for both the interviewer and interviewee information in their research plan folders.
  Thank you very much!

[mh-faraji]

@pandanista,

• I checked the interns' names and numbers. Only one person was missing from the IS22 intern roster, so I added his name to the roster and assigned him number 12.

• I also watched the first few minutes of the interviews. There are six interviewers. Where should I list them? They are not the same researchers who conducted Intake interviews RP006. I couldn't find the roll cal file for PR012 to see if they are the same.

[pandanista]

@mh-faraji

• RP012's roll call and session table is here.
  • I just moved it to the RP012's recording folder on PII drive.
• Since there are more than one interviewer, let's create a roll call and session table for RP023 using this template.
  • Would you please save the roll call and session table you will create in the RP023's interview recording folder in the PII drive? Thank you.
  • In the roll call table (first sheet), assign the interviewers numbers, like 001, 002, 003,
  • In the session table (second sheet), fill out any session info if we have any.
  • I took another look at RP006 and RP012's roll call, and realized the UXR numbers are not consistent, unlike interns. So, UXR 005 in RP012 could be UXR 012 in RP006. No need to worry about avoiding the existing numbers in this case.

[mh-faraji]

I saved the roll call and session table I created in RP023's interview recording folder on the PII drive and assigned the interviewers numbers 1 to 6, but I couldn't find information about the date and time of the recordings to fill out the session table.

[ExperimentsInHonesty]

Use the time from the recording file

[pandanista]

• fill out the session table (second sheet) of TWE: IS22: RP023: Intern Application Interview Roll Call and Session Table.
• rename the recoding files in RP023 Interview Recording Folder
• create new issues for transcribing

[mh-faraji]

@pandanista

• I filled out the session table (second sheet) of TWE: IS22: RP023: Intern Application Interview Roll Call and Session Table,
• and rename the recoding files in RP023 Interview Recording Folder
• By "create new issues for transcribing", do you mean new issues for all RP023 Interview Recording Folder that I renamed?

[pandanista]

@mh-faraji Thank you.

• Well done on the Roll Call and Session Table and the files' renaming.

• Yes, just like the issues you created for transcribing RP014's and RP006's interviews

  • For examples, TWE: IS22: RP014: Mentor 005 Exit Interview Recording: Transcribe #661 and TWE: IS22: RP006: Intern 011 Intake Interview Recording: Transcribe #658
  • Please use the transcribe template to create transcribing issues for intern 1 - 12's application interviews. Much appreciated.

[mh-faraji]

@pandanista What is the "type of Interview" for TWE: IS22: RP023: Intern Application Interview? Is it "Application"?

[mh-faraji]

@pandanista I created transcribing issues for interns 1 - 12's application interviews. Please let me know if there is anything else.

[pandanista]

@mh-faraji: Yes, we meant application as the type of interviews. Thank you very much! I will take a look at the new issues you created before closing this issue.

[pandanista]

@mh-faraji All the new issues look good to me. Appreciate your help creating them. We can close this issue now.