This article will explain the fields included in the Courses CSV reports that are exported from the Course metrics screen.
- Course Progress Summary
- Player Data: Player Course Summary
- Team Data: Course Summary for teams
- Player Data: Task attempts for all players
- If the player navigates away from the challenge/mission without submitting an answer, the time spent is discarded.
- Time spent is the amount of time a player has spent actively playing a challenge/mission. The time is tracked once a challenge has started/resumed and stopped once they submit an answer.
Course Progress Summary
|
Label |
Description |
|
Course Name |
The name of the Course |
|
Description |
Description of the Course (descriptions are added on creation) |
|
Deadline |
The expiration date of the Course (if set). An expiry date is optional |
|
Status |
Course status. This can be Published, Unpublished, or Archived |
|
Created By |
The name of the Company Admin or Team Manager that created the Course |
|
Players Invited |
Number of players invited to the Course |
|
Players Enrolled |
Number of players that enrolled in the Course but haven't completed it yet |
|
Players Completed |
Number of players that completed the Course |
|
Percentage Completed |
The percentage of players that completed the Course |
|
Languages available |
The languages that were available in the Course |
|
Average time spent on Course |
The average amount of time players spent on challenges/missions |
Player Data: Player Course Summary
|
Label |
Description |
|
Player Name |
The name of the player |
|
|
The email address of the player |
|
Team Name |
The name of the team the player belongs to |
|
Tags |
Any tags associated with the players' account |
|
Course |
Course Name |
|
Course Status |
Course status. This can be Published, Unpublished, or Archived |
|
Languages Available |
The languages that were available in the Course. For the player Course summary, there will be a row per language available within the Course per player. |
|
Status (player) |
Course status per player |
|
Status for a language (player) |
Course status per language |
|
First Started Date |
The date the Course was first started |
|
First Completed |
The date the Course was first completed in one of the languages available |
|
Progress |
A percentage of how much of the Course the player has completed |
|
Points |
How many points the player has acquired in the Course |
|
Accuracy |
Individual player Accuracy. Accuracy = (# Correct Challenges /# of attempts) * 100 |
|
Confidence |
Individual player Confidence. |
|
Completed tasks |
Number of tasks completed within the Course |
|
Total Tasks |
Total number of tasks available in the Course |
|
Hints Used |
Number of hints used throughout the Course |
|
Total Hints |
Total number of hints available in the Course |
|
Correct Attempts |
The number of correct challenge attempts |
|
Total Attempts |
The total number of challenge attempts |
|
Total Time Spent |
The total amount of active time spent playing challenges/missions on the Course is measured in hours (h), Minutes (m), and seconds (s) |
|
Videos Watched |
Number of resource videos that were watched throughout the Course |
Team Data: Course Summary for Teams
|
Label |
Description |
|
Team |
Name of the team |
|
Course |
Name of the Course |
|
Players Invited |
Number of players within the team that were invited to the Course |
|
Players Enrolled |
Number of players that enrolled in the Course but haven't completed it yet |
|
Players Completed |
Number of players in the team that have completed the Course |
|
Average progress |
A percentage showing the average Course progress per player in the team |
|
Total Points Earned |
The total amount of points earned by the team |
|
Accuracy |
Accuracy of the team Accuracy is calculated by dividing the number of correct attempts by the total of both incorrect and correct attempts and multiplying that by 100.Accuracy = (# Correct Challenges /# of attempts) * 100 |
|
Confidence |
Confidence of the team |
|
Average Time Spent on Course |
The average amount of active time spent playing challenges/missions on the Course as a team is measured in hours (h), Minutes (m), and seconds (s) |
|
Total Time Spent |
The total amount of active time spent playing challenges/missions on the Course as a team is measured in hours (h), Minutes (m), and seconds (s) |
Player Data: Task attempts for all players
|
Label |
Description |
|
Name |
Name of the player |
|
|
Player’s email address |
|
Status |
User status in Secure code warrior (enabled/disabled) |
|
Team |
The team the player belongs to |
|
Company |
The company the player belongs to |
|
Roles |
The player's role within Secure Code Warrior (User, Developer, Team Manager, Company Admin) |
|
Tags |
Any tags related to the player |
|
Language |
The Language the task has been played in |
|
Challenge Started |
The date the challenge had been started |
|
Course Name |
Name of the course the challenge had been in |
|
Activity Type |
Type of activity within the course (Challenge, Video, Custom) |
|
Category |
Vulnerability Category of the activity |
|
Subcategory |
Vulnerability subcategory of the activity |
|
Difficulty |
The difficulty of the challenge if applicable |
|
Activity Status |
The current progress of the activity |
|
Course Language Status |
Current player status of the course in the selected language (Done, In Progress) |
|
Course Status |
Status of the course (Published, unpublished) |
|
Base Points Earned |
Amount of points earned from the Base points available for the challenge |
|
Bonus Points |
Any bonus points earned for the challenge |
|
Stage 1 Question |
Type of question (only for challenges) Fix the vulnerability, Locate the vulnerability |
|
Stage 1 Status |
Status of Stage 1 (Done, skipped, in progress) |
|
Stage 1 total attempts |
Number of attempts on this stage |
|
Stage 1 Total Hints |
Number of Hints available |
|
Stage 1 Hints Used |
Number of hints used for this Stage |
Note: The stage columns will be repeated for the number of stages in the course
Comments
0 comments
Please sign in to leave a comment.