Let's Go Learn Knowledge Base
Question
Student and Teacher Upload Instructions
  
Answer

For Schools or Organizations with 50 or More Students

Please download the Excel file below (LGL_StudentTeacher_EntryTemplate_0225.xlsx) to see the required data fields for setting up student and teacher accounts in schools or learning organizations with 50 or more students. This file provides guidance for you or your IT department in preparing the student and/or teacher data for export.

See Attachment at bottom of page

Step One:  Collect the required information for each admin, teacher, and student:

ADMIN/PRINCIPAL INFORMATION REQUIRED:
  Admin first name
  Admin last name
  Admin email address

TEACHER INFORMATION REQUIRED:
  Teacher first name
  Teacher last name
  Teacher email address

STUDENT INFORMATION REQUIRED:
  Student first name
  Student last name
  Grade
  Date of birth
  Student ID number
  Teacher's email address (i.e. homeroom teacher email, math teacher email, or ELA teacher email, etc.)

*If a student needs to be linked to multiple teacher accounts, you can add extra columns to the Student Template after the 'TeacherEmail' column. Label these additional columns as 'TeacherEmail2,' 'TeacherEmail3,' and so on..

Step Two:  Paste the information into the Excel template

Download the attached Excel file attached below.  This Excel has multiple worksheets (tabs): Admin Template, Teacher Template, & Student Template.
PLEASE NOTE: Most student information systems have a feature to export out class or school lists that can then be imported into Excel.

Step Three:  Upload the file securely to LGL

Click here to securely upload your completed template
Please be sure to include your contact information in case there are any questions about the file you submitted.

Or alternatively email completed files to help@letsgolearn.com.

 

***If you have questions about Teacher/Student Templates, please contact our Customer Support at 888-618-7323.***
Was this Article Helpful?
Please add a quick rating! It will help us improve articles for you!
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistenciesin this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.