This article is to help you to export your learner data. Please note that the learner data must be delivered to us via one of the following:
- CSV format
- Excel spreadsheet
If you plan to deliver the learner data via CSV format or Excel, you MUST adhere to the fields we require.
There are nine compulsory fields required for data entry:
3. Admission Number
4. Gender - enter 'M' or 'F" only
5. Date of Birth - enter DOB in DD/MM/YY format
6. Registration Group
7. Year - enter a digit between '1' and '14' only
8. Unique Pupil Number (UPN) - free text field
9. Ethnicity (not compulsory) - free text field
10. Free School Meals (not compulsory) - enter 'T' or 'F' only
11. Class Details - free text field
To make the fullest use of SAM Learning's Three-wave Intervention program, you will also need to submit the following 5 student data fields:
12. FSM6 - enter 'T' or 'F' only
13. Pupil Premium - enter 'T' or 'F' only
14. Special Education Needs - enter 'T' or 'F' only
15. Looked After Children - enter 'T' or 'F' only
16. English as an Additional Language - enter 'T' or 'F' only
|Forename||Surname||Admission No.||Gender - Code||Date of Birth||Reg. Group||Year||Unique Pupil Number (UPN)||Ethnicity||Eligible for free meals||Class Details - Class|
|Gemma||Atkins||01046||F||09/07/85||H||11||J811288197017||White - British||T||Te-11-X5|
|Gemma||Atkins||01046||F||09/07/85||H||11||J811288197017||White - British||T||Ma-11-X5|
|Gemma||Atkins||01046||F||09/07/85||H||11||J811288197017||White - British||T||En-11-X5|
|Gemma||Atkins||01046||F||09/07/85||H||11||J811288197017||White - British||T||Ge-11-X5|
|Justin||Phillips||03264||M||25/06/89||D||7||Y810288197028||Black - African||F||En-07-B4|
|Justin||Phillips||03264||M||25/06/89||D||7||Y810288197028||Black - African||F||Ar-07-B3|
|Justin||Phillips||03264||M||25/06/89||D||7||Y810288197028||Black - African||F||Fr-07-C1|
Please Note: Each learner will be listed a number of times, once for each class.
Do not use spaces, punctuation marks or special characters such as commas or full stops.
Do not merge two fields into one column, e.g. Forename and Surname.
It is possible to enter learners' initials in the Forename and Surname fields, rather than their full names. We advise against this, however, as it makes it difficult to update Learner Accounts and makes Progress Reports unusable.
Disadvantaged Fields are optional (Pupil Premium, FSM, EAL, etc.). If these are filled in, the data must display as 'T' for 'True' or 'F' for 'False'.
It is possible to assign a learner's gender as "Undefined", if they do not wish to be identified as Male or Female.
When you have created the learner data file, save it either in Excel or CSV format (tab delimited) and log in using your SAM Learning Admin account details. Select the 'Learners' tab and click on the 'Import Learners' link.
This will open a web form where you can upload the data through our secure server. You will receive confirmation once this has been done. You will then receive another email once the data has been checked and uploaded into your SAM Learning school account.
Download the data upload spreadsheet template found below.