Mayur Sandip Sawant (254110001)
Number 1 Number 2 Add
3 5 8
Mayur Sandip Sawant (254110001)
Number 1 Number 2 Add
3 5 8
2 4 6
1 8 9
9 10 19
15 20 35
Mayur Sandip Sawant (254110001)
Stationery Order For The Month of March 2%
Description Quantity Cost Per Item Total Cost V.A.T Cost+V.A.T
Note Pad 202 2.85 575.7 11.514 587.214
Highlighter Pen 280 2.95 826 16.52 842.52
Ball Point Pen Blue (pkt) 520 2.5 1300 26 1326
Ball Point Pen Red (pkt) 340 2.5 850 17 867
Ball Point Pen Green (pkt) 250 2.5 625 12.5 637.5
Exercise Book 1B 35 4.95 173.25 3.465 176.715
Cello - tape 75 2.95 221.25 4.425 225.675
Manila Folders 100 2.95 295 5.9 300.9
A4 Refil Pad 90 5.95 535.5 10.71 546.21
Writing Pad 86 3.95 339.7 6.794 346.494
Pencil Sharpeners 110 0.95 104.5 2.09 106.59
Crayons (pkt) 80 3.85 308 6.16 314.16
Pencils 603 0.5 301.5 6.03 307.53
Colour Pencils (pkt) 50 2.95 147.5 2.95 150.45
Felt Pens (pkt) 40 3.95 158 3.16 161.16
Staples (pkt) 75 3.5 262.5 5.25 267.75
Stapler 30 9.95 298.5 5.97 304.47
Hole Punch 25 14.95 373.75 7.475 381.225
Ring Binder 45 10.95 492.75 9.855 502.605
Total Cost 8352.168
Mayur Sandip Sawant (254110001)
Student No. Student Name Maths Physics Chemistry Sum Average
1 John 85 75 60 220 73.3333333
2 Xavier 100 78 85 263 87.6666667
3 Milton 88 72 75 235 78.3333333
4 Clara 90 95 80 265 88.3333333
5 Linda 95 82 99 276 92
Mayur Sandip Sawant (254110001)
Student No. Student Name Maths Physics Chemistry Sum Average
1 John 85 75 60 220 73.33333333
2 Xavier 100 78 85 263 87.66666667
3 Milton 88 72 75 235 78.33333333
4 Clara 90 95 80 265 88.33333333
5 Linda 95 82 99 276 92
Maximum 100 95 99
Minimum 85 72 60
Mean 91.6 80.4 79.8
Standard deviation 5.9413803 8.9610267 14.237275
Variance 35.3 80.3 202.7
Mayur Sandip Sawant (254110001)
Name Gender Attendance Assigment Mid-term Final Total Description
Virak M 9 12 14 45 71 pass
Soa M 13 11 12 34 57 pass
Vibol M 8 8 12 21 41 fail
Theary F 14 14 14 25 53 pass
Sokha M 4 4 10 20 34 fail
Mayur Sandip Sawant (254110001)
Name Gender Attendance Assigment Mid-term Final Total Description
Virak M 9 12 14 45 71 pass
Soa M 13 11 12 34 57 pass
Vibol M 8 8 12 21 41 fail
Theary F 8 14 14 25 53 fail
Sokha M 4 4 10 20 34 fail
Mayur Sandip Sawant (254110001)
Name Gender Attendance Assignment Mid-term Final Total Description Grade
Virak M 9 12 14 45 71 pass C
Soa M 13 11 12 34 57 pass E
Vibol M 8 8 12 21 41 fail F
Theary F 14 14 14 25 53 pass E
Sokha M 4 4 10 20 34 fail F
Added1 M 10 15 15 50 80 pass B
Added2 F 12 20 20 50 90 pass A
Added3 F 13 15 15 35 65 pass D
Mayur Sandip Sawant (254110001)
Name Age Middle age Senior Citizen
John 25 FALSE FALSE
Will 17 FALSE FALSE
Kins 45 FALSE FALSE
Mark 18 FALSE FALSE
Mac 85 FALSE TRUE Category Counts
Uno 100 FALSE TRUE minor 3
Fiene 23 FALSE FALSE major 5
Jane 54 FALSE FALSE middle age 2
Nero 42 FALSE FALSE above middle age 7
Ander 34 TRUE FALSE Senior Citizen 3
Dana 15 FALSE FALSE Total 20
Mike 55 FALSE FALSE
Tina 23 FALSE FALSE
Kate 32 TRUE FALSE
George 55 FALSE FALSE
Watson 22 FALSE FALSE
Clara 66 FALSE TRUE
Kile 16 FALSE FALSE
Venna 51 FALSE FALSE
Kyle 54 FALSE FALSE
Mayur Sandip Sawant (254110001)
Product Supplier Quantity
Cherries John 200 Product Qty
Bananas Mike 350 Apples 410
Apples Pete 180 Bananas 600
Oranges Mike 400 Cherries 530
Bananas John 250 Oranges 400
Apples Mike 120
Cherries John 330
Apples Pete 110
Total (just
to verify)
1940 1940