3P Rollover

Need some help with Rollover?

Make sure all your students are in the correct classes for the new year. Let us step you through.

Select a product category

How to Rollover

Videos

 

Mathletics Rollover Video

 

Excel Help Video

Download Rollover Guide A4
Download Rollover Guide USL

Download your Rollover Spreadsheet

There are two ways to complete your spreadsheet for the new year:

Option 1 – Download your spreadsheet

  • Sign into your school’s Administration Console
  • Select ‘Rollover’ from the menu on the left hand side
  • Download your previous year’s school roll, you can choose to include or exclude unassigned students

If you have forgotten your admin login, please contact us at customerservice@3plearning.com

Option 2 – Use your school database

You’re welcome to use your own school database for Rollover, you’ll simply need to update the formatting to ensure it matches with our system.

  • Download a blank student upload template.
  • One column at a time, copy and paste the data from your school database into the spreadsheet template.
  • Please take extra care to make sure that names are entered the same way as they’re currently listed in Mathletics – otherwise new student accounts will be created
  • Save your updated spreadsheet to your computer as an .xlsx file.
  • Head to ‘Upload File’ (you won’t need to complete ‘Update student & teacher details’)

Update student & teacher details

NOTE: To retain student usernames and data, do not alter existing student names. 

  • Download your current school roll and update the spreadsheets to reflect your new school list.
  • Do not delete any columns on the spreadsheet.
  • Do not change the spelling of a student name in the download as that will create a new student record/login. You can alter a student name later.
  • Update year groups, classes and teacher information as required.
  • If a student is no longer attending your school, delete the entire row.
  • Save your updated spreadsheet to your computer as an .xlsx file.
  • Please note:
    • Students with identical names must be identified with a unique character eg. John B Smith or John Smith1.
    • During the Rollover process, a student can only be in one class. After Rollover, Teachers may copy students into other classes based on ability.
    • Teachers can share a class. Simply ensure that each Teacher appears on the spreadsheet next to the shared class at least once.
    • To retain student usernames and data, do not alter existing student names. Corrections can be made in the Administration Console after Rollover.

Upload your updated spreadsheet

  • When you have your updated spreadsheet ready to process click ‘Next’
  • Select your rollover type; Partial Rollover or Full Rollover and click ‘Next’. Each option will be explained on-screen, however we strongly recommend completing a Full Rollover
  • Click the ‘Upload file’ button and select your updated spreadsheet. Your data will appear on-screen, select ‘Confirm’
  • If there are any errors your file, the system will tell you what the errors are and which row to find them in
  • To download sign-in cards for new and updated students, click the ‘View Summary’ button. You can either download sign-in cards or export your student list as an excel file.

How to Rollover

Videos

 

Readiwriter Rollover Video

 

Excel Help Video

Download Rollover Guide A4

Download your Rollover Spreadsheet

There are two ways to complete your spreadsheet for the new year:

Option 1 – Download your spreadsheet

  • Sign into your school’s Administration Console
  • Select ‘Rollover’ from the menu on the left hand side
  • Download your previous year’s school roll, you can choose to include or exclude unassigned students

If you have forgotten your admin login, please contact us at customerservice@3plearning.com

Option 2 – Use your school database

You’re welcome to use your own school database for Rollover, you’ll simply need to update the formatting to ensure it matches with our system.

  • Download a blank student upload template.
  • One column at a time, copy and paste the data from your school database into the spreadsheet template.
  • Please take extra care to make sure that names are entered the same way as they’re currently listed in Readiwriter – otherwise new student accounts will be created
  • Save your updated spreadsheet to your computer as an .xlsx file.
  • Head to ‘Upload your updated Spreadsheet’ (you won’t need to complete ‘Update student & teacher details’)

Update student & teacher details

NOTE: To retain student usernames and data, do not alter existing student names. 

  • Download your current school roll and update the spreadsheets to reflect your new school list.
  • Do not delete any columns on the spreadsheet.
  • Do not change the spelling of a student name in the download as that will create a new student record/login. You can alter a student name later.
  • Update year groups, classes and teacher information as required.
  • If a student is no longer attending your school, delete the entire row.
  • Save your updated spreadsheet to your computer as an .xlsx file.
  • Please note:
    • Students with identical names must be identified with a unique character eg. John B Smith or John Smith1.
    • During the Rollover process, a student can only be in one class. After Rollover, Teachers may copy students into other classes based on ability.
    • Teachers can share a class. Simply ensure that each Teacher appears on the spreadsheet next to the shared class at least once.
    • To retain student usernames and data, do not alter existing student names. Corrections can be made in the Administration Console after Rollover.

Upload your updated spreadsheet

  • When you have your updated spreadsheet ready to process click ‘Next’
  • Select your rollover type; Partial Rollover or Full Rollover and click ‘Next’. Each option will be explained on-screen, however we strongly recommend completing a Full Rollover
  • Click the ‘Upload file’ button and select your updated spreadsheet. Your data will appear on-screen, select ‘Confirm’
  • If there are any errors your file, the system will tell you what the errors are and which row to find them in
  • To download sign-in cards for new and updated students, click the ‘View Summary’ button. You can either download sign-in cards or export your student list as an excel file.

How to Rollover

If you have both Reading Eggs and Mathseeds, please complete your Reading Eggs rollover first. Once you have completed your Reading Eggs rollover, your new students will be assigned a student id. You will need to use the newly created student id’s for your Mathseeds rollover.

When completing your Mathseeds rollover please use one of the following options when preparing your excel file.

  • Option 1. Use the downloaded excel file and add teachers emails
  • Option 2. Use the reading Eggs spreadsheet you added email addresses to and add the ID numbers allocated to all new students

We’ve put these detailed videos below outlining

 

