Re-format AEFIS exports of AAE Class Evaluations (TA)

Step 2 in compiling AAE TA class evaluations. Involves reformatting the results and putting in a PivotTable

** Be sure to complete Step 1 - Export AAE Results from AEFIS before proceeding to this step **

** For TA Evaluations only - if processing Professor evaluations see Re-format AEFIS exports of AAE Class Evaluations (Professor) **

  1. Remove the Top 6 rows of the results Excel document

    Delete top rows

  2. Rename Sheet1 to Raw
  3. Insert-->PivotTable

    Insert PivotTable

  4. Use the default range for the PivotTable - it SHOULD be the entire sheet/table

    PivotTable range

  5. In the PivotTable fields dialog, select Question

    Select Question

  6. Change the following questions to the indicated values:

     Original Question
     New Question
    Overall, what is your assessment of the TA's knowledge of the material related to this course?  Q06 - Class Organized
    Of those sections you have attended, what proportion were interesting and/or thought-provoking?  Q07 - Sections Interesting
    How responsive and helpful did you find your TA during office hours?  Q12 - Prof Helpful
    We know that how the instructor conducts the course often influences what a TA is able to do in a course. Given the instructor's role and the structure of this course, how would you evaluate your TA's performance?  Q14 - Prof Quality

    Change questions

  7. In the PivotTable fields, click the down arrow next to Question

    Arrow next to Question

  8. Click Sort A to Z

    Sort Question A to Z

  9. In the PivotTable fields, click the down arrow next to Question again
  10. Uncheck any questions that don't start with Q - click OK

    Uncheck questions

  11. In the PivotTable fields, check Course, Section, Instructor Evaluation, and Average
  12. Down below, drag Question into the Columns area.

    Drag question into Columns

  13. Be sure that Rows are in the order
    1. Course
    2. Section
    3. Instructor Evaluated

    If not, click and drag them into the correct order.

  14. Click the down arrow next to Sum of Average in the Values area and click Value Field Settings

    Value field settings

  15. Select Max in the Summarize value field by and click OK

    Select Max of Average

  16. If the Instructor Evaluated has "(blank)" included, in the PivotTable Fields click the down arrow next to Instructor Evaluated,scroll to (Blank) and uncheck it

    Uncheck Blank instructor

  17. Right-click on any course subtotal  (such as AAE 215: Total) and uncheck Subtotal Course

    Uncheck SubTotal

  18. Right-click on any Instructor subtotal (such as <NAME> Subtotal) and uncheck Subtotal Instructor Evaluated

    Uncheck subtotal

  19. Click on the down arrow next to Course down in Rows.  Click Field Settings

    Course-->Field Settings

  20. Select the Layout & Print tab, and select Show item labels in tabular form and Repeat item labels.  Click OK.

    Layout & Print

  21. Click on the down arrow next to Section down in Rows.  Click Field Settings

    Section->Field Settings

  22. Select the Layout & Print tab, and select Show item labels in tabular form and Repeat item labels.  Click OK.

    Layout & Print

  23. Right-click anywhere in the PivotTable, and select PivotTable Options

    Right-click PivotTable options

  24. On the Totals & Filters tab, uncheck both options under Grand Total

    PivotTable options

  25. Rename Sheet1 to PivotTable
  26. Add a New Sheet - rename it to Manual Table
  27. Highlight the entire PivotTable, EXCLUDING Max of Average and Question, select Copy (Ctrl +C)

    Highlight PivotTable and copy

  28. Go to the Manual Table sheet, and Paste Values

    Paste Values

  29. Insert 2 columns between Section and Q06 - Enrollment and Responses
  30. Fill in the appropriate values for the enrollment and survey responses for each course/section.  This information can be found in AEFIS Course Evaluation Analysis Report Summary (where you originally exported the Excel file in Export AAE Results from AEFIS )

    Insert columns

  31. Insert 4 blank columns between Q07 and Q12
  32. Insert 1 blank column between Q12 and Q14





Keywords:export;aefis;class evaluations;TA   Doc ID:92578
Owner:Eric D.Group:Agricultural & Applied Economics
Created:2019-06-20 12:32 CDTUpdated:2020-06-16 09:25 CDT
Sites:Agricultural & Applied Economics
Feedback:  0   0