Self-Generating Excel Worksheets for a Range of KS3 Maths Topics

An assortment of Excel resources I created to help with teaching KS3/4 Mathematics to SEN pupils who needed a lot of repetition, practice and over-learning. As such, these worksheets randomly self-generate, meaning every new iteration presents a new challenge. Therefore, you can print out thirty unique worksheets to eliminate the chance of pupils copying over each other’s shoulders, or assign the same activity multiple times with new content, for classes who need extra practice, or assessment purposes later in the year.

Almost all worksheets have three levels of differentiation, with easy, medium and hard levels of difficulty/complexity, as separate Excel sheet tabs. Every sheet can be easily refreshed by pressing F9, to completely regenerate a new set of problems.

With some sheets, you may want/need to add a learning objective, title, name or date to the top. My pupils tended to write this on for themselves, copied from a standard board in the classroom, so it isn’t always included as default. It’s easy enough to modify these documents for your own purposes, however, adding headers or footers or editing any blank cell shouldn’t have any effect on the functionality of the spreadsheets. Of course, you don’t necessarily need to print these out at all - some I would use as part of a smartboard display, and simply write over the top.

The following topic areas are included in this pack (in no particular order):

• Calculating fractions of an amount;
• Converting both ways between mixed and improper fractions;
• Identifying equivalent fractions;
• Simplifying fractions;
• Calculating one number as a percentage of another;
• Inequalities to be represented on a numberline;
• Solving inequalities (potentially before representing);
• Finding the Nth term for different linear sequences;
• Finding the Highest Common Factor;
• Recognising odd and even numbers;
• Estimating the correct answer to addition and multiplication sums;
• Multiplying and dividing by different factors of ten;
• Finding the prime factors of a number;
• Times tables test;
• Rounding to the nearest 10, 100 or 1000;
• Calculate and identify a given fraction of a given length;
• Simplifying algebraic equations by collecting like terms.