Aggregated Results

ADAM has a feature called “Aggregated Results” which are used to create aggregated results reports for pupils. This feature has two purposes:

Types of Aggregated Result Calculations

ADAM has three categories of Aggregated Result Calculations. You can choose whichever is best suited for your needs.

Reporting Periods

ADAM will take the final term results from each reporting period and weight them to reach a final aggregated result for a pupil in that subject.

For example:

Assessment Categories

ADAM will take results from each assessment category and allow you to specify an individual weighting for each to reach a final result.

For example:

Individual Assessments

A:\Users\Philip\AppData\Local\Microsoft\Windows\INetCache\Content.Word\big_warning_11.pngThis option is only available if you wish to create an Aggregated Result Calculation for a specific grade and subject.

In this calculation, ADAM will allow you to select individual assessments and weight them to reach a final result. This technique can be used to generate portfolio marksheets, for example, which may only use specific assessments and at specific weightings which might not reflect the weighting that was used for the term results.

For example:

Creating Aggregated Result Calculations

To create a new Aggregated Result Calculation, navigate to Reporting → Aggregated Result Calculations → Manage aggregated result calculations. A list of already created calculations will be shown to you, if any exist.

At the top of the screen, click on the option to Add a new Aggregated Result Calculation.

Specify which audience you’d like this calculation to be made available to:

The most common choices are a whole grade or a specific grade and subject. If you wish to make an aggregated result calculation that is based on individual assessment results, then you must choose a specific grade and subject. ADAM cannot create a calculation based on individual assessments across subjects or across grades.

Once you have selected the audience, click on Next and ADAM will ask for details of the calculation:

The Description field should be something to identify the calculation, such as “year mark,” “portfolio result” or even “practical results”.

You will need to specify the Academic Year that this applies to. ADAM cannot create a calculation that has results from multiple years.

If you chose to make a calculation available to a grade or a specific grade and subject, then you will be asked to specify which Grade that is. If you chose to make a calculation available to a subject or a specific grade and subject, then you will be asked to specify which Subject that is. Because we chose “specific grade and subject” on the previous page, ADAM is asking us for both the grade and the subject.

Finally, tell ADAM what results your calculation will be based on.

Click on Next when you want to proceed.

Depending on the type of calculation, you will see one of the following screens. Jump to the appropriate section below!

Reporting Periods

A list of reporting periods from the chosen academic year is displayed. The initial weightings are calculated automatically and are equally divided. You are welcome to change them to suit your needs.

A:\Users\Philip\AppData\Local\Microsoft\Windows\INetCache\Content.Word\big_warning_11.pngWhile these numbers look suspiciously like percentages in the screenshot above, they are not: ADAM will treat them as proportions of a total.

For example, if we entered the weightings for the three terms as 1, 2 and 4, ADAM would see that the total for the terms is 7 and weight Term 1 as 1 out of 7 (14,29%), Term 2 will be 2 out of 7 (28,57%) and Term 3 will be weighted as 4 out of 7 (57,14%).

Once happy with the weightings you’ve captured, click on Save changes.

Assessment Categories

ADAM will show a list of assessment categories for the chosen academic year. The initial weightings are calculated automatically and are divided equally. You are then welcome to change them to suit your needs.

In the diagram above, one might set the “Examinations” section of “Term 1” to 0 since there are no exams to take into account. Other weightings could be set accordingly.

A:\Users\Philip\AppData\Local\Microsoft\Windows\INetCache\Content.Word\big_warning_11.pngTake note that the numbers you see are not strictly percentages (they can be if you want them to be). ADAM will work them out as fractions of the total. Above, the total of all the 17s adds to 102. ADAM will actually use 17 / 102 as the fraction to work out the percentage weighting (16.67%)

Click on the Save changes button when you’re happy with your weightings.

Individual Assessments

If you choose to create a calculation based on the results of individual assessments, ADAM shows a very different screen to the ones in the diagrams above:

Start by clicking on the button Add a new line. ADAM will show a list of assessments that have been written in the grade this year - from all of the classes:

On the left, write a description for the assessment. For example “Listening Comprehension”. Choose how you want ADAM to treat the result (more on this below) and the total weighting that should be applied to these results.

The types of calculation include:

Note well that the assessments selected can be from multiple classes. This is useful so that you only need one calculation for all the classes in that grade. Also, it is necessary to catch results from pupils who may have written an assessment in one class in the first term, but moved to another class in the second term.

You can add as many lines as you like. Each line will appear as a separate column in the report view for this calculation.

Using an Aggregated Result Calculations as a Year-To-Date Result

You must have created your aggregated result calculation first.

There are two ways to set an aggregated result calculation as a Year-to-date result.

The first - and most commonly used - is to set it as a grade-wide calculation in the Reporting Period Settings. Note that only “whole grade” calculations can be selected to apply to a whole grade.

The second is to set the calculation in the mark book.

A:\Users\Philip\AppData\Local\Microsoft\Windows\INetCache\Content.Word\big_warning_11.pngSetting a calculation in the mark book will override any calculation that might be set for the grade in the reporting period settings.

At the bottom right of the mark book screen is a block that shows the currently applicable Year-to-Date Mark Calculation. If none has been set in the reporting period settings, then ADAM will simply be duplicating the Term result as a year-to-date result. If one has been set in the reporting period settings, then ADAM will use that one to calculate the results.

Note in the diagram above, the calculation is being pulled from the grade’s default calculation which is set in the reporting period settings.

Click on the button to Change YTD mark calculation. A list of available calculations will be shown in the dropdown list. Choose the appropriate one and click on Save calculation.

Using an Aggregated Result Calculation to calculate Term Results

While an aggregated result can be used to calculate a Year-to-Date result, as shown above, it is also useful to use such calculations to calculate a term mark. This is particularly the case when a mark is to be calculated using a “best-of” functionality for the assessments.

Use the instructions above to create an Aggregated Result based on subject and grade and then individual assessments.

A:\Users\Philip\AppData\Local\Microsoft\Windows\INetCache\Content.Word\big_warning_11.pngIt is not possible to have a term mark based on overall marks from other terms. It is, however, possible, to use assessments from previous terms.

In the assessment summary and weighting page, one would set the Year-to-Date calculation at the bottom of the page. However, to change the term mark to use an Aggregated Result, look for the following option at the top of the page:

Click on the button Change term mark calculation and then choose the Aggregate Result Calculation that you created above.