Whānau Favourite Fruits Data

Name:

Date:

🍎 Part 1: Dataset Entry

Instructions: Enter this data into your Google Sheets document. Create columns for: Fruit Name, Quantity Grown (kg), Taste Rating (1-10), Notes

1. Enter the following whānau fruit data into your spreadsheet:

Row 1: Kiwifruit, 25, 9, Sweet and tangy

Row 2: Feijoa, 18, 8, Aromatic autumn fruit

Row 3: Tamarillo, 12, 7, Great for chutneys

Row 4: Kawakawa berries, 3, 6, Traditional rongoā

Row 5: Horopito berries, 2, 5, Peppery taste

Row 6: Apple, 45, 9, Crisp and juicy

Row 7: Pear, 22, 8, Perfect for preserves

Row 8: Plum, 15, 7, Beautiful purple colour

Row 9: Blackcurrant, 8, 9, Rich in vitamin C

Row 10: Gooseberry, 6, 6, Tart summer treat

2. Format your spreadsheet by:

Making headers bold

Adding borders to all cells

Using different background colours for headers

Centre-aligning the quantity and rating columns

📊 Part 2: Formulas and Analysis

3. Create a SUM formula to calculate the total quantity of fruit grown:

Write the formula you used: =SUM(_____________)

4. Create an AVERAGE formula to find the average taste rating:

Write the formula you used: =AVERAGE(_____________)

5. What is the total quantity of fruit grown by the whānau?

6. What is the average taste rating across all fruits?

7. Sort your data by quantity grown (highest to lowest). Which fruit is grown the most?

Kiwifruit

Apple

Feijoa

Pear

8. Use a filter to show only fruits with a taste rating of 8 or higher. List them below:

📈 Part 3: Charts and Reflection

9. Create a column chart showing fruit quantities. Which type of chart would be most appropriate for showing the proportion of each fruit?

Column chart

Pie chart

Line chart

Scatter plot

10. Reflection: How does treating data as taonga (treasure) influence how we collect and share information about our whānau?

11. Extension: Add your own whānau's favourite fruit to the dataset. What quantity would you estimate and what taste rating would you give it?

Fruit name: _________________ Quantity: _______ kg Taste rating: _______/10

12. What is one interesting insight you discovered from analysing this fruit data?

Whānau Favourite Fruits Data

Whānau Favourite Fruits Data

🍎 Part 1: Dataset Entry

📊 Part 2: Formulas and Analysis

📈 Part 3: Charts and Reflection

About This Worksheet

Free in Kuraplan

Print-Ready

AI-Generated

For Teachers & Parents

Need a custom version of this worksheet?

More Technology Worksheets

Our Favourite Fruit Data Worksheet

RAU Favourite-Animal Data Analysis

Favourite Animals Bar Graph

Favourite Animals Data Survey

Matariki Whānau Connections Worksheet

Understanding Whānau in Māori

Tōku Marae Whānau

Toku Marae Whānau

Explore more free resources