How to get help with LEO
- See the full list of LEO help available from this link.
- Moodle's online documentation for technical information and some pedagogical advice on managing your units.
- LEO Support for telephone or email-based LEO technical support.
- IT Service Desk for help with Lecture Capture (Echo 360) and desktop software (such as Excel or Photoshop).
- Faculties-based help and support.
- eLearning 101 web page for regular interactive webinars on a range of technology enhanced learning topics. The recordings of previous webinars can also be accessed from this link.
- LEO professional development workshops for information on a series of face-to-face workshops before the start of semester one.
- Feedback form or email eLearning.LTC@acu.edu.au directly to request a workshop for five or more participants.
- Learning and Teaching website or the Learning and Teaching Contacts page for learning and teaching help that is not directly technology related (such as assessment, curriculum, evaluation or awards).
Marks can be imported directly into the gradebook via a spreadsheet.
Before this can happen the spreadsheet needs to be formatted correctly and there needs to be a column which uniquely defines the students in the unit. Those items that are unique to each student are username, email address and LEO ID number. You cannot import marks based on name.
The best way to ensure the correct format and include a unique key, is to first export a spreadsheet from the gradebook.
Exporting a spreadsheet to manually enter grades
- From Grades > Export > Excel spreadsheet, tick just the one manual assessment item you would like to manually grade.
- Expand the 'Export format options' section.
- If you will be providing written feedback on the assessment, tick the 'Include feedback in export' checkbox.
- In most cases you will be importing the raw mark (whatever format you display to students) so tick the 'Real' checkbox only in 'Grade export display types'.
- Click the 'Download' button.
Importing manual grades from a spreadsheet
Once you have filled your spreadsheet with the marks and/or feedback comments, it is time to import them into gradebook.
From Grades > Import there are two main choices - either to import as a CSV file, or copy and paste directly from an open spreadsheet on your computer. Either is fine.
- A CSV file would be more appropriate if there are a large number students and the spreadsheet has many rows. Before you can import, you will need to save your spreadsheet in the CSV format.
- Copying and pasting is fine and probably easier if the number of students is small.
- Once you have selected your CSV, or pasted in your data, click the 'Upload grades' button.
- LEO needs to identify which student relates to which row in the spreadsheet. In the 'Identify user by' section, select the column header from your spreadsheet and the type of unique key in LEO that it will map to. For example, email address or ID number.
- In the 'Grade item mappings' section, use the drop down menus to determine which columns in the spreadsheet relate to which gradebook items. Keep the drop down value as 'Ignore' for those columns that do not relate to grade items.
- Click the 'Upload grades' button.
Page last updated: 2017-06-27
Short url: http://www.acu.edu.au/1098738