Interest is the driving force of learning. It is always more interesting to test children's arithmetic ability in the form of dynamic software and automatic judgment scores. If you are not satisfied with the online children's arithmetic software, then automatically edit an Excel version of the arithmetic test software! Such test software can be compiled with Excel using simple VBA code. Xiaobian recommended "WPS Office Download" 1. The cartoon character decoration interface introduces the main operation interface of the worksheet making software. You can use the animated characters that children like to enjoy, such as Pleasant Goat, Big Big Wolf, etc. (Figure 1). Figure 1 [Note 1 Note: 1.C6 cell is used as the display cell for setting the scope of the problem. 2.B8, B10, B12 are the test number display area (black box), B9 is the arithmetic symbol area, B11 is the equal sign Area 3.C8, C10, C12, C17, E17, G17 are the display areas of feedback information. 4. The inserted pictures, graphics and other elements are renamed by the selection pane. 2. Using data verification to realize a multi-energy data verification To set the choice of operands, in order to achieve a variety of functions of the program, such as both addition and subtraction (Figure 2). Figure 23. Display information setup This process uses a simple function to set the display information for the cell (Figure 3). Figure 3 [Note 3 Note: 1. Enter the formula in the C8 cell as “=REPT("★ |
",$B$8)”, which means that n ($B$8 cell value) is displayed in the C8 cell. Similarly, in the C10 cell, enter “=REPT("★ |
",$B$10)”2.Define a name"AAA” for converting a string consisting of B8, B9, and B10 into a formula for calculation. In the C12 cell, type “=IF($B$12=AAA,"√"&REPT("★ |
",$B$12),IF($B$12="","? Baby, start arithmetic? Good luck! ","Х Baby, you are wrong, count it again. ?"))”, indicating that different information is displayed in C12 according to the result of the answer] 4. True or false prompts use color in the case that the baby still has a small number of words, it is a good idea to use the color hint right or wrong for the baby. This process is set to display different colors according to the baby's answer to the question (Figure 4). Figure 4 [Figure 4 Note: 1. Select B12: C12 cell, use the conditional format "New Rule" to create two cell display rules 2. Rule 1 formula is "L" (LEC ($C$12, 1)="?"”, the format is white on a blue background, used to display when B12 is empty. 3. The rule 2 formula is “=LEFT($C$12,1)="X"&rdquo ;, the format is yellow on the red background, used to display the two cells when the calculation result is wrong. 5. Realize the interaction of the VBA code with the reward and voice prompts. I believe that the baby must like it. This process is to use VBA code to achieve the problem, to judge the results of the answer automatically, and according to the results of the answer to make different voice prompts and picture rewards. Click the Visual Basic button on the "Development Tools" tab, double-click on Sheet1 in the left window, and enter the code in the image in the right window (you can paste the code at http://pan.baidu.com/s/1kTyXI7t) In the window) (Figure 5). Figure 5 [Figure 5 Note: 1. "Initialization" The main function of this macro process is to clear the formula, prompt information 2. "Problem" "The main function of this macro process is based on the set scope and calculation The symbol generates an addend, a subtraction, a subtraction, and a voice prompt with Application.Speech.Speak. Of course, you can also delete the voice prompts or make changes to the voice prompts. 3.Submit; submit” The main function of this macro process is to judge the baby's answer results, and make corresponding voice prompts and update prompt information. You can change the code in the code to "baby picture file name that baby likes, but the picture file must be in the same folder as this Excel file." 6. The simpler the operation button is, the easier it is for the baby to get started. . This process is to use the "button" control in the form control to achieve a simple operation, so that the baby can learn happily with only 3 buttons (Figure 6). Figure 6 [Figure 6 Note: 1. Click on the "Development Tools" tab in the "Insert" menu under the "Button (Form Control)" button, draw a button in the corresponding position of the interface, and It points to the corresponding macro 2. Right click the corresponding button to select the "Edit Text" menu, modify the button's label to the desired content. 7. Protect the worksheet in order to prevent the baby from misusing other cells, affecting learning. Use the protection worksheet to make the appropriate settings (Figure 7). Figure 7 [Note 7 Note: 1. Use the Ctrl key to select the active cells in the interface, and remove their protection locks. 2. Check the grid lines and title in the "Page Layout" tab. Remove the 3.protect the worksheet and check "“select unlocked cells" and "edit objects". After the above steps are completed, click each button on the operation interface to test to see if the baby is right. Interested in learning styles (Figure 8)? Figure 8 This article is from [System Home] www.xp85.com