14030654013_excel 1.xlsx

5
NI'MATUR ROHMAH/14030654013 Sumber : Guru SMPN 1 Trenggalek SMP NEGERI 1 TRENGGALEK DAFTAR NILAI ULANGAN SEMESTER GANJIL TAHUN 2013/2014 KELAS IX -E No Urut No Induk Nama L/P MATAPERLAJARAN Agama PKn Bhs. Indonesia Bhs. Inggris Matematika IPA IPS Seni Budaya TIK PLH Bhs. Jawa Ket. Jasa Jumlah 1 0121 AMMARA IZAHUDIN ASHAR P 98.00 90.00 66.00 86.00 86.67 70.00 80.00 76.00 64.00 84.00 72.00 92.00 964.67 2 0122 ANANDA WARIH MEYLINDA P 96.00 88.00 58.00 80.00 83.33 62.50 80.00 82.00 68.00 76.00 70.00 86.00 929.83 3 0123 ARI PURNOMO AJI L 98.00 86.00 70.00 94.00 93.33 67.50 84.00 90.00 82.00 86.00 68.00 90.00 1008.83 4 0124 AUDY RAHMAT DIAN KARTIKA P 98.00 86.00 68.00 94.00 96.67 72.50 84.00 90.00 80.00 86.00 68.00 94.00 1017.17 5 0125 BANGUN BARGUNA ALAM L 96.00 88.00 68.00 86.00 96.67 70.00 90.00 90.00 70.00 82.00 66.00 94.00 996.67 6 0126 BRAFIAN RAMADHAN PUTRA L 98.00 90.00 76.00 82.00 100 75.00 84.00 82.00 82.00 88.00 78.00 94.00 1029 7 0127 CHRISNANDA PUTRI K P 98.00 92.00 64.00 90.00 93.33 75.00 74.00 80.00 74.00 86.00 72.00 92.00 990.33 8 0128 CRISANDHA CARIAL F P 98.00 82.00 70.00 78.00 83.33 72.50 76.00 70.00 70.00 84.00 72.00 90.00 945.83 9 0129 DIMAS YOGA WASONO L 98.00 74.00 58.00 90.00 80.00 75.00 76.00 76.00 70.00 80.00 74.00 92.00 943 10 0130 DONA WAHYU DAININGSIH P 96.00 80.00 68.00 74.00 93.33 70.00 78.00 86.00 74.00 70.00 70.00 82.00 941.33 11 0131 ENGGARBELA OGI I P P 96.00 80.00 62.00 80.00 100.00 65.00 78.00 78.00 64.00 84.00 70.00 94.00 951 12 0132 IFTITAH RIZQI P 96.00 80.00 70.00 82.00 93.33 72.50 80.00 78.00 66.00 84.00 72.00 94.00 967.83 13 0133 ISTIQAMAH INTAN K P 96.00 80.00 66.00 80.00 100.00 77.50 80.00 78.00 66.00 84.00 70.00 96.00 973.5 14 0134 LARAS PURBANINGRUM P 96.00 80.00 70.00 72.00 83.33 62.50 80.00 78.00 72.00 84.00 70.00 92.00 939.83 15 0135 MUHAMMAD FAJAR K L 96.00 80.00 72.00 90.00 93.33 77.50 82.00 78.00 82.00 88.00 78.00 94.00 1010.83 16 0136 MOCHAMAD RODENA F R L 96.00 80.00 68.00 90.00 96.67 72.50 78.00 78.00 70.00 88.00 68.00 92.00 977.17 17 0137 MAULIDI ROBINGI M W L 96.00 80.00 60.00 82.00 90.00 67.50 82.00 78.00 76.00 88.00 66.00 90.00 955.5 18 0138 MUHAMMADALINGGAR P L 96.00 80.00 58.00 92.00 93.33 70.00 82.00 78.00 76.00 86.00 74.00 92.00 977.33 19 0139 NAFISA PRATIWI P 96.00 80.00 70.00 78.00 90.00 72.50 86.00 78.00 80.00 78.00 66.00 88.00 962.5 20 0140 NOVRANA AJI Q L 96.00 80.00 58.00 86.00 100.00 70.00 80.00 78.00 60.00 84.00 66.00 92.00 950 21 0141 RIA DWI AMBARWATI P 96.00 80.00 74.00 84.00 93.33 70.00 88.00 78.00 70.00 86.00 80.00 92.00 991.33 22 0142 RONA CAHYO ANGKOSO L 96.00 80.00 74.00 82.00 96.67 67.50 82.00 78.00 66.00 84.00 78.00 88.00 972.17 23 0143 SEVIOLA GANTENG A P 96.00 80.00 74.00 70.00 96.67 67.50 82.00 78.00 66.00 88.00 78.00 88.00 964.17 24 0144 SIZKA NOVITA DEWI P 96.00 80.00 60.00 78.00 76.67 60.00 84.00 78.00 70.00 84.00 62.00 76.00 904.67 25 0145 SUCI MULIAWATI P 96.00 80.00 64.00 80.00 93.33 72.50 86.00 78.00 66.00 78.00 64.00 88.00 945.83 26 0146 SURYA SINAR PERKASA L 96.00 80.00 74.00 84.00 93.33 60.00 80.00 78.00 70.00 84.00 54.00 90.00 943.33 27 0147 TIARA DANASTU PUTRI P 96.00 80.00 68.00 72.00 86.67 77.50 76.00 78.00 74.00 82.00 60.00 88.00 938.17 28 0148 ULFA RUSSYANA ALIM P 96.00 80.00 68.00 92.00 86.67 75.00 84.00 78.00 74.00 84.00 74.00 90.00 981.67 29 0149 WENING PANGESTHI MAHARANI P 96.00 80.00 76.00 82.00 93.33 62.50 86.00 78.00 74.00 86.00 80.00 80.00 973.83 30 0150 YUNI ANGGRAINI P 96.00 80.00 70.00 70.00 93.33 60.00 84.00 78.00 74.00 80.00 80.00 72.00 937.33 31 Nilai Rata-rata 96.47 81.87 67.40 82.67 91.89 69.67 81.53 79.40 71.67 83.53 70.67 89.40 966.16 32 Nilai Maksimum 98.00 92.00 76.00 94.00 100.00 77.50 90.00 90.00 82.00 88.00 80.00 96.00 1029.00 33 Nilai Minimum 96.00 74.00 58.00 70.00 76.67 60.00 74.00 70.00 60.00 70.00 54.00 72.00 904.67

