Available Fields

Accelerus Icon
 

Throughout the Analyser a tree of fields appears from where the fields in the database are listed and available to be used in its various operations:

In the Source and Expand operators, to set up selection restrictions.
In the Rank, Aggregate, Print and Export operators, for selection in the various panes that are used to set up your analysis requirements.
In the Filter, Formula and Aggregate operators, when constructing expressions or calculations in the Calculation Editor.

 

RA AvailableFieldsSource

 

minusField folders and nomenclature

In all instances of the available fields in the Analyser, the general principles are the same, whereby the tree is made up of fields 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.

The fields have been named in a hierarchical manner, using a consistent set of codes, with full stops between the hierarchical elements:

Generally, fields begin with a prefix indicating the type of field, eg Ct for cohorts, St for students.
Then the subsections of a field are separated by dots.

Therefore, as seen below, all of the Year Level cohort fields are coded Ct.YRLV, or whatever the code for this cohort type has been entered in the School Settings window in your database.

This may be followed by further subfields or just a field, eg Ct.YRLV.Cycle.Name, compared to Ct.YRLV.Name.

RA FieldNamingProtocol

 

minusField variations

The available fields in any location in the Analyser may vary:

The fields in the Restrictions table of the Source and Expand operators will depend on the entity type that has been chosen therein, eg Results compared to Enrolments.
The Aggregate, Formula and Rank operators allow the creation of fields which become available to the downstream operators.
The Aggregate operator may actually reduce the number of fields available as data is aggregated or grouped.
The Expand Operator makes more fields available than may have originally been piped into it.

Therefore, the positioning of the operator in the analysis may result in variations in the available fields. For example, an operator directly downstream from the Source operator will reflect the fields piped to it by the Source operator, but the fields may differ if the same operator is positioned further downstream in the analysis.

Likewise, the fields will not be the same when activated from an Aggregate operator upstream of a Formula operator, compared to the fields called from a downstream Formula operator.

Where new fields have been created in an operator, these fields will be listed in a folder for the operator, and are available for inclusion in any operation in the same way as the standard database fields.

However, new fields created in the Rank, Formula and Aggregate operators are only available in the analysis for which they were created and do not change your Accelerus database in any way.

As seen below, the fields in this Print operator include user defined fields found under Aggregate and Formula folders, indicating the fields were created in these operators upstream. In addition, many folders of fields are missing, as a result of the aggregation of data in the Aggregate operator.

RA AvailableFieldsReduced

 

minusMeaning and usage of the different fields

Most of the available 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.

However, some are less recognisable or there are multiple versions of fields that need clarification. These are covered in detail below.

 

In Accelerus, academic cycle categories and cycles are defined by each school. Then, subjects, cohorts and student custom properties must be assigned to an academic cycle category.

Therefore, you will find a generic Academic Cycle folder at the end of the available fields tree, plus an Academic Cycle folder within each of the entities that are assigned to academic cycles, eg within the Subject folder, as shown here.

RA SubjAcademicCycleFields

Generic Academic Cycle fields

[Category].Name

eg YEAR.Name, SEM.Name

YEAR.Name  =  2012

This returns data for the 2012 annual cycle and for all subcycles of annual. Therefore, if you have a semester category as a child of annual and a term category as a child of semester, data for Sem1, Sem2 and all four terms would be included.

SEM.Name = Sem1

Returns data for any cycle coded Sem1, ie 2012.Sem1, 2011.Sem1, etc.

[Category].StartDate

[Category].EndDate

YEAR.StartDate  =  01/01/2012

Will return the same data as using the YEAR.Name field, ie for the 2012 annual cycle and all its subcycles.

 

Academic Cycle fields found under Subject, Cohorts and Student Custom Properties

[Prefix].Cycle.HierarchyName

eg Sb.Cycle.HierarchyName,Ct.YRLV.Cycle.Name

This requires the hierarchy of the academic cycle to be specified, eg 2012.Sem1, 2011.Sem2.Term3, etc.

When used, only data for the specific academic cycle will be extracted.

Therefore:

Sb.Cycle.HierarchyName  =  2012

Will only extract data from subjects assigned to the 2012 annual cycle and not to those belonging to semester 1 of 2012.

Sb.Cycle.HierarchyName  =  2012.Sem1

Extracts only semester 1 subjects from 2012.

Sb.Cycle.HierarchyName  In  2012,2012.Sem1

Includes both annual and semester 1 subjects for 2012.

[Prefix].Cycle.Name

This field refers just to the actual name of the cycle, eg 2012, Sem1, etc. Therefore:

Sb.Cycle.Name  =  Sem1

Extracts data for any cycle named Sem1, no matter which year.

[Prefix].Cycle.StartDate

[Prefix].Cycle.EndDate

Any cycle that has the required start or end date will be returned. Therefore:

Sb.Cycle.StartDate  =  01/01/2012

Would return subject data for all subjects belonging to 2012, 2012.Sem1 and 2012.Sem1.Term1 if they all had the same start date of 1 January 2012, but not for 2012.Sem1.Term2 or 2012.Sem2.

[Prefix].Cycle.CategoryCode

[Prefix].Cycle.CategoryName

These fields would only be used if you wanted to refer to data across the whole database that belonged to a particular category, eg all annual data, or all semester data, no matter the year or semester.

 

Field

Usage

AI.Tags

AI.Tags.Comma

Assessment items may be assigned multiple tags, ie tags are multi-value fields. Accelerus allows these to be returned as an array or a comma separated value (CSV) string.

