Tips and Tricks with Reports

userEducator & Xello Admin Xello productXello 6-12 Time5 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 customized 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.

"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.

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.

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. From the top of the page, ensure the correct grade range is selected: Grades 6-12 or Grades 3-5.
  3. Find Saved Careers and click Select Report.
  4. Click Saved Careers.
  5. From the list, select a career to see all the students who saved it.
  6. From the top of the list, click Add to Group and select Create New Group.
  7. Give the group a name, and click Create.

Data & Export

A quick hint about a feature that works similarly to the Reports tool under Features but is spread throughout your Educator Account: the Data & Export 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 & Export 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.