Listing all results (498)

Interest: Simple and Compound

The first interactive sheet shows a calculator for Simple Interest where the amount invested, the rate of interest and the term can be altered. The next sheet shows sets of five questions on Simple Interest to be answered with the help of calculators. Answers can be revealed and new questions generated.

The...

Inverse Proportion

This interactive excel file has separate sheets which deal with inverse proportion where the functions are linear, quadratic and square root. Each sheet begins with a statement of the proportional relationship and values so that the constant can be calculated and the equation found. The student then substitutes...

Averages and Moving Averages

This resource contains two excel files dealing with measures of central tendency, trend and spread for sets of discrete data.

Averages and Range
The first interactive sheet shows a set of nine data items which can be shown sorted into ascending order. The values of mean,...

Box and Whisker

The first sheet of this excel file shows a box and whisker diagram where the defining points can be altered. The second sheet shows two box and whisker diagrams to allow comparison between distributions. The next sheet shows a box and whisker diagram for students to read off the lowest value, the median and...

Correlation

The first sheet of this excel file shows a set of data in a scatter plot. The line of best fit can be drawn and a description of the type of correlation can be revealed along with the equation of the trend line. The other sheet shows the value of cars at various ages. The scatter plot shows the data and there are a...

Cumulative Frequency

The first two sheets of this excel file shows sets of data about the weight of cows in two herds. The cumulative frequencies can be revealed and the quartiles and median are shown derived from the cumulative frequency graph. The next sheet shows the comparison of the two herds as shown by the box and whisker...

Data Sets: Calculating an Estimate of the Mean

The first sheet of this excel file shows the number of passengers per flight from London to Paris. The raw data is shown in a grouped frequency table and the midpoint of each group can be revealed as well as each stage in the calculation of the estimate of the mean. The next two sheets each show two sets of data...

Pie Charts

The first sheet of this excel file shows a frequency table for up to four different colours. Sometimes the angle 359⁰ or 361⁰ is shown in the table rather than 360⁰ and this can be used to aid discussion about rounding. Students need to calculate the angles so that a pie chart can be drawn. The pie chart can be...

Stem and Leaf

This excel workbook shows how to construct a stem and leaf diagram. The first sheet has some raw data at the top and a blank stem and leaf diagram with appropriate key is shown below. The cells in the stem and leaf diagram can be revealed or hidden and by clicking on one of the numbers in the stem the corresponding...

Algebraic Long Division

This interactive file shows how cubic polynomials can be divided by linear factors. The first four interactive sheets generate cubic expressions and the steps in the algebraic long division method can be gradually revealed. The constant term in the cubic can be altered to show how it affects the remainder. Some of...

Pages

View all publishers