Marks Scored by the students in the given Semester are as follows

Column1 Column2 Column3 Column4 Column5 Column6 Column7

Credits = 3 Credits = 1 Credits = 3
BS101 (Theory) BS101L (Lab) BS102 (Theory)
Name of Student Roll No ISE ESE TW PE ISE
May Wilmot 1100 32 30 21 22 29
David Shiner 1101 34 33 22 23 32
Gary Reynolds 1102 23 36 19 20 37
Mark Buntain 1103 43 34 19 18 33
Christine Davies 1104 44 32 20 19 32
Gary Shaw 1105 36 37 22 18 38
Christopher Cresswell 1106 38 39 23 19 39
Gillian Allnutt 1107 37 40 21 23 44
Francis Godden 1108 33 41 17 18 41
Christopher Cresswell 1109 25 25 15 11 25
Danny Brooks 1110 27 29 12 10 30
John Jenkins 1111 30 28 19 20 31
Richard Allnutt 1112 29 31 20 18 31
Tessa Morrow 1113 31 32 21 19 32
James Ricketts 1114 33 35 22 19 33
Susan Dixon 1115 35 36 18 16 35
Thomas Gordon 1116 37 37 16 17 36
David Walker 1117 41 29 15 18 30
Robin Hall 1118 42 30 21 20 30
Kenneth Walter 1119 44 31 22 23 33
1. Calculate Grade Point for all the students for this semester
2. Calculate SGPA for all the students (upto two decimal points)

Reference Material
Marks Obtained Grade Point
≥ 90 10
80 -- 89 9
70 -- 79 8
60 -- 69 7
40 -- 59 6
< 40 5
 Column8 Column9 Column10 Column11 Column12 Column13 Column14
Credits = 1 Credits = 3 Credits = 3
02 (Theory) BS102L (Lab) BS103 (Theory) BS104 (Theory)
ESE TW PE ISE ESE ISE ESE
33 21 21 29 27 33 31
35 22 19 32 34 37 33
25 19 20 37 25 24 34
43 18 19 33 43 39 44
44 19 18 32 44 43 32
33 20 21 21 33 37 37
37 19 20 39 22 33 39
34 23 21 44 34 37 39
33 18 19 41 33 33 41
29 16 17 25 22 30 25
27 13 12 30 27 28 31
31 20 19 31 31 30 28
30 20 20 31 32 25 33
31 19 20 32 31 31 32
33 19 21 33 33 26 22
34 16 18 35 23 35 36
38 19 20 36 38 28 29
39 18 17 30 29 41 35
40 20 21 30 29 37 30
41 20 21 33 30 41 35
3)autofit data into column
4) chart into image
5)delete blank sheets

vba programming
1)text to speech converter
2)change the chart type
3)create table of content from different worksheet in the same file
4)save selected range as a pdf file
5)convert selected text to a proper case
Marks Scored by the students in the given Semester are as follows

Column1 Column2 Column3 Column4 Column5 Column6

Credits = 3 Credits = 1
BS101 (Theory) BS101L (Lab) BS102 (Theory)
Name of Student Roll No ISE ESE TW PE
May Wilmot 1100 32 30 21 22
David Shiner 1101 34 33 22 23
Gary Reynolds 1102 23 36 19 20
Mark Buntain 1103 43 34 19 18
Christine Davies 1104 44 32 20 19
Gary Shaw 1105 36 37 22 18
Christopher Cresswell 1106 38 39 23 19
Gillian Allnutt 1107 37 40 21 23
Francis Godden 1108 33 41 17 18
Christopher Cresswell 1109 25 25 15 11
Danny Brooks 1110 27 29 12 10
John Jenkins 1111 30 28 19 20
Richard Allnutt 1112 29 31 20 18
Tessa Morrow 1113 31 32 21 19
James Ricketts 1114 33 35 22 19
Susan Dixon 1115 35 36 18 16
Thomas Gordon 1116 37 37 16 17
David Walker 1117 41 29 15 18
Robin Hall 1118 42 30 21 20
Kenneth Walter 1119 44 31 22 23
1. Calculate Grade Point for all the students for this semester
2. Calculate SGPA for all the students (upto two decimal points)

Reference Material
Marks Obtained Grade Point
≥ 90 10
80 -- 89 9
70 -- 79 8
60 -- 69 7
40 -- 59 6
< 40 5
 Column7 Column8 Column9 Column10 Column11 Column12 Column13
