Checklist rating form to narrative script

[Noj]

I use checklists that teachers fill out with 4 columns (above average,
average, below average, descripton of a behavior). After the teacher fills
out the form, I would like to use that form somehow to have all the below
average behaviors to automatically move to a narrative paragraph in a report
summary. "Teachers reported that the student needs to improve the following
behaviors: (then all the behaviors in this category are listed separated by a
common and ending in a period)." I plan to have a narrative paragraph for
each category- above average, average, below average. Do I use excel or
word? If so, how? Please help.

 

[joel]

There are lots of way to do this either from excel or word. Most o
them require some programming skills. there is a mail merge utility i
word that doesn't require using a macro but is difficult to use. I
would allow you to create a word template document and then inser
coluns from a row in an excel spread sheet into the word document. I
also has a looping function where you can create a different wor
document for each row of a spreadsheet and allow you to filter th
spreadsheet so only rows with specific criteria will be ionserted in t
the word document.

You can find lots of information On this technique perfroming a googl
serach for

combine mail merge records