Creating Student Accounts via Bulk Registration
We can bulk register Students from data supplied as a CSV or TSV file or an Excel Spreadsheet.
There are eighteen fields required, in the following order:
- First name
- Last name
- Unique ID number
- Date of birth
- Class Code (if available)
- Ethnicity (if available)
- Language of origin (if available)
- Free and reduced mean eligibility (if available)
- Title 1 eligibility (if available)
The class code information is helpful for teachers who wish to review work or set homework for students within their classes. As a student will be in multiple classes, we usually request the data be sent in a excel format where one student is repeated on several rows, one row for each class. We will however accept class codes on one row.
Do not use spaces, special characters or punctuation marks such as commas or full stops.
Do not merge two fields into one column – eg Firstname and Surname.
Sending the student data to Penda
When you have created the Student Data file, save it in Excel or CSV format (Tab Delimited).
If you are comfortable with attaching files to email messages, please email the file to firstname.lastname@example.org .
IMPORTANT: You MUST quote your Center ID when sending Student Data or we will not know which school the data has come from. If you do not know your Center ID, please quote your schools name and post code.