Credits = 3 Credits = 1 Credits = 3 Credits = 3
BS102 (Theory) BS102L (Lab) BS103 (Theory) BS104 (Theory)
ISE ESE TW PE ISE ESE ISE
29 33 21 21 29 27 33
32 35 22 19 32 34 37
37 25 19 20 37 25 24
33 43 18 19 33 43 39
32 44 19 18 32 44 43
38 33 20 21 21 33 37
39 37 19 20 39 22 33
44 34 23 21 44 34 37
41 33 18 19 41 33 33
25 29 16 17 25 22 30
30 27 13 12 30 27 28
31 31 20 19 31 31 30
31 30 20 20 31 32 25
32 31 19 20 32 31 31
33 33 19 21 33 33 26
35 34 16 18 35 23 35
36 38 19 20 36 38 28
30 39 18 17 30 29 41
30 40 20 21 30 29 37
33 41 20 21 33 30 41
this semester
decimal points)
 Column14

4 (Theory)
ESE
31
33 3)autofit data into column
34 4) chart into image
44 5)delete blank sheets
32
37 vba programming
39 1)text to speech converter
39 2)change the chart type
41 3)create table of content from different worksheet in the same file
25 4)save selected range as a pdf file
31 5)convert selected text to a proper case
28
33
32
22
36
29
35
30
35
 Clustered Column showing marks obtained by 2 students in each subject
40

35

30

25
Marks Obtained

20 May Wilmot 1100

David Shiner 1101

15

10

0
BS101 BS101L BS102 BS102L BS103 BS104
(Theory) (Lab) (Theory) (Lab) (Theory) (Theory)

Subjects
 Clustered Column showing marks obtained by 2 students in each subject

40

35

30

25
Marks Obtained

Name of Student Roll No

20 May Wilmot 1100
David Shiner 1101

15

10

0
BS101 BS101L BS102 BS102L BS103 BS104
(Theory) (Lab) (Theory) (Lab) (Theory) (Theory)

Subjects
Marks Scored by the students in the given Semester are as follows

Credits = 3 Credits = 1 Credits = 3

BS101 (Theory) BS101L (Lab) BS102 (Theory)
Name of Student Roll No ISE ESE TW PE ISE ESE
May Wilmot 1100 32 30 21 22 29 33
David Shiner 1101 34 33 22 23 32 35
Gary Reynolds 1102 23 36 19 20 37 25
Mark Buntain 1103 43 34 19 18 33 43
Christine Davies 1104 44 32 20 19 32 44
Gary Shaw 1105 36 37 22 18 38 33
Christopher Cresswell 1106 38 39 23 19 39 37
Gillian Allnutt 1107 37 40 21 23 44 34
Francis Godden 1108 33 41 17 18 41 33
Christopher Cresswell 1109 25 25 15 11 25 29
Danny Brooks 1110 27 29 12 10 30 27
John Jenkins 1111 30 28 19 20 31 31
Richard Allnutt 1112 29 31 20 18 31 30
Tessa Morrow 1113 31 32 21 19 32 31
James Ricketts 1114 33 35 22 19 33 33
Susan Dixon 1115 35 36 18 16 35 34
Thomas Gordon 1116 37 37 16 17 36 38
David Walker 1117 41 29 15 18 30 39
Robin Hall 1118 42 30 21 20 30 40
Kenneth Walter 1119 44 31 22 23 33 41

1. Calculate Grade Point for all the students for this semester
2. Calculate SGPA for all the students (upto two decimal points)

Reference Material
Marks Obtained Grade Point
≥ 90 10
80 -- 89 9
70 -- 79 8
60 -- 69 7
40 -- 59 6
< 40 5
 Credits = 1 Credits = 3 Credits = 3
BS102L (Lab) BS103 (Theory) BS104 (Theory)
TW PE ISE ESE ISE ESE
21 21 29 27 33 31
22 19 32 34 37 33 2)chart creation
19 20 37 25 24 34 3)autofit data into column
18 19 33 43 39 44 4) chart into image
19 18 32 44 43 32 5)delete blank sheets
20 21 21 33 37 37
19 20 39 22 33 39 vba programming
23 21 44 34 37 39 1)text to speech converter
18 19 41 33 33 41 2)change the chart type
16 17 25 22 30 25 3)create table of content from different worksheet
13 12 30 27 28 31 4)save selected range as a pdf file
20 19 31 31 30 28 5)convert selected text to a proper case
20 20 31 32 25 33
19 20 32 31 31 32
19 21 33 33 26 22
16 18 35 23 35 36
19 20 36 38 28 29
18 17 30 29 41 35
20 21 30 29 37 30
20 21 33 30 41 35

