ilt in maths page

Below is a list of all the pages in the ilt in maths category. You can read the title and first few words of the page page to see if it matches your needs. You can go to the page by clicking on the link. If you can't find anything here, use the search function to search the whole site as sometimes resources can be included in one category but still might be relevant to other categories.

Handout: doing scatter diagrams in Excel

You can download a detailed 5 page handout with screen grabs to show students how to present data in a scatter diagram using Excel. I have used this handout with several groups of students including through a VLE. They will need a suitable data set to type in. My...

Place value demonstration spreadsheet

The decimal point does not move! You can download an Excel spreadsheet designed to explore place notation and allow students to see the effect of adding various powers of ten to a number. You can also visit an external site and download some of Liz Philip's PowerPoints on decimal...

Mystic rose investigation

Each person shakes hands with every other person in the room. If there are 6 people then there are 15 handshakes. If there are 12 people in the room, there are 66 handshakes. The Mystic Rose diagram lets you see how to find the formula N * (N-1) /2...

Interactive straight line graph

I have used a spreadsheet with scroll bars to change the gradient and intercept of a straight line graph on a projector as a 'starter' whole class session. I ask students to describe the changes as I click on the scroll bars. You can also set individual work on...

Using Excel to interpret charts

Set up a simple Excel spreadsheet with a table of data and an embedded chart. Project the spreadsheet and ask students to describe the chart in words. Encourage use of comparisons of bars using ratio and percentages. I differentiate level by directed questioning and changing the data in the...

Excel date and time arithmetic

There is a Web page all about dates and times in Excel. Very handy for projects on dates and elapsed time. http://www.cpearson.com/excel/datetime.htm Below are two ways of finding the age of someone on completed years. If date of birth as an Excel date is in cell A1, then =INT((NOW()-A1)/365.25) gives...

Search

Content by Keith Burnett and contributors
Powered by Movable Type 2.63