© 2018 Capita Business Services Ltd. All rights reserved.

Capita Education Software Solutions is a trading name of Capita Business Services Ltd. Our Registered office is 30 Berners Street, London, W1T 3LR and our registered number is 02299747. Further information about Capita plc can be found in our legal statement.

Local API - Assessment Concepts

Overview

What do we mean by Assessments?

George got a ‘B’ in his maths test on the website of Online Test Provider. His teacher, Miss Beale, wants to enter the marks for George and the rest of the class in SIMS. 

Miss Beale would start by checking if there is an appropriate maths test Aspect.  She will need to bear in mind that everyone else in the maths department also defines a maths test and these are usually very different as the students pass through the school.  For completeness, we will assume that this doesn’t exist.

Miss Beale would have to first decide if there was an appropriate Grade Set available. If none is available, she would create one.

  • Grade Set Name:  Year 4 Autumn Term Maths Test Grades (Mrs Beale)
  • Date Range From: Now until <For ever>
  • Grades:
    • A                  10 points
    • B                   8 points
    • C                   6 points
    • F                   0 points.

NB: The names need to be specific and unique to avoid confusion.

She would then need to define an Aspect (mark definition) to collect the grades.

  • Aspect Name: Year 4 Autumn Term Maths Test (Mrs Beale)
  • Aspect Type: Grade
  • Grade Set: Year 4 Autumn Term Maths Test Grades (Mrs Beale)

Miss Beale would need to create a Template, which is a list of column headings for a mark sheet.

  • Each column defines an Aspect and optional result set (a purpose for the mark) and other optional items.  We only need to set the Aspect to the one created above.

Once this has been done, Miss Beale would create a Mark Sheet for her group and then she would be able to enter George’s mark and those of his classmates.

  • At the point of entry the marks are validated and errors can easily be seen and corrected.

Once the marks are in SIMS, there is a significant range of analysis tools and reporting options available to the MIS users.

Importing the marks from external systems automatically

Any expectation that steps above can be left out or avoided are likely to be disappointed.  Quite the reverse is true!

Stage 1: Apples and pears

We need to match up the mark definitions that we have in the VLE with the mark definitions in SIMS.  Given that the key validation point must be when the mark is entered, the VLE needs to validate the entry against the set of valid marks in SIMS before the mark is entered.

There are 2 ways of doing this.

Option A: Using School-defined Aspects and Grade Sets.

  • If the marks collected are based on existing standards within the school then the correct route is to export:
    • All Aspects
    • All Grade Sets
    • [All result sets / Assessment Periods]
  • From SIMS to the VLE.
  • The VLE then (before marks are collected ideally) links their mark definitions to the SIMS mark definitions.

Marks are then validated on entry and are easily transferable to SIMS.

Option B: Using VLE supplier defined Aspects and Grade Sets.

  • If the VLE provided offers standard tests typically across more than one school then the owner of the mark definition should be the VLE provider.  The VLE provider would also own and manage their own grade sets and possibly result sets.
  • When data is exported to SIMS, it will come complete with the VLE provider’s definitions and hence can be imported without issue.
  • Each provider needs to decide which is most appropriate for them.  Typically a mix of owners is likely to be more problematic unless great care is taken.
  • It is critical that if SIMS is used to generate Aspects, Grade Sets and other artefacts on behalf of a Technical Integrator then the SIMS training database MUST be reset to have unique GUID for supplier and other artefacts. 

Technical Integrators MUST contact the Partner Support Team before generating these from training data.  Externally generated artefacts should be fine!

Stage 2 – Moving the marks from A to SIMS.

There a many ways to move the data by data we usually mean results along with their definitions.  Usually, the simplest one is to put an application on a server in the school / data centre and schedule an export/import daily. 

The key thing is that the school controls what runs and there are many excellent examples of Technical Integrator systems populating their systems in this way and returning data to SIMS.

NB: Trying to push data into SIMS where the external provider is in control will usually fall foul of firewalls and security rules.

Please note that data centres may charge for hardware and software maintenance on Technical Integrator data extraction utilities. This is because it actually costs time and resources to upgrade these systems and support them within the data centre.  On a school server, this effort is usually fairly minimal and the resources are internal to the school benefitting from the application.

