Processing Evaluations for Multiple Courses

Warning: This procedure provides an opportunity to overwrite data and create inaccurate reports. If followed carefully, however, it will save you time and energy compared to processing each course individually

  1. Open the template file for the courses you are processing
  2. Replace the 'X's with the information from the first course's cover sheet
  3. Click on cell B10, next to the arrow that says 'Insert Here'
  4. From the 'Data' menu, click 'Get External Data', then 'Import Text File'
  5. Browse to the text file for the first course and click 'Get Data'
  6. Click 'Delimted', then 'Next'
  7. Check 'Comma', and then click 'Finish'
  8. Print your report, if desired, and save it.
  9. Go Back to the 'Insert Data Template' worksheet and replace the course information with that from the next course
  10. Click on cell B10
  11. From the 'Data' menu, click 'Refresh Data'
  12. Browse to the data file for the next course and click 'Get Data'
    • Excel will remember how to interpret the file and will overwrite the results from the previous class
  13. Print your second report, if desired, but Do Not Save it
  14. From the 'File' menu, choose 'Save As', and save your report file with the appropriate name
  15. Repeat steps 9-14 until all courses have been processed

Return to Main Instructor Evaluations Page