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

internal ID for a grade

AssessmentScaleId

Edm.Int32

false

internal ID for a scale

AssessmentGradeTitle

Edm.String

grade title

PercentFrom

Edm.Double

false

percent left range

PercentTo

Edm.Double

false

percent right range

OrderPosition

Edm.Int32

false

order in the assessment scale

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 ) 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
}
]
}