Wednesday

August 20, 2014

August 20, 2014

Posted by **Shinal** on Sunday, April 24, 2011 at 8:30am.

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 -
**MathMate**, Sunday, April 24, 2011 at 9:20ama. assignment 2

f(x)=1.1x

b. assignment 3

g(x)=(x+f(x))/2=(x+1.1x)/2=1.05x

- Computer -
**Shinal**, Sunday, April 24, 2011 at 9:48amPlease may you please explain it in the form of Microsoft Excel? please.

- Computer -
**MathMate**, Sunday, April 24, 2011 at 3:22pmCreate 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.

**Related Questions**

english - Questions about Avi(the author) Why was school a constant struggle for...

physics - Mary and John are on opposite sides of a seesaw. Mary has 3x the mass ...

Linguistics - Determine whether the following are entailment, presupposition, or...

Math - Find the ages of John and Mary if four times John's age equals three ...

CIS 105 - I need help with the following assignment: o Distinguish between ...

computer - Create a new project Lab05e, and write a program that asks the user ...

Linguistics - 1) (A) Mary murdered the platypus (B) Mary killed something Is the...

Maths - Hi, I am just doing some maths revision in light of my maths GCSE resit...

Algebra 2 - two people, john and mary, are 200 miles apart and leave at the same...

Simple Math Question - two people, john and mary, are 200 miles apart and leave ...