{"id":13082,"date":"2023-01-19T09:59:10","date_gmt":"2023-01-19T09:59:10","guid":{"rendered":"https:\/\/support.overnetdata.com\/?post_type=ht_kb&p=13082"},"modified":"2024-04-11T13:41:50","modified_gmt":"2024-04-11T12:41:50","slug":"running-an-achievement-overview-report-in-analytics","status":"publish","type":"ht_kb","link":"https:\/\/support.overnetdata.com\/knowledge-base\/running-an-achievement-overview-report-in-analytics\/","title":{"rendered":"Running an Achievement Overview Report in Analytics"},"content":{"rendered":"\n

The Achievement Overview report in the Analytics <\/a>feature, allows staff to view information and statistics on achievement points in their schools. Achievement data recorded in Edulink One is written back as live data to SIMS. <\/p>\n\n\n\n

Log in to Edulink One and click on the Analytics <\/strong>icon to begin. <\/p>\n\n\n\n

\"Analytics<\/figure>\n\n\n\n

Select the Achievement Overview<\/strong> report from the Report dropdown menu. <\/p>\n\n\n\n

\"Achievement<\/figure>\n\n\n\n

The report contains a date range, a group by selector and an options filter. The window to the right of the settings will display the data selected in graphs. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select the date range by selecting the ‘from’ and ‘to’ dates in the calendars. This will pull all the data from the date range you have selected.<\/p>\n\n\n\n

\"'From'<\/figure>\n\n\n\n

Group By Filter<\/h2>\n\n\n\n

Next, select the ‘Group By’ filter and decide what data you would like to base your achievement point analysis on.<\/p>\n\n\n\n

You can select up to 3 pieces of data to filter.

\"\"<\/p>\n\n\n\n

\"Group<\/figure>\n\n\n\n

You can group by:<\/p>\n\n\n\n

    \n
  • Activity Type (English, Geography etc…)<\/li>\n\n\n\n
  • Boarder<\/li>\n\n\n\n
  • EAL<\/li>\n\n\n\n
  • Ethnic Identity<\/li>\n\n\n\n
  • Form Group<\/li>\n\n\n\n
  • FSM<\/li>\n\n\n\n
  • Gender<\/li>\n\n\n\n
  • Has Medical Condition<\/li>\n\n\n\n
  • House Group<\/li>\n\n\n\n
  • In Care<\/li>\n\n\n\n
  • Month <\/li>\n\n\n\n
  • PP<\/li>\n\n\n\n
  • Recorded by<\/li>\n\n\n\n
  • SEN Status<\/li>\n\n\n\n
  • Student<\/li>\n\n\n\n
  • Type<\/li>\n\n\n\n
  • Week<\/li>\n\n\n\n
  • Year Group<\/li>\n<\/ul>\n\n\n\n

    If you only select one data set to group by, your chart will appear as a bar chart with any additional information located at the bottom of the chart (X-axis). The achievement points\/records will always appear on the Y-axis. <\/p>\n\n\n\n

    \"\"
    Basic analysis using one ‘Group By’ filter<\/figcaption><\/figure>\n\n\n\n

    You can also select multiple data sets to group by (up to three things), for example, PP (Pupil Premium) and Week (per week). <\/p>\n\n\n\n

    You cannot select per week and per month when grouping for the data analysis; these must be separate.<\/p>\n\n\n\n

    \"Multiple
    Example of grouping by multiple data sets (PP, Week)<\/figcaption><\/figure>\n\n\n\n

    If you are grouping data and including the month or the week data set, you can click on the points on the line graph to reveal a key and a breakdown of the points and activity\/data they are connected with below. <\/p>\n\n\n\n

    \"\"
    Example of the data key for monthly and weekly analysis<\/figcaption><\/figure>\n\n\n\n
    \"Points
    A breakdown of the points and the data related to them happens below the graph<\/figcaption><\/figure>\n\n\n\n

    Y-Axis Selector<\/h2>\n\n\n\n

    You can select whether you would like to base your Y-axis data on the number of achievement records given to learners, e.g. merit, bronze award, outstanding effort, etc… Each achievement record counts as 1. <\/p>\n\n\n\n

    \"Y
    Y axis: Records <\/figcaption><\/figure>\n\n\n\n

    If you choose to base the Y-axis on points, the Y-axis will return totals for the number of points given to pupils for each achievement recorded. For example, a merit might be worth 1 point and a bronze award might be worth 6. Edulink One will calculate the total points for each individual achievement record for the groups and options you include in the filters. <\/p>\n\n\n\n

    \"Y
    Y axis: Points (same example as above, different field)<\/figcaption><\/figure>\n\n\n\n

    Optional Filters<\/h2>\n\n\n\n

    The optional filters allow staff to exclude records from the data set selected by the date range, for example, if you only want to look at the records for year 10 students, you would select ‘year 10’ in the Year filter. <\/p>\n\n\n\n

    \"Optional<\/figure>\n\n\n\n

    You can select:<\/p>\n\n\n\n

    Students <\/p>\n\n\n\n

    Achievement types<\/p>\n\n\n\n

    Recorded by employee<\/p>\n\n\n\n

    Involving employee<\/p>\n\n\n\n

    Gender<\/p>\n\n\n\n

    Form<\/p>\n\n\n\n

    Year<\/p>\n\n\n\n

    House<\/p>\n\n\n\n

    Ethnicity<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Additionally, you can add or exclude<\/em> the following from your data set selected in the ‘Group By’ filter: <\/p>\n\n\n\n

      \n
    • Pupil Premium<\/li>\n\n\n\n
    • EAL<\/li>\n\n\n\n
    • Free school meals<\/li>\n\n\n\n
    • Is in care<\/li>\n\n\n\n
    • Has a medical condition<\/li>\n\n\n\n
    • Is SEN<\/li>\n\n\n\n
    • Boarder<\/li>\n<\/ul>\n\n\n\n
      \"Optional<\/figure>\n\n\n\n

      Once you have selected your optional filters, hit Apply<\/strong>. You can also cancel or reset your filters at this point. <\/p>\n\n\n\n

      \"Apply<\/figure>\n\n\n\n

      Once you have hit apply, you will return to the main screen and then click ‘Update’. <\/p>\n\n\n\n

      \"Update<\/figure>\n\n\n\n

      Your graph will be generated with the data in the window adjacent. <\/p>\n\n\n\n

      \"Example<\/figure>\n\n\n\n
      \"Example
      Example graph and filter for learners in care and PP<\/figcaption><\/figure>\n\n\n\n

      If you would like to see the achievement types for students, leave ‘achievement types’ blank in the optional filter and export the analysis to view all of the types attached to each student. <\/p>\n\n\n\n

      Exporting<\/h2>\n\n\n\n

      You can export the base data you would like to process to a .csv file. This can be used for your own analytics, to look at records and create your own graphs. <\/p>\n\n\n\n

      \"Export
      Export button<\/figcaption><\/figure>\n\n\n\n
      \"\"
      Example of base data exported<\/figcaption><\/figure>\n\n\n\n

      Achievement Overview (Arbor)<\/h2>\n\n\n\n

      Achievement Overview does work with the Arbor MIS with these current filters, as these are the data fields available: <\/p>\n\n\n\n

      Group By<\/strong><\/p>\n\n\n\n

        \n
      • Form<\/li>\n\n\n\n
      • Gender<\/li>\n\n\n\n
      • House Group<\/li>\n\n\n\n
      • Month <\/li>\n\n\n\n
      • Recorded by<\/li>\n\n\n\n
      • Student<\/li>\n\n\n\n
      • Type<\/li>\n\n\n\n
      • Week <\/li>\n\n\n\n
      • Year Group<\/li>\n<\/ul>\n\n\n\n

        Optional Filters<\/strong><\/p>\n\n\n\n

          \n
        • Students<\/li>\n\n\n\n
        • Achievement types<\/li>\n\n\n\n
        • Recorded by employee<\/li>\n\n\n\n
        • Involving employee<\/li>\n\n\n\n
        • Gender<\/li>\n\n\n\n
        • Form<\/li>\n\n\n\n
        • Year<\/li>\n\n\n\n
        • House<\/li>\n<\/ul>\n\n\n\n

          Achievement and Behaviour Overview Reports Video<\/h2>\n\n\n\n
          \n