Update Scores, Success Status, and Attendance for a Past Live Training Event

by Macz Norton
Follow

After hosting a live training event via Skilljar, you can add scores, update the success status, and mark attendance for each of your students one-by-by-one or via a bulk upload in Live Training.

You can also click on a student name to be redirected to their Student page for easy access to their signup information, domain membership, and enrollment data.

Screen_Shot_2020-06-24_at_7_39_59_PM-2-2.png

 

In this article:

 

Add scores, update success status, and mark attendance

Option 1: One-by-one update

Screen_Shot_2019-04-24_at_10.20.37_AM.png

  1. In the Dashboard left navigation bar, click “Live Training.”
  2. Click the time period toggle and click  “Past events.” The table will show all past live training events hosted in your Skilljar organization.
  3. Click the event name of the live event you want to update.
  4. For each student:
    1. Optional: Add the student’s score and the maximum score.
    2. Optional: Set a success status as Passed or Failed.
    3. Click Mark attended.

Tip: Add the score and success status for a student before marking the student attended. Once you mark a student attended, you must use the bulk upload option to add or change a student’s score or success status.

 

Option 2: Bulk upload

Screen_Shot_2020-06-24_at_8_40_12_PM.png

  1. In the Dashboard left navigation bar, click “Live Training.”
  2. Click the time period toggle and click  “Past events.” The table will show all past live training events hosted in your Skilljar organization.
  3. Click the event name of the live event you want to update.
  4. Click CSV to download the list of registered students for the live training event.
  5. Open the CSV in Excel, Google Sheets, or another spreadsheet tool and prepare the file to upload to Skilljar:
    1. Student names, email addresses, and associated training domain are already populated in the CSV.
    2. In the attended_Y_N column, mark attendance for each student by adding a Y for Attended and a N for Not Attended in the cell.
    3. Optional: In the score column, type the score in the cell for each student. In the max_score column, type the maximum score that each student could have received for the live event in the cell.
    4. Optional: In the status_PASSED_FAILED column, type the success status for each student as PASSED or FAILEDScreen_Shot_2016-08-23_at_9.33.32_AM.png
  6. Once you finish editing your spreadsheet, save the file as a Comma Separated File (.csv).
  7. Click Upload. You are redirected to the Upload CSV page.
  8. Click Choose File or Browse.
  9. Select a file from your file browser.
  10. Click Save. You are directed to the live event page and will receive an email from support@skilljar.com with the subject, 'Your background task is complete!" when the file finishes processing. The email is sent to the email set for your Dashboard user credentials.

 

Frequently asked questions

I get an error message when I try to upload my CSV. How do I successfully upload my CSV?

For successful upload, the file needs to be saved as a comma-separated file (.csv). The file type .csv is used interchangeably for comma-separated files and comma-delimited files, so ensure you’re choosing the correct type when saving your file: comma-separated file. On a PC, comma-separated files are denoted as CSV (Macintosh).

 

I marked a student as attended by accident, and I want to revert this status. How do I do this?

You can download the CSV for the event, then update the attended_Y_N cell, then upload the CSV.:

  • For past events, you need to set the attended_Y_N status as either Y or N, not blank.
  • For future events, you can set the attended_Y_N status as Y, N, or blank, to indicate that the event has not yet occurred.

 

Keep reading

Powered by Zendesk