Solve Simultaneous Equations AlgebraicallyQuick View
MattDunbar

Solve Simultaneous Equations Algebraically

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

Solve Simultaneous Equations Graphically

(0)
<p>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 &amp; linear y = mx + c (integers). Solve a quadratic function &amp; linear y = mx + c (fractions). Solve a quadratic function &amp; linear ax + by = c (integers). Solve a quadratic function &amp; linear ax + by = c (fractions). Solve an equation of a circle &amp; linear y = mx + c (integers). Solve an equation of a circle &amp; linear y = mx + c (surd r &amp; fractions). Solve an equation of a circle &amp; linear ax + by = c (integers). Solve an equation of a circle &amp; linear ax + by = c (surd r &amp; integers).</p>
Interquartile Range & Percentiles Of Data SetsQuick View
MattDunbar

Interquartile Range & Percentiles Of Data Sets

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Find lower quartile Q₁ median Q₂ upper quartile Q₃ &amp; IQR (odd n). Find lower quartile Q₁ median Q₂ upper quartile Q₃ &amp; IQR (even n). Find 10ᵗʰ percentile position P₁₀ &amp; value V₁₀ from a set of lengths. Find 25ᵗʰ percentile position P₂₅ &amp; value V₂₅ from a set of times. Find 50ᵗʰ percentile position P₅₀ &amp; value V₅₀ from a set of temp’s. Find 75ᵗʰ percentile position P₇₅ &amp; value V₇₅ from a set of points. Find 90ᵗʰ percentile position P₉₀ &amp; value V₉₀ from a set of weights. Find 95ᵗʰ percentile position P₉₅ &amp; 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 &amp; m occupies. Find the percentile position a temperature in °C to 1 d.p. occupies.</p>
Completing The Square & Quadratic FormulaQuick View
MattDunbar

Completing The Square & Quadratic Formula

(0)
<p>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 &amp; find turning point P. Write a graph’s equation as y = a(x + p)² + q &amp; 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 &amp; q in terms of a, b &amp; c then use them to find the roots &amp; 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 &amp; product of the two roots &amp; evaluate. Evaluate the golden ratio as a surd &amp; decimal using a rectangle.</p>
Direct & Inverse ProportionQuick View
MattDunbar

Direct & Inverse Proportion

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Write a given graph as a function y = f(x) &amp; a proportion statement. Find constant of proportionality k &amp; complete a table (y = kx). Find constant of proportionality k &amp; complete a table (y = kx⁻¹). Find constant of proportionality k &amp; complete a table (y = kx²). Find constant of proportionality k &amp; complete a table (y = kx⁻²). Find constant of proportionality k &amp; complete a table (y = kx³). Find constant of proportionality k &amp; complete a table (y = kx⁻³). Find constant of proportionality k &amp; complete a table (y = k√x). Find constant of proportionality k &amp; 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).</p>
Graphs Of Trigonometric FunctionsQuick View
MattDunbar

Graphs Of Trigonometric Functions

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Complete a table &amp; draw the unit circle using cos θ (x) &amp; sin θ (y). Complete a table &amp; 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 &amp; cos functions in the range 0° ≤ θ ≤ 360°. Plot graphs of sin, cos &amp; 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 &amp; cos functions in the range −180° ≤ θ ≤ 180°. Plot graphs of sin, cos &amp; tan functions in the range −180° ≤ θ ≤ 180°.</p>
Graphs Of Reciprocal & Exponential FunctionsQuick View
MattDunbar

