Download MAV's Excel Spreadsheet tools. These tools will enable you to get feedback from your students’ NAPLAN testing early enough to be able to use it to target your teaching.
Sample Test Papers are available from the NAPLAN website.
NAPLAN support
NAPLAN spreadsheet demonstration - Year 3
NAPLAN spreadsheet demonstration - Year 5
NAPLAN spreadsheet demonstration - Year 7 (calculator allowed)
NAPLAN spreadsheet demonstration - Year 7 (non-calculator)
Instructions for use of MAV’s NAPLAN analysis spreadsheets
MAV hopes that your use of these tools will enable you to get the feedback from your students’ NAPLAN testing early enough to be able to use it to target your teaching.
I have spoken to the NAPLAN administration, and I am informed that the procedure below is acceptable to them. Of course, teachers must not ‘modify’ any of the students’ responses, and the school principal will be signing a document certifying that all has been done correctly.
The sample spreadsheets (for 2009 tests for Years 3 and 5) have used the real sample data from an unnamed school. By examining these completed spreadsheets you will see in advance what to expect from your use of the ‘NAPLANblank’ spreadsheet with your own class.
When you start to use the NAPLANblank rename it to identify your own class. Others in your school may do the same, but with their own names. These spreadsheets are designed for use with up to 40 questions and up to 26 students. This may be modified. For assistance phone Ian Lowe (see below).
Procedure
- Before sending the students' papers back, photocopy one set of questions, and work out all correct answers. Open the NAPLANblank spreadsheet. If it is too small or too big to read, use the View menu to change the scale of the image. Type the correct answers in the bottom row of the table (labelled CORRECT).
- Then two people work together; one reads responses while the other types each student's response in a row starting with the student's name.
- Correct responses will turn the cell green, and be totalled, for each student.
- In addition you will have a total of correct responses for each question. Once you have identified the dimensions (next tab) these will appear at the bottom.
- In particular, you will know what each student knows, and does not know. Use this to guide your interventions.
- And you will know what incorrect response they gave, enabling you to analyse errors and misconceptions.
- By eye, discover the most common error and type this in the 'Common error' row.
- Move to the next tab below ('Dimensions') and follow the simple instructions.
If you cannot see the tabs, go to ‘full page’ view. - Please analyse the test items by placing them into dimension categories. In the table above, type 1 to show the category to which it belongs. The spreadsheet will then show the totals for each dimension for each student and for the class as a whole. The colour-coded dimensions will appear both here and in the Items sheet.
- The third tab, at the bottom of the sheet, will group the students into four ‘ability’ groups, and display the spread as a box & whisker plot.
It will do this for the total score and for each dimension separately, providing that there are enough items in the test to enable this to be done.
If there are any difficulties involving the use of the spreadsheets, please contact Ian Lowe at MAV (9380 2399 or by email: This e-mail address is being protected from spambots. You need JavaScript enabled to view it ).