mal points)
tent from different worksheet in the same file
e as a pdf file
ext to a proper case
Marks Scored by the students in the given Semester are as follows

Credits = 3 Credits = 1 Credits = 3

BS101 (Theory) BS101L (Lab) BS102 (Theory)
Name of Student Roll No ISE ESE TW PE ISE ESE
May Wilmot 1100 32 30 21 22 29 33
David Shiner 1101 34 33 22 23 32 35
Gary Reynolds 1102 23 36 19 20 37 25
Mark Buntain 1103 43 34 19 18 33 43
Christine Davies 1104 44 32 20 19 32 44
Gary Shaw 1105 36 37 22 18 38 33
Christopher Cresswell 1106 38 39 23 19 39 37
Gillian Allnutt 1107 37 40 21 23 44 34
Francis Godden 1108 33 41 17 18 41 33
Christopher Cresswell 1109 25 25 15 11 25 29
Danny Brooks 1110 27 29 12 10 30 27
John Jenkins 1111 30 28 19 20 31 31
Richard Allnutt 1112 29 31 20 18 31 30
Tessa Morrow 1113 31 32 21 19 32 31
James Ricketts 1114 33 35 22 19 33 33
Susan Dixon 1115 35 36 18 16 35 34
Thomas Gordon 1116 37 37 16 17 36 38
David Walker 1117 41 29 15 18 30 39
Robin Hall 1118 42 30 21 20 30 40
Kenneth Walter 1119 44 31 22 23 33 41

1. Calculate Grade Point for all the students for this semester
2. Calculate SGPA for all the students (upto two decimal points)

Reference Material
Marks Obtained Grade Point
≥ 90 10
80 -- 89 9
70 -- 79 8
60 -- 69 7
40 -- 59 6
< 40 5
 Credits = 1 Credits = 3 Credits = 3
BS102L (Lab) BS103 (Theory) BS104 (Theory)
TW PE ISE ESE ISE ESE
21 21 29 27 33 31
22 19 32 34 37 33 2)chart creation
19 20 37 25 24 34 3)autofit data into column
18 19 33 43 39 44 4) chart into image
19 18 32 44 43 32 5)delete blank sheets
20 21 21 33 37 37
19 20 39 22 33 39 vba programming
23 21 44 34 37 39 1)text to speech converter
18 19 41 33 33 41 2)change the chart type
16 17 25 22 30 25 3)create table of content from different work
13 12 30 27 28 31 4)save selected range as a pdf file
20 19 31 31 30 28 5)convert selected text to a proper case
20 20 31 32 25 33
19 20 32 31 31 32
19 21 33 33 26 22
16 18 35 23 35 36
19 20 36 38 28 29
18 17 30 29 41 35
20 21 30 29 37 30
20 21 33 30 41 35

mal points)
tent from different worksheet in the same file
e as a pdf file
ext to a proper case
Marks Scored by the students in the given Semester are as follows

Credits = 3 Credits = 1 Credits = 3

BS101 (Theory) BS101L (Lab) BS102 (Theory)
Name of Student Roll No ISE ESE TW PE ISE ESE
May Wilmot 1100 32 30 21 22 29 33
David Shiner 1101 34 33 22 23 32 35
Gary Reynolds 1102 23 36 19 20 37 25
Mark Buntain 1103 43 34 19 18 33 43
Christine Davies 1104 44 32 20 19 32 44
Gary Shaw 1105 36 37 22 18 38 33
Christopher Cresswell 1106 38 39 23 19 39 37
Gillian Allnutt 1107 37 40 21 23 44 34
Francis Godden 1108 33 41 17 18 41 33
Christopher Cresswell 1109 25 25 15 11 25 29
Danny Brooks 1110 27 29 12 10 30 27
John Jenkins 1111 30 28 19 20 31 31
Richard Allnutt 1112 29 31 20 18 31 30
Tessa Morrow 1113 31 32 21 19 32 31
James Ricketts 1114 33 35 22 19 33 33
Susan Dixon 1115 35 36 18 16 35 34
Thomas Gordon 1116 37 37 16 17 36 38
David Walker 1117 41 29 15 18 30 39
Robin Hall 1118 42 30 21 20 30 40
Kenneth Walter 1119 44 31 22 23 33 41

