Here’s an idea for sorting assessment data (SOAR) using Microsoft Word.

submitted by Francie Kugelman

>Here’s an idea for sorting SOAR Data using Excel in Microsoft’s Office Suite.

submitted by Francie Kugelman

This is an idea of entering SOAR data from Open Court tests in a template. Using the Word Table helps me instantly
know which students need remedial help. I use this to turn in the data to
the Open Court coach, and then I sort by columns to see which students need
help in fluency, and which need help in reading comprehension, etc.

I have this data instantly, and I do not have to wait for the Open Court
reports. I also use this information during student conferences. (See
sample conference form).

Another important tool I use during conferences is to use a table to show
the parents the State Testing data for their child from the prior year. I
use this to show the parents where we are starting from, and where we might
choose to focus for the new school year in my classroom.

To create these conference forms, I cut and paste a row from my tables and
insert the data into each student’s conference form. I am sending you some
samples.

Here is information on how to use all the great features in a Table using
Word:

All of the commands for using a Table are in the special Table section in
Word.

You can make a table, insert columns and rows, merge columns, etc.

Often you might want to make the first row a Header. This means that it will show up at the top of every page you have, if your document is more
than one page in length. To accomplish this, select the row you want to be
the Header, and click on Heading Rows Repeat in the Table section.

If you want to sort data in a column, just click on that particular column,
click on Sort in your Table section, and you can select to have your data
for that column sorted in ascending or descending order. The rows will stay
with the data, so you don’t have to be afraid of losing your information.

I use the sort feature to quickly determine which students need extra help.
I sort State Testing scores, Open Court SOAR data, and instantly can see
which students need remedial help.

Sample First ConferenceSample Student ReportSample of Comprehension Sorting