{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-1","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"기본작업-1","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
["교원확보율"]
[]
["학과코드","학과명","학제","전체학생수","전체교원","정원/전임(겸임)","전임"]
["KA-45267","경영정보과","2년",140,"6명","6/3(3)",{"v":0.5,"d":"50.00%"}]
["LT-95872","간호과","4년",130,"8명","7/6(2)",{"v":0.8571,"d":"85.71%"}]
["SQ-89163","사회복지과","3년",150,"7명","6/4(3)",{"v":0.6667,"d":"66.67%"}]
["TB-37245","유아교육과","3년",210,"9명","9/6(3)",{"v":0.6667,"d":"66.67%"}]
["AV-32896","정보통신과","2년",150,"6명","8/3(3)",{"v":0.375,"d":"37.50%"}]
["CT-92578","컴퓨터정보과","3년",105,"4명","6/3(1)",{"v":0.5,"d":"50.00%"}]
["PW-4128","식품생명공학과","4년",120,"7명","7/5(2)",{"v":0.7143,"d":"71.43%"}]

{"sheet":"기본작업-2","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[0,0,0,5],[3,0,5,0],[3,1,5,1],[3,5,5,5],[6,0,8,0],[6,5,8,5]]}
["인성인증 항목 및 배점표"]
[]
["인증영역","인증항목","내용","배점","회수","최대배점"]
["기본영역","출석률","95~100",45,2,90]
[null,null,"90~95",40,2]
[null,null,"80~89",40,2]
["인성점수","문화관람","영화/연극/전시회",3,10,30]
[null,"헌혈","헌혈참여",10,5]
[null,"교외봉사","봉사시간",2,35]

{"sheet":"기본작업-3","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[0,0,0,8]]}
["컴퓨터활용 성적"]
[]
["학번","이름","중간","중간(40)","기말","기말(40)","출석(20)","합계"]
[201213056,"김대훈",25,{"$f":"50+C4/2","v":{"v":62.5,"d":"63"}},15,{"$f":"50+E4/2","v":{"v":57.5,"d":"58"}},18,{"$f":"(D4+F4)*0.4+G4","v":66}]
[201309060,"김세인",{"v":67.5,"d":"68"},{"v":83.75,"d":"84"},10,55,16,{"v":71.5,"d":"72"}]
[201121010,"김송희",{"v":37.5,"d":"38"},{"v":68.75,"d":"69"},8,54,18,{"v":67.1,"d":"67"}]
[201118036,"김은지",30,65,30,65,20,72]
[201415093,"김지수",{"v":87.5,"d":"88"},{"v":93.75,"d":"94"},90,95,20,{"v":95.5,"d":"96"}]
[201214036,"박병재",{"v":43.75,"d":"44"},{"v":71.875,"d":"72"},5,{"v":52.5,"d":"53"},18,{"v":67.75,"d":"68"}]
[201330056,"박준희",{"v":42.5,"d":"43"},{"v":71.25,"d":"71"},20,60,16,{"v":68.5,"d":"69"}]
[201309025,"박하늘",25,{"v":62.5,"d":"63"},20,60,16,65]
[200906050,"윤경문",{"v":87.5,"d":"88"},{"v":93.75,"d":"94"},50,75,16,{"v":83.5,"d":"84"}]
[201118046,"이다정",88,94,80,90,20,{"v":93.60000000000001,"d":"94"}]
[201415058,"이종희",0,50,10,55,18,60]
[201415087,"임천규",50,75,40,70,20,78]
[201202075,"임태헌",20,60,15,{"v":57.5,"d":"58"},20,67]
[201415065,"최서현",50,75,40,70,20,78]
[201320030,"홍주희",{"v":34.375,"d":"34"},{"v":67.1875,"d":"67"},10,55,16,{"v":64.875,"d":"65"}]

{"sheet":"계산작업","index":3,"n_rows":37,"n_cols":11,"rows_kept":37,"merged":[[11,5,12,5],[23,1,23,2],[36,0,36,2]]}
["[표1] 자격증 응시일",{"$nulls":4},"[표2]"]
["응시지역","성명","응시일","요일",null,"성명","중간고사","기말고사","학점"]
["광주","김종민","2016-05-15",{"$f":"IF(WEEKDAY(C3,2)<=5,\"평일\",\"주말\")","v":"주말"},null,"김미정",85,90,{"$f":"HLOOKUP(AVERAGE(G3:H3),$G$12:$K$14,3,1)","v":"B"}]
["서울","강원철","2016-10-24",{"$f":"IF(WEEKDAY(C4,2)<=5,\"평일\",\"주말\")","v":"평일"},null,"서진수",65,70,{"$f":"HLOOKUP(AVERAGE(G4:H4),$G$12:$K$14,3,1)","v":"D"}]
["안양","이진수","2016-03-05","주말",null,"박주영",70,95,"B"]
["부산","박정민","2016-08-17","평일",null,"원영현",90,75,"B"]
["인천","한수경","2016-11-12","주말",null,"오선영",60,75,"D"]
["제주","유미진","2016-12-12","평일",null,"최은미",95,85,"A"]
["대전","정미영","2016-02-25","평일",null,"박진희",70,85,"C"]
[]
[{"$nulls":5},"학점기준표"]
["[표3]",{"$nulls":4},"평균",{"v":0,"d":"0 이상"},{"v":60,"d":"60 이상"},{"v":70,"d":"70 이상"},{"v":80,"d":"80 이상"},{"v":90,"d":"90 이상"}]
["학과","성명","생년월일","평점",null,null,{"v":60,"d":"60 미만"},{"v":70,"d":"70 미만"},{"v":80,"d":"80 미만"},{"v":90,"d":"90 미만"},{"v":100,"d":"100 이하"}]
["컴퓨터학과","유창상","1995-10-20",3.45,null,"학점","F","D","C","B","A"]
["경영학과","김현수","1994-03-02",4.02]
["경영학과","한경수","1994-08-22",3.67]
["컴퓨터학과","정수연","1992-01-23",3.89,null,"IF(조건,참,거짓)"]
["정보통신과","최경철","1995-05-12",3.12,null,"조건=> 평일이냐? WEEKDAY"]
["정보통신과","오태환","1996-07-05",3.91]
["컴퓨터학과","임장미","1995-10-26",4.15]
["경영학과","이민호","1993-06-27",3.52]
[]
["조건"]
["학과","경영학과 평균 평점",null,{"$f":"ROUND(DAVERAGE(A13:D21,D13,A24:A25),2)","v":3.74},null,"평균->소수이하 둘째자리 반올림"]
["경영학과",{"$nulls":4},"round(daverage(  ))"]
[]
["[표4]",{"$nulls":4},"[표5]"]
["학생명","커뮤니케이션","회계","경영전략",null,"학과","입학일자","입학코드"]
["유창상",77,75,88,null,"HEALTHCARE","2015-03-02",{"$f":"PROPER(LEFT(F29,3))&YEAR(G29)","v":"Hea2015"}]
["김현수",58,76,78,null,"HEALTHCARE","2017-03-03",{"$f":"PROPER(LEFT(F30,3))&YEAR(G30)","v":"Hea2017"}]
["한경수",68,70,80,null,"COMPUTER","2015-03-02","Com2015"]
["정수연",53,69,94,null,"COMPUTER","2017-03-02","Com2017"]
["최경철",73,75,91,null,"DESIGN","2014-03-02","Des2014"]
["오태환",55,67,88,null,"DESIGN","2016-03-02","Des2016"]
["임장미",95,89,79,null,"ARTS-THERAPY","2013-03-02","Art2013"]
[{"$nulls":5},"ARTS-THERAPY","2016-03-02","Art2016"]
["모든 과목이 70 이상인 학생 수",null,null,{"$f":"COUNTIFS(B29:B35,\">=70\",C29:C35,\">=70\",D29:D35,\">=70\")","v":3}]

{"sheet":"분석작업-1","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[0,0,0,5]]}
["소양인증포인트 현황"]
[]
["학과","성명","기본영역","인성봉사","교육훈련","합계"]
["경영정보","정소영",85,75,75,{"$f":"SUM(C4:E4)","v":235}]
["경영정보","주경철",85,85,75,{"$f":"SUM(C5:E5)","v":245}]
["경영정보","한기철",90,70,85,{"$f":"SUM(C6:E6)","v":245}]
["경영정보 평균",null,{"$f":"SUBTOTAL(1,C4:C6)","v":86.66666666666667},{"$f":"SUBTOTAL(1,D4:D6)","v":{"v":76.66666666666667,"d":"77"}},{"$f":"SUBTOTAL(1,E4:E6)","v":{"v":78.33333333333333,"d":"78"}}]
["경영정보 최대값",{"$nulls":4},{"$f":"SUBTOTAL(4,F4:F6)","v":245}]
["유아교육","강소미",95,65,65,{"$f":"SUM(C9:E9)","v":225}]
["유아교육","이주현",100,90,80,{"$f":"SUM(C10:E10)","v":270}]
["유아교육","한보미",80,70,90,{"$f":"SUM(C11:E11)","v":240}]
["유아교육 평균",null,{"$f":"SUBTOTAL(1,C9:C11)","v":91.66666666666667},{"$f":"SUBTOTAL(1,D9:D11)","v":75},{"$f":"SUBTOTAL(1,E9:E11)","v":{"v":78.33333333333333,"d":"78"}}]
["유아교육 최대값",{"$nulls":4},{"$f":"SUBTOTAL(4,F9:F11)","v":270}]
["정보통신","김경호",95,75,95,{"$f":"SUM(C14:E14)","v":265}]
["정보통신","박주영",85,50,80,{"$f":"SUM(C15:E15)","v":215}]
["정보통신","임정민",90,80,60,{"$f":"SUM(C16:E16)","v":230}]
["정보통신 평균",null,{"$f":"SUBTOTAL(1,C14:C16)","v":90},{"$f":"SUBTOTAL(1,D14:D16)","v":{"v":68.33333333333333,"d":"68"}},{"$f":"SUBTOTAL(1,E14:E16)","v":{"v":78.33333333333333,"d":"78"}}]
["정보통신 최대값",{"$nulls":4},{"$f":"SUBTOTAL(4,F14:F16)","v":265}]
["전체 평균",null,{"$f":"SUBTOTAL(1,C4:C16)","v":89.44444444444444},{"$f":"SUBTOTAL(1,D4:D16)","v":{"v":73.33333333333333,"d":"73"}},{"$f":"SUBTOTAL(1,E4:E16)","v":{"v":78.33333333333333,"d":"78"}}]
["전체 최대값",{"$nulls":4},{"$f":"SUBTOTAL(4,F4:F16)","v":270}]

{"sheet":"분석작업-2","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,0,0,8]]}
["학과별 인증 점수 취득 총점"]
[]
["[표1] 2013년",{"$nulls":4},"[표4] "]
["학과","정보인증","국제인증","전공인증",null,"학과","정보인증","국제인증","전공인증"]
["컴퓨터정보과",10800,9000,9140,null,"컴퓨터정보과",31520,21860,36200]
["유아교육과",9200,13780,13080,null,"컴퓨터게임과",25320,26200,24000]
["컴퓨터게임과",9060,9160,9140,null,"유아교육과",22500,32040,25600]
["특수교육과",3780,3680,2840,null,"특수교육과",13440,26520,34100]
[]
["[표2] 2014년"]
["학과","정보인증","국제인증","전공인증"]
["컴퓨터정보과",11360,5780,17940]
["컴퓨터게임과",9560,13960,11560]
["특수교육과",3960,9140,19700]
["유아교육과",3740,3300,2840]
[]
["[표3] 2015년"]
["학과","정보인증","국제인증","전공인증"]
["컴퓨터정보과",9360,7080,9120]
["특수교육과",5700,13700,11560]
["컴퓨터게임과",6700,3080,3300]
["유아교육과",9560,14960,9680]

{"sheet":"매크로작업","index":6,"n_rows":8,"n_cols":5,"rows_kept":8,"merged":[[0,0,0,4]]}
["소양직무인증점수"]
[]
["학과","성명","소양인증","직무인증","총점"]
["컴퓨터정보과","김영우",5780,17940,{"$f":"C4+D4","v":23720}]
["컴퓨터게임과","강주찬",13960,11560,{"$f":"C5+D5","v":25520}]
["특수교육과","이홍주",9140,19700,28840]
["유아교육과","박상아",3300,2840,6140]
["정보통신과","정성준",4580,4650,9230]

{"sheet":"차트작업","index":7,"n_rows":7,"n_cols":5,"rows_kept":7,"merged":[[0,0,0,4]]}
["연도별 장학금 현황"]
[]
["구분","2012년","2013년","2014년","2015년"]
["성적장학",{"v":42437,"d":"42,437"},{"v":43632,"d":"43,632"},{"v":47664,"d":"47,664"},{"v":47254,"d":"47,254"}]
["가계장학",{"v":11666,"d":"11,666"},{"v":12769,"d":"12,769"},{"v":13182,"d":"13,182"},{"v":14568,"d":"14,568"}]
["근로장학",{"v":27345,"d":"27,345"},{"v":27973,"d":"27,973"},{"v":31570,"d":"31,570"},{"v":33280,"d":"33,280"}]
["합계",{"v":81448,"d":"81,448"},{"v":84374,"d":"84,374"},{"v":92353,"d":"92,353"},{"v":95102,"d":"95,102"}]