Practice test volumes with Excel 2003 self-made students

One of the main tasks of a teacher is to correct the students ' homework, because of the large amount of homework, the teacher's correcting workload is very large. With the constant common home computer, we can use Excel and other software to make electronic practice volumes, so that students on the computer to answer, so that computers to automatically correct.

Completion function: We use Excel to make such an electronic practice volume, multiple-choice 5 questions, the correct answer to each question may be 1-2, completed correctly 10 points, if there are 2 correct answers, students choose 1 and correct, get 4 points, the other is not divided, the judgment Question 5 questions, the judgment correct 10 points, conversely does not score.

Note: The electronic practice volume of this kind of production, generally only supports the selection, judgment, fill in the blanks and other objective questions.

Production method:

1, start Excel2003 (other version please follow the operation), in accordance with the format of the practice Volume I request, make a blank form.

2, the title number, title, standard answers and other content input into the corresponding cell (effect as shown in Figure 1).

Figure 1

Note: Enter text in a cell, and if you need to wrap it, you can do this in two ways:

① Select the cells you want to wrap, execute the format, Cells command, open the Format Cells dialog box (Figure 2), switch to the Alignment tab, select the Word wrap option, and make sure you return. After this setting, if the cell fills in more than the column width, the system wraps automatically, and if the column width is resized, the characters of each row in the cell are automatically adjusted.

Figure 2

② If you want to force a newline at a character, set the cursor to the right of the corresponding character, and then press the "Alt+enter" key combination.

3. Select the H6 cell (the "score" cell for question 1th of the multiple-choice question), enter the formula: =if (G6=i6,10,if (OR (G6=J6,G6=K6), 4,0), automatically calculate the score of the 1th question.

Note: If you modify the above formula to: =if (g6= "", "not Done", if (G6 <> ", G6=i6), 10,if (and (G6 <>" ", OR (G6=J6,G6=K6)), 4,0)), then when this multiple-choice question has only 1 correct answers, You don't need to fill in the cells in the J and K columns, and when the answer column corresponds to blank, you're prompted for the question "not done."

4, select H6 cell again, move the mouse over the lower-right corner of the cell to a "fine cross" line (usually referred to as the "fill handle" state, as shown in Figure 3), press and hold down the left key to the H10 cell, and complete the score calculation for the other multiple-choice questions.