use microsoft excel VBA

Evaluate MG(Midterm Grade) if PASS or FAIL from the ff criteria:

50% Quiz Average (4 quizzes)

30% Project Average(2 projects)

20% Homework /Seatwork Ave (6 homework, 8 seatwork)

60% Passing Score

PLEASE REFER TO THE PHOTO

you can edit or add another rows or columns

Book1 Microsofe Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER Giane Cut !!! Geneal.] El AutoSum . Ay "AA. . Colibri @wap Copy Paste B 1 u . 98 Merge & Center, t.%) %:nConditional Format as Styles . Insert Delete Format Format Painter eaar. Formatting- Table- Styles- Styles Filter-Select- Ediing Oipboard Alignment 12 B C DE G H JK L MNO P QR STU VW 1 STUDENT 100 65 76 46 86 76 67 45 78 78 78 98 8 67 78 78 89 56 78 89 90 43 21 23 23 45 43 23 34 12 45 1 12 1 23 1 14 8 3 8161 7 15 27 2 13 5 12 2 9 6 3 12 15 5 1 15 25 3 11 8 14 14 S 3 3 14 14 86 13 22 4 14 9 11 14 8 5 5 15 25 9 2 6 23 5 1 0 16 16 9 1 7 16 25 13 25 17 25