DAFTAR NAMA ANAK 8GDAFTAR NAMA ANAK VIII GSMP NEGERI 2 PATINONAMAL/PSD/MI1ADELIA AYU APRISTIANAPSDN PATI KIDUL 022ADITYA PRATAMA PRADANA ISKANDARLSDN SEMIREJO O23ADNA OKTAVIAPSDN PATI KIDUL 014AFIFA NURUL AINIPSDN PATI KIDUL 065ARUM SUSILOWATIPSDN PURI 026BAGAS PANUNTUN RAMADHANLSDIT YAUMMI FATIMAH7BERLINDA HANIK PUSPITASARIPSDN KEBOLAMPANG8DEVI KARTIKA ROHMAHPSDN PURI 029DINI INDAH FAUZIAHPSDN PATI KIDUL 0110DWI PUTRI PUSPA SARIPSDN MARGOREJO 0211HANI FATUZZAROHPSDN SEMIREJO O212INDAH RAHMADANY IBRAHIMPSDN TLOGOWUNGU 0313IRMA AMANDAPSDN KARABAN 0114ISNA RAHMANINGTYASPSDN SEMIREJO O215ISNIATI MAHMUDAHPMI ALHIDAYAH16KUKUH PRASETYOLSDN GEMBONG 0117NAILAL MUNA AVIP18PUNGKI ASMARANING RUMTADIPSDN PATI KIDUL 0219PUTRI ROSALIA INDAHPSDN PATI KIDUL 0120RESTUTIA PUSPITAHATIPSDN PATI KIDUL 0121RIZKY FADILLA LAKSMI ADANIPSDN PATI KIDUL O622TAHNIA WIDIANINGRUMPSDN PATI KIDUL 0123TEGAR SUKMA AJILSDN PATI KIDUL 0624PANDU WINEKASL

&C&A&CPage &P

LKS HAL 27IndukNamaNilai Ujian SekolahIPAAgamaPpknIPSJawaElekKompJLM9063Ida Susanti9.428.719.858.579.288.999.1463.969074Irwan Susetio Romadhon7.498.138.998.717.417.138.1355.999091Lusia Estine Martin9.148.579.429.289.569.288.5663.819197Laras Retno Salindri8.497.278.999.148.417.278.1357.709085Lela Arumsari Purbaningsih8.497.29.149.438.277.418.1358.079084Lasmono8.498.569.858.858.998.998.5662.299088Lia Riana8.998.499.428.578.78.278.4260.869107Muchammad Rizal Setyo Nugroho8.138.138.428.857.987.78.4257.639100Mialita Rudy Hartanti8.997.999.149.438.277.568.1359.519105Muchammad Syaiful Bachri8.137.498.278.857.137.278.1355.279119Nita Fitri Indriyani9.148.569.719.289.429.148.5663.819160Syofiyati9.428.649.858.999.77.418.5662.579159Susanti Alfriani Maltimu9.429.719.859.289.428.569.1465.38RATA-RATA8.74923076928.26538461549.39.01769230778.65692307698.07538461548.4623076923NILAI TERTINGGI9.429.719.859.439.79.289.14NLAI TERENDAH7.497.28.278.577.137.138.13IndukNamaNilai Ujian SekolahIPAAgamaPpknIPSJawaElekKompJLMRUMUS IF9063Ida Susanti9.428.719.858.579.288.999.1463.9609074Irwan Susetio Romadhon7.498.138.998.717.417.138.1355.9909091Lusia Estine Martin9.148.579.429.289.569.288.5663.8109197Laras Retno Salindri8.497.278.999.148.417.278.1357.7009085Lela Arumsari Purbaningsih8.497.209.149.438.277.418.1358.0709084Lasmono8.498.569.858.858.998.998.5662.2909088Lia Riana8.998.499.428.578.708.278.4260.8609107Muchammad Rizal Setyo Nugroho8.138.138.428.857.987.708.4257.6309100Mialita Rudy Hartanti8.997.999.149.438.277.568.1359.5109105Muchammad Syaiful Bachri8.137.498.278.857.137.278.1355.2709119Nita Fitri Indriyani9.148.569.719.289.429.148.5663.8109160Syofiyati9.428.649.858.999.707.418.5662.5709159Susanti Alfriani Maltimu9.429.719.859.289.428.569.1465.380RATA-RATA8.74923076928.26538461549.39.01769230778.65692307698.07538461548.4623076923NILAI TERTINGGI9.429.719.859.439.79.289.14NLAI TERENDAH7.497.28.278.577.137.138.13

