AssessmentGrade

Overview

Assessment scales can be defined at the customer (site) level by the system administrator and in the course by the teacher. An assessment scale is made up of several assessment grades. They allow a percenage score (PercentFrom, PercentTo) to be shown as a text grade. E.g. 90% to 100% is an 'A'.

Which Assessment Grades are included?

  • This entity includes all the grades which were created in the platform.

Usage in itslearning

Assessment Scales contain Assessment Grades:

images/download/attachments/44599467/1.JPG

Administrators can add and manage these for all all teachers across their organisation.

Teachers can add and manage their personal assessment scale per course under Settings >> Assessment scales. >> Create (add new scale and add in grades). These are reflected in this entity.

images/download/attachments/45495688/image2018-2-7_12_53_17.png

Relationships

AssessmentGrade is linked to:

Diagram:

images/download/attachments/44599467/AssessmentGrade.PNG

Entity Details

Name

Data type

Nullable

Description

AssessmentGradeId

Edm.Int32

false

Id of an assessment grade

AssessmentScaleId

Edm.Int32

false

Id of an assessment scale to which the grade belongs

AssessmentGradeTitle

Edm.String

Grade title

PercentFrom

Edm.Double

false

Percent left range

PercentTo

Edm.Double

false

Percent right range

OrderPosition

Edm.Int32

false

Order of the grade in the assessment scale

T_ModifiedDate

Edm.DateTime

false

Date and time the entity was last modified in data warehouse

SQL Code:


CREATE TABLE [Dwh].[AssessmentGrade]([AssessmentGradeId] [INT] NOT NULL ,[AssessmentScaleId] [INT] NOT NULL ,[AssessmentGradeTitle] [NVARCHAR]( 255 ) NULL ,[PercentFrom] [FLOAT] NOT NULL ,[PercentTo] [FLOAT] NOT NULL ,[OrderPosition] [INT] NOT NULL, [T_ModifiedDate] [ DATETIME ] NOT NULL ) ALTER TABLE Dwh.AssessmentGrade ADD CONSTRAINT PK_AssessmentGrade PRIMARY KEY (AssessmentGradeId);

Request Body

URI
https://reporting.itslearning.com/odata/engine7/AssessmentGrades?$top=10

Response Body - XML

XML response
<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://reporting.itslearning.com/odata/engine7" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices
/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
<id>http://schemas.datacontract.org/2004/07/</id>
<title />
<updated>2017-08-29T12:35:43Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(-1)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(-1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(-1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(-1)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(-1)/UserGr
ades" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">-1</d:AssessmentScaleId>
<d:AssessmentGradeTitle>No grade</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">0</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">0</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">0</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(1)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(1)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(1)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">1</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">1</d:AssessmentScaleId>
<d:AssessmentGradeTitle>A</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">83.33</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">101</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">0</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(2)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(2)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(2)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(2)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(2)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">2</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">1</d:AssessmentScaleId>
<d:AssessmentGradeTitle>B</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">66.66</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">83.33</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">1</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(3)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(3)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(3)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(3)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(3)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">3</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">1</d:AssessmentScaleId>
<d:AssessmentGradeTitle>C</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">50</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">66.66</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">2</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(4)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(4)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(4)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(4)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(4)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">4</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">1</d:AssessmentScaleId>
<d:AssessmentGradeTitle>D</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">33.33</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">50</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">3</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(5)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(5)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(5)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(5)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(5)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">5</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">1</d:AssessmentScaleId>
<d:AssessmentGradeTitle>E</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">16.66</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">33.33</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">4</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(6)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(6)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(6)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(6)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(6)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">6</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">1</d:AssessmentScaleId>
<d:AssessmentGradeTitle>F</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">0</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">16.66</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">5</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(7)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(7)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(7)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(7)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(7)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">7</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">2</d:AssessmentScaleId>
<d:AssessmentGradeTitle>Passed</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">50</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">101</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">0</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(8)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(8)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(8)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(8)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(8)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">8</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">2</d:AssessmentScaleId>
<d:AssessmentGradeTitle>Not passed</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">0</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">50</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">1</d:OrderPosition>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/AssessmentGrades(9)</id>
<category term="Itslearning.Reporting.Data.Models.AssessmentGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(9)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentScale" type="application/atom+xml;type=entry" title="AssessmentScale" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades
(9)/AssessmentScale" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserGrades" type="application/atom+xml;type=feed" title="UserGrades" href="https://reporting.itslearning.com/odata/engine7/AssessmentGrades(9)/UserGra
des" />
<title />
<updated>2017-08-29T12:35:43Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:AssessmentGradeId m:type="Edm.Int32">9</d:AssessmentGradeId>
<d:AssessmentScaleId m:type="Edm.Int32">3</d:AssessmentScaleId>
<d:AssessmentGradeTitle>10,0</d:AssessmentGradeTitle>
<d:PercentFrom m:type="Edm.Double">98.9</d:PercentFrom>
<d:PercentTo m:type="Edm.Double">101</d:PercentTo>
<d:OrderPosition m:type="Edm.Int32">0</d:OrderPosition>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#AssessmentGrades","value":[
{
"AssessmentGradeId":-1,"AssessmentScaleId":-1,"AssessmentGradeTitle":"No grade","PercentFrom":0.0,"PercentTo":0.0,"OrderPosition":0
},{
"AssessmentGradeId":1,"AssessmentScaleId":1,"AssessmentGradeTitle":"A","PercentFrom":83.33,"PercentTo":101.0,"OrderPosition":0
},{
"AssessmentGradeId":2,"AssessmentScaleId":1,"AssessmentGradeTitle":"B","PercentFrom":66.66,"PercentTo":83.33,"OrderPosition":1
},{
"AssessmentGradeId":3,"AssessmentScaleId":1,"AssessmentGradeTitle":"C","PercentFrom":50.0,"PercentTo":66.66,"OrderPosition":2
},{
"AssessmentGradeId":4,"AssessmentScaleId":1,"AssessmentGradeTitle":"D","PercentFrom":33.33,"PercentTo":50.0,"OrderPosition":3
},{
"AssessmentGradeId":5,"AssessmentScaleId":1,"AssessmentGradeTitle":"E","PercentFrom":16.66,"PercentTo":33.33,"OrderPosition":4
},{
"AssessmentGradeId":6,"AssessmentScaleId":1,"AssessmentGradeTitle":"F","PercentFrom":0.0,"PercentTo":16.66,"OrderPosition":5
},{
"AssessmentGradeId":7,"AssessmentScaleId":2,"AssessmentGradeTitle":"Passed","PercentFrom":50.0,"PercentTo":101.0,"OrderPosition":0
},{
"AssessmentGradeId":8,"AssessmentScaleId":2,"AssessmentGradeTitle":"Not passed","PercentFrom":0.0,"PercentTo":50.0,"OrderPosition":1
},{
"AssessmentGradeId":9,"AssessmentScaleId":3,"AssessmentGradeTitle":"10,0","PercentFrom":98.9,"PercentTo":101.0,"OrderPosition":0
}
]
}