Spreadsheets – Challenge Based Learning

December 8th, 2011

Over the past few weeks my pupils have mastered some pretty tricky aspects of Microsoft Excel.

The pupils were set the challenge of seeing how a self marking maths quiz worked.
The spreadsheet had a hidden column which calculated the correct answer of the maths problem. An ‘IF’ function compared the actual answer with the user entered value. The ‘IF’ statement then toggled the feedback between ‘Correct’ or ‘Wrong – Try again’.

The children discovered within 15-20 minutes how the spreadsheet worked and were able to use their newly found knowledge to create their own self marking maths quizzes.

Further challenges included:
Using conditional formatting to highlight the feedback comments.
Inserting the รท symbol into the displayed problem (while retaining the / in the formula).

All groups were able to solve all of these challenges and support each other in the process.

One group managed to take it a stage further by protecting all cells except for the user entry cells.
The most gratifying part of all of this was that, save for a few timely hints, they had discovered it all for themselves.
(& The conditional formatting is most complicated in the new version of Excel!)

ICT Skills Audit – Pupils

November 26th, 2011

This week, I carried out an ICT skills audit with pupils from every class in KS2 at my school. The purpose of the audit was to determine whether the children were working at age appropriate levels in each year group. This in turn will help me to moderate the teacher assessment grades.

Although the final analysis has not been completed (and the skills mapped against where they should have got to in the ICT scheme of work), there were some interesting discoveries.

The children in Year 6 could complete all of the challenges – which included, amongst other things, recording audio and inserting audio and photos, and creating graphs to represent data. In the main, they chose the most appropriate program and the most efficient methods of doing things.

The lack of the facility in Windows 7 to upload individual photos threw the children – with some children finding a work around and others not.

All of the children from Yrs 3-6 were able to manipulate text – changing fonts, size and colour. Surprisingly a fair few were unable to make a copy of the text without retyping it.

We have a fair few different paint programs installed in school – which of course are aimed at children (making them easy to use) and can produce some interesting effects. All of the 24 children in the audit group chose Microsoft Paint as their tool for the paint challenge. The choice was limiting and they struggled to do some basic things like clearing the page because of the limited functions and interface of the program.

The younger children struggled more than I would have expected to save and print their work. Again, possibly because of their choice of tool.

The most surprising attempt at creating a graph was by a year 4 child who had used Excel as his chosen tool, because he’d “seen it used to make graphs before.” His method was creative to say the least… He had no idea how to create a graph by entering data and using the chart tools – so instead he changed the cell colour in vertical stripes to form his bars and then typed in the bar labels into the cells. There was, of course, no scale – and when he went to print his bars did not appear as there was no data within the coloured cells.

The other interesting thing was the way that a few of the younger pupils called the desktop applications “websites” on a number of occasions. They are obviously ready for cloud computing before it is truly realised.

The next step for me is to match the skills noted against the scheme of work and National Curriculum level descriptors to see how ‘on track’ the children are… And then feed back to the staff.

It was an interesting exercise and one that I would both recommend, and will do again.

Not such a slick launch of shared Google Calendars

November 24th, 2011

In school, staff have been using a shared Outlook calendar to book laptops for use in lessons. The shared calendar (unlike their own calendars) are not available off site via Outlook Web Access.

The decision was made to move to a Google powered calendar, which is part of our Google Apps for Education suite.

Accounts were created and the calendar shared with each of the staff from the Admin account.

The system was tested and demonstrated to the Senior Leadership Team – and all went well – and all were suitably impressed.

The launch with staff did not go smoothly.

Staff logged into their accounts and selected the calendar… to find the shared calendar was not present in the sidebar.

The walkthrough was abandoned rather than take up the valuable time of the staff.

A dummy account was set up and the calendar shared in exactly the same way. It worked without issue immediately.

It is inexplicable why one account would work and the many others not when all are showing in the ‘sharing’ list.

Any thoughts?

Update: By removing a member of staff from the list and then re-adding them the calendar magically appears in their ‘other calendars’ list.

Update 2: It seems that the issue is caused by sharing the calendar before the first login by the user. If the share is made after the first login, the sharing process is reliably successful.

Useful weather forecast site

April 30th, 2011

This site gives a clear breakdown of wind speeds at different points of the day
http://www.xcweather.co.uk/forecast in a 7+ day forecast.

Fanatic Viper 2011

April 17th, 2011

Top choice at the moment for an all round board: (Fanatic Viper 2011).

Update: I bought one of these!

The 2009 Starboard Rio

April 17th, 2011

A possible all round board: (The 2009 Starboard Rio ).

The 2010 Starboard Go

April 17th, 2011

A possible all round board: (The 2010 Starboard Go)

The JP Funster

April 17th, 2011

Another possible all round board: (The JP Funster).

Windsurf Freestyle Highlights Fuerteventura 2009

April 17th, 2011

Some inspiration… (I was never this good!)

New Blog: My Self Build Plan

April 16th, 2011

It is my ambition to build my own house, or at least have a commissioned build. I have set up a new blog to host notes and thoughts as I get closer to the dream:

www.myselfbuildplan.co.uk