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>
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>
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>
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>
Venn Diagrams & Set NotationQuick View
MattDunbar

Venn Diagrams & Set Notation

(0)
<p>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 &amp; interpret 2-circle Venn diagrams to find probabilities. Complete &amp; 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 &amp; practical test. Complete Venn diagrams by classifying ten different triangles. Complete Venn diagrams by classifying ten different quadrilaterals. Know all 16 set notations &amp; associated regions of Venn diagrams. Identify elements in regions of Venn diagrams using set notation.</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>
Rearrange Formulae To Change The SubjectQuick View
MattDunbar

Rearrange Formulae To Change The Subject

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Rearrange 1-step formulae using function machines. Rearrange 2-step formulae using function machines. Rearrange 3-step formulae using function machines. Rearrange 1-step formulae by transforming both sides. Rearrange 2-step formulae by transforming both sides. Rearrange 3-step formulae by transforming both sides. Rearrange formulae where the subject appears on both sides. Rearrange formulae where the subject appears twice on one side. Rearrange formulae where the subject appears in a reciprocal. Rearrange formulae where the subject appears in a fraction’s N &amp; D.</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>
Solve Problems Using AveragesQuick View
MattDunbar

Solve Problems Using Averages

(0)
<p>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 &amp; 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 &amp; all other times. Find the median, mode &amp; range of a data set given its mean &amp; ratio. Find the mean reaction time of the right-handed given mean of left. Find two twins’ ages after they &amp; another change a nursery’s mean. Find each gender’s mean mark given a % uplift, a mean &amp; a ratio. Find December’s sales to beat a colleague’s monthly mean by a %. Find the original &amp; new mean if balls are added &amp; a mean changes. Find the median, mode &amp; range of a linear algebraic data set. Find the median, mode &amp; range of a quadratic algebraic data set.</p>
Pie Charts Of Categorical DataQuick View
MattDunbar

Pie Charts Of Categorical Data

(0)
<p>Interactive macro-enabled MS-Excel spreadsheet. Contents: Use fractions, %s &amp; ratio to compare pets in a pet shop (±10%). Use fractions, %s &amp; ratio to compare fruit in an orchard (±5%). Use fractions, %s &amp; ratio to compare genres of movie (±1%). Interpret pie charts by finding the size of the angle for each sector. Interpret pie charts by finding the value of each fractional sector. Compare surveys of pupil’s favourite movies at two schools (±5%). Compare studies of daily sales of food items from two cafés (±1%). Draw pie charts for a simple data set by fraction of a circle method. Draw pie charts for a simple data set by unit angle method. Draw pie charts for any data set by fraction of a circle method. Draw pie charts for any data set by unit angle method. Find algebraic angles &amp; proportions by writing linear equations. Find algebraic angles &amp; proportions by writing quadratic equations.</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>