Give me formulars in computer science form

Okay, forti. Here are the formulas for TOTAL, AVG, RANK, and REMARK in a common spreadsheet (computer science) format, assuming your data starts in row 3 and columns B, C, D, E, F, G as in the image.

1. Formula for TOTAL (e.g., in cell D3 for Biology):

This formula sums the scores from "SEQUENCE1" (Column B) and "SEQUENCE2" (Column C) for the corresponding row.

$$D3 = \text{B3} + \text{C3}$$

Or, using a SUM function:

$$D3 = \text{SUM(B3, C3)}$$

2. Formula for AVG (e.g., in cell E3 for Biology):

This formula takes the "TOTAL" score (Column D) and divides it by 1.5.

$$E3 = \text{D3} / 1.5$$

3. Formula for RANK (e.g., in cell F3 for Biology):

This formula assigns a rank to the "AVG" score (Column E) relative to all other "AVG" scores. The RANK.EQ function is commonly used in spreadsheets, where E3 is the score to rank, E$3:E$8 is the range of all scores to rank against (the $ makes the range absolute so it doesn't change when copied), and 0 specifies descending order (highest score gets rank 1).

$F3 = \text{RANK.EQ(E3, E\$3:E\$8, 0)}$

4. Formula for REMARK (e.g., in cell G3 for Biology):

This formula uses nested IF statements to assign a remark based on the "AVG" score (Column E) according to the defined criteria.

$$G3 = \text{IF(E3 > 20, "Excellent", IF(E3 > 15, "Very Good", IF(E3 > 10, "Good", "Needs Improvement")))}$$

This formula checks the conditions in order:

• If E3 is greater than 20, the remark is "Excellent".
• Otherwise, if E3 is greater than 15, the remark is "Very Good".
• Otherwise, if E3 is greater than 10, the remark is "Good".
• If none of the above are true (meaning E3 is 10 or less), the remark is "Needs Improvement".