Student activity report
The student activity report contains a rich set of data that you can use to supercharge the use of Sparx Maths in your school. It can be downloaded via Reporting > Downloadable Reports.
You can build a report for the data and timeframe that you're interested in
When you click Create report, you'll be asked to choose the categories of data that you want to include, and the timeframe for which you wish to generate the report (defaults to the current academic year).
Data categories explained
All reports contain a set of default data
We'll always include each student's first name, surname, class, year group and registration group in the report.
We'll also include data about students' Compulsory, XP Boost and Target homework completion both weekly and in aggregate for your selected timeframe. We'll also include each student's Homework Difficulty Level, and the homework type and default homework length that's set for them, and for each weekly homework we'll include the date and time at which they completed their homework.
You can optionally include rewards data
If you select the rewards data category, we'll include data about the XP that students have earned both weekly and in aggregate for your selected timeframe. In aggregate, we'll include a breakdown of XP earned, so you can see whether they've earned it via their compulsory or optional homework, or via Independent Learning. We'll also include data about students' Sparx Maths reward levels.
You can optionally include additional student data
If you select the additional student data category, we'll include the following data in the report:
- PP*: Shows whether the student is in receipt of Pupil Premium (Y) or not (N). '-' means that we weren't able to retrieve this data for the student.
- FSM*: Shows whether the student is in receipt of Free School Meals (Y) or not (N). '-' means that we weren't able to retrieve this data for the student.
- EAL*: Shows whether the student uses English as an Additional Language (Y) or not (N). '-' means that we weren't able to retrieve this data for the student.
- Gender: Shows the student's gender as Male (M), Female (F) or Other (O). '-' means that we weren't able to retrieve this data for the student.
* these data can only be included when:
- Your school uses MIS integration (we retrieve this data from your school's MIS)
- Your school's Wonde administrator has granted Sparx access to this data (if we've been granted access to some, but not all data, we'll include the data that we're able to)
We don't include SEND data in the report. The Information Commissioner's Office (ICO) consider such data to be 'special category data', which needs more protection than other categories of data.
To retrieve this data from your school's MIS, store it in our databases and display it in your Sparx Maths site and any related reporting, we would have to demonstrate a significant need, and we'd need to ask all schools to agree to updated privacy terms.
You can optionally include teacher names
If you select the teacher names category, we'll include the name(s) of any teachers associated with a class, where we list classes.
How to interpret the report
Aggregate vs. weekly data
Data under the Data for date range section of the report are aggregated across your chosen date range. We'll include homework data for the full weeks that encompass your selected dates.
Data under the Week <number> sections of the report are grouped relevant to the week in which the homework was handed out.
Understanding homework completion data
Data for date range
- Compulsory % (on-time): The % of compulsory homeworks set for the student that were 100% complete by the homework due date/time.
- Compulsory % (all-time): The % of compulsory homeworks set for the student that are 100% complete now.
- Compulsory % (average): The average completion % for all compulsory homeworks set for the student (regardless of whether or not they are 100% complete).
- XP Boost %: The % of {{glossary.XP Boost}} homeworks set for the student that are 100% complete now.
- Target %: The % of {{glossary.Target}} homeworks set for the student that are 100% complete now.
Weekly data
- Total IL: The total amount of time that the student spent completing questions in Independent Learning during this week.
- C(OT): The % of this week's compulsory homework that the student completed by the homework due date/time.
- C(AT):The % of this week's compulsory homework that the student has completed.
- XPB: The % of this week's XP Boost homework that the student has completed.
- T: The % of this week's Target homework that the student has completed.
- XP: The amount of XP that the student earned this week (considers all homework types and Independent Learning).
Note that if a student has attempted questions but got them all incorrect, their completion will show as 0%.
If you're cross-referencing the report against 'non-starter' insights on the Department Dashboard or in the weekly emails that we send to Senior Leaders, Heads of Department and Sparx Leaders, bear in mind that these insights exclude students that have attempted questions but got them all incorrect.
Your spreadsheet software may display rounded data
If you notice discrepancies between weekly and aggregate data, this is likely to be due to rounding. If you click on individual numbers in the report, you'll be able to see that original (non-rounded) numbers.
Data are also aggregated by class, registration group and year group
Most data available under the By student tab of the report are also available aggregated by class, registration group and year group. See the corresponding tabs of the report.
Getting the most out of the student activity report
- Finding out which students in a group didn’t finish their homework on time for the last few weeks
- Getting a ranked list of students, classes, or year groups by compulsory completion rates
- Filtering the report to zone in on the data that you need