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 [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+  - Delete the first row 
 +  - Change the ''Row Labels'' value to ''Team'' 
 +  - Delete the ''Grand Total'' column 
 +  - Save the workbook as a comma separated values (NOT CSF UTF-8 comma separated values) 
   - 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, so we don't need to use the Team to Individual score converter that Kari has.   - In the future, we may want to use Learning Suite Team Assignments, so we don't need to use the Team to Individual score converter that Kari has.
Line 31: 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 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://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+      - 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
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://softwaresupport.byu.edu/learning-suite/instructor/assignments/specialized-assignment-types]]), the online evaluation scores will automatically be added to Learning Suite without the instructors doing anything.
  
 ==== Final Report Grades ==== ==== Final Report Grades ====
help-wiki/final_grades.1671574608.txt.gz · Last modified: 2022/12/20 15:16 by cds4byu