Download 105HW1.xIsx and open it in Excel. This document represents grades for a simulated class of students. The first column identifies the student (A-Z). The next three columns document their grades for three homework assignments (HW1, HW2, HW3). The final two columns are their grades for the midterm and final exams. 2. Create a column for average homework grade. This is a simple average. 3. Create a column for the semester grade based on the formula: Grade = 0.3 * HWAVERAGE + 0.3 * MIDTERM + 0.4 * FINAL EXAM 4. Using the sort feature, determine which students have the highest average homework grade, midterm grade, final exam grade, and total semester grade. 5. Write the answers to part 4 in a word document and save as a paf. You can answer in a single sentence. I just want to make sure we can save and submit a pdf. 6. Submit both the xisx (Excel) and pdf documents on here on Brightspace. Due on Feb 3, 2026 11:59 PM
Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure
100% Original
On Time Delivery