For Lab 15, you will be computing an average grade for a class of students. You are to download the workbook Lab15.xlsx It has a worksheet named Input, which is the input that you are to use. In column A is the student's name. Each of the next 5 columns includes the name of the test in row 1, the scale on which the test was graded (i.e., the maximum number of points) in row 2, and the student's grade in the row of their name.
You are to convert their grades to a 100 point scale, rounding the value to the nearest integer (use the ROUND function) and compute their final grade by dropping the lowest grade. Again, round the final grade to the nearest integer.
You are to put your results on the worksheet named Output. It is to follow the format that is shown. Note that row 2 has been eliminated on this page. You are to pick up the names of the tests and the students from the Input worksheet. Do NOT type them in or use copy and paste.
If you want to use any intermediate computations, you are to do them on additional worksheets. You do not need to use additional sheets, but it is a natural way to do it. Remember to use $ to lock a row or column rather than manually retyping the formulas. If you do this, you only need to write 2 formulas for the full lab.
You are to submit the spreadsheet through Sakai to the assignment called Lab15. It is to be uploaded as an attachment. The file name that you use is to begin with your onyen. Because this format will be required of all assignments, it is natural to use the lab or assignment name or number in the title as well.
As with all labs in this class, you may finish posting the lab after class, up until 10 pm.
By submitting the lab you are pledging that you have neither given nor received unauthorized help.