Teachers' Curriculum Institute

How to create a CSV file?

Teacher CSV
​​

  • Column 1

    • Name: ‘email’

    • Description: teacher email address

  • Column 2

    • Name: ‘first_name’

    • Description: teacher first name

  • Column 3

    • Name: ‘last_name’

    • Description: teacher last name

  • Column 4

    • Name: ‘password’

    • Description: teacher password

  • Column 5

    • Name: ‘password_confirmation’

    • Description: teacher password again

  • Column 6

    • Name: ‘program_code’

    • Description: program code from TCI system

    • Note: To find program codes, log into TCI as a subscription manager or coordinator and click on Programs tab

  • Guidelines

    • One row per teacher seat (e.g. 2 rows for single teacher with 2 programs)

    • All field values required for new teachers

    • Password and Password Confirmation optional for existing teachers

    • Passwords entered must be at least 6 characters


Student CSV

  • Column 1

    • Name: ‘first_initial’

    • Description: desired value to recognize student

  • Column 2

    • Name: ‘last_name’

    • Description: desired value to recognize student

  • Column 3

    • Name: ‘username’

    • Description: student login

  • Column 4

    • Name: ‘password’

    • Description: student password

  • Column 5

    • Name: ‘password_confirmation’

    • Description: student password again

  • Column 6

    • Name: ‘teacher_email’

    • Description: email address of student’s teacher for this program

  • Column 7

    • Name: ‘program_code’

    • Description: program code from TCI system

    • Note: To find program codes, log into TCI as a subscription manager or coordinator and click on Programs tab

  • Column 8

    • Name: ‘class_period’

    • Description: period number of student’s classroom

  • Guidelines

    • One row per student seat (e.g. 2 rows for single student with 2 programs)

    • All field values required for new students

    • Password and Password Confirmation optional for existing students

    • Passwords entered must be at least 6 characters

    • Referenced teachers must be registered in TCI system before adding students associated with the teacher

    • Username must be unique

    • Username can only contain letters [a-z], numbers [0-9], dashes [-] or underscores [_]


 

Did you find this article helpful?