# Computer

posted by Shinal

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.

1. MathMate

a. assignment 2
f(x)=1.1x

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

2. Shinal

3. MathMate

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.

## Similar Questions

1. ### Social studies

I need help on the assignment that is due on 11/26. I am requesting Angela Cooper for assistant. Please let me know and I will submit the assignment.
2. ### physics

Mary and John are on opposite sides of a seesaw. Mary has 3x the mass of John. If Mary is sitting at a distance of .5m from the fulcrum, how far must John site in order to keep it balanced.
3. ### Linguistics

Determine whether the following are entailment, presupposition, or both. 1) (A) Mary murdered the platypus (B) Mary killed something Is the answer: (a) entails (b) OR (a) presupposes (b) OR both 2) (A) John is taller than Mary (B) …
4. ### english

Questions about Avi(the author) Why was school a constant struggle for him?
5. ### math

Two students, Mary and John, play a game. Each time Mary passes “start” she received \$25. Each time John passes “start” he receives 15% of the amount he already has. Both students start with \$200. a. How much money will Mary …
6. ### math

there are 15 students including john and mary, in the art club of a school a committee of 3 men consists of chairman secretary and treasurer is selected from the club. if john and mary cannot be both selected how many different committees …
7. ### science computer

The program will accept the final marks of a group of students in a class. The lecturer can choose '1' to finds the highest and lowest marks in the class. The lecturer choose '2' to find the average marks of that class. If user enter …
8. ### computer

Write an algorithm to enter marks of three subject for 100 students and find average and percentage if age is greater than 20 and less than 25
9. ### Maths

There are fifty students in a class. In a 100 marks exam, 20 students scored less than 30 marks, 5 students scored more than 70 marks and the remaining scored between 30 and 70 marks. If passing score is 55 marks and 40% students have …
10. ### maths

Ramu is now half old as as his father . twenty years ago Ramu's father was six times ramu's age. what are their ages

More Similar Questions