I need help creating a VBA program for this problem

A class of students earned the following grades for 6 different exams. NameEXam Scores Final Grade 80 87 75 89 Adams 45 Aitken 60 Brown 0 Davis Chan Garcia56 Zorba 66 Lee Wan 95 56 54 65 81 45 95 65 45 80 70 49 59 57 79 45 91 87 50 76 98 87 58 89 75 84 52 85 89 78 80 81 67 Write a VBA program to determine an average score for each student, assuming that each of the first four exams contribute 15 percent of the final grade and each of the last two exams contribute 20 percent. Include a For. Next loop in the program Read the data from the spreadsheet and write the final grade (as a percentage) to the spreadsheet. A class of students earned the following grades for 6 different exams. NameEXam Scores Final Grade 80 87 75 89 Adams 45 Aitken 60 Brown 0 Davis Chan Garcia56 Zorba 66 Lee Wan 95 56 54 65 81 45 95 65 45 80 70 49 59 57 79 45 91 87 50 76 98 87 58 89 75 84 52 85 89 78 80 81 67 Write a VBA program to determine an average score for each student, assuming that each of the first four exams contribute 15 percent of the final grade and each of the last two exams contribute 20 percent. Include a For. Next loop in the program Read the data from the spreadsheet and write the final grade (as a percentage) to the spreadsheet