Requirements for the Math Game

If you have young children or teach in elementary school, then you can use the Math Game as a testing tool of basic math skills (probably first and second graders). Your kids may not enjoy the test, but you can have a lot of fun writing it—and after you are comfortable with VBA, add more features to the program to suit your needs. The requirements of the Math Game as I have defined them follow:

1. The user interface shall consist of a single spreadsheet formatted to accentuate the numerical question. The operands, operator, and answer shall all have a large spreadsheet cell formatted with a large, easy to read font.

2. The user interface shall contain a Command Button control for initiating the program.

3. The user interface shall contain a timer that counts down to zero from 60 seconds (displaying each second). The timer shall be written to a spreadsheet cell.

4. The user interface shall contain five Option Button controls that allow the user to select a specific operator (addition, subtraction, multiplication, division, or random) for the game.

5. The user interface shall provide three spreadsheet columns for writing the questions, user's answers, and correct answers when the game is finished.

6. When the program begins, the Command Button and Option Button controls shall be disabled for the duration of the game.

7. The Command Button and Option Button controls shall be re-enabled when the game ends.

8. When the game begins, the program shall automatically select the worksheet cell in which the user enters his or her answers to the questions.

9. Operands for each question shall be randomly selected integers between zero and ten.

10. The mathematical operator for each question shall be chosen from the user's selection of the Option Button controls. If the user selects the Option Button labeled "Any," then the operator shall be selected randomly for each question and written to the proper spreadsheet cell.

11. The user shall proceed to the next question by pressing the Enter key.

12. The user must enter an answer to the question before proceeding to the next question.

13. When the user enters an answer, the question shall be cleared and the worksheet cell containing the answer is re-selected; that is, the cursor shall remain in the same worksheet cell for the duration of the game.

14. The game is over when the timer reaches zero.

15. When the game ends, the questions, user's answers, and correct answers shall be written to the spreadsheet.

16. When the game ends, the user's score shall be calculated and written to the spreadsheet.

17. Incorrect answers shall be highlighted in the worksheet with a different font color.

Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook


Post a comment