Social Studies test grades, writing homework help

Stuck with a difficult assignment? No time to get your paper done? Feeling confused? If you’re looking for reliable and timely help for assignments, you’ve come to the right place. We promise 100% original, plagiarism-free papers custom-written for you. Yes, we write every assignment from scratch and it’s solely custom-made for you.


Order a Similar Paper Order a Different Paper

Course: CIS 111 MS Excel Lab Due 04/10/2017

– 1 –

You have been hired by an elementary school to develop a grading spreadsheet for Microsoft Excel. They have asked you to develop an example using the following criteria.

Make up student names for 10 students (first initial and last name)

Include the following input detail:

 Student Name

 4 Math test grades

 4 Social Studies test grades

 4 English test grades

 4 Science test grades

Note: Each grade should be in it’s own cell.

Your spread sheet must contain formulas or functions that calculates the following statistics:

1. Calculated average grade for each subject for each student.

 Create your own formula or use a built in function.

2. Highest test score for each subject.

 Only one high test score for each subject, not one for every student for every class. Use MAX function.

3. If there is a failing test grade below 60 the text should be “Red”.

 Use conditional formatting. (The color should change automatically if the grade changes)

4. Final numerical grade for each student. Weight the grades as follows:

40% of the Math Average

15% of the Social Studies Average

15% of the English Average

30% of the Science Average

After calculating the final numerical grade use nested “If Statements” to calculate the letter grade. HINT: Use the “Help” feature of Excel if you need “help” with the “IF statement”.

 A > 90

 B = 81 – 90

 C = 71 – 80

 D = 60 – 70

 F = < 60

Other Requirements:

 All grades shall be rounded to 2 decimal places. (IE: 80.95)

 A minimum font size of 12 will be used.

 Use formatting including shading and bolding to enhance your spreadsheet.

 Your spreadsheet must have a school title.

 All Data should fit on one 8.5×11 sheet of paper

Note: Remember you are doing this for a customer, so make it presentable. Use titles, footers, centering, shading, and bolding, and some colors if you would like. Also, all calculated grades should update automatically if any test grade is changed.

This must be completed using MS Excel.

Writerbay.net

We’ve proficient writers who can handle both short and long papers, be they academic or non-academic papers, on topics ranging from soup to nuts (both literally and as the saying goes, if you know what we mean). We know how much you care about your grades and academic success. That's why we ensure the highest quality for your assignment. We're ready to help you even in the most critical situation. We're the perfect solution for all your writing needs.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper