Final result of X A and B

JNV YADGIRI
CCE:2011-12
Class : 10th A Sub: Mathematics Sub.Teacher : Gangadhar.T
Sl.No	Roll No.	Name	House	FA-1									FA-2									SA-1			Total
				Activity	project	Assignment	Class/Home work	Total	Pen & Paper	G.Total			Activity	project	Assignment	Class/Home work	Total	Pen & Paper	G.Total
				20	10	10	10	50	50	100	10%	Grade	20	10	10	10	50	50	100	10%	Grade	100	20%		300	40%	Grade
1	1001	Amarendra B M	A	16	4			20	20	40	4.0	=9.1,"A1",IF(L7>=8.1,"A2",IF(L7>=7.1,"B1",IF(L7>6.1,"B2",IF(L7>=5.1,"C1",IF(L7>=4.1,"C2","D"))))))'>D	12	8	9	6	35	18	53	5.3	=9.1,"A1",IF(U7>=8.1,"A2",IF(U7>=7.1,"B1",IF(U7>6.1,"B2",IF(U7>=5.1,"C1",IF(U7>=4.1,"C2","D"))))))'>C1	57	11.40	=18.2,"A1",IF(X7>=16.2,"A2",IF(X7>=14.2,"B1",IF(X7>=12.2,"B2",IF(X7>=10.2,"C1",IF(X7>=8.2,"C2","D"))))))'>C1	150	20.70	=36.4,"A1",IF(AA7>=32.4,"A2",IF(AA7>=28.4,"B1",IF(AA7>24.4,"B2",IF(AA7>=20.4,"C1",IF(AA7>=16.4,"C2","D"))))))'>C1
2	1002	Ambika B B	A	16	4	7	8	35	22	57	5.7	=901,"A1",IF(L8>=8.1,"A2",IF(L8>=7.1,"B1",IF(L8>6.1,"B2",IF(L8>=5.1,"C1",IF(L8>=4.1,"C2","D"))))))'>C1	14	7	8	8	37	12	49	4.9	=9.1,"A1",IF(U8>=8.1,"A2",IF(U8>=7.1,"B1",IF(U8>6.1,"B2",IF(U8>=5.1,"C1",IF(U8>=4.1,"C2","D"))))))'>C2	48	9.60	=18.2,"A1",IF(X8>=16.2,"A2",IF(X8>=14.2,"B1",IF(X8>=12.2,"B2",IF(X8>=10.2,"C1",IF(X8>=8.2,"C2","D"))))))'>C2	154	20.20	=36.4,"A1",IF(AA8>=32.4,"A2",IF(AA8>=28.4,"B1",IF(AA8>24.4,"B2",IF(AA8>=20.4,"C1",IF(AA8>=16.4,"C2","D"))))))'>C2
3	1003	Archana S N	N	20	7	9	9	45	29	74	7.4	=901,"A1",IF(L9>=8.1,"A2",IF(L9>=7.1,"B1",IF(L9>6.1,"B2",IF(L9>=5.1,"C1",IF(L9>=4.1,"C2","D"))))))'>B1	18	9	8	9	44	33	77	7.7	=9.1,"A1",IF(U9>=8.1,"A2",IF(U9>=7.1,"B1",IF(U9>6.1,"B2",IF(U9>=5.1,"C1",IF(U9>=4.1,"C2","D"))))))'>B1	72	14.40	=18.2,"A1",IF(X9>=16.2,"A2",IF(X9>=14.2,"B1",IF(X9>=12.2,"B2",IF(X9>=10.2,"C1",IF(X9>=8.2,"C2","D"))))))'>B1	223	29.50	=36.4,"A1",IF(AA9>=32.4,"A2",IF(AA9>=28.4,"B1",IF(AA9>24.4,"B2",IF(AA9>=20.4,"C1",IF(AA9>=16.4,"C2","D"))))))'>B1
4	1004	Archankumar A B	S	17	5	8	7	37	37	74	7.4	=901,"A1",IF(L10>=8.1,"A2",IF(L10>=7.1,"B1",IF(L10>6.1,"B2",IF(L10>=5.1,"C1",IF(L10>=4.1,"C2","D"))))))'>B1	13	8	8	9	38	32	70	7.0	=9.1,"A1",IF(U10>=8.1,"A2",IF(U10>=7.1,"B1",IF(U10>6.1,"B2",IF(U10>=5.1,"C1",IF(U10>=4.1,"C2","D"))))))'>B2	84	16.80	=18.2,"A1",IF(X10>=16.2,"A2",IF(X10>=14.2,"B1",IF(X10>=12.2,"B2",IF(X10>=10.2,"C1",IF(X10>=8.2,"C2","D"))))))'>A2	228	31.20	=36.4,"A1",IF(AA10>=32.4,"A2",IF(AA10>=28.4,"B1",IF(AA10>24.4,"B2",IF(AA10>=20.4,"C1",IF(AA10>=16.4,"C2","D"))))))'>B1
5	1005	Ashwini B K	N	20	10	10	10	50	46	96	9.6	=901,"A1",IF(L11>=8.1,"A2",IF(L11>=7.1,"B1",IF(L11>6.1,"B2",IF(L11>=5.1,"C1",IF(L11>=4.1,"C2","D"))))))'>A2	18	8	9	10	45	37	82	8.2	=9.1,"A1",IF(U11>=8.1,"A2",IF(U11>=7.1,"B1",IF(U11>6.1,"B2",IF(U11>=5.1,"C1",IF(U11>=4.1,"C2","D"))))))'>A2	83	16.60	=18.2,"A1",IF(X11>=16.2,"A2",IF(X11>=14.2,"B1",IF(X11>=12.2,"B2",IF(X11>=10.2,"C1",IF(X11>=8.2,"C2","D"))))))'>A2	261	34.40	=36.4,"A1",IF(AA11>=32.4,"A2",IF(AA11>=28.4,"B1",IF(AA11>24.4,"B2",IF(AA11>=20.4,"C1",IF(AA11>=16.4,"C2","D"))))))'>A2
6	1006	Bablesh S C	A	17	5	9	9	40	30	70	7.0	=901,"A1",IF(L12>=8.1,"A2",IF(L12>=7.1,"B1",IF(L12>6.1,"B2",IF(L12>=5.1,"C1",IF(L12>=4.1,"C2","D"))))))'>B2	16	8	7	5	36	15	51	5.1	=9.1,"A1",IF(U12>=8.1,"A2",IF(U12>=7.1,"B1",IF(U12>6.1,"B2",IF(U12>=5.1,"C1",IF(U12>=4.1,"C2","D"))))))'>C1		0.00	=18.2,"A1",IF(X12>=16.2,"A2",IF(X12>=14.2,"B1",IF(X12>=12.2,"B2",IF(X12>=10.2,"C1",IF(X12>=8.2,"C2","D"))))))'>D	121	12.10	=36.4,"A1",IF(AA12>=32.4,"A2",IF(AA12>=28.4,"B1",IF(AA12>24.4,"B2",IF(AA12>=20.4,"C1",IF(AA12>=16.4,"C2","D"))))))'>D
7	1007	Basavaraj M S	S	8	1	7	8	24	17	41	4.1	=901,"A1",IF(L13>=8.1,"A2",IF(L13>=7.1,"B1",IF(L13>6.1,"B2",IF(L13>=5.1,"C1",IF(L13>=4.1,"C2","D"))))))'>C2	14	6	7	6	33	11	44	4.4	=9.1,"A1",IF(U13>=8.1,"A2",IF(U13>=7.1,"B1",IF(U13>6.1,"B2",IF(U13>=5.1,"C1",IF(U13>=4.1,"C2","D"))))))'>C2	55	11.00	=18.2,"A1",IF(X13>=16.2,"A2",IF(X13>=14.2,"B1",IF(X13>=12.2,"B2",IF(X13>=10.2,"C1",IF(X13>=8.2,"C2","D"))))))'>C1	140	19.50	=36.4,"A1",IF(AA13>=32.4,"A2",IF(AA13>=28.4,"B1",IF(AA13>24.4,"B2",IF(AA13>=20.4,"C1",IF(AA13>=16.4,"C2","D"))))))'>C2
8	1008	Hanamant D V	S	17	5	8	9	39	24	63	6.3	=901,"A1",IF(L14>=8.1,"A2",IF(L14>=7.1,"B1",IF(L14>6.1,"B2",IF(L14>=5.1,"C1",IF(L14>=4.1,"C2","D"))))))'>B2	14	8	9	9	40	24	64	6.4	=9.1,"A1",IF(U14>=8.1,"A2",IF(U14>=7.1,"B1",IF(U14>6.1,"B2",IF(U14>=5.1,"C1",IF(U14>=4.1,"C2","D"))))))'>B2	67	13.40	=18.2,"A1",IF(X14>=16.2,"A2",IF(X14>=14.2,"B1",IF(X14>=12.2,"B2",IF(X14>=10.2,"C1",IF(X14>=8.2,"C2","D"))))))'>B2	194	26.10	=36.4,"A1",IF(AA14>=32.4,"A2",IF(AA14>=28.4,"B1",IF(AA14>24.4,"B2",IF(AA14>=20.4,"C1",IF(AA14>=16.4,"C2","D"))))))'>B2
9	1009	Ishappa K R	U	20	9	10	10	49	39	88	8.8	=901,"A1",IF(L15>=8.1,"A2",IF(L15>=7.1,"B1",IF(L15>6.1,"B2",IF(L15>=5.1,"C1",IF(L15>=4.1,"C2","D"))))))'>A2	14	8	9	9	40	35	75	7.5	=9.1,"A1",IF(U15>=8.1,"A2",IF(U15>=7.1,"B1",IF(U15>6.1,"B2",IF(U15>=5.1,"C1",IF(U15>=4.1,"C2","D"))))))'>B1	81	16.20	=18.2,"A1",IF(X15>=16.2,"A2",IF(X15>=14.2,"B1",IF(X15>=12.2,"B2",IF(X15>=10.2,"C1",IF(X15>=8.2,"C2","D"))))))'>A2	244	32.50	=36.4,"A1",IF(AA15>=32.4,"A2",IF(AA15>=28.4,"B1",IF(AA15>24.4,"B2",IF(AA15>=20.4,"C1",IF(AA15>=16.4,"C2","D"))))))'>A2
10	1010	Jagannath K K	S	19	7	10	10	46	42	88	8.8	=901,"A1",IF(L16>=8.1,"A2",IF(L16>=7.1,"B1",IF(L16>6.1,"B2",IF(L16>=5.1,"C1",IF(L16>=4.1,"C2","D"))))))'>A2	20	8	10	10	48	31	79	7.9	=9.1,"A1",IF(U16>=8.1,"A2",IF(U16>=7.1,"B1",IF(U16>6.1,"B2",IF(U16>=5.1,"C1",IF(U16>=4.1,"C2","D"))))))'>B1		0.00	=18.2,"A1",IF(X16>=16.2,"A2",IF(X16>=14.2,"B1",IF(X16>=12.2,"B2",IF(X16>=10.2,"C1",IF(X16>=8.2,"C2","D"))))))'>D	167	16.70	=36.4,"A1",IF(AA16>=32.4,"A2",IF(AA16>=28.4,"B1",IF(AA16>24.4,"B2",IF(AA16>=20.4,"C1",IF(AA16>=16.4,"C2","D"))))))'>C2
11	1011	Jyothi K C	N	17	8	7	10	42	20	62	6.2	=901,"A1",IF(L17>=8.1,"A2",IF(L17>=7.1,"B1",IF(L17>6.1,"B2",IF(L17>=5.1,"C1",IF(L17>=4.1,"C2","D"))))))'>B2	16	9	8	9	42	25	67	6.7	=9.1,"A1",IF(U17>=8.1,"A2",IF(U17>=7.1,"B1",IF(U17>6.1,"B2",IF(U17>=5.1,"C1",IF(U17>=4.1,"C2","D"))))))'>B2	56	11.20	=18.2,"A1",IF(X17>=16.2,"A2",IF(X17>=14.2,"B1",IF(X17>=12.2,"B2",IF(X17>=10.2,"C1",IF(X17>=8.2,"C2","D"))))))'>C1	185	24.10	=36.4,"A1",IF(AA17>=32.4,"A2",IF(AA17>=28.4,"B1",IF(AA17>24.4,"B2",IF(AA17>=20.4,"C1",IF(AA17>=16.4,"C2","D"))))))'>C1
12	1012	Kailash M S	U	16	4	9	9	38	23	61	6.1	=901,"A1",IF(L18>=8.1,"A2",IF(L18>=7.1,"B1",IF(L18>6.1,"B2",IF(L18>=5.1,"C1",IF(L18>=4.1,"C2","D"))))))'>C1	14	8	9	8	39	20	59	5.9	=9.1,"A1",IF(U18>=8.1,"A2",IF(U18>=7.1,"B1",IF(U18>6.1,"B2",IF(U18>=5.1,"C1",IF(U18>=4.1,"C2","D"))))))'>C1	56	11.20	=18.2,"A1",IF(X18>=16.2,"A2",IF(X18>=14.2,"B1",IF(X18>=12.2,"B2",IF(X18>=10.2,"C1",IF(X18>=8.2,"C2","D"))))))'>C1	176	23.20	=36.4,"A1",IF(AA18>=32.4,"A2",IF(AA18>=28.4,"B1",IF(AA18>24.4,"B2",IF(AA18>=20.4,"C1",IF(AA18>=16.4,"C2","D"))))))'>C1
13	1013	Kambayya S P	A	16	6	7	8	37	16	53	5.3	=901,"A1",IF(L19>=8.1,"A2",IF(L19>=7.1,"B1",IF(L19>6.1,"B2",IF(L19>=5.1,"C1",IF(L19>=4.1,"C2","D"))))))'>C1	14	7	7	6	34	13	47	4.7	=9.1,"A1",IF(U19>=8.1,"A2",IF(U19>=7.1,"B1",IF(U19>6.1,"B2",IF(U19>=5.1,"C1",IF(U19>=4.1,"C2","D"))))))'>C2	54	10.80	=18.2,"A1",IF(X19>=16.2,"A2",IF(X19>=14.2,"B1",IF(X19>=12.2,"B2",IF(X19>=10.2,"C1",IF(X19>=8.2,"C2","D"))))))'>C1	154	20.80	=36.4,"A1",IF(AA19>=32.4,"A2",IF(AA19>=28.4,"B1",IF(AA19>24.4,"B2",IF(AA19>=20.4,"C1",IF(AA19>=16.4,"C2","D"))))))'>C1
14	1014	Kirankumar G G	S	20	10	10	10	50	35	85	8.5	=901,"A1",IF(L20>=8.1,"A2",IF(L20>=7.1,"B1",IF(L20>6.1,"B2",IF(L20>=5.1,"C1",IF(L20>=4.1,"C2","D"))))))'>A2	19	10	10	10	49	35	84	8.4	=9.1,"A1",IF(U20>=8.1,"A2",IF(U20>=7.1,"B1",IF(U20>6.1,"B2",IF(U20>=5.1,"C1",IF(U20>=4.1,"C2","D"))))))'>A2	93	18.60	=18.2,"A1",IF(X20>=16.2,"A2",IF(X20>=14.2,"B1",IF(X20>=12.2,"B2",IF(X20>=10.2,"C1",IF(X20>=8.2,"C2","D"))))))'>A1	262	35.50	=36.4,"A1",IF(AA20>=32.4,"A2",IF(AA20>=28.4,"B1",IF(AA20>24.4,"B2",IF(AA20>=20.4,"C1",IF(AA20>=16.4,"C2","D"))))))'>A2
15	1015	Lingaraj S T	U	15	6	9	10	40	26	66	6.6	=901,"A1",IF(L21>=8.1,"A2",IF(L21>=7.1,"B1",IF(L21>6.1,"B2",IF(L21>=5.1,"C1",IF(L21>=4.1,"C2","D"))))))'>B2	10	8	9		27	23	50	5.0	=9.1,"A1",IF(U21>=8.1,"A2",IF(U21>=7.1,"B1",IF(U21>6.1,"B2",IF(U21>=5.1,"C1",IF(U21>=4.1,"C2","D"))))))'>C2	65	13.00	=18.2,"A1",IF(X21>=16.2,"A2",IF(X21>=14.2,"B1",IF(X21>=12.2,"B2",IF(X21>=10.2,"C1",IF(X21>=8.2,"C2","D"))))))'>B2	181	24.60	=36.4,"A1",IF(AA21>=32.4,"A2",IF(AA21>=28.4,"B1",IF(AA21>24.4,"B2",IF(AA21>=20.4,"C1",IF(AA21>=16.4,"C2","D"))))))'>B2
16	1016	Mahesh G R	A	19	7	9	9	44	27	71	7.1	=901,"A1",IF(L22>=8.1,"A2",IF(L22>=7.1,"B1",IF(L22>6.1,"B2",IF(L22>=5.1,"C1",IF(L22>=4.1,"C2","D"))))))'>B1	14	10	10	10	44	32	76	7.6	=9.1,"A1",IF(U22>=8.1,"A2",IF(U22>=7.1,"B1",IF(U22>6.1,"B2",IF(U22>=5.1,"C1",IF(U22>=4.1,"C2","D"))))))'>B1	83	16.60	=18.2,"A1",IF(X22>=16.2,"A2",IF(X22>=14.2,"B1",IF(X22>=12.2,"B2",IF(X22>=10.2,"C1",IF(X22>=8.2,"C2","D"))))))'>A2	230	31.30	=36.4,"A1",IF(AA22>=32.4,"A2",IF(AA22>=28.4,"B1",IF(AA22>24.4,"B2",IF(AA22>=20.4,"C1",IF(AA22>=16.4,"C2","D"))))))'>B1
17	1017	Manjunath R S	S	20	10	10	10	50	46	96	9.6	=901,"A1",IF(L23>=8.1,"A2",IF(L23>=7.1,"B1",IF(L23>6.1,"B2",IF(L23>=5.1,"C1",IF(L23>=4.1,"C2","D"))))))'>A2	20	10	10	10	50	34	84	8.4	=9.1,"A1",IF(U23>=8.1,"A2",IF(U23>=7.1,"B1",IF(U23>6.1,"B2",IF(U23>=5.1,"C1",IF(U23>=4.1,"C2","D"))))))'>A2	82	16.40	=18.2,"A1",IF(X23>=16.2,"A2",IF(X23>=14.2,"B1",IF(X23>=12.2,"B2",IF(X23>=10.2,"C1",IF(X23>=8.2,"C2","D"))))))'>A2	262	34.40	=36.4,"A1",IF(AA23>=32.4,"A2",IF(AA23>=28.4,"B1",IF(AA23>24.4,"B2",IF(AA23>=20.4,"C1",IF(AA23>=16.4,"C2","D"))))))'>A2
18	1018	Nirusha S S	N	20	10	9	10	49	36	85	8.5	=901,"A1",IF(L24>=8.1,"A2",IF(L24>=7.1,"B1",IF(L24>6.1,"B2",IF(L24>=5.1,"C1",IF(L24>=4.1,"C2","D"))))))'>A2	14	8	10	10	42	25	67	6.7	=9.1,"A1",IF(U24>=8.1,"A2",IF(U24>=7.1,"B1",IF(U24>6.1,"B2",IF(U24>=5.1,"C1",IF(U24>=4.1,"C2","D"))))))'>B2	64	12.80	=18.2,"A1",IF(X24>=16.2,"A2",IF(X24>=14.2,"B1",IF(X24>=12.2,"B2",IF(X24>=10.2,"C1",IF(X24>=8.2,"C2","D"))))))'>B2	216	28.00	=36.4,"A1",IF(AA24>=32.4,"A2",IF(AA24>=28.4,"B1",IF(AA24>24.4,"B2",IF(AA24>=20.4,"C1",IF(AA24>=16.4,"C2","D"))))))'>B2
19	1019	Prashant S M	N	20	8	10	10	48	46	94	9.4	=901,"A1",IF(L25>=8.1,"A2",IF(L25>=7.1,"B1",IF(L25>6.1,"B2",IF(L25>=5.1,"C1",IF(L25>=4.1,"C2","D"))))))'>A2	19	10	10	10	49	30	79	7.9	=9.1,"A1",IF(U25>=8.1,"A2",IF(U25>=7.1,"B1",IF(U25>6.1,"B2",IF(U25>=5.1,"C1",IF(U25>=4.1,"C2","D"))))))'>B1	96	19.20	=18.2,"A1",IF(X25>=16.2,"A2",IF(X25>=14.2,"B1",IF(X25>=12.2,"B2",IF(X25>=10.2,"C1",IF(X25>=8.2,"C2","D"))))))'>A1	269	36.50	=36.4,"A1",IF(AA25>=32.4,"A2",IF(AA25>=28.4,"B1",IF(AA25>24.4,"B2",IF(AA25>=20.4,"C1",IF(AA25>=16.4,"C2","D"))))))'>A1
20	1020	Pyaranbi A N	U	20	10	10	10	50	49	99	9.9	=901,"A1",IF(L26>=8.1,"A2",IF(L26>=7.1,"B1",IF(L26>6.1,"B2",IF(L26>=5.1,"C1",IF(L26>=4.1,"C2","D"))))))'>A2	20	10	10	10	50	41	91	9.1	=9.1,"A1",IF(U26>=8.1,"A2",IF(U26>=7.1,"B1",IF(U26>6.1,"B2",IF(U26>=5.1,"C1",IF(U26>=4.1,"C2","D"))))))'>A1	94	18.80	=18.2,"A1",IF(X26>=16.2,"A2",IF(X26>=14.2,"B1",IF(X26>=12.2,"B2",IF(X26>=10.2,"C1",IF(X26>=8.2,"C2","D"))))))'>A1	284	37.80	=36.4,"A1",IF(AA26>=32.4,"A2",IF(AA26>=28.4,"B1",IF(AA26>24.4,"B2",IF(AA26>=20.4,"C1",IF(AA26>=16.4,"C2","D"))))))'>A1
21	1021	Raju M M	S	20	9	10	10	49	46	95	9.5	=901,"A1",IF(L27>=8.1,"A2",IF(L27>=7.1,"B1",IF(L27>6.1,"B2",IF(L27>=5.1,"C1",IF(L27>=4.1,"C2","D"))))))'>A2	20	10	10	10	50	47	97	9.7	=9.1,"A1",IF(U27>=8.1,"A2",IF(U27>=7.1,"B1",IF(U27>6.1,"B2",IF(U27>=5.1,"C1",IF(U27>=4.1,"C2","D"))))))'>A1	96	19.20	=18.2,"A1",IF(X27>=16.2,"A2",IF(X27>=14.2,"B1",IF(X27>=12.2,"B2",IF(X27>=10.2,"C1",IF(X27>=8.2,"C2","D"))))))'>A1	288	38.40	=36.4,"A1",IF(AA27>=32.4,"A2",IF(AA27>=28.4,"B1",IF(AA27>24.4,"B2",IF(AA27>=20.4,"C1",IF(AA27>=16.4,"C2","D"))))))'>A1
22	1022	Raju T C	S	14	6	6	9	35	23	58	5.8	=901,"A1",IF(L28>=8.1,"A2",IF(L28>=7.1,"B1",IF(L28>6.1,"B2",IF(L28>=5.1,"C1",IF(L28>=4.1,"C2","D"))))))'>C1	14	8	9	9	40	26	66	6.6	=9.1,"A1",IF(U28>=8.1,"A2",IF(U28>=7.1,"B1",IF(U28>6.1,"B2",IF(U28>=5.1,"C1",IF(U28>=4.1,"C2","D"))))))'>B2	61	12.20	=18.2,"A1",IF(X28>=16.2,"A2",IF(X28>=14.2,"B1",IF(X28>=12.2,"B2",IF(X28>=10.2,"C1",IF(X28>=8.2,"C2","D"))))))'>B2	185	24.60	=36.4,"A1",IF(AA28>=32.4,"A2",IF(AA28>=28.4,"B1",IF(AA28>24.4,"B2",IF(AA28>=20.4,"C1",IF(AA28>=16.4,"C2","D"))))))'>B2
23	1023	Ramakant C R	U	20	2	9	9	40	20	60	6.0	=901,"A1",IF(L29>=8.1,"A2",IF(L29>=7.1,"B1",IF(L29>6.1,"B2",IF(L29>=5.1,"C1",IF(L29>=4.1,"C2","D"))))))'>C1	12	8	7	8	35	22	57	5.7	=9.1,"A1",IF(U29>=8.1,"A2",IF(U29>=7.1,"B1",IF(U29>6.1,"B2",IF(U29>=5.1,"C1",IF(U29>=4.1,"C2","D"))))))'>C1	50	10.00	=18.2,"A1",IF(X29>=16.2,"A2",IF(X29>=14.2,"B1",IF(X29>=12.2,"B2",IF(X29>=10.2,"C1",IF(X29>=8.2,"C2","D"))))))'>C2	167	21.70	=36.4,"A1",IF(AA29>=32.4,"A2",IF(AA29>=28.4,"B1",IF(AA29>24.4,"B2",IF(AA29>=20.4,"C1",IF(AA29>=16.4,"C2","D"))))))'>C1
24	1024	Sanjay G K	N	20	10	10	10	50	46	96	9.6	=901,"A1",IF(L30>=8.1,"A2",IF(L30>=7.1,"B1",IF(L30>6.1,"B2",IF(L30>=5.1,"C1",IF(L30>=4.1,"C2","D"))))))'>A2	18	9	10	10	47	36	83	8.3	=9.1,"A1",IF(U30>=8.1,"A2",IF(U30>=7.1,"B1",IF(U30>6.1,"B2",IF(U30>=5.1,"C1",IF(U30>=4.1,"C2","D"))))))'>A2	96	19.20	=18.2,"A1",IF(X30>=16.2,"A2",IF(X30>=14.2,"B1",IF(X30>=12.2,"B2",IF(X30>=10.2,"C1",IF(X30>=8.2,"C2","D"))))))'>A1	275	37.10	=36.4,"A1",IF(AA30>=32.4,"A2",IF(AA30>=28.4,"B1",IF(AA30>24.4,"B2",IF(AA30>=20.4,"C1",IF(AA30>=16.4,"C2","D"))))))'>A1
25	1025	Santaram R A	A	20	6	8	10	44	25	69	6.9	=901,"A1",IF(L31>=8.1,"A2",IF(L31>=7.1,"B1",IF(L31>6.1,"B2",IF(L31>=5.1,"C1",IF(L31>=4.1,"C2","D"))))))'>B2	16	9	9	10	44	30	74	7.4	=9.1,"A1",IF(U31>=8.1,"A2",IF(U31>=7.1,"B1",IF(U31>6.1,"B2",IF(U31>=5.1,"C1",IF(U31>=4.1,"C2","D"))))))'>B1	74	14.80	=18.2,"A1",IF(X31>=16.2,"A2",IF(X31>=14.2,"B1",IF(X31>=12.2,"B2",IF(X31>=10.2,"C1",IF(X31>=8.2,"C2","D"))))))'>B1	217	29.10	=36.4,"A1",IF(AA31>=32.4,"A2",IF(AA31>=28.4,"B1",IF(AA31>24.4,"B2",IF(AA31>=20.4,"C1",IF(AA31>=16.4,"C2","D"))))))'>B1
26	1026	Santosh M C	U	10	6	4	6	26	20	46	4.6	=901,"A1",IF(L32>=8.1,"A2",IF(L32>=7.1,"B1",IF(L32>6.1,"B2",IF(L32>=5.1,"C1",IF(L32>=4.1,"C2","D"))))))'>C2	11	8	8	4	31	28	59	5.9	=9.1,"A1",IF(U32>=8.1,"A2",IF(U32>=7.1,"B1",IF(U32>6.1,"B2",IF(U32>=5.1,"C1",IF(U32>=4.1,"C2","D"))))))'>C1	56	11.20	=18.2,"A1",IF(X32>=16.2,"A2",IF(X32>=14.2,"B1",IF(X32>=12.2,"B2",IF(X32>=10.2,"C1",IF(X32>=8.2,"C2","D"))))))'>C1	161	21.70	=36.4,"A1",IF(AA32>=32.4,"A2",IF(AA32>=28.4,"B1",IF(AA32>24.4,"B2",IF(AA32>=20.4,"C1",IF(AA32>=16.4,"C2","D"))))))'>C1
27	1027	Shantagouda S K	N	20	7	10	10	47	42	89	8.9	=901,"A1",IF(L33>=8.1,"A2",IF(L33>=7.1,"B1",IF(L33>6.1,"B2",IF(L33>=5.1,"C1",IF(L33>=4.1,"C2","D"))))))'>A2	14	8	10	10	42	29	71	7.1	=9.1,"A1",IF(U33>=8.1,"A2",IF(U33>=7.1,"B1",IF(U33>6.1,"B2",IF(U33>=5.1,"C1",IF(U33>=4.1,"C2","D"))))))'>B1	82	16.40	=18.2,"A1",IF(X33>=16.2,"A2",IF(X33>=14.2,"B1",IF(X33>=12.2,"B2",IF(X33>=10.2,"C1",IF(X33>=8.2,"C2","D"))))))'>A2	242	32.40	=36.4,"A1",IF(AA33>=32.4,"A2",IF(AA33>=28.4,"B1",IF(AA33>24.4,"B2",IF(AA33>=20.4,"C1",IF(AA33>=16.4,"C2","D"))))))'>A2
28	1028	Sharada B H	U	20	8	10	10	48	34	82	8.2	=901,"A1",IF(L34>=8.1,"A2",IF(L34>=7.1,"B1",IF(L34>6.1,"B2",IF(L34>=5.1,"C1",IF(L34>=4.1,"C2","D"))))))'>A2	18	9	10	10	47	32	79	7.9	=9.1,"A1",IF(U34>=8.1,"A2",IF(U34>=7.1,"B1",IF(U34>6.1,"B2",IF(U34>=5.1,"C1",IF(U34>=4.1,"C2","D"))))))'>B1	59	11.80	=18.2,"A1",IF(X34>=16.2,"A2",IF(X34>=14.2,"B1",IF(X34>=12.2,"B2",IF(X34>=10.2,"C1",IF(X34>=8.2,"C2","D"))))))'>C1	220	27.90	=36.4,"A1",IF(AA34>=32.4,"A2",IF(AA34>=28.4,"B1",IF(AA34>24.4,"B2",IF(AA34>=20.4,"C1",IF(AA34>=16.4,"C2","D"))))))'>B2
29	1029	Sharankumar S U	A	18	5	10	9	42	35	77	7.7	=901,"A1",IF(L35>=8.1,"A2",IF(L35>=7.1,"B1",IF(L35>6.1,"B2",IF(L35>=5.1,"C1",IF(L35>=4.1,"C2","D"))))))'>B1	14	8	10	10	42	40	82	8.2	=9.1,"A1",IF(U35>=8.1,"A2",IF(U35>=7.1,"B1",IF(U35>6.1,"B2",IF(U35>=5.1,"C1",IF(U35>=4.1,"C2","D"))))))'>A2	72	14.40	=18.2,"A1",IF(X35>=16.2,"A2",IF(X35>=14.2,"B1",IF(X35>=12.2,"B2",IF(X35>=10.2,"C1",IF(X35>=8.2,"C2","D"))))))'>B1	231	30.30	=36.4,"A1",IF(AA35>=32.4,"A2",IF(AA35>=28.4,"B1",IF(AA35>24.4,"B2",IF(AA35>=20.4,"C1",IF(AA35>=16.4,"C2","D"))))))'>B1
30	1030	Sharat B P	A	15	4	8	10	37	27	64	6.4	=901,"A1",IF(L36>=8.1,"A2",IF(L36>=7.1,"B1",IF(L36>6.1,"B2",IF(L36>=5.1,"C1",IF(L36>=4.1,"C2","D"))))))'>B2	18	10	10	10	48	35	83	8.3	=9.1,"A1",IF(U36>=8.1,"A2",IF(U36>=7.1,"B1",IF(U36>6.1,"B2",IF(U36>=5.1,"C1",IF(U36>=4.1,"C2","D"))))))'>A2	85	17.00	=18.2,"A1",IF(X36>=16.2,"A2",IF(X36>=14.2,"B1",IF(X36>=12.2,"B2",IF(X36>=10.2,"C1",IF(X36>=8.2,"C2","D"))))))'>A2	232	31.70	=36.4,"A1",IF(AA36>=32.4,"A2",IF(AA36>=28.4,"B1",IF(AA36>24.4,"B2",IF(AA36>=20.4,"C1",IF(AA36>=16.4,"C2","D"))))))'>B1
31	1031	Shashikanth S D	A	17	8	10	10	45	30	75	7.5	=901,"A1",IF(L37>=8.1,"A2",IF(L37>=7.1,"B1",IF(L37>6.1,"B2",IF(L37>=5.1,"C1",IF(L37>=4.1,"C2","D"))))))'>B1	16	9	10	10	45	36	81	8.1	=9.1,"A1",IF(U37>=8.1,"A2",IF(U37>=7.1,"B1",IF(U37>6.1,"B2",IF(U37>=5.1,"C1",IF(U37>=4.1,"C2","D"))))))'>A2	81	16.20	=18.2,"A1",IF(X37>=16.2,"A2",IF(X37>=14.2,"B1",IF(X37>=12.2,"B2",IF(X37>=10.2,"C1",IF(X37>=8.2,"C2","D"))))))'>A2	237	31.80	=36.4,"A1",IF(AA37>=32.4,"A2",IF(AA37>=28.4,"B1",IF(AA37>24.4,"B2",IF(AA37>=20.4,"C1",IF(AA37>=16.4,"C2","D"))))))'>B1
32	1032	Shivanand I N	U	17	5	9	9	40	30	70	7.0	=901,"A1",IF(L38>=8.1,"A2",IF(L38>=7.1,"B1",IF(L38>6.1,"B2",IF(L38>=5.1,"C1",IF(L38>=4.1,"C2","D"))))))'>B2	14	8	8	9	39	26	65	6.5	=9.1,"A1",IF(U38>=8.1,"A2",IF(U38>=7.1,"B1",IF(U38>6.1,"B2",IF(U38>=5.1,"C1",IF(U38>=4.1,"C2","D"))))))'>B2	59	11.80	=18.2,"A1",IF(X38>=16.2,"A2",IF(X38>=14.2,"B1",IF(X38>=12.2,"B2",IF(X38>=10.2,"C1",IF(X38>=8.2,"C2","D"))))))'>C1	194	25.30	=36.4,"A1",IF(AA38>=32.4,"A2",IF(AA38>=28.4,"B1",IF(AA38>24.4,"B2",IF(AA38>=20.4,"C1",IF(AA38>=16.4,"C2","D"))))))'>B2
33	1033	Shruti K R	N	20	10	10	10	50	43	93	9.3	=901,"A1",IF(L39>=8.1,"A2",IF(L39>=7.1,"B1",IF(L39>6.1,"B2",IF(L39>=5.1,"C1",IF(L39>=4.1,"C2","D"))))))'>A2	16	9	10	9	44	39	83	8.3	=9.1,"A1",IF(U39>=8.1,"A2",IF(U39>=7.1,"B1",IF(U39>6.1,"B2",IF(U39>=5.1,"C1",IF(U39>=4.1,"C2","D"))))))'>A2	80	16.00	=18.2,"A1",IF(X39>=16.2,"A2",IF(X39>=14.2,"B1",IF(X39>=12.2,"B2",IF(X39>=10.2,"C1",IF(X39>=8.2,"C2","D"))))))'>B1	256	33.60	=36.4,"A1",IF(AA39>=32.4,"A2",IF(AA39>=28.4,"B1",IF(AA39>24.4,"B2",IF(AA39>=20.4,"C1",IF(AA39>=16.4,"C2","D"))))))'>A2
34	1034	Shruti R A	S	17	9	8	8	42	38	80	8.0	=901,"A1",IF(L40>=8.1,"A2",IF(L40>=7.1,"B1",IF(L40>6.1,"B2",IF(L40>=5.1,"C1",IF(L40>=4.1,"C2","D"))))))'>B1	16	9	9	10	44	41	85	8.5	=9.1,"A1",IF(U40>=8.1,"A2",IF(U40>=7.1,"B1",IF(U40>6.1,"B2",IF(U40>=5.1,"C1",IF(U40>=4.1,"C2","D"))))))'>A2	84	16.80	=18.2,"A1",IF(X40>=16.2,"A2",IF(X40>=14.2,"B1",IF(X40>=12.2,"B2",IF(X40>=10.2,"C1",IF(X40>=8.2,"C2","D"))))))'>A2	249	33.30	=36.4,"A1",IF(AA40>=32.4,"A2",IF(AA40>=28.4,"B1",IF(AA40>24.4,"B2",IF(AA40>=20.4,"C1",IF(AA40>=16.4,"C2","D"))))))'>A2
35	1035	Sundar B B	N	19	6	10	10	45	32	77	7.7	=901,"A1",IF(L41>=8.1,"A2",IF(L41>=7.1,"B1",IF(L41>6.1,"B2",IF(L41>=5.1,"C1",IF(L41>=4.1,"C2","D"))))))'>B1	18	10	9	10	47	36	83	8.3	=9.1,"A1",IF(U41>=8.1,"A2",IF(U41>=7.1,"B1",IF(U41>6.1,"B2",IF(U41>=5.1,"C1",IF(U41>=4.1,"C2","D"))))))'>A2	86	17.20	=18.2,"A1",IF(X41>=16.2,"A2",IF(X41>=14.2,"B1",IF(X41>=12.2,"B2",IF(X41>=10.2,"C1",IF(X41>=8.2,"C2","D"))))))'>A2	246	33.20	=36.4,"A1",IF(AA41>=32.4,"A2",IF(AA41>=28.4,"B1",IF(AA41>24.4,"B2",IF(AA41>=20.4,"C1",IF(AA41>=16.4,"C2","D"))))))'>A2
36	1036	Supriya B M	U	20	9	10	10	49	43	92	9.2	=901,"A1",IF(L42>=8.1,"A2",IF(L42>=7.1,"B1",IF(L42>6.1,"B2",IF(L42>=5.1,"C1",IF(L42>=4.1,"C2","D"))))))'>A2	18	10	10	10	48	44	92	9.2	=9.1,"A1",IF(U42>=8.1,"A2",IF(U42>=7.1,"B1",IF(U42>6.1,"B2",IF(U42>=5.1,"C1",IF(U42>=4.1,"C2","D"))))))'>A1	82	16.40	=18.2,"A1",IF(X42>=16.2,"A2",IF(X42>=14.2,"B1",IF(X42>=12.2,"B2",IF(X42>=10.2,"C1",IF(X42>=8.2,"C2","D"))))))'>A2	266	34.80	=36.4,"A1",IF(AA42>=32.4,"A2",IF(AA42>=28.4,"B1",IF(AA42>24.4,"B2",IF(AA42>=20.4,"C1",IF(AA42>=16.4,"C2","D"))))))'>A2
37	1037	Suvarna G M	S	20	9	10	10	49	42	91	9.1	=901,"A1",IF(L43>=8.1,"A2",IF(L43>=7.1,"B1",IF(L43>6.1,"B2",IF(L43>=5.1,"C1",IF(L43>=4.1,"C2","D"))))))'>A2	9	8	10	10	37	23	60	6.0	=9.1,"A1",IF(U43>=8.1,"A2",IF(U43>=7.1,"B1",IF(U43>6.1,"B2",IF(U43>=5.1,"C1",IF(U43>=4.1,"C2","D"))))))'>C1	77	15.40	=18.2,"A1",IF(X43>=16.2,"A2",IF(X43>=14.2,"B1",IF(X43>=12.2,"B2",IF(X43>=10.2,"C1",IF(X43>=8.2,"C2","D"))))))'>B1	228	30.50	=36.4,"A1",IF(AA43>=32.4,"A2",IF(AA43>=28.4,"B1",IF(AA43>24.4,"B2",IF(AA43>=20.4,"C1",IF(AA43>=16.4,"C2","D"))))))'>B1
38	1038	Varsha H C	S	20	10	10	10	50	44	94	9.4	=901,"A1",IF(L44>=8.1,"A2",IF(L44>=7.1,"B1",IF(L44>6.1,"B2",IF(L44>=5.1,"C1",IF(L44>=4.1,"C2","D"))))))'>A2	18	10	10	10	48	40	88	8.8	=9.1,"A1",IF(U44>=8.1,"A2",IF(U44>=7.1,"B1",IF(U44>6.1,"B2",IF(U44>=5.1,"C1",IF(U44>=4.1,"C2","D"))))))'>A2	81	16.20	=18.2,"A1",IF(X44>=16.2,"A2",IF(X44>=14.2,"B1",IF(X44>=12.2,"B2",IF(X44>=10.2,"C1",IF(X44>=8.2,"C2","D"))))))'>A2	263	34.40	=36.4,"A1",IF(AA44>=32.4,"A2",IF(AA44>=28.4,"B1",IF(AA44>24.4,"B2",IF(AA44>=20.4,"C1",IF(AA44>=16.4,"C2","D"))))))'>A2
39	1039	Varsha S S	A	19	7	10	10	46	26	72	7.2	=901,"A1",IF(L45>=8.1,"A2",IF(L45>=7.1,"B1",IF(L45>6.1,"B2",IF(L45>=5.1,"C1",IF(L45>=4.1,"C2","D"))))))'>B1	12	8	6	9	35	30	65	6.5	=9.1,"A1",IF(U45>=8.1,"A2",IF(U45>=7.1,"B1",IF(U45>6.1,"B2",IF(U45>=5.1,"C1",IF(U45>=4.1,"C2","D"))))))'>B2	62	12.40	=18.2,"A1",IF(X45>=16.2,"A2",IF(X45>=14.2,"B1",IF(X45>=12.2,"B2",IF(X45>=10.2,"C1",IF(X45>=8.2,"C2","D"))))))'>B2	199	26.10	=36.4,"A1",IF(AA45>=32.4,"A2",IF(AA45>=28.4,"B1",IF(AA45>24.4,"B2",IF(AA45>=20.4,"C1",IF(AA45>=16.4,"C2","D"))))))'>B2
40	1040	Veena R H	A	19	8	9	9	45	41	86	8.6	=901,"A1",IF(L46>=8.1,"A2",IF(L46>=7.1,"B1",IF(L46>6.1,"B2",IF(L46>=5.1,"C1",IF(L46>=4.1,"C2","D"))))))'>A2	20	10	10	10	50	42	92	9.2	=9.1,"A1",IF(U46>=8.1,"A2",IF(U46>=7.1,"B1",IF(U46>6.1,"B2",IF(U46>=5.1,"C1",IF(U46>=4.1,"C2","D"))))))'>A1	82	16.40	=18.2,"A1",IF(X46>=16.2,"A2",IF(X46>=14.2,"B1",IF(X46>=12.2,"B2",IF(X46>=10.2,"C1",IF(X46>=8.2,"C2","D"))))))'>A2	260	34.20	=36.4,"A1",IF(AA46>=32.4,"A2",IF(AA46>=28.4,"B1",IF(AA46>24.4,"B2",IF(AA46>=20.4,"C1",IF(AA46>=16.4,"C2","D"))))))'>A2
41	1041	Vishwaradhya S M	N	17	7	8	9	41	33	74	7.4	=901,"A1",IF(L47>=8.1,"A2",IF(L47>=7.1,"B1",IF(L47>6.1,"B2",IF(L47>=5.1,"C1",IF(L47>=4.1,"C2","D"))))))'>B1	15	8	6	6	35	27	62	6.2	=9.1,"A1",IF(U47>=8.1,"A2",IF(U47>=7.1,"B1",IF(U47>6.1,"B2",IF(U47>=5.1,"C1",IF(U47>=4.1,"C2","D"))))))'>B2	70	14.00	=18.2,"A1",IF(X47>=16.2,"A2",IF(X47>=14.2,"B1",IF(X47>=12.2,"B2",IF(X47>=10.2,"C1",IF(X47>=8.2,"C2","D"))))))'>B2	206	27.60	=36.4,"A1",IF(AA47>=32.4,"A2",IF(AA47>=28.4,"B1",IF(AA47>24.4,"B2",IF(AA47>=20.4,"C1",IF(AA47>=16.4,"C2","D"))))))'>B2

