Tips and Tricks with Reports

userEducator & Xello AdminTime5 minutes

Xello's powerful Reports tool helps you easily and quickly run accurate reports on a wide range of features and activities - from student logins, to how many students have completed their assessments, to which suggested career is the most popular.

Filter

Xello has dynamic filters, so from any list or report, you can narrow your results through the Filter button in the top right corner. Filters combine different criteria to find exactly what you're looking for. The filters available are customised to the list or report you're viewing.

A report can be run to include an entire school population, or a small group with only a handful of students.

Click to enlarge
Click to enlarge

"By student" reports

When you choose a "by Student" report (for example, Suggested careers by student, or Saved schools by student), by default the report is filtered by students who have completed the necessary work. To remove this filter or to view the students who have not yet completed the work, click Filters, and next to Activity completion, select which data you'd like to view.

Filters menu open with the filters "Students with assessment results" and "Students without assessment results" selected
Click to enlarge
Filters menu open with the filters "Students with assessment results" and "Students without assessment results" selected

Sort your lists

Easily view the data in the order most important to you. From the top of any table, click a column heading to sort the table by that column.

Filters menu open with the filters "Students with assessment results" and "Students without assessment results" selected
Click to enlarge
Filters menu open with the filters "Students with assessment results" and "Students without assessment results" selected

Create groups from reports

Improve engagement and interaction with your students by grouping them based on their interests, saved careers, Lesson completion, or anything else you've discovered nestled in the data. Create and edit an assignment or Add a Dashboard resource specific to that group.

For example:

  1. From your educator account, click Reports and select Student work.
    left menu open in educator account. Report dropdown open and Student work being selected
    Click to enlarge
    left menu open in educator account. Report dropdown open and Student work being selected
  2. Find Saved careers and click Select report.
  3. Click Saved careers.
  4. From the list, select a career to see all the students who saved it.
  5. From the top of the list, click Add to group and select Create new group.
  6. Give the group a name, and click Create.

Data options

A quick hint about a feature that works similarly to the Reports tool under Features but is spread throughout your educator account: the Data options tool. Use this tool to export almost any list in Xello to a spreadsheet that's exported to your computer for you to view and manage.

To export a list to a spreadsheet or .csv file:

  1. In your educator account, from the top of nearly every list, click Data options to open a dropdown.
    filter and export buttons on report page
    Click to enlarge
  2. From the dropdown, click the checkbox of each table column you would like to include.
  3. From the bottom of the dropdown, under the Export data section, click the Excel button to export it to an Excel spreadsheet, or click the CSV button to export it to a .csv file.
arrow upBack to top