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.