230 likes | 367 Vues
Coursework Completion System October 21, 2010. Welcome Interface Specifications XML and CSV Section, Course, Teacher On-Line Resources Q & A. Section/Course/teacher. XML Format. Single Section/Course/Teacher File Layout for XML and CSV. SECTION SECTION_ID CLASSROOM_TYPE
E N D
Coursework Completion SystemOctober 21, 2010 Welcome Interface Specifications XML and CSV Section, Course, Teacher On-Line Resources Q & A Coursework Completion System
Section/Course/teacher XML Format Coursework Completion System
Single Section/Course/Teacher File Layout for XML and CSV • SECTION • SECTION_ID • CLASSROOM_TYPE • DUAL_ENROLL_CREDIT • DISTANCE_ED • VIRTUAL_ONLINE_ED • BILINGUAL_ESL • PROJECT_BASED • COURSE • COURSE_CODE • LOCAL_COURSE_TITLE • ACAD_SERVICE_LEARN • EQUIVALENCY • WORLD_LANGUAGE • ALT_ED_PROGRAM • TEACHER • TEACHER_ROLE • ED_FILE_NUMBER • LAST_NAME Coursework Completion System
<?xml version = "1.0" encoding = "UTF-8" standalone = "no"?> <!DOCTYPE CWCS_TRANS SYSTEM "TR_CWCSWCT.DTD"> <CWCS_TRANS> <DTG>10-18-2010 13:00:05 CST</DTG> <SEQ_NUM>00002</SEQ_NUM> <COLLECTION>CW1</COLLECTION> <DISTRICT>0001</DISTRICT> <SCHOOLS> <SCHOOL>0020</SCHOOL> <RECORD_TYPE>WCT</RECORD_TYPE> <YEAR>2011</YEAR> <TERM>1S</TERM> <SECTION> <SECTION_ID>ALG2069B</SECTION_ID> <CLASSROOM_TYPE>S</CLASSROOM_TYPE> <DUAL_ENROLL_CREDIT>NA</DUAL_ENROLL_CREDIT> <DISTANCE_ED>N</DISTANCE_ED> <VIRTUAL_ONLINE_ED>N</VIRTUAL_ONLINE_ED> <BILINGUAL_ESL>B</BILINGUAL_ESL> <PROJECT_BASED>N</PROJECT_BASED> <COURSE> <COURSE_CODE>02069B</COURSE_CODE> <LOCAL_COURSE_TITLE>ALGBIL02069B</LOCAL_COURSE_TITLE> <ACAD_SERVICE_LEARN>N</ACAD_SERVICE_LEARN> <EQUIVALENCY>NA</EQUIVALENCY> <WORLD_LANGUAGE>NA</WORLD_LANGUAGE> <ALT_ED_PROGRAM>NA</ALT_ED_PROGRAM> </COURSE> <TEACHER> <TEACHER_ROLE>ST</TEACHER_ROLE> <ED_FILE_NUMBER>000009</ED_FILE_NUMBER> <LAST_NAME>BROWN</LAST_NAME> </TEACHER> </SECTION> </SCHOOLS> </CWCS_TRANS> XML Format Coursework Completion System
Single Section/Course/Teacher (CSV Format) “01”,”02-10-2011 13:00:05 CST”,”00001”,“CW1”,“0001” “02”,”0002”,”WCT”,”2010”,”1S” “03”,”ALG02069B”,”S”,”NA”,”N”,”N”, ”B”,”N” “04”,”02069B”,”ALGBIL02069B”,”N”,”NA”,”NA”,”NA” “05”,”ST”,”000009”,”BROWN”,”” … “06”,”EOF” Coursework Completion System
Generic Alternative Education Course with a Monitoring Educator for XML and CSV • SECTION • SECTION_ID • DISTANCE_ED • VIRTUAL_ONLINE_ED • PROJECT_BASED • COURSE • COURSE_CODE • ACAD_SERVICE_LEARN • ALT_ED_PROGRAM • TEACHER • TEACHER_ROLE • ED_FILE_NUMBER • LAST_NAME Coursework Completion System
Generic Alternative Education Course with a Monitoring Educator (XML Format) <?xml version = "1.0" encoding = "UTF-8" standalone = "no"?> <!DOCTYPE CWCS_TRANS SYSTEM "TR_CWCSWCT.DTD"> <CWCS_TRANS> <DTG>10-18-2010 13:00:05 CST</DTG> <SEQ_NUM>00002</SEQ_NUM> <COLLECTION>CW1</COLLECTION> <DISTRICT>0001</DISTRICT> <SCHOOLS> <SCHOOL>0020</SCHOOL> <RECORD_TYPE>WCT</RECORD_TYPE> <YEAR>2011</YEAR> <TERM>1S</TERM> <SECTION> <SECTION_ID>00205AF2010</SECTION_ID> <DISTANCE_ED>N</DISTANCE_ED> <VIRTUAL_ONLINE_ED>N</VIRTUAL_ONLINE_ED> <PROJECT_BASED>N</PROJECT_BASED> <COURSE> <COURSE_CODE>22A01G</COURSE_CODE> <ACAD_SERVICE_LEARN>N</ACAD_SERVICE_LEARN> <ALT_ED_PROGRAM>HSED</ALT_ED_PROGRAM> </COURSE> <TEACHER> <TEACHER_ROLE>ME</TEACHER_ROLE> <ED_FILE_NUMBER>000012</ED_FILE_NUMBER> <LAST_NAME>SMITH</LAST_NAME> </TEACHER> </SECTION> </SCHOOLS> </CWCS_TRANS> Coursework Completion System
Generic Alternative Education Course with a Monitoring Educator (CSV Format) “01”,”02-10-2011 13:00:05 CST”,”00001”,“CW1”,“0001” “02”,”0002”,”WCT”,”2010”,”1S” “03”, “00205AF2010”,””,””,”N”,”N”,””,”N” “04”,” 22A01G”,””,”N”,””,””,”HSED” “05”,”ME”,” 000012”,”SMITH”,”” … “06”,”EOF” Coursework Completion System
Generic Elementary Social Studies Course with only Required Fields for XML and CSV • SECTION • SECTION_ID • COURSE • COURSE_CODE • TEACHER • TEACHER_ROLE • ED_FILE_NUMBER • LAST_NAME Coursework Completion System
Generic Elementary Social Studies Course with only Required Fields (XML Format) <?xml version = "1.0" encoding = "UTF-8" standalone = "no"?> <!DOCTYPE CWCS_TRANS SYSTEM "TR_CWCSWCT.DTD"> <CWCS_TRANS> <DTG>10-18-2010 13:00:05 CST</DTG> <SEQ_NUM>00002</SEQ_NUM> <COLLECTION>CW1</COLLECTION> <DISTRICT>0001</DISTRICT> <SCHOOLS> <SCHOOL>0020</SCHOOL> <RECORD_TYPE>WCT</RECORD_TYPE> <YEAR>2011</YEAR> <TERM>1S</TERM> <SECTION> <SECTION_ID>00205AF2010</SECTION_ID> <COURSE> <COURSE_CODE>04E01B </COURSE_CODE> </COURSE> <TEACHER> <TEACHER_ROLE>ST</TEACHER_ROLE> <ED_FILE_NUMBER>000012</ED_FILE_NUMBER> <LAST_NAME>SMITH</LAST_NAME> </TEACHER> </SECTION> </SCHOOLS> </CWCS_TRANS> Coursework Completion System
Generic Elementary Social Studies Course with only Required Fields (CSV Format) “01”,”02-10-2011 13:00:05 CST”,”00001”,“CW1”,“0001” “02”,”0002”,”WCT”,”2010”,”1S” “03”,“GENSOCIALSTUDIES4E01”,””,””,””,””,””,”” “04”,” 04E01B ”,””,””,””,””,”” “05”,”ST”,”000012”,”SMITH”,”” … “06”,”EOF” Coursework Completion System
Multiple Courses with Multiple Teachers (interdisciplinary section) for XML and CSV • SECTION • SECTION_ID • CLASSROOM_TYPE • DUAL_ENROLL_CREDIT • DISTANCE_ED • VIRTUAL_ONLINE_ED • BILINGUAL_ESL • PROJECT_BASED • COURSE • COURSE_CODE • TEACHER • TEACHER_ROLE • ED_FILE_NUMBER • LAST_NAME • COURSE • COURSE_CODE • TEACHER • TEACHER_ROLE • ED_FILE_NUMBER • LAST_NAME Coursework Completion System
Multiple Courses with Multiple Teachers (interdisciplinary section) XML Format <?xml version = "1.0" encoding = "UTF-8" standalone = "no"?> <!DOCTYPE CWCS_TRANS SYSTEM "TR_CWCSWCT.DTD"> <CWCS_TRANS> <DTG>10-18-2010 13:00:05 CST</DTG> <SEQ_NUM>00002</SEQ_NUM> <COLLECTION>CW1</COLLECTION> <DISTRICT>0001</DISTRICT> <SCHOOLS> <SCHOOL>0020</SCHOOL> <RECORD_TYPE>WCT</RECORD_TYPE> <YEAR>2011</YEAR> <TERM>1S</TERM> <SECTION> <SECTION_ID>01054AmLit06101Span</SECTION_ID> < CLASSROOM_TYPE>M</CLASSROOM_TYPE> <COURSE> <COURSE_CODE>01054E</COURSE_CODE> <LOCAL_COURSE_TITLE>AMERICANLITERATURE105E</LOCAL_COURSE_TITLE> </COURSE> <COURSE> <COURSE_CODE>06101E</COURSE_CODE> <LOCAL_COURSE_TITLE>SPANISH610E</LOCAL_COURSE_TITLE> <ACAD_SERVICE_LEARN>N</ACAD_SERVICE_LEARN> <WORLD_LANGUAGE>WL</WORLD_LANGUAGE> </COURSE> <TEACHER> <TEACHER_ROLE>MT</TEACHER_ROLE> <ED_FILE_NUMBER>000030</ED_FILE_NUMBER> <LAST_NAME>NELSON</LAST_NAME> </TEACHER> <TEACHER> <TEACHER_ROLE>MT</TEACHER_ROLE> <ED_FILE_NUMBER>000017</ED_FILE_NUMBER> <LAST_NAME>MARTIN</LAST_NAME> </TEACHER> </SECTION> </SCHOOLS> </CWCS_TRANS> Coursework Completion System
Multiple Courses with Multiple Teachers (interdisciplinary section) CSV Format “01”,”02-10-2011 13:00:05 CST”,”00001”,“CW1”,“0001” “02”,”0002”,”WCT”,”2010”,”1S” “03”,”01054AmLit06101Span”,”M”,””,””,””,””,”” “04”,”01054E”,”AMERICANLITERATURE105E”,””,””,””,”” “04”,”06101E”,”SPANISH610E”,”N”,””,”WL”,”” “05”,”MT”,” 000030”,”NELSON”,”” “05”,”MT”,” 000017”,”MARTIN”,”” … “06”,”EOF” Coursework Completion System
One School with multiple Sections/Courses/Teachers Header Information School Information Section/Course/Teacher Section/Course/Teacher Section/Course/Teacher End of File Coursework Completion System
One School with multiple Sections/Courses/Teachers (XML Format) Coursework Completion System ?xml version = "1.0" encoding = "UTF-8" standalone = "no"?> !DOCTYPE CWCS_TRANS SYSTEM "TR_CWCSWCT.DTD"> CWCS_TRANS> DTG>10-18-2010 13:00:05 CST</DTG> SEQ_NUM>00002</SEQ_NUM> COLLECTION>CW1</COLLECTION> DISTRICT>0001</DISTRICT> SCHOOLS> SCHOOL>0020</SCHOOL> RECORD_TYPE>WCT</RECORD_TYPE> YEAR>2011</YEAR> TERM>1S</TERM> SECTION> SECTION_ID>ALG206B</SECTION_ID> CLASSROOM_TYPE>S</CLASSROOM_TYPE> DUAL_ENROLL_CREDIT>NA</DUAL_ENROLL_CREDIT> DISTANCE_ED>N</DISTANCE_ED> VIRTUAL_ONLINE_ED>N</VIRTUAL_ONLINE_ED> BILINGUAL_ESL>B</BILINGUAL_ESL> PROJECT_BASED>N</PROJECT_BASED> COURSE> COURSE_CODE>02069B</COURSE_CODE> LOCAL_COURSE_TITLE>ALGEBRABILING206B</LOCAL_COURSE_TITLE> ACAD_SERVICE_LEARN>N</ACAD_SERVICE_LEARN> EQUIVALENCY>NA</EQUIVALENCY> WORLD_LANGUAGE>NA</WORLD_LANGUAGE> ALT_ED_PROGRAM>NA</ALT_ED_PROGRAM> /COURSE> TEACHER> TEACHER_ROLE>ST</TEACHER_ROLE> ED_FILE_NUMBER>000009</ED_FILE_NUMBER> LAST_NAME>BROWN</LAST_NAME> /TEACHER> /SECTION> SECTION> <SECTION_ID>00205AF2010</SECTION_ID> <DISTANCE_ED>N</DISTANCE_ED> <VIRTUAL_ONLINE_ED>N</VIRTUAL_ONLINE_ED> <PROJECT_BASED>N</PROJECT_BASED> <COURSE> <COURSE_CODE>22A01G</COURSE_CODE> <ACAD_SERVICE_LEARN>N</ACAD_SERVICE_LEARN> <ALT_ED_PROGRAM>HSED</ALT_ED_PROGRAM> </COURSE> <TEACHER> <TEACHER_ROLE>ME</TEACHER_ROLE> <ED_FILE_NUMBER>000012</ED_FILE_NUMBER> <LAST_NAME>SMITH</LAST_NAME> </TEACHER> </SECTION > </SCHOOLS> </CWCS_TRANS>
Multiple Sections/Courses/Teachers CSV Format “01”,”02-10-2011 13:00:05 CST”,”00001”,“CW1”,“0001” “02”,”0002”,”WCT”,”2010”,”1S” “03”,”01054AmLit06101Span”,”M”,””,””,””,””,”” “04”,”01054E”,”AMERICANLITERATURE105E”,””,””,””,”” “05”,”MT”,” 000030”,”NELSON”,”” “03”,”06101E”,”SPANISH601E”,” “04”,”06101E”,”SPANISH610E”,”N”,””,”WL”,”” “05”,”MT”,” 000017”,”MARTIN”,”” … “06”,”EOF” Coursework Completion System
Section/Course/Teacher File (one school with multiple terms) Header Information School 0020 (Term = 1S) Section/Course/Teacher Section/Course/Teacher Section/Course/Teacher School 0020 (Term = 1Q) Section/Course/Teacher Section/Course/Teacher Section/Course/Teacher End of File Coursework Completion System
Section/Course/Teacher File (one school with multiple terms)CSV Format “01”,”02-10-2011 13:00:05 CST”,”00001”,“CW1”,“0001” “02”,”0002”,”WCT”,”2010”,”1S” “03”,”01054AmLit06101Span”,”M”,””,””,””,””,”” “04”,”01054E”,”AMERICANLITERATURE105E”,””,””,””,”” “05”,”MT”,” 000030”,”NELSON”,”” “03”,”06101E”,”SPANISH601E”,” “04”,”06101E”,”SPANISH610E”,”N”,””,”WL”,”” “05”,”MT”,” 000017”,”MARTIN”,”” “02”,”0002”,”WCT”,”2010”,”1Q” “03”,” 02071GGEOMETRY”,”M”,””,””,””,””,”” “04”,” 02071G ”,”INFORMALGEOMETRY”,””,””,””,”” “05”,”MT”,” 000030”,”NELSON”,”” “03”,”06101E”,”SPANISH601E”,” “04”,”06101E”,”SPANISH610E”,”N”,””,”WL”,”” “05”,”MT”,” 000017”,”MARTIN”,”” … “06”,”EOF” Coursework Completion System
Section/Course/Teacher File (with multiple schools) Header Information School Information Section/Course/Teacher Section/Course/Teacher Section/Course/Teacher School Information Section/Course/Teacher Section/Course/Teacher Section/Course/Teacher End of File Coursework Completion System
Section/Course/Teacher File (with multiple schools) CSV Format “01”,”02-10-2011 13:00:05 CST”,”00001”,“CW1”,“0001” “02”,”0002”,”WCT”,”2010”,”1S” “03”,”01054AmLit06101Span”,”M”,””,””,””,””,”” “04”,”01054E”,”AMERICANLITERATURE105E”,””,””,””,”” “05”,”MT”,” 000030”,”NELSON”,”” “03”,”06101E”,”SPANISH601E”,” “04”,”06101E”,”SPANISH610E”,”N”,””,”WL”,”” “05”,”MT”,” 000017”,”MARTIN”,”” “02”,”0004”,”WCT”,”2010”,”1Q” “03”,” 02071GGEOMETRY”,”M”,””,””,””,””,”” “04”,” 02071G ”,”INFORMALGEOMETRY”,””,””,””,”” “05”,”MT”,” 000030”,”NELSON”,”” “03”,”06101E”,”SPANISH601E”,” “04”,”06101E”,”SPANISH610E”,”N”,””,”WL”,”” “05”,”MT”,” 000017”,”MARTIN”,”” … “06”,”EOF” Coursework Completion System
CWCS On-Line Recourses • Meeting CWCS Data Collection Requirements: http://dpi.wi.gov/lbstat/dm-eseadata.html • CWCS Web Application: http://dpi.wi.gov/lbstat/cwcsapp.html • CWCS Training & Support: http://dpi.wi.gov/lbstat/cwcssupprt.html • CWCS Phone- and Web-Based Conferences: http://dpi.wi.gov/lbstat/eseaphconf.html • CWCS Important Dates: http://dpi.wi.gov/lbstat/eseadates.html • CWCS FAQs: http://dpi.wi.gov/lbstat/cwcsfaq4.html Coursework Completion System
Thank You • Question and Answers • Reminder: Please forward questions to the WSLS/ISES Help Desk and open a Help Desk Ticket or call 800-507-5744. Coursework Completion System