A P H Q E R
I E X A P H
K Q Y I X Z
X R E R Z J
P I A Q H Y
Q K G E I X
L Y X E Z I
R A G K P Q
I E Z A G X
K Z F P G N
I H G J L Y
Q E R O F Z
Y L A J X H
J G I R F Q
N F O G K Z
Z A R F Z G
G F Y O H P
L H K A Y E
D R C B N L
E G J F Q A
O B X C D H
I A G C J Z
F L H K Y N
R B D B E O
A F Z Y E J
Q C P G Z B
N B K A F Q
D H E X F L
Y F A P B C
G K N D Q I
E O B L G P
R A F O J C
H D Y A X E
Q N F C L G
A I B H P Z
K D E O A F
D Y R Y H P
N E C B L X
I O J N D F
X B P C K H
K C D N D X
R L H J Z O
P I N O C Q
O Y D P N J
C G K B I H
C X L N R J
K D P L B Y
N J B O P Z
R I C L D Z
J D N R C Q
O L B K X O
O J Q Q Y X
N I P B D R
B K D L C J
This uses 20 letters and so needs 20 Questions and Answers
1. Load up the lotto grid (which is read only – or if not make it this) and then you will not
overwrite your master
2. Do a Save As and give it a new name e.g. lotto light and shadows (I enclose this example too)
3. Decide on your questions and answers and type them up
4. Do a find and replace A with your first answer (tick case sensitive and then it will not replace
letters in words for the subsequent replaces)
5. Repeat for B, C etc
6. You now have 36 different lotto cards
7. Cut up and select questions at random when you do the lotto
8. The individual grids are 3x3 so you can do line, column, diagonal or full house if time
9. If you are doing pictures as answers this is a lot slower but I have found it works by doing a
find A and replace with a blank
10. You can then see where there is no letter to copy the picture into – it is slow but gets things in
the right place
11. I used A to T but then found some answers had capital M, S and T so I replaced these with X Y
and Z
Hope this makes sense
Chris
See the ‘Light and Shadows’ Lotto game in the Science section for an example of how this works.