by clicking the arrows at the side of the page, or by using the toolbar.
by clicking anywhere on the page.
by dragging the page around when zoomed in.
by clicking anywhere on the page when zoomed in.
web sites or send emails by clicking on hyperlinks.
Email this page to a friend
Search this issue
Index - jump to page or section
Archive - view past issues
Inside Teaching : October 2010
www.atra.edu.au | firstname.lastname@example.org CURRICULUM & ASSESSMENT 33 Googledocs spreadsheet can also be exported as an Excel and downloaded onto your own computer for offline work. Victoria’s DEECD is now rolling out the Ultranet with similar capacities, so all student data will soon be held online in a secure environment. Analysing the data Having collected all this information about student performance, what do we do with it? We originally tried to personalise individual lessons to pick up on those aspects of writing that specific students seemed not to have learnt. This is the main purpose of collecting such data – to support further learning – although it’s also used to report on student progress. Our school has spent considerable time and effort managing and analysing quite large amounts of student data, with one of our leading teachers developing several Excel-based instruments that can sort and highlight student performance in various ways. With exotic names like the Fitzolator and the Quokka, these instruments are stored on a central server and are basically sophisticated versions of the simple spreadsheet described above. Being school- wide data sets, they rely on input from individual teachers, as well as central data like Universal Italian Restaurant School Group Dinning Located on Lygon Street, Carlton VIC. Walking distance to IMAX Theater, Piazza Italia, Sky Deck, Melbourne Museum, Old Melbourne Gaol & Public Transport. Serving school groups for over 30 years. www.universalrestaurant.com.au • Pizza • Pasta • Drinks • Ice Cream Years 1-9 only $10 Years 10-12 only $12 evaluations, book reviews and so on – is collected • a spreadsheet is created like the one in Figure 2 • the gaps indicate useful data too – was the student absent, or does he or she not complete work? • the spreadsheet can be colour- coded using the ‘conditional formatting’ command; for example, all assessments below the expected level can be highlighted so student needs can be more easily recognised. I keep an Excel spreadsheet like this for all the students and class groups that I teach, and as a team leader I expect and assist my colleagues to do the same. The next stage is to share our information, which can be done face to face at meetings, which is the best option as it involves actual discussion, but also remotely over the internet. We’ve been using Googledocs. To do this, a team leader creates an online spreadsheet similar to the one above and ‘invites’ teachers to view it and contribute. In this way all data from a wider range of sources or classes can be entered and viewed, which makes the triangulation easier and also ensures that the data is still available if the key teacher is, say, on leave or sick, or has gone to another job. The