ADAM has a feature called “Aggregated Results” which are used to create aggregated results reports for pupils. This feature has two purposes:
- As an additional analysis tool. We might use this to calculate an aggregated examination result or to perhaps use a “best of” scenario to include and exclude some assessments. In some subjects, it might be useful to create a “practical” and a “theory” result, and the Aggregated Results now allows for this.
- Secondly, ADAM can use Aggregated Results to calculate a “Year-To-Date” mark for a class or grade. You will choose an aggregated result to use as the default result. Classes, however, have the opportunity of overriding that default aggregated result by choosing one of their own. This provides the opportunity for some subjects to have their year marks calculated differently to other subjects.
Types of Aggregated Result Calculations
ADAM has three categories of Aggregated Result Calculations. You can choose whichever is best suited for your needs.
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.
- Term 1: 10%
- Term 2: 30%
- Term 3: 10%
- Term 4: 50%
ADAM will take results from each assessment category and allow you to specify an individual weighting for each to reach a final result.
- Term 1 Classwork: 10%
- Term 2 Classwork: 10%
- Term 3 Classwork: 10%
- Term 4 Classwork: 5%
- Term 2 Examination: 25%
- Term 4 Examination: 40%
This 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.
- Test 1: 5%
- Test 2: 5%
- Mid-year exam: 20%
- Investigation: 30%
- Trial Examinations: 40%
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!
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.
While 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.
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.
Take 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.
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:
- Average of: here, ADAM works out a simple average of all the results.
- Weighted average of: when working out the averages, ADAM will take the markbook weightings into account.
- Best 1 from: ADAM will take the result with the highest percentage for each pupil of the assessments selected.
- Best X of (weighted average): Here ADAM will take the best number of assessment results for each pupil from the ones selected and produce a weighted averages (based on markbook weightings).
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.
Setting 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.
It 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.