&C&A&CPage &P

KUNCI JAWABANEVALUASI BAB 1EVALUASI BAB 3EVALUASI BAB 51D1A1A2A2C2B3D3B3A4C4B4A5B5A5B6A6B6C7B7C7D8A8D8C9A9C9C10A10D10CEVALUASI BAB 2EVALUASI BAB 4EVALUASI BAB 61C1C1A2B2A2D3C3A3B4B4A4C5B5D5B6D6D6C7C7C7C8A8C8A9B9C9C10B10B10CEVALUASI SEMESTER 11A2B3C4D5A6A7A8B9B10A11A12D13C14A15A16A17D18B19B20D

&C&A&CPage &P

KLINIK PERSALINANKLINIK PERSALINAN "SELEBRITI"Nama PasienKelasPenangananTanggalLama InapBiayaTotal BayarMasukKeluarInapLayananPersalinanAABidan01/11/200804/11/20083Rp900,000.00Rp300,000.00Rp750,000.00Rp1,950,000.00BBBidan01/11/200804/11/20083Rp600,000.00Rp210,000.00Rp750,000.00Rp1,560,000.00CCDokter01/11/200804/11/20083Rp300,000.00Rp150,000.00Rp1,000,000.00Rp1,450,000.00DCDokter03/11/200808/11/20085Rp500,000.00Rp250,000.00Rp1,000,000.00Rp1,750,000.00EBBidan05/11/200809/11/20084Rp800,000.00Rp280,000.00Rp750,000.00Rp1,830,000.00FABidan06/11/200808/11/20082Rp600,000.00Rp200,000.00Rp750,000.00Rp1,550,000.00Total Bayar=Rp10,090,000.00BiayaTotal Bayar Tertinggi=Rp1,950,000.00KelasBiaya PerhariTotal Bayar Terendah=Rp1,450,000.00InapLayananJumlah Kelas A=Rp3,500,000.00ARp300,000.00Rp100,000.00Jumlah Kelas B=Rp3,390,000.00BRp200,000.00Rp70,000.00Jumlah Kelas C=Rp3,200,000.00CRp100,000.00Rp50,000.00Petunjuk PengerjaanRumusBiaya inap=Berdasarkan kelas(Lihat tabel biaya, Kolom inap)*Lama inapBiaya Layanan=Berdasarkan kelas(Lihat tabel Biaya, Kolom Layanan)*Lama inapB. Persalinan=Jika Penanganan = Dokter, maka 1.000.000Jika Penanganan = Bidan, maka 750.000

&C&A&CPage &P

Sheet2NOURAIANNERACA AWALNERACA PERUBAHANDKDK1KASRp245,744.00-Rp678,513,500.00Rp678,513,500.002SIMPANAN POKOK-Rp550,000.00Rp25,000.00Rp25,000.003SIMPANAN WAJIB-Rp92,413,500.00Rp5,378,500.00Rp20,175,000.004SIMPANAN SUKARELA-Rp81,094,500.00Rp4,530,000.00Rp18,830,000.005SIMPANAN THR-Rp13,080,000.00Rp13,460,000.00Rp17,360,000.006RESIKO KREDIT-Rp15,117,850.00Rp810,000.00Rp5,756,500.007SIMPANAN DI BANKRp500,000.00-Rp19,900,000.00Rp19,900,000.008UTANG JAMSOSTEK-Rp19,166,671.00Rp10,000,200.00-9BUNGA UTANG JAMSOSTEK--Rp1,281,000.0010SIMPANAN DAN KOPRI---Rp7,000,000.0011PIUTANG UANGRp384,879,000.00-Rp575,650,000.00Rp488,822,000.0012PIUTANG BARANGHRp376,700.00--Rp376,700.0013JASA UANG SIMP. PINJAMAN---Rp99,939,500.0014JASA BARANG---Rp28,800.0015ONGKOS--Rp12,855,000.00-16DANA CADANGAN-Rp113,195,329.00--17DANA ANGGOTA BERJASA-Rp11,993,199.00Rp11,993,199.00-18DANA ANGGOTA PENYIMPAN-Rp11,993,199.00Rp11,993,199.00-19DANA PENGURUS-Rp2,998,300.00Rp2,998,300.00-20DANA KARYAWAN-Rp5,427,839.00Rp1,499,150.00-21DANA PENDIDIKAN-Rp6,671,826.00--22DANA SOSIAL-Rp4,450,619.00Rp3,150,000.00-23DANA PEMBANGUNAN-Rp7,748,612.00Rp2,500,000.00-24SHU TAHUN 2007----JUMLAHRp386,001,444.00Rp386,001,444.00Rp1,356,537,048.00Rp1,356,417,048.00

