Fields in Assessment Item Calculations

Accelerus Icon

AI CalcEditorFieldsWhen setting up formula calculations in assessment items the Calculation Editor window is used. It contains a Fields pane with all of the fields that may be drawn upon when constructing a formula to calculate results based on other results or data in the subject, either for individual students, on a class by class basis, or across the whole subject.

The tree of fields therein is different to the fields in the Analyser. This is because subject and class windows deal with results in assessment items, that apply to particular subjects and classes and, therefore, the fields available are specific to the particular subject and classes. On the other hand, analyses deal with the whole database and the fields are more generic.

As seen below, the actual assessment items in the particular subject are displayed in the pane of available fields and, within each of these, specific fields are available including those that apply to the whole subject or to to each class of the subject.

The available fields in the Calculation Editor are appropriately grouped together in folders by entity for ease of retrieval, eg Student, Subject, Assessment Item, etc. Within each folder, further folders may be found.

Most of the folders and their fields are easily identifiable as they relate directly to the various fields in each of the different entities in Accelerus, eg students, subjects, classes, etc. They may be useful in various calculations, eg:

If(Student.Gender = "M", "he", "she")

Other fields which are less recognisable and may need some clarification are covered below.


minusStudent fields

In the Student folder, apart from fields for the student's code, name and gender, the following are found:

A sub folder for each cohort type that has been set up at the school, as found in the School Settings window, eg Year Level, Home Group, etc.

Within these are fields for the code and name of the cohort groups, and any cohort roles that have been created in the Security window, eg Home Group Teacher.

A Custom Properties folder containing all of the student custom properties that have been set up.


minusSubject fields



Subject Count

{Subject.Count} returns a count of the number of students currently enrolled in all classes of the subject.

Note that this may return a different result to the special Count calculation, which allows a count of the number of valid results for a specific assessment item, for the subject.

Academic Cycle Name

Returns the academic cycle of the subject, eg Sem1, 2011, etc.

All Subject Results

AI CalcFieldsSubjectThis folder displays all of the assessment items that exist in the subject, eg  but rather than drawing upon an individual student result, these fields deal with the set of results for the entire subject for the particular assessment item.

These multi-valued fields are used with various calculations where the result for a student is determined within the context of the other students’ results. For example, to determine how many students received an A result in an item coded TASK1, you could enter:

DCountIf({Subject.TASK1}, {Subject.TASK1} = 'A')


minusClass fields



Class Count

{Class.Count} returns a count of the number of students currently enrolled in each class of the subject, ie for each student it will display the count of students in the class in which they are enrolled.

Note that this may return a different result to the special Count calculation, which allows a count of the number of valid results for a specific assessment item, for the student's class.

All Class Results

This folder, like its Subject counterpart, displays all of the assessment items that exist in the subject. However, these fields deal with the set of results that apply to the class of the student for the particular assessment item, and not across the whole subject.

An example usage of this field would be:


which would return each class average for the assessment item EXAM.


minusStudent results fields

In the Student Results folder you will find a list of all of the assessment items that have been created for the subject. These fields refer to the results of the students stored in these fields. For example, to average a student’s results for the items TASK1, TASK2, and TASK3, you would insert these fields into your calculation as follows:

Avg({TASK1}, {TASK2}, {TASK3})


minusAssessment items fields

Within the Assessment items folder, a sub folder for every assessment item that has been set up in the subject appears, as shown below.

Within these sub folders, most of the fields are identical for all types of assessment items, but some fields only relate to items that use a List, Numeric or Date marking scheme.





Long Name

The assessment item name field, eg {ATA.Name} return the description of the assessment item, or its name, as displayed beside the code. Interim 1 achievement is the name of the item coded T1ACH, shown here, for example.

The long description field of an assessment item is the Long Name field.

An example of the use of such fields in calculations would be:

If({AT1.Name} = "Workbook", "Workbook", "Other task")

This would print the word Workbook, if that were the task’s description. Otherwise Other task would be printed.


AI CalcFieldsAIListThis field only appears with assessment items that have a list marking scheme, eg A,B,C,D,E or Always, Usually, Sometimes, Rarely, Never, etc.

The List field returns a multi-valued list of all possible values in the List marking scheme used by the assessment item, ordered from first to last. The order will depend upon the way the scheme values were set up in the Marking Scheme window, but generally it is in descending order, starting with the best value, eg A, B, C…

These fields are particularly useful when using functions that deal with an ordered set of possible values, including DMode, Index and Ordinal. For example:


will take the student's result for TASK1 and find its ordinal value in the list of possible values for TASK1.

Entered Value

Displayed Value

Reported Value

These three fields relate to the three columns found in list and numeric marking schemes. For example, where a list scheme is used, the teachers may enter A, and this is displayed in the dropdown list as Well above expected level, and the reported value might be Working at least 12 months above expected level.

In the case of Date marking schemes, which have a Displayed Format, both the Entered Value and Displayed Value will reference the marking scheme's Displayed Format, which the Reported Value refers to the Reported Format.

When the Displayed Value or Reported Value fields are used for comment and numeric marking schemes, the Entered Value field will be substituted automatically.

All Class Results

All Subject Results

These fields are identical to those found for each assessment item under the Subject and Class All Results folders, covered above.



AI CalcFieldsAINumThe Min and Max fields only appear for assessment items that use a numeric marking scheme. They are available for the minimum and maximum values allowed for the assessment item.

The example this item allowed numbers between 0 and 100, these would be the values returned by the field {T1ABS.Min} and {T1ABS.Max}, respectively.

These fields can be useful when working out percentages or weighted averages, eg:

({T1ABS} / {T1ABS.Max}) * 100