Using a CSV to load teacher and student attributes to Hāpara Analytics Follow

In this article:

Hāpara Analytics supported attributes overview

Hāpara Analytics provides insights into your institute’s G Suite usage with options allowing you to refine the graphs using teacher and student attributes (i.e. school, gender or grade). The Load from CSV method allows you to load any of these attributes. This method is available on the Hāpara 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. Read more about this here.

For multi-school institutes, Hāpara Analytics allows the teacher and student graphs to be refined by school.

For all institutes, Hāpara 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 Hāpara Analytics student attributes

These student attributes can be loaded and then can be used with Hāpara 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 Hāpara Admin Console > Configuration > School Configuration page.

Gender

The student’s gender.

  • M = Male
  • F = Female
  • X = Other

Grade

The student's grade or 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 = Native American or First Nations
  • M = Multiracial
  • O = Māori
  • 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 Hāpara Analytics teacher attributes

These teacher attributes can be loaded and used with Hāpara 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 Hāpara Admin Console > Configuration > School Configuration page.

How to import student attributes from a CSV file

The Hāpara Admin Console > Modules > Analytics page includes a section called Load Students 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 Hāpara 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.

How to import teacher attributes from a CSV file

The Hāpara 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 Hāpara 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