Importing Teacher and Student Attributes using Load from CSV Follow

 

Hapara Analytics provides insights into your institute’s G Suite usage. Hapara Advanced Analytics extends this view, allowing you to refine the graphs using teacher and student attributes (e.g. Gender and Grade).

The Load from CSV method allows you to load School, Gender, Grade, Ethnicity, English Language Learner status, Free and Reduced Lunch status or Individualized Education Program status information. This method is available on the Hapara Admin Console > Modules > Analytics page.

Note: The main purpose of this method is to import student and teacher attributes. But this method can also be used to import new teachers and students. This aspect is discussed here.

 

Summary of Hapara Advanced Analytics supported Attributes

For multi-school institutes, Hapara Advanced Analytics allows the teacher and student graphs to be refined by School.

For all institutes, Hapara Advanced Analytics allows the student graphs to be refined using these student attributes:

  • Grade
  • Gender
  • Ethnicity
  • English Language Learner status
  • Free and Reduced Lunch status
  • Individualized Education Program status

 

Details on Hapara Advanced Analytics student attributes

These student attributes can be loaded and then can be used with Hapara Advanced Analytics:

Attribute

Description

Valid options

School

The school code for the school the student attends. Only one school code is allowed per student

The school code can be at most 12 characters long. Longer entries are truncated.

The full name of each school can (optionally) be entered in the Hapara Admin Console > Configuration > School Configuration page.

Gender

The student’s gender.

  • M = Male
  • F = Female
  • X = Mixed

Grade

In the Northern hemisphere, the student’s grade.

In the Southern hemisphere, the student’s year.

  • P or -1 = Prekindergarten
  • K or 0 = Kindergarten
  • 1
  • ...
  • 13
  • G or 14 = Postgraduate

Race

The student’s ethnicity or race. Only one value is allowed per student.

  • A = Asian
  • B = Black or African-American
  • H = Hispanic or Latino
  • I = American Indian or Alaska Indian
  • M = Multiracial
  • O = Maori
  • P = Hawaiian or Pacific Islander
  • R = Aboriginal or Torres Strait Islanders
  • W = White

ELL

The student’s English Language Learner status.

  • Y = Yes
  • N = No

FRL

The student’s Free And Reduced Lunch status.

  • F = Free
  • R = Reduced
  • N = No discount

IEP

The student’s Individualized Education Program status.

  • Y = Yes
  • N = No


 

Details on Hapara Advanced Analytics teacher attribute

These teacher attribute can be loaded and then can be used with Hapara Advanced Analytics:

Attribute

Description

Valid options

School

The school code for the school the teacher teaches at. Only one school code is allowed per teacher.

The school code can be at most 12 characters long. Longer entries are truncated.

The full name of each school can (optionally) be entered in the Hapara Admin Console > Configuration > School Configuration page.


 

Importing Student Attributes from a CSV file

The Hapara Admin Console > Modules > Analytics page includes a section “Load Student from a CSV”.

The student CSV being loaded must have a column titled “Email” containing student email addresses. The student CSV can also contain some or all of these columns School, Gender, Grade, Race, ELL, FRL and IEP. Each column must be titled. For example:

Email

School

Gender

bill.smith@myschool.com

ELK

M

rob.jones@myschool.com

ELK

 

jane.jackson@myschool.com

 

F

molly.henderson@myschool.com

SAN

M

 

As shown in the example above, blank attributes are allowed. The import process ignores (does not import) any blank attributes it finds.

Analytics will start using any newly loaded students and new student attributes the Monday after the data is imported.

Note: For students that have previously been loaded via Hapara Admin Console > Data Loader for use with Teacher Dashboard, Highlights or Workspace, the student’s school is already known, and can not be modified using this method.

 

Importing Teachers and their Attributes from a CSV file

The Hapara Admin Console > Modules > Analytics page includes a section “Load Teachers from a CSV”. 

The teacher CSV being loaded must have a column titled “Email” containing teacher email addresses. The teacher CSV can also contain the column School. For example:

Email

School

mei.ling@myschool.com

ELK

ivan.quirke@myschool.com

 

mike.neligan@myschool.com

SAN

As shown in the example above, blank school attributes are allowed. The import process ignores (does not import) any blank attributes it finds.

Analytics will start using any newly loaded teachers and new teacher attributes the Monday after the data is imported.

Note: For teachers that have previously been loaded via Hapara Admin Console > Data Loader for use with Teacher Dashboard, Highlights or Workspace, the teacher’s school is already known, and can not be modified using this method.

 

 

 

 

Have more questions? Submit a request