Simple Spreadsheet for primary school kids

markerd

New Member
Joined
Mar 8, 2004
Messages
3
I am creating a simple spreadsheet for primary school kids that will correct certain activities that they do. I want them to fill in the missing numbers in a sequence, e.g. 2, 4, 6,?, 10. How do I program Excel to give feed back to the children if they are correct or incorrect. Is it done through conditional formatting? If possible I would like each answer to be ticked or marked wrong with some degree of feedback like 'Well Done, that is correct.'
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,886
Office Version
  1. 365
Platform
  1. Windows
Take a look at writing event procedure macros, specifically the Worksheet_Change event. What you can do with this is any time a certain cell is changed (i.e., an answer is entered), it can check the answer and return a message.

For details on this, check out this link http://www.cpearson.com/excel/events.htm
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
If writing macros is not your thing, you could do this fairly easily with if statements. You can also use one of the more graphic fonts (again in the if statement) to produce ticks and crosses. Have a look at the system font and wingdings there in there somewhere.


The if statement would take the form of

=if(cell input="","",if(cell input = cell answer, "correct","wrong")). where cell input refers to the cell where the children will put an anser and cell answer, the cell that houses the anser and can be hidden away somewhere.

If you need further assistance post back.
 

DaVinci

Board Regular
Joined
Feb 18, 2004
Messages
55
You can also make the feedback more interesting, by making a short list of statements: Good Job!, Excellent!, Keep up the Good Work!, You're SO smart! .... and make a cell with "=ROUNDUP(4*RAND(),0)" where the 4 is the number of phrases. Then use the "Offset" function to place a new and unpredictable response next to the childs answers.

We could also put in a "reset" button that would automatically fill the "Quiz Sheet" witha new set of problems, of the same type but with different values.

If you want more help, I could make this little "Quiz Sheet" template for you and send it.

Cheers, DaVinci
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,102
Members
425,454
Latest member
khoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top