Year 9 Term 1 B Home Learning Task 1

Open Ended

What is a spreadsheet, and what are its key parts?

Define what a spreadsheet is (mention that it's software for organizing numbers and data).

Identify and explain four key parts of a spreadsheet:

cell

row

column

Open Ended

How do formulas work in spreadsheets?

Explain what a formula is and how it must always start

Describe the four basic operators you can use in a formula: (+, -, *, / )

Create and explain a simple formula you will use to calculate the total scores in the image attached.

Open Ended

What are spreadsheet functions and why are they useful?

Explain what a function is

Describe three different functions from the lesson and what each one does (choose from: SUM, AVERAGE, MIN, MAX, ROUND, COUNT).

Give a practical example of when you would use each of the three functions you chose.

Open Ended

You are the captain of your school football team and have recorded the number of goals each player scored across 10 matches in a spreadsheet. Explain which three functions you would use to analyze this data and what each function would tell you.

For example, which function would show the team's total goals? Which would show the average goals per match? Which would help you find the top scorer? Describe why using these functions is faster and more accurate than doing the calculations by hand.