Teaching Online at UTAS

If you use the Groups tool to organise groups of students in your MyLO site, you may find it helpful to download a spreadsheet listing the students  and the Groups they are members of. Here’s how.

Step 1

Select the Grades tool from the MyLO Toolbar.

Step 2

Select the Export button. This appears towards the top left of the Grades tool when in Enter Grades view.

Step 3

Now select whether you wish to include All Users (students) enrolled in the MyLO site in your spreadsheet, or specify only a certain group of students to appear in the spreadsheet. For example, you may only want to see students in a particular study mode, studying at a particular campus or enrolled in a particular unit code. If you want all users included, skip to Step 4.

If you wish to select a specific Group of students:

• select Groups from the dropdown menu, then the Apply button;

  

• select the Group you wish to view from the dropdown menu (only one can be selected), then select Apply again.

Step 4

You can now choose the fields you wish to include in the export. Under Key field, leave the Org Defined ID option selected. Uncheck all the Grade Value options. Under User Details, check the Last Name, First Name and Group Membership fields checked.

Step 5

You won’t need any of the Choose Grades to Export options. The quickest way to deselect them all is to select the checkbox at the top of the list, then deselect it again (this selects all, then deselects all).

Step 6

Select the Export to Excel button that appears at the bottom of the screen.

A pop up window will appear as your spreadsheet is generated. The file will eventually appear. Select the file name to download it. The final name will normally include your unit code and name.

The resulting Excel spreadsheet will include your students on the left (one row per students), with each Group Category listed as a column header. An example is provided below.