Exporting Gap Analysis - Pro Tip

Exporting Gap Analysis - Pro Tip

Sometimes you may need to print off Gap Analysis for a whole year group, or class, and there will be too much information to fit onto a screengrab or pdf.

In these circumstances use this Pro Tip to convert any Gap Analysis selection into a formatted excel file.

This video (4 minutes) shows you how (click the 'fullscreen' icon bottom right to enlarge video):



The key steps are:

Step 1: Select the information you need in Gap Analysis

Step 2: Download as a csv file

Step 3: Convert to Excel 

Step 4: Format columns, rows and add conditional cell formatting

Step 5: Save!




    • Related Articles

    • Gap Analysis: View the Gaps in a Student's Learning

      Gap Analysis allows you to clearly see any gaps in a student's learning to effectively plan next steps. Navigate to Gap Analysis from your dashboard, or within Classes & Groups and Assessment Summary. Use the selector to select the Year Group / Class ...

    • Insights: Judgement Score Analysis

      The Judgement Score Analysis displays the percentage of students awarded each attainment and progress descriptor. This is either the calculated judgement from individual assessments, or a teacher judgement override if one exists. This information is ...

    • Insights: Accumulated Score Analysis

      The Accumulated Score Analysis report surfaces the average % of assessments for each class in a selected subject. As teachers record assessments against each assessment window, the Accumulated Score Analysis updates. This report is useful when ...

    • Insights: Leaders Analysis Report

      The Leaders Analysis report allows you to see cumulative attainment and progress judgements (as well as Defined Progress Over Time) based on the assessments or teacher judgments recorded in your system, while also presenting a breakdown of how each ...

    • Toggle Between Traffic Light and Shades

      We have added a new feature which allows you to view Gaps Analysis as the standard ‘Traffic Light’ option or now as ‘Shades’. 1. Go to Gap Analysis 2. Select ‘Year Groups’ or ‘Classes / Groups’, ‘Subject’ and ‘Rung Year’. 3.Above the first ladder is ...