Data Import Template
The data import template has been shared directly with your school (the link is unique to your school). It's a spreadsheet on Google Sheets. It's made up of three sheets:
The Companies Sheet is all of your corporate partners. At a minimum, what is required is the name of the work-study partner. We have added optional fields for the address, city, etc.
Please only list each company once. If you have multiple sites with the same company, please use a unique name for each. If a company is entered twice, they will both turn red.
The account owner field is the member of your team who manages the relationship with this corporate partner. If you do not divide your accounts, please leave this field blank. It can easily be changed later as well, if you have not divided accounts among your staff.
The Supervisors Sheet is for supervisors (or other employees with whom you interact) at each of your companies.
The Company Name field contains a drop-down for companies in the Companies Sheet.
If you enter a company that is not on that sheet, it will be yellow until you add it to the Companies Sheet.
Email is a required field for this sheet. If you enter an invalid email account, it will be highlighted red:
If a supervisor is entered without an email account, it will be highlighted in yellow until the email is added:
Students & Employments
Email is a required field for students. If you enter an invalid email account, it will be highlighted red:
If a student is entered without an email account, it will be highlighted in yellow until the email is added:
Grade and Graduation Year
You only need to select the grade from the drop-down (or enter 9 through 12). The graduation year will be automatically filled-in:
Select the student's work day. If you're a Monday rotation school, do not assign any students on Monday. If you're a Friday rotation school, do not assign any students on Friday.
Workplace and Supervisor
The Workplace and Supervisor fields are all drop-downs based on the companies and supervisors you've entered:
If the supervisor is associated with a different company than the selected workplace, the cell will be highlighted in red:
What do I do for students who don't have a position at a corporate partner?
If you have students who you have not placed, they should fall into one of three categories:
Working at the School
In this case, add a Company with your school's name. Assign the student to that company.
Add a company with your school's name and "Retraining" in the name. Assign the student to that "company".
Students who have no position yet
Please enter "NO EMPLOYER" in the Workplace Company field.