Step 1: Open the ‘MarvellousMe New School Setup Data File’ Excel file and save it to your desktop, or other folder
Resize the column widths so that you can read the column headers. Please do not change the column headers.
Step 2: Add details for the staff
Type the name and email address for all staff that will be using MarvellousMe into columns A and B. Once the file is uploaded, a ‘Teacher’ account will automatically be created for them.
Step 3: Collate the pupil data from your MIS for all the children you want to be active in MarvellousMe.
You will need to run a report on your school’s MIS for the whole school with these filters / data columns, in this order:
- Child forename and surname*
- UPN
- Reg Group
*If your MIS reports the pupil’s names in a different format, please use our Name Configurator to reformat them correctly for MarvellousMe. There is also a video guide for this or contact us for help.
Sort your report by Reg Group, either in the MIS system or in your output file.
Output the report from your MIS to Excel.
Copy and paste all the details into columns C, D and E of your data file.
Save your file.
Step 4: Assign the main teacher for each class (Column F)
Copy the email address of just the main class teacher from column B and paste it into column F next to the name of their appropriate Reg Group.
Click and drag to copy this down the list until the end of the group so the same teacher’s email shows next to all the pupils in their class.
You can assign additional staff (e.g. the second teacher in a job share, school leaders, specialist subject teachers) to the their groups after the data file has been uploaded.
Step 5: Run through the following checklist
- Have you listed all the staff you want to use MarvellousMe?
- Have you included all pupils at the school? (New pupils can be added later if you don’t have their details yet).
- Have you shown each child’s first and last name correctly, both together in column C?
- Does each child have a UPN? If not, you will need to add them manually when they do.
- Have your sorted by Reg. Group?
- Have you added one email for the main teacher next to each child’s Reg Group?
- Have you left the column headers unchanged?
Once you have completed the checklist, please save your file.
Step 6: Securely* send your completed data file to support.mme@junipereducation.org
We will confirm receipt, upload the data into your MarvellousMe account and then contact you to arrange the next steps.
*We recommend using WeTransfer, a free service that encrypts your files when they are transferred (TLS) and when they are stored (AES-256). Alternatively, save the spreadsheet as an Excel file (not .csv), password-protect it and send it via email to support.mme@junipereducation.org.
Updated