CSV File Format Help
Header
The file import action looks for a single “header” line at the top of the input file that maps out where the various required fields are. After the header line, the individual student records follow below. For example:
| f | l | id | team | |
|---|---|---|---|---|
| Judith | Diaz | judith.diaz@sysiphus.com | 200000 | 1 |
| Victoria | Price | victoria.price@sysiphus.com | 200001 | 1 |
| Leigh | Snyder | leigh.snyder@sysiphus.com | 200002 | 1 |
| Rodney | Barton | rodney.barton@sysiphus | 200003 | 1 |
The “First”, “Last”, “Email”, and “ID” fields are required in all input files. The columns in the header can be in any order, as long as the field names are correct.
The field names in the header are not case-sensitive. For any of the fields, you can also just enter the first letter of the field name as shown above (“f” instead of “First”). The exception is “Sex”, which must be spelled out to distinguish it from “Section.” Do not include anything in the header fields except the expected field names. While “First” and “f” are both valid header field names, “First Name” is not valid. Similarly, “email” is valid, but “e-mail” is not.
Required fields
First and Last name
Max Length: 20 characters
Allowed characters: letters, numbers, hyphen, space, apostrophe, period
NOTE: Your input file is allowed to have the “First” and “Last” name fields combined together in a single field. For example:
Last: First, Email, ID, Team, Section
Miller: Chase, chase@sysiphus.com, 1010111, Squirrels, Tues [… etc …]
When the first and last names are combined in a single field, the names don’t have to be separated by colons– ANY character or set of characters will work (for example, commas or semicolons). Also, the first and last names can appear in any order. What’s important here is that the “header” line expresses whatever character(s) are used to separate the first and last names and the order in which the names will appear. Please make sure to not include special characters such as "á" or any other accented letters and symbols. They may not import properly.
Student’s email address
Max Length: 40 characters
Allowed characters: something that appears to be a valid email address
ID
Student’s personal university ID number
Max Length: 15 characters
Allowed characters: letters, numbers, hyphen, and space
NOTE: If you are concerned about privacy issues, you may make up a different ID number for the student purely for use in this system. However, please be consistent across multiple surveys.
Extra fields for Team-Maker Surveys
Sex
The student’s gender
Max Length: N/A
Allowed characters: the value in this field must begin with an ‘M’ or an ‘F’ (case is unimportant)
Students can also identify their gender within the Team-Maker Survey if you ask for that information.
GPA
The student’s current overall GPA
Max Length: N/A
Allowed characters: must be a valid decimal number between 0.0 and 5.0
Pre
The student’s grade in an associated previous or prerequisite course for this class.
Max Length: N/A
Allowed characters: must either be a numeric grade (a valid decimal number between 0.0 and 5.0), a letter grade (“A”-“F” with an optional “+”/”-” afterward; “E” and “F” are equivalent), or “P”/”F” (representing pass/fail grades)
Extra Fields for Peer Evaluation Surveys
Team
The name of the team the student has been assigned to
Max Length: 30 characters
Allowed characters: letters, numbers, hyphen, space
The “Team” field is required when loading data for CATME Peer Evaluation surveys. This field is simply ignored when importing data into Team-Maker surveys.
Section
The name of the class section the student is enrolled in
Max Length: 10 characters
Allowed characters: letters, numbers, hyphen, space
The “Section” field is optional and only used when loading class lists for “multi-section” surveys. You can skip this field entirely if you do not need to define multiple sections.