{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-1","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"기본작업-1","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["교원확보율"]
[]
["학과코드","학과명","학제","전체 학생수","전체교원","정원/전임(겸임)","전임"]
["KA-45267","경영정보과","2년",140,"6명","6/3/(3)",0.5]
["LT-95872","간호과","4년",130,"8명","7/6(2)",0.85709999999999997]
["SQ-89163","사회복지과","3년",150,"7명","6/4(3)",0.66669999999999996]
["TB-37245","유아교육과","3년",210,"9명","9/6(3)",0.66669999999999996]
["AV-32896","정보통신과","2년",150,"6명","8/3(3)",0.375]
["CT-92578","컴퓨터정보과","3년",105,"4명","6/3(1)",0.5]
["PW-4128","식품생명공학과","4년",120,"7명","7/5(2)",0.71430000000000005]

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

{"sheet":"계산작업","index":3,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,2],[11,5,12,5],[23,1,23,2]]}
["[표1] 자격증 응시일",null,null,null,null,"[표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,TRUE)","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,TRUE)","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"]
[]
[null,null,null,null,null,"학점기준표"]
["[표3]",null,null,null,null,"평균",0,60,70,80,90]
["학과","성명","생년월일","평점",null,null,60,70,80,90,100]
["컴퓨터학과","유창상","1995-10-20",3.45,null,"학점","F","D","C","B","A"]
["경영학과","김현수","1994-03-02",4.0199999999999996]
["경영학과","한경수","1994-08-22",3.67]
["컴퓨터학과","정수연","1992-01-23",3.89]
["정보통신과","최경철","1995-05-12",3.12]
["정보통신과","오태환","1996-07-05",3.91]
["컴퓨터학과","임장미","1995-10-26",4.1500000000000004]
["경영학과","이민호","1993-06-27",3.52]
[]
["조건"]
["학과","경영학과 평균 평점",null,{"$f":"ROUND(DAVERAGE($A$13:$D$22,4,A24:A25),2)","v":3.74}]
["경영학과"]
[]
["[표4]",null,null,null,null,"[표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"]
[null,null,null,null,null,"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,"cut":false,"hidden":false,"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.666666666666671},{"$f":"SUBTOTAL(1,D4:D6)","v":76.666666666666671},{"$f":"SUBTOTAL(1,E4:E6)","v":78.333333333333329}]
["경영정보 요약",null,null,null,null,{"$f":"SUBTOTAL(9,F4:F6)","v":725}]
["유아교육","강소미",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.666666666666671},{"$f":"SUBTOTAL(1,D9:D11)","v":75},{"$f":"SUBTOTAL(1,E9:E11)","v":78.333333333333329}]
["유아교육 요약",null,null,null,null,{"$f":"SUBTOTAL(9,F9:F11)","v":735}]
["정보통신","김경호",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":68.333333333333329},{"$f":"SUBTOTAL(1,E14:E16)","v":78.333333333333329}]
["정보통신 요약",null,null,null,null,{"$f":"SUBTOTAL(9,F14:F16)","v":710}]
["전체 평균",null,{"$f":"SUBTOTAL(1,C4:C16)","v":89.444444444444443},{"$f":"SUBTOTAL(1,D4:D16)","v":73.333333333333329},{"$f":"SUBTOTAL(1,E4:E16)","v":78.333333333333329}]
["총합계",null,null,null,null,{"$f":"SUBTOTAL(9,F4:F16)","v":2170}]

{"sheet":"분석작업-2","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["학과별 인증 점수 취득 총점"]
[]
["[표1] 2013년",null,null,null,null,"[표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,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["소양직무인증점수"]
[]
["학과","성명","소양인증","직무인증","총점"]
["컴퓨터정보과","김영우",5780,17940,{"$f":"SUM(C4:D4)","v":23720}]
["컴퓨터게임과","강주찬",13960,11560,{"$f":"SUM(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,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["연도별 장학금 현황"]
[]
["구분","2012년","2013년","2014년","2015년"]
["성적장학",42437,43632,47664,47254]
["가계장학",11666,12769,13182,14568]
["근로장학",27345,27973,31570,33280]
["합계",81448,84374,92353,95102]