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.
Physical format
Excel workbook (compatible with 2003, 2007, 2010)
Level

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.