{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["tempData","학생배정결과","DATA","메인","전체통계","학급통계","선택과목별통계","도움말","개인통계","for차트","removeDuple"],"not_rendered":{"charts":1,"images":9,"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":"tempData","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"학생배정결과","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"DATA","index":2,"n_rows":2,"n_cols":50,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["학년","반","번호","이름","국어영역",null,null,null,null,"수학영역",null,null,null,null,"영어영역",null,null,null,null,"탐구유형","탐구1과목",null,null,null,null,"탐구2과목",null,null,null,null,"탐구3과목",null,null,null,null,"제2외국어",null,null,null,null,null,null,null,null,"총계",null,null,null,null,"선택그룹"]
["학년","반","번호","이름","국어과목","원점수","표준점수","백분위","등급","수학과목","원점수","표준점수","백분위","등급","영어과목","원점수","표준점수","백분위","등급",null,"과목","원점수","표준점수","백분위","등급","과목","원점수","표준점수","백분위","등급","과목","원점수","표준점수","백분위","등급","과목","원점수","표준점수","백분위","등급","시험IDX",null,null,null,"원점수","표준점수","백분위"]

{"sheet":"메인","index":3,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,4,1,9],[8,7,8,9]]}
[null,1,null,null,"남궁연 @2023 속초고 만듦. [도움말: 아래 링크]"]
[null,"모의고사성적분석프로그램 ver7",null,null,"https://namgungyeon.tistory.com/91"]
[]
[]
[]
[]
[null,"시험정보  (아래 테이블에 시험 정보(평가일자,평가명) 을 입력후 [새로운 자료입력] 을 누르면 됩니다)"]
[]
[null,"순번","평가일자","평가명","입력된 자료수","비고",null,"영어등급별 환산점수(수정가능)"]
[null,1,"2024-03-28","전국연합학력평가",0,"실채점",null,"등급","백분위","표준점수"]
[null,2,null,null,null,null,null,1,100,200]
[null,null,null,null,null,null,null,2,97,196]
[null,null,null,null,null,null,null,3,92,193]
[null,null,null,null,null,null,null,4,87,188]
[null,null,null,null,null,null,null,5,82,183]
[null,null,null,null,null,null,null,6,77,180]
[null,null,null,null,null,null,null,7,72,170]
[null,null,null,null,null,null,null,8,67,160]
[null,null,null,null,null,null,null,9,62,150]

{"sheet":"전체통계","index":4,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[3,4,4,12],[5,13,5,14]]}
[2]
[]
[1]
[null,null,null,null,"2024학년도 1학년 성적분석자료(실채점)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-28"]
[]
[null,"학급별 백분위 분포"]
[null,"학급",null,1,2,3,4,5,"합계",7,8,9,"합계",11,12,"합계"]
[null,"~ 390"]
[null,"~ 380"]
[null,"~ 370"]
[null,"~ 360"]
[null,"~ 350"]
[null,"~ 340"]
[null,"~ 330"]
[null,"~ 320"]
[null,"~ 310"]
[null,"~ 300"]
[null,"~ 290"]
[null,"~ 280"]
[null,"~ 270"]
[null,"~ 260"]
[null,"~ 250"]
[null,"~ 240"]
[null,"~ 230"]
[null,"~ 220"]
[null,"~ 210"]
[null,"~ 200"]
[null,"~ 190"]
[null,"~ 180"]
[null,"~ 170"]
[null,"~ 160"]
[null,"~ 150"]
[null,"~ 140"]
[null,"~ 130"]
[null,"~ 120"]
[null,"~ 110"]
[null,"100미만"]
[]
[]
[]
[null,"영역별 점수 분석"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"영역별 등급 분포"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"총점순 정렬"]
[null,"순번","학번","이름","국어선택","국어점수","수학선택","수학점수","영어등급","한국사등급","탐구1선택","탐구1점수","탐구2선택","탐구2점수","총점"]