Upload: nimaturrohmah

Post on 02-Dec-2015

26 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: 14030654013_EXCEL 1.xlsx

NI'MATUR ROHMAH/14030654013Sumber : Guru SMPN 1 Trenggalek

SMP NEGERI 1 TRENGGALEKDAFTAR NILAI ULANGAN SEMESTER GANJILTAHUN 2013/2014KELAS IX -E

No

Uru

t

No

Ind

uk

Nama L/P

MATAPERLAJARAN

Aga

ma

PK

n

Bh

s. I

nd

ones

ia

Bh

s. I

ngg

ris

Mat

emat

ika

IPA

IPS

Sen

i Bu

day

a

TIK

PL

H

Bh

s. J

awa

Ket

. Jas

a

Jum

lah

Rat

a-ra

ta

1 0121 AMMARA IZAHUDIN ASHAR P 98.00 90.00 66.00 86.00 86.67 70.00 80.00 76.00 64.00 84.00 72.00 92.00 964.67 80.392 0122 ANANDA WARIH MEYLINDA P 96.00 88.00 58.00 80.00 83.33 62.50 80.00 82.00 68.00 76.00 70.00 86.00 929.83 77.493 0123 ARI PURNOMO AJI L 98.00 86.00 70.00 94.00 93.33 67.50 84.00 90.00 82.00 86.00 68.00 90.00 1008.83 84.074 0124 AUDY RAHMAT DIAN KARTIKA P 98.00 86.00 68.00 94.00 96.67 72.50 84.00 90.00 80.00 86.00 68.00 94.00 1017.17 84.765 0125 BANGUN BARGUNA ALAM L 96.00 88.00 68.00 86.00 96.67 70.00 90.00 90.00 70.00 82.00 66.00 94.00 996.67 83.066 0126 BRAFIAN RAMADHAN PUTRA L 98.00 90.00 76.00 82.00 100 75.00 84.00 82.00 82.00 88.00 78.00 94.00 1029 85.757 0127 CHRISNANDA PUTRI K P 98.00 92.00 64.00 90.00 93.33 75.00 74.00 80.00 74.00 86.00 72.00 92.00 990.33 82.538 0128 CRISANDHA CARIAL F P 98.00 82.00 70.00 78.00 83.33 72.50 76.00 70.00 70.00 84.00 72.00 90.00 945.83 78.829 0129 DIMAS YOGA WASONO L 98.00 74.00 58.00 90.00 80.00 75.00 76.00 76.00 70.00 80.00 74.00 92.00 943 78.5810 0130 DONA WAHYU DAININGSIH P 96.00 80.00 68.00 74.00 93.33 70.00 78.00 86.00 74.00 70.00 70.00 82.00 941.33 78.4411 0131 ENGGARBELA OGI I P P 96.00 80.00 62.00 80.00 100.00 65.00 78.00 78.00 64.00 84.00 70.00 94.00 951 79.2512 0132 IFTITAH RIZQI P 96.00 80.00 70.00 82.00 93.33 72.50 80.00 78.00 66.00 84.00 72.00 94.00 967.83 80.6513 0133 ISTIQAMAH INTAN K P 96.00 80.00 66.00 80.00 100.00 77.50 80.00 78.00 66.00 84.00 70.00 96.00 973.5 81.1314 0134 LARAS PURBANINGRUM P 96.00 80.00 70.00 72.00 83.33 62.50 80.00 78.00 72.00 84.00 70.00 92.00 939.83 78.3215 0135 MUHAMMAD FAJAR K L 96.00 80.00 72.00 90.00 93.33 77.50 82.00 78.00 82.00 88.00 78.00 94.00 1010.83 84.2416 0136 MOCHAMAD RODENA F R L 96.00 80.00 68.00 90.00 96.67 72.50 78.00 78.00 70.00 88.00 68.00 92.00 977.17 81.4317 0137 MAULIDI ROBINGI M W L 96.00 80.00 60.00 82.00 90.00 67.50 82.00 78.00 76.00 88.00 66.00 90.00 955.5 79.6318 0138 MUHAMMADALINGGAR P L 96.00 80.00 58.00 92.00 93.33 70.00 82.00 78.00 76.00 86.00 74.00 92.00 977.33 81.4419 0139 NAFISA PRATIWI P 96.00 80.00 70.00 78.00 90.00 72.50 86.00 78.00 80.00 78.00 66.00 88.00 962.5 80.2120 0140 NOVRANA AJI Q L 96.00 80.00 58.00 86.00 100.00 70.00 80.00 78.00 60.00 84.00 66.00 92.00 950 79.1721 0141 RIA DWI AMBARWATI P 96.00 80.00 74.00 84.00 93.33 70.00 88.00 78.00 70.00 86.00 80.00 92.00 991.33 82.6122 0142 RONA CAHYO ANGKOSO L 96.00 80.00 74.00 82.00 96.67 67.50 82.00 78.00 66.00 84.00 78.00 88.00 972.17 81.0123 0143 SEVIOLA GANTENG A P 96.00 80.00 74.00 70.00 96.67 67.50 82.00 78.00 66.00 88.00 78.00 88.00 964.17 80.3524 0144 SIZKA NOVITA DEWI P 96.00 80.00 60.00 78.00 76.67 60.00 84.00 78.00 70.00 84.00 62.00 76.00 904.67 75.3925 0145 SUCI MULIAWATI P 96.00 80.00 64.00 80.00 93.33 72.50 86.00 78.00 66.00 78.00 64.00 88.00 945.83 78.8226 0146 SURYA SINAR PERKASA L 96.00 80.00 74.00 84.00 93.33 60.00 80.00 78.00 70.00 84.00 54.00 90.00 943.33 78.6127 0147 TIARA DANASTU PUTRI P 96.00 80.00 68.00 72.00 86.67 77.50 76.00 78.00 74.00 82.00 60.00 88.00 938.17 78.1828 0148 ULFA RUSSYANA ALIM P 96.00 80.00 68.00 92.00 86.67 75.00 84.00 78.00 74.00 84.00 74.00 90.00 981.67 81.8129 0149 WENING PANGESTHI MAHARANI P 96.00 80.00 76.00 82.00 93.33 62.50 86.00 78.00 74.00 86.00 80.00 80.00 973.83 81.1530 0150 YUNI ANGGRAINI P 96.00 80.00 70.00 70.00 93.33 60.00 84.00 78.00 74.00 80.00 80.00 72.00 937.33 78.1131 Nilai Rata-rata 96.47 81.87 67.40 82.67 91.89 69.67 81.53 79.40 71.67 83.53 70.67 89.40 966.16 80.5132 Nilai Maksimum 98.00 92.00 76.00 94.00 100.00 77.50 90.00 90.00 82.00 88.00 80.00 96.00 1029.00 85.7533 Nilai Minimum 96.00 74.00 58.00 70.00 76.67 60.00 74.00 70.00 60.00 70.00 54.00 72.00 904.67 75.39

