How can we help?

CSV Data Dictionary for Administrator Reports

Updated

Khan Academy offers administrators the option to export student data into downloadable CSV files they then can use for additional analysis and reporting outside of the Khan Academy platform. This document will go over the data included in those files, and how it is formatted. 

To start off though, let’s answer the question: “What is a CSV?”

  • A CSV, or Comma Separated Values is a type of file that stores data. 
  • In a CSV file, each line is a data record and each record consists of one or more fields, separated by commas. 
  • It's like a simple spreadsheet, but without the formulas and formatting. 
  • You can then open CSV files in programs like Microsoft Excel, Google Sheets, or Numbers

Khan Academy offers 5 types of CSV files for administrators to download. Click on the CSV title to jump to information about the data on it:

  1. Overall Khan Academy Student Data CSV Report: File Name: District-name_daterange
  2. Mastery Progress:
    • By Student: File name: District-name_MasteryProgressStudent_daterange
    • By Classroom: File name: District-name_MasteryProgressClassroom_daterange
  3. Skills Progress: File name: District-name_skills_progress_Course-name_daterange
  4. SAT Skills Progress: File name: District-name__daterange 
  5. Khanmigo CSV: (Available if your school district has purchased Khanmigo licenses for your teachers and/or students) File name: District-name_khanmigo 

Note: The numbers at the end of the file names are the date in this format: YYYYMMDD. Example:  20230710_20230717 means: July 10, 2023 through July 17, 2023

Now, let's dive into the data that is included in these 5 files:

1. Overall Khan Academy Student Data CSV Report Data:

  • Column A: Student Name
  • Column B: Student Email
  • Column C: Student SIS ID
  • Column D: Roster Status (Rostered, No Longer Rostered, or Activated) If the student is no longer shared from Clever or Classlink to Khan Academy on the day the report is exported, the status will be "No Longer Rostered." Rosters are updated every 24 hours 
  • Column E: Rostered Grade
  • Column F: School Name
  • Column G: Total learning minutes (Total active learning time completed, excluding non-learning activities like navigating the site)
  • Column H: Skills Worked on (Total number of skills that students practiced on) 
  • Column I: Skills Leveled Up (Total number of skills worked on that moved up a mastery level by the end of date range)
  • Column J: Skills Leveled Up to Proficient or Higher (Total number of skills that moved up a mastery level and ended at the Proficient or Mastered level by the end of the date range)

SAT data (empty if not applicable): 

