please i need the answer as soon as possible(with function used in excel please)
Q1 Please calculate the final note using "Midterm1 and "Final" sheets. The grading will be %25 Midterm-1, %25 Midterm-2 and %50 Final. Calculate the final notes according to grading sheet format. Answers should be given in "Grading" file. Q2 Important note: Not everyone took midterms and finals for each test. Combine files accordingly and if somebody didn't take the exam grade it "O" for the relevant note and calculate the grading accordingly. In the grading file convert final grades to letter marks. The best%20-A,%20-40-B, %40-60- C, %60-80-D and lowest %20 of all grades is F. Show them in a seperate column as given in "Grading" file. Column J. Use function to assign Grading Letter (So if it is 55, it should be automatically. Q3 Summarize data based on "max" grade per class(Column-B). (Using pivot table). Use column chart to show the number of students per grade. (So in each bar there should be 04 Midterm Final Grading Grading Letter Questions Student No Class Name Sumame Final 190302001 2 GAYE DEMIR 90 190302009 78 KOROKMEZ AKCAN 190302002 99 190302011 MUTLU 65 190102004 79 30 190302003 190102010 ESRA 3 EMRE ONUR 3 SIMAY SUKRIYE 2 LAYDA 4 OKTAY METE 4 BETUL 4 FURKAN FUAD 4 ECE 4HUSSAINI HABASH AYSENUR YAKUT ADIGZEL TURE ARSLAN AKAKAWA 75 Name - Surname GAYE DEMIR ESRA KORUKMEZ EMRE ONUR AKCAN SIMAY SUKRIYE MUTLU ILAYDA YAKUT OKTAY METE ADIGUZEL BETUL TURE FURKAN FUAD ARSLAN ECE AKAKAYA HUSSAINI HABASH AMINU AYSENUR DINER TURAN EKI EMRAN ADEM EMRE CHAN SEBAHATTIN KULU 190302006 35 19030201 70 200302804 AMINU 45 190302005 X7 DINER EK 190302014 TURAN 85 200202802 ADEM 180102012 4 EMRAN 4 EMRI 4 SEBAHATTIN CHIAN 53 190302023 KULU Midterm Final Grading Grading Letter Questions Midterm-1 Midterm-2 65 90 73 78 Student No Name 190302001 GAYE 190302009 ESRA 190302002 EMRE ONUR 190302011 SMAY SUKRIYE 190302004 LAYDA 45 99 83 55 53 190302003 OKTAY METE Surname DEMIR KOROKMEZ AKCAN MUTLU YAKUT ADIGZEL AKAKAYA AMINU DINER EK ARABACIOGLU AYBAS 63 79 68 701 65 190302018 ECE Name - Surname GAYE DEMR ESRA KORUKMEZ EMRE ONUR AKCAN SIMAY SUKRIYE MUTLU LAYDA YAKUT OKTAY METE ADIGZEL ECE AKAKAYA HUSSAINI HABASH AMINU AYSENUR DINER TURAN EKI ELN HALE ARABACIOGLU SERIFE AYBAS EMRAN ADEM EMRE CHAN SEBAHATTN KULU 53 50 25 87 45 65 SO so 200302804HUSSAINI HABASH 190302005 AYSENUR 190302014 TURAN 200302002 ELIN HALE 190302007 SERIFE 200302802 EMRAN 180302012 EMRE 190302023 SEBAHATTN 10 83 ADEM 10 81 0 53 CHAN KULU NA NA Q1 Please calculate the final note using "Midterm1 and "Final" sheets. The grading will be %25 Midterm-1, %25 Midterm-2 and %50 Final. Calculate the final notes according to grading sheet format. Answers should be given in "Grading" file. Q2 Important note: Not everyone took midterms and finals for each test. Combine files accordingly and if somebody didn't take the exam grade it "O" for the relevant note and calculate the grading accordingly. In the grading file convert final grades to letter marks. The best%20-A,%20-40-B, %40-60- C, %60-80-D and lowest %20 of all grades is F. Show them in a seperate column as given in "Grading" file. Column J. Use function to assign Grading Letter (So if it is 55, it should be automatically. Q3 Summarize data based on "max" grade per class(Column-B). (Using pivot table). Use column chart to show the number of students per grade. (So in each bar there should be 04 Midterm Final Grading Grading Letter Questions Student No Class Name Sumame Final 190302001 2 GAYE DEMIR 90 190302009 78 KOROKMEZ AKCAN 190302002 99 190302011 MUTLU 65 190102004 79 30 190302003 190102010 ESRA 3 EMRE ONUR 3 SIMAY SUKRIYE 2 LAYDA 4 OKTAY METE 4 BETUL 4 FURKAN FUAD 4 ECE 4HUSSAINI HABASH AYSENUR YAKUT ADIGZEL TURE ARSLAN AKAKAWA 75 Name - Surname GAYE DEMIR ESRA KORUKMEZ EMRE ONUR AKCAN SIMAY SUKRIYE MUTLU ILAYDA YAKUT OKTAY METE ADIGUZEL BETUL TURE FURKAN FUAD ARSLAN ECE AKAKAYA HUSSAINI HABASH AMINU AYSENUR DINER TURAN EKI EMRAN ADEM EMRE CHAN SEBAHATTIN KULU 190302006 35 19030201 70 200302804 AMINU 45 190302005 X7 DINER EK 190302014 TURAN 85 200202802 ADEM 180102012 4 EMRAN 4 EMRI 4 SEBAHATTIN CHIAN 53 190302023 KULU Midterm Final Grading Grading Letter Questions Midterm-1 Midterm-2 65 90 73 78 Student No Name 190302001 GAYE 190302009 ESRA 190302002 EMRE ONUR 190302011 SMAY SUKRIYE 190302004 LAYDA 45 99 83 55 53 190302003 OKTAY METE Surname DEMIR KOROKMEZ AKCAN MUTLU YAKUT ADIGZEL AKAKAYA AMINU DINER EK ARABACIOGLU AYBAS 63 79 68 701 65 190302018 ECE Name - Surname GAYE DEMR ESRA KORUKMEZ EMRE ONUR AKCAN SIMAY SUKRIYE MUTLU LAYDA YAKUT OKTAY METE ADIGZEL ECE AKAKAYA HUSSAINI HABASH AMINU AYSENUR DINER TURAN EKI ELN HALE ARABACIOGLU SERIFE AYBAS EMRAN ADEM EMRE CHAN SEBAHATTN KULU 53 50 25 87 45 65 SO so 200302804HUSSAINI HABASH 190302005 AYSENUR 190302014 TURAN 200302002 ELIN HALE 190302007 SERIFE 200302802 EMRAN 180302012 EMRE 190302023 SEBAHATTN 10 83 ADEM 10 81 0 53 CHAN KULU NA NA
