. With the basic functions of Excel, the students' answers are automatically judged, which greatly reduces the workload of teachers' correction work and helps to improve students' learning efficiency. Example description: Make an electronic practice test paper with Excel: Select question 5, the correct answer for each question may have 1 or 2, 4 points for correctness. If there are 2 correct answers, the student only chooses 1 and is correct. 2 points, the other are not scored; judge the question 5, judge the correct 2 points, and vice versa. The electronic practice paper layout design process is mainly to complete the production of the test paper content and layout. First, start Excel, design the title, name, class, total score, etc. of the test paper, and then input the title, title, standard answer, etc. into the corresponding cell. Select the 5th row in the table and select the “window →freeze window“ menu so that the entire header will freeze and the following questions can be scrolled (Figure 1). Note: Enter text in the cell. If the text is too much or too long, you need to change the line. You can do this in two ways: 1 Select the cell that needs to be wrapped, and select “Format → Cell” menu, pop up In the "cell format" dialog box, select the “ Align & rdquo; tab, check the "Auto wrap" option and confirm the return. After this setting, if the cell fills in more than the column width, the system will automatically wrap the line; if you adjust the column width, the system will automatically adjust the number of characters in each row of the cell (Figure 2). 2 If you want to force a line break at a character, set the cursor to the right of the corresponding character, and then press “Alt+Enter” to force a line break. Using the function to answer the judgment This process mainly uses the function to compare the input of the student input with the standard answer, and gives the corresponding score according to the comparison result. First, select the I6 cell (that is, the "score" of the multiple choice question 1), enter the formula: = IF (H6 = J6, 4, IF (OR (H6 = K6, H6 = L6), 2, 0)), automatically calculate the score of the first question. Then select the I6 cell and move the mouse to the fill handle in the lower right corner of the cell to complete the filling of the score formulas for the other multiple choice questions (Figure 3). Note: If you modify the above formula to: =IF(H6="","do not do",IF(AND(H6<>"",H6=J6),4,IF(AND( H6<>"",OR(H6=K6,H6=L6)), 2,0))), then when there is only one correct answer in this multiple choice question, there is no need for the corresponding unit in the K and L columns. Fill in the content in the grid, and when the cell corresponding to the "answer” cell is "empty", prompt the question <;not done”. Select the I12 cell (ie, the score of the first question) and enter the formula: =IF(H12=J12,2,0) to automatically calculate the score of the first question. Note: If you modify the above formula to: =IF(H12="","do not do",IF(H12=J12,2,0)), then when the judgment is “answer” cell correspondence When the cell is "empty", the prompt "this is not done". Similarly, select the I12 cell and double-click the “fill handle” to copy the above formula into the cells of I13 to I16 to complete the filling of the score formulas of other judgment questions. Finally, select the F2 cell (the entire practice paper "Total Score"), enter the formula = SUM (I6: I10, I12: I16), and automatically calculate the score of the entire practice paper. “ Total score & rdquo; value cell setting This process mainly completes the setting of the "Total Score" value cell display format. If the total score is lower than the pass line, it will be red, if it is higher than the pass line, it will be blue. First, select the F2 cell and select the “format →conditional format” menu. In the Open “conditional format” dialog box, click the drop-down button on the right side of the ” In the list, select the “greater than or equal to" option and enter the value “18”; in the box that follows, then press the "format” button to open the “cell format” dialog box to change the font color Set to “blue<quo;, of course, the choice of color can be based on your own needs. Make sure to return. Press the “Add” button to follow the above operation and add a conditional format that is smaller than “18 for “red”. Finally click OK to exit. After such a setting, when the score is greater than or equal to 18 points, the score characters are displayed in blue, and vice versa (shown in Figure 4). Of course, for the aesthetics of this electronic practice paper, you can also set the font, font size, and cell fill color for the cells or areas that need to be beautified. If these settings are not made, it does not affect the use of practice papers. The process of hiding standard answers and protecting worksheets is mainly to complete the locking of input cells and the hiding of standard answers, and to use the protection worksheet to enable students to enter data only in names, classes and answers, while other places such as Questions such as test questions cannot be changed. First, select the B2 cell, then hold down the Ctrl key, then select the D2, H6 to H10, H12 to H16 cells respectively, and select the “format →cell format” menu in the pop-up cell format dialog box. Select the “protect” tag and remove “∨” from the checkbox in the “Lock” option to confirm the return (Figure 5). Then, select the J to L column at the same time, right-click the mouse, and in the shortcut menu that pops up, select the “Hide” option to hide the selected column (Figure 6). Next, protect the worksheet so that the above settings work. Select the “Tools & Rarr; Protect & Rarr; Protect Worksheet” menu and enter the password in the pop-up “Protect Worksheet” dialog box. After confirming the password further, click OK to return (Figure 7). Note: If you need to modify the practice paper, please select “Tools →Protect →Undo Worksheet Protection”Menu, enter the password (if you don't have a password, you don't need a password), remove the protection of the worksheet, and then proceed Modify, after the modification is completed, you can protect it. Save the document name, the electronic practice paper is completed, now let's take a look at its final effect (Figure 8)! We can distribute the practice papers to students through the network, mobile storage devices, etc. Students open the corresponding documents in Excel, and fill in their answers in the corresponding "answers" cell (filled in letters, do not need to consider Size), and you can always know if your answer is correct and understand your score. It is very convenient. With such an electronic practice paper, not only greatly reduced the workload of teachers, but also the learning efficiency of students has been greatly improved, it can be described as a double-edged! This article comes from [System Home] www.xp85.com