Instructors may use a comma-delimited (CSV) spreadsheet file to present individual feedback and/or grades to students. This spreadsheet file must follow a particular format:
- Your file must be saved in .CSV format. You can save Microsoft Excel spreadsheets as CSV files.
- The first row of your file must contain column headings; every column must have a heading.
- The first column of your file must contain individuals' usernames in lower case.
Once you have created your file, you can modify and update it as you wish, as long as you stay within the guidelines above.
Tip: You can download a CSV file that includes the student usernames under Gradebook > Import/Export > Export Gradebook. You can also download a CSV file that includes the student usernames under Roster > Export.
Example of a Properly Formatted CSV File
- First row contains column headings.
- First column contains student usernames.
Go to PostEm.
Select the PostEm tool from the Tool Menu of your site.
Note: The PostEm tool is sometimes named Feedback.
Click the Add tab.
Enter a Title.
Enter a Title for the Feedback file. This is the title students will see when they go to PostEm to view their feedback.
Select your file.
Click the Choose a CSV file or URL from Resources button to select your file.
Select your file.
To upload a CSV file from your computer, click the Choose File button to locate the file on your computer and select it for upload. Alternatively you may enter the URL of a CSV file on a website or select a CSV file that you have already uploaded to the Resource tool of your site.
Adjust Feedback Availability and Post.
Check the box next to Feedback Availability if desired, and then click Post.
Verify the upload.
You will be prompted to verify your file upload. The first row of data will be previewed for you. If everything looks correct, click Save; if not, click Back, make changes to your CSV file, and upload it again.