Assessment - measures and attributes

The following measures and attributes are found in the Assessment category in the Data Catalogue:

Name	Type	Definition	Calculation
Answer	Attribute	A text field showing the answer given by a user to a question in an assessment.
Correct Answer	Attribute	Whether or not the answer to a question in an assessment is correct. "True" indicates the given answer is correct, "False" indicates that the given answer is incorrect. If the answer contains "(empty value)" then no answer has been marked as either correct or incorrect. This only works with questions where the user can select an answer.
Assessment Assessable Type	Attribute	The item being assessed. An assessment can be added to chapters, an individual item of content (ChapterItem) or a topic. Assessment scores and passing or failing of an assessment happens at topic level.
Assessment Completion Rate	Measure	The percentage of users who have completed an assessment, out of the total number of users who have access to it (users in the topic community).	(Count of User Ids that have started an assessment where the nr of completed attempts is >0)/ Topic Audience (count of users part of topic community)
Assessment Id	Attribute	The unique identifier for an assessment. Assessments are displayed in the Analyzer tool as the items that are assessed (such as a topic, chapter, or item of content) not an ID.
Assessment Type	Attribute	The type of assessment.
Assessments - Passed vs Attempted	Measure	The percentage of users that have passed an assessment, out of the total number of users that attempted an assessment.	(Count of user ids that have the assessment status "passed") / (count of user ids that have started the assessment)
Number of Assessments	Measure	The total number of assessments.	Count of the unique identifiers for an Assessment
Question Text	Attribute	The text of a question in an assessment.
Question Id	Attribute	The unique identifier for a question that forms part of an assessment.
Answer Type	Attribute	The question type. The following question types can be added to an assessment: One Correct: Only one answer, from the list of possible answers provided is correct. Many Correct: More than one answer, from the list of possible answers is correct. Scale: Select a number on a scale of 1-5 or 1-10. Correct Order: Rearrange a set of answers to appear in the correct order. Variation: The answer that is entered, must match one of the terms in the predefined list. FreeText: Enter a free text answer.
Question Value	Attribute	The value of the question in relation to the whole assessment. For example, if the question is worth 10% of the whole assessment, "10" will be displayed.
# of Attempts	Measure	The number of times users have attempted the assessment.	Count of the unique identifiers for the Assessment template
Assessment Attempt Id	Attribute	Unique identifier of the assessment attempt.
Attempted vs Audience	Measure	The percentage of users that have attempted an assessment, out of the total number of users who are members of the topic community.	(Count of User Ids that have started an assessment)/ (count of users part of topic community)
Average Nr of Attempts to First Success	Measure	The average number of attempts made by the user before successfully passing the assessment.	The average (nr of attempts needed to first success / count of user id's that have attempted an assessment)
Completed Assessment Attempts	Measure	The number of attempts made by users to complete an assessment (Status = Failed or Passed).	Count of Assessment Attempt ID where Status = Failed or Status = Passed
Correct Answers %	Measure	The number of correct answers in an assessment as a percentage of all available answers.	(Count of Answers where Anwer Correct = true)/ (count of Answers)
Failed Assessment Attempts	Measure	The number of times users have unsuccessfully attempted to pass an assessment. (Status is Failed)
Failed Attempts %	Measure	The number of times a user has attempted an assessment and failed it, as a percentage of all attempts.	(Count of Assessment Attempt ID where Status = Failed)/ (count of Assessment Attempt ID)
Highest Assessment Score	Measure	The highest score a user has achieved for an assessment. This is very useful if the user has made multiple attempts.	Max (Assessment Score)
Number of Incomplete Answer %	Measure	The number of incomplete answers in an assessment, as a percentage of all available answers. "Incomplete Answers" are answers that have not been marked as correct or incorrect.	(Count answer where Answer Correct = (empty value))/(count of Answers)
Incomplete Attempts %	Measure	The number of times users attempted an assessment but did not complete it, as a percentage of all attempts. (Status is Incomplete)	(count of Assessment Attempt ID where Status = Incomplete)/ (count of Assessment Attempt ID)
Incorrect Answers %	Measure	The number of incorrect answers in an assessment, as a percentage of all available answers.	(count of Answers where Anwer Correct = false)/ (count of Answers)
Last Assessment Result	Measure	The number of points the user has been awarded for their latest assessment attempt. This will either be displayed as a percentage or the total number of points the user has received. Score = points Result = percentage
Latest Assessment Score	Measure	The total number of points the user has scored in their latest attempt on an assessment.
Number of Attempts Needed to First Success	Measure	The total number of attempts before the user passed the assessment for the first time.
Number of Answers in Assessment	Measure	The total number of answers in an assessment.	Count of answers
Number of Assessment Attempts	Measure	The total number of attempts for an assessment.	Count of Assessment Attempt IDs
Number of Correct Answers	Measure	The total number of answers that have been marked as correct.	count of Answers where Answer correct is true
Number of Questions in Assessment	Measure	The total number of questions available in an assessment.	Question ID count.
Number of Users Answered a Question	Measure	The number of users that have answered a question.	Count of user ids that have submitted an answer to a question
Number of Wrong Answers in Assessment	Measure	The number of answers that have been marked as incorrect.	Number of answers that are marked as "False".
Passed Attempts %	Measure	The number of times users attempted to complete the assessment and passed it, as a percentage of all attempts (Status is "Passed").
Question Score	Measure	The score assigned to a user's answer to a question.
Score	Measure	The overall score (total number of points) a user has received for an assessment.
User's Assessment Status	Attribute	The user's status for an assessment. The following statuses exist: Failed: The user has not passed the assessment. Passed: The user has successfully passed the assessment. Incomplete: The user has not completed the assessment.
Topic Audience	Measure	The number of community members with access to the topic.
Total Failed Attempts as %	Measure	The number of times users attempted to complete the assessment and failed to pass it, as a percentage of all attempts (Status is Failed).	(Count of Assessment Attempt ID where Status = Failed)/ (count of Assessment Attempt ID)
Total Passed Assessments as %	Measure	The number of times users attempted to complete the assessment and passed it, as a percentage of all attempts (Status is "Passed").	(Count of Assessment Attempt ID where Status = Passed)/ (count of Assessment Attempt ID)
Users Attempted	Measure	The number of users that attempted an assessment.	count of user IDs that started an assessment
Users Attempted a Question	Measure	The number of users that attempted to submit an answer to a question that is part of an assessment.	Count of user IDs that answered a question.
Users Failed	Measure	The number of users that failed the assessment.	Count of user IDs where Status = Failed
Users Passed	Measure	The number of users that passed the assessment.	Count of user IDs where Status = Passed