myCourses Batch Assignments From a CSV File

This article describes how to upload multiple assignments at once using a Microsoft Excel CSV (comma separated values) file.

Issue

Using the myCourses UI (User Interface), assignments must be manually entered individually.

Discussion

Many Instructors have lists of assignments or can extract assignments from gradebooks used in prior semesters. myCourses also offers a method for importing those assignments in a batch using a CSV file.

Solution

  1. Select your course and click Grades on the course menu.
  2. Click Export (top-right), then click Current.
  3. Follow the prompts presented by your browser. (You are downloading a .csv file from myCourses in the proper format.)
    1. Here is a link to the myCourses guides for additional details about downloading scores from the gradebook.

      https://community.canvaslms.com/docs/DOC-2849

  4. Open the Excel file you just saved to your computer and add columns for each assignment you want to create. (If you already have an Excel gradebook, you can paste the assignments.) Do not change the file name when you save your updated file.
    1. Here is a link to the myCourses guides for additional details about uploading scores to the gradebook.

       https://community.canvaslms.com/docs/DOC-2850

  5. Back in the myCourses gradebook, click Import (top-right). You will be prompted to choose a CSV file to upload, browse for the file you saved in step 4 and click the blue Upload Data button.
  6. Follow the prompts presented in myCourses (usually asking if a particular assignment is new and how many points should be assigned.) Then click Continue.
  7. You will be presented with a screen asking to change student grades from a certain value to a desired value. You can just click Save Changes without doing anything else.
  8. The new assignments will populate the syllabus and gradebook.

Please note that you will have to assign due-dates as desired.

 

Need additional help?

Please Fill out the myCourses webform with as much detail as possible?

 

 

Custom Fields
  • Application: Canvas
  • Department: Teaching & Learning Platforms
Attached Files
There are no attachments for this article.
Related Articles RSS Feed
myCourses: Assignments User Guide
Viewed 471 times since Tue, Apr 17, 2018
myCourses - Using the Late Submission Policy in the Gradebook
Viewed 563 times since Wed, Jul 25, 2018
myCourses - Rubrics Overview
Viewed 512 times since Wed, Feb 21, 2018
myCourses Sample Courses
Viewed 1450 times since Fri, Oct 30, 2015
myCourses - Add Student to Course
Viewed 1110 times since Tue, Dec 6, 2016
myCourses Course Access Post Term FAQ
Viewed 1495 times since Mon, Jan 25, 2016
myCourses Support and Technical Help for Instructors
Viewed 3111 times since Thu, Aug 20, 2015
myCourses - Add Guest Lecturer to your course
Viewed 1314 times since Fri, Jun 3, 2016
myCourses - How to create a Module
Viewed 401 times since Mon, Feb 19, 2018
myCourses support and technical help for students
Viewed 1652 times since Thu, Aug 20, 2015
MENU