xlsm, 22.68 KB
xlsm, 22.68 KB

This is a macro enabled spreadsheet to be used with mini white boards.

Three quadratics are randomly generated in the form ax^2+bx+c.

The green question has a=1 and b and c are both positive, ranging from 1 to 12.

The amber question has a=1, but b and c could be either negative or positive, but their absolute values range from 1 to 12.

The red question has a>1 with factors ranging from 1 to 6; b and c could be positive or negative with absolute values ranging from 1 to 12. When factorised, the constant and coefficient in each bracket are mutually prime, so you don’t end up with quadratics that could be factorised in more than one way.

Variables are also randomised for each question with i, l, o, and t omitted as possible variables.

There are a couple of places where you could have a coefficient of 1 that shows, but this is a downfall of Excel (or perhaps my Excel programming skills!). When I use this file in lessons, I use that as an opportunity to remind pupils that you don’t have to write the 1 if you don’t want to do so and that mathematicians rarely do.

Creative Commons "Sharealike"

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have downloaded this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.