Resources tagged with: Spreadsheets

Other tags that relate to Tree Tops

Real world. Processing and representing data. Maximise/minimise/optimise. Handling data. Interpreting data. Spreadsheets. Maths Supporting SET. Biology. Mathematical modelling. Comparing data.

There are 61 results

Broad Topics > Information and Communications Technology > Spreadsheets

Tree Tops

Age 14 to 16 Challenge Level:

Can you make sense of information about trees in order to maximise the profits of a forestry company?

What's the Weather Like?

Age 11 to 14 Challenge Level:

With access to weather station data, what interesting questions can you investigate?

The Legacy

Age 14 to 16 Challenge Level:

Your school has been left a million pounds in the will of an ex- pupil. What model of investment and spending would you use in order to ensure the best return on the money?

Substitution Cipher

Age 11 to 14 Challenge Level:

Find the frequency distribution for ordinary English, and use it to help you crack the code.

Excel Interactive Resource: the up and Down Game

Age 11 to 16 Challenge Level:

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

Excel Technique: Logic Tests

Age 11 to 16 Challenge Level:

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

Excel Interactive Resource: Multiples Chain

Age 11 to 16 Challenge Level:

Use an interactive Excel spreadsheet to investigate factors and multiples.

Excel Technique: LOOKUP Functions

Age 11 to 16 Challenge Level:

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

Excel Interactive Resource: Long Multiplication

Age 11 to 16 Challenge Level:

Use an Excel spreadsheet to explore long multiplication.

Excel Interactive Resource: Equivalent Fraction Bars

Age 11 to 16 Challenge Level:

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

Excel Investigation: Happy Numbers

Age 11 to 16 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: Triangular Arrays by Turning Off Zeros

Age 11 to 16 Challenge Level:

Learn how to use Excel to create triangular arrays.

Excel Investigation: Pascal Multiples

Age 11 to 16 Challenge Level:

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

Excel Interactive Resource: Number Grid Functions

Age 11 to 16 Challenge Level:

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

Excel Interactive Resource: Fraction Addition & Fraction Subtraction

Age 11 to 16 Challenge Level:

Use Excel to practise adding and subtracting fractions.

Excel Investigation: Number Pyramids

Age 11 to 16 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: Conditional Formatting

Age 11 to 16 Challenge Level:

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

Excel Interactive Resource: Interactive Division

Age 11 to 16 Challenge Level:

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

Excel Technique: Composite Bar Charts

Age 11 to 16 Challenge Level:

Learn how to use composite bar charts in Excel.

Excel Investigation: Ring on a String

Age 11 to 16 Challenge Level:

This investigation uses Excel to optimise a characteristic of interest.

Peeling the Apple or the Cone That Lost Its Head

Age 14 to 16 Challenge Level:

How much peel does an apple have?

Funnel

Age 14 to 16 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 ?

Training Schedule

Age 14 to 16 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?

Excel Investigation: Fraction Combinations

Age 11 to 16 Challenge Level:

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

Excel Investigation: Target Decimal

Age 11 to 16 Challenge Level:

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

Excel Technique: Using Paste Special to Lift a Copy of Values

Age 11 to 16 Challenge Level:

Learn how to use advanced pasting techniques to create interactive spreadsheets.

Excel Investigation: Difference Tuples

Age 11 to 16 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 Technique: Inserting an Increment Button

Age 11 to 16 Challenge Level:

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

Excel Interactive Resource: Fraction Multiplication

Age 11 to 16 Challenge Level:

Use Excel to explore multiplication of fractions.

Excel Investigation: More Beads

Age 11 to 16 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 Technique: Making a Table for a Function of Two Independent

Age 11 to 16 Challenge Level:

Learn how to make a simple table using Excel.

Excel Interactive Resource: Make a Copy

Age 11 to 16 Challenge Level:

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

Time of Birth

Age 11 to 14 Challenge Level:

A woman was born in a year that was a square number, lived a square number of years and died in a year that was also a square number. When was she born?

Excel Technique: LCM & HCF (or GCD)

Age 11 to 16 Challenge Level:

Learn how to use the Excel functions LCM and GCD.

Excel Interactive Resource: Haitch

Age 11 to 16 Challenge Level:

An Excel spreadsheet with an investigation.

Litov's Mean Value Theorem

Age 11 to 14 Challenge Level:

Start with two numbers and generate a sequence where the next number is the mean of the last two numbers...

Excel Investigation: Planks

Age 11 to 16 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.

Excel Investigation: Pythagorean Triples

Age 11 to 16 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 Investigation: Beads

Age 11 to 16 Challenge Level:

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

Excel Investigation: Multiples of Three

Age 11 to 16 Challenge Level:

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

There's Always One Isn't There

Age 14 to 16 Challenge Level:

Take any pair of numbers, say 9 and 14. Take the larger number, fourteen, and count up in 14s. Then divide each of those values by the 9, and look at the remainders.

Excel Investigation: the Difference of Two (same) Powers

Age 11 to 16 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. . . .