Tag Archives: statistics

Spreadsheets101

Being able to work with Spreadsheets is an important skill for today.

Today you would be crazy to do any sort of accounting and financial management or data analysis without spreadsheets!

Knowing how to get the spreadsheet to complete multiple calculations powerfully, being able to change input and have the roll on effect etc etc!

“Spreadsheets!” not just “excel”: spreadsheets take many different forms today. The activity in this post is actually a Google Spreadsheet which works the same as Excel but in the browser. They can also be collaborative and also saved as excel when you want!

A spreadsheet activity for all:

This activity for making a start on spreadsheets but also building a good skill set to really getting going with spreadsheets. The same spreadsheet can be used for the very first steps right through to those that are strong at spreadsheeting. The activity has built and refined over many years and has built in extension tasks for those that move faster.

What is covered?

In the activity you will be investigating and hopefully demonstrating an understanding of:

  • how to get spreadsheets to do the medial collecting, counting and calculating work
  • the components of a spreadsheet
  • patterns in spreadsheets
  • creating functions in Spreadsheets
  • filling patterns and functions into other cells
  • “absolute” and “relative” referencing of cells (Yep! Google it!)
  • Statistical functions for Quantitative data (remember which one quantitative was!)
  • frequency distribution tables in a more powerful way
  • further functions like standard deviation (extension)
  • categorical data and the limited statistics available

Future tasks will This task will be required knowledge for the next stage which is creating effective surveys/questionnaires, collecting data via online forms then graphing and reflecting on your results.

The Activity:

As a Google Spreadsheet:
Click on the link http://bit.ly/spreadsheets101 make sure you are logged into your Google account. Go to the “File” Menu and “make a copy”

For those without Google Accounts:
Click on the link http://bit.ly/spreadsheets101 Go to “File” Menu and  select “download as” and choose “Microsoft excel”

NOTE: spreadsheets and iPads are still not a good combination. Hopefully this will change soon! Stay Tuned!