From CLEW Wiki
In this article:
- Examples Using Feedback Tool
- What the Feedback Tool is Capable Of
- Key Concepts and Considerations
- Create a .csv File for Import into Feedback
- Add Feedback to the CSV File (Rubric Example)
- Import Feedback File
- Updating a Posted Feedback File
- Deleting a Posted Feedback File
- To View the Entire Posted File
- To View Feedback for a Single Participant
- Feedback FAQ
The Feedback tool is useful for securely providing any type of information to individual students by importing the information from a .csv file into CLEW in Sakai. While you can provide feedback using the Gradebook and Assignments, the Feedback tool provides other opportunities to distribute information.
Examples Using Feedback Tool
- One example might be to display weekly progress comments to students.
- One instructor reports that it is an effective way to share a grading rubric with the students.
- Another instructor uses it in conjunction with Gradebook. They report weekly lab grades in Feedback, and then using formulas calculated in the spreadsheet (outside of CLEW) they drop the two lowest lab grades. The total result is then used as one "Lab" mark reported and imported back into Gradebook (note spreadsheet must be formatted properly to import back into Gradebook).
- A project site leader might use Feedback to give feedback to members about their contributions to a report, share feedback from other members, and provide and track specific goals for each individual.
- An instructor uses Feedback to update students about their performance in class, which might include scores, percentages, letter grades, and/or comments.
What the Feedback Tool is Capable Of
Using the Feedback tool, you can upload a comma delimited (CSV) spreadsheet to present feedback to site participants.
Feedback provides the following functionality:
- Display a participant's individual feedback to that participant,
- Display all participants' feedback to the site leader
- Allow the site leader to view a single participant's feedback
- Calculate and display simple statistics for any numerical data
- Update an existing feedback file
- Upload more than one feedback file
Feedback Post Grades Basics
Feedback Key Concepts and Considerations
Spreadsheet formatting: For a spreadsheet file to be compatible with Feedback, it must be:
- Saved in .csv format
- The first column must contain UWin ID's in lower case, and
- The first row must contain headings. Other data cells may contain text or numerical values.
- When you update an existing feedback file, this will overwrite the original Feedback posting and reset the Last Checked column to never, so you will lose the tracking of when a participant has viewed their feedback when you update the file.
Create a .csv File for Import into Feedback
- Click Gradebook
- Click All Grades
- Click Export as CSV at the upper right corner of the screen.
Note: You may need to delete columns if there are already entries in the Gradebook (except the first one containing the UWin ID) to prepare for the information you want to display in the current Feedback file you want to work on.
- Click Roster
- Click Export at the upper right corner of the screen.
- Delete the first column "Name." The second column "User ID" is the one that needs to be first for a Feedback file. You can also delete the Email Address and Role columns if you wish as that is redundant information. Then insert your column heading(s) containing what you wish to give feedback on, and the enter data in the corresponding rows/cells for students or participants.
Add Feedback to the CSV File (Rubric Example)
- Open the file you downloaded from one of the above sources. The file will be displayed in MS Excel. There will be columns other than the student username and student name. You can delete those.
- To use this tool as a grading rubric for an Assignment, label each column with a part of the rubric. For example, Citation 10%, Grammar 10%, Position Statement 15%, Support for Position 25%, Evidence and Examples 25%, Closing Paragraph 15%, Total Grade 100%.
- Enter your comments beside each student's name for each of these topics. You can also include the points awarded for each item.
- Save the spreadsheet with a name that identifies it as your Feedback spreadsheet, and save as a .csv (see inset images Excel Save As and Save as .csv to right).
- When you save, you will get a warning saying that the file may contain features that are not compatible with CSV. Answer Yes to that warning.
- Close the file
Import Feedback File
- Click Feedback in the left menu bar.
- Click Add at the top of the screen.
- "Title" - Enter a descriptive title (maximum length is 30 characters), such as "Rubric for Assignment 1"
- Click Choose File
- Locate the file and double-click it.
- If you want this Feedback released immediately (i.e., allow your students to see the grades, or participants to see your comments), check the "Release feedback to participants?" box.
- Click Post or to cancel, click Cancel.
- On the "Verify Upload" page, you will see a sample of how the file will appear. To continue and post the file, click Save. To return to the upload screen, click Back.
To upload additional files, repeat the instructions above.
Updating a Posted Feedback File
Once you have a Feedback item in the system, you can update it rather than adding new feedback.
- Click "Update" (not Add this time) beside the Feedback item.
- Browse for your updated .csv file. This will overwrite the original Feedback posting and reset the Last Checked column to never, so you will lose the tracking of when a participant has viewed their feedback when you update the file.
- If you wish to release the feedback to participants (i.e., allow the students to see the grades), check Release feedback to participants? . This option may already be selected based on the original file.
- To save your file, click Post; to cancel, click Cancel.
- On the Verify Upload page, you can preview how the file will appear. To continue and post the file, click Save. To return to the upload screen, click Back.
Deleting a Posted Feedback File
- Find the file you want to delete, and click Delete.
- To confirm the deletion, click Delete. To cancel the deletion, click Cancel.
Viewing Feedback in a Posted File
Instructors and assistants can view feedback in the entire posted file or the feedback for an individual participant.
To View the Entire Posted File
- Find the file to view, and click View. The contents of the posted file will appear. Names of participants who have not checked their feedback will appear in red.
- Under "Last Checked", you can see the last time participants checked their feedback.
- To return to the main Feedback screen, click Back.
To View Feedback for a Single Participant
- Find the appropriate file, and click View Participant.
- Use the drop-down list to select a participant. You'll see the feedback as it will appear to that person.
- To return to the main Feedback screen, click Back.
FAQ – Feedback
How do I . . .?
Upload to Feedback?
Be sure to "Save". Once you've selected a file to upload in the Feedback tool and clicked Post, you will receive a verification screen. You must click the Save button or your upload will not be saved to your site.
The CLEW Team has added some helpful text to the verification screen to remind you to please press the Save button below to save the upload.
When you upload your grades file in the Feedback tool, make sure you place a check mark beside Release feedback to participants? If you don't, your students will not be able to see their grades.