Reading Eggs Rollover Video

 

Mathseeds Rollover Video

Once you have uploaded your Mathseeds rollover spreadsheet, the next step is to delete any students who have left the school or no longer need access to the programs.

Download Rollover Guide

Deleting unassigned students

  • Sign into your Reading Eggs or Mathseeds Admin Console
  • You may have inactive students on your school roll who left the school in previous years. To make it easier to re-assign students for the new year, we recommend deleting accounts of students who were already unassigned last year and will not be using the program this year.

Note: This step should only be done either before activating the rollover OR after ALL students have been reassigned to their new classes

Delete Students:

  • Click Management and Manage Studentsfilter the page to only show unallocated students
  •  Tick the Select all box in the table header to select all unallocated students, click More actions and select Delete students permanently.

Adding new teachers

  • Please ensure you add any new teachers at the school BEFORE you click the Activate Rollover button.

Add Teachers:

  • Click Management and Manage Teachers 
  • Check the list of existing teachers and delete teachers who have left the school or no longer require access
  • Add new teachers one at a time by filling in the fields at the top of the page

Clever

(US/Canada customers only)

For non-Clever schools/districts the start of a new school year requires the subscription coordinator at each school to use the Manage Rollover function in Mathseeds to increment student grades and move students out of their current classes.

For Clever schools/districts all teachers and student data changes are made within Clever and thus the Manage Rollover function is not available to subscription coordinators.

Prior to the commencement of the new school year Clever districts should:

  • Ensure the schools in the district have current subscriptions with sufficient capacity for the number of students who will be using Mathseeds at the school in the new school year. Talk to your Mathseeds support team to organise your subscriptions.
  • For any new schools in the district ask your Mathseeds support team to create a new school account in Mathseeds.
  • Ensure teacher, student and class/section data is up-to-date in Clever and that all the required data is available to be shared with Mathseeds.
  • To align the district data in Mathseeds with the data in Clever:
    • Use the Reset function to download the latest Clever data into Mathseeds.
    • Complete all new school, teacher and student matches for each school in the district – all previously matched teacher and student records will match automatically.
    • Use the Sync Schools function to sync the Clever and Admin data for the district.
    • Note: For Districts using both Mathseeds and Reading Eggs the Reset/Match/Sync process should be performed for each product but for only one product at a time. The process must be completed for one product before it can be started for the other product. This can be achieved by coordination between your Mathseeds and Reading Eggs support teams.

This step is not mandatory but is recommended by Clever to ensure the best chance for a smooth data transition into the new school year. Any problems reported to Clever will require that the district is reset, matched & synced before they are investigated further.

How to Rollover

Download Rollover Guide A4

Removing old students

Note: Rollover can only be actioned from your school’s WordFlyers Subscription Coordinator’s account.

  1. Go to My School and select Students.
  2. Use the search bar to find the students you wish to remove and tick the checkbox beside their name to select them.
  3. Select Delete to remove these students.

Updating existing teachers

  1. Go to My School and select Rollover.
  2. Select Download existing students to download your school’s existing WordFlyers students. Save this .csv file to your computer.
  3. Open the file and populate the empty columns (J, K, L, M) for students who will be using WordFlyers in the new school year. Save the file.

Adding new students

Note: These can be Year 7 students or any student not already in WordFlyers.

  1. In your Rollover area, select Download new student template. Save this .csv file to your computer.
  2. Open the file and populate the columns (A – G) with each new student’s details. Save the file.

Activating Rollover

  1. Go back to the Rollover area under My School on your Subscription Coordinator Dashboard.
  2. Upload your current student list and new student list and select Submit.

You will receive an email from the WordFlyers team once your school’s rollover has been completed.

Videos

 

Activating Rollover

Mathletics FAQs

Yes! We encourage schools to complete your own Rollover as soon as possible. The process itself is relatively quick and there are no delays in getting up and running for the academic year.

No, to ensure a quick and successful Rollover please complete a whole school Rollover. Contact your Account Manager if you require some of your year groups to be updated but not all. Any students that are missing will be in the ‘unassigned’ area.

No, names must remain unchanged for an accurate match allowing students to retain results and usernames. Where names are changed new student accounts will be created. Corrections and changes can be made in the Admin Console after Rollover.

Students with the same name need a unique character to differentiate them eg, John Smith1 or John B Smith.

Yes, but only after Rollover. A student can be copied to appear in two or more classes from within the Teacher Console.

Yes, Teachers can share a class. Simply ensure that each Teacher appears on the spreadsheet beside their class at least once.

Throughout the year we will communicate important information around training options, product releases and major events.

The spreadsheets are prepared in Excel 2007 which is a Windows product. Mac users require Office for Mac 2008 or higher. Please contact us if you are having difficulty opening or saving your spreadsheet.

The deadline is September 30th, 2019, however the sooner you complete your rollover, the sooner your students and teachers will be able to access their new classes.

All student data has been archived for Mathletics. Before you complete your rollover, you may decide to ‘Extend Results’, to keep gold bars and results from last year. This does not affect students’ certificates, points, avatar, Live Mathletics statistics and credits, provided the existing students’ names have not been changed Eg, Sam to Samantha.
In order to retrieve data from last year, go to your Admin Console and click on ‘Extend Results’ in the rollover tab.

Yes, in fact we encourage you to monitor student enrolment. Add new students via the ‘School Roll’ in the Administration Console.

Yes, after rollover you can transfer a student’s Mathletics and Spellodrome account from their previous school. To transfer via the Administration Console you will require the student username and an exact name match to be successful. This will transfer their avatar, credit points and username.

Your students may have received a new username. Check student details in the School Roll including ‘Unassigned Students’. You can reinstate the original username here and delete the new one so your student numbers don’t exceed your cap.