If the data transfer is divorced from the data entry error messages are likely to lack meaning and be difficult to get back to the member of staff who can fix the fault.    That is why there is an emphasis on validation at point of entry.

There is a check on the supplier name in SIMS assessment imports.  The customer needs to create an agency with the same as the supplier or SIMS will refuse to import the data.

 

Stage 3 - Customers using the imported data in SIMS

At this point, there are results in SIMS.  There will be no templates or mark sheets which are the typical way that SIMS users would view results in SIMS.  In other words, the transferred data is invisible in SIMS.

If the VLE is creating a set of aspects and they have some form of coherence when grouped in sets then it might be worth them creating templates for their aspects in a copy of SIMS modified to ensure that supplier and other identifiers are unique.  These can then be exported to an XML file and simply imported by the schools.  This is an easy task but there is no simple automation process for template imports.

If there is no coherent grouping then templates can be created by staff as in the manual mechanism described above.

In both cases, once the template has been created, it is a simple task to make mark sheets from the template.

If the aspects, grade sets and result sets are exported from SIMS to the VLE, we assume that schools would have already created suitable templates and mark sheets.

Interim Conclusion

The value of the automation process which moves marks from a VLE (or similar) to the MIS is significant and a key step forward identified by BECTA before their demise.

It is also critical that SIMS Technical Integrators engaging in providing a facility to export data to SIMS consider this guidance carefully so that we can ensure that the quality of the data is maintained across the transaction.

Detail Dive for the Assessment System

Introduction

Assessment Manager is area of SIMS used to record and manage results of any kind which need to be stored against a student. 

Assessment is one of the key areas of data that BECTA has identified for publication to parents and one of the areas where data is typically generated and stored in diverse systems such as VLEs in addition to the MIS. 

It is therefore a key area for data exchange if we are to provide a holistic view of a student’s achievements to parents, staff and students alike.

Whilst technically it is possible to code against the same business objects and processes that are used in the SIMS UI, we have provided some simple XML formats for exchanging key assessment data in a format similar to the SIF (System Interoperability Framework) formats.

Assessment Structures

Aspect Types

The following types of aspect are supported in SIMS.

Type

Supported in SIMS

Supported in SIF

Grade

Yes

Yes

Decimal

Yes

Yes

Integer

Yes

No – Use Decimal

Comment

Yes

Yes

Age

Yes

No

 

Grade Sets

Grade sets are required elements for Aspects of type Grade.  A grade set may have multiple value sets.  A simple example of this is Formula 1

Pre 1/1/2010

Post 1/1/2010

Grade

Value

Grade

Value

First

10

First

25

Second

8

Second

18

Third

6

Third

15

Fourth

5

Fourth

12

Fifth

4

Fifth

10

Sixth

3

Sixth

8

Seventh

2

Seventh

6

Eighth

1

Eighth

4

 

 

Ninth

2

 

 

Tenth

1

 

So a grade set defines the set of allowable grades for an aspect at a given point in time and the relative values of each grade.

Within SIMS Grade Set definitions you would see

Define a grade set #1
SIMS 7 Gradeset

Or click on the version 01/01/2010

Define a grade set #2
SIMS 7 - Gradesets showing historical values

Supplier

Some assessment artefacts have the concept of an owner.  When SIMS is installed, a unique identifier based on the school name and number is generated and this is used to define who created the ‘Aspect’.  Whilst this may seem trivial, it has a large impact on the Assessment System.  If you want to be able to provide a standard assessment to multiple schools then it needs to have the same supplier and identity.  Within a SIMS installation, artefacts that were created by a supplier other than the local system are not editable which significantly restricts what the school can do with them!  Partners need to define a suitably unique supplier id for themselves (25 characters) and ensure that all of their artefacts are from them as a supplier. 

ESS would expect partners not to distribute artefacts with supplier ids based on ‘Green Abbey’, ‘Water’s Edge’, ‘CCS’, ESS or ‘SIMS’ for obvious reasons.

Aspects

