Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

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.

Formal Assessment1johndoeRoleuser-- Fuse--.-- users' , 2DoeCommunity

Profile fields (eg Department)

community where the topic exists1Community community where the topic exists CommunityDate created topic 11-2021 topic topic , 11-2021- topic.53-2021 statuspassed passed (s) in the topicfailed attempted and failed (s) in the topicNot started started the topic but has not yet attempted (s) in the topicRaw Score on the assessment weighted 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.

Nr of completed has answered in the assessment2 has 2 has in the assessmentNr of incomplete questions total number of questions the user has failed to provide an answer for.yes

Column

Definition

Example

Attempt id

The unique identifier for the user’s formal assessment attempt.

12345

User id

The unique identifier of the user who has access to the

formal assessment.

12345

Username

The username of the user who has access to the formal assessment.

john.doe

First name

The first name of the user who has access to the formal assessment.

John

Last name

The last name of the user who has access to the formal assessment.

Doe

E-mail

The email address of the user who has access to the formal assessment.

john.doe@fuseuniversal.com

System role

The user's account type.

The following user types are available:

  • User: The user is an ordinary non-admin user.

  • Admin: The user is a site admin with access to the admin panel.

User

Creation date

The creation date of the users' account

1

/1

/2021

Last activity date

The last date the user accessed

the platform.

17

/5

/2021

Deactivation date

The date the user’s account was deactivated

(if applicable)

19

/5

/2021

Time zone setting

The

user’s 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.

Manager last name

The last name of the user’s manager.

33344

Manager first name

The first name of the user’s manager.

Jane

Info

If the user has multiple managers, the IDs are separated by a semi colon. For example: 33344;28719

Manager username

Username of manager

jane.doe

Info

If the user has multiple managers, the usernames are separated by a semi colon. For example: jane.doe; jon.doe

Manager e-mail

The e-mail address of the user’s manager.

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.
(values of the field are either in the table profile_field_values, or profile_field_options)

Sales

jane.doe@fuseuniversal.com

Info

If the user has multiple managers, the emails are separated by a semi colon. For example: jane.doe@fuseuniversal.com;jon.doe@fuseuniversal.com

Community id

The unique identifier of the community where the topic containing the assessment exists.

12345

Community name

The name of the community that contains the topic that the assessment is attached to.

Sales Enablement Community

Topic id

The unique identifier of the

topic the assessment is attached to.

12345

Topic name

The name of the

topic the assessment is attached to.

Sales Enablement

Programme

Assessment id

The unique identifier of the Assessment id.

12345

Assessment creation date

The date the

formal assessment was created.

08-

07-2016 12:14:38

Last updated date

The date the

formal assessment was last edited.

Info

If the

formal assessment has never been edited

; the creation date is displayed instead.

08-

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:

  • not started: The topic is available to the user via the community, but the user has not completed any of the items in the topic.

  • in progress: The user has only completed some of the items in the topic.

  • completed: The user has completed all items in the topic
     

Note: If items are added to the topic after the user completes it, the user’s status remains “completed” in the report. 

completed

07-2016 12:14:38

Start date

The date the user started the formal assessment. This is as soon as the user views the first question (clicks Start assessment).

09-07-2016 12:14:38

Completed date

The date the user passed

/completed the

assessment

09-

07-2016 12:14:38

Assessment user status

The user’s status for the formal assessment

.

The available statuses are:

  • Started: The user has

  • started but not finished the formal assessment

  • .

  • Passed: The user has

  • passed the formal assessment

  • .

  • Failed: The user has

  • attempted and failed the formal assessment

  • .

passed

Assessment completion date

The date the user passed the assessment.

3-3-2021

Passed

Raw score

The total number of points the user has scored in their latest attempt

.

Info

This score is weighted by the platform and not

manually by the formula set up in the formal assessment settings.

10

Assessment result

The

100%

Nr of attempts

The total number of attempts from the user for the assessment.

1

user’s assessment result, shown as a percentage.

Info

The result is shown as a percentage at all times, irrespective of the settings selected when the formal assessment was created.

100%

Attempt count

The attempt number.

For example, of this is the user’s first attempt, 1is shown, if it is their second attempt, 2 is shown, and so on.

2

Total questions

The total number of questions the user

was required to answer.

5

Nr of correctly answered questions

The total number of questions in the assessment that the user

answered correctly.

4

Nr of incorrectly answered questions

The total number of questions the user

answered incorrectly

.

1

Question type

The

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

type of question defined by the assessment:

  • One correct

  • Many Correct

  • Scale

  • Ordering

  • Variation

Question id

The unique identifier for a specific question in the formal assessment.

12335