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
  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")