Solve Simultaneous Equations AlgebraicallyQuick View
MattDunbar

Solve Simultaneous Equations Algebraically

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Solve two linear equations, add or subtract (+ve x & y). Solve two linear equations, add or subtract (±ve x & y). Solve two linear equations, add or subtract (fractional x & y). Solve two linear equations, multiply one (+ve x & y). Solve two linear equations, multiply one (±ve x & y). Solve two linear equations, multiply one (fractional x & y). Solve two linear equations, multiply both (+ve x & y). Solve two linear equations, multiply both (±ve x & y). Solve two linear equations, multiply both (fractional x & y). Solve linear & quadratic equations simultaneously (±ve x & y). Solve linear & quadratic equations simultaneously (fractional x & y). Solve linear & quadratic equations simultaneously (decimal x & y).
Solve Simultaneous Equations GraphicallyQuick View
MattDunbar

Solve Simultaneous Equations Graphically

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Solve two linear equations of the form ax + by = c (+ve x, y axes). Solve two linear equations of the form ax + by = c (±ve x, y axes). Solve a quadratic function & linear y = mx + c (integers). Solve a quadratic function & linear y = mx + c (fractions). Solve a quadratic function & linear ax + by = c (integers). Solve a quadratic function & linear ax + by = c (fractions). Solve an equation of a circle & linear y = mx + c (integers). Solve an equation of a circle & linear y = mx + c (surd r & fractions). Solve an equation of a circle & linear ax + by = c (integers). Solve an equation of a circle & linear ax + by = c (surd r & integers).
Interquartile Range & Percentiles Of Data SetsQuick View
MattDunbar

Interquartile Range & Percentiles Of Data Sets

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Find lower quartile Q₁ median Q₂ upper quartile Q₃ & IQR (odd n). Find lower quartile Q₁ median Q₂ upper quartile Q₃ & IQR (even n). Find 10ᵗʰ percentile position P₁₀ & value V₁₀ from a set of lengths. Find 25ᵗʰ percentile position P₂₅ & value V₂₅ from a set of times. Find 50ᵗʰ percentile position P₅₀ & value V₅₀ from a set of temp’s. Find 75ᵗʰ percentile position P₇₅ & value V₇₅ from a set of points. Find 90ᵗʰ percentile position P₉₀ & value V₉₀ from a set of weights. Find 95ᵗʰ percentile position P₉₅ & value V₉₅ from a set of marks. Find the percentile position a girl’s result in points occupies. Find the percentile position a runner’s time in h & m occupies. Find the percentile position a temperature in °C to 1 d.p. occupies.
Graphs Of Reciprocal & Exponential FunctionsQuick View
MattDunbar

Graphs Of Reciprocal & Exponential Functions

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Write the equation of a graph as y = f(x) & its proportion statement. Complete a table & plot a graph of a positive reciprocal function. Complete a table & plot a graph of a positive exponential function. Complete a table & plot a graph of a negative exponential function. Complete a table & plot a graph of a decimal exponential function. Match different graphs on the same axes to one of five functions. Use interpolation to estimate x & y on a +ve reciprocal graph. Use interpolation to estimate x & y on a +ve exponential graph. Use interpolation to estimate x & y on a −ve exponential graph. Use interpolation to estimate x & y on a decimal exponential graph. Find the values k, l, m & n given 4 points on a +ve reciprocal graph. Find the values a, k & y given 2 points on a +ve exponential graph. Find the values a, k & y given 2 points on a −ve exponential graph.
Powers, Roots & Index LawsQuick View
MattDunbar

Powers, Roots & Index Laws

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Complete a table of the first ten integer powers of one positive №. Complete a table of powers & evaluate powers & roots using it. Represent small ±ve powers of the first twelve integers on a № line. Evaluate random ±ve integers, decimals & fractions to ±ve powers. Evaluate user-defined №s to ±ve integer, decimal, fractional powers. Write negative integer powers of numbers as unit fractions. Find ±ve square or cube roots of given square or cube numbers. Estimate square roots or cube roots using upper & lower bounds. Write numbers & products as integer single powers in index form. Evaluate sums, products, quotients of powers & roots expressions. Multiply & divide integer powers using the three laws of indices. Evaluate exactly integers to the power of fractional indices. Write expressions as integers to the power of fractional indices.
Proof Of Circle TheoremsQuick View
MattDunbar

