Easy creation of children's Fun arithmetic software-imsoft. cnblogs

Skills for computer enthusiasts of MA zhenan, A Fun arithmetic software for children 0Comment Tag: Software

Interest is the motivation for learning. It is always more interesting to test your children's Arithmetic Ability in the form of dynamic software and automatic scoring.

If you are not satisfied with the online children's arithmetic software, compile an Excel version of the arithmetic testing software! Using Excel with simple VBA code, you can compile such a test software.

1. Interest in Cartoon Character Decoration Interface

Use the worksheet to create the main operation interface of the software. You can use the animated figures that children like to see to decorate the operation interface, such as pleasant goat and Big Wolf (figure 1 ).

1. Cell C6 serves as the display cell for setting the question range

2. B8, B10, and B12 are the numbers (black box), B9 is the operator number area, and B11 is the equal sign area.

3. C8, C10, C12, C17, E17, and G17 are the display areas of feedback information.

4. Use the selection pane to rename the inserted image, image, and other elements.

2. Use data verification to achieve multi-capacity of a table

You can use data verification to set the choice of operator numbers to implement multiple functions of a program, such as addition and subtraction.

3. Display Information settings

This process mainly uses simple functions to set display information for cells.

1. Enter the formula "= rept (" in cell C8 ("★| ", $ B $8)", indicating that N ($ B $8) cells are displayed at C8 cells.★Similarly, in the C10 cell, enter "= rept ("★| ", $ B $10 )"

2. Define the name "AAA" to convert a string consisting of B8, B9, and B10 into a formula for calculation.

3. Enter "= if ($ B $12 = aaa," √ "& rept ("★| ", $ B $12), if ($ B $12 = "","? Baby, start arithmetic? Good luck! "," Hey, baby, you're counting wrong. Can you calculate it again? ")", Indicating that different information will be displayed in C12 Based on the answer result

4. Right or wrong prompt with color

In the case that the baby still does not recognize words, it is a good idea to use the color to prompt right or wrong. This process is set to display different colors based on whether the answers are correct or not.

1. Select cells B12: C12 and create two cell display rules using the "new rule" in the condition format.

2. The formula for rule 1 is "= left ($ C $12,1) = "? "", The format is blue-white, used when B12 is empty display mode

3. The formula for Rule 2 is "= left ($ C $12,1) =" X ". The format is red and yellow. It is used to display the two cells when the calculation result is incorrect.

5. Automated VBA code Display

Interaction with rewards and voice prompts is something baby will love. This process uses VBA code to automate question issuance and judgment of answer results, and provides different voice prompts and image rewards based on the answer results. Click the Visual Basic button on the Development Tools tab, double-click sheet1 in the left window, and enter the code in the diagram in the right window (you can paste the code at http://pan.baidu.com/s/1ktyxi7tdownload to the window ).

1. The main function of the macro process of "initialization" is to clear the formula and prompt information.

2. The main function of the macro process of "Question" is to generate a number, subtrahend, and subtrahend Based on the set question scope and operator number, and use application. Speech. Speak for voice prompting. Of course, you can also delete the voice prompt statement or change the content of the voice prompt.

3. The main function of the macro process of "Submit" is to judge the baby's answer results, and make corresponding voice prompts and update the prompt information. You can change the file name of your favorite cartoon image in the code to JPG, but the image file must be in the same folder as the Excel file.

6. Add OPERATION button

The simpler the operation, the easier it is to get started with baby. This process uses the "button" Control in the form control to implement simple operations, so that the baby can learn with only three buttons.

1. Click the "button (Form Control)" button under the "insert" menu on the "development tools" tab, draw the button at the corresponding position on the interface, and point it to the corresponding macro

2. Right-click the corresponding button and select the "edit text" menu to change the button label to the desired content.

7. Protect worksheets

In order to prevent the baby from misoperations on other cells, learning is affected. Use the protection worksheet to set it accordingly (figure 7 ).

1. Use the ctrl key to select all active cells on the interface and remove their protection locks.

2. on the "page layout" tab, check and remove the grid lines and titles.

3. Protect the worksheet and check "select unlocked cells" and "Edit object"

After completing the preceding steps, click the buttons on the operation interface to test the learning method?