Change Transcription Template columns names

[raquelnish]

Overview

The names of columns A-D at the Transcription sheet template must make more sense, so new UXRs can understand them better

Action Items

• On the Transcription Template
  • Change Column A
    • from: Field from Form
    • to: Questions from Form
  • Change Column B
    • from: Existing text (form submission)
    • to: Ranking Response & Interviewer Notes
  • Change column C
    • from: exactly what OtterAI says (taken from audio)
    • to: Interviewee text before your edits (produced by OtterAI)
  • Change column D
    • from: Actual cleaned input
    • to: Interviewee text after your edits
• run it on Transcriptions Sheets already created:
• Move Row down to between row 10 and 11. Making it the new 10, because 2-10 will move up. See screenshots below

Resources:

Transcription Sheet template

Currently the template look like this

and we want it to look like this

Script: https://colab.research.google.com/drive/10E_UA0feefZrph7OSi_ODVv8d3Zz6ft6

[Baleja]

Here is the link to the Wonder Woman https://docs.google.com/spreadsheets/d/1o0SlXYZmQxXxzmLRft7zhd3vvp-NxkX1Ou16qtP2EAs/edit#gid=845721923

[MarianneAnthonette]

Transcription column names have been changed for existing transcription sheets and the template. Updates to the formatting of older transcription sheets are being tracked in issue #199