Entity Management

Accelerus Icon
 

The underlying database structure of Accelerus is quite complex, set up to allow multiple academic cycles of data to be stored and accessed. Having an understanding of some of the structures of the Accelerus database will make setting up Accelerus for the first time and in subsequent cycles easier. Integral to this structure are its entities.Ent ExploreMenu

Entities are a type of record, eg teachers, students, subjects, classes and cohort groupings. Each entity type has its own set of properties and fields. Also, entities have relationships with each other, ie they interlinked. For example, classes belong to subjects, have students enrolled in them and are taught by teachers.

The Explore menu, available to those with a school level role, lists all of the entities in Accelerus. The majority of these entities are available to Accelerus administrators only, either through the Quick Find pane or the relevant Explorer window. Each will open in its own tabbed window, displaying the details for the currently selected academic cycles.

Many entities, eg Report Runs, Quick Setups and Analyses, have their own, unique and specific functions. The entities with which most users will deal are the types of records those working in a school environment are familiar with - students, teachers, subject, classes, and the various cohort groups such as year levels.

The more specialised entities are usually only dealt with by Accelerus administrators.

At the subject level, those with a subject role may need to bring up the results of the students in subjects they coordinate for the purpose of checking them and/or making changes.

Most commonly, those with a class role, ie most teachers, will be working on class entities, ie the classes of students that they teach, assigning results and comments to these students.

With many of the entities, their data is initially imported into the Accelerus database from the school's computerised administration systems, although all can also be set up manually. However, manual data entry is usually only used to add the odd new student or teacher, change enrolments and other ongoing maintenance functions, rather than bulk data entry of records at the beginning of an academic cycle.

All of these processes work with entities and throughout Accelerus, the same general procedures are used in creating new records and for exploring, opening or deleting existing records, whether it is classes or students, subjects or cohort groups.

However, some of the entities have specific features and procedures that apply only to them. For example, you may move students in a class from one class to another for a Class record only.

 

minusLifespan of entity records

Each entity type in Accelerus has a lifespan, or applies to different timeframes. For example, teachers and students remain in the database for all time, whereas subjects may vary from cycle to cycle, as required.

During its lifespan, each record should be uniquely coded. Therefore, a subject code must only be unique within an academic cycle, and the same code may be used in the next cycle, if you wish.

On the other hand, base teacher and student details – Code, Family Name, Given Name, Preferred Name, Gender, Title, Start Date and End Date – exist perpetually in the database. If these details are changed, any previous values are overwritten permanently.

The table below lists the main database entities and their lifespan, or the period of time to which a record applies:

 

Entity Type

Applies to

Teachers

The whole database, across cycles, but only current for the time between their start and end date, if entered.

It is not necessary to add the teachers each cycle or year – simply add new teachers and enter the end date for those teachers who have left the school.

Cohorts

To the academic cycle category defined in the Cohort Types tab of the School Settings window, eg annual.

Students

The whole database, across cycles, but only current for the time between their start and end date, if entered.

Students’ cohort memberships are restricted by the applicable academic cycle category, eg annual. Therefore, each applicable cycle, you must set the new cohort memberships.

Students are never removed from the database, but their end date can be entered when they leave the school.

Subjects

Applicable to a particular academic cycle.

The assessment items added to a subject, therefore, apply for the same period.

Classes

The classes and the enrolments in them are applicable to a particular academic cycle. This is the cycle that applies to the subject to which the classes belong.

Marking Schemes

The whole database, perpetually.

Report Runs

Encompass all academic cycles that fall in the report run’s start and end date.

Quick Setups

Is linked to a particular report run and its range of dates.

Analyses

The whole database, perpetually.

Result Conflicts

Belong to a particular academic cycle, according to the class to which the conflict applies.

Comment Banks

The whole database, perpetually

 

minusEntity field specifications

Each entity record in Accelerus has fields which have particular attributes.

Maximum number of characters, with 20 being the maximum for most code fields.
Type of data allowed, eg numbers, letters, any special characters such as underscore, etc.
Whether mandatory or not, which means records cannot be saved without valid data for the field.
Whether they have user-defined or set field names. For example, when importing students, the cohorts to which they are assigned are defined, coded and named by each school.

When setting up Accelerus entities, whether manually or using the importing processes, you must ensure your data conforms to these field specifications.