Inspire Connect Engage Create
Assessing Pupils' Progress (APP) Google Doc
In this post I welcome James Mansell, a fellow primary school teacher here in the UK, who explains about a wonderful resource he has created and brought to my attention that addresses the use of APP in school.
APP or Assessing Pupils’ Progress is the new (?) national approach in the UK to understanding children’s learning needs. There has been a whole heap of related links and materials released through the Primary Strategy site and no doubt if you are Literacy or Numeracy coordinator you will be (or have already) attending training in the UK. I will let James introduce himself further and explain more.
My name is James Mansell, and I work at Earl Soham Community Primary School in Suffolk. We are a small rural school with just three classes. I am currently teaching Years 4/5/6. I have been using Google Docs for my own planning for about a year and a half now. I have found the flexibility of being able to access my plans from anywhere, and link to resources from them, has made my job easier and helped me to be more organised, as I no longer get to school and realise I’ve forgotten to transfer my plans to my memory stick or left them lying on the table at home! In the last year, I have also begun using Google spreadsheets to keep an assessment record. This again has meant that I can access and add to assessment files without the need for carrying bulky box files between home and school.
Download you own copy of the APP Guidelines Doc
With the advent of the new APP materials from the Primary Frameworks for Literacy and Numeracy, I wanted to stick with my new paper-free way of working, but was unable to find an easy solution as the APP guidelines were only produced as PDF’s (ideal for printing, but not much good for working with online). So I decided that I would need to spend a bit of time taking the guidelines and turning them into something that I can use in Google Docs. After much copying, pasting, and reformatting the result is a spreadsheet which contains all of the Maths, Reading and Writing APP Guidelines currently available (Levels 2-5). Each Guideline is set out in the same way as the original PDFs, each taking a different sheet in the spreadsheet, but with two important differences: they are now editable and stored online.
There are a number of ways that the materials could be used, but this is how I intend to use them:
As APP is designed to be used with a sample of six children from across a range of abilities, I intend to select my six pupils and create six copies of the APP Guidelines, with the filename as the child’s name. I will then select the appropriate guideline sheets for each pupil and delete any unnecessary sheets (cutting the number of sheets by a third). Whenever I wish to make an assessment, I can highlight the appropriate statements in the grid, by changing the cell colour, and use the comment feature to reference any evidence I have used in making my judgement. It is then a simple matter of entering a Y or N in the appropriate box to show whether they have reached a particular level. If used with a class laptop, comments could even be made during a lesson when working with a small group or individual child, so that a bank of evidence is built up to support the assessments.
I hope that other teachers find this resource useful, and if you have any ideas for how it could be improved, please feel free to contact me. mr.mansell+app (at) gmail.com
I am sure you will join me in thanking James for the hours of work that has gone into the APP Document and for being willing to share it to help other teachers. Please let us know if you find it useful.
Similar Ideas
| Print article | This entry was posted by tbarrett on December 11, 2008 at 8:23 pm, and is filed under Google Docs, Uncategorized. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
No trackbacks yet.
Marmite: Love it or Hate it? – Using Google Forms and Twitter
about 5 months ago - View Comments
Over the next two weeks in our year 5 class we will be exploring data investigation and the tools with which we can use to undertake them. The first three days of this week we will be looking at some technology that can enhance data handling and make our life easier. In today’s session we
The Curriculum Catalyst – Stage 2 – Contribute Your Ideas
about 5 months ago - View Comments
The Curriculum Catalyst is about the online education community coming together to produce practical resources that we can all use to support curriculum development.
At the end of last weekend the Catalyst had over 280 topic ideas for the curriculum and over 70 people had voted more that 3000 times for a top topic. It turned
Using Voicethread for Writing Ideas and for Peer Marking
about 7 months ago - View Comments
In the past week or so our literacy work has focused on a short sequence from the comic Spiderman #1. Our Superheroes topic is going well and in this post I explain how we have used Voicethread as a creation tool, a writing scaffold and as a way to do peer marking.
We began with the sequence in
Online Reporting – On the Back Burner
about 9 months ago - View Comments
Unfortunately sometimes you have to be honest and admit that some ideas will remain just ideas. I have decided to step away from the online reporting project using Google Docs as I just can’t find the time I want to give it.
It is not about the validity of the idea of using Google Docs for
Introducing Google Docs to the Class
about 10 months ago - View Comments
Day one of introducing Google Docs to a class is always an exciting one, I have been fortunate to be able to see three cohorts experience the fun ways to use it. Today we made a start with our Year 5s and had a great afternoon.
The first thing that you need to have ready is
Online Reporting to Parents using Google Docs: A Proposal Update
about 1 year ago - View Comments
Back in October I wrote a proposal for the use of Google Docs (as part of Edu Apps) to deliver online reporting to parents at our school. The original blog post proved incredibly useful in sparking some debate about the use of such cloud based tools for reporting to parents. It also brought about some
Aaargh Too Many Google Forms!
about 1 year ago - View Comments
This post includes some reflections on the use of Google Forms in data handling teaching and some problems we encountered in using them in the classroom.
For a few weeks now we have been exploring data handling in our numeracy lessons – we have included lots of work to allow children the choice of some current
Using Instant Messaging to Engage Children with Reading Comprehension
about 1 year ago - View Comments
I recently had a great conversation with my teaching colleague Rick about the use of technology to engage children with reading comprehension. This post is about my lesson I taught today as a result of that brief yet productive talk.
Although we have been reasonably successful in addressing how we use our available technology to support
100 Interesting Ways
about 1 year ago - View Comments
In November 2007 I began the first of a series of Google presentations gathering together some ideas about the uses of different tools for the classroom. I thought that the easy manner of sharing Google Docs was ideal to collate thoughts, tips and suggestions from teachers and educators all over the world.
I began with interesting
Using Google Earth, Google Docs and Twitter in this Afternoon's Science Lesson
about 1 year ago - View Comments
In my science lesson this afternoon we used Google Earth, Google Docs and Twitter to help us get a better understanding about how day length varies across the UK, and an insight into the differences around the world.
As part of our introduction to the concept of day length I used Google Earth and the sun/shadow