Please note that these columns reflect work done by students in grades 9-12 on the Official SAT Prep tool, not on the Digital SAT course. Please note: the Official SAT Prep tool will sunset in early 2024. Student data will not be able to be downloaded once the tool is sunset. 

  • Column K: SAT Learning Mins (Total minutes spent practicing on Official SAT Practice)
  • Column L: Time on Math (Percentage of SAT learning minutes spent practicing on math section of Official SAT Practice)
  • Column M: Time on Reading & Writing (Percentage of SAT learning minutes spent practicing on reading and writing section of Official SAT Practice)
    • Note: if the two percentages don’t add up to 100%, the remainder of the time was spent on essay writing or test taking techniques 
  • Column N: Linked to CB (True or False indicating if the account is linked to the student's College Board account)
  • Column O: Number of Completed SAT Practice Exercises Math
  • Column P: Percent SAT Practice Exercises Passed Math (What percent of the math exercises did the student passed (get at least 50% on)
  • Column Q: Number of Completed SAT Practice Exercises Reading & Writing
  • Column R: Percent SAT Practice Exercises Passed Reading & Writing (What percent of the Reading & Writing exercises did the student passed (get at least 50% on)

                                                                                                                                                                              

2. Mastery Progress Report CSV Data:

  • Student Mastery CSV
    • Column A: Student Name
    • Column B: Student Email
    • Column C: Student SIS ID
    • Column D: No longer rostered: (If the student is no longer shared from Clever or Classlink to Khan Academy on the day the report is exported, this column will say "True." Rosters are updated every 24 hours) 
    • Column E: Rostered Grade
    • Column F: School Name
    • Column G: Domain (Subject area of the class)
      • Domain options: Math, Science, Arts and Humanities, Reading and Language Arts, Economics, Test Prep, Computing, Districts (for custom curated courses) or Life Skills
    • Column H: Course (The Khan Academy course added to the classroom. Example: The Algebra 1 Course) 
      • Note: If the teacher did not add a course onto their classroom, the student data will not show up on the downloaded CSV
    • Column I: Shared Classrooms (Total number of classrooms a student is in that have the selected course added to it)
      • Note: If a student is in multiple classrooms working on the same course, they will have multiple rows on the CSV. Therefore, if you would like to see unique (non-duplicated) data, you should filter by "Shared Classrooms"=1
    • Column J: Section (class) Name 
    • Column K: Section ID
    • Column L: Teacher Name 
    • Column M: Teacher Email 
    • Column N: Teacher SIS ID
    • Column O: SIS Course Name
    • Column P: SIS Course ID 
    • Column Q: Course Goals (Number of Course Mastery Goals added)
    • Column R: Unit Goals (Number of Unit Mastery Goals added) 
    • Column S: YY.MM.DD CM % (Course Mastery % by that student for that given week)
    • Column T: YY.MM.DD CM pts (Course Mastery points earned (up to 100 points per skill) by the student in that given week) 

Some notes about Columns S, T and beyond: 

  • A CM% and CM pts column are added for every week of the school year. Please note that Khan Academy does not track Mastery data throughout the summer. 
  • Each column tracks data for a particular week: from Monday-Sunday. The date is shown in the  YY.MM.DD format: 23.06.18 equals June 18, 2023 
  • The last CM % and CM pts columns of the spreadsheet show the current week. 

Below is a gif showing an example of how the Student Mastery Progress CSV is formatted: 

Student Mastery Progress New.gifBelow is a screenshot of columns S through V: 

  • Columns S and T are the data from the week of Sunday, August 20, 2023 through Saturday, August 26, 2023. 
  • Columns U and V are the data from the following week: Sunday, August 27, 2023 through Saturday, September 2, 2023 . 

  • Classroom Mastery CSV:
    • Column A: School Name
    • Column B: Section (class) Name
    • Column C: Section ID
    • Column D: KA Domain
    • Column E: KA Course
    • Column F: Teacher Name
    • Column G: Teacher Email
    • Column H: Teacher SIS ID
    • Column I: SIS Course Name
    • Column J: SIS Course ID
    • Column K: Activated Students in class
    • Column L: Course Goals (Number of Course Mastery Goals added)
    • Column M: Unit Goals (Number of Unit Mastery Goals added) 
    • Column N: YY.MM.DD Median CM % (Median Course Mastery % of activated students for that given week)
    • Column O: YY.MM.DD students with progress (Number of students who made progress towards Course Mastery in the designated week)

Some notes about Columns N, O and beyond: 

  • A Median CM% and Students with Progress column are added for every week of the school year. Please note that Khan Academy does not track Mastery data throughout the summer. 
  • Each column tracks data for a particular week: from Monday-Sunday. The date is shown in the  YY.MM.DD format: 23.06.18 equals June 18, 2023 
  • The last CM % and CM pts columns of the spreadsheet show the current week. 

Below is a gif showing an example of how the Classroom Mastery Progress CSV is formatted: 

Mastery Classroom CSV New.gif

Below is a screenshot of columns N through Q: 

  • Columns N and O are the data from the week of Sunday, August 20, 2023 through Saturday, August 26, 2023. 
  • Columns P and Q are the data from the following week: Sunday, August 27, 2023 through Saturday, September 2, 2023 . 

                                                                                                                                                                             

3. Skills Progress Report CSV Data:

  • Column A: School Name
  • Column B: Rostered Grade
  • Column C: Student Name
  • Column D: Student Email
  • Column E: Student SIS ID
  • Column F: No longer rostered (If the student is no longer shared from Clever or Classlink to Khan Academy on the day the report is exported, this column will say "True." Rosters are updated every 24 hours) 
  • Column G: Skill name
  • Column H: Current skill mastery level (Attempted, Familiar, Proficient, or Mastered)
  • Column I: Skills Mastery Points: (The current number of points demonstrated by the student in that skill)
  • Column J: Learning Time on Skill (Time spent practicing this skill. Video and article learning minutes are not included in this metric.)
  • Column K: Standards (Common Core and/or applicable state standards linked to this skill)
  • Column L: SIS Course Name(s)
  • Column M: SIS course ID(s)
  • Column N: Section (Class) Name(s)
  • Column O: Section ID(s)
  • Column P: Teacher(s) Name
  • Column Q: Teacher(s) Emails
  • Column R: Teacher(s) SIS IDs

Below is a gif showing an example of how the Skills Progress CSV is formatted: 

                                                                                                                                                                               

4. SAT Skills Progress

Please note that this CSV pulls data from student work done on the Official SAT Prep tool, not the Digital SAT course. To see data from the Digital SAT Course, use the Skills Progress CSV and select a Digital SAT course. 

Data included: 

  • Column A: School Name
  • Column B: Rostered Grade
  • Column C: Student Name
  • Column D: Student Email
  • Column E: Student SIS ID
  • Column F: No longer rostered (If the student is no longer shared from Clever or Classlink to Khan Academy on the day the report is exported, this column will say "True." Rosters are updated every 24 hours) 
  • Column G: Area: Math, Reading or Writing 
  • Column H: Skill Name
  • Column I: Starting Skill Level (0, 1, 2, 3, or 4, pertaining to the difficulty of the practice questions worked on. 4 being the most difficult)
  • Column J: Ending Skill Level (0, 1, 2, 3, or 4, pertaining to the difficulty of the practice questions worked on. 4 being the most difficult)

                                                                                                                                                                               

5. Khanmigo CSV

Available if your school district has purchased Khanmigo licenses for your teachers and/or students.

Data included: 

  • Column A: User type (teacher or student) 
  • Column B: Name
  • Column C: Email
  • Column D: SIS ID
  • Column E: No longer rostered (If the student is no longer shared from Clever or Classlink to Khan Academy on the day the report is exported, this column will say "True." Rosters are updated every 24 hours) 
  • Column F: Rostered Grade
  • Column G: Shared School
  • Column H: School Name
  • Column I: Shared Class
  • Column J: Section (Class) Name
  • Column K: Section ID
  • Column L: Teacher Name
  • Column M: Teacher Email
  • Column N: Teacher SIS ID
  • Column O: SIS Course Name
  • Column P: SIS Course ID
  • Column Q: Chats 
  • Column R: Flagged Chats (relevant resources: Why was my Khanmigo conversation flagged?)
  • Column S: Interactions
  • Column T: Tokens (relevant resource: What are tokens and how to count them?)