Skip to end of metadata
Go to start of metadata


Overview

At the beginning of the semester, you can get details about who’s in your class by reviewing, printing, or downloading a student roster. The roster is formatted so that it can be easily imported into Excel, where you can record and track your students’ work.

This tutorial has two parts:

  • First, we’ll give you an orientation to the roster page and show you how to locate, print, and download the student roster for each of your online classes.
  • Second, we’ll show you how to import your roster into Excel.

The Roster Page

The Roster Page

The Roster Page

At the beginning of the semester, you can get details about who’s in your class by reviewing, printing, or downloading a student roster.

The roster is formatted so that it can be easily imported into   or Easy Grade Pro, where you can record and track your students’ work. Let’s look at how this can be done.

From inside your class, just click the Roster link here on the toolbar.

When you first open this page, you’ll see your own profile. The names of all your students are listed here on the left, and if you click a name, you can see that student’s profile.

The list view is the default layout for a roster, but you can also choose to display this information in a grid layout by clicking this icon. This page lets you see everyone in your class at once. For each student, you’ll note that there are links to a profile—and a portfolio, if one has been created. Clicking the colored dot next to a student’s name shows you their “Student Pulse” information—which we’ll discuss in greater detail later in this training.

You’ll find a link for sending a message to the student, using the mailbox tool. And notice that there’s also a button here that lets you send a message to your entire class at once.

From the roster page, you can also review progress information for any student. Click the “Progress Report” link under a student’s name to see this information.

The dock at the top of the page lets you customize the report to show the specific information that interests you.

From the Roster page, you can review, print, or download a roster that lists key information for all your students—the links are here.

  • Click the printer icon to open the roster in a new tab or window. This page is formatted for printing. You can use your browser menu to print a hard copy of this page.
  •  To download a CSV file of your roster information, which you can then import into Excel or Easy Grade Pro, click the download link, here, and save the file to your computer.

 Importing Rosters into Excel  |  top of page

Importing Rosters into Excel

Importing Rosters into Excel

Once you’ve got your roster file downloaded to your computer, one option is to open the file in Excel, so you can work with it there.

Begin by opening Excel and then click the link to open an existing file.

When the dialogue box opens, click the arrow to open the drop-down menu under “files of type” and select “all files.” This will show you all the files in your chosen directory.

Next, since I saved my roster file on my desktop, I need to navigate there to find it. I scroll down the page, and here it is. Now I just select the file and click “open.”

Because the file I’m working with is not an Excel file, the computer automatically opens a wizard so I can make sure Excel sets the file up properly. On the first page, make sure the radio button for “delimited” is selected—this should happen automatically. Then click “next.”

In the second window, check to make sure that the “Tab” box is checked under “Delimiters.” Click “Next” to see the final page.

Here, you’ll see that the default Column data format is “General.” We need to change this to “text.” So first select all the columns in the “data preview” area, and then click the “text” button under Column data format.

You’ll see that the data format has changed to text. Now click “Finish” to see your new file, with the categories displayed in the first row, and all your student information listed below. Now you can reformat this spreadsheet, list your various assignments, record students’ scores, and calculate grades.

When you’re done  working, it’s important to  remember to save your document in Excel format, so that you preserve all your work. Right now, this suffix shows me that my file is still in text format. To save it as an Excel workbook, I open my file menu and choose “Save as.” Then I select “Excel workbook”—which is the default Excel format—and I click “Save.”

Now my document is in Excel format, and all my data and formulas will be preserved. Any time I open this file in the future, I'll be working with an Excel document.   



  • No labels