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 [2022/12/20 15:16] cds4byu [Stage Approvals] |
help-wiki:final_grades [2023/10/25 18:15] (current) dbradyr [Individual Contribution Assessment] |
||
---|---|---|---|
Line 10: | Line 10: | ||
- Create a pivot table with Team number as the row label, Stage as the Column Label, and Maximum of Approval Points as the Values entry | - Create a pivot table with Team number as the row label, Stage as the Column Label, and Maximum of Approval Points as the Values entry | ||
- Copy the pivot table to a new workbook as values only. | - Copy the pivot table to a new workbook as values only. | ||
- | - Save the workbook as a CSV | + | |
+ | - Change the '' | ||
+ | - Delete the '' | ||
+ | | ||
- Send the saved workbook to Kari to convert them from Team to Individual scores | - Send the saved workbook to Kari to convert them from Team to Individual scores | ||
- In the future, we may want to use Learning Suite Team Assignments, | - In the future, we may want to use Learning Suite Team Assignments, | ||
Line 31: | 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 36: | 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 | + | - 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 | ||
Line 48: | Line 56: | ||
- Save them as a CSV | - Save them as a CSV | ||
- Import the results to Learning Suite | - Import the results to Learning Suite | ||
+ | |||
+ | ==== Online Evaluation Extra Credit Scores ==== | ||
+ | As long as the online evaluation has been created a a Student Ratings assignment in Learning Suite (see [[https:// | ||
==== Final Report Grades ==== | ==== Final Report Grades ==== |