...
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 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 |