Visual Factors HCF (with Prime number check)

Visual Factor Pairs, HCF & Prime Numbers – Interactive Excel (Macro-Enabled)

Product Description:

An interactive, macro-enabled Excel spreadsheet designed to support the teaching of factors, highest common factor (HCF), and prime numbers in an engaging and visual way.

Ideal for Key Stage 2 and Key Stage 3, this resource encourages deep understanding by showing how multiplication and factorisation can be represented as areas of rectangles – making abstract number concepts more tangible.

See it in action by clicking the video link here - https://youtu.be/n-vd5DycbBQ

Included Worksheets:

Sheet 1 – Input a single number (between 4 and 100) to generate its factor pairs, displayed as rectangle visuals.

Sheet 2 – Enter two numbers (each between 4 and 50) to view their factor pairs and automatically calculate their HCF.

Sheet 3 – Check whether a number is prime by seeing which factor tests pass or fail (shown visually as possible rectangle combinations).

Why It Works:

Visually rich: Helps learners grasp multiplication and factorisation as area concepts.

Interactive: Uses VBA macros to drive each function - no formulas to accidentally delete!

Versatile: Use live in lessons, or take screenshots to embed into presentations and resources.

Fully customisable (fonts, colours, sizes) to suit your classroom style.

Technical Requirements:

This spreadsheet is a macro-enabled .xlsm file and will only function on devices that support VBA macros.

iPads and some browser-based Excel alternatives may not support this functionality.

Perfect for:

Classroom instruction
Homework support
Interventions and small groups
SEN pupils needing visual support
Revision lessons and topic introductions

File format: Excel (.xlsm)
Suitable for: KS2, KS3, SEN, High-attaining pupils needing visual models

#HCF #Highest Common Factor #Common Factor #Prime Numbers #Factor pairs