Learning Excel #2, Designing Math Challenge For Young Children, Template #2

Standard

Hello all,

 

As I was pleased with the achievement on the previous Math challenge for young children I have designed, motivated, I immediately went to design a new template.

 

Once again, I set up the challenge with two goals in mind:

– pleasing design with some lovely cartoon character

– interesting layout with some visual verification of the answers

 

I have to say that I really like this template and I hope you will like it too. Please have a read and download the file and try it. (Download at the end.)

 

1, The idea

The idea is pretty simple again.

What I have changed from the previous template is the layout.

This time the file after opening only displays one equation.

Once the answer is provided, the new equation is given by running a macro assigned to a button right of the equation, unhiding row above the starting task and new tasks continue to be given one by one until the last one is uncovered.

 

The answers are confirmed in a form of a picture. The correct answer gets Doc McStuffins and the incorrect a plaster. On top of this, the answer is filled with green, if correct, and with red, if incorrect.

 

And as a final reward for all answers being correct, there is a picture saying “Congratulations.”

 

2, How does it work?

~ Checking the answers

Each answer is checked through a macro. Next to each answer are four pictures laid one on each other, the top picture being a white background hiding all others underneath. The correct answer runs macro that removes the top white square uncovering the Doc McStuffins picture as a reward. The macro that runs after incorrect answer deletes the top white square, the Doc McStuffins underneath it, and also the white square floating above the plaster. So basically it removes three layers of pictures.

 

Both macros then unhide the row above and give user new task.

 

In the cells where answers are provided, conditional formatting is used to give the cell appropriate fill, either green, or red.

 

~ Checking whether all answers are correct

This is achieved by calculating the difference between the answer provided by user and between the correct answer checked by Excel itself. If the difference is 0, the answer is correct.

Then the SUM of all differences is pulled into the master cell, which again, if all differences are 0, means all answers are correct, and in case its value is different than 0, at least one answer is incorrect, in which case the reward picture message won’t be displayed.

 

~ Commands/Macros

Again, I decided to execute the checks by user. So there are macro enabled buttons next to each equation to execute this.

 

Within the last macro there’s also a code that checks whether all answers are correct and unhides the message with congratulations text.

 

~ Coding

Here’s the full code for the challenge:

Macro to delete pictures based on answer being either correct, or incorrect:

Sub Delete_White1()

‘ Delete_White1 Macro


If (Range(“F16”).Value = 9) Then
ActiveSheet.Shapes.Range(Array(“Pic 3A”)).Select
Selection.Delete
Range(“G2”).Select
Rows(“15:15”).Select
Selection.EntireRow.Hidden = False
Range(“F16”).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 5296274
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range(“F15”).Select

End If


If (Range(“F16”).Value <> 9) Then
ActiveSheet.Shapes.Range(Array(“Pic 3A”)).Select
Selection.Delete
Range(“G2”).Select
ActiveSheet.Shapes.Range(Array(“Picture 43”)).Select
Selection.Delete
Range(“G2”).Select
ActiveSheet.Shapes.Range(Array(“Pic 3”)).Select
Selection.Delete
Range(“G2”).Select
Rows(“15:15”).Select
Selection.EntireRow.Hidden = False
Range(“F16”).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range(“F15”).Select

End If

Rows(“15:15”).Select
Selection.EntireRow.Hidden = False
Range(“F15”).Select
End Sub

And this is macro that uncoveres the Well done! message:

Sub WellDone()

‘ WellDone Macro


ActiveSheet.Shapes.Range(Array(“Picture 101”)).Select
Selection.Delete
End Sub
Sub HideAll()

‘ HideAll Macro


Rows(“2:17”).Select
Selection.EntireRow.Hidden = True
End Sub

 

Sample pictures

doc mc stuffin math 1

doc mc stuffin math 2

correct incorrect

doc mc stuffin math 4

doc mc stuffin math 3

 

~ Possible improvements

 

1, It was suggested that instead of deleting the white background pictures covering the pictures I want to display I could use a True / False statement code to make whichever of the two I need visible, or invisible. (This wouldn’t make a difference for user, but would be easier to write and would give possibility to restart the challenge.)

 

2, Randomization of the equations automatically as soon as the file is open

 

~

 

So,

 

this is my second attempt at designing a Math challenge for young children. I might have explained this in previous post, but I will explain it again (just in case). The idea of designing these challenges comes from a chat with my Excel guru, who cleverly suggested that the best way is fine learning Excel is to play with it. Now to play with it, it’s probably good if one can have some challenge on mind. So to give myself a motivation I decided to kill two birds with one stone and I set up a target of creating a few math challenge templates for young children, including my daughter, which, in the end, could be used by any user who wants to teach his/her children math and computer skills in a simple, but visually appealing way.

 

I also wanted to create a little Excel portfolio of my own designs to be able to give anyone about idea about my Excel skills. So that’s why this blog.  And I also want to have a little platform for sharing creative Excel ideas with others.

So if you have any, please get in touch.

 

Download:

Full Excel file can be downloaded from here >>>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s