Graphs Of Reciprocal & Exponential Functions

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Write the equation of a graph as y = f(x) &amp; its proportion statement. Complete a table &amp; plot a graph of a positive reciprocal function. Complete a table &amp; plot a graph of a positive exponential function. Complete a table &amp; plot a graph of a negative exponential function. Complete a table &amp; 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 &amp; y on a +ve reciprocal graph. Use interpolation to estimate x &amp; y on a +ve exponential graph. Use interpolation to estimate x &amp; y on a −ve exponential graph. Use interpolation to estimate x &amp; y on a decimal exponential graph. Find the values k, l, m &amp; n given 4 points on a +ve reciprocal graph. Find the values a, k &amp; y given 2 points on a +ve exponential graph. Find the values a, k &amp; y given 2 points on a −ve exponential graph.</p>
Inequality Symbols, Variables & Number LinesQuick View
MattDunbar

Inequality Symbols, Variables & Number Lines

(0)
<p>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 &amp; inequalities. Compare two lengths or weights or volumes using inequalities. Evaluate &amp; 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 &amp; represent linear inequalities in one variable n (1, 2, 3-step). Solve &amp; represent linear inequalities in one variable n (both sides). Solve &amp; represent simple quadratic inequalities in one variable n. Solve, factorise &amp; represent quadratic inequalities in one variable x.</p>
Powers, Roots & Index LawsQuick View
MattDunbar

Powers, Roots & Index Laws

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Complete a table of the first ten integer powers of one positive №. Complete a table of powers &amp; evaluate powers &amp; roots using it. Represent small ±ve powers of the first twelve integers on a № line. Evaluate random ±ve integers, decimals &amp; 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 &amp; lower bounds. Write numbers &amp; products as integer single powers in index form. Evaluate sums, products, quotients of powers &amp; roots expressions. Multiply &amp; 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.</p>
Coordinates & Straight-Line GraphsQuick View
MattDunbar

Coordinates & Straight-Line Graphs

(0)
<p>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 &amp; plot a straight-line graph on +ve axes. Generate coordinates &amp; plot 2 straight-line graphs on +ve axes. Generate coordinates &amp; plot a straight-line graph on ±ve axes. Generate coordinates &amp; 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 &amp; equation of a straight-line graph. Find the equation &amp; point of intersection of 2 straight-line graphs. Find the equation &amp; 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.</p>
Proof Of Circle TheoremsQuick View
MattDunbar

Proof Of Circle Theorems

(1)
<p>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.</p>
Pascals TriangleQuick View
MattDunbar

Pascals Triangle

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. A dynamic pyramid which enables the teacher to present a wide variety of mathematical sequences &amp; patterns within Pascals Triangle.</p>
Non-Linear Sequences In 2D Spatial PatternsQuick View
MattDunbar

Non-Linear Sequences In 2D Spatial Patterns

(0)
<p>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.</p>
Linear, Geometric & Quadratic SequencesQuick View
MattDunbar

Linear, Geometric & Quadratic Sequences

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Extend linear sequences &amp; describe the term-to-term rules. Extend geometric sequences &amp; describe the term-to term rules. Extend quadratic sequences &amp; 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.</p>
Linear Sequences In 2D Spatial PatternsQuick View
MattDunbar

Linear Sequences In 2D Spatial Patterns

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the first 10 odd &amp; 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 &amp; w. Find a formula for number of matches M in a rectangle given l &amp; w. Find a formula for number of discs D in a trapezium given n, b &amp; h.</p>
Estimation, Approximation & ErrorQuick View
MattDunbar

Estimation, Approximation & Error

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Estimate a robot, alien &amp; pylon’s height given exact height of a boy. Estimate a circle’s area given exact area of a square. Estimate an equilateral triangle’s area given exact area of a square. Estimate calculations involving two numbers by rounding to 1 s.f. Estimate calculations involving four numbers by rounding to 1 s.f. Estimate calculations by rounding roots to nearest known powers. Estimate quotients by rounding to a nearest multiple. Estimate quotients by rounding to a nearest factor. Evaluate products using a given related multiplication. Evaluate quotients using a given related multiplication. Estimate addition A &amp; subtraction S in №s &amp; words form. Estimate multiplication M &amp; division D in №s &amp; words form. Describe groups of darts on targets using terms accurate &amp; precise.</p>
Pay Rates & Rates Of ChangeQuick View
MattDunbar

