Issues developing a maths drill worksheet for students

[AceCo55]

I'm trying to create a randomly generating maths drill file for students
My file to date is NOT attached - I can't figure out how to do it.
I did search "attach file to post" but couldn't find how to do it

To start with I want the students to be able to choose if the problems will be

1. Addition only
2. Subtraction only
3. Addition and subtraction problems at random

They do this in cell A2

They select the highest number to be used in cell D2
They then either select the lowest number in cell D4 ... or ... select a specific number fact they want to work on in cell D5

The problem that the students will see is in cell A7 (this has been created by concatenating three other cells)
The students will type their answer in cell B7

Here is my problem:
How can I get excel to calculate the correct answer to the problem in A7 - so that I can create a correct or wrong check?

Once that is achieved:

1. how can I get the worksheet to produce another random question in A7
2. I also want the students to select either a drill of 10 questions or 20 questions.
   How can I get excel to stop generating questions once it reaches 10 or 20?
3. How can I keep a record of how many problems the student got correct and how many they got wrong for those 10 or 20 questions?

Later I would like an alternative worksheet that has a 60 second countdown keeper - to test how many problems the students completed in one minute - BUT THAT IS FOR LATER

Thankyou very much for any assistance or guidance

 

[AlanY]

...deleted

 

[AceCo55]

It seems like it is not possible to attach a file
Here is a ink to the file from my dropbox:
Addition-Subtraction Fact Drills.xlsx

 

[AceCo55]

I have found a solution to "How can I get excel to calculate the correct answer to the problem in A7 - so that I can create a correct or wrong check?"

Any help on ...

1. how can I get the worksheet to produce another random question in A7
2. I also want the students to select either a drill of 10 questions or 20 questions.
   How can I get excel to stop generating questions once it reaches 10 or 20?
3. How can I keep a record of how many problems the student got correct and how many they got wrong for those 10 or 20 questions?

... would be very much appreciated

 

[oldbrewer]

addition

subtraction

either

max number

min number

X

50

15

choose add, subtract or either and set max and min numbers above

<tbody> </tbody>

then click green shape to set the test question

37

-

28

put your answer here

11

now click purple shape to check your answer

the long macro sets the question

and records the answer out of sight

check answer <tbody> </tbody>

the short macro tells the student

if the answer is correct or not

Sub Macro4()

'

' Macro4 Macro

' Macro recorded 22/08/2017 by bob

'

'

10 Cells(20, 5) = "": Cells(12, 5) = ""

If Cells(2, 1) = "X" Then GoTo 100

in the space above here there is a green circle

If Cells(2, 2) = "X" Then GoTo 200

to which I have assigned the first macro

If Cells(2, 3) = "X" Then If Rnd < 0.5 Then GoTo 100 Else GoTo 200

it is labelled "set question"

100 Cells(10, 6) = "+"

150 temp = Int(100 * Rnd)

and there is a purple rectangle

If temp < Cells(2, 7) Then GoTo 150

to which I have assigned the second macro

If temp > Cells(2, 6) Then GoTo 150

it is labelled "check answer"

Cells(10, 5) = temp

number1 = temp

160 temp = Int(100 * Rnd)

If temp < Cells(2, 7) Then GoTo 160

If temp > Cells(2, 6) Then GoTo 160

Cells(11, 5) = temp

number2 = temp

addanswer = number1 + number2

GoTo 999

200 Cells(10, 6) = "-"

220 temp = Int(100 * Rnd)

If temp < Cells(2, 7) Then GoTo 220

If temp > Cells(2, 6) Then GoTo 220

Cells(10, 5) = temp

number1 = temp

240 temp = Int(100 * Rnd)

If temp < Cells(2, 7) Then GoTo 240

If temp > Cells(2, 6) Then GoTo 240

Cells(11, 5) = temp

number2 = temp

If number2 > number1 Then mytemp = number1: number1 = number2: number2 = mytemp: Cells(10, 5) = number1: Cells(11, 5) = number2

minusanswer = number1 - number2

999 If Cells(2, 1) = "X" Then Cells(1, 27) = addanswer Else Cells(1, 28) = minusanswer

End Sub

Sub Macro5()

'

' Macro5 Macro

' Macro recorded 22/08/2017 by bob

'

'

If Cells(2, 1) = "X" And Cells(1, 27) = Cells(4, 27) Then Cells(20, 5) = "CORRECT"

If Cells(2, 1) = "X" And Cells(1, 27) <> Cells(4, 27) Then Cells(20, 5) = "INCORRECT"

If Cells(2, 2) = "X" And Cells(1, 28) = Cells(4, 28) Then Cells(20, 5) = "CORRECT"

If Cells(2, 2) = "X" And Cells(1, 28) <> Cells(4, 28) Then Cells(20, 5) = "INCORRECT"

100 End Sub

<colgroup><col><col><col span="3"><col><col><col><col><col span="5"><col><col><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[oldbrewer]

easy to build in 10 or 20 questions for a session, but I will wait to see if this is useful to you

 

[AceCo55]

THANK YOU SO MUCH for this - VERY much appreciated.

Due to my inexperience, I'm a little bit lost though.
Perhaps my confusion is due to the image file only showing text??

Are you saying I need to have three cells/buttons in A1 B1 and C1 that say addition subtraction and either
... or should I be using the drop down list I had in my file?

Same with the max number and min number? Should I have that in specific cells?
(In my test file I also have the option of the student selecting just one number set (eg add 5 to every question or, say, subtract 4 in every problem.
Is this possible in your code?)

I have:
* Used the VBA editor to copy your code and create two macros (one called Macro4 and another called Macro5)
* Created two "button shapes" (one green - "set question" ... and another purple one - "check answer")
* Assigned Macro4 to the green button and assign Macro5 to the purple button


When I click on the green (set question) button I get this error:
Compile error:
Syntax error

I have uploaded the Excel file with your code to my dropbox. The link is
Dropbox - Addition-Subtraction Fact Drills_Working.xlsm

The screenshot of the macro error is here:
Dropbox - 2017.08.23_16h11m17s_001_.jpg

Sorry I'm thick - I REALLY do appreciate your time and help

WHAT I WOULD LOVE TO HAVE FINALLY is:
Students can choose to practice
* addition
* subtraction
* both addition and subtraction
* multiplication
* division
* both multiplication and subtraction
* all operations

Students can set
* max and minimum number ... OR
* just one number fact (eg times 5 problems ... or add 6 problems)

I can get all of the above done using my rudimentary methods BUT I CAN'T
* check to see if their answers are correct
* keep a record of how many the student gets correct and how many were wrong
* give the students the option of doing say 10 or 20 problems

 

[MickG]

I have a game I wrote some time ago, comprising twenty simple maths Question (Add,sub,Mult Div).
A series of question are presented and are answered by selecting the correct value from range of possible answers.
Would you be interested in a copy.

 

[oldbrewer]

the student can say whether they want add, subtract or mixed, and set the minimum and maximum values

the image file merely indicates there were shapes there - these do not copy into this forum

cells in cols AA and AB are for correct answer and student answer

the short macro can be modified to put the student score into the teacher workbook

easy to set 10, 20 30 questions per session

if you read the macro code it is obvious that the "X" is in cells(2,1) cells(2,2) and cells(2,3) (A2, B2, C2)

(2,6) and (2,7) are the number limits

 

[AceCo55]

I have a game I wrote some time ago, comprising twenty simple maths Question (Add,sub,Mult Div).
A series of question are presented and are answered by selecting the correct value from range of possible answers.
Would you be interested in a copy.

Thank you very much for your kind offer however I am looking for something a little different