Capstone Project Wiki

The following checklist describes the actions to be done prior to submitting grades.

1. Get ICA scores submitted by coaches
   1. Pod instructors need to follow up with the coaches in their pods
   2. Submission status can be checked at Individual Contribution Scores Submitted (available from Reviews, Submissions & Evaluations → My Pods → My Pod Individual Contributions). Typing “Midterm” or “Final” into the Assignment box will let you see only one of the submissions.
   3. Once all scores are submitted, they can be transferred to Learning Suite by the following
      1. Download a CSV file of the scores at https://byucapstone.byu.edu/all-contribution-scores/export/all/scores.csv
      2. Open the CSV file in Excel, and create a pivot table with NetID as the row label and Assignment as the column label
      3. Copy the data from the pivot table into a new workbook with Paste Special/Values
      4. Save the new workbook as a CSV
      5. Use the new workbook to upload the scores to Learning Suite from Grades/Import

1. Get final Coach and Peer Evaluation scores entered
   1. Paula has CSV files for the Coach and Peer Evaluations that were submitted
   2. Get the NetIDs from those files
   3. Add a 100 for each NetID in the file
   4. Save them as a CSV
   5. Import the results to Learning Suite

1. Get Final Report grades submitted by grading coaches and (if necessary) instructors
   1. Pod instructors need to follow up with the coaches in their pods
   2. Submission status can be checked at My Pod Final Evaluations (available from Reviews, Submissions & Evaluations → My Pods → My Pod Final Evaluations)
   3. Instructors grade reports where scores by the two grading coaches differ by 7 points or more
   4. Instructors should NOT enter grades for report where the scores differ by less than 7 points.
2. Give Final Report grades to Kari to place in her LS upload spreadsheet
   1. Grades can be downloaded at https://byucapstone.byu.edu/final-evaluations-by-pod.csv.
   2. An Excel spreadsheet to calculate the final grades is available on Box at Capstone Master/Instruction Materials/Grading Worksheets/Final Report Grade Calculations.xls. Use the spreadsheets as follows:
      1. If it's Winter semester, delete the rows containing the Architecture Review and Fall Design Report scores from final-evaluations-by-pod.csv
      2. Copy columns L through N from Final Report Grade Calculations.xls to
         final-evaluations-by-pod.csv
      3. As necessary, copy the cells down (for more teams) or delete them (for fewer teams)
      4. Copy columns K and L from final-evaluations-by-pod.csv
      5. Paste them special (Values only) to a new workbook
      6. Sort the new workbook by Median (column B)
      7. Delete all the rows with a blank Median value
      8. Sort the new workbook by Team (column A)
      9. Save the new workbook to share with Kari.
      10. Kari will upload the team scores to all the individuals on Learning Suite
      11. After Kari has uploaded the team scores, adjust the team score for the individuals who have less than 70 on ICA.
3. Create a professionalism score for each team
   1. For Fall, this is just the professionalism that the office tracks
   2. For Winter, this includes all the items listed in Learning Suite, plus the professionalism that the office tracks.
   3. Give the scores to Kari to place in her LS upload spreadsheet
4. Make sure all unsubmitted grades are converted to zeros
   1. This is easily done by exporting all grades from Learning Suite, making sure that the Zero all unscored items box is checked, and then importing the exported file.
5. Review the final grades on LS to ensure they make sense
6. Each instructor must submit his or her grades from Learning Suite
   1. Follow all of the instructions; there are a couple of boxes to check to complete the submission