Tutorial Tuesday – Uploading a Class Using a CSV File

This Tutorial Tuesday will focus on how to best use the new File Class Upload on Edcite! Before we get into the details, we are thankful to the many teachers who suggested this as a helpful feature. It is the feedback from teachers that helps us make Edcite an even better resource!

What is the File Class Upload for?

This is the third method of adding students to a class (the other two are the class code and manually adding each student). The File Upload is useful if your students might struggle with using the class code or if you want to have a lot of control over student usernames. It is also a timesaver if you are manually uploading students because you can do it all at once. In the future, it will also be a great way for Technology specialists to upload multiple classes at once. 

How to create a File to upload a class:

  1. Use the template that we have provided and fill it in with student info
  2. Create your own CSV file using Powerschool (see linked PDF for steps)
  3. Create your own Excel spreadsheet using the headers shown below (in the same order), fill in student information. Make sure you save your excel spreadsheet as a CSV using the “Save As” option.

Example:

F Name L Name Student email (optional) Student UserID Activation Password
Brian McIntosh bmcintosh@gatewayhigh.org bmcintosh18 algebra1

Tips for filling in student data:

Student First Name Student Last Name Student Email (optional) Student UserID Activation Password
Use the same name as in your gradebook to save time. Use the same name as in your gradebook to save time. 1. Elementary schoolers may not yet have emails.

2. If they do have email, it is a good way to notify them when you send an assignment. Use school emails when possible.

1. This will be their permanent login

2. Tip: use a pattern for all usernames so that you can remind students if they forget (1st initial, last name, grad year)

1. Make it simple, students can change it upon login

2. Use different passwords w/ older students to prevent sign-ins into wrong accounts

How to Upload your finished CSV file:

Step 1: From the teacher homepage choose the “Classes” tab and choose “My Students” 

Screen Shot 2015-01-04 at 2.44.47 PM

Step 2: Find the class that you want to add students to. Note: If you haven’t yet created a class, see this document on how to create a class.

 You will know you have selected the class because its name will be highlighted in yellow (see below).  Click on the button that says “Upload Students” (in red below).

Screen Shot 2015-01-04 at 2.49.55 PM

Step 3: Click on “Upload File” and select your CSV file. If it doesn’t work, make sure you have the file saved as a CSV file type.
Screen Shot 2015-01-04 at 2.56.06 PM

Step 4: Check your student list to make sure it looks accurate. If it is accurate, click on “Add Students to Class” to finalize the upload of students!

Screen Shot 2015-01-04 at 2.57.30 PM Note: If some students come up in red (see red rows below), it means that their username is already in the system. You can still add them to your class by clicking on the “Add Students to Class” button.  If you get a message that says “Student Email Already used by [username]” (see green row below) then it will not add the student to your class because they are already signed up with a different UserID. To fix this, just change the UserID for that student or get rid of the student email.

Screen Shot 2015-01-06 at 1.24.06 PM

Step 5: Print a copy of the file for your records in case students forget their usernames.

 I hope this Tutorial Tuesday was helpful and stay posted for another one on in two weeks!

3 thoughts on “Tutorial Tuesday – Uploading a Class Using a CSV File

    1. Liz – we will reach out to you by email and help with this request.

      Edcite allows teachers to export student data (scores on assignments) into a CSV file which can then be imported into other applications like Powerschool.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s