Secondary Girls: Spreadsheets 1

This is the first lesson in a series of Microsoft Excel review lessons for Secondary Girls where we looked at collecting data using a spreadsheet and then taking the data and constructing a simple graph that we then interpret and then copy and paste into a Microsoft Word document that we then use to write an interpretive piece talking about the data.

Our first step was to collect our data and put it into a spreadsheet:

After we finished our spreadsheets we then created a new Word document and inserted the table from the spreadsheet into the Word document and then we started to analyse the data and draw conclusions about it - and about our spending habits at the local store:

One of the things that we talked about was how the bar graph made it easier to intrepret the data. That it was easier to read numbers converted into a visual form that it is to simply read numbers in a long list.

As a test you can link to an online version of our word document here, hosted on Googledocuments