NK GRAND TOTAL MARKS SHEET.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1			GOVERNMENT HIGHER PRIMARY SCHOOL
2					GRAND TOTAL MARKS SHEET 2021-22													CLASS
3	S.N		PRE	Sems	Exams	%	KANNADA		ENGLISH		HINDI		MATHS		SCIENCE		SST		P.E / H.E		GRAND TOTAL			RESULT
4		Student name	DAYS				M	G	M	G	M	G	M	G	M	G	M	G	M	G	M	%	G	700
5	1	PRAMOD KADAKOL		SEM	FA1	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
6				1	FA2	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
7		DOB		SEM	FA3	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
8		10/6/2011		2	FA4	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
9		SATS NO.			TOTAL	60%	56	A+	56	A+	56	A+	56	A+	56	A+	56	A+	56	A+	392
10		198256415			SA	40%	35	A	35	A	35	A	35	A	35	A	35	A	35	A	245
11				GRAND TOTAL			91	A+	91	A+	91	A+	91	A+	91	A+	91	A+	91	A+	637	91%	A+	PASS
12	2	BBB		SEM	FA1	15%	11	A	11	A	11	A	11	A	11	A	11	A	11	A	77
13				1	FA2	15%	11	A		FALSE		FALSE		FALSE	9	B	12	A		FALSE	32
14		DOB		SEM	FA3	15%	12	A		FALSE		FALSE		FALSE	8	B	10	B+		FALSE	30
15		10/5/2011		2	FA4	15%	9	B	8	B	9	B	8	B	9	B	9	B	9	B	61
16		SATS NO.			TOTAL	60%	43	A	32	B	33	B	31	B	26	C	24	C	25	C	200
17					SA	40%	25	B+	30	A	29	A	26	B+	28	A	27	B+	23	B	188
18				GRAND TOTAL			68	B+	62	B+	62	B+	57	B	54	B	51	B	48	C	388	55%	B	PASS
19	3	CCC		SEM	FA1	15%	15	A+	10	B+		FALSE		FALSE		FALSE		FALSE		FALSE	25
20				1	FA2	15%	15	A+	15	A+		FALSE		FALSE		FALSE		FALSE		FALSE	30
21		DOB		SEM	FA3	15%	12	A	25	A+		FALSE		FALSE		FALSE		FALSE		FALSE	37
22				2	FA4	15%	13	A		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	13
23		SATS NO.			TOTAL	60%	55	A+	50	A	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	105
24					SA	40%	25	B+		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	25
25				GRAND TOTAL			80	A	50	B	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	130	19%	FALSE	FAIL
26	4	DDDD		SEM	FA1	15%	15	A+		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	15
27				1	FA2	15%	10	B+		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	10
28		DOB		SEM	FA3	15%	13	A		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	13
29				2	FA4	15%	27	A+		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	27
30		SATS NO.			TOTAL	60%	65	A+	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	65
31					SA	40%		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	0
32				GRAND TOTAL			65	B+	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	65	9%	FALSE	FAIL
33		NOTICE : M indictes Marks, G indicates Grade & % indicates percentage.																	PREPARED BY: NAVEENKUMAR.K
34		USING METHOD : FILL UP THE FA-1,2,3,4, & SA OF ALL SUBJECTS THEN AUTOMATICALLY TOTAL, GRADE, % AND RESULT WILL BE GENERATED
35	S.N		PRE	Sems	Exams	%	KANNADA		ENGLISH		HINDI		MATHS		SCIENCE		SST		P.E / H.E		GRAND TOTAL			RESULT
36		Student name	DAYS				M	G	M	G	M	G	M	G	M	G	M	G	M	G	M	%	G	700
37	1	PRAMOD KADAKOL		SEM	FA1	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
38				1	FA2	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
39		DOB		SEM	FA3	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
40		10/6/2011		2	FA4	15%	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	14	A+	98
41		SATS NO.			TOTAL	60%	56	A+	56	A+	56	A+	56	A+	56	A+	56	A+	56	A+	392
42		198256415			SA	40%	35	A	35	A	35	A	35	A	35	A	35	A	35	A	245
43				GRAND TOTAL			91	A+	91	A+	91	A+	91	A+	91	A+	91	A+	91	A+	637	91%	A+	PASS
44	2	BBB		SEM	FA1	15%	11	A	11	A	11	A	11	A	11	A	11	A	11	A	77
45				1	FA2	15%	11	A		FALSE		FALSE		FALSE	9	B	12	A		FALSE	32
46		DOB		SEM	FA3	15%	12	A		FALSE		FALSE		FALSE	8	B	10	B+		FALSE	30
47		10/5/2011		2	FA4	15%	9	B	8	B	9	B	8	B	9	B	9	B	9	B	61
48		SATS NO.			TOTAL	60%	43	A	32	B	33	B	31	B	26	C	24	C	25	C	200
49					SA	40%	25	B+	30	A	29	A	26	B+	28	A	27	B+	23	B	188
50				GRAND TOTAL			68	B+	62	B+	62	B+	57	B	54	B	51	B	48	C	388	55%	B	PASS
51	3	CCC		SEM	FA1	15%	15	A+	10	B+		FALSE		FALSE		FALSE		FALSE		FALSE	25
52				1	FA2	15%	15	A+	15	A+		FALSE		FALSE		FALSE		FALSE		FALSE	30
53		DOB		SEM	FA3	15%	12	A	25	A+		FALSE		FALSE		FALSE		FALSE		FALSE	37
54				2	FA4	15%	13	A		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	13
55		SATS NO.			TOTAL	60%	55	A+	50	A	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	105
56					SA	40%	25	B+		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	25
57				GRAND TOTAL			80	A	50	B	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	130	19%	FALSE	FAIL
58	4	DDDD		SEM	FA1	15%		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	0
59				1	FA2	15%		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	0
60		DOB		SEM	FA3	15%		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	0
61				2	FA4	15%		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	0
62		SATS NO.			TOTAL	60%	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0
63					SA	40%		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE		FALSE	0
64				GRAND TOTAL			0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	FALSE	0	0%	FALSE	FAIL
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