Pay Rates & Rates Of Change

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Find an hourly pay rate given the wage received &amp; hours worked. Find my total pay this week inc’ overtime given an hourly pay rate. Find the annual number of loaves of bread a family buys &amp; its cost. Find the annual number of bags of sugar I buy for my tea &amp; its cost. Find a truck’s fuel cost to fill it up &amp; running cost in pence per mile. Find my value in gold if my boss says I’m worth my weight in gold. Find a large meteorite’s unit price given its weight &amp; auction price. Find my hourly pay rate based on profit from making jars of jam. Find a sword’s rate of fall in temperature or rate of sales of tickets. Find a footballer’s strike rate in goals per game &amp; minutes per goal. Find a flow rate into a cuboid-shaped tank given l, w, h &amp; fill-time t. Sketch 3 graphs as 3 beakers of different diameters fill up or empty. Sketch 4 graphs as 4 flasks with different profiles fill up or empty.</p>
Time, Clocks, Timetables & CalendarsQuick View
MattDunbar

Time, Clocks, Timetables & Calendars

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Write an analogue clock’s time in words, am/pm &amp; 24-hour form. Use the mnemonic of months &amp; 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 &amp; vice versa. Interpret a calculator display as a mixed number fraction of time. Find total time ΣT &amp; time interval ΔT given 2 times to 1, 2 or 3 d.p. Find a film’s length given a start &amp; finish in am/pm or 24-hour form. Find the time by using &amp; completing school, bus &amp; 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 (&lt;1) or % of an hour or day. Find a mixed number or decimal fraction (&gt;1) of an hour or day.</p>
Surface Area & Volume Of 3D SolidsQuick View
MattDunbar

Surface Area & Volume Of 3D Solids

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the possible arrangements of unit cubes on an isometric grid. Find the surface area &amp; volume of a cuboid by counting unit cubes. Find the surface area &amp; volume of a cuboid using a given formula. Find the visible &amp; total surface area of a triangular prism. Find the visible &amp; total surface area of a trapezoidal prism. Find the visible &amp; total surface area of an L-shaped prism. Find the cross-sectional area &amp; volume of a triangular prism. Find the cross-sectional area &amp; volume of a trapezoidal prism. Find the cross-sectional area &amp; volume of an L-shaped prism. Find the surface area of a rectangular-based pyramid. Find the volume of a rectangular-based pyramid.</p>
Real-Life & Distance-Time GraphsQuick View
MattDunbar

Real-Life & Distance-Time Graphs

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Use a graph to find party cost C given number of people p. Use a graph to find repair cost C given repair time t. Use a graph to find taxi fare F given trip distance d. Use a graph to find cooking time t for turkey or beef given weight w. Use a graph to find volume V of drink made given milkshake ratio r. Use a graph to find speed of sound S at altitude A above sea level. Use a graph to find stopping distance d of a car given its speed S. Use a graph to find time t taken for tea to cool to temperature T. Use a step-graph to find 1ˢᵗ &amp; 2ⁿᵈ class letter postage p (linear axis). Use a step-graph to find unit pen price p &amp; cost C (non-linear axis). Use a distance-time graph to show a 3-stage bus run &amp; find speed. Use a distance-time graph to show a 3-stage bike ride &amp; find speed. Use a distance-time graph to show a 3-stage car trip &amp; find speed.</p>
Density & PressureQuick View
MattDunbar

Density & Pressure

(0)
<p>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 &amp; mass M of a cuboid given its density D, l, w &amp; h. Find volume V &amp; density D of a cuboid given its mass M, l, w &amp; h. Find density D of a coin given its mass M, thickness t &amp; diameter d. Find volume V &amp; density D of a sphere of diameter d &amp; mass M. Find pressure P a cube of length x &amp; density D exerts on a surface.</p>