1. Calculate Grade Point for all the students for this semester
2. Calculate SGPA for all the students (upto two decimal points)

Reference Material
Marks Obtained Grade Point
≥ 90 10
80 -- 89 9
70 -- 79 8
60 -- 69 7
40 -- 59 6
< 40 5
 Credits = 1 Credits = 3 Credits = 3
BS102L (Lab) BS103 (Theory) BS104 (Theory)
TW PE ISE ESE ISE ESE
21 21 29 27 33 31
22 19 32 34 37 33 2)chart creation
19 20 37 25 24 34 3)autofit data into column
18 19 33 43 39 44 4) chart into image
19 18 32 44 43 32 5)delete blank sheets
20 21 21 33 37 37
19 20 39 22 33 39 vba programming
23 21 44 34 37 39 1)text to speech converter
18 19 41 33 33 41 2)change the chart type
16 17 25 22 30 25 3)create table of content from different work
13 12 30 27 28 31 4)save selected range as a pdf file
20 19 31 31 30 28 5)convert selected text to a proper case
20 20 31 32 25 33
19 20 32 31 31 32
19 21 33 33 26 22
16 18 35 23 35 36
19 20 36 38 28 29
18 17 30 29 41 35
20 21 30 29 37 30
20 21 33 30 41 35

mal points)
tent from different worksheet in the same file
e as a pdf file
ext to a proper case
 Chart Title
50

45

40

35

30

25

20

15

10

0
May Wilmot David Shiner Gary Reynolds Mark Buntain Christine Davies

BS101 (Theory) ISE ESE BS101L (Lab) TW PE

Marks Scored by the students in the given Semester are as follows

Credits = 3 Credits = 1 Credits = 3

BS101 (Theory) BS101L (Lab) BS102 (Theory) BS102L (Lab)
Name of Student ISE ESE TW PE ISE ESE TW
May Wilmot 32 30 21 22 29 33 21
David Shiner 34 33 22 23 32 35 22
Gary Reynolds 23 36 19 20 37 25 19
Mark Buntain 43 34 19 18 33 43 18
Christine Davies 44 32 20 19 32 44 19
Gary Shaw 36 37 22 18 38 33 20
Christopher Cresswell 38 39 23 19 39 37 19
Gillian Allnutt 37 40 21 23 44 34 23
Francis Godden 33 41 17 18 41 33 18
Christopher Cresswell 25 25 15 11 25 29 16
Danny Brooks 27 29 12 10 30 27 13
John Jenkins 30 28 19 20 31 31 20
Richard Allnutt 29 31 20 18 31 30 20
Tessa Morrow 31 32 21 19 32 31 19
James Ricketts 33 35 22 19 33 33 19
Susan Dixon 35 36 18 16 35 34 16
Thomas Gordon 37 37 16 17 36 38 19
David Walker 41 29 15 18 30 39 18
Robin Hall 42 30 21 20 30 40 20
Kenneth Walter 44 31 22 23 33 41 20

1. Calculate Grade Point for all the students for this semester
2. Calculate SGPA for all the students (upto two decimal points)

Reference Material
Marks Obtained Grade Point
≥ 90 10
80 -- 89 9
70 -- 79 8
60 -- 69 7
40 -- 59 6
< 40 5
 Credits = 1 Credits = 3 Credits = 3
BS102L (Lab) BS103 (Theory) BS104 (Theory)
PE ISE ESE ISE ESE
21 29 27 33 31
19 32 34 37 33 2)chart creation
20 37 25 24 34 3)autofit data into column
19 33 43 39 44 4) chart into image
18 32 44 43 32 5)delete blank sheets
21 21 33 37 37
20 39 22 33 39 vba programming
21 44 34 37 39 1)text to speech converter
19 41 33 33 41 2)change the chart type
17 25 22 30 25 3)create table of content from different worksheet in the
12 30 27 28 31 4)save selected range as a pdf file
19 31 31 30 28 5)convert selected text to a proper case
20 31 32 25 33
20 32 31 31 32
21 33 33 26 22
18 35 23 35 36
20 36 38 28 29
17 30 29 41 35
21 30 29 37 30
21 33 30 41 35

mal points)
different worksheet in the same file