Group photo of jnv

FA-1 MATHEMATICS VIII

FORMATIVE ASSEMENT I JULY2011


JAWAHAR NAVODAYA VIDYALAYA HOTHPETH GULBARGA
FORMATIVE TEST FIRST JULY 2011)
Mathematics: VIII Max marks:50

__________________________________________________

QUESTIONS OF ONE MARK EACH

1. The property of a+b =b+a is known as :
a) Closer property b) commutative property
c) Inverse property d) property of identity
2. The product of two rational number is always ……
a) Irrational b) 2 Rational c) Neither rational nor
Irrational d) None these
3. The additive inverse of - is -------.
a) - b) - c) d)
4. Identify the monamial among the fallowings:
a) 4xyz2 b) xy+z c) z2y+x2 d) z2+2
5. If 5x-3 =2 then value of x will be …..
a)2. b) -1. c) 1 d) 10
6. The sum of 24xyz, -10yxz, -14zxy. Will give ….
a) 48 xyz b)-48xyz c) 0 d) None of them

QUESTIONS OF TWO MARKS EACH
7. Obtain the value of x: 2x-1 = 14 - x
8. Find the multiplicative inverse of and -
9. Obtain the volume of rectangular box whose length, breadth, and height are 4xy, 5yz, 3zx.
10. Add: p(p-q), q(q –r), r(r-p)
11. The sum of two consecutive natural number is 109 find the numbers .
QUESTIONS OF THREE MARKS EACH