The term aspect is used to define a mark or result within SIMS.  An Aspect is comparable to a LEARNERRESULTCOMPONENT within the SIF model. 

Define an Aspect in SIMS 7
SIMS 7 - Aspect - Type grade

Aspects now have unique GUIDs which are used within our Partner interfaces to identify them.  Aspects also have an external id which should be unique and is used through older import routines to match up. Partners should assume that their Aspects will be exchanged between schools using any means available.

Where aspects are of type decimal or integer the following additional information is required.

Define range for decimal aspect
SIMS 7 - Aspect of type integer / decimal

Where aspects are of type grade they require the following additional information

Define range for an age type aspect
SIMS 7 - Aspect of type Age

Comments require no further information and grades require the following:

Grade set definition for grade type aspect
SIMS 7 - Aspect of type Grade

Whilst there are ‘classifications’ that can be applied to aspects these are local to the school and not supported by the Partner Interfaces.

Aspects have the following set of data populated when they are saved.

Empty set of default properties for an aspect
SIMS 7 - Aspect self filling fields

Becomes

Populated set of defaulted properties of an Aspect
SIMS 7 - Aspect with default fields populated.

for our example.  The module will always be CES Assessment Services and this is outside of Partner control.   

Result Set

A result set is a device used to give a specific result a purpose.  For example and end of term assessment ‘result set’ may be created and applied to say English, maths and science effort grades.  The teacher may collect weekly effort grades but there would only be one grade used on the report.

Capita owned aspect definition
SIMS 7 - Result Set

The only data entered by the user is the basic section.  Similar issues would apply to suppliers and IDs as they do for aspects.

Results

Results can be recorded as follows:

With a Result Set

One mark can be recorded for any aspect, student and result set.  Any further mark for this combination will overwrite the previous mark.

Without a Result Set

One mark can be recorded for any aspect, student and calendar day.  Any further mark for this combination will overwrite the previous mark.   Hence a historical performance record is maintained for ‘standard’ results.

Results are validated against their aspect and grade set where appropriate. 

Result validation is date based because the grade sets and value ranges are editable over time.

Results dates are critical – using the current date as the date for the result will create incorrect results for students.  For example if we were to create a program that saves resends results on a daily basis to SIMS

Result date        Who      Result  

10/01/2010       Fred      Grade B

10/01/2010       Jane      Grade C

If the application used the current date for results then it might create an apparent history as follows:

10/01/2010       Fred      Grade B

11/01/2010       Fred      Grade B

12/01/2010       Fred      Grade B

13/01/2010       Fred      Grade B

14/01/2010       Fred      Grade B

 SIMS does provide a mechanism for Fred to be given the same grade for an aspect on another day, but the data would suggest that Fred had been assessed 5 times when this was not the case.  Worse if the data was corrected to a grade C on 15/01 then the data would be completely wrong

10/01/2010       Fred      Grade B

14/01/2010       Fred      Grade B

15/01/2010       Fred      Grade C

WARNING

The use of today to save results is usually an error unless the marking process posts the result back to SIMS without delay.

Template

A template is a device used to group a set of Aspects for collection within a mark sheet.  This is where an aspect is tied to a result set within SIMS for collection.

Initial screen for a template definition
SIMS 7 - Template

 

We have added the F1 result to the template and made it a result tied to a result set ‘End of Term Assessment’.

Mark sheets can then be created for most types of groups within SIMS, simply by pressing add on marks sheets and choosing the applicable group.

Mark Sheet

Once saved, a mark sheet can then be opened as in the figure above.

SIMS 7 Assessment Marksheet
SIMS 7 - Marksheet

Saving and then right click on a result will allow the editing and display of the mark history.

SIMS 7 Marksheet Historical marks
SIMS 7 - Marksheet historical results

Partner Interfaces

There are two key partner designed interfaces one for import and export. These interfaces allow for the following:

Artifact

Import

Export

Grade Set

Yes*

Yes

Aspect

Yes*

Yes

Results

Yes

Yes#

Result Sets

No

Yes

# ESS cannot conceive of a valid reason to export every single mark ever held for a student.  A full export would also be slow.  We have made a filter compulsory on export for these reasons.