Proof Of Circle Theorems

(1)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Prove the angle subtended by the diameter is a right angle. Prove the angle at the centre is twice that at circumference. Prove the opposite angles of cyclic quadrilateral sum to 180°. Prove the angle in the alternate segment is equal.
Pascals TriangleQuick View
MattDunbar

Pascals Triangle

(0)
Interactive macro-enabled MS-Excel spreadsheet. A dynamic pyramid which enables the teacher to present a wide variety of mathematical sequences & patterns within Pascals Triangle.
Completing The Square & Quadratic FormulaQuick View
MattDunbar

Completing The Square & Quadratic Formula

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Use a visual method to derive the completing the square formula. Rewrite a given quadratic expression ax² + bx or ax² + bx + c. Solve quadratic equations writing x as a decimal or in surd form. Write a graph’s equation as y = (x + p)² + q & find turning point P. Write a graph’s equation as y = a(x + p)² + q & find turning point P. Write a graph’s equation as y = x² + bx + c using its minimum P. Write a graph’s equation as y = −x² + bx + c using its maximum P. Write p & q in terms of a, b & c then use them to find the roots & P. Use completing the square to derive the quadratic formula. Use the quadratic formula to solve a quadratic equation. Use the quadratic formula to solve a graph of a quadratic equation. Write formulae for the sum & product of the two roots & evaluate. Evaluate the golden ratio as a surd & decimal using a rectangle.
Time, Clocks, Timetables & CalendarsQuick View
MattDunbar

Time, Clocks, Timetables & Calendars

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Write an analogue clock’s time in words, am/pm & 24-hour form. Use the mnemonic of months & complete units of time definitions. Find the number of days between two dates of the calendar. Find times around the world using differences between time-zones. Convert a period of time in mixed units to single units & vice versa. Interpret a calculator display as a mixed number fraction of time. Find total time ΣT & time interval ΔT given 2 times to 1, 2 or 3 d.p. Find a film’s length given a start & finish in am/pm or 24-hour form. Find the time by using & completing school, bus & train timetables. Find the time remaining till half-time or full-time plus injury-time. Find the mean duration or average running time of a table of films. Find a simple fraction or decimal (<1) or % of an hour or day. Find a mixed number or decimal fraction (>1) of an hour or day.
Density & PressureQuick View
MattDunbar

Density & Pressure

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Find an item’s density, mass or volume using a formula. Find an item’s density, mass or volume using a table. Find a surface’s pressure, force or area using a formula. Find a surface’s pressure, force or area using a table. Find volume V & mass M of a cuboid given its density D, l, w & h. Find volume V & density D of a cuboid given its mass M, l, w & h. Find density D of a coin given its mass M, thickness t & diameter d. Find volume V & density D of a sphere of diameter d & mass M. Find pressure P a cube of length x & density D exerts on a surface.
Direct & Inverse ProportionQuick View
MattDunbar

Direct & Inverse Proportion

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Write a given graph as a function y = f(x) & a proportion statement. Find constant of proportionality k & complete a table (y = kx). Find constant of proportionality k & complete a table (y = kx⁻¹). Find constant of proportionality k & complete a table (y = kx²). Find constant of proportionality k & complete a table (y = kx⁻²). Find constant of proportionality k & complete a table (y = kx³). Find constant of proportionality k & complete a table (y = kx⁻³). Find constant of proportionality k & complete a table (y = k√x). Find constant of proportionality k & complete a table (y = k∛x). Find values by writing a formula connecting 2 given №s (linear). Find values by writing a formula connecting 2 given №s (powers). Find values by writing 2 formulae connecting 3 given №s (linear). Find values by writing 2 formulae connecting 3 given №s (powers).
Graphs Of Trigonometric FunctionsQuick View
MattDunbar