12. Obtain any five rational numbers between and
13. Find the product of ( 2x-3y) (4x2-6xy+9y2) and find its value when x=2 and y=1
14. Simplify: (x2+7)(x2-5) +2(x2 +15).

at house plantation

gangadhar Tanakedar

yadgir school day photo

awrd of house prize

plantation 2

group photo

Happy New Year

Avoid to have fear as you sinciar
let us celebrate happy new year

you forget the past recall the most

Speech at JNV Yadgir

Pictures of TG

Question paper Mathematics VIII

JAWAHAR NAVODAYA VIDYALAYA HOTHPET
VIth UNIT TEST
Subject –Mathematics Max.marks - 40
Class - VIII Date - 25/02/2010

SECTION – A (1 x 6 = 6)
1) Match the planar figures with their respective areas.
A B
a) Quadrilateral i) 1/2(a+b)h
b) Parallelogram ii) 1/2(h1+h2)d
c) Rhombus iii) пr2/2
d) Trapezium iv) 1/2 d1d2
e) Semicircle v) bh
2) If X and Y are two variables, then write the condition for them to be
a) Directly proportional
b) Inversly proportional
SECTION – B (2 x 5 = 10)
3) If the weight of 12 sheets of thick paper is 40 grams, how many sheets of same paper would weigh 2 ½ kilograms?
4) 6 pipes are required to fill a tank in 1hr 20min. How long will it take if only 5 pipes of the same type are used?
5) Find the height of a cylinder whose radius is 7cm and total surface area is 968cm2
6) A gift box in the form of a cuboid has the dimensions 8cm X 3cm X 4cm.Find the colour paper required to cover its lateral faces.
7) Find the height of a cuboid whose base area is 180cm2 and volume is 900cm3
SECTION – C (3 x 4 = 12)
8) A 5m 60cm high vertical pole casts a shadow of 3m 20cm long. Find at the same
time the height of a pole which casts a shadow of 5m long.
9) Find the volume of a cube whose total surface area is 486cm2
10) A cubical classroom of each edge 40m is to be white washed leaving the floor. Find the region to be white washed .
11) Classify the following pair of variables under direct and inverse proportionality.
a) Demand of the product and its production.
b) Speed of the vehicle and time taken to cover the same distance.
c) The population of a country and the area of land per person.
SECTION – D (4 x 3 = 12)
12) If a box of sweets is divided among 24 children, they will get 5 sweets each.
a) How many would each get if the number of children is reduced by 4.
b) How many students will be extra, if each get 4 sweets.
13) The floor of a building consists of 3000 tiles which are rhombus shaped and
each of its diagonal are 45cm & 30cm. Find the total cost of polishing the floor,
if the cost per m2 is Rs 4.
14) In a building there are 24 cylindrical pillars. The radius of each pillar is 28m
& height is 4m. Find the total cost of painting the curved surface area of all
Pillars at the rate of Rs 8 per m2.