Science

You win some you lose some

A short while back I was buoyed by the use of Google Spreadsheets in our science lessons. The children enjoyed the fact that we were sharing data and it added an edge to their motivation. They questioned the data that popped up as the sheet updated, they enquired about it’s ownership and accuracy. However this week sharing a Google presentation did not run so well!

I assumed we would have a similar experience and the sharing feature would work just as well. Groups were created in each class they were assigned a planet (we are looking at the solar system) and after a short intro, asked to explore our del.icio.us links and create one slide (or more if needed) in a ready made presentation. 3 children were working on a wireless laptop. It just never really got off the ground and I found my self firefighting access, update, deletion and wireless problems. Admittedly the technology got in the way of the learning  and it proved a disappointing afternoon. You really do win some, lose some. There were of course some groups that worked without any issues. So what went wrong – I think that it is important to try and reflect on the successes and failures on this blog so that I learn from it and others do as well.

  1. We put a lot of pressure on the wireless network in the session as 16 machines were active and Google docs regularly refreshes so the web connection was very busy.
  2. Some kids worked on the class PC and they seemed to work a lot smoother.
  3. The children accessed del.icio.us links and these included a NASA image gallery so that could well have chewed up the bandwidth a bit.
  4. Google presentations deals with different data than the spreadsheets, whole slides need to be updated sometimes with images etc – not just a number in a spreadsheet.
  5. The children had to start from scratch and make new slides for their planet – some mix ups went on here.
  6. All of the children were using one Google domain login – not sure if this hindered.

On reflection the idea is still a good one. Children all contributing to one presentation that has a common theme. They all have a piece of the jigsaw. But I think that we just asked too much of the wireless network, it certainly was far more than we have ever done. I am uncertain if the same login made an issue, I may try out some individual account logins with a similar activity.

I think that the most important thing to learn from this is that sharing Google Presentations works smoother when on hard wired PCs because it deals with a larger data set than spreadsheets.

Taking risks is a good thing. If I had never planned such an activity I would not have learned about how differently the application performs in the classroom. Were I to do it again in the future I would feel better prepared. Lesson learned.

Sharing a Google Spreadsheet in class

Today was Day 1 in terms of our laptop use in the classroom and we hit the ground running, so to speak – just how I like it. I am sure you have had days like today, when it is a bit of a whirlwind from 8am right through to 4pm – where does the time go? Today the sands just seemed to slip through my fingers! Not to say it was one of the best days for a long time.

We now have 8 Toshiba laptops running happily in both of our Year 5 classes and today we kicked off with a simple word level activity in literacy. One group worked on Race to Ramses! a game about combining prefixes and suffixes to create new words. I have taught with laptops in the past but the new technology (laptops and WAPs) is just so much more reliable. And it is great seeing children completely engaged with one to one technology supporting their learning, I am so pleased to see it in the hands of the pupils – which is the whole point. You might think “web game, one group…not really setting the world alight” – but I suppose it is a culmination of a lot of work and to finally get things in front of children, reliable and solid feels like a big achievement.

Needless to say in the afternoon we swam into deeper waters and I’d like to think we pushed the envelope a bit…

The morning was successful and the children enjoyed working on their own machine and many children asked for the web address for the game – so we will have to get our del.icio.us account sorted or get them into their Google accounts soon!

In the afternoon we were looking at some science work we have begun regarding healthy living and exercise. Today we explored pulse rates and we used an online spreadsheet to share our results, hence the title of the post. (This work is similar to some online spreadsheet action we had last year with my Year 6 class) I decided to use a Google spreadsheet as I have been using the Docs application for a while (in fact I have a few grumbles about that – more soon) but you could have easily used EditGrid as an alternative – I set the sheet up so that all of the children’s names from both classes were present in the first column. Then 10 other columns were labelled, “Resting Pulse1, Resting Pulse 2…” It was in these cells that the kids added their resting pulse after counting for 30 seconds and doubling.

spread

