...
Column | Definition | Example | |||
|---|---|---|---|---|---|
User id | The unique identifier of the user who has access to the Formal Assessment | 1 | |||
Username | The username of the user. | johndoe | |||
First name | The first name of the user. | John | |||
Last name | The last name of the user. | Doe | |||
The email address of the user. | |||||
Role | The user's account type. The following user types are available:
| user | |||
Creation date | The creation date of the users' account | 1/1/2021 | |||
Last log in date | The last date the user logged in to Fuse (presented with the log in screen). | 14/5/2021 | Last activity date | The last date the user accessed Fuse. | 17/5/2021 |
Deactivation date | The date the user’s account was deactivated. | 19/5/2021 | |||
Time zone setting | The users' time zone as set in their profile. | GMT +1:00 London | |||
Language setting | The user's language, as set in their profile. | en - English | |||
Manager id | The unique identifier of the user’s manager. | 2 | |||
Manager first name | The first name of the user’s manager. | Jane | |||
Manager last name | The last name of the user’s manager. | Doe | |||
Manager e-mail | The e-mail address of the user’s manager. | ||||
Profile fields (eg Department) | The header contains the label of the custom profile field, the field itself contains the value as presented on the UI of the custom profile field. | Sales | |||
Community id | The unique identifier of the community where the topic exists. | 1 | |||
Community name | The name of the community where the topic exists. | Sales Enablement Community | |||
Date created | The date the topic was created. | 1/1/2021 | |||
Last updated date | The date the topic was last edited. If the topic has never been edited, the creation date is displayed instead. | 1/1/2021 | |||
Topic id | The unique identifier of the topic. | 2 | |||
Topic Name | The title of the topic. | Sales Enablement Programme | |||
User’s topic status | The user’s progress status for the topic. The available statuses are:
Note: If items are added to the topic after the user completes it, the user’s status remains “completed” in the report. | completed | |||
Completed date | The date the user passed/completed the topic. | 5/3/2021 | |||
Assessment user status | The user’s assessment status. The available statuses are:
| passed | |||
Assessment completion date | The date the user passed the assessment. | 3/3/2021 | |||
Raw Score | The total number of points the user has scored in their latest attempt on the assessment. This score is not weighted by the formula set up in the assessment settings | 10 | |||
Assessment result | The number of points the user has been awarded for their assessment attempt. The weighting is set by the admin in the assessment settings. The score is either displayed as a percentage or the total number of points the user has received. The user’s score is only displayed as a percentage, if the ‘Show score as a percentage’ option has been selected in the ‘Assessment settings’ tab for the assessment. | 100% | |||
Nr of attempts | The total number of attempts from the user for the assessment. | 1 | |||
Nr of completed questions | The total number of questions the user has answered in the assessment. | 2 | |||
Nr of correctly answered questions | The total number of questions in the assessment that the user has answered correctly. | 2 | |||
Nr of incorrectly answered questions | The total number of questions the user has answered incorrectly in the assessment. | 1 | |||
Nr of incomplete questions | The total number of questions the user has failed to provide an answer for. | 2 | |||
Q1 [question text] | The title should include the question id & text The field itself should include the answer text of the user to the question | field title: “id: 2; you should pick up the phone to call answer: yes | |||
Marked as correct? | yes/no | yes |