Import AEFIS Assignment Scoring Data using an Excel Template

User Roles: Institution Admin, College Admin, Department Admin, Course Coordinator (if assigned to the Course), Course Section Director, Instructor
Applies to:  Course Sections, Co-Curricular Sections
Outcome: The user will be able to create an assignment in AEFIS of the “Not Managed in AEFIS” type that allows for the uploading of student final scores through an excel spreadsheet template.  Then the user will learn how to export/import the scoring spreadsheet for this type of assignment.
Description: Assessment of student learning may take place in several different venues outside of the AEFIS managed assignments and your Learning Management System.  This assignment type allows the user to upload a spreadsheet containing the final scores for enrolled students in a course section.

Part One: Create “Not Managed in AEFIS” Assignment 

Quick Video (no sound)

Step 1: Navigate to the Course Section or Co-Curricular Section either by clicking the blue pencil next to the section in the My Course Sections and Syllabi Widget (Course Section Directors & Instructors) 

mceclip0.png

or by searching for the section in the Course Sections manager, which you may access through the Main Menu:
mceclip1.png

Step 2: Navigate to the Assignments menu in your Section, and click the blue Add Assignment button
mceclip2.png

Step 3: Follow the wizard instructions to enter an Assignment Name, Assignment Description, Maximum Score and then choose “Assignment not Managed in AEFIS” from the Assignment Type drop down menu:

mceclip3.png

You will then see the assignment date options disappear.  You do not need to select a Rubric Visibility option so you can skip that drop-down menu.

Step 4: Click the blue Save button 
mceclip4.png

Step 5: You will then see your Assignment not Managed in AEFIS display in the Assignments list:

mceclip5.png

Part Two: Importing Scores for an Assignment not Managed in AEFIS using the Excel Scoring Template

Quick Video (no sound)

Step 1: After the Assignment not Managed in AEFIS is created in the section, you may navigate to the Assignment Scoring drop-down menu at the top right of the Assignments page to retrieve the scoring template:

mceclip6.png

Step 2: From the Assignment Scoring drop-down menu, select “Download Scoring Template”

mceclip7.png

Step 3: Select the Assignment you would like to download a scoring template for by checking the box next to the assignment name, and click Next:
mceclip8.png

Step 4: Click the Download icon to export the scoring template:

mceclip9.png

Step 5: The excel template will download.  You may then add the student scores in the column under the name of the exam and save the document:

mceclip10.png

Step 6:  Return to the Assignments page in your section and click the Assignment Scoring drop-down menu and select “Import Scoring Template” from the list:

mceclip11.png

Step 7: Click on Select File and upload on the Assignment Template Import wizard that appears:
mceclip12.png

Step 8: Select the Scoring Template file you just updated with student scores.  It should have a title like this:  mceclip13.png

Step 9: The system will verify that the file is valid and ready to import.  If all items have a green check mark next to them, you may click next:

mceclip14.png

Step 10: Click the Import template data icon to import the scores:
mceclip15.png

Then click Yes, Continue and Import My Data on the next screen:
mceclip16.png

Then click Finished to complete the process:
mceclip17.png

Step 11:  On the Assignments page, you will now see that 100% of students were scored, and 0% of students submitted artifacts, as students do not submit work/artifacts for the Assignment not Managed in AEFIS Assignment Type:

mceclip18.png

To link your scored assignment to Outcomes, please see the guide below:
Linking Assignment not Managed in AEFIS to AEFIS Outcomes

It's Your Academy. Help us improve it!
Your feedback is vital to help build the best Academy
— and our community deserves it!

Recent Favorites

View your most recent favorited blogs, resources, events and content hubs.

It's Your Academy. Help us improve it!

Your feedback is vital to help build the best Academy
— and our community deserves it!

  • Hidden
  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.

It's Been A Year...

Welcome to AEFIS Academy!

Here is what’s driving us to do it and why…