Please write a code for what it is asking for in the VBA program (in Excel) that
ID: 3708955 • Letter: P
Question
Please write a code for what it is asking for in the VBA program (in Excel) that includes For..Next loops. Thank you!!!!Please write a code for what it is asking for in the VBA program (in Excel) that includes For..Next loops. Thank you!!!!
1. For...Next loops (see notes from last class) 2. Activity: THIS ACTIVITY NEEDS TO BE UPLOADED BEFORE NEXT MONDAY'S CLASS as HW assignment. Write a program that gives students their letter grade. The letter grade is based on the course numerical to letter chart below. Write a code that asks the user for their homework average and exam/quiz average. Then use a User Defined Function to calculate the course letter grade. The course grade comes a) Numerical Letter Grade enlw 21 1.) from the flowing breakdown: Average Homework 10% (input A) Exam/quiz average 45% (input B) Project 20% (assume 80%) (input C) Final Exam 25% (assume 80%) (input D) 293 290 287 283 280 277 273 ass b) Then write a whole different module/code doing the same but:- tengt Write asub. program thatfindsthecoursetetter grade. C+ Nested DO Loops: Extra if we have time: 3. / - a. Set up a spreadsheet like below 270 4 A 31 41 D+ 267 260
Explanation / Answer
import java.util.Scanner;
public class GradeCalculate {
public static void main(String[] args) {
System.out.println("Grade Calculator : ");
Scanner sc = new Scanner(System.in);
System.out.println("Please enter your average homework Marks");
int homework_marks = sc.nextInt();
System.out.println("Please enter your average exam/quiz Marks");
int quiz_marks = sc.nextInt();
System.out.println("Please enter your average project Marks");
int project_marks = sc.nextInt();
System.out.println("Please enter your average final exam Marks");
int finalexam_marks = sc.nextInt();
float netMarks = (float) (homework_marks*(0.10) + quiz_marks*(0.45) + project_marks*(0.20) + finalexam_marks*(0.25));
System.out.println("netMarks : "+netMarks);
String grade = "";
if(netMarks<60) {
grade="F";
}else if(netMarks>=60 && netMarks <67) {
grade="D";
}else if(netMarks>=67 && netMarks <70) {
grade="D+";
}else if(netMarks>=70 && netMarks <73) {
grade="C-";
}else if(netMarks>=73 && netMarks <77) {
grade="C";
}else if(netMarks>=77 && netMarks <80) {
grade="C+";
}else if(netMarks>=80 && netMarks <83) {
grade="B-";
}
else if(netMarks>=83 && netMarks <87) {
grade="B";
}
else if(netMarks>=87 && netMarks <90) {
grade="B+";
}
else if(netMarks>=90 && netMarks <93) {
grade="A-";
}
else if(netMarks>=93) {
grade="A";
}
System.out.println("Your final grade is : " + grade );
}
}