Khan academy advocate tips

• LTT tips (terminology)
• LTT exported tsv file tips

LTT tips

• Tree level name: root - domain - subject - topic - tutorial - videos/exercises/articles
• domain: Math, Science, ...
• subject (course): Arithmetic, Physics,...
• topic (unit): Addition and Subtraction, One-dimensional motion, ...
• tutorial (lesson): Basic addition and subtraction, Displacement, velocity, and time, ...

LTT exported tsv file tips

• Preparation of a filtered sheet.
  1. See Export all content by Daniel's post in forum (20200624)
  2. Download topi tree tsv file (English for translation work)
  3. Import it to google sheet
  4. Duplicate inside the sheet with a (simple) name (e.g., sheet01)
  5. Create empty sheet with a (simple) name (e.g., sheet02)
• Filter example. On blank sheet (sheet02) at A1.
  • Filter "Video", "arithmetic", "arith-decimals"
    =filter(Sheet0!A:AL, Sheet0!A:A="Video", Sheet0!F:F="arithmetic", Sheet0!G:G="arith-decimals")
• Deep copy the result: Select the part of the sheet by mouse, avoid the A1, which is filter function, and copy and paste to a new sheet.