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. 

Because you have more than 30 logins — bypass this popup.

The popup shown to the right allows users to enter 30 or fewer logins.  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.

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

[If you have 0 in the orange 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 turquoise Import button (black arrow points it out in the picture above) that says:

+ Import Students Logins From CSV

 

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  make up a username and a passcode 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  make up 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.

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 as a CSV file (it’s an excel file now, so you have to choose Save As and find CSV (Comma delimited) in the list).   See what that looks like to the right. If you don’t choose SAVE AS and select CSV (Comma delimited) 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 the CSV 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.

Step 4.

Scroll to the bottom and hit 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!  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 *