Teacher Resources

Create a geometric sequence including the sum of terms and extend using Tap and Drag technique.

Create a pie chart, determine the percentages represented by each sector and dynamically modify.

Create a flexible Simple Interest spreadsheet using Absolute and Relative cell references and extend by copying and pasting multiple columns.

Create a flexible Compound Interest spreadsheet using Absolute and Relative cell references and format cells to 2dp.

Use a spreadsheet to examine the balance of a reducible interest loan.

Use a spreadsheet to examine the balance of an annuity.

Smooth time series data in a spreadsheet using moving averages, fit a regression line and calculate residuals.

Create a boxplot from a single list of scores.

Create a boxplot from a frequency table.

Create several boxplots in a single graph to compare their distributions.