1. Copy the text of the electronic class list beginning with on the line with the first student.  (For now, you’ll skip the first line starting with “@@@@,” which is your course identification header.)
   
2. Open Excel to a new spreadsheet.
   
3. Paste the class list into the first cell on the second row (A2).
   
4. In the menu bar, select “Data,” then “Text to Columns.” A new window, “Convert Text to Columns Wizard,” will open.
   
   1. For “Original Data Type,” choose “Delimited;” then click Next.
      
   2. Under “Delimiter,” check the box for “Comma;” then click Next.
      
   3. In the last step, you’ll delete the last columns that you don’t need for writing your evaluations—the first one (&&&&) and the last three (college, grade option, e-mail). Click on the column; then choose the button “Do not import column (Skip).” (Make sure to use the arrow button in the Data Preview box to go through all of the student information that’s hidden to the right.) Click Finish.
      

For questions about designing your evaluations or using a software method, contact the Evaluations Support Coordinator at 459-1573 or evals@ucsc.edu.

If you have any questions regarding the processing of your evaluations please contact the Evaluations Office at 459-4682 or nes@ucsc.edu.

Additional Online Resources:
Guidelines on writing Performance (Narrative) Evaluations

Instructions for the proper electronic formatting of evaluations

A software tutorial for simplifying the writing of evaluations