Decimals, percentages, fractions and rounding learners' resource
Submitted by Han Dunsterville on 17 April 2011.
This spreadsheet is designed to enable students to check their own work; but also to learn about what happens when you add two decimals, or multiply two fractions, and so on.
The spreadsheet consists of the following sheets:
- “Mult-div by 10-100-1000” allows a student to input a number and explore the effect when multiplied or divided by 10, 100 or 1000.
- “Decimals (n d.p.)” are three tabs to allow a student to input two numbers with one, two or three decimal places, and to see the answer if added, subtracted, multiplied or divided.
- “Fractions” allows a student to input two fractions, and to see the answer if added, subtracted, multiplied or divided. Note that Excel cannot display fractions as ‘over each other’, but rather ‘side-by-side’ – 1/2 rather than ½.
- “Fraction parts” allows a student to find out fraction parts, increases and decreases.
- “Percentage parts” allows a student to find out percentage parts, increases and decreases.
- “Rounding” allows a student to input either a whole number or a number with decimals, and find out rounding to the nearest 10, 100 or 1000; or to one, two or three decimal places.
Excel workbook (compatible with 2003, 2007, 2010)
- Log in to post comments
The author, Han, removed minor errors and updated this resource on April 28, 2011.
I will amend the front sheet as soon as I get time.