Decimals, percentages, fractions and rounding learners' resource

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.