create an excel sheet, check the requirements in the attached document ………………………………
Unformatted Attachment Preview
In this project you will create a spreadsheet (name it
LastnameFirstname_Project1), which keeps track of your grade in this Math 154
class. In addition to simply recording all of your grades for the course, it will
provide you with a “running tally” of how you are doing in the course at any point
in time during the semester.
(5%)What does “running tally,” mean? To help you understand this, compute the
grade of a student with an 82% HW average, a 92% on Project 1 and a 93% on the
midterm exam. Use the syllabus to determine the appropriate weightsfor each
category and enter a formula in a spreadsheet to compute the grade. Re-compute
the grade assuming a 95% on Project 2. Insert a textbox into the spreadsheet and
record both grades in the textbox. Are you surprised by their grades? Explain
what weights dominate at this point in the semester.
(10%)Create a new sheet in the spreadsheet from part 1which will allow you to
enter all of your grades for this Math 154 course. To start, reference your
gradebook in Canvas. There should be nicely labeled spaces for all of the following
There are 10 MyMathLab Assignments (25% of total grade).
There are 10 Excel Assignments (25% of total grade).
There is 2 Projects (20% of total grade).
There will be 2 Exams (30% of total grade).
(10%)Create cells which will compute the averageMyMathLab grade, average
Excel grade, average project grade, and average exam grade. Name these cells
appropriately, so if used in a formula the name will appear not the cell reference.
(10%)Create cells, which will count the number of MyMathLab grades entered so
far, the number of Excel grades, the number of project grades, and the number of
exam grades. Name these cells appropriately, so if used in a formula the name will
appear not the cell reference.
(5%)Create cells, which will compute the max and min grades for each of the 5
categories: MyMathLab, Excel, project, and exam.
(20%)Create a Histogram of your MyMathLab grades and your Excel grades (you
may put both in one chart). You must choose appropriate bin sizes so that there is
more than one column in your chart (I would suggest [0,1), [1,2), [2,3), [3,4),
[4,5]). Keep the chart next to where you enter grades, not on a separate sheet, so
when you enter your grades the columns will change.
(5%) Formatall of this nicely with borders and shading. Try to arrange so that it all
fits onto one screen when Excel is opened to the max width of the monitor screen.
(20%) Create a cell which computes your total grade using the ideas of weighted
averageas discussed in class. The formula must take into account the “counts” of
your grades. This formula must be linked to all of your input cells, so when you
enter a grade it automatically updates (HINT: Let Excel do the work for you! Do
not manually compute this value. You must use a formula!!!).
(10%) Create a cell which computes the highest possible averageyou can get in the
class. You may assume your MyMathLab and Excel are fixed (you can use the
averages on the sheet) but you should assume that you get a 100 on the project and
exams. To do this you will once again have to count the number of projects and
exam grades entered so far.
(5%) Enter ONLY your grades for the semester so far, your total grade formula
should give you your grade at this point in the semester. If you get an error try
Purchase answer to see full
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more