Assignment # 5
Deadline (Total Marks: 20)
Upload Instructions
Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.
Rules for Marking
It should be clear that your assignment will not get any credit if:
• The assignment is submitted after due date.
• The assignment is copied from some one else.
• The file you upload does not open.
Instructions to follow
• Use HTML and java script to solve Q # 2 of assignment.
• There will be two files i.e one Excel file (Q # 1) and other HTML file (Q # 2), so you should have to zip these two files and then upload it.
Objective
This assignment is designed to help you enable understand the concept of If-Else structure using spread sheet as well as to make familiar you with using for and while loop using java script.
Assignment:-
Q # 1:- Create an Excel file according to the following instructions. (Marks 10)
• You have to put student name, student father name, and marks in three different subjects for at least five different students.
• You have to calculate the percentage of marks for each student using formula.
• You have to calculate the grade of individual student on the basis of percentage according to following formula:
Percentage Grade
Percentage greater than or equal to 80 then A
Percentage greater than of equal to 65 then B
Percentage greater than of equal to 50 then C
Percentage greater than of equal to 40 then D
Percentage less than 40 then F
Q # 2:-
Write a small program using for and while loop in java script that displays the table of ‘10’ .sample is given below?
