{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Puantaj"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Puantaj","index":0,"n_rows":33,"n_cols":48,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,44],[30,20,30,24],[23,1,24,5],[21,1,21,4],[23,20,24,24],[2,1,2,13],[3,1,3,13],[9,46,9,53],[32,31,32,36],[32,37,32,41],[4,47,4,52],[1,1,1,44],[16,46,16,53],[5,46,5,53],[6,46,6,53],[7,46,7,53],[8,46,8,53]]}
[null,"2023-2024 Eğitim Öğretim Yılı"]
[null,"Büro Yönetimi Alanı Web Uygulamaları I. Dönem I. Uygulama Sınavı Değerlendirme ve Analiz Tablosu"]
[]
[]
["Soru No","Ünite ve Konular/Soru","Sınav Puanı","Doğru Cevapların Ortalaması","Doğru Cevapların Yüzdesi %","Öğrenci-1","Öğrenci-2","Öğrenci-3","Öğrenci-4","Öğrenci-5","Öğrenci-6","Öğrenci-7","Öğrenci-8","Öğrenci-9","Öğrenci-10","Öğrenci-11","Öğrenci-12","Öğrenci-13","Öğrenci-14","Öğrenci-15","Öğrenci-16","Öğrenci-17","Öğrenci-18","Öğrenci-19","Öğrenci-20","Öğrenci-21","Öğrenci-22","Öğrenci-23","Öğrenci-24","Öğrenci-25","Öğrenci-26","Öğrenci-27","Öğrenci-28","Öğrenci-29","Öğrenci-30","Öğrenci-31","Öğrenci-32","Öğrenci-33","Öğrenci-34","Öğrenci-35","Öğrenci-36","Öğrenci-37","Öğrenci-38","Öğrenci-39","Öğrenci-40",null,null,"Kırmızı yazı ile yazılan alanları değiştirip, öğrenci notlarını girebilirsiniz."]
["Soru1","Domain Nedir?",10,{"$f":"AVERAGE($F6:$AS6)","v":10},{"$f":"IF(C6=\"\",\"\",D6*100/C6)","v":100},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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sınav tarihi ve başlığı değiştiriniz."]
["Soru2","Kod yapısını yazınız.",10,8,{"$f":"IF(C7=\"\",\"\",D7*100/C7)","v":80},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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sorularınızı yazınız."]
["Soru3","IP yazımında dikkat edilecek hususları yazınız.",10,6,60,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soru puanlarınızını yazınız."]
["Soru4",null,10,{"$error":"#DIV/0!"},{"$error":"#DIV/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,null,null,null,null,null,null,null,null,null,null,"Öğrenci adı ve aldığı puanları yazınız."]
["Soru5",null,10,{"$error":"#DIV/0!"},{"$error":"#DIV/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,null,null,null,null,null,null,null,null,null,null,"Öğrenci Puanı, Notu, İstatistik ve Not Dağılım Analizi otomatik oluşacaktır."]
["Soru6",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru7",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru8",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru9",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru10",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru11",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru12",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/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,null,null,null,null,null,null,null,null,null,null,"www.buroyonetimi.com.tr"]
["Soru13",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru14",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Soru15",null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Öğrencinin Puanı",null,null,null,{"$f":"IF(SUM(F6:F20)=0,\"\",SUM(F6:F20))","v":24},{"$f":"IF(SUM(G6:G20)=0,\"\",SUM(G6:G20))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"Notu",{"$f":"IF(F22=\"\",\"\",IF(F22<50,1,IF(F22<60,2,IF(F22<70,3,IF(F22<85,4,5)))))","v":1},{"$f":"IF(G22=\"\",\"\",IF(G22<50,1,IF(G22<60,2,IF(G22<70,3,IF(G22<85,4,5)))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[null,"En Yüksek Not",":",{"$f":"MAX($F$22:$AS$22)","v":24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85-100 Arası",":",{"$f":"COUNTIF(F23:AS23,5)","v":0}]
[null,"En Düşük Not",":",{"$f":"MIN($F$22:$AS$22)","v":24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70-84,99 Arası",":",{"$f":"COUNTIF(F23:AS23,4)","v":0}]
[null,"Sınıf Ortalaması",":",{"$f":"AVERAGE($F$22:$AS$22)","v":24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60-69,99 Arası",":",{"$f":"COUNTIF(F23:AS23,3)","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,"50-59,99 Arası",":",{"$f":"COUNTIF(F23:AS23,2)","v":0}]
[null,"Başarılı Öğrenci",":",{"$f":"COUNTIF($F$22:$AS$22,\">=50\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-49,99 Arası",":",{"$f":"COUNTIF(F23:AS23,1)","v":1}]
[null,"Başarısız Öğrenci",":",{"$f":"COUNTIF($F$22:$AS$22,\"<50\")","v":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,null,null,null,null,"Ayla TATLICI",null,null,null,null,null,"Şafak KÖSE"]