3.D) How to assign student logins to more than 30 seats with a CSV file

First–Have you set up Teacher Mgrs?

If you have more than one classroom of students, you will need to assign them to Teacher Mgrs.  So you first need to Add Teacher Mgrs to the account.  Please read and follow the directions about How to Add More Teacher Mgrs to your account BEFORE you start to assign login information to students. 

Why not delegate?

If you have Teacher Mgrs, you can delegate the creation of logins to your teacher mgrs, once you have created them. They can each go to admin.rocketmath.com  login to their account and see the popup.  They can then put in up to 30 student logins on their own.  The usernames have to be unique to your school, but if they use a nickname and a number it should not be hard.  As the owner of the account, you’ll still be able to see all the students and review their progress, but you don’t have to enter all the logins yourself.

If you are going to do more than 30 logins — click outside the popup to bypass it.

The popup shown allows owners or Teacher Mgrs to enter up to 30 logins at a time.  It says you’ll need to use the “+Import Student Logins from CSV” which is hidden from view.  (Are we trying to be difficult?)  Just click outside of the popup and you will see the dashboard.  There you can see the Import Student Logins as in the picture below.

 

Next: Assign Logins to many seats at once–follow the 4 steps below.

For owners the orange box on your dashboard shows the number “Unassigned Seats” you have that can be assigned to students. 

For Teacher Mgrs, the blue box shows the number of “Available seats”–available for you to assign to students by setting up logins.

[If you have 0 in the box, you have not set up seats in your account.  You have to have seats in your account before you can assign logins to them.  If you haven’t set up seats, see the place to do that on the pop-up that says “Welcome to the Free Trial.” See  step 2A) in the directions here: https://www.rocketmath.com/rocket-math-faqs/how-to-set-up-your-30-day-free-trial/ ]

Give the Unassigned seats to students by clicking the + Import Students Logins From CSV button (turquoise?) (black arrow points it out in the picture above).


 

You will see this pop-up page labeled

Import Student Logins From CSV

looks like this picture to the left.

 

 

 

Step 1.

Begin at #1 click on “Excel template to fill in and then SAVE AS Comma-separated value (CSV)” and click it to get the latest, and most properly formatted template for starting your student file. (Please, you must start with that template and fill in the fields and then save with your name. The system is expecting these headings. Don’t just make up your own file because it won’t work!)

See the blank Excel template to the right.

Username.  You’ll  create a username for each student. We do not want to collect personally identifiable information on your students, so we don’t want their actual names.  But make sure you know who goes to which username.  Only you need to know, we don’t.   *** See note below.

Passcode.  You’ll  create a passcode for each student.

Learning Track code.  Enter the code number, and only the code number (1 through 10), for the Learning Track they will start in. You can change it at any time. Click here for the directions page about Learning Tracks if you need help deciding.

Teacher Mgr email.  You are the default Teacher Mgr so if you leave this blank the students will all be assigned to you the account owner.  Add the Teacher Mgr’s email address only if you wish to connect the student to a Teacher Mgr other than yourself.  CAREFUL! It needs to be a Teacher Mgr that you have already set up in your account. If you try to import with Teacher names rather than emails or if a single one of those emails is not in the system the same way–the import will not work!

Class name.  This is a future plan for schools in which teachers have multiple classes.  Leave it blank for now.

 

Once you have completed the file, use SAVE AS to save it to your computer in the format of a CSV file (it’s an excel file now, so you have to choose Save As and from the file types find and choose CSV (Comma delimited) in the list).   See what that looks like to the right. If it still has dot xlsx appended to the end of the file name then you didn’t save it in the CSV format.  If you don’t choose SAVE AS and select CSV (Comma delimited) as the file format then your file won’t import.

Be sure to save the file somewhere you can find again, because you’ll need it again in the next step. 

 

 

Step 2.

Now go back to the pop-up page labeled “Import Student Logins From CSV.” See it to the right and do #2 “Choose file”

Browse to your file saved in the CSV format (it will have dot csv appended to the name of your file) you just saved on your computer and select it.  Now the name of the file should show up in this box.

Step 3.

Then go to the bottom of the page and hit the blue button at #3 that saysParse CSV.”

After you hit “Parse CSV” you’ll see a list of your students if this is working for you.

Step 4.

Scroll to the bottom of the list of your students and click on the blue button that says “Import Students.” Then they will be set up in the system.

If something goes wrong, use the red button on your Dashboard that says “Delete ALL students!” It is extreme.  Do NOT do this if some classes have started working!  Do not do this if you have already merged some teachers and their students into your account.  Delete All Students will clear out ALL of your student data, allowing you to start over and re-import.

If you have a bunch of trouble, Delete All students! and send me your CSV file and I will do the import for you. But don’t do that until you have saved it as a CSV file. -Dr.Don

 

***BE KIND.  Your students have to enter the username, passcode and Account number every time they login to play.  So be kind and make these short, easy to remember, and easy to type in.  Initials or nickname for username,  a short word or 4 digits for a passcode.

***You can create and keep a copy of the file with the students’ names, but you can’t import it.  Here’s how:

  1. Upload the blank template onto your computer.
  2. Add a column at the left of the columns that are on the template and label it student names.
  3. Fill out names and usernames and passcodes and Learn Track codes and Teacher Mgr email addresses.
  4. Save a copy of this “with names” file on your computer for use in the school to share with teachers, etc.
  5. Open a copy and delete the first lefthand column with student names and save as CSV (comma delimited) “without names.”
  6. Use that “without names” copy to import into our system.  Now you have both.
This entry was posted in . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *