Decimals, percentages, fractions and rounding learners' resource

Submitted by Han Dunsterville on Sun, 2011-04-17 13:58

Numeracy: N2/L1.8, N2/L1.9, N1/E2.6, N2/L1.1, N2/L1.10, N1/E3.7, N2/E3.3, N2/L1.2, N2/L2.7, N1/L1.8, N2/L1.3, N2/L2.8, N2/L2.2, N2/L1.5, N2/L1.6, N2/L1.7, N2/L2.1, N2/L2.3, N2/L2.6, N2/L2.9, N2/L2.4

Level: E3, L1, L2

Resource type: Interactive worksheet, Resource generator

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)

Updated version

Submitted by Maggie Harnew on Thu, 2011-04-28 20:18.

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.

© 2011 Skills Workshop. Site development by Fonant. Theme based on Corolla by Kiwi Themes.