Both of the following will extract data that belongs to assessment items tagged T1:

AI.Tags  Includes  T1
AI.Tags.Comma  Like  *T1*

It is recommended that the array field AI.Tags is used, in conjunction with the Includes operator.

AI.IsCalculated

Use this field to extract assessment items that include a calculation or only those that do not, ie:

AI.IsCalculated  =  True

AI.IsCalculated  =  False

AI.IsSystem

Schools in the Victorian Catholic and Government sectors use Quick Setup for their AusVELS reports. All of the AusVELS assessment items created through Quick Setup are system items. Therefore, you may select just system items or exclude system items from an analysis using this field, ie:

AI.IsSystem  =  True

AI.IsSystem  =  False

AI.RestrictedState

Assessment items may be restricted from the view of teachers. To include or exclude such items, enter:

AI.RestrictedState  =  R

AI.RestrictedState  =  A     OR    AI.RestrictedState  <>  R

R signifies Restricted and A means Available.

AI.LockedState

Locked assessment items may be included or excluded from an analysis using this field, eg:

AI.LockedState  =  L

AI.LockedState  =  U

L equals Locked and U means Unlocked.

MarkSchemeCategory

There are four marking scheme categories:

C for Comment
D for Date
L for List
N for Numeric

Therefore, to extract all results that are comments, enter:

MarkSchemeCategory  =  C

 

Each school defines its own roles in the Security window. Accelerus allows multiple roles to be defined for each role type, eg Teacher 1 and Teacher 2.

RA SourceAllRolesFor each role defined, a folder of fields will be available under the appropriate entity, ie under Subject, Class and the various cohort types such as Year Level and Home Group.

In addition, an All roles folder will be found in each of the Subject, Class and cohort entity folders. As shown here, there is an All Class roles folder in the Class entity.

Within each All roles folder are three additional folders with fields that contain details of all of the teachers who are assigned to the roles:

Array fields are multivalued fields, eg [SMIM,DOBP,BROJ]
Comma fields convert the array fields to a comma separated value or CSV field, eg SMIM,DOBP,BROJ
The String fields convert the array fields to a string which contains appropriate spacing and text, eg SMIM, DOBP and BROJ.

You will notice that most of the fields in all three folders end with TIF, TPF, PF, etc. These letters stand for:

T        Title

P        Preferred Name

I        Initial

G        Given Name

F        Family Name

Therefore, for example, if you have a class taught by Ms Mary Smith and Mr John Brown:

The Title and Family Names string field, ie Cl.Roles.TF.String, would be Ms Smith and Mr Brown.
Cl.Roles.GF.Comma would be Mary Smith,John Brown.

If you wanted to extract all results for students taught by Mary Smith, you could enter restrictions such as:

Cl.Roles.GF  Includes  Mary Smith.
Cl.Roles.Code.Comma  Like  *SMIM*
Cl.Roles.TPF.String  Like  *Mary Smith*

When used in restrictions in the Source or Expand operators, array fields require the use of the Includes operator, whereas Like or Not Like are used for the Comma and String fields.

 

Warning

If you do not use one of the role fields when you have multiple teachers to a role, you would have to know exactly the role to which a teacher was assigned, eg Teacher 1 or Teacher 2.

Unless your school only ever has one role for subjects, classes and/or each cohort, it is recommended you set up your analyses using the All Roles fields. In this way, you do not have to change the analysis each time you run it for different subjects, classes or cohorts.

 

Field

Usage

EnteredValue

DisplayedValue

ReportedValue

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.

ResultOrdinal

When a List marking scheme is set up, the order in which the scheme’s values appear in the Marking Scheme window is the ordinal value. For example, in an A to E scheme, if you enter A, B, C, D, E as the values, in this order, their ResultOrdinal values are 1, 2, 3, 4 and 5.

With Numeric schemes, the actual number of possible numeric results determines the ordinal value.

In the case of comment and date schemes, the ordinal value is always 0.

Note that exceptional values in List and Numeric marking schemes also have an ordinal value and, therefore, in some situations you may need to use the IsExceptionalValue field in conjunction with ResultOrdinal.

IsExceptionalValue

List, date and numeric marking schemes may have a set of exceptional values, eg NA, ABS, etc. The IsExceptionalValue field may be used to specifically extract just these values or exclude them from analyses, ie:

IsExceptionalValue = True

IsExceptionalValue = False

 

Field

Usage

IsWithdrawn

Enrolment Status

Both of these fields refer to the withdrawal of students from classes but allow the restriction to be entered in different ways. Note that E signifies Enrolled and W equals Withdrawn.

IsWithdrawn  =  True

OR

IsWithdrawn  =  False

EnrolmentStatus  =  W

OR

EnrolmentStatus  =  E

EnrolmentStatus <> E

OR

EnrolmentStatus <> W

 

Field

Usage

Sb.IsSystem

Schools in the Victorian Catholic and Government sectors use Quick Setup for their AusVELS reports and, as part of this, Accelerus creates special system subjects to hold overall domain scores. You may want to exclude such subjects from analyses or specifically include just these, ie:

Sb.IsSystem = False

Sb.IsSystem = True.

Ct.[CohortCode].TypeName

eg Ct.YRLV.TypeName

The name of the cohort type. For example, for the cohort type YRLV the type name would be Year Level.

These cohort type names are those you have assigned to your cohort types in the School Settings window.