12 Fill the Status column if the student score less than 30 then Fail if the score is between 31 to 50 Pass If the score is between 51 to 60 Third_Class, 61 to 70 Second_Class, and above 70 First_class.write excel formula grade present in e5 cell

In M10 use a formula to calculate the total number of Fail grades. Copy the formula down to M16. Note cell P4 which displays the Total Number of students who achieved a "C" should have changed colour. What colour is the cell?

As a python student, write a program using functions and conditions to display the grades that the students will be receiving. The grades are:90% - 100%  Grade is A 80% - 89% Grade is  B70% - 79% Grade is C                                                        60% - 69%  Grade is D                   50% - 59%    Grade is E   <50% Fail

Accept the grades from the user and display the grade according to the following criteria:Below 25 --D25 to 45  -- C45 to 50 -- B50 to 60 --B+60 to 80 -- AAbove 80 -- A+

Problem StatementA computer science teacher assigned the students a programming task that calculates and displays grades based on test marks. The teacher wants the program to take a student's test mark as input and determine their grade using the following criteria:If the mark is between 90 and 100 (inclusive), assign grade A.If the mark is between 80 and 89 (inclusive), assign grade B.If the mark is between 70 and 79 (inclusive), assign grade C.If the mark is between 60 and 69 (inclusive), assign grade D.If the mark is between 45 and 59 (inclusive), assign grade E.For marks below 45 assign grade F.If the mark is greater than 100 or a negative number, it displays "Invalid input". Help the students to accomplish the given task.Note: This question helps in clearing AMCAT exam.Input format :The input consists of a single integer, representing the student's mark.Output format :The output displays "Grade: " followed by the grade for the given mark based on the given criteria.If the mark is greater than 100 or a negative number, the output displays "Invalid input".Refer to the sample output for the formatting specifications.Code constraints :In the given scenario, the test cases fall under the following constraints:0 ≤ student's mark ≤ 100Sample test cases :Input 1 :100Output 1 :Grade: AInput 2 :85Output 2 :Grade: BInput 3 :79Output 3 :Grade: CInput 4 :63Output 4 :Grade: DInput 5 :56Output 5 :Grade: EInput 6 :0Output 6 :Grade: FInput 7 :-5Output 7 :Invalid inputInput 8 :126Output 8 :Invalid input

The system records attendance details for multiple students, capturing their name, roll number, and attendance status for various subjects. Each subject has a total of 20 classes in a semester. Users can input the number of classes students have attended and calculate their attendance percentage. If a student's attendance falls below 75% for a particular subject, the system identifies it and calculates the number of classes they need to attend to reach a minimum of 75% before the semester concludes.Sample Input:Student Name: John DoeRoll Number: ABC123Subject: MathematicsClasses Attended: 15 Student Name: Jane SmithRoll Number: XYZ456Subject: PhysicsClasses Attended: 10 Sample Output:For John Doe (Roll Number: ABC123) in Mathematics:Attendance Percentage: 75%No additional classes required.For Jane Smith (Roll Number: XYZ456) in Physics:Attendance Percentage: 50%Additional classes needed: 5