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

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 -
**MathMate**, Sunday, April 24, 2011 at 9:20am
a. 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:48am
Please may you please explain it in the form of Microsoft Excel? please.

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

## Related Questions

- english - Questions about Avi(the author) Why was school a constant struggle for...
- math - Two students, Mary and John, play a game. Each time Mary passes “start” ...
- physics - Mary and John are on opposite sides of a seesaw. Mary has 3x the mass ...
- science computer - The program will accept the final marks of a group of ...
- computer - Write an algorithm to enter marks of three subject for 100 students ...
- math - there are 15 students including john and mary, in the art club of a ...
- Linguistics - Determine whether the following are entailment, presupposition, or...
- Social studies - I need help on the assignment that is due on 11/26. I am ...
- Math - Find the ages of John and Mary if four times John's age equals three ...
- Physics (Classical) - John and Mary are skating at an ice rink. John skates at a...

More Related Questions