User Tools

Site Tools


help-wiki:final_grades

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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://byucapstone.byu.edu/node/add/assignment]]
 +    - 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://byucapstone.byu.edu/all-contribution-scores/export/all/scores.csv]]       - Download a CSV file of the scores at [[https://byucapstone.byu.edu/all-contribution-scores/export/all/scores.csv]]
-      - 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, then Pivot Table (top left corner), then New Worksheet, then use NetID as the row label (drag Net ID into the Rows box), and Assignment as the column label (drag Assignment into the Columns box), and Grade as the Values (change Value from Sum of Values to Max of Values)
       - Copy the data from the pivot table into a new workbook with Paste Special/Values       - Copy the data from the pivot table into a new workbook with Paste Special/Values
       - Save the new workbook as a CSV       - Save the new workbook as a CSV
help-wiki/final_grades.1681248467.txt.gz ยท Last modified: 2023/04/11 15:27 by dbradyr