Managing Teacher Assessed Grades (TAG) for 2021 summer examinations

Since the DfE’s update that GCSE and A-level qualifications will be awarded based on assessment by teachers rather than formal exams, they have released further guidance outlining that schools should submit unranked Teacher Assessed Grades to the Awarding Organisations.

You can generate lists of students you've entered into each exam series in Arbor, which you can then export to excel to filter and submit to the Awarding Organisations before the 18th June deadline. We've detailed the process below.

You will not be able to use the Forecast Grades page in the Exams area to generate a list, due to the Awarding Organisation not having released the full basedata for the Summer 2021 exams.

What are the options?

There are two options, depending on whether you are already using assessments in Arbor.

If you're not already using assessments, you can use Exams to generate your TAG lists. Follow the instructions for option 1. To view student entries, you'll need one of these permissions:

  • Student Profile: Action: Qualifications: Administer All Students - Headteachers and Exams Officers have this permission by default.
  • Student Profile: View: Qualifications: View All Students - Please note this permission will not currently allow users to view the entries pages. We are currently working on fixing this.

If you are using assessments, you can use Ad Hoc Assessments to generate your TAG lists. Follow the instructions for option 2. You will need these permissions:

  • Assessments: Administer - Set up and manage assessments.
  • Assessments: Administer All/My Students - Add assessment marks for all students/students they are the academic lead for.
  • School: General Admin: Export Data - Create your own custom reports.

If you're missing the permission required, ask your office team to give it to you using these instructions.

 

Option 1 - Using Exams

Step 1 - See your entries

If you've got the right permissions, you'll be able to go to Students > Examinations > Entries > Entries by Student Group.

Click into the filters to select the classes you want to generate a list of entries for, then click Apply Filters.

Screenshot_2021-03-08_at_13.04.36.png

 

You'll then see all of their entries. If you can't see any entries, make sure you have made your entries correctly.

Screenshot_2021-03-08_at_13.21.11.png

Step 2 - Download and filter your data

To export your entries into a spreadsheet, click Download and select Excel.

Your export will show additional student fields of UPN, UCI and ULN.

Screenshot_2021-03-08_at_13.23.22.png

 

Once you open your export in Excel, you have a list of students and their entries.

Screenshot_2021-03-08_at_13.27.07.png

 

You can then:

  • Delete any unneeded columns.
  • Remove any students who aren't taking that subject by deleting the row.
  • Separate each subject into its own sheet if you want to. Just duplicate your tab, then delete any unwanted columns so you have one subject in each tab.

For example, as I'm only looking at students taking English Language, I'm going to delete the other columns. 

Screenshot_2021-03-08_at_13.28.46.png

Step 3 - Send your grades off to the awarding organisations

You can then put in the grades, which you can share with other team members to help finalise. In this example, I've uploaded my excel file to Google sheets to allow me to share it.

To put in grades, simply change 'Entry Confirmed' to the grade.

Screenshot_2021-03-08_at_13.34.07.png

 

Once you've finalised your grades, you can send them to the awarding organisation. The process for this is likely to be different for each awarding organisation, so please contact them for further information.

 

 

Option 2 - Using Assessments and the Custom Report Writer

Step 1 - Create an Ad-Hoc assessment

Rather than setting up new summative assessments, the easiest way to create an assessment column for teachers to enter TAGs into is to set up a new Ad Hoc assessment and link it to all the subjects you need to generate TAGs for.

Follow the instructions in this article to set up your Ad Hoc assessment: Setting up Ad Hoc Assessments

In step 2 when you choose your assessment details, be sure to select 'One mark per course' to set up the Ad Hoc for each subject, and select that the marking type should be Grades. You'll need to add the 9-1 grade set in the next step.

set_up_ad_hoc.png

ad_hoc_grades.png

 

Once you add the assessment to your Assessment Framework, you need to add it to your Annual Policy.

add_to_policy.png

 

Be sure to link the assessment to the subjects that you want to produce TAG for, and the students who are taking the exams (you can always remove single students from your export later on).

Select that the assessment should be a single annual measurement. In Students > Assessments > Annual Policy > Manage Assessments you should see the assessment linked to the GCSE courses.

add_tag_to_policy.png

manage_assessments_tag_example.png 

Step 2 - Enter the marks

Teachers will be able to enter the marks for the Ad Hoc assessment from the same place as they enter the subject marks because they've been linked. You can see how to do this here: Get to the summative assessment marksheet and add marks

They can scroll to the right-hand side of the marksheet and add in the TAG.

tag_for_english_marksheet.png

Step 3 - Create your mark export

To export your TAGs, you'll need to create a report from School > Custom Report Writer.

The report should be regarding Students, then click Next

set_up_custom_report.png

 

Select the date range for the full academic year, and then add a column for your TAGs. Add one column for each subject (or you could also create a separate report for each subject).

add_TAG_columns.png

 

In step 6, add a filter to only look at the current students taking exams. You could use a year group (shown below).

add_student_group_filter.png

 

When you save and view your report, you can see each student's TAG for each subject.

Click the Download button to export it into Excel.

Screenshot_2021-05-06_at_15.44.02.png

Step 4 - Send your grades off to the awarding organisations

Once you've downloaded your sheet, you can share it with other team members to help finalise it. In this example, I've uploaded my excel file to Google sheets to allow me to share it.

Before you submit the information to the awarding organisation, you can:

  • Delete any unneeded columns.
  • Remove any students who aren't taking that subject by deleting the row.
  • Separate each subject into its own sheet if you want to. Just duplicate your tab, then delete any unwanted columns so you have one subject in each tab.

Screenshot_2021-05-06_at_15.47.46.png

 

Once you've finalised your grades, you can send them to the awarding organisation. The process for this is likely to be different for each awarding organisation, so please contact them for further information.

 
Was this article helpful?
1 out of 1 found this helpful
I'm still stuck!

Comments

6 comments
  • Thanks for this.

    Is it just me though that can't see why we would use this over assessments? We need the data in Arbor so we can analyse it and send to 4matrix. 

    0
  • Hi Kate, we know not all of our schools use the Assessments area of Arbor, so doing it through exams allows you to generate these lists without needing to set any assessments up. It also includes the UCI, UPN and ULN so you don't need to worry about adding additional columns, user-defined fields etc. If you would like to use assessments to generate your lists you absolutely can!

    0
  • Does Arbor produce any analysis for exams or does it always have to be exported? 

    0
  • Hi Catherine, it does currently have to be exported. But we are working on some features to allow you to analyse exams within Arbor. Please put any feedback you have on what you'd like to be able to analyse here: https://portal.productboard.com/arbor-education/1-arbor-development-roadmap/c/100-ks4-exams-results-analysis

    0
  • So are the two approaches an 'either or', as you in you can do the same thing/collection of grades by the exams route or by assessment? (for example if you were more familiar and confident with the exams route?)

    0
  • Hi Kal, that's right! You can use either method at your school - if you'd rather use the Exams area that's absolutely fine!

    0

Please sign in to leave a comment.