# Welshmathsman's Shop

I have taught Maths and ICT for over 25 years in 6 different schools in both England and Wales. I have been a Cross Curricular ICT coordinator (5 years) in one school and a Head of Maths in two other schools (4 and 10 years). During that time I have developed numerous resources to teach Maths and ICT particularly using EXCEL and VBA. The resources in the shop are all written using EXCEL. I would welcome any feedback / suggestions that would make the resources better.

5k+Views

I have taught Maths and ICT for over 25 years in 6 different schools in both England and Wales. I have been a Cross Curricular ICT coordinator (5 years) in one school and a Head of Maths in two other schools (4 and 10 years). During that time I have developed numerous resources to teach Maths and ICT particularly using EXCEL and VBA. The resources in the shop are all written using EXCEL. I would welcome any feedback / suggestions that would make the resources better.

#### Coordinates and Vertical Lines Starter and Worksheets Free Version

(3)
These are a free sample version of a set of worksheets that are designed as starters and worksheets on plotting coordinates and drawing horizontal and vertical lines on a set of axes. The full resource pack is available here: https://www.tes.com/teaching-resource/plotting-coordinates-horizontal-and-vertical-lines-starters-and-worksheets-11238890

#### Introduction to Percentages lessons Free Version

(2)
Introduction to Percentages Starters and Worksheets This is a series of interactive resources to deliver: The sheets ** (starred) are working to show how the paid for version would work • 2 x Starters: • A word cloud on fractions, decimals and percentages ** • An Anagram maker that you can use the original words on fractions, decimals and percentages, type in your own words or use a list of random Maths words. • Revision of place value ** • Revision of multiplying and dividing whole numbers by powers of 10, 100, 1000 • Revision of multiplying and dividing decimals by powers of 10, 100, 1000 • What is a percentage interactive resource ** • Percentages from diagrams questions ** • (1 of 4**) 4 x Equivalent of percentage, decimal and fraction interactive resources • (1 of 4**) 4 x Worksheets on percentages to decimals and decimals to percentages Each resource can be used as a self marking worksheet on a PC where each pupil have their own randomised questions and the computer ‘marks’ their work, recording it on a summary ‘homepage’ or they can be printed out and used as a class resource. The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### KS2/3 Department Analysis Sheets in EXCEL

(1)
KS2/3 Department Analysis Sheets in EXCEL These are tracking sheets that provide instant departmental analysis for 3 interim assessment points across the year. There is a summary sheet and details class breakdown analysis in all the standard areas – Male, Female, FSM, Non-FSM, LAC, Non-LAC, MAT, Non-MAT, SEN, Non-SEN as well as progress against targets etc. There is also a helpsheet detailing areas to focus on for training people to read the data sheets. Simply: • Export the data from SIMS marksheets. • Paste the data into the Class 1 Data Dump, Class 2 data dump…Whole school Data Dump sheets • Your analysis is displayed ready for printing / copy and pasting. This is useful for departmental tracking and monitoring as SLT looking at departments of departments checking / reporting to SLT. The resources are written using EXCEL 2013 and include VBA code to perform the analysis. Worksheets are formatted for printing on a single sheet of A4 / A3. You will need to enable the macros for the resource to work properly.

#### Plan a Holiday Numeracy Rich Task

(0)
Plan a holiday This is a series of lessons designed to be a numeracy rich task investigating the planning of a holiday. There is a workbook and an interactive EXCEL sheet with randomised values to ensure all students get a different workbook if required. The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### Plotting Coordinates, Horizontal and Vertical Lines Starters and Worksheets

(0)
A set of maths starter and worksheet resources linked to straight line graphs that will ask students to: * State the coordinates of a point, * Plot a point given a coordinate pair, * Plot a given vertical or horizontal line, * State the equation of a given horizontal or vertical line The coordinates and lines are randomised between -5 and +5 for the starters and -10 and +10 for the worksheets. There is a timer countdown that can be changed depending on how much time you think the students need. This is best used with a set of mini-whiteboards (ones with axes or a lined grid on are best). The resources use VBA code behind the scenes to make it work so you will have to 'enable macros' when prompted by Excel. It has been written using Excel 2013.

#### Trial and Improvement sheets in EXCEL

(0)
Trial and Improvement Sheets in EXCEL There are 11 EXCEL sheets that provide: • One starter on rounding to decimal places. This is a self marking randomly generated sheet so all students would have their own individual questions. • 10 x Trial and improvement sheets that are differentiated. All sheets are self marking and there is a summary sheet at the start of the pack. These can be used by projecting onto a class whiteboard but is best used in a computer room or using a set of laptops / tablets with EXCEL on. The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### Teaching IF Statements in EXCEL interactive resources

