This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
help-wiki:final_grades [2023/04/11 15:27] dbradyr [Individual Contribution Assessment] |
help-wiki:final_grades [2023/10/25 18:15] (current) dbradyr [Individual Contribution Assessment] |
||
---|---|---|---|
Line 34: | Line 34: | ||
==== Individual Contribution Assessment ==== | ==== Individual Contribution Assessment ==== | ||
+ | - **Instructor first adds the assignment** | ||
+ | - Navigates to [[https:// | ||
+ | - Set the title, following the pattern (like Fall Midterm Individual Contribution) | ||
+ | - Set the school year and due date desired | ||
+ | - Once the new assignment is saved, the scores can be submitted by the coaches | ||
- **Get ICA scores submitted by coaches** | - **Get ICA scores submitted by coaches** | ||
- Pod instructors need to follow up with the coaches in their pods | - Pod instructors need to follow up with the coaches in their pods | ||
Line 39: | Line 44: | ||
- Once all scores are submitted, they can be transferred to Learning Suite by the following | - Once all scores are submitted, they can be transferred to Learning Suite by the following | ||
- Download a CSV file of the scores at [[https:// | - Download a CSV file of the scores at [[https:// | ||
- | - Open the CSV file in Excel, and create a pivot table with NetID as the row label and Assignment as the column label, and Grade as the Values (change Value from Sum of Values to Max of Values) | + | - ii. Open the CSV file in Excel, and create a pivot table (click on Insert on the top tab row, then select all data in spreadsheet, |
- Copy the data from the pivot table into a new workbook with Paste Special/ | - Copy the data from the pivot table into a new workbook with Paste Special/ | ||
- Save the new workbook as a CSV | - Save the new workbook as a CSV |