about 6 months ago
Fabulous work. Thank you very much – have been working on an Excel based one ofr a little while as most people in my school would be afraid of Google Docs… Will be very useful.
about 8 months ago
Thanks for this James & Tom. I have just shared it with all the teachers in my school via our Google domain.
about 8 months ago
Thanks for this James & Tom. I have just shared it with all the teachers in my school via our Google domain.
about 1 year ago
Thank you. You have saved me so much time this evening I was just beginning to despair with the PDF format and resigned to having to re-type them. I believe we are not supposed to be able to amend them hence the PDF format. I intend to re-write them in language our teachers, TAs and children can understand without re-reading several times.
about 1 year ago
Excellent idea – but I need level 1!!!
about 1 year ago
Even more incredible that a teacher is doing this in his own time.
This should have been thought about from the start and provided when the APP materials went live. If we are being told to incorporate use of ICT into our practice then the people who are designing the curriculum should make sure that any materials they provide are fully IT aware so we don’t have to do this sort of stuff.
It’s like the early days of the Literacy Strategy when everyone was literally cut, copying and pasting the strategy onto large sheets of paper. Didn’t it take another eight or nine years for the stategy itself to provide a computer based planning system. Which certainly initially didn’t work too well if it does now?
about 1 year ago
I really like this idea. Thanks for sharing it
I work in a secondary school, so the levels will be different, but I could easily adapt this, it’s so simple to record and share information.
I wonder if I can persuade some of my colleagues to start using Google docs…
about 1 year ago
What an effort! Unbelievable that in the 21st Century somebody thinks it’s ok to produce a load of stuff in a format that 99% of people can’t edit.