L.O: I can collect, enter, organise into a spreadsheet. 

L.O: I can use a range of spreadsheet formulae, e.g. + - / x, sum, average, max, min.

 

Let's activate our prior knowledge... Beth wyt ti'n feddwl?

1. What is a cell?

2. What is a row?

3. What is a column?

4. How do we tell a spreadsheet we want it to do a calculation?

 

In outdoor learning last week, you measured the height and circumference. 

 

Today, your challenge is to...

 

1. Create a spreadsheet with tree number, height and circumference; remember to name your document.

2. Calculate the total of height and circumference using a formula

3. Calculate the average height and average circumference using a formula

3. Create a graph for the height and for the circumference

4. Learn how to order your data in ascending or descending order... this is new learning! 

 

Cofia! Share your work with archards6@hwbcymru.net