Formal assessment report
- James Goodwin
This custom report provides a list of users and their completion status for formal assessments attached to topics. This includes the topic details, such as the topic name and ID, and the assessment details, such as the assessment ID, the user's completion date, raw score, current assessment status (Started, Passed or Failed), and the assessment result, shown as a percentage.
Example: This report can be used to ensure that all users in your organisation have completed and passed assessments in topics that are part of mandatory training (for example, things like vital security, data protection, or food hygiene training), which users may be required to complete in order to work safely and securely at your organisation or within your industry. You might then follow up with any users who have not successfully passed those assessments to ensure that they do. You might also generate this report as proof that all required users in your organisation have passed the assessments and then share it with key members of your organisation, such as management, trainers, auditors, or heads of department so that they are made aware.
Standard fields included in the report
The following standard fields are included in this report:
Notes:
The fields listed below are standard fields that cannot be removed from this report.
The list below does not include any custom profile fields that may be included in the report that are specific to your organisation or fields that can be added optionally during creation. For example, your organisation may have custom fields such as Location, Department, or Job Title that can be included in this report.
Column | Definition | Example |
|---|---|---|
User id | The unique identifier of the user who has access to the topic with the formal assessment. | 12345 |
Community id(s) | The unique identifier of the community where the topic exists. | 12345 |
Community name(s) | The name of the community where the topic exists. | Sales Enablement Community |
Topic id | The unique identifier of the topic with the formal assessment. | 12345 |
Topic name | The name of the topic with the formal assessment. | Sales Enablement Programme |
Assessment id | The unique identifier of the formal assessment in the topic. | 12345 |
Assessment creation date | The date and time the formal assessment was created in the topic. | 08-07-2025 12:14:38 |
Last updated date | The date and time the formal assessment in the topic was last edited. If the formal assessment has never been edited; the creation date is displayed instead. | 08-07-2025 12:14:38 |
Start date | The date the user started the formal assessment. This is as soon as the user clicks Start assessment and views the first question in the formal assessment. | 09-07-2025 12:14:38 |
Completed date | The date and time the user passed/completed the formal assessment. | 09-07-2025 12:14:38 |
Assessment user status | The user’s status for the formal assessment.
| Passed |
Attempt id | The unique identifier for the user’s formal assessment attempt. | 12345 |
Raw score | The total number of points the user has scored in their latest attempt. This score is weighted by the platform and not manually by the formula set up in the formal assessment settings. | 20 |
Assessment result | The user’s assessment result, shown as a percentage. For example, if the user has answered all the questions correctly, 100% is shown in this column for that user. | 100% |
Optional fields that can be included in the report
The fields in the Optional fields section are optional and are not included in the report by default. You might add some of these fields so that the report includes more detail. The fields listed below do not include any organisation-specific custom profile fields that may be present in the Optional fields section in your organisation’s version of the platform.
Column | Definition | Example |
|---|---|---|
Username | The username of the user with access to the topic with the formal assessment. | john.smith |
First name | The given name of the user with access to the topic with formal assessment. | John |
Last name | The family name/surname of the user with access to the topic with the formal assessment. | Smith |
The email address of the user with access to the topic with the formal assessment. | john.smith@fuseuniversal.com | |
System role | The account type of the user with access to the topic with the formal assessment: The following user types are available:
| User |
Creation date | The date the user who has access to the topic was created in the platform. | 06-11-2015 14:28:47 |
Last activity date | The date and time the user who has access to the topic last accessed the platform. | 17-03-2023 16:39:11 |
Deactivation date | The date the user who has access to the topic was deactivated in the platform (only if applicable). | 17-03-2023 16:39:11 |
Time zone setting | The time zone of the user who has access to the topic, as set in their profile. | London |
Language setting | The language of the user who has access to the topic, as set in their profile. | en-GB |
Manager id(s) | The unique identifier of the user’s manager(s). | 97735 |
Manager username(s) | The username of the user’s manager(s). | |
Manager e-mail(s) | The email address of the user’s manager(s). | jane.doe@fuseuniversal.com |
Attempt count | The number of completion attempts the user has made for the formal assessment. For example: 1 is shown if a first attempt has been made, 2 is shown if a second attempt has been made, and so on.
| 2 |
Total questions | The total number of questions presented to the user in the formal assessment. | 20 |
Nr of correctly answered questions | The total number of questions in the formal assessment that the user has answered correctly. | 12 |
Nr of incorrectly answered questions | The total number of questions the user has answered incorrectly in the formal assessment.
| 10 |