# The Game of Life

## 1 The basics - BBQ

• You may or may not have used a spreadsheet before.
• In any event, it's probably worth recapping the basic vocabulary used in a spreadsheet, which will help you in the coming lessons.
• The tutorial below walks you through the vocabulary of spreadsheets, writing simple formulae, using AutoSum and using formula replication to save time.
• Try the different techniques for yourself as you watch the tutorial. When you're done, see if you can write out all the odd numbers from 5 to 51, then add them all up.

## 2 The BBQ

• To remind ourselves of the basic features of Excel we are going to finish a partly completed model of a budget for a BBQ.

• Open the spreadsheet in Excel.

### Learn It

• Let's pretend you want to host a large BBQ, which you and your friends will all contribute to the cost of.
• A friend has started to produce a spreadsheet to hold all the information you'll need to work out if you have enough money.
• The spreadsheet has some issues and is incomplete.
• When complete it will be able to dynamically calculate whether you have gone under or over budget in regards to holding your BBQ.
• Here is an example of 40 people attending the BBQ, which is what we're working towards:

### Try It

• We'll need to write some formulae to perform our calculations.
• The formulae you need are all on show in the screenshot below:
• Apart from the basic maths calculations you will need to know:
• Conditional formatting (cell G3)
• Excel if statement (cell G4)
• If you're struggling to complete the formulae in this scenario, this video tutorial will help you along:

• Silver: You have been asked to plan a BBQ for 60 people, using the following figures:
• Burgers: 48
• Hot-dogs: 12
• Drinks: 1/5 of the guests want Orange, 4/5 want Coke.
• You need to know if £120.00 is sufficient to pay for the cost of your BBQ.
• Complete the formulae above and tidy the spreadsheet, then change the variables (e.g. number of burgers) to those above.

## 3 The basics - Olympic data

• Excel is very good tool to use when looking at a large data set and trying to extract some information.
• We will try and analyse some Olympic medal data to answer some questions.

• Open the spreadsheet in Excel

### Learn It

• Gold: Answer the following questions in the Medal Analysis tab of the workbook
• What is the total of all medals awarded?
• Who has won the most gold medals in a single sport, in a single year?
• How may athletes names are missing?
• Replace the missing names with Unknown.
• Sort the data by athlete, who appears last on the list?
• Sort the data A-Z by country then A-Z by athlete, who is last on the list?
• Create a new tab called Brazil, copy and paste all the Brazil data to this new tab.
• How old was the youngest medal winner from any country?
• How many medals where awarded for Ice Hockey in total?
• What was the average age of all the athletes?
• How many Olympics did Natalie Ward win 1 or more metals in?

## 4 The basics - Science, maths and graphs

• In this lesson you will learn how to visually represent data.

• Open the spreadsheet in Excel

### Learn It

• All graphs MUST:
• Have a title
• Have axis labels
• Be pleasing to the eye
• Make the data easier to undstand compared to looking at the data itself
• Use a type of graph that is correct for the data set
• You can see an overview of drawing different types of graph here:
• This guide may also be of some help: