Evaluation Labels for Brenda

 Problem Description : 

Printing labels from the class evaluations

 Resolution : 

Brenda will send the following email requesting that evaluation lables be printed.

Request for Student Evaluation Labels

TO:   Jody Defore

                   Computer Services

FROM:      Brenda Blackstock

                   Academic Affairs

DATE:       September 6, 2010

Good morning, Jody.  Please run the Fall 2011 student evaluation packet labels as soon as you have time.  I have listed examples. I am continuing to use the term “CRN/CSN”.  We won’t be running a set that only lists the PIDM without the faculty member’s name.  I’ll come over and get them when they are ready.     

            Thanks. 

2 Sets Needed of labels that list:

Div:

Name:

PIDM:

CSN/CRN:

Term: Fall 2011, 201108

(I think you may have to reduce the font on the label.  Sometimes it cuts a bit off at the bottom.)  

1 Table Summary needed with the heading

Dept           Name                  PIDM                   CSN/CRN            TERM

F:\users\brendab\Stueval\LabelReq

Steps to run the labels.

1. In Toad open the eval.sql which is found on N:\csd\tracy\SQLS

2. Change the term description in the select to the correct term. Update the two prompted terms in the where statement. run the sql and export the data to excel. You will then save it under N:\csd\evaluations.

3. Open word and create a mail merge for labels. You will need to set your font to Arial Narrow and use a 10pt. Create the lables exacly like Brenda has in her email. You can use the mailing labels in the closet. If we get low ask Laura to order new ones.

4. Print two copies of the labels and one copy of the excel spreadsheet and put on the conference room table. Email Brenda to let her know the have been printed. 

 Revision Date : 6/8/2012