Graphs Of Trigonometric Functions

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Complete a table & draw the unit circle using cos θ (x) & sin θ (y). Complete a table & draw the tangent to the unit circle using tan θ. Complete all three trigonometric ratios on a half-circle protractor. Plot a graph of the sin function in the range 0° ≤ θ ≤ 360°. Plot a graph of the cos function in the range 0° ≤ θ ≤ 360°. Plot a graph of the tan function in the range 0° ≤ θ ≤ 360°. Plot graphs of sin & cos functions in the range 0° ≤ θ ≤ 360°. Plot graphs of sin, cos & tan functions in the range 0° ≤ θ ≤ 360°. Plot a graph of the sin function in the range −180° ≤ θ ≤ 180°. Plot a graph of the cos function in the range −180° ≤ θ ≤ 180°. Plot a graph of the tan function in the range −180° ≤ θ ≤ 180°. Plot graphs of sin & cos functions in the range −180° ≤ θ ≤ 180°. Plot graphs of sin, cos & tan functions in the range −180° ≤ θ ≤ 180°.
Inequality Symbols, Variables & Number LinesQuick View
MattDunbar

Inequality Symbols, Variables & Number Lines

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Compare the heights of two sets of tiles using inequality symbols. Compare two ±ve integers or decimals using inequality symbols. Compare two ±ve decimal temperatures using inequality symbols. Compare two fractions, decimals or %s using pies & inequalities. Compare two lengths or weights or volumes using inequalities. Evaluate & compare proportions of an amount using inequalities. Write inequality expressions involving n or another suitable letter. Describe linear inequalities on a number line in one variable n. Represent linear inequalities on a number line in one variable n. Solve & represent linear inequalities in one variable n (1, 2, 3-step). Solve & represent linear inequalities in one variable n (both sides). Solve & represent simple quadratic inequalities in one variable n. Solve, factorise & represent quadratic inequalities in one variable x.
Venn Diagrams & Set NotationQuick View
MattDunbar

Venn Diagrams & Set Notation

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Complete 2-circle Venn diagrams by placing numbers in regions. Complete 3-circle Venn diagrams by placing numbers in regions. Complete & interpret 2-circle Venn diagrams to find probabilities. Complete & interpret 3-circle Venn diagrams to find probabilities. Complete Venn diagrams given decimal probabilities of all regions. Complete Venn diagrams by writing 2-step linear equations. Complete Venn diagrams by writing equations with x on both sides. Complete Venn diagrams by writing quadratic equations. Complete Venn diagrams by representing a theory & practical test. Complete Venn diagrams by classifying ten different triangles. Complete Venn diagrams by classifying ten different quadrilaterals. Know all 16 set notations & associated regions of Venn diagrams. Identify elements in regions of Venn diagrams using set notation.
Coordinates & Straight-Line GraphsQuick View
MattDunbar

Coordinates & Straight-Line Graphs

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Read or plot (x, y) coordinates in the 1ˢᵗ quadrant or all 4 quadrants. Find the equation of a line parallel to the axes or main diagonal. Find the equation of 2 lines parallel to the axes or main diagonal. Generate coordinates & plot a straight-line graph on +ve axes. Generate coordinates & plot 2 straight-line graphs on +ve axes. Generate coordinates & plot a straight-line graph on ±ve axes. Generate coordinates & plot 2 straight-line graphs on ±ve axes. Find the gradient of 2 straight-line segments on +ve or ±ve axes. Find the gradient, y-intercept & equation of a straight-line graph. Find the equation & point of intersection of 2 straight-line graphs. Find the equation & point of intersection of 4 straight-line graphs. Draw the straight-line graph of an equation of the form ax + by = c. Draw the straight-line graph of 2 equations of the form ax + by = c.
Solve Problems Using AveragesQuick View
MattDunbar

Solve Problems Using Averages

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the overall mean score of pupils (integer) or films (decimal). Find the mass of peas from the largest pods in Mr. Pareto’s garden. Find the weight or height of a player & a sub’ after a mean changes. Find an overall average speed or daily temp given two sets of data. Find the position a sprinter finished given a mean & all other times. Find the median, mode & range of a data set given its mean & ratio. Find the mean reaction time of the right-handed given mean of left. Find two twins’ ages after they & another change a nursery’s mean. Find each gender’s mean mark given a % uplift, a mean & a ratio. Find December’s sales to beat a colleague’s monthly mean by a %. Find the original & new mean if balls are added & a mean changes. Find the median, mode & range of a linear algebraic data set. Find the median, mode & range of a quadratic algebraic data set.
Non-Linear Sequences In 2D Spatial PatternsQuick View
MattDunbar

