Average before Final Result For the 1st Semester spring 2021

Assignment Quiz Mid Term GDB / VIVA % Final Term

SUBJECTS Wt Total Obtain ✔ Wt Total Obtain ✔ Wt Total Obtain ✔ Wt Total Obtain ✔
before
finals % Σ â
% Σ â % % Σ â % % Σ â % % Σ â %

cs302 10 40 4 1 5 40 18 2.25 20 38 20.22 10.642 5 5 2.5 2.5 16.39 60 60

cs304 10 40 38 9.5 5 40 34 4.25 20 38 16.69 8.7842 5 5 2.5 2.5 25.03 60 60
eco402 3 15 1 0.2 9 30 20 6 25 38 25.18 16.566 3 5 2.5 1.5 24.27 60 60
mgt101 3 15 3 0.6 9 30 22 6.6 25 38 27.63 18.178 3 5 1.25 0.75 26.13 60 60
mgt503 3 10 4 1.2 9 30 22 6.6 25 38 17.26 11.355 3 5 1.25 0.75 19.91 60 60
pak301 4 15 7 1.87 8 40 29 5.8 25 38 11.22 7.3816 3 5 2.5 1.5 16.55 60 60

INPUT DATA Accordingly Enter = Enter = Enter = Enter = Enter =

Total : (%AGE)

Grade Equivalent Percentage Equivalent Percentage

E

A+ 4 90 - 100
EM

A 4 85 - 89
H

A- 3.66 - 3.99 80 - 84
SC

B+ 3.33 - 3.65 75 - 79
G

B 3.00 - 3.32 71 - 74
IN
D

B- 2.66 - 2.99 68 - 70
A

C 2.00 - 2.65 61 - 67
R
G

D 1.00 - 1.99 50 - 60
VU

F 0 Below 50
Note:-
According to new Grading Scheme you need 50% overall in each subject to pass a subject.

To get a Degree You need to earn atleast 2.25 CGPA

 Instructions to check required percentage.
To pass a subject.
Final Term Input all your obtain numbers in
Final there respective sub-fields.
✔ (%)
% It will show you exact calculations in green boxes
of your obtained percentage till now.
0 16.392 example
To check how much you need more percentage to
0 25.034
pass the respective subject in Finals.
0 24.266 1. Click on the columns in Red
2. Go to Data Section from Ribbon top menu.
0 26.128 3. Click on What-If Analysis
0 19.905 4. Click on Goal-Seek
5. in second option (to value) enter 50 which is
0 16.548 required for passing a subject
6. then in third option type U4 to U10 (final Term
obtain colum of sheet) e.g. U4 if you are calculating
for cs101. then repeat the same procedure for 1st
subject and so on.

Total : (%AGE) 21.38

nt Percentage How to Use This Score Sheet to Calculate your %

- 100 Wt_x000 Weitage of you subject.
5 - 89 D_ Check VULMS Subject Site to update !
%
0 - 84 Total_x00 Total Assigned marks in particular activity
5 - 79 0D_ so far.
Σ
1 - 74 Obtain Total obtained marks in particular activity
8 - 70 â so far.
1 - 67 ✔_x000D Percentage Set with Formula
0 - 60 _ Don't change any thing in Yellow Columns
%
low 50 This is your Grades before Finals.
All graded activity scores.
This is where you will use GoalSeek
Final function. To know the required marks.
(%) with using colum U4 to U10