Search by Topic

Resources tagged with Spreadsheets similar to Farey Approximation:

Filter by: Content type:
Stage:
Challenge level:

Farey Approximation

Stage: 5 Short Challenge Level:

Use Farey sequences to obtain rational approximations to irrational numbers.

Excel Investigation: Fraction Combinations

Stage: 3 and 4 Challenge Level:

Choose four numbers and make two fractions. Use an Excel spreadsheet to investigate their properties. Can you generalise?

Excel Technique: Logic Tests

Stage: 3 and 4 Challenge Level:

Learn how to use logic tests to create interactive resources using Excel.

Excel Investigation: Target Decimal

Stage: 3 and 4 Challenge Level:

Use an Excel spreadsheet to approximate a decimal using trial and improvement.

Excel Technique: LCM & HCF (or GCD)

Stage: 3 and 4 Challenge Level:

Learn how to use the Excel functions LCM and GCD.

Excel Investigation: Multiples of Three

Stage: 3 and 4 Challenge Level:

Use Excel to investigate digit sums of multiples of three. Can you explain your findings?

Stage: 3 and 4 Challenge Level:

Use Excel to investigate remainders and divisors. Was your result predictable?

Excel Technique: LOOKUP Functions

Stage: 3 and 4 Challenge Level:

Learn how to use lookup functions to create exciting interactive Excel spreadsheets.

Excel Investigation: Happy Numbers

Stage: 3 and 4 Challenge Level:

Take any whole number between 1 and 999, add the squares of the digits to get a new number. Use a spreadsheet to investigate this sequence.

Excel Technique: Composite Bar Charts

Stage: 3 and 4 Challenge Level:

Learn how to use composite bar charts in Excel.

Excel Investigation: Ring on a String

Stage: 3 and 4 Challenge Level:

This investigation uses Excel to optimise a characteristic of interest.

Excel Technique: Conditional Formatting

Stage: 3 and 4 Challenge Level:

Learn how to use conditional formatting to create attractive interactive spreadsheets in Excel.

Excel Investigation: Number Pyramids

Stage: 3 and 4 Challenge Level:

Use Excel to create some number pyramids. How are the numbers in the base line related to each other? Investigate using the spreadsheet.

Excel Technique: Triangular Arrays by Turning Off Zeros

Stage: 3 and 4 Challenge Level:

Learn how to use Excel to create triangular arrays.

Excel Investigation: Pascal Multiples

Stage: 3 and 4 Challenge Level:

This spreadsheet highlights multiples of numbers up to 20 in Pascal's triangle. What patterns can you see?

Excel Investigation: Pythagorean Triples

Stage: 3 and 4 Challenge Level:

Use Excel to find sets of three numbers so that the sum of the squares of the first two is equal to the square of the third.

Excel Interactive Resource: Long Multiplication

Stage: 3 and 4 Challenge Level:

Use an Excel spreadsheet to explore long multiplication.

Negative Power

Stage: 4 Challenge Level:

What does this number mean ? Which order of 1, 2, 3 and 4 makes the highest value ? Which makes the lowest ?

Excel Technique: Inserting an Increment Button

Stage: 3 and 4 Challenge Level:

Learn how to use increment buttons and scroll bars to create interactive Excel resources.

Excel Interactive Resource: Make a Copy

Stage: 3 and 4 Challenge Level:

Investigate factors and multiples using this interactive Excel spreadsheet. Use the increment buttons for experimentation and feedback.

Excel Technique: Making a Table for a Function of Two Independent

Stage: 3 and 4 Challenge Level:

Learn how to make a simple table using Excel.

Excel Investigation: Sums of Consecutive Numbers

Stage: 3 and 4 Challenge Level:

A heap of beads was shared out by a professional bead sharer. Use the information given to find out how many beads there were at the start.

Excel Investigation: Difference Tuples

Stage: 3 and 4 Challenge Level:

Use an Excel spreadsheet to investigate differences between four numbers. Which set of start numbers give the longest run before becoming 0 0 0 0?

Excel Interactive Resource: Haitch

