Literacy Assessment Tool

Age Range: 5 - 11
By: James Blomfield

Literacy Assessment Tool

James has contributed a handy Excel tool to help primary teachers assess their children's Literacy skills. Download the Excel sheet below.

You will see that all of the sheets are completely the same as in the Suffolk scheme - I have just joined them together in Excel to allow teachers to scroll through each level and choose the most appropriate for each student. All you need to do is to use the LEFT and RIGHT arrow keys to go forwards or back. Double clicking in any of the cells will highlight them and make the text bold and change the colour (RED, AMBER, GREEN). Double clicking again will clear the highlighting.

At the bottom of the Excel sheet there are tabs to switch between NARRATIVE and NON-NARRATIVE assessment sheets.

It is intended that teachers can create a copy of the Excel file for each student (giving it their name). If the file is saved it will store the most recent levelling, placement and highlighting and can be dated or updated accordingly to evidence progress. The sheets are not designed to be printed out - rather they are a screen modelling tool, but teachers might use 'select print area' within Excel if they prefer to have a hard copy of part of the assessment.

When you open the Excel - a dialogue box will ask you if you want to 'Enable Macros' - which you allow. The macro enables you to double-click on any cell to change the colour from blank, to red, to amber, to green and back to blank.

You can highlight smaller segments of text within cells if you need to and change font colour.

Note: if the colour highlighting doesn't work, you may have to click on Tools/Macro/Security to change security level to Medium or Low. Do this and reopen the Excel file, then choose 'Enable Macros. I can demonstrate.


Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.


This is a wonderful document