I then accessed the same spreadsheet through my Google login on all 8 laptops per class that I put around the room – so in effect I logged in 16 times (plus my PC and SMARTBoard, so 17) to the same document from different locations. We talked a little about how to find our pulse and then asked the children to record 10 instances of their resting rate into the spreadsheet. It was great! With the live update feature we were able to see individual results popping up all over the place and even from next door in Rick’s class who were doing the same. Google Spreadsheets has an Auto Save option which makes life much easier and gives you the opportunity to see the live data. Not only did the hardware hold out fine, but accessing the spreadsheet was excellent – even with 17 simultaneous users on a single login. The children really enjoyed seeing each other’s work and it gave them a great overview of not only the class year group working together, but also to the sorts of data people were adding. Children from the other class were nipping across the corridor and questioning the validity of results from kids in my class.

The children had a tendency to sit with the laptop in front of them, in small groups rather than freely moving around the classroom and accessing any machine. But I suppose that is due to the nature of task.

Within the space of about 40 minutes, perhaps less, we collected approximately 600 individual results all in one place. No doubt they will be quicker next time. This method of data collection also allows us the ability to then manipulate the results afterwards, working out averages of the whole year group etc. I would highly recommend doing this if you have the reliable kit in your classroom, we have already said that it will be an excellent data entry method for our maths lessons on data handling.

It is now 12 hours since I started the day at school and I am just about coming up for air, no don’t worry I am not at school still! – but it is great to reflect here on these sorts of days. One to remember and I hope you might take some of these ideas and use it yourself.

Editgrid update

We got round to looking once more at our Science Online resource over at Editgrid. I had some trouble yesterday with it so I thought I could try dumping the cache in Firefox and that worked really well.

So in the morning I pasted in the data which I added to Excel yesterday and sorted out an average and simple bar graph which you can see I have linked to below, also here.


Then the other year 6 class added their own data – we watched as it updated live, the children loved it and we talked about how the graph and average were also changing.

It would be great to be able to do this with schools in other countries – after all exercise is universal! SO GET INVOLVED – all the instructions are there for you to do the short exercises and then you can add you data into the pool.

Real data we can all share; to help better demonstrate how reliability is imperative in scientific results.

Editgrid and Pulse Rate revision

Today we were back to school. We had a good day and pretty much hit the ground running.

I decided that during our revision of the human body, and specifically whilst we were looking at pulse rate we would use our Science Online spreadsheet resource to share results between the 2 Year 6 classes.

Although over the last few months we have had nearly 300 individual views and some positive comments on the resource, nobody has yet been in a position to contribute. So I thought I would look closer to home and share pulse rate data between the classes.

Pulse

The important principle still remains underpinning why I want this web2.0 tool to work; that more results means more reliability. These tools have to make a difference after all.

So the children recorded the pulse rate (counted for 30 seconds and doubled) when:

  • Resting
  • After 30 arm circles
  • After 30 star jumps
  • After 30 side to side jumps

Editgrid has a real time update feature but unfortunately we had a bunch of trouble and the spreadsheet just sort of stopped updating. I decided to save our results in Excel and then import them later – you can still see our “Exercise” sheet and everything ready to go.

You are welcome to have a go and add some data – it took us less than 30 mins to gather the info and add all 30 odd sets of entries to Excel.

Let me know of any other simple experiments or investigations you and your class are doing this term that we could pool the results for.

Image Citation:
Imperial Doughnut, “Pulse” Imperial Doughnut’s Photostream. April 25 2006 <http://farm1.static.flickr.com/44/134998486_c7519227be.jpg>.

A cry for help…!

I have just had a look at my Science Investigations grid over at EditGrid and they are now showing the number of views the spreadsheets have had. I was very pleased to see my Science grid has had 210 views, that was quite surprising – but what I have noticed is there has not been any contributions of results from anyone.

Maybe everyone is too scared to dip their toe in, I don’t know – so this is a call for help! Please contribute what you can to the shared results – after all the premise of the tool relies upon other people contributing to the investigation and then benefiting from the shared, pooled data – showing your class more reliable data.