Download - Simulasi Kelulusan Un Smp
![Page 1: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/1.jpg)
CARA MENGGUNAKAN SIMULASI INITim Akademik SMA Muhammadiyah 1 Pati
1) Baca Bismillah2) Pilihlah sheet SIMULASI
tidak bisa diganti KARENA berisi rumus .5) Keterangan lebih lanjut dan atau butuh password membuka
6) Mohon koreksi jika ditemukan kesalahan "formula"
SIMULASI INI DIBUAT MENGGUNAKAN Ms Excel 2007
3) Isilah kolom-kolom yang berwarna PUTIH4) Kolom yang berwarna selain PUTIH sengaja diprotek
proteksi silahkan hub. 081326608910 (sms only)
![Page 2: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/2.jpg)
SIMULASI KELULUSAN UJIAN NASIONAL SMP/MTS UNANTARA NILAI RAPOT, NILAI US DAN NILAI UNby TIM AKADEMIK SMA MUHAMMADIYAH 1 PATI 2012
no NAMA SISWAB.Indonesia B.Inggris
NR US UN NRI II III IV V rata2 I
1 IPIN 7.30 7.00 8.00 7.30 7.80 7.48 6.50 6.89 8.00 7.56 7.302 UPIN 7.00 7.30 7.30 7.30 7.30 7.24 9.50 8.60 5.60 6.80 7.303 UNYIL 7.00 7.30 7.30 7.30 7.30 7.24 9.50 8.60 5.40 6.68 7.304 USROK 7.00 7.30 7.30 7.30 7.30 7.24 9.50 8.60 6.20 7.16 7.3056789
10111213141516171819202122232425262728293031323334353637
NS= (40% NR+60%US)
NA= (60% UN+40%NS)
![Page 3: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/3.jpg)
383940
JUMLAHKETERANGAN
![Page 4: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/4.jpg)
UN2012
B.Inggris MatematikaNR US UN NR USII III IV V rata2 I II III IV V rata2
7.00 6.00 7.30 7.80 7.08 9.50 8.53 6.20 7.13 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.457.00 6.00 7.30 7.80 7.08 9.50 8.53 5.80 6.89 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.457.00 6.00 7.30 7.80 7.08 9.50 8.53 5.40 6.65 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.457.00 6.00 7.30 7.80 7.08 9.50 8.53 5.40 6.65 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.45
NS= (40% NR+60%US)
NA= (60% UN+40%NS)
NS= (40% NR+60%US)
![Page 5: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/5.jpg)
JUMLAHKETERANGAN
![Page 6: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/6.jpg)
Matematika IPA KRETERIA KELULUSAN
UN NR US UN Rata-rataI II III IV V rata2
5.00 6.38 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.45 2.75 5.03 0 6.52.75 5.03 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.45 2.50 4.88 0 5.92.50 4.88 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.45 2.75 5.03 0 5.83.00 5.18 7.30 6.00 6.00 7.30 7.80 6.88 9.50 8.45 3.50 5.48 0 6.1
NA= (60% UN+40%NS)
NS= (40% NR+60%US)
NA= (60% UN+40%NS)
Jum Mapel < 4,00
![Page 7: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/7.jpg)
JUMLAHKETERANGAN
![Page 8: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/8.jpg)
KRETERIA KELULUSAN
Keterangan
LULUSLULUSLULUSLULUS
![Page 9: Simulasi Kelulusan Un Smp](https://reader035.vdokumen.com/reader035/viewer/2022071921/55cf9d4c550346d033ad05b2/html5/thumbnails/9.jpg)