Grades: Weighted Mean and Lab Points

Satisfactory Essays
A. Use breakpoints to enter the grading scale in the correct structure on the Documentation worksheet, and the name the grading scale range Grades. The grading scale is as follows:

95+ | A | 90-94.9 | A- | 87-89.9 | B+ | 83-86.9 | B | 80-82.9 | B- | 77-79.9 | C+ | 73-76.9 | C | 70-72.9 | C- | 67-69.9 | D+ | 63-66.9 | D | 60-62.9 | D- | 0-59.9 | F |

B. Calculate the total lab points earned for the first student in cell T8 in the Grades worksheet. The first student earned 93 lab points.
C. Calculate the average of the two midterm tests for the first student in cell W8. The student's average midterm test average is 87.
D. Calculate the assignment average for the first student in cell I8. The formula should drop the lowest score before calculating the average. Hint: You need to use the combination of the three functions: SUM, MIN, and COUNT. The first student’s assignment average is 94.2 after dropping the lowest assignment score.
E. Calculate the weighted total points based on the four category points (assignment average, lab points, midterm average, and final exam) and their respective weights (stored in the range B40:B43) in cell Y8. Use the relative and absolute cell references as needed in the formula. The first student’s total weighted score is 90.
F. Use the appropriate function to calculate the letter grade equivalent in cell Z8. Use the range name in the function. The first student’s letter grade is A-
G. Copy the formulas down their respective columns for the other students.
H. Name the passing score the threshold in cell B5 with the range name Passing. Display a message in the last grade book column based on the student’s semester performance. If a student earned a final score of 70 and higher, display Enroll n CS 202. Otherwise, display RETAKE CS 101.
I. Calculate the average, median, low, and high scores for each assignment, lab, test, category average, and total score. Display individual averages with no decimal

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Grade point Average

    • 372 Words
    • 2 Pages

    Grade Point Average (GPA) Grade point average (GPA) is the measure of how well you are doing in your academic studies. At Costaatt, the academic grading scale goes from A-F with matching points ranging from the highest 4.0 to the lowest 0.0. This is a mathematical calculation that indicates where an average of grade falls on the scale. When calculating your GPA firstly multiply the amount of grade points achieved, by the amount of credits for each subject, and then divides the total amount of grade…

    • 372 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Grades are an effective means of motivating students to do their best work. Believing: Grades are often seen to be one of, if not the most effective method of motivating a student to work to their fullest potential. For example, a student who receives an A-grade is going to be encouraged by the grade, as they see it to be an affirmation of their academic efforts. An A-student views their grade with pride, and will work very hard to maintain said grade, once achieved. An example of this is as…

    • 733 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Boiling Point Lab

    • 340 Words
    • 2 Pages

    Boiling Point Lab Introduction: The purpose of this lab is to learn about the calibration of a thermometer. In addition, we also investigated the boiling point of an unknown liquid to determine its identity. Chemical Responsibility: 1. Make sure to use glycerine (lubricant) and a towel to safely insert the thermometer into the rubber stopper. 2. Carefully operate the Bunsen burner and make sure to use rubber gloves when handling the boiling water of beaker 3. Always wear goggles…

    • 340 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Melting Point Lab

    • 653 Words
    • 3 Pages

    Melting Point Determination and Thermometer Calibration Lab Background: The melting point of a substance, a solid in this case, signifies the temperature at which the first crystal starts to melt until the temperature at which the last crystal disappears is reached. That being said, melting points are expressed in ranges, am organic compound will have a sharp range depending on the purity of the compound. Impurity of an organic substance will register an abnormal melting point based on its…

    • 653 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Boiling Point Lab

    • 529 Words
    • 3 Pages

    Purpose The purpose of this lab is to find the boiling point of the liquid and find the melting point of the solid. Procedure Boiling point: To find the boiling point of Isopropyl Alcohol I put about 1 mL of it in the test tube. Then I attached the thermometer to the test tube with a rubber band(make sure the thermometer bulb is lined up with the end of the test tube). After that I made a water bath with a beaker and put in the test tube with the thermometer. I then used a burner and a burner stand…

    • 529 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    ENTR1 Grades Do Not Mean Everything I, myself, used to think that grades are the basis for a successful and better future. I was honestly among the grade conscious students who always strive to excel in class; who get depressed when getting failed marks; and who invest much time studying. That is because I have always thought that the idea of studying hard and exceling in school is the key for a good career in the future. Hence, the fact that the ones with bad grades are often the ones who…

    • 787 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    repCHEMISTRY I - LABORATORY EXERCISE MANUAL LABORATORY EXERCISE 10: Melting Point and Boiling Point Determination This is a traditional lab. You'll simply follow the step-by-step procedure, keeping records of your measurements and observations. Each student will write their own lab report, which should include the following: Name: Names of lab partners: Date of Experiment: Date Report Submitted TITLE: Purpose: A brief statement about what the experiment is designed to determine…

    • 2340 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    rank or future plans. Classes are made up of groups of friends that pressure each other to disrupt the other students. Doing so takes the students attention away from what the teacher is saying and their work. If the classes were divided by grade point averages, the students that didn’t care would not be in a class with students who do care. Therefore they could learn better and be more prepared. Schools in today’s society are made up of the students who spend their time studying and students…

    • 453 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    the freezing point depression of a known amount in an aqueous solution. Freezing point depression is a colligative property of solutions. There are three other properties, which are boiling point elevation, vapor pressure depression, and osmotic pressure. Colligative properties of a solution depend on the amount of solute and solvent molecules and not the specific properties of the molecules. The temperature at which the solvent starts to freeze will be specified as the freezing point of the solution…

    • 349 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Lab #1 - Melting Points

    • 749 Words
    • 3 Pages

    Purpose: a) Determine the melting points of two organic compounds known to have the same melting range when pure. b) Determine the mixture melting point of a mixture of the two pure compounds. c) Identify an unknown organic compound by determining its melting point and mixture melting point. Procedure and Observations: Using the procedure outlined in Appendix A of the Lab Manual, approximately equal samples of p-Nitrophenol and acetanilide, which are known to have the same melting range…

    • 749 Words
    • 3 Pages
    Good Essays