Page 2: 14030654013_EXCEL 1.xlsx

NI'MATUR ROHMAH/14030654013Sumber : Guru SMPN 1 Trenggalek

NO NAMA MATAPELAJARAN RERATA MAKS MIN1 Agama 96.47 98.00 96.002 PKn 81.87 92.00 74.003 Bhs. Indonesia 67.40 76.00 58.004 Bhs. Inggris 82.67 94.00 70.005 Matematika 91.89 100.00 76.676 IPA 69.67 77.50 60.007 IPS 81.53 90.00 74.008 Seni Budaya 79.40 90.00 70.009 TIK 71.67 82.00 60.00

10 PLH 83.53 88.00 70.0011 Bhs. Jawa 70.67 80.00 54.0012 Ket. Jasa 89.40 96.00 72.00

Agam

aPKn

Bhs. In

dones

ia

Bhs. In

ggris

Mat

emat

ika

IPA

IPS

Seni B

udaya

TIKPLH

Bhs. Ja

wa

Ket. Ja

sa0.00

20.00

40.00

60.00

80.00

100.00

120.00

96.47

81.87

67.40

82.6791.89

69.67

81.53 79.4071.67

83.53

70.67

89.40

GRAFIK RERATA NILAI MATAPELAJARAN

RERATA

NAMA MATAPELAJARAN

