So you’ve learnt how to mark a course as completed for an individual, here’s a reminder.
Imagine you’ve just created a new course and decided that not everyone has to complete it from scratch. And what if there are literally hundreds of people to update?
The good news is that you just need to prepare a CSV file that will do the heavy lifting for you! The better news is that there are just 3 columns of data in it:
The course code for the new course
The username of the person to force pass
The date that you want the reporting to show when they “passed” the course
… and it looks like this:
Here’s a quick way to get the information for this file.
Step 1 – get your data for the “old” course by using Analyse overall performance to download an unfiltered data with dates report:
It’s important that you pick the “(with dates)” version.
Open up your unfiltered data (with dates) report and use the username field and the data column for the old course to populate the new “forced pass import csv file”:
Hopefully you can see from the above that the “date” data from the “old course code” column becomes the “Date passed” data for the new course.
When you’ve created your new “forced pass import csv file” save it as a csv file (this is important):
Now you should switch off your old course because we don’t want anyone else completing this course when we’ve just created our list of forced passes!
Go to Courses … Overview:
Search for and edit your new course:
… and make it unavailable by removing the tick:
Make sure that your new course is available! - if you don’t complete this crucial step then when you try and import your forced passes CSV file, it won’t actually do anything:
Step 2 – prepare to upload your CSV file
From your dashboard select Courses … Overview and for your chosen course pick Complete Courses for Many:
Now you can pick Choose file
When the file has imported, it’ll tell you and give you a chance to upload another file (useful if you’re preparing files in batches of, say, 500 to 1,000 records at a time):
You’re almost there, all you need to do now is…
Step 3: Assign your new course to the relevant learning profiles and any rules you’ve created using Link attributes to Courses.
It’s always best to do this after you’ve completed the forced passes so that you don’t enable a learner to start a course from scratch that you’re going to force pass anyway.