{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sayfa1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sayfa1","index":0,"n_rows":78,"n_cols":33,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,0,79,29],[0,0,0,29],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,29,7,29],[1,17,1,27],[2,17,2,27],[3,17,3,27],[1,3,1,10],[2,3,2,10],[1,11,1,16],[2,11,2,16],[3,11,3,16],[3,3,3,10],[5,0,5,2],[6,28,7,28],[72,0,74,29],[67,0,69,29],[53,0,55,29],[6,0,7,0],[6,1,7,1],[6,2,7,2],[56,21,56,28],[58,21,58,28],[59,21,59,28],[62,0,64,29],[58,1,58,2],[59,1,59,2],[57,24,57,28],[52,0,52,29],[38,0,38,2]]}
["BOLU FEN  LİSESİ SINAV ANALİZ FORMU"]
["DERS YILI",null,null,"SINIFI",null,null,null,null,null,null,null,null,null,null,null,null,null,"SINAVA KATILAN ÖĞRENCİ SAYISI",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L3=0,\"\",SUM(AC3,AC4))","v":""}]
["DÖNEMİ",null,null,"SINIF MEVCUDU",null,null,null,null,null,null,null,null,null,null,null,null,null,"BAŞARILI ÖĞRENCİ SAYISI",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L3=0,\"\",COUNTIF(AD9:AD38,\"BAŞARILI\"))","v":""},{"$f":"IF(OR(AC2=\"\",AC3=\"\",AC2=0),\"\",ROUND(AC3/AC2,2))","v":""}]
["DERSİN ADI",null,null,"YAZILI NO",null,null,null,null,null,null,null,null,null,null,null,null,null,"BAŞARISIZ ÖĞRENCİ SAYISI",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L3=0,\"\",COUNTIF(AD9:AD38,\"BAŞARISIZ\"))","v":""},{"$f":"IF(OR(AC2=\"\",AC4=\"\",AC2=0),\"\",ROUND(AC4/AC2,2))","v":""}]
[]
["KAZANIM  AÇIKLAMALARI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOPLAM","BAŞARI DURUMU"]
["SIRA","NO","ADI SOYADI","S1","S2","S3","S4","S5","S6","S7","S8","S9","S10","S11","S12","S13","S14","S15","S16","S17","S18","S19","S20","S21","S22","S23","S24","S25",{"$f":"SUM(D8:AB8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D8:AB8)","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B9=\"\",\"\",IF(COUNTA(D9:AB9)=0,\"G\",SUM(D9:AB9)))","v":""},{"$f":"IF(AC9=\"\",\"\",IF(AC9=\"G\",\"GİRMEDİ\",IF(AC9<50,\"BAŞARISIZ\",\"BAŞARILI\")))","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B10=\"\",\"\",IF(COUNTA(D10:AB10)=0,\"G\",SUM(D10:AB10)))","v":""},{"$f":"IF(AC10=\"\",\"\",IF(AC10=\"G\",\"GİRMEDİ\",IF(AC10<50,\"BAŞARISIZ\",\"BAŞARILI\")))","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Sorulara Göre Başarı Oranları",null,null,{"$f":"IF(OR($L$3=\"\",D8=\"\"),\"\",IF(COUNT(D9:D38)>0,ROUND(AVERAGE(D9:D38)/D8,2),\"\"))","v":""},{"$f":"IF(OR($L$3=\"\",E8=\"\"),\"\",IF(COUNT(E9:E38)>0,ROUND(AVERAGE(E9:E38)/E8,2),\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","",null,null,{"$f":"AE8-COUNTIF($D$39:$AB$39,\">=0,5\")","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Başarılı","Başarısız"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC3","v":""},{"$f":"AC4","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DEĞERLENDİRME VE ALINACAK TEDBİRLER"]
[{"$f":"IF(OR($C$2=\"\",$C$3=\"\",$C$4=\"\",$L$2=\"\",$AD$3=\"\"),\"Eksik bilgi girişi var ya da henüz bir puan girişi yapılmamış.\",IF($L$4=\"\",A78,IF($AE$39=0,A63,IF($AE$39=1,A68,IF($AE$39>1,A73,\"\")))))","v":"Eksik bilgi girişi var ya da henüz bir puan girişi yapılmamış."}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"UYGUNDUR …../…../\"&YEAR(TODAY())","v":"UYGUNDUR …../…../2022"}]
[]
[null,"AD SOYAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD SOYAD"]
[null,"……………………………………….. Öğretmeni",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Okul Müdürü"]
[]
["BAŞARI ORANI %50 NİN ALTINDA OLAN HİÇ SORU YOK İSE"]
[{"$f":"IF($AD$3=\"\",\"\",\"Yapılan sınav analizine göre \"&$L$2&\" Sınıfı \"&PROPER($C$4)&\" Dersi \"&$C$3&\". Dönem \"&$L$4&\". Yazılı Sınavına katılan toplam \"&$L$3&\" öğrenciden \"&$AC$3&\" öğrenci başarılı olmuştur. Buna göre, sınavın başarı oranı %\"&ROUND($AD$3*100,0)&\" olarak gerçekleşmiştir. Sütun grafiğinde başarı oranı %50'nin altında olan \"&\"soru bulunmayıp konular yeterince anlaşılmıştır.\")","v":""}]
[]
[]
[]
["BAŞARI ORANI %50 NİN ALTINDA OLAN 1 SORU VAR İSE"]
[{"$f":"IF($AD$3=\"\",\"\",\"Yapılan sınav analizine göre \"&$L$2&\" Sınıfı \"&PROPER($C$4)&\" Dersi \"&$C$3&\". Dönem \"&$L$4&\". Yazılı Sınavına katılan toplam \"&$L$3&\" öğrenciden \"&$AC$3&\" öğrenci başarılı olmuştur. Buna göre, sınavın başarı oranı %\"&ROUND($AD$3*100,0)&\" olarak gerçekleşmiştir. Sütun grafiğinde başarı oranı %50'nin altında olan \"&\"1 adet soru bulunup bu soru sınıf ortamında çözülecek, yeri geldikçe sınıfa bu soru tipiyle ilgili açık uçlu sorular yöneltilerek konunun daha iyi anlaşılması sağlanacaktır.\")","v":""}]
[]
[]
[]
["BAŞARI ORANI %50 NİN ALTINDA OLAN ÇOK SORU VAR İSE"]
[{"$f":"IF($AD$3=\"\",\"\",\"Yapılan sınav analizine göre \"&$L$2&\" Sınıfı \"&PROPER($C$4)&\" Dersi \"&$C$3&\". Dönem \"&$L$4&\". Yazılı Sınavına katılan toplam \"&$L$3&\" öğrenciden \"&$AC$3&\" öğrenci başarılı olmuştur. Buna göre, sınavın başarı oranı %\"&ROUND($AD$3*100,0)&\" olarak gerçekleşmiştir. Sütun grafiğinde başarı oranı %50'nin altında olan \"&$AE$39&\" adet soru bulunup bu sorular sınıf ortamında çözülecek, yeri geldikçe sınıfa bu soru tipleriyle ilgili açık uçlu sorular yöneltilerek konunun daha iyi anlaşılması sağlanacaktır.\")","v":""}]
[]
[]
[]
["ORTAK SINAV İSE"]
[{"$f":"IF($AD$3=\"\",\"\",\"Yapılan sınav analizine göre \"&$L$2&\" Sınıfı \"&PROPER($C$4)&\" Dersi \"&$C$3&\". Dönem \"&$L$4&\". Yazılı Sınavına katılan toplam \"&$L$3&\" öğrenciden \"&$AC$3&\" öğrenci başarılı olmuştur. Buna göre, sınavın başarı oranı %\"&ROUND($AD$3*100,0)&\" olarak gerçekleşmiştir.\")","v":""}]