1. Open the excel form and enter all data in the form;
2. Select the cell with data in the class hour quantity column to be counted;
3. Click the icon in the lower right corner of the cell, and select the sum button in the summary in the list;
4. Sum the data in the class hour volume column to get the total result;
5. Click the cell of the summation result, and drag the mouse to the right when the mouse cursor shows the crosshairs to copy the formula to the right to get the summation result of other columns.
The amount of class hours refers to the sum of mental and physical labor that teachers pay in the process of preparing lessons before class, teaching preparation, classroom teaching, homework correction, individual counseling, and after-class reflection.