&C&A&CPage &P

Sheet12DATA PENJUALAN BARANGTanggalKode BarangCabang (IF)Jumlah TerjualHarga BarangUang yang DiterimaUang yang Diterima01/01/20111020Rp0.00Rp1,000,000.0002/01/20112025Rp0.00Rp625,000.0003/01/20113012Rp0.00Rp180,000.0004/01/20114025Rp0.00Rp250,000.0005/01/20111020Rp0.00Rp1,000,000.0006/01/20112023Rp0.00Rp575,000.0007/01/20113020Rp0.00Rp300,000.0008/01/20114023Rp0.00Rp230,000.0009/01/20111025Rp0.00Rp1,250,000.0010/01/20112020Rp0.00Rp500,000.0011/01/20113025Rp0.00Rp375,000.0012/01/20114021Rp0.00Rp210,000.0013/01/20111020Rp0.00Rp1,000,000.0014/01/20112024Rp0.00Rp600,000.0015/01/20113023Rp0.00Rp345,000.0016/01/20114025Rp0.00Rp250,000.00

&C&A&CPage &P

JENIS ANGKUTANDAFTAR JENIS ANGKUTANNONO.POLISIDAERAHJENISANGKUTAN1B 1473 LH0002AB 5002 MU0003D 2514 HS0004B 6517 AX0005F 5123 MU000

&C&A&CPage &P

Sheet16FUNGSI TEKSTeksFungsi teksHasilKegunaanBadminton=LEN("Badminton")menjumlah karakterBadminton=LOWER("Badminton")badmintonmengubah huruf besar mejadi huruf kecilBadminton=UPPER("Badminyon")BADMINTONmengubah huruf kecil menjadi huruf besarBadminton=LEFT("Badminton";4)Badmmengambil huruf sejumlah n karakter dari kiriBadminton=RIGHT("Badminton";5)intonmengambil huruf sejumlah n karakter dari kananBadminton=MID("Badminton";2;2)admengambil huruf dari posisi tertentu

&C&A&CPage &P

Sheet15TOKO MAJU TERUSLAPORAN HASIL PENJUALAN BARANG2 FEBRUARI 2011NONAMA PEMBELIKODENAMA BARANGHARGA SATUANVOLUMEJUMLAH HARGADISKONJUMLAH DIBAYAR1AAP005Rp6,000,000.0020%2BMM007Rp6,300,000.0020%3CAP003Rp3,600,000.000%4DAP004Rp4,800,000.000%5EMR004Rp5,600,000.0020%6FMB003Rp2,100,000.000%7GRB003Rp1,950,000.000%8HMM006Rp5,400,000.0020%9IAP007Rp8,400,000.0020%10JMM005Rp4,500,000.000%11KAP006Rp7,200,000.0020%12LMB009Rp6,300,000.0020%TOTAL PENJUALANKODENAMA BARANGHARGA SATUANAPALMARI PAKAIANRp1,200,000.00CATATANMBMEJA BELAJARRp700,000.00NILAI PENJUALAN = Rp.5 juta