Import Polling @ McGill participation results into myCourses
Slido is the Polling @ McGill tool. You can create a participation report based on your Slido event and upload the results into the Grades tool in myCourses. This article lists two ways of importing participation results from Slido into myCourses using either the Joined participants data or Poll results per user data.
Both methods follow the general steps below:
Export your class list from myCourses
Download your Slido participation results.
Merge the myCourses classlist and the Slido participation results into the corresponding Excel template (automatically calculating participation).
Save and import to myCourses.
Export participation data from Slido
Select your Slido Event.
Go to the Analytics tab.
Click Export.
Click Download exports.
There are two sets of data you may want to download from Slido:
Select Joined participants to get a list of students that joined the Slido event.
Select Poll results per user to get the responses from each participant to Polls and Quizzes for the Slido event.
Export classlist from myCourses
On the Course Home, click Grades on your navigation bar.
On the Enter Grades page, click Export.
Under Key Field, select both.
Under User Details, select Email.
Under Choose Grades to Export, ensure no Grade item is selected.
Click Export to CSV.
Import results into myCourses (joined participants)
Watch the tutorial for importing participation data from Slido into myCourses provided by McGill’s Teaching and Learning Services.
This method will not take into account how much the student participated in your polling session. It will only take into account if they joined the session. If you wish to take into account participation please see Import results into myCourses (poll results per user)
The steps below explain how to use the provided Excel template to pull participation results from Slido and import them into myCourses using the Joined participants list from Slido.
Export your classlist from myCourses.
Open the Excel template.
The Excel template has four sheets: Instructions, Slido Export, myCourses Classlist, myCourses Grades.
Copy the OrgDefinedID, Username and Email columns from your classlist (including the headers) into the top-left corner of the myCourses Classlist.
Copy the Joined participants list into the top-left corner of the Slido Export sheet.
In the myCourses Classlist sheet, drag down the formula in the Participation Points Grade and the End-of-Line Indicator columns to apply it to all rows of your classlist.
Copy the values from the myCourses Classlist sheet columns (including the headers) into the myCourses Grade sheet.
Optional: If importing multiple polling sessions repeat steps 4 and 5 for each additional polling session, copying the Participation Points Grade column into a new column in the myCourses Grade sheet before the End-of-Line Indicator column.
Go to the myCourses Grade sheet.
Save the spreadsheet as an MS-DOS .csv (Comma delimited) file and confirm that you want to keep the file format.
Follow these instructions for importing a spreadsheet into myCourses.
Import results into myCourses (poll results per user)
Watch the tutorial for importing participation data from Slido into myCourses provided by McGill’s Teaching and Learning Services.
The steps below explain how to use the provided Excel template to pull participation results from Slido and import them into myCourses using Poll results per user list from Slido.
Export your classlist from myCourses.
Open the Excel template.
The Excel template has four sheets: Instructions, Slido Export, myCourses Classlist, myCourses Grades.
Optional - Change the minimum participation by going to cell C24 in the Instructions sheet and changing the percentage. By default it is 70%
Copy the OrgDefinedID, Username and Email columns from your classlist (including the headers) into the top-left corner of the myCourses Classlist.
Copy the Poll results per user list into the top-left corner of the Slido Export sheet.
In the myCourses Classlist sheet, drag down the formula in the Participation Points Grade and the End-of-Line Indicator columns to apply it to all rows of your classlist.
Copy the values OrgDefined ID, Participation Points Grade, and the End-of-Line Indicator columns (including the headers) into the myCourses Grade sheet.
Optional: If importing multiple polling sessions repeat steps 5 and 6 for each additional polling session, copying the Participation Points Grade column into a new column in the myCourses Grade sheet before the End-of-Line Indicator column.
Go to the myCourses Grade sheet.
Save the spreadsheet as an MS-DOS .csv (Comma delimited) file and confirm that you want to keep the file format.
Follow these instructions for importing a spreadsheet into myCourses.
Learn more:
Slido documentation
TL KB articles:
Slido and myCourses tutorials (TLS Youtube channel)
Have a question that was not answered in this article? Visit our FAQs.
While this resource is accessible worldwide, McGill University is on land which has served and continues to serve as a site of meeting and exchange amongst Indigenous peoples, including the Haudenosaunee and Anishinabeg nations. Teaching and Learning Services acknowledges and thanks the diverse Indigenous peoples whose footsteps mark this territory on which peoples of the world now gather. This land acknowledgment is shared as a starting point to provide context for further learning and action.
McLennan Library Building 3415 McTavish Street Suite MS-12(ground level), Montreal, Quebec H3A 0C8 | Tel.: 514-398-6648 | Fax: 514-398-8465 | Email: tls@mcgill.ca