Capstone Project Wiki

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

There are points provided for achieving stage approval. In order to have these points properly awarded, we need the following:

1. Develop a view that exports the status of each stage approval (1 for approved, 0.5 for conditionally approved, 0 for waiting for approval).
2. Develop a workbook that converts the status to a score
3. Send the scores to Kari to convert them from Team to Individual scores
4. Right now, we don't track approval status closely enough, so we will just give teams all 1 point for each approval.
5. 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.

1. Each instructor needs to score the exam questions to which they have been assigned
2. After all the scores have been entered, make sure that all of the grades have been accepted by Learning Suite
   1. Go to the Exam List
   2. Click on the Score button for the exam
   3. Click on the Results Menu at the left-hand side of the page
   4. Click on the Question Details sub menu
   5. If there are any scores not entered on a particular question, the Question Details page will say
      Some scores not entered (Score now) for that question
   6. To find the score that you have missed, go to the Results menu, choose the Exam Summary submenu, and click on the Export Student Answers button. This will give you a CSV containing the answers and the scores. Look for answers that have a zero score and a non-blank answer. Those are likely the ones you need to score.

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/fall-report-scores.csv or https://byucapstone.byu.edu/final-report-scores.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. Copy columns L through N from Final Report Grade Calculations.xls to the downloaded grade csv file
      2. As necessary, copy the cells down (for more teams) or delete them (for fewer teams)
      3. Copy columns K and L from the downloaded grade csv file.
      4. Paste them special (Values only) to a new workbook
      5. Sort the new workbook by Median (column B)
      6. Delete all the rows with a blank Median value
      7. Sort the new workbook by Team (column A)
      8. Save the new workbook to share with Kari.
      9. Kari will upload the team scores to all the individuals on Learning Suite
      10. After Kari has uploaded the team scores, adjust the team score for the individuals who have less than 70 on ICA.

1. 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. You can export a CSV with all of the columns from Learning Suite to make sure you have all of the items. But you will want to enter only one score per team, rather than one score per student.
   4. Give the scores to Kari to place in her LS upload spreadsheet

1. 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.
2. Review the final grades on LS to ensure they make sense
3. Each instructor must submit his or her grades from Learning Suite
   1. The first instructor to submit will see a Submit button.
   2. The remaining instructors will see a message that grades have been submitted, and will see a Resubmit button.
   3. You must hit the Resubmit button to submit the grades for your section.
   4. Look for the email from the registrars office that your grades have been submitted.
   5. The email asks you to check on AIM for the grades (and gives you a link to do so). Follow the link to make sure.