[MOSAIC] assessment AND grades - record keeping

[Keith Mack]

I have a friend Carolyn Hinshaw that operates her own site:
http://www.rightinclass.com. She teaches 5th grade in the Bellingham WA
school district. 

Within her site she has a teacher tools page with examples of how she uses
Excel to help monitor and assess student progress. There is a
reading/writing example:
http://rightinclass.com/integrate/teacher_tools.htm.

While it may seem complicated to use this sort of electronic format, the
nice thing is that she can easily sort students for remediation. For
example, she can sort for students scoring "2" in "Finding Main Idea" and
pull them out for special small group instruction.

The other nice thing is that the school district uses a "Mail Merge" feature
for the report card so teacher notes and key area scores are merged directly
on the student report card without the need to get out the pen and rewrite
everything.

I've used the same sort of system and mail merge in my middle school classes
to send out individualized progress reports to keep parents and students
updated on what the individual student has accomplished and what s/he needs
to work on.

We both found having a laptop or PDA works best so that you can input data
right as you work with individuals or groups.

Keith Mack
kmack at literacyworkshop.org
http://www.literacyworkshop.org