Agama

PKn

Bhs. In

donesia

Bhs. In

ggris

Mate

mati

kaIP

A IPS

Seni B

udaya

TIKPLH

Bhs. Ja

wa

Ket. Ja

sa0.00

20.00

40.00

60.00

80.00

100.00

120.00

98.0092.00

76.00

94.00100.00

77.50

90.00 90.0082.00

88.0080.00

96.00

GRAFIK MAKSIMUM NILAI MATAPELAJARAN

MAKS

NAMA MATAPELAJARAN

Agam

aPKn

Bhs. In

dones

ia

Bhs. In

ggris

Mat

emat

ika

IPA

IPS

Seni B

udaya

TIKPLH

Bhs. Ja

wa

Ket. Ja

sa0.00

10.00

20.00

30.00

40.00

50.00

60.00

70.00

80.00

90.00

100.0096.00

74.00

58.00

70.0076.67

60.00

74.0070.00

60.00

70.00

54.00

72.00

GRAFIK NILAI MINIMUM MATAPELAJARAN

MIN

Page 3: 14030654013_EXCEL 1.xlsx

NI'MATUR ROHMAH/14030654013Sumber : Guru SMPN 1 Trenggalek

N

Agam

aPKn

Bhs. In

dones

ia

Bhs. In

ggris

Mat

emat

ika

IPA

IPS

Seni B

udaya

TIKPLH

Bhs. Ja

wa

Ket. Ja

sa0.00

10.00

20.00

30.00

40.00

50.00

60.00

70.00

80.00

90.00

100.0096.00

74.00

58.00

70.0076.67

60.00

74.0070.00

60.00

70.00

54.00

72.00

GRAFIK NILAI MINIMUM MATAPELAJARAN

MIN