ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKAL
1
2
3
INSTRUCTIONS
4
1
Type the names of the students, caste and GR number in the respective column of the TERM1 and the same informathion will appear in the TERM2
5
2
TERM1 sheet is for the first term and TERM2 sheet is for the second term.
6
3
This reduces your time for the second term . Same Excel sheet you can use for the second term.
7
4
SUMMARY1 is the subjectwise summary sheet of first term and SUMMARY2 is the summary sheet of second term.
8
5
As soon as you enter the marks of SUMMATIVE and FORMATIVE you will get the total and grades of that student.
9
6
no need of doing any calculations just enter the marks and the rest of the work is done for you.
10
6
It is important to enter M/F of the student otherwise you will not get the summary
11
7
You can make necessary changes according to your on roll , need and convineince
12
8
Take print of TERM1 and SUMMARY1 for the first term and TERM2 and SUMMARY2 for the second term.
13
9
Sheet1 and Sheet2 for checking the grades of student and grade of entire class. No need to take print of this.
14
10
This Excel sheet is made for the maximum 75 students divided into two sheets of A3 size.
15
One for 40 students and the other for 35 students. So while taking print if your on roll is more than 40 then only you need two prints.
16
11
Select standard and division from dropdown menu.
17
18
19
SRINIVAS V GOLLAPELLI
20
WEBSITE
srinivasgollapelli.com
A
21
EMAIL:
srinivas.gollapelli@gmail.com
22
SCHOOL:
POWAI DOCKYARD MUN. ENGLISH UPS
23
MOBILE: 9029705825
24
25
GRADING SYSTEM SEMESTER 2 2019-20 (without summative marks)
26
SELECT
27
FOR SUBJECTS (LANGUAGE/MATHS/EVS/SCIENCE/SOCIAL STUDIES)
28
29
SRSTD/GRADEFORMATIVE MARKSA 1A 2 B 1B 2C 1C 2D 1D 2E
30
PEERCENT
91%-100%
81%-90%
71%-80%
61%-70%
51%-60%
41%-50%
33%-40%
21%-32%
< 20%
31
1STD I - II7064-7057-6350-5643-4936-4229-3523-2815-22< 14
32
2STD III - IV6055-6049-5443-4837-4231-3625-3020-2413-19< 12
33
3STD V - VI5046-5041-4536-4031-3526-3021-2517-2011-16< 10
34
4STD VII - VIII4037-4033-3629-3225-2821-2417-2013-169-12< 8
35
36
37
FOR SPECIAL SUBJECTS (ARTS/ CRAFT/PHYSICAL EDUCATION)
38
39
SRSTD/GRADEFORMATIVE MARKSA 1A 2 B 1B 2C 1C 2D 1D 2E
40
PEERCENT
91%-100%
81%-90%
71%-80%
61%-70%
51%-60%
41%-50%
33%-40%
21%-32%
< 20%
41
1STD I - II100
91-100
81-9071-8061-7051-6041-5033-4021-32< 20
42
2STD III - IV100
91-100
81-9071-8061-7051-6041-5033-4021-32< 20
43
3STD V - VI100
91-100
81-9071-8061-7051-6041-5033-4021-32< 20
44
4STD VII - VIII100
91-100
81-9071-8061-7051-6041-5033-4021-32< 20
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100