Flexible Interactive Workbooks in Excel

Resources

Classroom Ready Resources

All of the resources on this Website can be accessed form the side bar on every page. This page also includes a description of each resource.

The resources are best viewed in full screen mode in Excel, (View, Full screen from the menu). Each of the workbooks has a 'Read me' page with instructions and ideas for use, though each workbook is designed to be as flexible as possible in it's range of applications.

Number and Algebra

1. Fractions ratios decimals and percentages
   Compare equivalent fractions, ratios, decimals and percentages. Change a grid of squares to represent a proportion. Show or hide the fractions, ratios, decimals and percentages.

2. Grid Puzzles
   Produces random grid puzzles to solve. Choose the range of numbers and the operation.

3. Inequalities
   Represents inequalities on a number line. Show one inequality or combined inequalities.

4. Multipliers
   Use and find multipliers from one number to another. Randomly selects original number and multiplier according to user settings. Show/hide different values.

5. Negative number line
   Show negative numbers moving up and down a number line. Show/hide the numbers and/or their position on the number line.

6. Number Grids
   An interactive number grid. Change the size of the grid and colour squares in different colours.

7. Number Line
   An interactive number line. Change the start and end values or change the interval. Show/hide the numbers on the line.

8. Operations
   An interactive multiplication grid and grids for the other three operations. Show/hide values and colour squares.

9. Percentage increase and decrease
   Use and find percentage increase and decrease, including reverse percentage problems. Show/hide any of the values.

10. Product and Sum
    Shows two numbers and their product and sum. Show/hide any ofthese values. Includes a random option.

11. Proportionality
    Investigate direct, inverse and square proportionality. Interactive workbook, containing table of values, graph and equation.

12. Quadratic expressions
    Investigate the different forms of a quadratic expression and their graph.

13. Random number
    Simply produces a random number to your specification!

14. Rounding
    Round numbers to varying degrees of accuracy. Represent the number on a number line. Show which digit is important in deciding whether to round up or down. Show/Hide digits.

15. Sequence generator
    Investigate various sequences with this interactive workbook. Show/hide values and formulas, change the settings to suit the class. Contains linear, quadratic, exponential and fibonacci sequences.

16. Simultaneous equations
    Investigate the graphical solitions of simultaneous equations. Alter the equations and see how the graphs change and how this affects the intersection point.

17. Multiples
    This workbook shows if a value you select is a multiple of two other numbers. The value will be highlighted if it is a multiple.

18. Testing Divisibility
    Tests numbers for divisibility. This workbook allows students to explore tests for divisibility of 2, 3, 4, 5, 6, 7, 9, 10 & 11.

19. Multiplication Game (NEW)
    An interactive multiplication game for two players. This game is played on an interactive whiteboard. Hit the answer to the multiplication question before your opponent and score a point. Get one wrong and lose a point! Settings available to customise questions.

Shape and Space

1. 12 & 24 hour clock
   Displays the time shown on an analogue clock in digital format using both 12 and 24 hour clock. Show/Hide digital clocks.

2. Coordinate shapes
   Enter coordinates to draw shapes on the grid. Use the first or all four quadrants.

3. Coordinates
   Enter Coordinates to plot them on the axes. Use the first or all four quadrants.

4. Investigating Trigonometry
   Investigate the sine, cosine and tangent ratios by looking at the lengths of the sides of a right angled triangle. Alter the triangles in a number of ways.

5. Measuring
   An interactive scale. Change the scale by altering the size of the divisions. Includes negative numbers to look at temperature. Alter the size of the measurment.

Handling Data

1. Averages
   Compare a small set of data with it's mean, median, mode and range. Find the summary data from the raw data or find the raw data from the summary data. Show/hide all values.

2. Correlation
   Investigate correlation. Produces randon data based on your settings. Comment on correlation, outliers and relationships. Extends to A'Level Statistics including PMCC.

3. Data Set 1 - Goals per game
   Compare several sets of football related data. Interactive features include automatic sorting, all summary values calculated, colour cells or boundaries between cells, view box plots for the data.

4. Data Set 2 - Daisies per sq metre
   Same as above, but for flower related data, (well, sort of!)

5. Data Set 3 - Stamps in a week
   Interactive frequency table. Includes group totals for calculating mean and cumulative frequencies for finding the median. Show/hide values.

6. Data set 4 - Colours of cars
   Compare Frequency diagram and pie chart for qualitative data. Show/hide the data or the graphs.

7. Point Plotter
   Simply plot points entered on a set of axes. Compare the points with various types of best fit lines.

8. Racing
   Roll the Dice to move the cars! Which will win? Change the rule to move the cars, change the maximum number on each die. Investigate combined probability.

9. Space Diagrams
   Create space diagrams for investigating combined probability. Includes finding the sum, difference, maximum and minimum of two numbers.

10. Spinner
    A random spinner with user defined outcomes.

11. The Bandit
    An interactive one armed bandit! Change the settings to make the bandit more or less likely to pay up!

A-Level - Mechanics 1

1. Constant Acceleration (2D)
   Investigate motion in two dimensions under constant acceleration. Set initial position and velocity, and acceleration and then see what happens as time changes. View an animation of the motion for your settings.

2. Friction
   Investigate Friction on a horizontal surface. Set mass and angle of force and then see what happens as the force increases.

3. Momentum (1D)
   Investigate momentum in one dimension. Set mass and initial velocity of two particles. View an animation of the motion for your settings.

4. Vectors
   Look at position vectors and resultant vectors.

5. Resultant Velocity
   Investigate motion in two dimensions of a boat moving in a current. Set initial position and velocity, and then see what happens as time changes. Use column vectors or magnitude and bearing. View an animation of the motion for your settings.

A-Level - Mechanics 2

1. Centre of mass
   Investigate centre of mass in one or two dimensions. Considering a system of particles, set the mass and position of each particle, then find the centre of mass.

2. Equilibrium of a rigid body
   Investigate Equilibrium problems involving a horizontal beam resting on two supports, with or without an extra force being applied.

A-Level - Mechanics 4

1. Topple or Slide?
   Will the block topple or slide? Set various values, then increase the force and see what happens.

A-Level - Statistics 1

1. The Effect of Multiplication and Division on a Distribution
   Investigate the effect of multiplication and addition on the mean and standard deviation of a distribution.

2. Sampling
   A workbook that allows you to take random samples of various sizes from three different distributions. Gives the mean and stanard deviation of each sample. Explore the distribution of sample means. Ideal for investigating sampling and the central limit theorem.