UserGrade

Overview

This is a fact entity that keeps information about a grade(score) received by a user for completing an assessment. It relates the user who was assessed, with the grade/score given in the context of the course in which the assessment took place.

Which user grades are included?

  • This entity includes all the assessments by teachers.

Usage in itslearning

When a student is assessed in an assignment, test, or other activity the 'Score' is recorded in this entity. This numeric 'Score' can be mapped to a meaningful grade (e.g. A+, Pass, Merit) through the 'AssessmentGrade' relationship. The status of the grade (e.g. completed) is know from the 'AssessmentStatus' relationship. 'UserGrades' are always associated with a course.

The entity includes date submitted by the student and date reviewed by the teacher.

The teacher assignment 'grading' page

images/download/attachments/44599519/image2018-7-16_11_49_41.png

Relationships

UserGrade is linked to:

  • User - the student who was being assessed

  • Course - the course in which the assessment took place.

  • LearningItem - the assessment element (e.g. test)

  • AssessmentGrade - the grade (e.g. A+, Pass, Merit) associated with the score given.

  • AssessmentStatus - status of the assessment (e.g. completed, submitted).

Entity Details

Name

Data type

Nullable

Description

LearningItemId

Edm.Int32

false

Id of a learning item that has been graded

CourseId

Edm.Int32

false

Id of a course the learning item belongs to

UserId

Edm.Int32

false

Id of a user that received a grade

AssessmentGradeId

Edm.Int32

false

Id of an assessment grade

AssessmentStatusId

Edm.Int32

false

Id of an assessment status

Score

Edm.Double

false

Score - points granted to the user

SubmittedDate

Edm.DateTime

Date of answer submission by the user

ReviewDate

Edm.DateTime

Date of review done by a teacher

NumberOfAttempts

Edm.Int32

false

Number of attempts taken

T_ModifiedDate

Edm.DateTime

false

Date and time the entity was last modified in data warehouse

Diagram

images/download/attachments/44599519/UserGrade.PNG

SQL code

CREATE TABLE [Dwh].[UserGrade]([LearningItemId] [INT] NOT NULL ,[CourseId] [INT] NOT NULL ,[UserId] [INT] NOT NULL ,[AssessmentGradeId] [INT] NOT NULL ,[AssessmentStatusId] [INT] NOT NULL ,[Score] [FLOAT] NOT NULL ,[SubmittedDate] [DATETIME] NULL ,[ReviewDate] [DATETIME] NULL ,[NumberOfAttempts] [INT] NOT NULL, [T_ModifiedDate] [DATETIME] NOT NULL )

ALTER TABLE Dwh.UserGrade ADD CONSTRAINT PK_UserGrade PRIMARY KEY (LearningItemId,UserId);

Request body

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

Response body - XML

XML response
<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://reporting.itslearning.com/odata/site" 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" xml
ns: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-30T11:58:09Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades" />
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400022)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400022)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400022)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00022)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400022)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400022)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400022)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400022)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400022</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400023)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400023)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400023)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00023)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400023)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400023)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400023)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400023)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400023</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400024)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400024)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400024)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00024)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400024)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400024)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400024)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400024)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400024</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400025)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400025)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400025)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00025)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400025)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400025)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400025)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400025)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400025</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400026)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400026)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400026)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00026)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400026)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400026)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400026)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400026)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400026</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400027)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400027)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400027)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00027)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400027)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400027)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400027)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400027)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400027</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400028)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400028)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400028)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00028)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400028)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400028)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400028)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400028)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400028</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400029)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400029)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400029)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00029)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400029)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400029)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400029)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400029)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400029</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400030)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400030)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400030)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00030)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400030)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400030)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400030)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400030)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400030</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400062)</id>
<category term="Itslearning.Reporting.Data.Models.UserGrade" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400062)" />
<link rel="self" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400062)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItem" type="application/atom+xml;type=entry" title="LearningItem" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=4
00062)/LearningItem" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400062)/Cours
e" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,UserId=400062)/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentGrade" type="application/atom+xml;type=entry" title="AssessmentGrade" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,Us
erId=400062)/AssessmentGrade" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AssessmentStatus" type="application/atom+xml;type=entry" title="AssessmentStatus" href="https://reporting.itslearning.com/odata/site/UserGrades(LearningItemId=1,
UserId=400062)/AssessmentStatus" />
<title />
<updated>2017-08-30T11:58:09Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:LearningItemId m:type="Edm.Int32">1</d:LearningItemId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:UserId m:type="Edm.Int32">400062</d:UserId>
<d:AssessmentGradeId m:type="Edm.Int32">-1</d:AssessmentGradeId>
<d:AssessmentStatusId m:type="Edm.Int32">-2</d:AssessmentStatusId>
<d:Score m:type="Edm.Double">0</d:Score>
<d:SubmittedDate m:null="true" />
<d:ReviewDate m:null="true" />
<d:NumberOfAttempts m:type="Edm.Int32">0</d:NumberOfAttempts>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/site/$metadata#UserGrades","value":[
{
"LearningItemId":1,"CourseId":7,"UserId":400022,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400023,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400024,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400025,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400026,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400027,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400028,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400029,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400030,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
},{
"LearningItemId":1,"CourseId":7,"UserId":400062,"AssessmentGradeId":-1,"AssessmentStatusId":-2,"Score":0.0,"SubmittedDate":null,"ReviewDate":null,"NumberOfAttempts":0
}
]
}