soal latihan ( ms excel)

1
1. MAT IPA IPS 1 Anna 90 85 80 2 Benedicta 60 75 90 3 Cristina 70 65 80 4 Dona Harun 80 90 80 5 Elfrida 75 78 70 6 Fransiskus 95 90 85 7 Gani 80 80 85 8 Hardiman 65 70 80 9 Imron 70 80 70 10 Jesica 80 85 75 2. NO NAMA AGM B.IND MAT IPA IPS 1 Ari yuda 75 80 90 65 80 2 Budiman 80 80 84 75 85 3 Caprio 75 85 75 70 75 4 Dona 70 75 85 80 70 5 Ericson 65 75 80 80 85 6 Fatonah 85 80 80 85 75 7 Gustiar 70 80 85 75 80 8 Ivana 85 95 90 95 90 9 Jonatan 75 65 85 70 85 10 Kasmiran 80 70 80 80 80 11 Lusia 75 75 65 80 80 12 Mustar 80 80 70 75 65 13 Novi 80 80 60 80 80 14 Poniman 70 80 90 95 95 15 Ruben 80 70 65 65 70 jumlah 1145 1170 1184 1170 1195 rata rata 76,33333333 78 78,93333333 78 79,66666667 nilai maximum 85 95 90 95 95 nilai minimum 65 65 60 65 65 3. NO NAMA B.IND MAT IPA IPS 1 Budiman 70 70 65 70 2 Chayono 65 65 75 75 3 Fesilitas 90 85 90 95 4 Guritno 70 69 85 78 5 Martua 80 80 65 80 6 Rusdi 85 65 75 75 7 Sutrisno 90 70 85 88 8 Zakia 65 75 80 85 NAMA NO NILAI NILAI 0% 20% 40% 60% 80% 100% Budiman Chayono Fesilitas Guritno Martua Rusdi Sutrisno Zakia 1 2 3 4 5 6 7 8 NILAI B.IND NILAI MAT NILAI IPA NILAI IPS

Upload: leo-mahesa

Post on 21-Mar-2017

45 views

Category:

Education


10 download

TRANSCRIPT

Page 1: Soal latihan ( ms excel)

1.

MAT IPA IPS

1 Anna 90 85 80

2 Benedicta 60 75 90

3 Cristina 70 65 80

4 Dona Harun 80 90 80

5 Elfrida 75 78 70

6 Fransiskus 95 90 85

7 Gani 80 80 85

8 Hardiman 65 70 80

9 Imron 70 80 70

10 Jesica 80 85 75

2. NO NAMA AGM B.IND MAT IPA IPS

1 Ari yuda 75 80 90 65 80

2 Budiman 80 80 84 75 85

3 Caprio 75 85 75 70 75

4 Dona 70 75 85 80 70

5 Ericson 65 75 80 80 85

6 Fatonah 85 80 80 85 75

7 Gustiar 70 80 85 75 80

8 Ivana 85 95 90 95 90

9 Jonatan 75 65 85 70 85

10 Kasmiran 80 70 80 80 80

11 Lusia 75 75 65 80 80

12 Mustar 80 80 70 75 65

13 Novi 80 80 60 80 80

14 Poniman 70 80 90 95 95

15 Ruben 80 70 65 65 70

jumlah 1145 1170 1184 1170 1195

rata rata 76,33333333 78 78,93333333 78 79,66666667

nilai maximum 85 95 90 95 95

nilai minimum 65 65 60 65 65

3. NO NAMA

B.IND MAT IPA IPS

1 Budiman 70 70 65 70

2 Chayono 65 65 75 75

3 Fesilitas 90 85 90 95

4 Guritno 70 69 85 78

5 Martua 80 80 65 80

6 Rusdi 85 65 75 75

7 Sutrisno 90 70 85 88

8 Zakia 65 75 80 85

NAMANO NILAI

NILAI

0% 20% 40% 60% 80% 100%

Budiman

Chayono

Fesilitas

Guritno

Martua

Rusdi

Sutrisno

Zakia

12

34

56

78

NILAI B.IND

NILAI MAT

NILAI IPA

NILAI IPS