Stage: 3 and 4 Challenge Level:

An Excel spreadsheet with an investigation.

Getting to Know Excel

Stage: 3 and 4 Challenge Level:

A number of useful techniques that can extend your use of Excel.

Excel Investigation: the Difference of Two (same) Powers

Stage: 3 and 4 Challenge Level:

If you take two integers and look at the difference between the square of each value, there is a nice relationship between the original numbers and that difference. Can you find the pattern using. . . .

Excel Investigation: Power Crazy

Stage: 3 and 4 Challenge Level:

When is 7^n + 3^n a multiple of 10? Use Excel to investigate, and try to explain what you find out.

Excel Investigation: Planks

Stage: 3 and 4 Challenge Level:

I have an unlimited supply of planks, of lengths 7 and 9 units. Putting planks end to end, what total lengths can be achieved? Use Excel to investigate.

Peaches in General

Stage: 4 Challenge Level:

It's like 'Peaches Today, Peaches Tomorrow' but interestingly generalized.

Percentages for Key Stage 4

Stage: 4 Challenge Level:

A group of interactive resources to support work on percentages Key Stage 4.

Unusual Long Division - Square Roots Before Calculators

Stage: 4 Challenge Level:

However did we manage before calculators? Is there an efficient way to do a square root if you have to do the work yourself?

Excel Interactive Resource: Interactive Division

Stage: 3 and 4 Challenge Level:

Use an Excel to investigate division. Explore the relationships between the process elements using an interactive spreadsheet.

Euler's Squares

Stage: 4 Challenge Level:

Euler found four whole numbers such that the sum of any two of the numbers is a perfect square...

Odd Differences

Stage: 4 Challenge Level:

The diagram illustrates the formula: 1 + 3 + 5 + ... + (2n - 1) = n² Use the diagram to show that any odd number is the difference of two squares.

Succession in Randomia

Stage: 5 Challenge Level:

By tossing a coin one of three princes is chosen to be the next King of Randomia. Does each prince have an equal chance of taking the throne?

Excel Interactive Resource: Fraction Multiplication

Stage: 3 and 4 Challenge Level:

Use Excel to explore multiplication of fractions.

Excel Interactive Resource: Number Grid Functions

Stage: 3 and 4 Challenge Level:

Use Excel to investigate the effect of translations around a number grid.

Excel Interactive Resource: Multiples Chain

Stage: 3 and 4 Challenge Level:

Use an interactive Excel spreadsheet to investigate factors and multiples.

Excel Interactive Resource: Fraction Addition & Fraction Subtraction

Stage: 3 and 4 Challenge Level:

Use Excel to practise adding and subtracting fractions.

Training Schedule

Stage: 4 Challenge Level:

The heptathlon is an athletics competition consisting of 7 events. Can you make sense of the scoring system in order to advise a heptathlete on the best way to reach her target?

Under the Ribbon

Stage: 4 Challenge Level:

A ribbon is nailed down with a small amount of slack. What is the largest cube that can pass under the ribbon ?

Excel Interactive Resource: Equivalent Fraction Bars

Stage: 3 and 4 Challenge Level:

A simple file for the Interactive whiteboard or PC screen, demonstrating equivalent fractions.

Excel Interactive Resource: the up and Down Game

Stage: 3 and 4 Challenge Level:

Use an interactive Excel spreadsheet to explore number in this exciting game!

Pythagoras’ Comma

Stage: 4 Challenge Level:

Using an understanding that 1:2 and 2:3 were good ratios, start with a length and keep reducing it to 2/3 of itself. Each time that took the length under 1/2 they doubled it to get back within range.

Any Win for Tennis?

Stage: 5 Challenge Level:

What are your chances of winning a game of tennis?

Funnel

Stage: 4 Challenge Level:

A plastic funnel is used to pour liquids through narrow apertures. What shape funnel would use the least amount of plastic to manufacture for any specific volume ?

Zeller's Birthday

Stage: 4 Challenge Level:

What day of the week were you born on? Do you know? Here's a way to find out.