How to convert the scores of teachers' open recruitment in Guang 'an?

The conversion method of teachers' open recruitment scores in Guang 'an is total score 100, with written test scores accounting for 50% and interview scores accounting for 50%.

The conversion method of teacher recruitment written test is as follows:

1. First, establish a "conversion table of written test scores for teacher recruitment" in the table.

2. Then enter the corresponding value in the cell.

3. According to the conversion score/conversion total score = volume score/volume total score, we enter "=I4*J4/H4" in the "conversion score" cell.

4. Click to enter, and the written test scores of teacher recruitment will be converted.