{"sheet":"학급통계","index":5,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[2]
[null,"학급통계"]
[1,"학년",1,"반",2]
[]
[]
[]
[]
[null,null,null,"백분위",null,null,null,null,null,null,null,null,null,null,"등급"]
[null,"학번","이름","국어선택","국어점수","수학선택","수학점수","영어점수","한국사점수","탐구1선택","탐구1점수","탐구2선택","탐구2점수","총점","국어","수학","영어","한국사","탐구1","탐구2"]

{"sheet":"선택과목별통계","index":6,"n_rows":89,"n_cols":25,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
[2,"경제","C"]
[2]
[]
[null,"교과명","반","인원",null,null,null,null,"백분위",null,null,null,null,null,null,null,null,null,null,"등급"]
[null,"경제","C",23,null,null,"학번","이름","국어선택","국어점수","수학선택","수학점수","영어점수","한국사점수","탐구1선택","탐구1점수","탐구2선택","탐구2점수","총점","국어","수학","영어","한국사","탐구1","탐구2"]
[null,"경제","H",23]
[null,"경제","I",25]
[null,"경제 수학","B",18]
[null,"경제 수학","C",16]
[null,"고전 읽기","B",17]
[null,"고전 읽기","D",24]
[null,"고전 읽기","E",20]
[null,"과학과제 연구","C",28]
[null,"기하","D",26]
[null,"기하","G",25]
[null,"물리학Ⅱ","F",22]
[null,"물리학Ⅱ","G",24]
[null,"미적분","D",26]
[null,"미적분","E",26]
[null,"미적분","G",22]
[null,"미적분","I",26]
[null,"사회문제 탐구","B",28]
[null,"사회문제 탐구","D",28]
[null,"사회문제 탐구","E",28]
[null,"사회문제 탐구","G",28]
[null,"사회문제 탐구","I",28]
[null,"생명과학 실험","D",15]
[null,"생명과학 실험","I",15]
[null,"생명과학Ⅱ","A",22]
[null,"생명과학Ⅱ","F",23]
[null,"생명과학Ⅱ","I",18]
[null,"생활과 과학","F",24]
[null,"생활과 과학","G",26]
[null,"생활과 과학","I",26]
[null,"생활과 윤리","A",28]
[null,"생활과 윤리","B",28]
[null,"생활과 윤리","D",28]
[null,"생활과 윤리","F",26]
[null,"생활과 윤리","H",28]
[null,"세계사","C",26]
[null,"세계사","E",26]
[null,"세계사","F",26]
[null,"세계지리","A",21]
[null,"세계지리","B",21]
[null,"세계지리","I",16]
[null,"수학과제 탐구","D",25]
[null,"수학과제 탐구","E",23]
[null,"수학과제 탐구","F",24]
[null,"수학과제 탐구","G",22]
[null,"언어와 매체","A",24]
[null,"언어와 매체","C",20]
[null,"언어와 매체","I",22]
[null,"영미 문학 읽기","B",19]
[null,"영미 문학 읽기","C",17]
[null,"영어 독해와 작문","A",26]
[null,"영어 독해와 작문","B",26]
[null,"영어 독해와 작문","C",26]
[null,"영어 독해와 작문","E",25]
[null,"영어 독해와 작문","F",23]
[null,"영어 독해와 작문","G",25]
[null,"영어 독해와 작문","H",26]
[null,"영어권 문화","A",23]
[null,"영어권 문화","E",19]
[null,"영어권 문화","I",19]
[null,"융합과학","A",25]
[null,"융합과학","H",22]
[null,"인공지능수학","B",14]
[null,"인공지능수학","H",15]
[null,"정치와 법","A",22]
[null,"정치와 법","D",26]
[null,"정치와 법","F",24]
[null,"정치와 법","H",25]
[null,"지구과학Ⅱ","C",18]
[null,"지구과학Ⅱ","D",19]
[null,"지구과학Ⅱ","H",21]
[null,"진로 영어","C",17]
[null,"진로 영어","H",15]
[null,"현대문학 감상","B",20]
[null,"현대문학 감상","G",22]
[null,"현대문학 감상","H",20]
[null,"화법과 작문","A",26]
[null,"화법과 작문","B",26]
[null,"화법과 작문","C",26]
[null,"화법과 작문","E",25]
[null,"화법과 작문","F",25]
[null,"화법과 작문","G",23]
[null,"화법과 작문","I",22]
[null,"화학Ⅱ","E",25]
[null,"화학Ⅱ","H",22]

{"sheet":"도움말","index":7,"n_rows":152,"n_cols":12,"rows_kept":152,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["도움말 및 최신버전의 파일 : https://namgungyeon.tistory.com/91"]
[]
[null,"1. 자료 입력 및 삭제"]
[null,null,null,null,null,null,null,null,null,null,null,"* 대교협 양식 말고 BLSN 양식도 업로드 할 수 있도록 했습니다."]
[null,null,null,null,null,null,null,null,null,null,null,"BLSN 양식은 프로그램의 아래 메뉴에서 다운로드 받을 수 있습니다."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"입력된 자료의 구분을 위해 채점구분(실채점, 가채점) 은 비고란에 입력하면 좋습니다."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. 선택과목별 통계"]
[null,"고교학점제 과목선택 양식(hscredit) 을 등록하면 선택과목별로의 모의고사 점수 통계를 조회할 수 있습니다."]
[null,"등록해야 할 선택과목 양식은 아래와 같습니다."]

{"sheet":"개인통계","index":8,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,"학급",null,"학생"]
[]
[]
[null,"모의고사"]
[]
[null,null,null,"국어",null,"수학",null,"영어","한국사","탐구1",null,"탐구2"]
[null,"순번","평가일자","선택","점수","선택","점수","점수","점수","선택","점수","선택","점수"]

{"sheet":"for차트","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"removeDuple","index":10,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]