Non-Linear Sequences In 2D Spatial Patterns

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the first ten square numbers by drawing a series of squares. Find the first ten triangle numbers by drawing a series of circles. Find the first ten rectangle numbers by drawing a series of squares. Find the first five factorial numbers by drawing a series of squares. Find the first six powers of two by drawing a series of squares. Find a formula for number of cells C in a rectangular pattern. Find a formula for number of squares S in a triangular pattern. Find a formula for number of diagonals D in a regular polygon. Find a formula for number of cells C in a triangular star pattern. Find a formula for number of cells C in a compound shape pattern. Find a formula for number of cells C in a centred-square array. Find a formula for number of discs D in a centred-hexagonal array. Find a formula for number of regions R inside overlapping circles.
Solve Problems Using Ratio (Foundation)Quick View
MattDunbar

Solve Problems Using Ratio (Foundation)

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Solve problems involving cost of items by direct proportion. Divide a box of items into two or three colours in a given ratio. Share an amount of items between three friends in a given ratio. Divide an amount of money into two or three parts in a given ratio. Divide the angles of a triangle in a given ratio then draw it. Convert one currency into another using direct proportion. Solve direct proportion problems by the unitary method. Solve direct proportion problems using ratio tables & arrows. Solve direct proportion problems by scaling quantities. Solve direct proportion problems using ratio multipliers. Adapt a recipe’s ingredients & find № served by scaling quantities. Use parallel № lines to find a multiplier or scale factor & its inverse. Combine two 2-part ratios into one 3-part ratio & find three values.
Linear, Geometric & Quadratic SequencesQuick View
MattDunbar

Linear, Geometric & Quadratic Sequences

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Extend linear sequences & describe the term-to-term rules. Extend geometric sequences & describe the term-to term rules. Extend quadratic sequences & describe the term-to term rules. Generate terms of linear sequences from term-to-term rules. Generate terms of geometric sequences from term-to-term rules. Generate terms of quadratic sequences from term-to-term rules. Generate terms of linear sequences from position-to-term rules. Generate terms of geometric sequences from rules (user-defined). Generate terms of geometric sequences from rules (randomised). Generate terms of quadratic sequences from position-to-term rules. Write expressions to describe the nᵗʰ term of linear sequences. Write expressions to describe the nᵗʰ term of geometric sequences. Write expressions to describe the nᵗʰ term of quadratic sequences.
Linear Sequences In 2D Spatial PatternsQuick View
MattDunbar

Linear Sequences In 2D Spatial Patterns

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the first 10 odd & even numbers by drawing a series of circles. Find an expression for the number of rings in the nᵗʰ pattern. Find an expression for the number of rhombi in the nᵗʰ pattern. Find an expression for the number of triangles in the nᵗʰ pattern.Find an expression for the number of matches in the nᵗʰ pattern. Find an expression for the number of blue tiles in the nᵗʰ pattern. Find an expression for the number of red lines in the nᵗʰ pattern. Find a formula for number of tiles T to surround a pool given l & w. Find a formula for number of matches M in a rectangle given l & w. Find a formula for number of discs D in a trapezium given n, b & h.
Solve Problems Using Fractions (Higher)Quick View
MattDunbar

Solve Problems Using Fractions (Higher)

(0)
Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the fraction of items in a bag that are discs & tiles given ratios. Find the № of passengers on a plane given two fractions of a total. Find the № of pupils at a school given two fractions & a ratio 1 : n. Find the cost to fill up two tanks using two fuel gauges & unit costs. Find the fraction of hats I call large relative to calculated mean size. Find the total cost to feed two dogs given a fraction of a tin they eat. Find the number of goals a team must score to achieve a mean. Find the museum visitor rate given two fractions of total time open. Find the age of two children given the age difference & ratio a : b. Find the № of pupils at a club given two fractions of a litre of juice. Find the fraction of questions a pupil got right given his final score. Find the № of toys given a cost, fractional reduction & final profit. Find the № of nuts & raisins given two fractions & one difference.