Hero image

Welshmathsman's Shop

Average Rating4.68
(based on 20 reviews)

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.

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.
The Average Smarties Investigation (Mean, Median and Mode)
WelshmathsmanWelshmathsman

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.
Teaching IF Statements in EXCEL interactive resources
WelshmathsmanWelshmathsman

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.
ICT Assessment Tracker in EXCEL
WelshmathsmanWelshmathsman

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.