Assessment Forms - Import Spreadsheet Method

User Roles: Faculty

Instructions:

1. Click blue pen icon for the course you would like to enter data under My Direct Assessments widget Running Assessments tab. 
   
   
2. Click Import Spreadsheet. 
   
3. Click Yes, visit [Course Section] or click No, create the assignments for me to have the system to create them for you.
   • If you clicked Yes, visit [Course Section], please visit How to Add & Link Assignments page in order to continue.
   • If you clicked No, create assignments for me, please follow steps below:
     • Click No, create the assignments for me
     • Adjust the Rubric setting if needed and click Save.
     • When the page reloads, click on Import Spreadsheet to download the assessment template (Skip to Step 6).
        
       
4. Once all assignments are created, click Yes, import assignments to import your assignments.
5. Click Yes, Continue when the popup dialog opens.
6. Click Download Template. 
   
7. Select a template format you would like to download and click Next.
   
8. Select an assessment method and click Next. 
   
9. Click Download. 
   
10. Click Close when the dialog window pops up.
11. Open the downloaded file and enter scores/rubrics and save.
    *Please Note: Make sure to only copy and paste the data without formatting into the template page (paste values only) - any difference in formatting will not import correctly. 
12. Click Import Template.
13. Click Select File & Upload. 
    
14. Once you select your file and upload, the system will show a status update. Click Next. 
15. Click Import Data. 
    
16. Click Yes, Continue and import my data when the dialog window opens.
17. Click Finished. 
    * Once your file is upload, please click on Using Student Scores tab to see the scores before your submission.
18. After scores are entered, click I'm Finished, Submit at the bottom of the page.