Re-format HelioCampus AC exports of AAE Class Evaluations (Professor)
Step 2 in compiling AAE Professor class evaluations. Involves reformatting the results and putting in a PivotTable
** Be sure to complete Step 1 - Export AAE Results from HelioCampus AC before proceeding to this step **
** For Professor Evaluations - if processing TA evaluations see Re-format HelioCampus AC exports of AAE Class Evaluations (TA) **
- Remove the Top 6 rows of the results Excel document
- Rename Sheet1 to Raw
- Insert-->PivotTable
- Use the default range for the PivotTable - it SHOULD be the entire sheet/table
- In the PivotTable fields dialog, select Question
- Change the following questions to the indicated values:
Original Question New Question Were the classes clearly organized and well prepared? Q06 - Class Organized Were the classes interesting and thought provoking? Q07 - Lectures Interesting How useful were the readings? Q08 - Useful readings How well have the examinations and other assignments measured your knowledge of the course material? Q09 - Exams Indicative How would you rate the difficulty of this course in comparison with your other University courses? Q10 - Course Difficulty How fair were the grading procedures? Q11 - Grading Fair How responsive or helpful did you find the instructor? Q12 - Prof Helpful Would you recommend this course to a friend? Q13 - Recommend Course Overall, how do you rate the quality of the instructor's teaching in this course? Q14 - Prof Quality 
- In the PivotTable fields, click the down arrow next to Question
- Click Sort A to Z
- In the PivotTable fields, click the down arrow next to Question again
- Uncheck any questions that don't start with Q - click OK
- In the PivotTable fields, check Course Code, Instructor Evaluation, and Average
- Down below, drag Question into the Columns area.
- Click the down arrow next to Sum of Average in the Values area and click Value Field Settings
- Select Max in the Summarize value field by and click OK
- Right-click on any course subtotal (such as AAE 215: Total) and uncheck Subtotal Course
- Click on the down arrow next to Course down in Rows. Click Field Settings
- Select the Layout & Print tab, and select Show item labels in tabular form and Repeat item labels. Click OK.
- Right-click anywhere in the PivotTable, and select PivotTable Options
- On the Totals & Filters tab, uncheck both options under Grand Total
- Rename Sheet1 to PivotTable
- Add a New Sheet - rename it to Manual Table
- Highlight the entire PivotTable, EXCLUDING Max of Average and Question, select Copy (Ctrl +C)
- Go to the Manual Table sheet, and Paste Values
- Insert 2 columns between Instructor Evaluated and Q06 - Enrollment and Responses
- Fill in the appropriate values for the enrollment and survey responses for each course/section. This information can be found in HelioCampus AC Course Evaluation Analysis Report Summary (where you originally exported the Excel file in Export AAE Results from HelioCampus AC )
