12. Enter the following Marks for Assignment One figures:
Name
Assgn 1
John
10
Mary
12
Emma
15
Pita
15
Avi
15
Ramu
10
Sani
11
13. Due to a recent natural disaster, MAF11 students were unable to submit their assignments 2 and 3. The Course Coordinator then decided to award marks to each student based on the following criteria:
a. Assignment 2: Increase Assignment 1 mark by 10 percent.
b. Assignment 3: Take the average of Assignments 1 and 2 marks.
Create formulas that will achieve the above.
a. assignment 2
f(x)=1.1x
b. assignment 3
g(x)=(x+f(x))/2=(x+1.1x)/2=1.05x
Please may you please explain it in the form of Microsoft Excel? please.
Create a third column (C) titled "assignment 2".
Assume John is in row 2.
In cell C2, enter
+1.1*B2
Copy Cell C2 to the remaining cells of column C.
Now create a fourth column (D) titled "assignment 3".
Again, assume John is in row 2.
In cell D2, enter
+(B2+C2)/2
Copy the cell D2 to the remaining cells of column D.
Sani (last student) should get 1.155 for assignment 2.
Adjust formatting to have a fixed number of decimals.
To achieve the required formulas, you can follow these steps:
1. Calculate the increased mark for Assignment 2 using the criteria: Increase Assignment 1 mark by 10 percent.
- Multiply the mark for Assignment 1 by 0.10 to calculate the 10% increase.
- Add the 10% increase to the mark for Assignment 1.
- For example, if the mark for Assignment 1 is in cell B2, the formula for Assignment 2 would be: `=B2 + (B2 * 0.10)`
2. Calculate the average mark for Assignment 3 using the criteria: Take the average of Assignments 1 and 2 marks.
- Add the marks for Assignment 1 and Assignment 2 together.
- Divide the sum by 2 to calculate the average.
- For example, if the marks for Assignment 1 and Assignment 2 are in cells B2 and C2 respectively, the formula for Assignment 3 would be: `=(B2 + C2) / 2`
You can then apply these formulas to the respective cells for each student in the spreadsheet to compute the marks for Assignment 2 (cell D2) and Assignment 3 (cell E2) for the first student (John). Repeat the process for each student by changing the cell references accordingly.