* Aspects and Grade Set scan only be imported if a supplier is created in Agencies and the name matches the supplier name within the import.

SIMS 7 - Agency (Simple)
SIMS 7 - Agency

Only the 2 required fields need be filled in but this is deemed to be an agreement that artifacts from that provider may be added to the SIMS system.  Users should only add the agency if they trust the provider and believe that they will provide imports within the terms of their assessment policy.

Export / Import Process

Both interfaces are XML based and similar to standard SIF formats.  This does mean that you cannot use integer or age aspects at this time.

The divergence from the SIF format is in the support for Result Sets which have no SIF equivalence.

The basic rules for import are that any artifact that your import is dependent on must exist before the import can succeed.

So for the following result import to work

Result

Grade Set

Result Set

Student

Date

A

1

2

3

29/02/2010

 

  • Grade set 1 must exist
  • Result set 2 must exist
  • Student 3 must exist
  • The date must be valid
  • The result must be a valid grade on the import date.

Real time versus scheduled transfers

 There must be a balance between real time and annual transfers of data.  It is possible to approach real time exchange but this may add significant loads at both ends if not done well.

A model where a scheduled application asks say a VLE service ‘have you got data transfer requests’ is likely to be optimal. 

Scheduled application runs every 5 minutes on a suitable server.

Scheduled application checks to see whether it is already running and exits if it is.

Schedule application makes a web service call to the VLE – what requests do you have.

Scheduled application gets a list of jobs

              For each job

                           Scheduled application invokes a web service to request the job details.

                           Scheduled application runs job.

                           Scheduled application invokes web service with data returned and /or errors

This mechanism minimizes data exchange to that demanded solely by the task requested. It also allows for the sender to understand in basic terms if a job has succeeded or possibly why it failed.

WARNING

Partners need to be aware that validation messages are unlikely to be passed to the user responsible in real time and in a way that is clear and unambiguous to the user.  It is therefore critical that marks are validated at the point of entry and hence reduce errors (or at least restrict errors to those that can be fixed automatically – i.e. by retransmission.

When can marks be exchanged (and what shouldn’t be)?

It is important that Partners consider the traceability of marks.  If we assume for example that the PE department had a grade set:

Grade

Meaning

A

 

B

 

C

 

M

Excused Swimming (Period)

I

Excused Medical

P

Pregnant Pupil

Z

Forgot kit

 

Whilst it could be argued that these are inappropriate, nothing stops a school from creating something similar.

Publishing the fact that a pupil is/was pregnant to parents would breach the data protection act and be highly risky from an ESS / Partner perspective.  In this case, SIMS has done nothing wrong and SIMS Learning Gateway will only publish to parents, results marked for publication.

It is the opinion of ESS that Partners should exercise caution when exporting marks from SIMS.  We would recommend that marks are only exported at the request of a member of staff and that all such requests are logged.  In that way the erroneous display of this type of information can be shown to be at the user’s specific request which then clearly renders the fault with the school rather than the computer systems.  

Partners are also advised to make schools fully aware and in control of any data exported from SIMS.  Particular care must be taken with data intended to be shown to students or parents.  Partners are advised to make the school and their users fully aware that they need to manage the export and publication of MIS data and that they are responsible (demonstrably so) for any such export. Consideration should be given to including warnings on screen, in documentation and in any EULAs.

 

During training ESS staff will remind partners of these potential issues and the need to attribute exports to known users.  By virtue of ESS’s market position, we are unable to ‘prevent’ data export and/or record why it was shared.

Further Guidance for Schools

The mechanisms provided for partner data exchange in the assessment area do not include mark sheets or templates.  In SIMS the only way that marks are effectively used is via the mark sheet paradigm.  Partners are therefore advised to remind schools of the need to create templates and mark sheets for results imported from partners. 

Whilst it is theoretically possible to use SIMS business objects to create templates and mark sheets, they are relatively complex and rely upon the provider having all of the additional information available to enable creation and update.  We would recommend that schools assessment coordinators manage the creation of templates and mark sheets because they should be aware of the data being imported.