(0)
Teaching If Statements using EXCEL This is a series of interactive resources to teach IF Statements in EXCEL. The EXCEL workbook contains the following sheets: • A word cloud starter with spreadsheet terms • An interactive “Build an IF statement” whiteboard sheet • 10 x “Build an IF Statement” question sheets designed to practice creating IF statements • 5 x Project sheets where the students need to build a complete interactive test sheet for younger students to practice their maths. These include self-assessment sheets with indicative levels • 3 x Help sheets and example sheets to support students • 1 x Final assessment sheet with timer where the students have to evaluate 5 if statements. (Random number generation so that all students have a different assessment answer set) The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### Algebra Sequences 1 Starters and Worksheets

(0)
This is a series of interactive whiteboard starter resources to deliver: • Continuing a number sequence + and - • Generating values given the nth term The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. There are: • 5 ‘Bell work’ tasks. These are to be projected on the whiteboard as the class comes in or for the ‘card sort’ (Bellwork 4 and 5) printed out on put on the desks. The idea is pupils have something to get on with related to the learning objectives while everyone gets in and is settled. (It also gives the member of staff time to take the register. • 7 Starter activities on basic addition and subtraction. If these are completed on a PC / Laptop / Tablet then the sheets self mark…always a good idea I find! • 3 ‘Find the next terms in the number pattern’ examples that can be used as a whiteboard projector resource or a help-station activity for pupils who struggle with the concept. They get progressively more difficult from Ex 1 to Ex 3 (Generator an+b Ex 1 positive a &amp; b, Ex2 positive a and ±b, Ex 3 ±a and ±b) • 6 ‘Find the next terms in the number pattern’ exercises that self mark. They get progressively more difficult from Ex 1a to Ex 3b the a exercises are find the next 2 terms and the b exercises are find the terms in the gaps (Generator an+b Ex 1 positive a &amp; b, Ex2 positive a and ±b, Ex 3 ±a and ±b) • There is a mini-plenary that is a number square that gives you a starting term and second term and challenges you to find the next 10 in the number sequence. As yet it’s not self marking…I’m working on that! • 3 ‘Generate the first 5 terms in the number pattern given the nth term’ examples that can be used as a whiteboard projector resource or a help-station activity for pupils who struggle with the concept. They get progressively more difficult from Ex 1 to Ex 3 (Generator an+b Ex 1 positive a &amp; b, Ex2 positive a and ±b, Ex 3 ±a and ±b) • 3 ‘Generate the first 5 terms in the number pattern given the nth term’ exercises that self mark. They get progressively more difficult from Ex 1 to Ex 3 (Generator an+b Ex 1 positive a &amp; b, Ex2 positive a and ±b, Ex 3 ±a and ±b) • 4 help sheets that can be used for printing tables squares, number lines or demonstrating doubling and halving a number.

#### Introduction to Percentages series of interactive EXCEL resources.

(1)
Welshmathsman Resources Introduction to Percentages Starters and Worksheets This is a series of interactive resources to deliver: • 7 x Starters: • A word cloud on fractions, decimals and percentages • A word cloud maker input your own words • An ‘estimate the %” interactive sheet. • A change % to decimals ‘TETRIS’ style game • 2 X Follow me cards maker on % of a quantity • An Anagram maker that you can use the original words on fractions, decimals and percentages, type in your own words or use a list of random Maths words. • Revision of place value • Revision of multiplying and dividing whole numbers by powers of 10, 100, 1000 • Revision of multiplying and dividing decimals by powers of 10, 100, 1000 • What is a percentage interactive resource • Percentages from diagrams questions • 4 x Equivalent of percentage, decimal and fraction interactive resources • 4 x Self-Marking Worksheets on percentages to decimals and decimals to percentages • 2 x Example sheets on finding percentages of quantities • 6 x Self-Marking Worksheets on finding percentages of quantities. • 4 x Help Sheets: Interactive Tables Square, Double and Half helpers and number lines 3 x Printable workbooks on percentages Each resource can be used as a self marking worksheet on a PC where each pupil have their own randomised questions and the computer ‘marks’ their work, recording it on a summary ‘homepage’ or they can be printed out and used as a class resource. The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### Class Context Analysis Sheets in EXCEL

(1)
Class Context Analysis Sheets in EXCEL There are 6 EXCEL sheets that provide a quick summary breakdown of a class. One is for KS3 classes, one for KS4 GCSE classes, one for KS4 BTEC Classes and three for performance management summary data sheets. Simply: • Export the data from a SIMS marksheet. • Paste the data into the Data Dump sheet • Your class analysis is displayed ready for printing / copy and pasting. This is useful for lesson observations when you want to provide a context for the person observing but don’t want to spend an hour making your summary data sheet ‘just so’! The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### Class Data Dashboard & Assessment 'RAGer'

(0)
Class analysis sheet and Learning Checklist maker This is a single Excel sheet to take data from a SIMS system and produce a class summary. It also has an assessment strengths and weaknesses maker. Input data from an assessment and a summary of the questions at the top and you get a class average sheet for each question and individual RAG rated checklists: • Data drop sheet • A class summary one page ‘dashboard’ • An assessment data entry sheet • A ranked class summary sheet of the results of the assessment • 37 (for those of you with big classes) individual RAG Rated review sheets The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### TETRIS Style Four Rules of Number Maths Game

(1)
This is a game that can be used to practice basic four rules number skills ( + - x ÷). The numbers can be changed to vary the difficulty and the time taken before each tile ‘falls’ can be varied. After each set of 10 correct answers the game gets a little quicker. The high score is kept and that can be very motivating with a group of students…who comes top! Simple choose your parameters using the spinner button, press the start button and input the answers to each sum at the bottom of the column to ‘zap’ the column. If the sums reach the bottom of the column before you answer them…then it’s game over!

#### ICT Assessment Tracker in EXCEL

(0)
ICT Assessment Tracker in EXCEL This is a level tracker for use with KS3 students. The pupils self assess and the member of staff has the option to assess the progress if the tracker is shared, for example, using Office 365. The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### Cross Number Maker - Infinte Add and Subtract Puzzles

(1)
This resource has a word document with 25 different add / subtract Crossnumber puzzles with answers. It also has a Crossnumber puzzle maker that can make an infinite number of puzzles....so you never ever run out!

#### The Average Smarties Investigation (Mean, Median and Mode)

(0)
The Average Smarties Investigation This is a user guide to creating a spreadsheet that calculates averages (mean, median and mode) and then gets pupils to think about why certain things happen with averages. During the process students also learn some formatting techniques on EXCEL. This resource can be used from a Mathematics point of view to look at averages or an ICT point of view to look at formulae use and modelling in spreadsheets The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4. You will need to enable the macros for the resource to work properly.

#### Plotting Straight Line Graphs y=mx+c Starters and Worksheets

(0)
This is a series of interactive whiteboard starter resources to deliver: • Plotting straight line graphs with fixed m. • Plotting straight line graphs with fixed c. • Plotting straight line graphs with variable m and c. • Understanding what m and c do in y=mx+c The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4.

#### Welshmathsman Resources Plotting Quadratic Graphs Starters and Worksheets

(0)
This is a series of interactive whiteboard starter resources to deliver: • Plotting y=+ax2 • Plotting y=-ax2 • Plotting y=+ax2 ±bx ±c • Plotting y=-ax2 ±bx ±c There are four versions of each different quadratic graph plotter. Each version comes as horizontal or vertical table formats depending on the way you teach it. All versions randomly generate curves to plot, select a random x-axis range and calculate and set the minimum and maximum value of the y-axis so the graph can be plotted. The autoplot version randomly generates a question then calculates the coordinates to plot, showing full workings and plots the curve one point at a time. There is a variable delay timer so you can ask students the correct value using for instance mini-whiteboards. The ‘BLANK’ version randomly generates a question to plot and allows you to fill in the table by typing in correct answers or you can use ‘Answers’ button and the sheet will fill in the correct solution showing full workings The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4.

#### Welshmathsman Resources Plotting Quadratic Graphs Starters and Worksheets Free Version

(4)
This is free sample of a series of 16 interactive whiteboard starter resources to deliver: • Plotting y=+ax2 • Plotting y=-ax2 • Plotting y=+ax2 ±bx ±c • Plotting y=-ax2 ±bx ±c There are four versions of each different quadratic graph plotter. Each version comes as horizontal or vertical table formats depending on the way you teach it. All versions randomly generate curves to plot, select a random x-axis range and calculate and set the minimum and maximum value of the y-axis so the graph can be plotted. The autoplot version randomly generates a question then calculates the coordinates to plot, showing full workings and plots the curve one point at a time. There is a variable delay timer so you can ask students the correct value using for instance mini-whiteboards. The ‘BLANK’ version randomly generates a question to plot and allows you to fill in the table by typing in correct answers or you can use ‘Answers’ button and the sheet will fill in the correct solution showing full workings

#### TETRIS Style Four Rules of Number Maths Game FREE Version

(3)
This is the free version of the game that has the 'add' sheet working but the others do not. To get the full working version please go here: https://www.tes.com/teaching-resource/tetris-style-four-rules-of-number-maths-game-11244244 This is a game that can be used to practice basic four rules number skills ( + - x ÷). The numbers can be changed to vary the difficulty and the time taken before each tile ‘falls’ can be varied. After each set of 10 correct answers the game gets a little quicker. The high score is kept and that can be very motivating with a group of students…who comes top! Simple choose your parameters using the spinner button, press the start button and input the answers to each sum at the bottom of the column to ‘zap’ the column. If the sums reach the bottom of the column before you answer them…then it’s game over!

#### Plotting straight line graphs Free Version

(2)
These are a free sample version of a set of worksheets that are designed as starters and worksheets on plotting straight line graphs on a set of axes. The full resource pack is available here: https://www.tes.com/teaching-resource/plotting-straight-line-graphs-y-equals-mx-c-starters-and-worksheets-11240189