Sunday
March 26, 2017

Post a New Question

Posted by on .

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.

  • Computer - ,

    a. assignment 2
    f(x)=1.1x

    b. assignment 3
    g(x)=(x+f(x))/2=(x+1.1x)/2=1.05x

  • Computer - ,

    Please may you please explain it in the form of Microsoft Excel? please.

  • Computer - ,

    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.

Answer This Question

First Name:
School Subject:
Answer:

Related Questions

More Related Questions

Post a New Question