Home

1704 StudentInformation Import Export Guide

1. Select an Ad Hoc Membership w Ad hoc Public And Private it the selected Home District contains multiple high schools then the Export file will contain a separate section for each high school in the district The district Export file must be manually separated in order to create an Export file for each high school Primary Student Id for Export required Choose State Student ID SSID or EMIS ID The default is the SSID If SSID is chosen and a student does not have an SSID then the EMIS ID will be included in the export record If EMIS ID is chosen and a student does not have an EMIS ID then the SSID will be included in the export record If the student does not have an SSID or an EMIS ID then the SSID EMIS ID field will be left blank in the export record Whenever possible choose to export by SSID versus EMIS ID A student in multiple districts must have the same SSID but can have varying EMIS IDs at each district An exception to this would be if the home school is a non public school and does not use SoIDs the JVS would want to do the export by EMIS ID If they chose SSID for the export file then nothing would be imported to the non public school since they do not use SSIDs Home District required Choose the IRN of the Home School district this data applies to The Home District dropdown list is populated based on the building Home ochool IRN field on the Student Profile Gene
2. Export Format Preldent For Otela Export Grade Levels Available Grade Levels Selected Not Applicable 01 First Grade 02 Second Grade 03 Third Grade Export Available Schools in District required Select the schools that are to be included in the export file One export file will be created that will contain data for all selected schools Export Format required Select the Pre Ident for OTELA Export Grades Levels required Select the grade level s to include in the export Export Execute the Export process lf there are students that do not have SSIDs they will be displayed ProgressBook Studentinformation Import Export Guide 99 Pre Identification Export From this screen you can export data for a specific file format PreIdent For Otela Export The following students do not have Statewide Student Identifiers Click Continue if you would like to create the export file without these students Click the Student Name to go to the Student Profile Edit screen Click Refresh to reload the list 27 Records Displayed Grade District Building Student Number Student Name UO DA DAHS 00004001 EYE MAGNUM P 09 DA DAHS 00004003 JOHNSON GEORGE EVAN UO DA DAHS 48652419 Jones Whitney 09 DA DAHS 00007002 PERRY RICHARD MATTHE RICH Click the hyperlinked student name Y5 MAGNUM P t5 go to the Student Profile Edit screen for this student Cli
3. 192 197 PO MarkAlpha4 220 222 O MarkNumeric 223 228 MarkAlpha5 260 262 MarkNumeric5 263 268 LevelOfDifficulty 291 298 CourseCode 299 814 O EMISSubect 315 320 EMISSubjectAreaCredii 323 325 CORESubjectArea 331 8333 EE IsDualCredit 362 vy 1 N 0 gt null blank IsCollegePrep vy 1 N 0 gt null blank 52 ProgressBook Studentlnformation Import Export Guide Home School Export Attendance Navigation Home Management Import Export Home School Export EMIS Attendance tab The JVS typically exports attendance at midyear and at the end of the year When the JVS attendance is imported into the Home School an entry is created on the student s External Absences page in Studentlnformation As of 10 3 0 16150 the Attendance export function includes Days Attended and will split absences into excused and unexcused Export Data to Provide to Students Home Schools This screen will create export files for students home schools Marks Attendance No information is needed to export attendance data Primary Student Id for Export 6 state Student ID SSID EMIS ID Home District Select School v s Student Status A ACTIVE RES A D DELETED Ej dn I INACTIVE i Gs N NON RES xi
4. 44 51 Pt SSIDOEMSID So HomeSchoolCode 61 64 3J4 SchoolYear 65 68 Abbreviation 69 76 4 9 0 SectionNumber 77 78 CourseShoriName 79 93 SchooCode 100 108 BLANK CourseGradeLevelCode 110 111 BLANK BLANK AreaOfStudy 120 122 SubjectArea 1123 125 TransferCode 126 0 0 0 0 MarkAlphai 127 129 0 0 0 MarkNumerict 130 185 1 1 1 0 0 0 justified EarnedCredit1 47 157 Decimal formatted 0 000000 right justified AttemptedCredit1 136 146 Decimal formatted 0 000000 right 1 MarkAlpha2 158 160 0 0 0 00000000 MarkNumeric2 161 166 0 0 000 0 O Decimal formatted 0 000000 right justified justified MarkAlpha3 189 191 0 0 0000000000 MarkNumeric3 192 197 justified justified ProgressBook Studentlnformation Import Export Guide 13 Field Name Position Description MarkAlpha4 220 222 0 0 0000000000000 MarkNumeric4_ 223 228 justified justified BLANK BLANK justified Justified 7 v mo CourseCode 298 314 EMISSubject 1315 320 EMISSubjectAreaCredit 323 325 11 0 0 0 0 0 CORESubecrea 381 833 e BLANK justified BLANK CredtFlex 360 IsDualCredit 362 pes N 0 gt null blank IsCollegePrep 3
5. 48652258 OOS 4005 4003 SO I ZOO 1224 roal 3004 HOO 4001 DOO4 IDOL 3002 YOO 4008 3005 4004 122445 SOJA roog 3003 ZOO 4002 48652261 Excelsior Export Banana MAN WELLS JOHNSON EYE RING LEE CONTRARY SPRAT FONT EYE LINE CONTRARY PERRY PERRY SAWYER WELLS POTTS EYE JONES SARGENT POTTS WILLIAMSON FONT contrary Navigation Home Management Import Export Excelsior Export Many schools use a grade book package named Excelsior Student records in the Excelsior application may be populated by importing data from the Studentlnformation application Six separate files are required for this export and those files then are used to populate the Excelsior grade book package with updated information on a daily basis The six files with their default name are files that include data for the following ProgressBook Studentinformation Import Export Guide 77 Excelsior Export From this screen you can export data for a specific file format Select an Export Format ze Select an Export Format Course Detail Information Course Information Student Data Student Schedule Information Teacher Information Student Data Extended Each file is a comma delimited file left justified with a CSV extension The files can be produced one at a time by choosing the file export format from the dropdown list Please Note Studentlnformation allows this export to be run on a sc
6. Student Data ka Student Statuses Excluded Student Statuses Included A ACTIVE RES D DELETED e I INACTIVE e o M NON RES VK moved the export will not filter on Student Status and all Student Statuses will be included Export Execute the Export process Fields included in the export are the following student ID Student Name 30 characters allows commas formatted Last First Called Student Grade Level Student Birthdate Student Gender Student Parent Student Address1 Student City this field is appended into one field with Province State and Zip Student Province State this field is appended into one field with City and Zip Student Zip this field is appended into one field with City and Province State Student Phone Student Program Code Student Previous School Student Social Security Number formatted xxx xx xxxx Student Admission Date formatted mm dd yyyy Student Withdrawal Date formatted mm dd yyyy ProgressBook Studentinformation Import Export Guide 81 The following figure shows an example of the Student Data Excelsior Export file A B 48652258 Banana H 7001 CONTRAR 48552281 Contrary 5001 CONTRAR 6001 EYE COR 4001 EYE MAC 122445 EYE PRIN 4002 FONT ELL 6002 FONT MIC 4003 JOHNSON 6003 JONES A 1224 LEE HAR D 11 8 7 1887 F 9 2 14 1990 M 10 4 4 2005 M 11 11 17 1987 F 10 7 15 1988 M IJ 4 3 1887 M 11 11 12 1888 F 12 10 24 1985 F 10 1 5 1888 F 12 89
7. Management Import Export WebXam Export At different points in the school year the JVS has the need to create a pre identification file to send to the vendor containing the students who are scheduled to take an exam Previously there was a program on the Alpha provided by SSDT that created the file based on the student subject records and staff class master record data on the Alpha oince the Alpha is no longer being used the program is no longer available The WebXam Export is available in Studentlnformation for this use Note A WebXam report listing the details of the students included in the export file will be available in a future Studentlnformation release The WebXam Export is only available for districts You will receive the following message if you do not have a district in context Iib WebExam Export This page is not available for your Working School You can choose to filter using the Ad Hoc Selection tab or the Filter Selection tab Ad Hoc Selection Tab WebXam Export From this screen you can export data for a specific file format Ad Hoc Selection Filter Selection S i Export file will include only students in grades 09 10 11 12 13 and 23 who are in selected Ad Hoc Membership Ad Hoc Membership Select an Ad Hoc Membership v Casal Public And Private fall GA For selected students without a CTE Program of Concentration use the following CTE Program of Concentration and Assessment Coordin
8. EXCUSED I 155 O OTHER P PARENT CP Export Fields Phone Student Name Period Absence Reason Period Absence Mote Student ID Period 1 Absence Type Export PHON version 2 returns students absent period 1 for the current processing date This file is comma delimited left justified and contains the following fields Phone Number otudent ID otudent Last Name First Name Called Name 1 Period Absence Type Period Absence Reason Period Absence Note User Defined Field 1 Data Flag 2 User Defined Field 2 Data Flag 3 Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process 58 ProgressBook Studentlnformation Import Export Guide File Download Do you want to open or save this file Mame PHONO81113 TXT Type Text Document From dsldemo mcoecn org P While files from the Internet can be useful some files can potentially harm r2 your computer If you do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive These exports are run daily but are not automated The export must be manually processed by the building The file is comma delimited and left justified Edulog Export Navigation Home Management Import Export Edulog Export Several districts use Edulog transportation software for bus routing The file described in the following sections is
9. End user can use their web browser to upload a file from their computer into Studentlnformation The file can then either be processed immediately or made available to an ITC staff member for processing An example of this would be where a school uses an electronic grade book package The school uses the mechanism provided by the grade book package to generate a text file containing student marks in the LOAGRADE format Once this file is created the user would go into Studentlnformation and navigate to the import student marks page They would be prompted to upload their file Studentlnformation would take the uploaded file then process it and load the marks The user would be provided with a report of the completed process File Download Export The end user can download a file directly to their computer from Studentlnformation This action requires no interaction from an ITC staff member An example of this could be that a user needs to have student demographic data information to use in a customized report they are creating They would navigate to the student demographic data page use the filters to select the desired students specify the format of the file and specify the fields to be included in the download file Understanding the Import Export Module otudentlnformation will support the following export formats e Comma Separated e Tab delimited e Excel HTML e Fixed Length e XML COMMA SEPARATED is usually used as a delimi
10. ProgressBook Studentinformation Import Export Guide 71 Meals Plus Point of Sale Version 1 Navigation Home Management Import Export Lunch Export Meals Plus Point of Sale Version 1 Lunch Export From this screen you can export data for a specific file format Meals Plus Point Of Sale Version 1 Student Statuses Excluded A ACTIVE RES D DELETED I INACTIVE ee o M NON RES Student Statuses Included Export Fields Student Number Last Name Z First Name Z Birthdate Middle Mame Student Statuses Excluded Student Statuses Included required Choose the Student Statuses to be included or excluded in the Export Grade Code Address 2 Parent Name Address 3 Homeroom Teacher Last Name Address Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process File Download A Some fles can harm your computer If the file information below Na looks suspicious or you do nat Fully trust the source da nat open or save this file File name DAHS ExE File type Text Document From dsldemo mcaoecn orq Would vau like to open the file or save it to your computer Cancel More Info Save Save this file to your hard drive or network drive 72 ProgressBook Studentlnformation Import Export Guide The file is fixed width left justified with spaces for padding
11. ProgressBook Studentlnformation Import Export Guide ProgressBook Studentinformation ProgressBook Studentlnformation Import Export Guide This document is current for v14 7 0 or later 2015 Software Answers Inc All Rights Reserved All other company and product names included in this material may be Trademarks Registered Trademarks or Service Marks of the companies with which they are associated Software Answers Inc reserves the right at any time and without notice to change these materials or any of the functions features or specifications of any of the software described herein Software Answers Inc www progressbook com 6770 Snowville Rd Suite 200 www software answers com Brecksville Ohio 44141 Change Log The following Change Log explains by Product Version Heading Page and Reason where changes in the ProgressBook Studentinformation Import Export Guide have been made Product Version Heading Page Reason 14 7 0 Entire Guide N A Removed updated references to the retired ProgressBook Studentlnformation General Use Guide 14 6 7 Preldent for Science and Social 111 Updated procedure and image to show Studies new option to Create Separate Files for AASWD and OCBA and new File Download Options section 14 6 5 Preldent for PARCC 106 Added note indicating which courses display in the multi select lists 14 6 5 Preldent for PARCC Student N A Removed section Registration File 14 6 4
12. This export can only be accessed for Districts Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools DAEL DASL ELEMENTARY SCHOOL DAHS DASL HIGH SCHOOL e DAMS DASL MIDDLE SCHOOL Export Format Preldent For OLSAT EI es Like L kc am Ike pm Oo Clos Clos o4 Grade Levels los loe Llo7 log lee Pio Paii L112 Oer Oz Clue ao Omn O oR Return only these students Comma separated Student Ids Available Schools in District required Select the schools that are to be included in the export file One export file will be created that will contain data for all selected schools Export Format required Select the Pre Ident for OLSAT 104 ProgressBook Studentlnformation Import Export Guide Grade Levels required Select the grade level s to include in the export Return Only These Students optional enter specific Student IDs Separated by commas to return in the export This can be used when creating pre identification export files for alternate assessments Please Note When using this option the grade level s of the students entered still need to be checked or the entered students will not be included in the file Export Execute the Export process E File Download Do you want to open or save this file Mame OLSATPreldent DA 1023080403 t
13. Lange Photo The Lange Photo Export is shown in the following figures They use this export file to generate bar codes for the schools and then produce a CD containing the student pictures and associated student information 116 ProgressBook Studentlnformation Import Export Guide Photo Export From this screen you can export data for a specific file format Lange Photo w Student Statuses Excluded Student Statuses Included A ACTIVE RES e dt db Export Fields Z Student Number Lol city Lol Phone Prefix Birthdate Student Last Name State Phone Number Student Grade Level Student First Name Zip Parent Mame Homeroom Name Address Area Code Gender Homeroom Teacher Last Name v Address z Student Statuses Excluded Student Statuses Included required Choose the otudent Statuses to be included or excluded in the Export Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute Export process File Download p Save Some files can harm your computer If the file information below looks suspicious or you do not fully trust the source do not open or save this file File name DAHS csy File type Microsoft Office Excel Comma Separated values Fil From dsldemo mcoecn orq Would you like ta open the file or save it to your computer Cancel More Info Save this file to your hard drive or network drive ProgressBook Studen
14. Management Import Export Special Education Import SpS Student Ohio Graduation Test Run Option Student Ohio Graduation Test Record Sort Type FA The Student Ohio Graduation Test record import will serve as an update if a match is found The import file layout of the Student Ohio Graduation Test record will be formatted in the FA file record layout as defined in Chapter 5 of the ODE EMIS Manual Student Ohio Graduation Test FA Record Special Education Import Logic 1 If same test date required test part assessment type code GX and existing accommodation equals No Studentlnformation will load update the record with the accommodation value from the import file 2 lf no matching FA records exist no records are imported Imports may be done at any time during the school year Special Education Import SpS Student Kindergarten Readiness Assessment FA GO Record Type Navigation Home Management Import Export Special Education Import SpS Student Kindergarten Readiness Assessment Run Option Student Kindergarten Readiness Assessment Record Sort Type FA The Student Kindergarten Readiness Assessment record import will serve as an update if a match is found The import file layout of the Student Kindergarten Readiness Assessment record will be formaited in the FA file record layout as defined in Chapter 5 of the ODE EMIS Manual ProgressBook Studentlnformation Import Export Guide 31 Student Kindergar
15. OoO000000 102004 ka 00000000 OoO0000000 200502105 200511075 1004200501205 1004200511075 1004200501205 1004200501205 1004200501205 1004200511085 1004200503165 1004200511095 1004200501205 1004200511075 1004200511085 1004200511065 1004200501205 1004200501205 1004200511085 1004200511075 1004200501205 1004200511075 1004200511085 1004200511085 1004200511075 1004200501205 1004200501205 200504145 j ei ei ud tU eieiei ei ei ei ei ei ei eieiei ei ei ei m ei ei D ei tu D td D td D D D Cd D D D D D D D D D D D D td D D oa HH HH HR H H H H H H iH d H iH iH H iH iH iH H iH iH H Lunch Export Navigation Home Management Import Export Lunch Export This export is a specific format for four different cafeteria point of sales programs as shown in the following figure The export information will be used to populate these programs for lunch cards and accounts Lunch Export From this screen you can export data for a specific file format Select an Export Format w Select an Esport Format Lunch Export For WAPAK City Schools Meals Plus Point Of Sale Version 1 Meals Plus Point Of Sale Version 2 WIM MCM Lunch Program ProgressBook Studentinformation Import Export Guide Lunch Export for WAPAK City Schools Navigation Home Management Import Export Lunch Export Lunch Export for WAPAK City Schools Lunch Export From this screen you can export data for a specific file format Lun
16. imported as blank marks in Studentlnformation Values Replaced From Import File Will display the records that were processed and marks updated This will display any old marks that were replaced by the new marks and the reporting period to which those marks were imported ProgressBook Studentinformation Import Export Guide 11 Start Over Start Over and go back to Step One Once the LOAGRADE Import has run successfully the specific marks are updated on the student records You can now proceed with any or all of the following R703 Verification Sheets Required Marks Entry R702 Transcripts R700 Report Cards viewing grades on student records etc Note If the LOAGRADE process imports marks for a student who has been withdrawn from a particular course section Studentinformation will not prevent those marks from being applied to that student and that course section Home School Import Navigation Home Management Import Export Home School Import Home School Import is used to transfer Course History Attendance and Students data from a JVS to a Home School Any school not just Home Schools can use the Home School Import Studentinformation will create an export file that can be imported to Studentlnformation see Home School Export or a SIS extract can be performed and imported to otudentlnformation The file layouts are fixed width files with a header row if exporting from Studentlnformation Note that some program
17. indicating the eTranscript job has been submitted 158 ProgressBook Studentlnformation Import Export Guide
18. 13 1985 M 10 8 14 1988 F 9 10 30 1989 F F G H 2117 CheriLima OH 45804 MARION C90 ELM S LIMA OH 45801 645 S Ma Lima OH 45804 MARION C90 ELM S LIMA OH 228 7417 EDWARD 12 NORTHLIMA OH 45801 EDWARD 122 NORT LIMA OH 111 2222 BLU EYE 123 SECR LIMA OH 222 6888 JANE FON345 N FRCLIMA OH 45801 JANE FON345 N FRCLIMA OH 45801 HOWARD 597 STATELIMA OH 45801 WILLIAM 702 BRIST LIMA OH 45801 ATTICUS F23 MOCKI LIMA OH 345 2345 L N 268 72 217 2 9 2005 2 10 2005 359 565 2368 00 00 0000 4 14 2005 00 00 0000 376 687 3245 5309 09 64 267 607 4612 123 65 4123 566 97 8542 2709 65 4736 4586 76 9300 456 30 9900 6798 95 6677 00 00 0000 8 1 2004 00 00 0000 00 00 0000 00 00 0000 00 00 0000 00 00 0000 00 00 0000 00 00 0000 00 00 0000 Excelsior Export From this screen you can export data for a specific file format Student Schedule Information ze Artificial Course Filter Mat Used v Get scheduling info based on current Schedule Term Course Type Artificial Course Filter exported data by artificial course status or select Filter Not Used Course Type Filter exported data by course type or select Filter Not Used Get scheduling info based on current Schedule Term Check this box to use the current Schedule Term s scheduling information Export Execute the Export process Fields included in the export are the following e Student ID e Course ID e Course Section Number e
19. 2004 20044115 2004 2004 2004 2004 2004 2604 2004 e004 2004 2004 zUD4AIQG 2004 2604 ZUUAKILO z004 2004 iDD4Al0 sllja 2004 20044110 a DU 2117 Cherry Street 600 BLOOM DRIVE 843 NORTHWALD DR I 597 STATE STREET 12 NORTH ST 9065 BLISS RD 23 MOCKINGBIRD LANE 90 ELM STREET 890 BACON TRAIL 345 N FRONT ST 122 NORTH ST 665 SUGAR STREET 90 ELM STREET 776 BROADWAY BLVD 775 BROADWAY BLVD 89 MISSISSIPPI RD 843 NORTHWALD DR 7632 BLENDON PLACE 123 SECRET AVE 702 BRISTOL 123 Bigtop Street 7632 BLENDON PLACE 881 THAYER ROAD 345 N FRONT ST 645 S Main SUITE 100 2004 2004 2004 20044110 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 20044106 2004 2004 20044110 2004 2004 20044106 2004 2004 20044110 2004 ProgressBook Studentlnformation Import Export Guide Filler 329 22 First 8 positions contain the last date the STUD record was modified ninth position contains the scheduling priority code Edulog School Code 351 4 Studentlnformation School Code m oko EB mee Ej GI 42 42 El GL x ECC 42 ml ese d oc m cr p RHR DT PE DO mg DOES TW OTE ES TO TH DT Pa G EB DB Bi sa ma ta pi sa ta eb eR dem ta eR ses ta deb eR des dea gen je RA ek m ts Fa SHARON LEE MITCH WELLS HOWARD JOHNSON EDWARD EYE NICHOLAS RING 4193452345ATTICUS FINCH MARION CONTRARY 4192287417JOLENE TREECE JANE FONT 5551112222EDWARD EYE BOB LINE 4192287417MARION CONTRARY MATTHEW PERRY MATTHEW PERRY 4
20. Campus Number expected by the WIN MCM Lunch Program Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process File Download 9 Some files can harm your computer IF the file information below wd looks suspicious or you do nat Fully trust the source da nat open or save this file File name DAHS Ext File type Text Document From dsldemo mcoecn org Would vau like to open the file or save it to your computer Cancel More Info Save Save this file to your hard drive or network drive 76 ProgressBook Studentlnformation Import Export Guide The file is fixed width left justified with spaces for padding The file layout will be as follows with the starting point of that field and the length in parenthesis e Campus Number 1 3 e Student ID 4 15 e Student First Name 19 16 e Student Last Name 35 16 e Grade Level 51 2 e Home Room 53 6 The following figure shows an example of the WIN MCM Lunch Program export file E DAHS txt Notepad File Edit Format View Help Hannah DAISY LEE JOBETH GEORGE EVAN LORY ROBERT NICOLE SUZAHHE HARPER JASON WILLIAM J k JOSEPH MICHELLE LYNN MAGNUM P TROY AARON MARY M MICHAEL JAY RICHARD MATTHE THOMAS JOMA REMEE JORDAN DAMIEL PRIV A WHITNEY ANN LEANN JEAN IAM MICHAEL RYAN SETH ELLA JANE Jesse
21. Chapter 5 of the ODE EMIS Manual Student Special Education GE Record Special Education Import Logic 1 If same date type and same event date Studentlnformation will load update the record with applicable fields ProgressBook Studentlnformation Import Export Guide 29 2 lf same date type and different event date Studentlnformation will load add the record with applicable fields 3 If different date type new record regardless of date Studentlnformation will load add the record with applicable fields Special Education event records should be imported for Periods K and N Imports may be done at any time during the school year Special Education Import SpS Student Special Education Graduation Requirement FE Navigation Home Management Import Export Special Education Import SpS Student Special Education Graduation Requirement FE Run Option Student Special Education Graduation Requirement Record Sort Type FE The Student Special Education Graduation Requirement record import will serve as an import of new records if no match exists or an update if a match is found The import file layout of the Student Special Education Graduation Requirement record will be formatted in the FE file record layout as defined in Chapter 5 of the ODE EMIS Manual Student Special Education Graduation Requirement FE Record Special Education Import Logic 1 If the same date type event date and assessment area code St
22. Course Term Calculated as the number of course terms for the current school year that ended before today EffDate date PLUS 1 82 ProgressBook Studentlnformation Import Export Guide For instance if a school has the following terms defined e Quarter 1 e Quarter 2 e Semester 1 e Quarter 3 e Quarter 4 e Semester 2 e All Year In this example the following CourseTerm values would be returned e During Quarter 1 CourseTerm 1 e During Quarter 2 CourseTerm 2 e During Quarter 3 CourseTerm 4 e During Quarter 4 CourseTerm 5 Notice that the 3rd and 4th quarters the CourseTerm values seem to be 1 to high This is because the Semester 1 course term has now ended and it would be included in the count of previous terms that have ended For instance if a school has the following terms defined e Semester 1 e Semester 2 e All Year In this example the following CourseTerm values would be returned e During Semester 1 CourseTerm 1 e During Semester 2 CourseTerm 2 The following figure shows an example of the Student Schedule Information Excelsior Export file A B E D DUU ER 2 2 2 BOO ER 2 2 3 e003 EN 2 2 4 BOO Jr 2 2 5 DUU ER 2 2 5 r001 D 2 2 f r002 OU 2 2 D r003 5 2 2 g r004 OU 2 2 10 r005 St 2 2 11 r001 a 2 2 ProgressBook Studentinformation Import Export Guide 83 Teacher Information Format SC I gt Excelsior Export From this screen you can export data for a specific file format Teacher In
23. Elem ELEE 2 Student12786 BRANDEN 14417 HHHHHHHH 7 16E 08 645 S Main St i 45804 124 10 ELIDA HIG ELHS 3 Student13639 KERSTEIN 13395 HHHHHHHH 7 13E 08 645 S Main St 45804 124 11 ELIDA HIG ELHS 4 Student13359 MAX 14015 HHHHHHH 7 13E 08 645 S Main St 45804 124 10 ELIDA HIG ELHS 5 Student14116 TYLER 13015 HHHHHHHH 7 1EH08 645 S Main St 45804 124 10 ELIDA HIG ELHS Battelle For Kids Export Navigation Home Management Import Export Battelle For Kids Export The Battelle For Kids Export extracts the data for reporting to Battelle For Kids The Battelle For Kids Export produces the following four extract files in Microsoft Excel format 154 School Information Exports information about each school in the district Employee Information Exports information about every employee in the district Student Information Exports information about every student in the district regardless of whether they are withdrawn or actively enrolled ProgressBook Studentlnformation Import Export Guide e Class Roster Information Exports information about each course section assignment including dropped course sections for the students in the district for the school year Only the latest instance of a single course section is reported for a student IIb Battelle For Kids Export From this screen you can export data for a specific file format School Information eTranscripts The eTranscript Transfer extracts st
24. Enter the date on which the test will be administered in MMDDY Y format Teacher required Choose Homeroom Teacher Homeroom Name or Period Teacher for the Teacher value in the export file Testing Period required only if Period Teacher is selected above Select a class period to use for extracting the Teacher value in the export file Student Number required Choose SSID SSN or EMIS Id for the Student Number value in the export file Special Code optional Please see the previously outlined Terra Nova Export File Format for details on this parameter To include the district IRN in the export file enter the district IRN in the Special Code field Inview optional Please see the previously outlined Terra Nova Export File Format for details on this parameter 140 ProgressBook Studentlnformation Import Export Guide Scorable Booklet optional Please see the previously outlined Terra Nova Export File Format for details on this parameter ByPass Bubbling of Name optional Please see the previously outlined Terra Nova Export File Format for details on this parameter Performance Assessment optional Please see the previously outlined Terra Nova Export File Format for details on this parameter Writing Assessment optional Please see the previously outlined Terra Nova Export File Format for details on this parameter Formatting Options for the Terra Nova 2 Edition Please see the previously o
25. Found n in the current building Value Indicates the value which caused the listed error Line Number Indicates which line in the file included the listed value Please Note If you did not check Ignore Load Errors these errors must be fixed in the input file before you can proceed to Step Three If you did check Ignore Load Errors any errors listed will cause those records not to be loaded Records without errors will be loaded Start Over Start Over and go back to Step One Next Ignore the records containing the listed errors and process the remaining records This button is only visible if you checked Ignore Load Errors in Step One ProgressBook Studentinformation Import Export Guide 9 Step Three Marking Patterns In Step Three you will be asked to verify the Marking Patterns and make adjustments as necessary LOAGRADE Import Step Three Marking Pattern Course Section Count Mark One Mark Two Mark Three Mark Four AY All Year Course 1 1st Quarter Interim v ist Ouarter Mark v Not Imported v Not Imported be Import marks for dropped assignments Reporting Term for Comments Mark Type for Comments Marking Pattern The Marking Pattern assigned to the Course Sections that are being imported There could be multiple Marking Patterns present in a single LOAGRADE Import All Year courses Semester courses Quarter courses etc Course Section Count T
26. Guide Accom SS 2 Y yes blank no Accom SS 3 Y yes blank no Accom InView 1 Y yes blank no Accom InView 2 Y yes blank no Accom InView 3 Y yes blank no 170 250 Blank for CTB use only Terra Nova Export School Grade Configuration DASL _Local SD 2010 2011 N This Screen does not use a Selected Student Amy Recker Data on this screen applies to the current school district Find Students n Ki n m Go To Go i Terra Nova Export From this screen you can export a Terra Nova pre identification file Choose the school and student statuses to include in the extract School Select school Available Student Statuses Selected A ACTIVE RES D DELETED ec I INACTIVE N NON RES Select the grade level formatting options for the extract file Formatting options for the Terra Nova Grade Level Select grade Achievement Test Level Select Test Form CAT 5 Test Id CAT 5 Survey Sort Order UNSORTED Testing Date T F Teacher 9 Homeroom Teacher Homeroom Name Period Teacher Student Number SSID D SSN EMIS Id Special Code Inview Scorable Booklet ByPass Bubbling of Name Performance Assessment Writing Assessment Formatting options for the Terra Nova 2nd Edition AA IEP AA 504 AA LEP BB RLA BB MA BB SC BB SS BB Inview BB Algebra Formatting options for the Terra Nova 3rd Edition Barcode Labe
27. Guide 121 File Download Do you want to open or save this file e Name HIGH SCHOOL _STUFEES_Export csv T Type Microsoft Office Excel Comma Separated Values File From dev webi noacsc org While files from the Internet can be useful some files can potentially harm your computer Ifyou do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive The file format is CSV Comma Separated Values The file layout is as follows e Accounting Code enclosed in quotes Please note that the Accounting Code can be defined as up to 8 characters in Accounting Code Maintenance However the USAS STUFEES Import only accepts 6 character Accounting Codes If you are using the Studentlnformation STUFEES Export with the USAS STUFEES Import you will want to change your Accounting Codes to a maximum of 6 characters in Accounting Code Maintenance e Amount e Student Number e Student Name enclosed in quotes e Date YYYYMMDD format e Comments enclosed in quotes The following figure shows an example of the STUFEES Export file File Edit Format View Help EMS 1000 118128 Student36423 Elizabeth 20081210 3064 MUT 1200 98026 Student38105 James 20080819 371351 10M 1500 98026 Student38105 James 20080819 371351 122 ProgressBook Studentlnformation Import Export Guide AIR Export Navigation Home Management Import Export AIR Export On August
28. Name Last Name Gender Grade Level Code Home School Irn Home School Program Code Math ASED XXXX85 QT346XXXX JUSTIN dXXXX Math ASED XXXX00 PS487XXXX AARON FXXXX Math ASED XXXX89 PS495XXXX RYAN HXXXX Math ASED XXXX68 OW272XXXX CODY MCCXXXX Math ASED XXXX07 PS519XXXX LUKE MCFXXXX Math ASED XXXX35 ON121XXXX JOSEF MXXXX Math ASED XXXX02 SG648XXXX CHRISTOPHER SXXXX Math ASED XXXX34 PS559XXXX MICHAEL UXXXX 10 Math ASED XXXX15 ONS974XXXX ANTHONY HXXXX 11 Math ASED XXXX28 ON118XXXX SUSAN KXXXX 2 3 4 5 6 7 8 9 TSS S 8 5 5 5 5 5 UU BRU BB bb Staff List The Staff List option creates the DataMap Staff csv export file The DataMap Staff csv export file contains the following columns e Staff Name e Staff Code e State Staff ID e Job Function e Address e Address Line 2 e City e State e ZipCode e Telephone The following figure shows an example of the Staff List output file H l IStaff Code State Staff ID Job Function Address Address Line City State Zip Code Telephone LASTR FIRSTR HJRB Teacher LASTS FIRSTS HTJB Teacher LASTT FIRSTT DKIC Teacher LASTU FIRSTU DMAC Not Specified LASTV FIRSTV TLLC Teacher LASTW FIRSTW DCAC Not Specified LASTX FIRSTX HKXR Teacher LASTY FIRSTY HRAD Teacher LASTZ FIRSTZ HIIE Teacher 2 3 A 5 6 8 9 e 150 ProgressBook Studentlnformation Import Export Guide Student List The Student List option creates the DataMap Student csv export file The DataMap Student c
29. Not Attributes provided match two or more Assigned existing records and uniqueness cannot be determined SID and 4 attributes Do Not Exist Nor Attributes provided do not match existing Records Updated record One Match Exists SID Record Attributes provided match one existing Updated record and attributes are updated Missing or Invalid Data One or more edit check failures SID Inactive Correct SID Returned SID submitted is inactive and valid SID is returned Attributes of the Valid SID do not SID submitted is inactive and valid SID match the Inactive SID exists however last name first name date of birth or gender in the file do not match the attributes of the active Valid SID No Match Exists SID Not Returned Attributes provided do not match existing record for those records with an Existing otudent Code of Y New SID not assigned Invalid Attributes provided do not match existing Admission Reason Code record however new SID is not assigned because invalid Admission Reason Code submitted 6 or 7 SID Inactivated SID provided has been inactivated LOAGRADE Import Navigation Home Management Import Export LOAGRADE Import ochools use a variety of third party grade book packages external to the Studentinformation application Data may be transferred to Studentlnformation if the grade book program can create a file in the following format This process was called LOAGRADE in SIS and was used to con
30. OOo FONT CeO A OCC PORN SOM ed MOCKINGBIRD LANE ATTICUS FINCH 43193452234512585 1030 BAGNUE P 555111222218870403 ELLA JANE GEORGE EWAN 122 NORTH 3T EDWARD ETE Jain N FRONT 3T 2001 JANE Foe 1961024 ONT 507 STATE STREET 45401 HOWARD JOHNSON 15850513 ODOOAOOAPOTTS NIDOSOOSVELLS BODO AUOSELUYVER ODOSOOLCONTRAEY UU SU FERRY CeO SOs POTTS OMOOOSODAEPRAT D C D O OOOOO O EN or ot EA C z el D0000 SUO SNELLS OCRODOSOJLETE Onno soos POT UCFOD Oo CaM Bad OCRODOSOTA LINE aaononosoOo5NAT ORDO OL OO THART DORSDUD POJE FERRY DORSDUD 7003 RING ORDO PULO GS ARGENT ULODO OO SB ELLIARTSON DODI22445EYE 48652258Eanana Jan CO LC ont Care D4R65228lConrrary ProgressBook Studentinformation Import Export Guide JORDAN DANIEL JODETH THORAS HARY B BICHAEL JAT TAM HICHAEI JACE JOSEPH JONA RENEE CORY ROBERT RICHELLE LYN SULTHEY AME TROY AARON DAISY LEE VAS WILLIAR RICHARD HATLIHE NICOLE SUZANNE LEANH JEAN 7612 ELEHDCH PLACE Ba3 NORINWALD DE Bu MISSISSIPPI RID B ELE STREET Th BEDADWAY BLVD 632 BLENDON PLACE Ban RACON TRAIL Bas NORINWALD DE 665 SUGAR STREET 600 ELOGH DRIVE DU ELE STREET Tro BROADWAY BLWVI S065 BLISS RD lad Biotop Ztreet 091 THATER ROAD 123 SECRET AVE 21117 Cherry Street in EUITE 100 DAVID POTTS MITCH WELLS NARE TWAIN HARION CONTRART NATIMEV FERRY DAVID POTIS JOLENE TEEECE RESCH WELLS EDWARD EYE JANE FONT WILLIAN JONES BOB LINE ZHARON LEE HWABION CONTPRAET HA
31. Only Do Not Perform Import Processing will only create the import verification file and not actually do any imports The verification file will be named StudentAttendanceVerificationFile xxxx txt where xxxx is your building code IMPORTANT It is strongly suggested that you run this option first to check for errors This option will also perform the student identifier check e Perform Student Identifier Check Only Do Not Perform Import or Create Verification File Processing will only check the import records for a student match and show any students that did not match onscreen It will not produce a verification file or import any records Student Student Name Error Message 088761 4 T EVAN Student not found Nothing will be imported Primary Student Identifier for Import required Choose State Student ID SSID or EMIS ID The default is SSID If the user chooses SSID then the import will first try to match the student on SSID and if no match is found it will try to find a match on the EMIS ID If the user chooses EMIS ID then the import will first try to match the student on EMIS ID and if not match is found it will try to find a match on the SSID If no SSID or EMIS ID match is found the record is not imported and an error record is added to the onscreen summary or verification file depending on which option the user has chosen l Your selection will be determined by which ID the JVS used in the export file If the J
32. P T Lo LA e k a CI E po o istrict tudent Yumber USIL Statewide Student Identifier SSID assigned by ODE Description Comments Accentable values m K 4 Date of Birth Year Och ee nie ke TIE District Mame position 500 Required Optional 31x digit District contains on L materiale and pre ID labels will be shipped to the Attending Dein ct Community schools nonpublic schools may use the Attending School RN to populate the Attending Distinct IRN field JVSDs should populate the Attending District IRN with either the JVSD IRN or the CTC school IRN depending upon where they want pre D labels and testing materials shipped If score reports should be made available to a diferent education agency then the new optional field named Home District IRN must also be completed Six digit School IRN contains only numenc values 0 9 IF score reparte should be made available to a different education agency then the new optional field named Home Schoo IRN must also ba completed Alphafnumenc Must correspond to Attending District IRN and be consistent with district name as listed in the Ohio Educaton Directory System DEDS Alphafnumenc Must corraspond to Attending School IRN and be consistent with school name as listed in QEDS Alpha This is the last name that will be used when reparting student assessment results Alpha This is the first name that will be
33. Preldent for Science and Social 111 Added section Studies 14 6 2 Preldent for PARCC Student N A Added section Registration File 14 5 2 Preldent for KRA 109 Added section 14 5 0 STUFEES Export 121 Updated image to show renamed multiselect lists 14 4 3 Home School Import Course 12 Corrected file format errors History 14 4 3 Special Education Import SpS 24 Removed Reporting Period field description and updated image 14 4 3 Home School Export Course 49 Corrected file format errors History 14 3 0 Home School Import Course 12 Added IsDualCredit and History IsCollegePrep rows to file layout 14 3 0 Home School Export Course 49 Added IsDualCredit and History IsCollegePrep rows to file layout 14 3 0 e Transcripts 155 Updated image and procedure to reflect change in menu structure Added sections for new GPA Set Options FJ screen and Graduation Core Summary Record GC screen 14 2 2 Preldent for Ohio Online Field 107 Added section Test 14 2 1 Pre Identification Export 86 Added general explanation of pre ProgressBook Studentinformation Import Export Guide identification exports Product Version Heading Page Reason 14 2 1 Preldent for PARCC 106 Added section 14 2 0 Global N A Updated Heading 1 2 and 3 formats to match ProgressBook Suite formatting Removed outline numbers to conform to heading format of the ProgressBook Suite Removed import exp
34. RES M Students must have an SSID on their current FS record to be included in the extract Schools Available optional Move one or more schools from the Schools Available select box to the Schools Chosen select box If no schools are moved to the Schools Chosen select box all schools will be selected Grade Levels Available optional Move one or more grade levels from the Grade Levels Available select box to the Grade Levels Chosen select box If no grade levels are moved to the Grade Levels Chosen select box all grade levels will be selected Student Statuses Available optional Move one or more student statuses from the Student Statuses Available select box to the Student Statuses Chosen select box If no student statuses are moved to the Student Statuses Chosen select box all student statuses will be selected IMPORTANT Students must have an SSID on their current FS record to be included in the extract 124 ProgressBook Studentlnformation Import Export Guide Choose students by student numbers Choose students by filters Choose students by student numbers Choose students by ad hoc membership Enter a comma Separated list of student numbers to include in the extract 0005743 00005745 123123123123 F Validate Student Numbers Students must have an SSID on their current FS record to be included in the extract Enter a comma separated list of student numbers to include in the extract re
35. Type Text Document From dsldemo mcoecn org While files from the Internet can be useful some files can potentially harm your computer If you do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive The export file is fixed width with spaces for padding An example of the output is shown in the following figure DASL HIGH SCHOOL DAHS DASL LOCAI DASL HIGH SCHOOL DAHS LICONTRARY JASON WIL 369852369 02141990M 1 1 ProgressBook Studentinformation Import Export Guide 105 Preldent for PARCC Navigation Home Management Import Export Pre Identification Export Preldent For PARCC dropdown You can only run this export at the district level The export file is in CSV format Ib Home Management Import Export Pre Identification Export 106 1 Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools DAJH DALTON INTERMEDIATE DAKI KIDROM ELEMENTARY DADA DALTON ELEMENTARY DAHS DALTOM HIGH SCHOOL Export Format PreIdent For PARCC English amp Language Arts ELA Subject Codes Available Subject Codes Selected DAHS 002 03 ENGLISH 10 DAHS 001 08 ENGLISH 9 DAHS 002 07 ENGLISH 10 4 DAHS 002 01 ENGLISH 10 DAHS 002 08 ENGLISH 10 DAHS 003 01 ENGLISH 11 Mathematics MAT Subject Codes Available Subject
36. Type to Export drop down list select Teacher 10 Repeat steps 4 through 8 to create and save the teacher export file 11 In the Choose KRA Pre ID Type to Export drop down list select Enrollment 12 Repeat steps 4 through 8 to create and save the enrollment export file 110 ProgressBook Studentlnformation Import Export Guide Preldent for Science and Social Studies Navigation Studentinformation Management Import Export Pre Identification Export Preldent For AASWD and OCBA dropdown This pre identification export is for the following science and social studies assessments e Ohio Computer Based Assessments OCBA in Science and Social Studies e Alternate Assessment for Students with Significant Cognitive Disabilities AASCD AASWD You can only run this export at the district level You can choose to create a single export file containing students for both assessments or you can create separate files for each assessment The export files are in txt or fixed format and only include students with state student IDs SSIDs Note If you have students who will take the alternate assessment you need to create an ad hoc membership for them prior to running this export For more information on ad hoc groups see ProgressBook Studentinformation Getting Started Guide Studentinformation gt Management gt Import Export gt Pre Identification Export Pre Identification Export From this screen you can exp
37. View Help LAST NAME FIRST NAME BIRTH DATE GENDER GRADE BUILD LOGR LOGR COGA COGA ELLERBROOK TIMOTHY 01 03 1994 M 1 das1 A 05 6 A EITEMILLER KENDELL 03 04 1994 M 1 das1 A 05 6 A ERIKSON ERIC 04 09 1994 M 1 das1 A 05 6 A EICHER KELSEY 06 03 1995 F 1 das1 A 05 6 A 88 ProgressBook Studentlnformation Import Export Guide 1 At the top of the screen select the school s to include in the export by moving them from the Available Schools in District multi select list to the Selected Schools list A single export file will contain data for all selected schools 2 Inthe Export Format drop down list select Riverside ITBS Pre Identification Export Select the appropriate Grade Level Enter the Building Name For the Layout option select a Long or Short layout format eee IY a Is If you chose a Short layout select the correct Logramos ITBS Form Logramos ITBS Level CogAT Form and CogAT Level 7 Click Export and save the file Preldent for Pearson Educational Measurement Export Navigation Home Management Import Export Pre Identification Export Preldent for Pearson Educational Measurement Export dropdown Studentinformation returns course information in the Ohio Achievement Assessment and Ohio Graduation Test export files based on the value in the EMIS Subject Code field on the EMIS Override tab for a course section if defined otherwise Studentinformation returns course info
38. any Special Codes are to be considered critical Critical Special Codes must be numeric others can be numeric or blank The number of codes used depends on the test Note the following NOTE To include the district IRN in the export file enter the district IRN in the Special Code field Test No of Codes Positions CAT 5 9 95 103 SABE 2 8 95 102 Terra Nova 10 95 104 Terra Nova 2 Edition 10 95 104 Terra Nova Algebra 10 95 104 InView 10 95 104 Note If you order the CAT 5 MAP report and you use the CAT 5 Listening and Speaking Checklist you may have teachers encode Listening and Speaking scores on each student s CAT 5 answer document answer sheet Student Information Form or the biographical data page of a machine scorable booklet and have this score reported on the MAP To reserve a column for this score specify that the column must be blank in your precoding file The normal column for this score is column S byte 103 however you can reserve any column in the range K through S bytes 95 103 for this purpose 105 110 111 113 Test ID numeric The test ID codes are as follows CAT 5 Survey 028 CAT 5 Survey with TCS 2 029 CAT 5 Complete Battery 030 CAT 5 Complete Battery with TCS 2 031 CAT 5 Short Form 032 CAT 5 Short Form with TCS 2 033 SABE 2 Levels 1 6 034 SISS Student Information amp Score Sheet 039 Co NI ProgressBook Studen
39. associated with the school IRN specified in the Home School IRN field on the Student Profile General tab Home School Required field Size digit school IRN contains IRN only numeric values 0 9 Enter the IRN of the school where the student was last tested for the OGT Use the value of the Home School IRN field on the Student Profile General tab Home district Optional field Aloha numeric Must correspond to Name home district IRN Use the district IRN associated with the school IRN specified in the Home School IRN field on the Student Profile General tab Home School Optional field Aloha numeric Must correspond to Name Home School IRN Use the name associated with the School IRN specified in the Home School IRN field on the Student Profile General tab Name student Name student Initial middle name ProgressBook Studentlnformation Import Export Guide OHIO TEST Record Description for Student Data Files Position Position Length month DD Year YYYY 203 Statewide Required field between September 15 and April Student Identifier 30t of every year State assigned Student ID only SSID Combination of alpha and numeric must start with two alphas followed by numeric 0 9 SSID of the student as specified on the latest FS record for the student Terra Nova Export Navigation Home Management Import Export Terra Nova Export The Terra Nova Export is used to create a pre identific
40. being tested in enrolled grade Blank Not Indicated assume student rs being tested in enrolled grade Humenc If accelerated testing flag is Y indicate the grade level at which the student is tested Musi be numeric Valid values are 05 and OD Accelerated testing grade must bo higher than student s enrolled grade Alpha indicate whether the student will be administered a test in an accelerated grade level a grade level higher than the student s enrolled grade Y Yes student is being tested in an accelerated ade M No student is being tested in enrolled grade Blank Not Indicated assume student m being tested in enrolled grade Numeric lf accelerated testing flag is Y indicate the grade level al which the student ig tested Must be numeric Valid values are 05 and OP Accelerated testing grade must bo higher than student s enrolled grade A nha nurnerc Uisticts may provide teacher credential IU numbers so that teacher level results can be tracked across test administrations Alpha numeric Districts may provide teacher credential ID numbers so that teacher lavel results can be tracked across test administrations Alpha numeric Districts may provide teacher credential ID numbers so that teacher level results can be tracked across test administrations Alphanumeric Districts may provide teacher credential ID numbers so that teacher level results can be tracked across test administrations Alphanumeric Districts may pro
41. ei e sie sie ee ci Hj e ei us 9372725454 4193452345 4192287417 5551112222 4192287417MARION CONTRARY 4192287429 4192228888 4195559876 SHARON LEE MITCH WELLS HOWARD JOHNSON EDWARD EYE NICHOLAS RING ATTICUS FINCH MARION CONTRARY JOLENE TREECE JANE FONT EDWARD EYE BOB LINE MATTHEW PERRY MATTHEW PERRY MARK TWAIN MITCH WELLS DAVID POTTS BLU EYE WILLIAM JONES SAM SARGENT DAVID POTTS JOHN WILLIAMSON JANE FONT tu td D D D D D bd bd D D D D D cd td DD DD D D D D oa on onn HH abba aa p p mH RH a HR Hp H H EDUDA SEQ WordPad Edit View Insert Format Help la Slo 4 kel Gb 112004410805 4013411535 00000000 OoO000000 0920044103 4009 ooooo0000 OoOo000000 1020044105 OOOOOOOO OoO0000000 1220044109 00000000 oo000000 122004410910 00000000 ooo00000 1020044105 ooo00000 OO000000 0920044103 00000000 OoO0000000 092004 Wd ooooo0000 OOO0000O0 092004A103 ooooO0000 OoO000000 112004410704 00000000 OoO0000000 1020044105 00000000 OoO000000 1220044109 ooo00000 OoO000000 1020044105 00000000 OoO0000000 112004410703 00000000 oo000000 112004A107 ooooo0000 OoO000000 D92004A103 00000000 OoO0000000 112004 Loa 00000000 oo000000 112004A107 ooooo0000 OoO000000 1220044109 00000000 OoO0000000 1120044107 00000000 OoO000000 1020044105 ooooo0000 OoO000000 0920044103 OOOOOOOO OoO0000000 1120044107 00000000 oOo000000 0920044103 00000000 ooo00000 1220044109 ooo00000
42. file The verification file will be named StudentVerificationFile xxxx txt where xxxx is your building code e Create Verification File Only Do Not Perform Import Processing will only create the import verification file and not actually do any imports The verification file will be named StudentVerificationFile xxxx txt where xxxx is your building code IMPORTANT It is strongly suggested that you run this option first to check for errors This option will also perform the student identifier check Note Changes made to EMIS Situation and the remaining fields on this tab are saved to the profiles of the imported students Admission Date required Choose the date the students will be admitted This date must be between the first and last day of the school calendar year in context Admission Reason required Select the reason the students will be admitted If you select one of the following codes you must enter a value in the Admitted From IRN field per EMIS requirements ProgressBook Studentinformation Import Export Guide 21 e 3 Student transferred from nonpublic school in Ohio e 6 Transferred from other Ohio public district community school e Not newly enrolled in this school district Otherwise the Admitted From IRN field is not editable and defaults to Student Status required Choose the appropriate status for the students EMIS Situation required Choose from a drop down list or u
43. following figure shows an example of the Course Detail Information Excelsior Export file hi hi KRKI KJ 553135 553135 g 1 1 1 1 2 2 2 2 3 3 4 4 4 4 5 5 5 5 5 5 b b E G ProgressBook Studentinformation Import Export Guide 79 Course Information Format Excelsior Export From this screen you can export data for a specific file format Artificial Course Course Type Artificial Course Filter exported data by artificial course status or select Filter Not Used Course Type Filter exported data by course type or select Filter Not Used Export Execute the Export process Fields included in the export are the following e Course ID e Course Credit Units e Course Hours of Instruction e Course Short Text The following figure shows an example of the Course Information Excelsior Export file L 120 CBI ENGLISH 10 120 CBI HISTORY 10 DUU CBI 12 JOB 120 CBI 12 RELATED 120 CBI T2 MATH 120 CBI 12 ENG 120 CBI 12 HISTORY 120 CBI 11 MATH 120 CBI RELATED 10 240 CEI EMPLO Y ABILI 2 S A 5 5 P S s Cc GI CO Fa Lu bi C L 80 ProgressBook Studentlnformation Import Export Guide Student Data Format Student Statuses Excluded Included Select the Student Statuses to be filtered on and move them to the Included box in the dual select box If no Student Statuses are Excelsior Export From this screen you can export data for a specific file format
44. most recent record missing an SSID until it finds a record with a non blank value for SSID Example 1 In this example the 8 1 FS record and 7 15 FS record would get the SSID loaded when the import is processed e 8 1 2008 FS record no SSID e 7 15 2008 FS record no SSID e 7 1 2008 FS record SSID Example 2 In this example only the 8 1 FS record would get the SSID loaded when the SSID Import is processed because the 7 15 FS record already has an SSID The 7 1 FS record is missing an SSID however the SSID that should be filled in there is the one from the 7 15 record This will need to be corrected manually e 8 1 2008 FS record no SSID e 7 15 2008 FS record SSID e 7 1 2008 FS record no SSID IIb State Student ID Import Please select the State Student ID file to import File name Browse Browse to the location of the File Name to be imported Verify Execute the Import The verification messages will include a Result Code translation shown in the following table The most current result codes can be found in the SSID User Manual located at https www ohiossid com ssid help control asp 6 ProgressBook Studentlnformation Import Export Guide Result Description Possible Reason for Outcome Code No Match Exists New SID Attributes provided do not match existing Assigned record One Match Exists SID Returned Attributes provided match one existing record Multiple Matches Exist New SID
45. of Birth Month MM 2 Date of Birth Day DO E Pal E M F f P T Lo LA k i h istrict tudent Yumber USIL pa Statewide Student Identifier SSID assigned by ODE Description Comments Accentable values m K 4 Date of Birth Year Och ee nie ke TIE District Mame position 500 Required Optional 31x digit District contains on L materiale and pre ID labels will be shipped to the Attending Dein ct Community schools nonpublic schools may use the Attending School RN to populate the Attending Distinct IRN field JVSDs should populate the Attending District IRN with either the JVSD IRN or the CTC school IRN depending upon where they want pre D labels and testing materials shipped If score reports should be made available to a diferent education agency then the new optional field named Home District IRN must also be completed Six digit School IRN contains only numenc values 0 9 IF score reparte should be made available to a different education agency then the new optional field named Home Schoo IRN must also ba completed Alphafnumenc Must correspond to Attending District IRN and be consistent with district name as listed in the Ohio Educaton Directory System DEDS Alphafnumenc Must corraspond to Attending School IRN and be consistent with school name as listed in QEDS Alpha This is the last name that will be used when r
46. pb in is participating in accelerated testing a Optional 97 reld Ber 1 Accelerated Testing Indicator Mathamatics Accelerated Testing Grade Mathematics Accelerated Testing Indicator Socal Studies Accelerated Testing Grade Social Studies Accelerated Testing Indicator Suence Accelerated Tasting Grada Science Teacher Identification Number Writing Teacher Identification Number Mathematics Teacher Identification Number Social Studies Teacher Identification Number scence ZO Course Code soclal Siudies 20 Course Gode Science 6 Home School IRM 30 Home District Name Home School Name 98 Camrments Acceptalble values Alpha Indicate whether the student will be administered a test in an accelerated grada level a grade level higher than the student s enrolled grade Y Yes student is being tested in an accelerated grade N Na student is being tested in enrolled grade Blank Not Indicated assume student is being tested in enrolled grade Numeric If accelerated testna flag is Y indicate the grade level ai which the student is tested Must be numeric Valid values are 3 04 05 06 07 and Accelerated testing grade must be higher than student s enrolled grade Alpha indicate whether the student will be administered a test in an accelerated grade level a grade level higher than the student s enrolled grade Y Yes student is bein
47. test administrations Alphanumeric Districts may provide teacher credential ID numbers so that teachar level results can be tracked across test administrations aha nurneric Uistnicis may populate this held course cade Alphanumeric Districts may populate this field with tha writing course coda A nha numernc Uisticts may populate this feld with i mathematics course code Alphanumeric Districts may populate this field with the sclence course code Alphanumeric Districts may populate this field with the social studies course coda Six digit District IRN numeric 0 9 If this field rs filled out student ecoro roporte will bo mado availablo to the indicated dictrict Six digit School IRN numeric 0 9 If this field is filled out student score reports will be made available to the indicated school Alphanumeric Must correspond to Home District IRN Alphanumeric Must correspond to Home School IHN ProgressBook Studentlnformation Import Export Guide Pe Lec Optional unless student is participating in accelerated un pam kodeni is parbcpatna in accelerated unless student is participating in accelerated unless shaker is participaling in accelerated testing uniess student is participating in accelerated tacit Required for JYSD etudonte Optional for other students Optional Required for JVSD students Opbux ral for other students Optional At this time the export fi
48. that student schedules are up to date when they create the file so that the results will be returned to the correct teacher once the vendor sends the test results back to the districts Previously Pre Ident was only including students who had an overall internal student status of Active This has been changed in the 8 2 0 release to now include actively enrolled students regardless of their status code Therefore it is no longer necessary to change the internal value of your status codes for students to be included in the file As of DASL 9 0 1 8507 the OAA Pre Ident is only accessible by districts If the OAA Pre Ident is accessed with a building in context the following message will be displayed IIb Pre Identification Export This page is not available for your Working School This page can only be accessed for Districts As of 10 3 0 16150 students without SSIDs will display in a list at the bottom of the page and give the user the option to continue excluded the students in this list from the export or cancel The user can also click on the student information and have a window pop up with the Student Profile Edit screen 90 ProgressBook Studentlnformation Import Export Guide IF Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools Elementary School HIGH SCHOOL ELEMENTARY SCHOOL Export Format Preldent For Pearson Educational Mea
49. the required format for import student data into Edulog Each district using Edulog and importing student data from Studentlnformation presently has different requirements for address formatting and determining various codes in the file The export will give the districts various selections for formatting of the export files See also Ad Hoc Reporting Note As of DASL v10 0 when the Edulog Export is run before the first day of school it uses the first day of school to look up the EMIS FS and FD data Ib Edulog Export From this screen you can export data for a specific file format Select an Export Format Select an Export Format ELIDA EDULOG BATH EDULOG WAYNE TRACE LIMA CITY EDULOG GENERAL EDULOG FORMAT ProgressBook Studentinformation Import Export Guide 59 Elida Edulog Navigation Home Management Import Export Edulog Export ELIDA EDULOG Edulog Export From this screen you can export data for a specific file format ELIDA EDULOG k District DASL Local SD School Year 2007 2008 Please Note For projections change context to the new year Action 6 All Students O Student updated since last run date wT Include the deleted students since last school year Export Action required Choose All Students or only Students updated since a specified last run date Can also choose whether to include the deleted students since last school year Export E
50. used when reporting student assessment results Alpha This is the middle initial that will be used when reporting student assessment results Required Required Hequirad require Hequirad Required Required Required strict or School assigned 5 A nine character Opticona identifier first character may be numeric 0 9 or alpha 4 2 All ining characters must be numeric 0 9 State assigned Student ID only A nine character identifier first two characters are alpha all remaining characters are numere Required for public school students egurre Required Required American Indian 2 AsianiPacific Islander 3 Black African American 4 Hispanic 5 White 6 Multi racial T Other Unknown uUi E n Room Number Alphanumeric popi sss o o ProgressBook Studentlnformation Import Export Guide Y z Migrant Student W Not Unknown 101 el tequired 153 162 10 Glass Name Course Mame Alpha numeric This field will be used to report the name of the Reading 163 Bf 5 Section Number Reading 20 Teacher Name Reading 10 Glass Mame Course Name Wntng ca E Section Number Wining k ec Pra J n hel Mel LA in CH CH Teacher Name V riting Glass Name Course Name Mathematics 233 237 Section Number Mathematics 238 25 20 Teacher Mame Mathematics 258 267 lO Glass Name Course Name Social Studies 212 Section Number Social Studies 27
51. 006 12 00 0 00 AM 12 22 2000 1 12 00 00 AM O mosse 12 00 00 AM SAWYER THOMAS K MISSISSIPPI LIMA 45804 eem 12 00 00 AM 2 00 15 20 2006 12 00 00 AM 12 22 2006 12 00 00 AM 0 12 20 2006 12 00 0 Creating the form letters in Word using Mail Merge If you need to create the initial form letter use the following instructions 1 Open Word 2 Click on Tools e Mail Merge e Create e Form Letters e Active Window e Get Data e Open Data Source e Check the box labeled Select Method e Down arrow in the box labeled Files of type e Text Files 3 Open the Export file such as DAHS txt 40 ProgressBook Studentlnformation Import Export Guide 4 Inthe Confirm Data Source box select Text Files txt and click OK 5 Click on Edit Main Document You should now be back to your blank document with a mail merge tool bar across the top Begin typing your letter At locations where you would like to use data from the DAHS txt file place your cursor in the appropriate position and click Insert Merge Field This will list all fields available listed in the following table Click on the field you want and a token will be placed in your letter Continue to type letter and place tokens until the letter is finished Click on Mail Merge Helper the icon on your mail merge tool bar that looks like two documents and sign If you would like to use just specific records from the file for example expulsions only or sort the data click on Qu
52. 15 Student Grade Level 83 2 Student Primary Contact 85 30 Student Address 1 115 30 Student Address 2 145 30 Student Address 3 175 30 The following figure shows an example of the Meals Plus Point of Sale Version 2 export file ProgressBook Studentinformation Import Export Guide P EC DAHS txt Notepad File Edit Format View Help 48652258 Hannah Rose 2117 Cherry street DAISY LEE 600 BLOOM DRIVE JOBETH 843 NORTHWALD DR GEORGE EVAN 597 STATE STREET CORY ROBERT 12 NORTH ST NICOLE SUZANNE 9065 BLISS RD HARPER 23 MOCKINGBIRD LANE JASON WILLIAM 90 ELM STREET JACK JOSEPH 890 BACON TRAIL MICHELLE LYNN 345 N FRONT ST MAGNUM P 122 NORTH ST TROY AARON 665 SUGAR STREET MARY M 90 ELM STREET MICHAEL JAY 776 BROADWAY BLVD RICHARD MATTHE 775 BROADWAY BLVD THOMAS 89 MISSISSIPPI RD JONA RENEE 843 NORTHWALD DR JORDAN DANIEL 7632 BLENDON PLACE PRIVA 123 SECRET AVE WHITNEY ANN 702 BRISTOL LEANN JEAN 123 Bigtop Street IAN MICHAEL 7632 BLENDON PLACE RYAN SETH 881 THAYER ROAD ELLA JANE 345 N FRONT ST 48652281 Jesse 645 S Main Banana E MAY WELLS JOHNSON EYE LEE CONTRARY SPRAT FONT EYE LINE CONTRARY PERRY PERRY SAWYER SUITE 100 WELLS POTTS EYE JONES SARGENT POTTS WILLIAMSON FONT contrary O8171987FW 10041 988Fw 12231986FW 09131986MH 07161989Mw 05111989Fw 10301989Fw 02141990Mw 02021988Mw 01051989Fw 04031987Mw 02021989Mw 1117
53. 192287429MARK TWAIN MITCH WELLS DAVID POTTS 4192228888BLU EYE WILLIAM JONES 41955598768AM SARGENT DAVID POTTS JOHN WILLIAMSON JANE FONT Si ei ej Uj Ud ei e ei ei ei ei e ei ei ei ei e ei ei e m ei ei ei JUTU IUS LOOL2 00502205 LOO k200S0 205 icnAz dso1205 1004200501205 100R200501205 icn0Az d501205 IODA 00S09015 LOOM 00504125 ionAzagsnmis05 lo0Az 0501245 1004200501205 LOO R2 00502 145 icn0Az d501205 ionaszd0501205 i1o00A200501205 ionAzagsnmnis05 lo0Az ds01z05 io04A200501205 1O0R200501205 icn0Az d501205 io0Akz00501205 LOO KE OCHO 12 05 innizasmi205 z 0504145 General Edulog Format Navigation Home Management Import Export Edulog Export GENERAL EDULOG FORMAT IIb Edulog Export rom this screen you can export data for a specific file format GENERAL EDULOG FORMAT Local 5D School Year 2009 7010 Please Note For projections change context to the new year Effective Homeroom Date 1 11 2010 vw E Action All Students O Student updated since last run date E Include students withdrawn prior to Effective Homeroom Date Export Fields StudentNumber Flag HomeroomName WithdrawalDay LastName Flag3 ProgramCode TransferDate FirstName Flag4 Disability Condition DiplomaCentury GradeLevelCode 4 Flag5 LockerNumber DiplamaYear Address CalledName Combination DiplomaMonth Address State PreviousSchool DiplomaDay City AreaCode TransferToSchoo l EthnicCode Z
54. 1987FW 1204198 Mie 04241989Mw 10291989Mw 03171988Fw 08011986Mw 11121989Fw 08141989FB O9301989FB 0920198 7Mw 10151989Mw 10241986Fw 04042005M Lima OH LIMA OH LIMA OH LAYMAN LIMA OH LIMA OH LIMA OH LIMA OH LIMA OH LIMA OH LIMA OH LIMA OH LIMA OH LIMA OH LIMA OH CASTLE LIMA OH LIMA OH LIMA OH LAYMAN LIMA OH LIMA OH LIMA OH CASTLE LIMA OH LIMA OH LIMA OH LAYMAN LIMA OH Lima OH LOSHARON LEE 12MITCH WELLS 1 12HOWARD JOHNSON 1 lOEDWARD EYE QONICHOLAS RING QOATTICUS FINCH QOMARION CONTRARY 1 11JOLENE TREECE LOJANE FONT 12EDWARD EYE 1OBOB LINE 1 11MARION CONTRARY 11MATTHEW PERRY QOMATTHEW PERRY 11MARK TWAIN 4 11MITCH WELLS 12DAVID POTTS 11BLU EYE LOWILLIAM JONES QOSAM SARGENT 1 11DAVID POTTS OS9IOHN WILLIAMSON 79 WIN MCM Lunch Program Navigation Home Management Import Export Lunch Export WIN MCM Lunch Program Lunch Export From this screen you can export data for a specific file format WIM MICM Lunch Program bul Student Statuses Excluded Student Statuses Included A ACTIVE RES D DELETED a I INACTIVE 4 p M NON RES Export Fields Campus Number W First Name Grade Level Homeroom Name Student Number Last Name Student Statuses Excluded Student Statuses Included required Choose the Student Statuses to be included or excluded in the Export Campus Number optional The
55. 22 2007 a memorandum was sent by the Office of Career Technical and Adult Education stating the following The Ohio Department of Education is aware that JVSD s must obtain OGT score data on incoming students as early as possible ODE s vendor for the OGT now has a provision to allow the American Institutes for Research AIR to share student OGT scores directly with JVSDs for students enrolled in a JVSD when permission is granted to share such data The process being developed requires written permission from the parent guardian or student if older than age 18 An extraction is available in Studentlnformation to provide this file to the JVSD for submission to AIR The AIR Export is processed at the district level However the AIR Export functions differently if the school in context is a JVSD versus a home school district AIR Export Home School District in Context Navigation Home Management Import Export AIR Export Home School District in context From this screen you can create an AIR export file A home district must choose the JVS district and JVS to include in the extract JVS District lf JVS JE Choose students by filters Choose students by student numbers Choose students by ad hoc membership Use the filters below to choose the students within the district to include in the extract Schools Available Schools Chosen ELEMENTARY HIGH SCHOOL Grade Levels Available Grade Lev
56. 3 292 Teacher Name Social Studies 293 302 10 Class Mame Course Nanta Science 307 Section Number Science A Teacher Name Science Accelerated Testing Indicator Reading 303 3n Accelerated Testing Grade Accelerated Testing Grade Writing Ea EA hal es Pat ca en Ca in 102 class ar course an reading teacher reports Je g Reading English Literature Class Name Gourse Name Section Number and Teacher Name are optional However no classroom level report will ba generated if ALL tha three falds ara laft blank Alphainumeric This field will be used to report the section number of the class or course on reading teacher rep og 01 02 JA Alpha last name first name This field will ba used to report the teacher name on reading reports Alpha numeric This field will be used to report the name of the class or course on writing teacher reports e g Wnting Composition Creative Wribng Class Name Gourse Name Section Number and Teacher Name are optional However no classroom level report will be generated if ALL the three fields are left blank Alphaiumenc This field will be used to report the section number of the class or course on writing teacher reports e g 01 02 JA Alpha last name first name This field will ba used to report the teacher name on writing teacher reports Alpha numenc This field will be used to report the name of the class or course on mathematics teacher reports e g Mathematics Alge
57. 4m43 MORTHWALD DH TERTI iT 0 ELM STREET TOATI 24990 ELM STREET 64 IHR IG BROADWAY MVO LOSTHORIATIS BBOADWAY ELVD BOTE GA 637 BLEHDON PLACE BOOT SE 637 BLEHDON PLACE 4231237859550 BACON TRAIL 453123789590 BACOH TEAIL 423476123543 MORTHAELD DR 4234761235843 pret D DR lTBTA 612127 MORTH ST MCK Lar ri MORTH ST ORS a a M FRONT ST FORE a M FRONT ST 4558 69300 9 STATE STREET 455876930039 STATE STREET 5563432907632 BLEHDON PLACE 5553432907632 BLEHDON PLACE 1230986545543 MORTHaLD DR 1230986545543 MWORTHa UELD DR TBwISBA SAI WORTH ST LBCnRA SAI WORTH ST ZrBASATIBI45 M FRONT ST zrBASATIBT45 M FERONT ST ProgressBook Studentlnformation Import Export Guide E DAHS txt Notepad File Edit Format View Help 36985236990 ELM STREET 5554443349065 BLISS RD 134876456881 THAYER ROAD 36985236990 ELM STREET 0989898907775 BROADWAY BLVD 5554443349065 BLISS RD 565454345256 LUCKY AVE 134876456881 THAYER ROAD 58909845612 NORTH ST 278654738345 456309900702 908987876665 123768453600 M FRONT ST BRISTOL SUGAR STREET BLOOM DRIVE 36985236990 ELM STREET 5554443349065 BLISS RD 134876456881 THAYER ROAD 58909845612 NORTH ST 278654738345 456309900702 908987876665 123768453600 123098654843 123098654843 N FRONT ST BRISTOL SUGAR STREET BLOOM DRIVE NORTHWALD DR NORTHWALD DR 37687324590 ELM STREET 37687324590 ELM STREET SHARRI SHARRI SHARRI SHARRI SHARRI SHARRI SHARRI SHARRI DONALD DONALD DONALD DONA
58. 63 Y N 0 gt null blank 14 ProgressBook Studentlnformation Import Export Guide Import Data from Studente Vocational Schools This screen will import files from students vocational schools Course History Attendance Students The file can contain up to five term marks Please select student marks information for each of the term marks that will be imported Mark Term Term 1 Mark Not Imported Term 2 Mark Not Imported Term 3 Mark Mot Imported Term 4 Mark Not Imported Term 5 Mark Not Imported Import Mode Primary Student Identifier for Import Marks Import Options Mark Type Not Imported Not Imported Not Imported Not Imported Not Imported Credit Type Not Imported Not Imported Not Imported Not Imported Not Imported 8 Perform Import and Create Verification File O Create Verification File Only Do Not Perform Import O Perform Student Identifier Check Only Do Not Perform Import Or Create Verification File State Student ID SSID EMIS ID Fi Ignore Area Of Study If No Match To Existing Values z Ignore Subject Area If No Match To Existing Values Remove Pluses And Minuses From Imported Alpha Marks Sending School IRN F ja Import File Browse Z Select Reporting Term Mark Type and Credit Type to use for each marks record imported Note that when importing fil
59. 66 e Residency Code 321 4 e Special Ed Code 325 3 e Attendance Code 328 1 Ej EDUDA SEQ WordPad Ed Vi D ck 048652258Banana OOOOOGOOS5MAY OOOOO4OOS5UWELLS 000004003 JOHNSON OOOOOGOO1EYE OOOOO OO3RING 000001224LEE DnoOO007001CONTRARY o00005004SPRAT ooo006002FONT OOOOO4OO1EYE OOOOOGOO4L INE DnoOO05001CONTRARY 000005002 PERRY 000007002 PERRY D000004008SAWYER D000005005WELLS 000004004PO0TTS 00012244S5EYE oo0006003 JONES 0000070045 aRGENT OOOOOS5OO3POTTS OOOOO OOSUWILLIAMSON 000004002FONT 048652281Contrary File Edit View Insert Forme D c E amp a Fi198708172698722176 Fi19881004123768453 Fi9861223123098654 N19660913455769300 Hi9890716589098456 F19890511555444334 F19891030678956677 Mi99002 14369852369 H19880202453123789 F19890105278654738 M198704032 67874612 M19890202908987876 F19871117376873245 M19871204564789874 M1989042 409989890 M198910292 58741258 F19880317453676123 M19860801756543290 F19891112123654123 F19890814456309900 F19890930565454345 M19870920890987654 N19891015134876456 F19861024568978542 M20050404 E MUWA SEG WardPad mat Hel iat eip Sk o R B Hannah DAISY LEE JOBETH GEORGE EVAN CORY ROBERT NICOLE SUZANNE HARPER LEE JASON WILLIAM JACK JOSEPH MICHELLE LYNN MAGNUM P TROY AARON MARY M MICHAEL JAY RICHARD MATTHERICH THOMAS JACK JONA RENEE JORDAN DANIEL PRIVA WHITNEY ANN LEANN JEAN IAN MICHAEL RYAN SETH ELLA JANE Jesse TT Da e004
60. 67090123 WALTERS LINDA 6500 HANOVER LIMA OH 419 225 4590 839012345 WEBBER MICHAEL S00 VINE AVENUE LIMA OH 419 226 4890 ProgressBook Studentlnformation Import Export Guide Student Data Extended IIb Excelsior Export From this screen you can export data for a specific file format Student Data Extended v Homeroom Date 1 18 2008 Reporting Term Marking Period GPA Set Cumulative GPA Set IA Student Statuses Excluded Student Statuses Included A ACTIVE RES D DELETED I INACTIVE jh JVS Student Attending Homeroom Date Enter the date to be used to determine the student s homeroom Reporting Term Determines the time range used for calculating Marking Period Marking Period GPA Set Determines the Marking Period GPA and Marking Period Credits Earned Cumulative GPA Set used to determine the Cum GPA and Cum GPA Credits Earned Student Status Excluded Included Select the students you wish to include Export Execute the Export process Fields included in the export include otudent Data Extended Export has 10 additional fields compared to the Student Data Export The index indicates the column position Index is zero based Columns with index 0 14 are exactly the same as Student Data Export ProgressBook Studentinformation Import Export Guide 85 Index Column 15 Homeroom 16 School Code 17 Marking Period Absence 18 Full Year Absence 19 Marking Period Tardy 20 Full Yea
61. 91MEW7777777 r Center JVSD 045111000067Test vill SD Test High School Test Caree J04131992FER3333333 t Career Center JVSD 045111000067Test vill SD Test High School Tes 3011995FEQ5555555 The file is a fixed length file The following is the file layout for the extraction file OHIO TEST 13 19 85 115 145 165 185 132 84 114 144 164 184 185 Record Description for Student Data Files Start End Field Field Name Comments Description Position Position Length JVSD IRN Required field Six digit district IRN contains only numeric values 0 9 Enter the IRN of the JVSD Use the district IRN from the JVS JVS School IRN Required field Six digit School IRN contains only numeric values 0 9 Enter the IRN of the joint vocational school Use the building associated with the value of Attending building on the latest FS record 30 JVSD Name Optional field Alpha numeric Must correspond to JVSD IRN Use the name associated with the district IRN of the JVS in context 30 30 30 20 20 JV School Name Optional field Alpha numeric Must correspond to JV School IRN Use the name associated with the building specified in the attending building IRN field on the student s latest FS record Home District Required field Six digit District IRN contains only IRN numeric values 0 9 Enter the IRN of the school where the student was last tested for the OGT Use the district IRN
62. A3 A3 Required XX format 1 Filler NENNEN MEER Filler es 7 Required alphabetic XX format must be capital letters Zipcode 9 Required numeric 5 or 9 numbers Numeric Qooooo00xx or xxx xxx xxxx format Filler Contact type Alphanumeric must match contact type name of receiving school Filler Contact name Alphanumeric will load into Last Name field only Contact title Valid options are Mr Mrs Ms or Dr Filler ProgressBook Studentinformation Import Export Guide 19 OO II NE NEN 40 2 p OO REG XXX format must be capital letters Disadvantagement Valid options are 1 2 or 3 EU Filler ll O Filler ll O Filler ll O Filler ll O Filler Required enter 1234560 Filler ll O UM Required valid options are 01 02 03 04 05 06 08 09 10 12 13 14 15 or 16 Eier ll O Home Language LA 9 XXXformat must be capital letters Hispanic Latino LL YorN case sensitive Race White LB TrueorFalse case sensitive Race Black LB TrueorFalse case sensitive Race Asian LB TrueorFalse case sensitive case sensitive Native language 0101 01 gt 20 ProgressBook Studentlnformation Import Export Guide Import Data from Studente Vocational Schools This screen will import files from students vocational schools Course History Attendance Students No additional information is need
63. Ba looks suspicious or you do not Fully trust the source do nat open or save this File File name DAS txt File type Text Document From dsldemo mcaecn arg Would vau like to open the file ar save it to your computer i Cancel More Info Save Save this file to your hard drive or network drive for use in Microsoft Word mail merge The following figure shows an example of the Discipline Letter Export file P DAHS 1 txt Notepad Fle Edt Format view Hep Student Number School Name Student Last Name Student First Name Parent Name Address Address city State Yip Incident Date Incident Description Infraction Code Infraction Description Infraction Referrer Action Code Action Description Number Of Days Action Start Action emer its Action Date Policy Description 6001 DA HIGH SCHEN ETI CORY ROBERT M M EDWARD E YI 17 NORTH 5T OH 458 10 20 2006 17 00 00 AM 2 00 odere 17 00 00 AM ES caa 17 00 00 AM 12 20 2006 12 00 00 AM DASL HIGH SCHOOL SPRAT JACK JOSEPH 90 BACON ATI LIMA 45801 11 70 7006 17 00 00 AM 1 00 12 30 2006 17 00 00 AM 12 20 2006 17 ni d AM pr rina 17 00 00 AM DASL HIGH SCHOOL SPRAT JACK JOSEPH Mary Sprat 90 BACON 458 EEN 17 00 00 AM 12 30 2006 17 00 00 AM 12 22 2006 17 00 og AM i 12 20 2006 17 00 0 DASL HIGH SCHOOL SPRAT JACK JOSEPH EOD BACON TRATI LIMA 45801 351472005 12 00 00 AM 1 1 1900 12 00 K d s mis ei E E AM I B 12 00 00 AM DASL HIGH SCHOOL EYE MAGNUM P EDWARD EYE 45801 10 20 2006 E e 12 20 2
64. Birth Month 171 2 Birth Day 173 2 social Security Number 175 9 Counselor 184 25 otudent Status 209 1 Grade Level 210 2 ochool Year 212 4 Homeroom 216 4 Program Code 220 2 Disability Code 222 2 Locker 224 4 Locker Combination 228 8 Previous School 236 4 Admission Century 240 2 Admission Year 242 2 Admission Month 244 2 Admission Day 246 2 Admission Code High 248 1 Admission Code Low 249 1 Withdrawal Century 250 2 Withdrawal Year 252 2 Withdrawal Month 254 2 Withdrawal Day 256 2 Withdrawal Code High 258 1 Withdrawal Code Low 259 1 Transfer to School 260 4 Transfer Date 264 8 formatted as yyyymmdd Diploma Century 272 2 Diploma Year 274 2 Diploma Month 276 2 Diploma Day 278 2 Ethnic Code 280 2 Filler 282 23 First 5 positions are data flags next 10 positions are scheduling flags last 8 positions are the last date the student s schedule was changed Listed Unlisted Code 305 1 Parent Guardian Relationship 306 1 Filler 307 2 First position contains birth date verification code second position contains the file received flag Calendar 309 1 Filler 310 7 First position contains file sent flag second position contains graduation rule code last 5 positions contain report flags New Homeroom 317 4 65 The following figures show an example of the Wayne Trace Lima City Edulog export file
65. CBA check box 12 In the File Download Options section select a download method Note There is only one file type option which is txt or FIXED 13 Click Export If all students have a state student ID SSID the file download begins Note If any student does not have an ID the student displays in a grid You can access the student s profile from the grid and add the ID If you do not the student will be excluded from the export Studentinformation gt Management gt Import Export gt Pre Identification Export Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools DAES DALTON ELEMENTARY SCHOOL DAHS DALTON HIGH SCHOOL Z amp DAJH DALTON INTERMEDIATE Export Format PreIdent For AASWD and OCBA v The following students do not have Statewide Student Identifiers Click Continue if you would like to create the export file without these students Click the Student Name to go to the Student Profile Edit screen Click Refresh to reload the list 1 Record Displayed District Building Student Number Student Name 09 DLTN DAHS 00260150 BARNES SONTA ProgressBook Studentinformation Import Export Guide 113 14 Optional To add a missing SSID for a student so the student is included in the export a Click the student s name b On the Edit Student Profile screen FS Standing tab in the State Student
66. Codes Selected DAHS 020 03 ALGEBRA I DAHS 020 02 ALGEBRA I DAHS 020 07 ALGEBRA I s DAHS 030 01 ALGEBRA II DAHS 030 04 ALGEBRA II DAHS 030 09 ALGEBRA IT Test Taken Online S At the top of the screen select the school s to include in the export by moving them from the Available Schools in District multi select list to the Selected Schools list A single export file will contain data for all selected schools In the Export Format drop down list select Preldent For PARCC In both the English amp Language Arts ELA and Mathematics MAT sections select the course s to include in the export by moving them from the Subject Codes Available multi select list to the Subject Codes Selected list Note Courses with the following EMIS Subject Codes display in the lists e ELA 05XXXX and 06XXXX e MAT 11XXXX In the Test Taken drop down list select the format of the test the students will take either Paper or Online Click Export and save the file ProgressBook Studentlnformation Import Export Guide Preldent for Ohio Online Field Test Navigation Home Management Import Export Pre Identification Export Preldent For Ohio Online Field Test dropdown You can only run this export at the district level The export file is in txt format otudentlnformation includes students in the export based on the following rules e 04 08 graders o include
67. Coldwater Ex Vill SD DL Delphos City SD DS Delphos St Johns EL Elida Local 5D _ FD Findlay Digital Academy MB Clear All Districts FN HC KA LM MA Findlay City SD Fort Recovery Local SD Hancock Educ Serv Cntr Jennings Local SD Kalida Local SD Liberty Benton Local SD Lima Catholic School District LIMA DIGITAL ACADEMY Lima City SD Leipsic Local SD Lincolnview Local SD Marion Local SD McComb Local SD Mercer Educ Serv Cntr Miller City New Cleveland Local North Baltimore Local SD Ottawa Glandorf Local SD Ohio Virtual Academy District Ottoville Local SD PERRY LOCAL SD Pandora Gilboa Local SD Putnam Educ Serv Cntr District Level Paulding Ex Vill SD Parkway Local SD QUEST ACADEMY COMMUNITY ELEM SCHOOL DIST St Henry Consolidated Local SD St Marys City SD Springfield Local SD Spencerville Local SD Shawnee Local SD Van Buren Local SD Vanlue Local SD Van Wert St Marys Vantage JVSD Van Wert City SD WESTERN BUCKEYE ESC District West Central Learning Academy District Wapakoneta City SD Wayne Trace Local SD Include Districts Choose Select All Districts to check all districts in the ITC Choose Clear All District to uncheck all districts in the ITC Districts required All districts for the ITC are listed Check one or more individual district checkboxes to process only for those di
68. DASL where 000000 is the Home School District IRN or XXXX is the home school four letter code state Student ID SSID or EMIS ID depending on Primary Student Id for Export option selected 1 9 School Year 10 4 Report Term Code or Report Term Export Code depending on Home School Term Format option selected 14 3 Absence Type 17 1 Full Day Absences 18 3 Half Day Absences 21 3 Tardies 24 3 Filler 27 12 Student Name 39 30 ProgressBook Studentlnformation Import Export Guide 17 Il Import Data from Students Vocational Schools This screen will import files from students vocational schools Course History Attendance Students No additional information is needed to import attendance data Import Moda 0 Perform Import and Create Verification File Create Verification File Only Do Not Perform Import Perform Student Identifier Check Only Do Not Perform Import Or Create Verification File Primary Student Identifier for Import State Student ID SSID EMIS ID Sending School IRN Z Jo Import File Browse 7 Import Mode required You must choose one of the following Import Mode options e Perform Import and Create Verification File Processing will import all valid records and also create the import verification file The verification file will be named StudentAttendanceVerificationFile xxxx txt where xxxx is your building code e Create Verification File
69. DERICK 01181991MEW7777777 050999050777Test JVSD Test Career Center JVSD 045111000067Test vill SD Test High School Student68383 BILLIE JEAN 304131992FER3333333 050999050777Test JVSD Test Career Center JVSD 045111000067Test vill SD Test High School Student68504 ANGELA L03011995FEQ5555555 126 ProgressBook Studentlnformation Import Export Guide The file is a fixed length file The following is the file layout for the extraction file OHIO TEST Record FieldName for Student Data Files Position ae 8 ee JVSD IRN Required field Six digit district IRN contains only numeric values 0 9 Enter the IRN of the JVSD Use the value specified in the JVS District IRN orompt selected on the requesting page JVS School IRN Required field Six digit School IRN contains only numeric values 0 9 Enter the IRN of the joint vocational school Use the building IRN specified in the JVS school building selected on the requesting page epee Name Optional field Aloha numeric Must correspond to TT iso IRN Use the name associated with the District JVS IRN selected on the requesting page LL School Name Optional field Alpha numeric Must correspond to JV School IRN Use the name associated with the JVS school IRN selected on the requesting page Home District IRN Required field Six digit District IRN contains only numeric values 0 9 Enter the IRN of the school where the ME was last tested for the OGT Use the district IRN of the current dis
70. EAN IAN MICHAEL RYAN SETH ELLA JANE Jesse 2117 Cherry Street 675 S Main St 600 BLOOM DRIVE 843 NORTHWALD DR 597 STATE STREET 12 NORTH ST 9065 BLISS RD 23 MOCKINGBIRD LANE 90 ELM STREET 690 bacon trail 345 N FRONT ST 122 NORTH ST 665 SUGAR STREET 90 ELM STREET 776 BROADWAY BLVD 775 BROADWAY BLVD 12 KIMMEY 111 E steet 7632 BLENDON PLACE 123 SECRET AVE 702 BRISTOL 123 Bigtop Street 7632 BLENDON PLACE 881 THAYER ROAD 345 N FRONT ST 645 S Main 112004410805 4013411535 092004A103 A009 102004A105 i22004A109 122004410910 102004A105 0920042A103 092004 SZ 09200448103 112004410704 4020 102004A105 122004A109 1020044105 112004410703 112004a107 0920044103 112004 EE 112004A107 i22004A109 1120042A107 102004A105 0S92004A103 112004A107 0Sz004A103 122004A109 102004 X OOOOOODO OOOOOOOD OOOOOOOD OOOOOODO OOOOOODO OOOOOODO OOOOOOOOD OOOOOODO OOOOOODO OOOOOODO OOOOOOOO OOOOOOOO OOOOOODO OOOOOODO OOOOOOODOD OOOOOODO OOOOOODO OOOOOODO OOOOOODO OOOOOOOD OOOOOODO OOOOOODO OOOOOOOO OOOOOODO OOOOOOODO OOOOOOOD ProgressBook Studentlnformation Import Export Guide OOOOOODO OOOOOOOO OOOOOOODO OOOOOOOO OOOOOOOO OOOOOODO OOOOOOOO oooo00000 oooo0000 oooo00000 OOOOOODO OOOOOOOO OOOODODO OOOOOODO OOOOOOOD OOOOOOOOD OOOOOOODO OOOOOODO ooooo0000 OOOODODO oooo0000 OOOOOOOO oooo00000 OOOOOODO OOOOOOOO OOOOOODO Si ei sei UN ei ei ei zm ei e
71. EL LARSON OODI22Z445ETE U4B sz258EAnana Np CHL opt Cars D4R65228lConrrary ProgressBook Studentinformation Import Export Guide JORDAN DANIEL JOBETH THOMAS HARY H MICHAEL JAY TAN MICHAEL JA K JOSEPH JONA RENEE CORY ROBERT MICHELLE LYNN WHITHEY ANN TROY AARON DAISY LEE JASON WILLIAM RICHARD MATTHE NICOLE SUZANNE 7632 ELENDOW PLAC B42 NORINWALD DE Bu MISSISSIPPI RID B ELE STREET Th BEDADWAY BLVD 632 BLENDON PLACE Ban RACON TRATL Bas NORINWALD DE 12 NORTH ST 145 M FRONT ST UZ BEISTOL amp 65 JUGAR STREET 600 ELOOH DRIVE BU ELE STREET Ths BROADWAY BLVD S065 BLISS RD Lid Bigtop Street 001 THAYER ROAD 123 SECRET AVE peer EUITE 100 DAVID POTTS MITCH WELLS NARE TWAIN HARION CONTRART NATIMEV FERRY DAVID POTIS JOLENE TEEECE RESCH WELLS EDWARD EYE JANE FONT WILLIAN JONES BOB LINE ZHARON LEE HWABION CONTPRAET HATTEN FERRY NICHOLAS RING JAA SARGENT JOEN VILCIANSON ELU EYE 15B6 801 19061223 415228 742915859 1029 4319228741718871117 189071204 Pe 105 D 419228741 T1888O0z02 ISO I 196920716 10820105 IEBUSQUIA Legge oe 15881004 4195355580 O1B8BSUT 419222888819B859 z 20050404 63 Wayne Trace Lima City Edulog Navigation Home Management Import Export Edulog Export WAYNE TRACE LIMA CITY EDULOG Edulog Export From this screen you can export data for a specific file format ONE TRACE LIMA CITY EDULOG ze Distr
72. EM OiBEREM OD BE REM OD BE REA OD BEREF O TBEREF O3T7AZTM ORCAS TH OPTASTE 3cAZTE oct oa fag OCT fa Bili Sepls jji Sepls S017 Agil B512 Ausg BELE Decri Bdi Pests BOLE Julld 8910 Julld 8910 Jarni 5910 Jarni S910 CONTRARY HARTON RING HICHOLASZ wILLIAMTOH Em UTNAHY MUEBTOM PEERY MST THE RIMG HICHOLAS NABDGENT G HILLLIAMEON OHM Ert EDWARD FONT JAME JOHES WELL DAM LIME Bodi LEE SHADOW CONTRARY MAE DOM ATG HICHCOLAS WILLIT SASH JOM BME EDWARD FONT JAME JONES WILLIAM LINE Don LEE SHARON WELLS MITCH WELLS MITCH CONTRARY MKETOH CONTRARY MARTH PEERY MATT RE PEERY MATTHEW POTTS DAVID POTTS DAWID TREECE JULEHE TREECE JOLEME WELLS MITCH WELLS MITCH EVE EDWARD EVE EDWARD FONT JAME FONT JAME JORDON HOWARD JOHHWIZON HOWARD POTTS DAVID POTTZ DAVIG WELLS MITCH WELLS MITCH EVE EDWARD EYE EDWARD FONT JAME FONT JAME i5485236990 ELM STADET 5554441 49065 BLISS ED iz487545538Hl1 THAFER BOAD i5485236990 ELM ZTREET 9808907775 B amp b5oADWAY Lo 5554441 4 9065 BLISS ED 555454145255 LUCKY AVE iz458754553Hl THAFEB OAD CERME SEL NORTH T ZTO554731814 5 M FRONT ST 45630000070 BRISTOL GOPRATETESS5 SUGAR STARET L223 768453600 BLOOM DRIVE i6485260990 ELM STEET 5554443349065 BLISS RD Eiaa SESH THAYER BOAD GA 5617 NORTH T Sree eR M FEONT ST 45509900707 BRISTOL DORSHTSTEShS SUGAR STREET kee 3600 BLOOM DRIVE il300m t
73. Findlay Dialer Export Navigation Home Management Import Export Findlay Dialer Export This export is a specific format for schools that use an auto dialer program or third party program to dial home for students that are listed in the export file as absent for the current date Auto Dialer Export For Findlay Attendance From this screen you can export data for a specific file format Select an Export Format Select an Export Format PHON version 1 PHON version 2 There are two formats currently that are created for the district s use 56 ProgressBook Studentlnformation Import Export Guide PHON Version 1 llb Auto Dialer Export For Findlay Attendance From this screen you can export data for a specific file format PHON version 1 bul Absence Type E EXCUSED Export Fields Fhone Student Name Period 2 Absence Type M Grade Level PHON version 1 returns students absent any period of the date for the current processing date This file is comma delimited left justified and contains the following fields Area Code and Phone Number student ID student Last Name First Name Called Name 1 Period Absence Type 2 d Period Absence Type 34 Period Absence Type Grade Level ProgressBook Studentinformation Import Export Guide 57 PHON Version 2 Auto Dialer Export For Findlay Attendance From this screen you can export data for a specific file format Absence Type E
74. HS Di D 15 8006 12 FARAH M MICHELLE 1012 WW S Lima OH 10 x 00 00 0000 ELHS Di O 17 10558 10 4 19 1992 F CHRYSTA 2061 EDG LIMA OH 8 21 2007 00 00 0000 ELHS Di O 18 10150 10 fee ee F DAVE ASL2100 N GIELIDA OF m JO 00 00 0000 ELHS Di O 19 9354 11 RE M ANTHONY 8845 BICELIMA OH VF 00 00 0000 ELHS 0i D 20 9002 11 3 6 1991 F RIC 8 DEE4775 SYC ELIDA OF Ig 00 00 0000 ELHS Di O 21 8503 12 4 20 1990 F MAR Y ANP8495 LINC FT JENNI p i 00 00 0000 ELHS Di D 22 9353 11 RARE M LISA Y AHI499 POWELIMA OH j2 00 00 0000 ELHS Di D 23 8707 11 3 11 1991 M MICHAEL 5650 Leatt Elida OH 5 00 00 0000 ELHS Di D 24 10998 10 1 12 1992 M ANGELA 1636 KARILIMA OH 9 00 00 0000 ELHS Di D 25 11007 O G tt F BALDRIDG 417 VV NCLIMA OH I Elida Midd 8 29 2007 00 00 0000 ELHS Di O 26 8715 10 7 7 1991 F GBENUA 11225 N SLLIMA OH I 00 00 0000 ELHS Di O 27 10548 10 2 25 1990 F KARI GRA 7590 BILL DELPHOS 11 00 00 0000 ELHS Di D 28 8682 12 SAAR F ED amp MAF 1175 BRO LIMA OH 8 28 2007 ELHS Di O 29 8793 12 1 25 1990 F MARY FIS 1662 BRO LIMA OH j x 00 00 0000 ELHS Di O 30 8737 10 3 10 1992 F VERONIC 531 BRO LIMA OH JJ 00 00 0000 ELHS Di D E 11413 9 9 7 1992 M GINA BRC 1081 BRO LIMA OH Elida Midd 8 29 2007 00 00 0000 ELHS Di D 32 9003 11 HHRHH F PAUL 8 L45284 SHAIELIDA OF D 00 00 0000 ELHS Di D am 7005 12 6 23 1989 M MATT amp LI 120 E MairElida OH pv 8 29 2007 00 00 0000 ELHS Di D 34 10003 9 6 21 1992 F MELISSA 3511 TOW ELIDA OF iG Eli
75. Home Schools If you re not the resident district and you want the information sent back to the home school AND you ve checked to include Contract Vocational In students then you will need to check Include CVI Home School Information Hint for Home Schools If you are the Home School do not check the Include CVI Home School Information If you do any Contract Vocational In students in your file will generate an error and you will not be able to upload the file Include JVS home school information optional Hint for non Home Schools If you re not the resident district and you want the information sent back to the home school AND you ve checked to include JVS students then you will need to check Include JVS Home School Information Hint for Home Schools If you are the Home School do not check the Include JVS Home School Information If you do any JVS students in your file will generate an error and you will not be able to upload the file Return Only These Students optional enter specific Student IDs separated by commas to return in the export This can be used when creating pre identification export files for alternate assessments Please Note When using this option the grade level s of the students entered still need to be checked or the entered students will not be included in the file Export Execute the Export process Note If any students are encountered without SSID s a grid will display below the Expo
76. ID SSID field enter the student s SSID c Click Save d On the Pre Identification Export screen click Refresh The student name no longer displays in the list and the student will now be included in the export e Repeat as needed to include all students in the export 15 If any student displayed in the grid click Continue Note Any students remaining in the grid are excluded from the export file 16 Save the export file s Photo Export Navigation Home Management Import Export Photo Export oeveral photo exports are available in Studentlnformation These photo exports are used by the photo companies to generate student photos on CD Photo Export From this screen you can export data for a specific file format Select an Export Format Select an Export Format Fostoria Life Touch Photo Lange Photo Lima Life Touch Photo Note Studentinformation State Support recommends using SIS Student Search in place of the Photo Exports to get the needed data out of Studentlnformation 114 ProgressBook Studentlnformation Import Export Guide Fostoria Life Touch Photo Export Navigation Home Management Import Export Photo Export Fostoria Life Touch Photo The Fostoria Life Touch Photo Export is shown in the following figures They use this export file to generate bar codes for the schools and produce a CD containing the student pictures and associated student information Photo Expor
77. If you want to include JVS students in the export select the JVS check box 8 Optional If you want to include JVS home school information on the export select the Include JVS home school information check box Note for non home schools lf you are not the resident district you want the home school to receive the information and you selected to include JVS students in step 7 you should select this check box Note for home schools If you are the home school do not select this check box If you do any JVS students in your file will generate an error and you will not be able to upload the file Note The Return only these students feature is not currently functional 9 Click Export and save the file 108 ProgressBook Studentlnformation Import Export Guide Preldent for KRA Navigation Studentinformation Management Import Export Pre Identification Export Preldent For KRA dropdown You can only run this export at the district level Only students with state student IDs SSIDs are included in the export files The files are in csv format and contain the following information e Student export Kindergarten students e Teacher export Teachers with students in their kindergarten reading course EMIS subject code of 050102 Reading K 3 or kindergarten language arts course EMIS subject code of 050152 Integrated English Language Arts K 3 e Enrollment export Students assigned to a kindergarten reading co
78. LD DONALD DONALD DONALD DONALD DONALD DONALD DONALD DONALD DONALD DONALD DONALD DONALD DONALD AUSTIN AUSTIN AUSTIN AUSTIN AUSTIN AUSTIN AUSTIN AUSTIN BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY BERRY LANGUAG LANGUAG LANGUAG soc STU soc STU soc Soc soc ART ART ART ART ART SPANISH SPANISH SPANISH ANATOMY ANATOMY FRENCH OOZAFRENCH E ARTS E ARTS E ARTS D D I I I BAS ENGLISH BAS ENGLISH BAS ENGLISH BAS ENGLISH BAS ENGLISH III III 003 FRENCH III QO3AFRENCH III 003 FRENCH III QO3AFRENCH III 003 FRENCH III OOZAFRENCH III 003 FRENCH III QO3AFRENCH III PHYSICS 008 PHYSICS 007 PHYSICS PHYSICS PHYSICS PHYSICS PHYSICS PHYSICS PHYSICS PHYSICS ANATOMY ANATOMY ANATOMY ANATOMY 564789874776 BROADWAY BLVD DONALD BERRY 564789874776 BROADWAY BLVD DONALD BERRY 8909876547632 BLENDON PLACE DONALD BERRY 8909876547632 BLENDON PLACE DONALD BERRY 453123789890 BACON TRAIL DONALD BERRY 453123789890 BACON TRAIL DONALD BERRY 453676123843 NORTHWALD DR DONALD BERRY 453676123843 NORTHWALD DR DONALD BERRY 267874612122 NORTH ST DONALD BERRY 267874612122 NORTH ST DONALD BERRY 568978542345 N FRONT ST DONALD BERRY 568978542345 N FRONT ST DONALD BERRY 458769300597 STATE STREET DONALD BERRY 458769300597 STATE STREET DONALD BERRY 7565432907632 BLENDON PLACE DONALD BERRY 7565432907632 BLENDON PLACE DONALD BERRY 123098654843 NORTHWALD DR D
79. M Absence A M P M 27 1 valid values are A a m P p m and space full day Absence Reason 28 1 only importing if Absence Reason Code is one letter Absence Note 29 1 one letter Absence Note Code defined in Studentlnformation Step One Daily Absence Only Please note that this import can only be run for daily absence file Attempting to process this import for period absence records will result in invalid records ProgressBook Studentlnformation Import Export Guide IIb ATT2SIS Import Daily Absences Only Please note that this import can only be run for daily absence file Attempting to process this import for period absence records will result in invalid records Step One Action 9 Add Mode Update Mode File Name Browse Browse to the location of the File Name to be imported Next gt Process the file selected and go to Step Two Step Two In Step Two you will be presented with the List of Errors on Import If no errors are found you will skip Step Two and proceed directly to Step Three ATT2SIS Import Step One Step Two Step Three List Of Errors On Import Type Value No Absence Type Found d Start Over Type Indicates the Type of error Step Two will check for valid data for Student ID Absence Date Absence Type Absence Time and Absence Reason Error Types include e No Student Number Found e No Absence Type Found e No Absence Reason Found Value Valu
80. M 90 ELM STREET LIMA 7417 MARION CONTRARY 6001 EYE CORY RO 12 NORTH ST LIMA EDWARD EYE 4001 EYE MAGNUM 122 NORTH ST LIMA 2222 EDWARD EYE 122445 EYE PRIVA 123 SECRET AVE LIMA 8888 BLU EYE 4002 FONT ELLA JAN 345 N FRONT ST LIMA JANE FONT 6002 FONT MICHELLE 345 N FRONT ST LIMA JANE FONT 4003 JOHNSON GEORGE 597 STATE STREET LIMA HOWARD JOHNSON 6003 JONES WHITNEY 702 BRISTOL LIMA WILLIAM JONES 1224 LEE HARPER 23 MOCKINGBIRD L4 LIMA 2345 ATTICUS FINCH 665 SUGAR STREET LIMA BOB LINE 600 BLOOM DRIVE LIMA SHARON LEE 776 BROADWAY DL LIMA MATTHEW PERRY MATTHEW PERRY 7632 BLENDON PLA LIMA DAVID POTTS 6004 LINE TROY AAF 6005 MAY DAISY LEI 5002 PERRY MICHAEL 7002 PERRY RICHARD CASTLE 775 BROADWAY BL LIMA 5003 POTTS IAN MICHA 4004 POTTS JORDAN LAYMAN 7632 BLENDON PLA LIMA DAVID POTTS 7003 RING NICOLE S 9065 BLISS RD LIMA NICHOLAS RING 7004 SARGENT LEANN JE CASTLE 123 Bigtop Street LIMA 9876 SAM SARGENT 120 4008 SAWYER THOMAS 5004 SPRAT JACK JOS 4005 WELLS JOBETH 5005 WELLS JONA REP 7005 WILLIAMS RYAN SE 89 MISSIS SUITE 100 LIMA 890 BACON TRAIL LIMA 843 NORTHW ALD DF LIMA 843 NORTHW ALD DF LIMA 881 THAYER ROAD LIMA ProgressBook Studentlnformation Import Export Guide 7429 MARK TWAIN 7417 JOLENE TREECE MITCH WELLS MITCH WELLS JOHN WILLIAMSON STUFEES Export Navigation Home Management Import Export STUFEES Export The STUFEES Export is shown in the following figure This export can be used to export stude
81. OM AYAM SETOS3 xOLODOOOUEOUlEYE Chey EOBERT 1716 K OXLONPOOSOOJFONT MICHELLE LYTHH i716 EOLOODO0E003 JONES mr THEY AMH 1718 ERLOOQOOEOG4 LING TROT BARON 1716 xOLODOONGO05MATY DAES LEE 1716 el ODODOTODLCONTEARY M Act n MI I NELLE LTUH 4 WHETNEY ANH a MICHAEL JAY a MICHAEL JAY LAH MICHAEL LAH MICHAEL a JACH JOSEPH JACE JOSEPH a PONA RENEE a PONA RENEE XULOUCODSQUIEYE MAGHIM F SOLUS CLEVE MAGHIM F LIP SOLOS OULFONT ELLA JANE 431 SOLS GO FORT ELLA JANE 431 SOLOS GOS ORME GEORGE EVAR II xOLOGODO QU JOHNSON GEORGE EVANA I s MORGAN DAMIELA3I s MORGAN DAMTELA3 Ez Bar Peat ad Pt et tt BI ER Ex w i4 pari xiXLOOODORODTEYE CORY ROBERT x XLOQODOEOU2 FONT MECHELLE LYNN 233 x KLOQODOEOUZ FONT MICHELLE LYMHH 233 ri GF 4ueaTE D ALETM lira DLG GLAWSTE GLAWETE DL OLBEAEM CLARRIE OLBEREF OLBEREM Cua ue O2HRREM INEREF IBEREM DOlnEREM DOlnEREF CLNEREF OlnEREM DlnEREF OINEREF OINEREF Febl4 9009 May11 590 ES aG Fabi4 9009 e 24 8909 Hay11 8009 Sapib 8909 etis aop 3u118 8910 Jari5 8910 Ad 8010 2 8910 etii BBl0 Fabia p00 Mayii atp OcTi5 8009 Decl 1BEREF228 7417N0v17 8711 ULlBEREFZZB T4A1THQuVA7 B71i GlLpERSN OLBEREM OLBEREM OUNEREM IBEREZM B ote PPLE ete SBP SE orali idi D dz sili OUBEREMI a Pal Prete 8611 OLBEREF ULIBEREF Hari Shi Har17 B li XBEREMIT5 1234Apr03 8712 3BERSMT15 L234Apr 3 8717 OTBEREF TBEREF QiBER
82. ONALD BERRY 123098654843 NORTHWALD DR DONALD BERRY 58909845612 NORTH ST RONALD CASTLE 58909845612 NORTH ST RONALD CASTLE 278654738345 N FRONT ST RONALD CASTLE 278654738345 N FRONT ST RONALD CASTLE PREBBBBBBBBBBBBBBBBBEBBBBBEBBEBBEBEBBEBBEBBBBEBEBBEBEEBEBEE o Home School Export Navigation Home Management Import Export Home School Export The Home School Export is the process used by the JVS to export the marks and attendance data out of the JVS to the home schools This process will create export files to be processed in SIS Home School Export Course History Navigation Home Management Import Export Home School Export Course History Tab This is commonly referred to as the JVS Grades Export Any school not just JVSes can use the Home School Export The Home School Export will only export students with marks in courses with a Course Type of Class Post Secondary Course or Vocational as defined on the Courses Miscellaneous tab ProgressBook Studentinformation Import Export Guide 49 Ill Export Data to Provide to Students Home Schools This screen will create export files for students home schools Course History Attendance For each marking pattern select the marking pattern rules to use for the exported marks Term 1 Mark Term 2 Mark Term 3 Mark Term 4 Mark Final Mark Blank v Blank v Blank v Blank v Blank Blank e Blank e Blank e Blan
83. RARY SP RAT FONT EYE LINE CONTRARY PERRY PERRY SAWYER SUITE 100 WELLS POTTS EYE JONES SARGENT POTTS WILLIAMSON FONT contrary OBI F l4B7 Lima OH 10041988 LIMA OH 12231585 LIMA OH 097 37 SS6LAYPRAN LIMA OH 07161989 LIMA OH 05111989 LIMA OH 10301986 LIMA OH 02141990 LIMA OH 02021988 LIMA OH 01051989 LIMA OH O403198 LIMA OH 02021989 LIMA OH 11171587 LIMA OH 12041987 LIMA OH 0424798 9C 45TLE LIMA OH 10201585 LIMA OH 03171588 LIMA OH OBUTI GBOLATMAN LIMA OH 11121585 LIMA OH 08141989 LIMA OH O95 01L989C45TLE LIMA OH 0970198 LIMA OH 10151585 LIMA OH l02419585LAYMANM LIMA OH o4 04 2005 Lima OH TI 4 l SHAROM LEE 12MITCH WELLS 1 l2HOWARD JOHNSON l EDWARD EYE 1 OGNICHOLAS RING 1 OGATTICUS FINCH OOMARTON CONTRARY 1 11J5LENE TREECE l JANE FONT l2EDWARD EYE l BOB LINE llMARIOM CONTRARY 1 llMATTHEW PERRY OOMATTHEW PERRY 1 llMARK TWAIN LIMITCH WELLS l2DAVID POTTS llBLU EYE LTOWILLIAM JONES 1 45801 45801 45604 QGSAM SARGENT 11DAVID POTTS OGJOHN WILLIAMSOM 12JANE FONT 73 Meals Plus Point of Sale Version 2 Navigation Home Management Import Export Lunch Export Meals Plus Point of Sale Version 2 Lunch Export From this screen you can export data for a specific file format Meals Plus Point Of Sale Version 2 ka Student Statuse
84. TTEN FERRY NICHOLAS RING JAA SARGENT JOEN VILCIANSON ELU EYE 15B6 801 19061223 41522814251585910245 4319228741718871117 419555580 Taos 419222888819B859 z 20050404 61 BATH Edulog Navigation Home Management Import Export Edulog Export Bath EDULOG Edulog Export From this screen you can export data for a specific file format BATH EDULOG k District DASL Local SD School Year 2007 2008 Please Note For projections change context to the new year Action All Students O Student updated since last run date e Include the deleted students since last school year Export Action required Choose All Students or only Students updated since a specified last run date Can also choose whether to include the deleted students since last school year Export Execute the Export process File Download Some files can harm your computer IF the file information below bn looks suspicious or you do not fully trust the source do not open or save this file File name EDUCA SEQ File type From dsldema mcaecn arg Would vau like to open the file ar save it ta your computer Cancel More Info sk before opening this type af file Save Save this file to your hard drive or network drive 62 ProgressBook Studentlnformation Import Export Guide The file is fixed width left justified with spaces for padding The file layout will be as follows with the star
85. The file layout will be as follows with the starting point of that field and the length in parenthesis file ProgressBook Studentinformation Import Export Guide Student ID 1 9 Student First Name 10 15 Student Middle Name 25 15 Student Last Name 40 15 Date of Birth 55 8 formatted as mmddyyyy Teacher Last Name 63 15 Student Grade 78 2 Parent 80 30 Student Address 1 110 30 Student Address 2 140 30 Student Address 3 170 30 The following figure shows an example of the Meals Plus Point of Sale Version 1 export E DAHS txt Notepad File Edit Format View Help 48552258 Hannah 2117 Cherry Street 5005 DAISY LEE 600 BLOOM DRIVE 4005 JOBETH B43 NORTHWALD DR 4003 GEORGE EVAN 597 STATE STREET 6001 CORY ROBERT 12 NORTH ST 7003 NICOLE SUZAHNHE 9065 BLISS RD 1224 HARPER 23 MOCKINGBIRD LANE FOOL JASON WILLTAM 90 ELM STREET JACK JOSEPH BATON TRAIL MICHELLE LYNN M FRONT ST MAGNUM P NORTH ST TROY AARON SUGAR STREET MARY M 90 ELM STREET 5002 MICHAEL JAY 776 BROADWAY BLYD 7002 RICHARD MATTHE fo BROADWAY BLYD 4008 THOMAS 89 MISSISSIPPI RD 5005 JONA RENEE eds MORTHWALD DR 4004 JORDAN DAMIEL 632 BLENDON PLACE 122445 PRIVA 123 SECRET AVE 6003 WHITNEY ANN 702 BRISTOL z 04 LEAMM JEAN 123 Bigtop street O03 IAM MICHAEL 7632 BLENDON PLACE 7005 RYAM SETH 881 THAYER ROAD 4002 ELLA JANE 345 M FRONT ST 46652281 Jesse 645 5 Main Banana Mar WELLS JOHNSON EYE RING LEE CONT
86. VS exported by SSID then you will need to do the import by SSID 18 ProgressBook Studentlnformation Import Export Guide Sending School IRN required Enter the IRN of the school providing the Attendance data to be imported The entity name associated with the IRN will show in the adjacent disabled textbox Click to open the ODE IRN Search page to browse for an IRN at ODE s website Import File required Browse to the location of the File Name to be imported Import Import Attendance data from the import file You must confirm click OK that you really want to import this information before the import completes Error Message Cause Resolution This is most frequently due to an EMIS ID or SSID mismatch between the JVS and home school Change the incorrect EMIS ID or SSID at the incorrect building and re export or Student not found change the EMIS ID or SSID in the import file and re import Note Ifyou ignore this error and continue on with the import this student s attendance will not be imported Home School Import Students Navigation Home Management Import Export Home School Import Students Tab The Students file layout must be as follows in tab delimited txt file format Social Security number Numeric xxxxxxxx format Filer o l G O Ee Filer 7 7 v v v g cv gt v G O Birth deis Required MM DD YYYY format receiving school Grade 3
87. a 2035 000976 Student55352 Megan F 645 S Main St Lima 0H 45804 555 EECH 366125240 2001 08 06 m n n n Mak 7 n Student55352 Megan Sue n n n m 2041 000976 Student55346 Richard M 645 S Main St Lima 0H 45804 555 ST Reger ISI NU ee A ee are JH es Y n n N m Special Notes on the Export File e he Name field is a combination of last name first name called name e he Middle Name field will show blank if a student has a middle name of because of a missing legal middle name e The Email field shows both the email address from the Student Profile and the email address from the Primary Contact separated by a comma and a space 38 ProgressBook Studentlnformation Import Export Guide Discipline Letter Export DISCDT Navigation Home Management Import Export Discipline Letter Export DISCDT This process will create an export file for students requiring Discipline letters The Discipline Letter Export DISCDT will only look at the Year selected and not include incidents from prior years This tab delimited export file can then be used with Microsoft Word as a mail merge document The file can be loaded in Microsoft Word as a data file for a form letter The first row in this file is a header row containing all field names Discipline Letter Export DISCDT From this screen you can export a Discipline DT tab delimite
88. a used to report the teacher name on reading reports Alpha numeric This field will be used to report the name of the class or course on writing teacher reports e g VVriting Composition Creative Writing Class Name Course Name Section Number and Teacher Name are optional However no classroom level report will be generated if ALL tne three fields are left blank Alphainumenc his feld will be used to report the section number of the class or course an writing teacher reports e g 01 02 JA Alpha last name first name This field will ba used to report the teacher name on writing teacher reporte Alpha numeric This field will be used to report the name of the class or course on mathematics teacher reports e g Mathematics Algebra Geometry Class Name Course Name Section Number and teacher name are optional However no classroom level report will ba generated if ALL the three fields are left blank Alphanumenc This field will be used to report the sectan number of rmn or course on mathematics teacher reports teg 01 2 3A Sertian Number Reading 20 Teacher Name Reading 10 Class Mame Course Name V ntng d Section Number Wining Teacher Mame Mriting Glass Name Course Name Mathematics Section Number Mathematics 23B 257 Teacher Name Mathematics Alpha last name first name This field will ba used to report the teacher name on mathematics teacher reports 25B 267 lO Glass Name Course Na
89. a valid mark for the home school This is most frequently due to a JVS having a subject area that the home school does not The usual resolution for this is for the home school to add this subject area and only use it in Home School Import for that JVS This error means that the credit ratios cannot be calculated Could not calculate credit ratio for term for the listed Terms You may need to place these lines in a different file for importing into a single reporting term Note If the grades imported from the JVS are numeric marks the export file from the JVS will contain the numeric mark and alpha equivalent according to the Marks Maintenance scale set up at the JVS So if a student receives a numeric grade of 90 00 at the JVS and a 90 00 is equivalent to a mark of A at the JVS but a mark of B4 at the Home School the 90 00 will be imported into the Home School equivalent to an A In other words the Home School Marks Maintenance scale is ignored Note The Home School Import will now match on course code and abbreviation when determining whether an incoming record matches an existing record Home School Import Attendance Navigation Home Management Import Export Home School Import Attendance Tab The Attendance file layout must be as follows with the starting point of that field and the length in parenthesis Default names are likely to be StudentAttendance000000 S EQ DASL or ALIEN ATTENDANCE XXXX SEQ JVSGRA
90. acO5fdb 18 NO 2009 Mnnnnn 84d992ad HHH 24 NO Jnnnnn c5 6ecl HEH 29 NO Annnnn 4fb67611 HiH 21 NO Ennnnn e92ba ac 28 NO Jnnnnn 7c2d775c 21 NO Jnnnnn bb5a8989 7 24 NO Jnnnnn d5e5a7e4 7 J T Annnnn S88d83684 Seet 27 NO 2 3 4 5 6 H 8 9 e 152 ProgressBook Studentlnformation Import Export Guide District Roster for Medicaid Billing Export Navigation Home Management Import Export District Roster for Medicaid Billing Export This export creates a file that includes all students in a district that are eligible for Medicaid and only includes students enrolled at some point during the reporting week for the school year in context This export is used when collecting and reporting Medicaid eligibility information from the previous school year To collect pertinent Medicaid eligibility information from the previous school year 1 Place a school Xxxxxxx High School for example in context that is within the school district ABCD Xxxxxxx City Schools for example for which the Medicaid billing export is being run 2 Change the school year in context from the current school year 2011 2012 for example to the previous school year 2010 2011 for example 3 Select Management Import Export District Roster for Medicaid Billing 4 Select the school district for which the Medicaid billing export is being run in the District Roster
91. ation export file for the Terra Nova assessments The Terra Nova Export can be accessed only with a District in context If you do not have a district in context you will receive this message Il Terra Nova Export This page is not available for your Working School This page can only be accessed for Districts With a District in context the Terra Nova Export will display the School Grade Summary List A single export file is created for the District based on the individual School Grade Configurations in the School Grade Summary List ET Il Terra Nova Export From this screen you can export a Terra Nova pre identification file School Grade Student Status Codes There are no records to display ProgressBook Studentinformation Import Export Guide 133 Note The Terra Nova Export does not save School Grade Configurations once you navigate away from the Terra Nova Export screen The School Grade Summary List will always be unpopulated when you enter the Terra Nova Export screen You must add your specific School Grade Configurations each time you run the Terra Nova Export This is required to make sure the correct School Grade Configurations are added each time for the export Note To include the district IRN in the export file enter the district IRN in the Special Code field under the formatting options on the submission page Terra Nova Export School Grade Summary List Terra Nova Export From this screen you can e
92. ator when generating the WebXam Export Record CTE Program Area CTE Program of Concentration Ad Hoc Membership required Specify an Ad Hoc Membership Group to limit the WebXam Export to the students in this group 144 ProgressBook Studentlnformation Import Export Guide Click to create a new ad hoc membership You will be taken to the Ad Hoc Memberships screen where you can create a new ad hoc membership and then return to the WebXam Export Check the Public And Private checkbox to see Ad Hoc Memberships created by other users in your drop down list CTE Program Area required Choose a Program area for the CTE Program of Concentration element CTE Program of Concentration required Choose a default element that designates the program of concentration for a CTE concentrator that will be assigned to any student that does not have a CTE Program of Concentration set on their Period N record The list of available values in the CTE Program of Concentration dropdown is dependent on the value selected for the CTE Program Area Preview A Preview button is available that will display all the students that will be included in the export prior to creating the export file The students Legal Last First and Middle Name will be used if provided for the student Records in the Preview grid will be flagged if a Default Assessment Coordinator has not been chosen on the WebXam Assessment Coordinator Records page however those recor
93. atuses Excluded Student Statuses Included required Choose the Student Statuses to be included or excluded in the Export Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process File Download 9 Some files can harm your computer IF the file information below nt looks suspicious or you do nat Fully trust the source do nat open or save this file File name DAS Cu File type Microsoft Office Excel Comma Separated Values Fil From dsldemo mcaoecn orq Would vau like to open the file or save it to your computer Cancel More Info Save Save this file to your hard drive or network drive ProgressBook Studentinformation Import Export Guide 119 This file is comma delimited left justified with spaces as padding characters Fields included in the export are the following e Student ID e Student Last Name e Student First Given Name e Student Grade e Student Homeroom e Homeroom Teacher Last Name e Student Address 1 e Student Address 2 e Student City e Student State e Student Zip Code e Student Area Code e Student Phone 1 e Student Phone 2 e Student Parent Name The following figure shows an example of the Lima Life Touch Photo Export file Cie C O p 46652253IBanana Hannah 2117 Cherry Street Lima 7001 CONTRARJASON W 90 ELM STREET LIMA MARION CONTRARY 48552281 Contrary Jesse 645 S Main Lima 5001 CONTRAR MARY
94. be selected Include only students admitted after optional Enter a date in order to include students only enrolled after this date This allows the JVS to create a file periodically after the school year starts to only pick up newly enrolled students that may not have been in the original file uploaded ProgressBook Studentinformation Import Export Guide 129 IMPORTANT Students must have an SSID on their current FS record to be included in the extract Students also must have a Home School IRN set on the student profile to be included in the extract Choose students by student numbers AIR Export From this screen you can create an AIR export file Choose students by filters Choose students by student numbers Choose students by ad hoc membership Enter a comma separated list of student numbers to include in the extract 00005743 00005745 123123123123123 F Validate Student Numbers Students must have an SSID on their current FS record to be included in the extract Students must have a Home School IRN set on the student profile to be included in the extract Enter a comma separated list of student numbers to include in the extract required as in the example above enter student numbers separated by a comma Click Validate Student Numbers You will receive the following message if any of the student numbers are invalid lib AIR Export From this screen you can create an AIR export file Pl
95. bra Geometry Class Name Course Name Section Number and teacher name are optional However no classroom level report will ba generated if ALL the three fields are left blank Alpha numenc This field will be used to report the sechon number Optbona of nw ar course on mathematics teacher reports teg 01 DJ 3A Alpha last name first name This field will ba used to report the teacher name on mathematics teacher reports Alpha numeric This field will be used to report the name of the Optonal class or course on social studies teacher reports g Social Studies History Civics Class Name Lourse Name Section Number and Teacher Name are optional However no classroom level report will ba generated if ALL the three fields are laft blank Alpha numeric This field will be used to report the secbon number Optona of ne or course on social studies teacher reports eg 01 udi D 3A Alpha last name first name This field will be used to report the pbona ports Alpha numeric This field will ba used to report the name of the class or course on science teacher reports e g Science Biology Physics Class Name Course Nama Section Number and Teacher Mama are optional However no classroom level report will be generated if ALL the three fields are left blank Alpha numeric This field will be used to report the section number of the class or course on science teacher rej Alpha last name first name This field wi
96. ch Export Far WAPAE City Schools ze Student Statuses Excluded A ACTIVE RES D DELETED e I INACTIVE e M NON RES Student Statuses Included Export Fields Student Number Lol city Z Phone Lol Grade Cade Last Mame State Parent Name v Teacher Code Lol First Name Middle Lol Zip Gender Lol SSN Address v area Code Birthdate School Code Address 2 Student Statuses Excluded Student Statuses Included required Choose the Student Statuses to be included or excluded in the Export Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export These export fields all refer to information found on the Student Profile The Teacher Code refers to the student s Homeroom Teacher Code Export Execute the Export process File Download 9 Some files can harm your computer IF the file information below looks suspicious or you do nat fully trust the source da nat open or save this file File name DAHS ExE File type Text Document From dsldemo mcaoecn orq Would vau like to open the file or save it to your computer Cancel More Info Save Save this file to your hard drive or network drive The default name of this file is DAHS txt you may rename it when you save the file 70 ProgressBook Studentlnformation Import Export Guide The file is fixed width left justified with spaces for padding The file layout will b
97. ck Refresh to reload the list Click Cancel to return to the Pre Ident for OTELA Export selection screen Click Continue if you would like to create the export file without these students Do you want to open or save this file Mame DA Get Type Text Document From dsldemo mcoecn org E While files from the Internet can be useful some files can potentially harm e your computer Ifyou do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive The export file is fixed width with spaces for padding The file layout from ODE District Test Coordinator Newsletter K 8 Assessments December 2007 is detailed in the following figure In this export file course codes longer than 10 characters are truncated to 10 characters by removing the necessary number of characters from the right side of the course code 100 ProgressBook Studentlnformation Import Export Guide OHIO TESTS RECORD DESCRIPTION FOR STUDENT PRE IDENTIFICATION FILE New fields are highlighted in blue Home District IRN position 488 493 and Hof 529 are required for JVS students Record Length 569 Field Position Field Length Cn tart End b Attending School IRN 42 30 Attending District Name 30 Attending School Name 20 Student Last Name 20 Student First Name Student Middle Initial Date of Birth Month MM 2 Date of Birth Day DO E Pal E M F f
98. d V Pre school Evaluated Only Found Ineligible Assigned Building IRN optional Enter the IRN of the building the students being imported would normally attend according to the standard district attendance policy Click di to open the ODE IRN Search page SMART logic will be invoked to help determine the correct value Sent To 1 Reason optional Select the reason the students being imported are sent to another district SMART logic will be invoked to help determine the correct value Sent To 1 IRN optional Enter the district to which the students being imported are sent Click to open the ODE IRN Search page SMART logic will be invoked to help determine the correct value Sent To 1 Percent of Time optional Enter the average percent of time for the week that the students being imported participate in any instruction provided by an employee at a non EMIS reporting entity Sent To 2 Reason optional Select the reasons the students being imported are sent to another district if the student is sent to a second district Sent To 2 IRN optional Enter the district to which the students being imported are sent if the student is simultaneously being sent to a second district Click to open the ODE IRN Search page SMART logic will be invoked to help determine the correct value Sent To 2 Percent of Time optional Enter the average percent of time for the week that the student participates in any i
99. d file Preview Data Preview Discipline letter data Students who have _ Needs a Letter checked on any Discipline Incident s will have their Discipline records previewed as shown in the following figure Discipline Letter Export DISCDT From this screen you can export a Discipline DT tab delimited file Discipline Export Data Incident Incident Infraction Infraction Infraction Action Action Number Action Action amerika Action Policy Date Description Code Description Referrer Code Description Of Days Start End Date Description IO 20 2006 12 20 2006 12 22 2006 12 20 2006 14 00 00 2 00 14 00 04 14 00 00 12 00 00 AM AM AM AM 11 20 2006 12 20 2006 12 20 2006 12 20 2006 14 0 A 1 00 14 00 0 12 00 00 U 12 A AN AM AM AN 10 20 2006 12 20 2006 12 22 2006 12 20 2006 12 00 00 12 00 00 12 00 00 12 00 00 AM AM AM AM laj 2005 1 L 1900 Li LI 1900 li L 15900 14 00 X E 14 00 00 12 00 00 12 00 OD AM AM AM AM 10 20 2206 12 20 2006 12 22 2006 12 20 2006 ETE 14 00 00 12 00 00 12 00 00 H 14 00 00 AM AM AM AM 10 20 2006 13 20 7006 12 22 2006 12 20 2006 SAWYER 12 00 00 D 12 00 00 12 00 00 0 12 00 00 AM M AM AM Export Execute the Export process Update Reset the L Needs a Letter box as unchecked on each Discipline Incident Cancel Cancel the Export process ProgressBook Studentinformation Import Export Guide 39 File Download Some files can harm your computer IF the file information below
100. d regardless of whether they are in an SOC or SCI course o course information included for SOC and SCI courses otherwise left blank e High school students o only included if they are currently taking a course with the specified EMIS oubject Codes 150300 150308 159950 150810 152300 132230 and 132220 o course information always included I gt Home Management Import Export Pre Identification Export Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools E128 BATAVIA ELEMENTARY a E127 Batavia High School de gt F E129 BATAVIA MIDDLE SCHOOL e os Export Format PreIdent For Ohio Online Field Test Include the following grades O4th Grade OSth Grade D6th Grade V 07th Grade osth Grade Include High School Students F s s amp Include the following students Contract Vocational In W Include CVI home school information LC Contract Vocational Out avs tnclude Jv8 home school information Return only these students Comma separated Student Ids 1 Atthe top of the screen select the school s to include in the export by moving them from the Available Schools in District multi select list to the Selected Schools list A single export file will contain data for all selected schools 2 In the Export Format drop down list select Pr
101. da Midd 8 29 2007 00 00 0000 ELHS Di O 35 7157 11 8 2 1989 M DAVE BA 3511 TOW ELIDA OF 8 29 2007 00 00 0000 ELHS Di O 36 12458 9 5 20 1993 F RUDIKA L 2395 ALLE LIMA OH Elida Midd 8 28 2007 00 00 0000 ELHS Di O Sh 8678 12 2 15 1990 F JOHN 8 TI7575 BUIS ELIDA OF 15 ri 00 00 0000 ELHS Di O 38 9204 11 5 14 1991 F SCOTT amp 1350 N W Elida OH 8 28 2007 00 00 0000 ELHS Di D Pre Identification Export Navigation Home Management Import Export Pre Identification Export Each pre identification export includes properly formatted student data required by the assessment provider prior to the assessment Providers later use this information to aggregate and interpret scores using meaningful breakdowns based on several criteria 86 ProgressBook Studentlnformation Import Export Guide Riverside ITBS Pre ldentification Export Navigation Home Management Import Export Pre Identification Export Riverside ITBS Pre ldentification Export dropdown You can only run this export at the district level The export file is comma delimited There are two layout options Long Layout IIb Home Hancnement x EEE Pre Identification Export Pre Identification Export From this screen you can export data for a specific file format Awailable Schools in District Selected Schools DADA DALTON ELEMENTARY e DAHS DALTON HIGH SCHOOL F DAJH DALTON INTERMEDIATE DAKI KIDRON ELEMENTARY Export Forma
102. ded If the data in Studentlnformation exceeds the available length for the field then the data is truncated These files will end with the extension SEQ as the default but the extension may be changed by the user to the user s specification Many of the EMIS data files are formatted in this way XML format produces a file with the necessary XML tags Miscellaneous Items Data in many of the exported data fields may contain carriage return and or line feed characters In addition apostrophes and commas may be present in data fields as well The presence of any of these characters may cause problems in the importation of data by a third party and or external application Therefore any such characters must be removed in these instances as they conflict with the file format and will result in errors for the application processing the file or the vendor receiving the file Specific Export File Formats oeveral file formats that have been used in SIS and DSL in the past will continue to be supported Those file formats have specific fields and formatting for their particular needs hose formats that have been included at the time of the release will be listed here but the list will continue to grow as Studentlnformation continues development Import Formats ATT2SIS Import Navigation Home Management Import Export ATT2SIS Import The ATT2SIS Import format will be used to load data from a sequential file to attendance records School
103. defaults to the IRN of the district to which the school building in context belongs This is used in the Header row of the file If this is an ITC enter the ITC s IRN Schools required If no Schools are selected the report will not include any Schools You can also filter by selecting specific Schools for your export Social Security Number required Choose the format of SSN to be included in the Export Existing Student Code required Choose how the Student Code should be generated Note that the Y option indicates that a student code exists and a new student code should not be generated Student Options required Choose the students to export Export Execute the Export process ProgressBook Studentinformation Import Export Guide 33 Studentinformation creates an export file to be sent to the third party vendor for processing The file is comma delimited and each data value is enclosed in double quotation marks Each file record will be delimited by a carriage return and line feed The first record of the file will contain a header row listing the following fields e IBM User ID entered e Date and time the file was created formatted as mm dd yyyy hh mm ss e Source building IRN entered e Source district IRN entered The header row will conform to the same field layout as the rest of the file with the header row data fields mapping to the following primary data fields respectively e First Name e Date
104. demographic data from Studentlnformation to INFOhio for use in the Patron files in the library software Most ITCs set up the exports to run automatically at night for each of their buildings Three separate options are available in Options INFOhio Export tab for the homeroom assignment to include in the record for each building administrative period or department Please see the School Setup and Configuration End User Guide for the DASL Options INFOhio Export details If the nightly extracts fail to complete the file created from Studentlnformation does not get loaded into the Library system When no record comes over from Studentlnformation for a student regardless of the reason the student automatically gets changed to Expired in INFOhio If a new record is loaded for a student to correct the issue the student s status will be updated automatically ITC Considerations ITC Staff should check the logs daily to ensure that the extracts and loads completed successfully If logs are checked first thing in the morning and it is discovered that a load failed once the issue is identified and the resolution found extracts can be reprocessed and the files reloaded to quickly resolve the issue Log files for the otudentlnformation extractions reside in the Log direction on the Alpha Studentlnformation Support staff should notify INFOhio support when a otudentlnformation update is applied in case something changes that has an effect on th
105. dent for Pearson Educational Measurement Export 89 Prelident tOr O TELA ee La 0 pne ia oe ae ave ao oe ko oe a 99 PREO NOVO EE 104 Preldent Ior PARGO EE 106 Preldent for Ohio Online Field TeS cerr n 107 Preldent ior NINA S 109 Preldent for Science and Social Studies 0 nn0nnnn0nnoennnnnnnnnnnnrnennnnnnnnnrsnnrennne gt 111 miele apice rr T 114 FOSTO Made POUCH NOVO e LE 115 Lange PNOO EXDON WEE 116 Lima Gle LOUGH Polo EXDOM GE 119 e EE s 121 ProgressBook Studentlnformation Import Export Guide Eeer 123 AIR Export Home School District in Context 123 RIB ee Lu ERT gel RE el E AE 128 We ila NOV tt doro EE 133 SAS eeler EXPO SE 142 WebX am EXO ON ettet ah Pe oh aed Mie iat eek inh aad Mahe Hori eas 144 REITER 147 District Roster for Medicaid Billing Export 153 Eeler Ol SIG EXPO EE 154 MAINS CMO LS TTE E 155 ProgressBook Studentlnformation Import Export Guide V Vi This page intentionally left blank ProgressBook Studentlnformation Import Export Guide Import Export Overview otudentlnformation needs to be able to exchange data in order to provide both import and export capabilities The method of data exchange selected for each import export will be based on the best method for the task to be accomplished The following methods are ways that data can be exchanged using Studenilnformation File Upload Import
106. differs from other areas of the import in that no complete student record is imported Only specific fields from the Student Attributes record are updated Other fields in the Student Attributes record are filled with When the import encounters this character in any field the field value is ignored and not imported All files are in the Chapter 5 format Student Attributes FD Record Special Education Import Logic 1 If the import file contains an FD record with the same disability condition and the same effective start date as the open FD record in Studentlnformation the Studentlnformation import does not load the record 2 fthe import file contains an FD record with the same disability condition as the open FD record in Studentlnformation but a different effective start date the Studentlnformation import does not load the record and flags an error on the Import screen 3 Ifthe import file contains an FD record with a different disability condition than the open FD record in Studentlnformation regardless of start date the Studentlnformation import loads the imported disability condition over the existing disability using the imported effective start date closing any appropriate records as needed ProgressBook Studentlnformation Import Export Guide 27 4 Ifthe import file contains an FD record with a different Section 504 value than the open FD record in Studentlnformation regardless of start date the otudentlnformation imp
107. ds will still be included in the export file Once the Preview button is clicked and Preview grid displays an Export button is available Clicking the Export button will create a precta seq file in the proper file layout which can be saved Filter Selection Tab WebXam Export From this screen you can export data for a specific file format Ad Hoc Selection Filter Selection ka Export file will include only students in grades 09 10 11 12 13 and 23 who are in selected filter criteria Schools ASJH ASHLAND MIDDLE SCHOOL ASED EDISON ELEMENTARY SCHOOL ASLI LINCOLN ELEMENTARY CTE Program of Concentration AO Agribusiness and Production Syster A1 Agricultural and Industrial Power Tz s A2 Animal Science and Management A3 Biotechnology for Food Plant and A 7 Assessment Coordinator amp Use Default Assessment Coordinator for Program of Concentration Use Teacher of Record from applicable courses Include Tech Prep Completer Students without CTE Program of Concentration Preview ProgressBook Studentinformation Import Export Guide 145 Schools required All schools for the district are listed Select one or more schools by moving the school from the left dual select box to the right dual select box CTE Program of Concentration required Choose a default element that designates the program of concentration for a CTE concentrator that will be assigned to any student that does n
108. e StudentName Birthdate Address Creditunits CourseCode GradeLevel kel city SectionNumber HomeroomCode State staffcode Lol ParentName Zip Z Period CourseName Building Will default to current building 46 ProgressBook Studentlnformation Import Export Guide Term required Choose the Term for which the Export is to be created Reporting Period required Choose the Reporting Period for which the Export is to be created Teachers Excluded Teachers Included required Choose the teachers to be included or excluded in the Export Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process File Download 9 Some files can harm your computer IF the file information below wt looks suspicious or you do nat fully trust the source do not open or save this file File name DAHS txt File type Text Document From dsldema mcaecn arg Would you like to open the file or save it to your computer Cancel More Info Save Save this file to your hard drive or network drive The export file is of fixed width columns is left justified and uses spaces for padding All students in the working school for the current school year are included in the export if they have class list records Following are the fields included starting position and field length are in parenthese
109. e Levels Available Grade Levels Chosen Student Statuses Available Student Statuses Chosen A ACTIVE RES D DELETED I INACTIVE N NON RES Home Schools Available Home Schools Chosen High School East High School High School ton High School Include only students admitted after MEM Students must have an SSID on their current FS record to be included in the extract Students must have a Home School IRN set on the student profile to be included in the extract Schools Available optional Move one or more schools from the Schools Available select box to the Schools Chosen select box If no schools are moved to the Schools Chosen select box all schools will be selected Grade Levels Available optional Move one or more grade levels from the Grade Levels Available select box to the Grade Levels Chosen select box If no grade levels are moved to the Grade Levels Chosen select box all grade levels will be selected Student Statuses Available optional Move one or more student statuses from the Student Statuses Available select box to the Student Statuses Chosen select box If no student statuses are moved to the Student Statuses Chosen select box all student statuses will be selected Home Schools Chosen optional Move one or more home schools from the Home Schools Available select box to the Home Schools Chosen select box If no home schools are moved to the Home Schools Chosen select box all home schools will
110. e Machine and GradeQuick This export file is used to import and populate these programs for grade reporting Building level personnel produce the file and then FTP the file to their server so that the file can then be imported into the grade book program ProgressBook Studentinformation Import Export Guide 43 The only limitations placed on users is that their Grade Book software must be able to import the SIS GRBK export file and that their Grade Book software can export a file in the designated format and naming convention for use as an import file for the LOAGRADE program There are two Gradebook exports available in Studentlnformation Original Format and Extended Format Gradebook Export From this screen you can export data for a specific file format Select an Export Format Select an Export Format Original Farmat Extended Format Original Gradebook Export Navigation Home Management Import Export Gradebook Export Select Original Format from the drop down menu Gradebook Export From this screen you can export data for a specific file format Original Format bul Building DASL HIGH SCHOOL Term Select Term 4 Reporting Period Select Reporting Period 4 Teachers Excluded MARCIA ALLEN MARK ALLEN Z RAN ALLSS CINDY AMOR Ki Export Fields Farmcode Z CourseCode v Gender v GradeLevel StudentNumber SectionNumber Phone HomeroomCode v Stud
111. e Student Gender 54 1 e Phone 55 8 formatted as nnn nnnn e Birthdate 63 8 formatted as mm dd yy e Grade 71 2 e Homeroom 73 4 This export file then will be imported into the grade book packages mentioned above When grades are ready to be submitted for grade card processing the grade book package will create an export file with the grades and or attendance to be imported back into the Studentlnformation application That import process is covered in 1C LOAGRADE Import ProgressBook Studentinformation Import Export Guide 45 The following figure shows an example of the Original Gradebook Export file E DAHS txt Notepad File Edt Format View Help dd re JASON WILLOS x OI OOO0O OOZRING NICOLE UZANNEOS 2 xOLlO00007Q005WILLIAMSOH RYAN SETOS2 xOlO000007001CONTRARY JASON WILLOSS XOlO000007002PERRY RICHARD MATTH S3 xOTlO00000 003RINMG NICOLE SUCANNEDSS COLOOOOO7 004 SARGENT LEANN JEAN 053 xOLO OO O POOSWITLLIAMSOM RYAN SETOSS x OU OCOOOOGOOLETE CORY ROBERT 1716 xOlO000006002FONT MICHELLE LYNN 1716 xOl00000600323OMES WHITNEY ANN 1716 x lO000006004LINE TROY AARON 1716 COLOR SME DAISY LEE 1716 x OLOOOOO FOOL ONTRARY JASON WILL183 xOlOQ00007003RIHG NICOLE SUZAHHElB83 xOlO00007005WILLIAMZONH RYAN SETLES OLOOOOOSO0LEYE CORY ROBERT 21d xOlO00006002FONHT MICHELLE LYNN 214 xOlO0000000032OMES WHITNEY ANN 214 xOlO000006004LIHE TROY AARON 214 COLOR SMa DAISY LEE 214 xOTlO000004005wWELLS JOBETH
112. e as follows with the starting point of that field and the length in parenthesis e Student ID 1 9 e Student Last Name 10 18 e Student First Name Middle 28 14 e Address 1 42 25 e Address 2 67 25 e City 92 18 e State 110 4 e Zip 114 9 e Area Code 123 3 e Phone 126 7 e Parent 133 25 e Sex 158 1 e Birthdate 159 8 formatted as yyyymmdd e Grade 167 2 e Homeroom Teacher Code 169 4 will be blank if the student has no homeroom e Student Social Security Number 173 9 e School Code 182 4 The following figure shows an example of the Lunch Export for WAPAK City Schools export file P DAHS 1 txt Notepad Fie Edt Format Vew Hep 48652258 Banan Hannah Rose 2117 cherry Street Lima F1987 Bei 709wt 882687221 DNE 48652327 Jam St PO Box 435 Ottawa M1 9900525 17WEBB4 564567 89DAHS 48652557 teste christine 111 street Lima 3081212 DAHS ISY LEE 600 BLOOM DRIVE LIMA SHARON LEE I 1988100412wt BEI 2376845 3DAHS WELLS OBE TH 843 NORTHWALD DR LIMA MITCH WELLS F19861 223 LO out 23098654DAHS IRGE EVAN 597 STATE STREET LIMA 4195551212HOWARD JOHNSON M1986091310C0US458769300DAHS CORY a RT 1 NORTH SI LIMA EDWARD EYE M198907161 1WEBB589098456DAl NICOL 3 SUZANNE 9065 BLISS RD LIMA NICHOLAS RING F1 989051 111WAl Lan so 23 MOCKINGBIRD LANE LIMA 4193452345ATTICUS FINCH deer 03011WAI 1678956677DAKS ASON WILLTAM 90 ELM STREET LIMA MARTON CONTRARY M1990021411WALT369852369D DAHS
113. e data extracted nightly This would be an especially important time to check those nightly logs to make sure there are no problems as a result of the update For any of the homeroom options used it is possible that the value of a student s homeroom may change at the end of the semester or quarter Make sure the files are checked at that time to ensure all necessary homeroom information is there If a student is missing homeroom information in the record the student s homeroom will be changed to unknown in the library software The INFOhio Export will only use the finalized schedule 36 ProgressBook Studentlnformation Import Export Guide INFOHIO Export From this screen you can export data for a specific file format Export Fields Student Number State Parent Name First Name Building IRN Zip Homeroom Called Name Name Phone Teacher Name Middle Name Graduation Withdrawal Date SSN Program Code Suffix Gender Birthdate Home School Email Address Grade Last Name Status Code City Export Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export In the export file each field will be enclosed in quotation marks and separated from other fields by the character Check with your librarians to determine which fields they wish to have included in the export file Homeroom checkbox The Homeroom checkbox can be configured to use Administrative Homeroom Period Homeroom or Department Homeroom o
114. e district Export file must be manually separated in order to create an Export file for each High School Export A file is created After opening this file and verifying the date email the file to the Home School if necessary The Course History file layout will be as follows with the starting point of that field and the length in parenthesis The output file defaults to the name otudentMarks000000 S EQ where 000000 is the Home School District IRN The file is a fixed width file with a header row File Format Field Name Position Description O StudentNumber 1 9 GradeLevelCode 10 14 lastName 12 29 FirstName 30 43 O CaledName 44 51 o J SSIDOrEMISD 52 60 3 o O HomeSchoolCode 61 64 O SchoolYear 1 65 68 O Abbreviation 69 76 gt 0 O SectionNumber 77 78 CourseShortName 79 98 SehoolCode 100 108 PO CourseGradeLevelCode 110 111 PO AreaOfStudy 120 122 123 125 TransferCode 126 jo MarkAlphat 127 129 MarkNumerict 130 195 PO 136 146 MakAlpa2 158 160 MarNumerice 161 166 ProgressBook Studentlnformation Import Export Guide 51 Field Name Ss Position Description MarkAlpha 189 191 O MarkNumerica
115. e export prior to creating the export file The students Legal Last First and Middle Name will be used if provided for the student Records in the Preview grid will be flagged if a Default Assessment Coordinator has not been chosen on the WebXam Assessment Coordinator Records page or if the student is not in a course that matches the filter criteria however those records will still be included in the export file Once the Preview button is clicked and Preview grid displays an Export button is available Hide Existing Students Student Student First Student Student Last Building Ende Summative Race EMIS ID a Mid Name EES IRN Gender CTE Program Of Concentration Staff ID Assessment Coordinator E 28 MARIE 028910 11 Ww F AO Agribusiness and Production Systems Clicking the Export button will create a precta seq file in the proper file layout which can be saved 146 ProgressBook Studentlnformation Import Export Guide File Download Do you want to open or save this file Name precta seq Type SEQ auto file From dev webl noacsc org While files from the Internet can be useful some files can potentially harm your computer If you do nottrust the source do not open or save this file Save Save this file to your hard drive or network drive Export File Format The pre ident file is named precta seq with the following fixed length format Position Fild U Ucsc O 12 111 116 District of Res
116. e have errors Next Process the file selected and go to Step Two or Step Three if no errors are found Step Two Errors In Step Two you will be presented with the List of Errors on Import If no errors are found you will skip Step Two and proceed directly to Step Three 8 ProgressBook Studentlnformation Import Export Guide li LOAGRADE Import Step Two List Of Errors On Import Type Value Line Number Na Student Number Found 870 3 No Course Section Found 3210 03 4 Start Over Next gt Type Indicates the Type of error Step Two will check for valid data for Course Sections Course Section Marking Patterns Students Mark Values Teacher Comments and Work Habits Error Type The course section listed is not a valid active course l section in the current building and school year OR The No Course Section Found l course listed is not a valid active course in the current building and school year The student number listed is not enrolled in the current No Student Number Found l building and school year No Student Course Section The student number listed is not enrolled in the course Assignment Found section listed The mark listed is not a valid active mark in the current No Mark Found o building The Comment listed is not a valid active General Comment No General Comment One Found uu in the current building The Comment listed is not a valid active General Comment No General Comment Two
117. e level a grade level higher than the student s enrolled grade Y Yes student is being tested in an accelerated grada N No student is being tested in enrolled grade Blank Mat Indicated assume student is being tested in enrolled grade Numene IF accelerated testing lag is Y indicate the grade evel at which the student is tested Must be numeric Valid values are 03 04 05 06 07 and 08 Accelerated testing grade must be higher than student s enrolled grade Accelerated Testing Indicator Reading Accelerated Testing Grade EE mud enrolled grade Y Yes student is being tested in an accelerated grade N No student is being tested m enrolled grade Blank Nat Indicated assume student is being tested in enrolled grade Numeric If accelerated testing flag is Y indicate the grade level at which the student is tested Must be numeric Valid values are Od and OF Accelerated testing grade must be higher than student s enrolled grade 333 Accelerated Testing Grade Writing ProgressBook Studentinformation Import Export Guide Comments Acceptable values Her ooo OM Glass Name Course Name eu reg Optional Opbona l Optional Opt ona Jpbona Optonal Optional Optional unless student is participating in accelerated Le Aptonal uniess student is participating in accelerated testing Jpbonal unless student is parficipatmqg in accelerated test D
118. e of Student ID Absence Date Absence Type Absence Time or Absence Reason that is causing the error Start Over Start Over and go back to Step One You must correct the errors in the ATT2SIS txt file before you can go to Step Three of the ATT2SIS Import Step Three 4 ProgressBook Studentlnformation Import Export Guide Step three will show you the attendance record s that have been processed ATT2SIS Import Step Three Process Code 5tudent ID Student Name Student Telephone Date Type Time AMPM Reason Note I 0468652304 Smith Jenna 419123456 11 16 2004 E I P Start Over Start Over and go back to Step One to process another ATT2SIS txt file Attendance records processed through the ATT2SIS Import process will be notated as Record created by data import process in the Student s School Absences ue Student s School Absences From this screen you can display add change and delete data pertaining to student absences Start Date 8 24 2004 v 7 End Date 11 17 2004 7 Daily Attendance Period Attendance Add Absence Date Time Absence Level Absence Type Reason Note Comment A f Oct 01 2004 11 13 AM 0 50 S FIELD TRIP X Nov 15 2004 07 45 AM 1 00 E Record created by data import process X 4 Nov 16 2004 07 45 AM 1 00 E ILL PRNT CALL Record created by data import process State Student ID Import Navigation Home Management Import Export State Student ID Import All students in the state of Ohio
119. e page displayed so you can enter any missing data Continue Process the export without any of the listed students included Cancel Do not process the export and return to the State Student ID Export page File Download Do you want to open or save this file Mame DASL Demoz tn60417 ExE Type Text Document From dasldema mcaecn arg While files from the Internet can be useful some files can potentially harm your computer IF pou do nat trust the source do not open ar save this File Whats the risk Save Save this file to your hard drive or network drive Sample Output E DASL Demo20060417 txt Notepad File Edit Format View Help DASL User Q01 04 17 2006 02 58 50 033084 043877 333 3 9 3 3 3 3 9 9 3 9 9 9 9 99999 9 9 n n n n n n n n A Hannah Banana 08 17 1987 F 268722176 N 7033084 043877 7 ENG W Lima ROSe sss ss 118 ProgressBook Studentinformation Import Export Guide 35 INFOhio Export Navigation Home Management Import Export INFOhio Export INFOhio is the statewide library software system The system maintains student records in order to track automated library resource sharing and materials checkout The INFOhio system will receive a feed of student data from the Studentlnformation application to populate its student information data store The INFOhio Export is usually performed on a nightly basis to send
120. ease correct the following errors 1331231331335 is an invalid student number lf the student numbers are valid you will receive validation as follows Choose students by filters Choose students by student numbers Choose students by ad hoc membership Enter a comma Separated list of student numbers to include in the extract Edit Student Numbers Students must have an SSID on their current FS record to be included in the extract Students must have a Home School IRN set on the student profile to be included in the extract Click Edit Student Numbers to further edit the student numbers before Export IMPORTANT Students must have an SSID on their current FS record to be included in the extract Students also must have a Home School IRN set on the student profile to be included in the extract 130 ProgressBook Studentlnformation Import Export Guide Choose students by ad hoc membership lb AIR Export From this screen you can create an AIR export file Choose students by filters Choose students by student numbers Choose students by ad hoc membership Choose an ad hoc membership containing students to include in the extract Select an Ad Hoc Membership Public And Private Students must have an SSID on their current FS record to be included in the extract Students must have a Home School IRN set on the student profile to be included in the extract Ad Hoc Membership required Specify an Ad Hoc Me
121. ect this check box If you do any Contract Vocational In students in your file will generate an error and you Will not be able to upload the file Optional If you want to include JVS students in the export select the JVS check box Optional If you want to include JVS home school information on the export select the Include JVS home school information check box Note for non home schools lf you are not the resident district you want the home school to receive the information and you selected to include JVS students you should select this check box ProgressBook Studentlnformation Import Export Guide Note for home schools If you are the home school do not select this check box If you do any JVS students in your file will generate an error and you will not be able to upload the file 9 Optional To include only specific students in the export file in the Return only these students field enter the student IDs separated by commas Note When using this option you still need to select the appropriate Include assessments grade subject check boxes or the students will not be included in the file 10 In the Paper Online drop down list if students will take these assessments in paper booklet form select Paper If students are taking these assessments online select Online 11 Optional If you want to create separate export files for regular and alternate assessments select the Separate Files for AASWD and O
122. ed to import Student data Import Mode anaes e 9 Perform Import and Create Verification File Create Verification File Only Do Not Perform Import Admission Date 7 1 2011 T Z Admission Reason 6 Transferred from other Ohio public district community school Student Status v 4 EMIS Situation 5 Resident attending Full Time vi 7 imm Admitted From IRN District Relationship 1 Stud rcvg instr in whole part from rep dist District of Residence 43505 Ashland City SD How Received Not Applicable How Received IRN Percent of Time 100 Percent of Time must be greater than 0 and less Tuition Type N Non tuition student default than or equal to 100 D Assigned Building IRN Attending Building IRN Select Attending Building IRN e Sent To 1 Sent To 2 Reason NA Not sent to Reason NA Not sent to another district default IRN D IRN Percent of Time Percent of Time Import File Browse 7 Smart Logic has been built into the page to perform checks on the field values based on the selected EMIS Situation SMART Logic is indicated by a light colored background and the text changed by SMART and it assists the user in providing the correct field data Import Mode required You must choose one of the following Import Mode options e Perform Import and Create Verification File Processing will import all valid records and also create the import verification
123. eldent For Ohio Online Field Test 3 Optional In the Include the following grades option select the check box beside each grade level to include in the export file ProgressBook Studentinformation Import Export Guide 107 4 Optional To include high school students select the Include High School Students check box 5 Optional In the Include the following students option select any of the following options to include students with these conditions e Contract Vocational In students that are non residents of your district attending as a contract vocational student e Contract Vocational Out students that are residents of your district attending another district as a contract vocational student Note If your district is testing these students and you want to receive the results you should include these students in your file 6 Optional If you want to include contract vocational home school information on the export select the Include CVI home school information check box Note for non home schools lf you are not the resident district you want the home school to receive the information and you selected to include Contract Vocational In students in step 5 you should select this check box Note for home schools If you are the home school do not select this check box If you do any Contract Vocational In students in your file will generate an error and you Will not be able to upload the file 7 Optional
124. els Chosen PS PS KG KG 01 01 02 02 Student Statuses Available Student Statuses Chosen A ACTIVE RES D DELETED I INACTIVE N NON RES Students must have an SSID on their current FS record to be included in the extract ProgressBook Studentinformation Import Export Guide 123 JVS District required If the school in context is not a JVSD a district IRN value for the JVS must be entered or selected from the dropdown list If the file is being created by the home school because the students are not yet enrolled in the JVS the home district will need to create a separate file for each JVS building students will be attending in the upcoming school year JVS required If the school in context is not a JVSD a building IRN value for the JVS must be entered or selected from the dropdown list The dropdown will list all JVS school IRNs associated with the selected JVS District IRN Choose students by filters Choose students by filters Choose students by student numbers Choose students by ad hoc membership Use the filters below to choose the students within the district to include in the extract Schools Available Schools Chosen AVHS ADA HIGH SCHOOL Led Grade Levels Available Grade Levels Chosen PS KG E 02 Student Statuses Available Student Statuses Chosen A ACTIVE RES D DELETED e I INACTIVE S N NON
125. ent you wish to use Click on Merge to New Document You will find the icon on your top menu bar It will show two small documents with a right arrow pointing to a larger single document Check and print The following fields are in the Export file such as DAHS TXT and available for use in your letters Reminder if an incident contains multiple actions the file will contain one record per action 42 ProgressBook Studentlnformation Import Export Guide DISCDT Field Names Description of Field Names StudentlD LastName FirstName ParentName IncidentDate Date incident occurred format YYYYMMDD example 20000927 IncidentDateFull Full date incident occurred format Month DD YYYY example oeptember 27 2000 IncidentDesc Description of incident IncidentPeriod seven comma up to 7 seven Action code You may want to use this field in the Filter if you have action specific letters Full action starting date format Month DD YYYY example September 27 2000 Full action ending date format Month DD YYYY example September 27 2000 Demerits includes decimal point Full action on date format Month DD YYYY example September 27 2000 Description of policies separated by comma up to four Gradebook Export Navigation Home Management Import Export Gradebook Export In SIS McSIS Poise the GRBK screen is used to create an export file for grade book packages such as Grad
126. entName staffcode l Birthdate Teachers Included Building Will default to current building Term required Choose the Term for which the Export is to be created Reporting Period required Choose the Reporting Period for which the Export is to be created Teachers Excluded Teachers Included required Choose the teachers to be included or excluded in the Export 44 ProgressBook Studentlnformation Import Export Guide Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process File Download 9 Some files can harm your computer IF the file information below s looks suspicious or you do not fully trust the source do not open or save this file File name DAS txt File type Text Document From dslderno mcoecni org Would vau like ta open the file ar save it ta your computer Cancel More Info Save Save this file to your hard drive or network drive The export file is of fixed width columns is left justified and uses spaces for padding All students in the working school for the current school year are included in the export if they have class list records Following are the fields included starting position and field length are in parentheses e Form Code 1 3 Always x01 e Student ID 4 9 e Student Name 13 20 e Course ID 33 15 e Course Section Number 48 2 e Teacher ID 50 4
127. eparting student assessment results Alpha This is the first name that will be used when reporting student assessment results Alpha This is the middle initial that will be used when reporting student assessment results Required Required Hequirad require Hequirad Required Required Required strict or School assigned 5 A nine character Opticona identifier first character may be numeric 0 9 or alpha 4 2 All ining characters must be numeric 0 9 State assigned Student ID only A nine character identifier first two characters are alpha all remaining characters are numere Required for public school students egurre Re Re quired quired American Indian 2 AsianiPacific Islander 3 Black African American 4 Hispanic 5 White 6 Multi racial T Other Unknown uUi E n Room Number E Mad hed BE preo Y z Migrant Student NeNot Unknown ProgressBook Studentlnformation Import Export Guide lesrrpiion Alpha numenc This field will be used to report the name of the class or course on reading teacher reports je g Reading English Literature Class Name Course Name Section Number and Teacher Name are optional However no classroom level report will ba generated if ALL the three falds ara laft blank Alphasnumeric This field will be used ta report the section number of the class or course on reading teacher rep sg 01 02 JA Alpha last name first name This field will b
128. er Type section select a file transfer type as follows e Flat file transfer Creates a flat file that you must manually load into the Data Collector ProgressBook Studentinformation Import Export Guide 157 Flat file transfer for Data Collector Creates a flat file moves the flat file into the Data Collector and stores it in a subdirectory named with your district s unique district code This is the most commonly selected option Click Submit iib Home gt gt Management gt gt Import Export gt gt eTranscript gt gt eTranscript Transfer Transfer eTranscript Data E From this screen you can transfer Period E eTranscript records Request Type Program Selection Select all transfers eTranscript Staff Contact CD eTranscript Staff Relationship CH eTranscript Student Academic Performance Summary FJ eTranscript Student Assessment FA eTranscript Student Attendance Summary FK eTranscript Student Attribute no date FM eTranscript Student Attributes FD eTranscript Student Contact Address FG eTranscript Student Contact Record FF eTranscript Student Core Summary GC eTranscript Student Course Academic Performance History FH eTranscript Student Demographics GI eTranscript Student Special Ed Graduation FE eTranscript Student Standing FS Transfer Type Flat file transfer CO Flat file transfer for Data Collector A confirmation message displays
129. ery Options To use only specific records select Filter Records In the first Field click the down arrow and select the field you want to use Fill in the Comparison field and the Compare to value For example if your letter is specific to Expulsions define the filter as follows ActionCode Equal to 1 To sort the records select the field you want to use for sorting by clicking the down arrow Finally click on OK To merge your letter and discipline data click on Merge suggest you merge to new document so you can look over the results before printing merge all records and do not print blank lines when data fields are empty this keeps an empty line from printing for address line 2 if it is blank Click Merge again Your merged letter will be displayed on the screen Scroll through to check it and then print When you click X to close out of the letters it will ask if you want to save the file If you have already printed the letters and or do not have a need to save the merged letters click No If there is some reason you want to save the merged letters click Yes When you are back at the letter containing tokens use Save As to save the document and name as you wish ProgressBook Studentlnformation Import Export Guide 41 If your form letter has already been defined use the following instructions to create letters with student discipline data Open Word Click on File Click on Open Click on or open the docum
130. es are as follows Terra Nova 34 Edition Complete Battery 097 Terra Nova 34 Edition Complete Battery Plus 098 Terra Nova 34 Edition Complete Battery InView or PTCS 099 Terra Nova 34 Edition Complete Battery Plus with InView or PTCS 100 Terra Nova 3 Edition Survey 101 Terra Nova 3 Edition Survey Plus 102 Terra Nova 34 Edition Survey with InView 103 Terra Nova 34 Edition Survey Plus with InView 104 Terra Nova 34 Edition Multiple Assessments 105 Terra Nova 34 Edition Multiple Assessments with InView or PTCS 106 Terra Nova 34 Edition Multiple Assessments Plus 107 Terra Nova 34 Edition Multiple Assessments Plus with InView or PTCS 108 Test Form Terra Nova 34 Edition Barcode Layout G Achievement Test Level Level 10 for grade K Level 11 for grade 1 Level 12 for grade 2 Level 13 for grade 3 Level 14 for grade 4 Level 15 for grade 5 Level 16 for grade 6 Level 17 for grade 7 Level 18 for grade 8 Level 19 for grade 9 Level 20 for grade 10 Level 21 for grades 11 and 12 Ethnicity 1 American Indian 2 African American or Black and not Hispanic 3 Asian 4 Pacifica Islander 5 Hispanic or Latino 6 White and not Hispanic 7 Multiethnic 8 Other InView or PTCS Level The InView or PTCS level will only be used if the test code selected is for a combination test Numeric or blank Blank for CTB use only ProgressBook Studentlnformation Import Export
131. es created by the JVSGRADASL program in SIS POISE there is only rarely a Term 3 or Term 4 mark and the Final is Term 5 Import Mode required You must choose one of the following Import Mode options Perform Import and Create Verification File Processing will import all valid records and also create the import verification file The verification file will be named StudentMarksVerificationFile xxxx txt where xxxx is your building code Create Verification File Only Do Not Perform Import Processing will only create the import verification file and not actually do any imports The verification file will be named StudentMarksVerificationFile xxxx txt where xxxx is your building code This option allows you to view the errors in the file and correct the errors before performing the actual import IMPORTANT It is strongly suggested that you run this option first to check for errors This option will also perform the student identifier check Perform Student Identifier Check Only Do Not Perform Import or Create Verification File Processing will only check the import records for a student match and show any students that did not match onscreen It will not produce a verification file or import any records Student Student Name Error Message 088761 AL I EVAN Student not found Nothing will be imported ProgressBook Studentinformation Import Export Guide 15 Primary Student Identifier for Import required Choose State S
132. esi xOLOOOOOSOOLCONTRARY MARY M 382 xOlO000005002PERRY MICHAEL JAY 382 xOLOCOOOOSOOZPOTTS TAN MICHAEL 382 xOlOO00005004S5PRAT JACK JOSEPH 382 xOlO000005005wWELLS JONA RENEE 382 KOLO OOLEYE MAGHUM P 431 Extended Gradebook Export OZAUSTM DZ2AUSTF ZAUSTM OLAUSTM OLAUSTM OLAUSTF Febid 9006 Mayll BsQs Ocr15 89098 Febl4 9009 Apr24 8G06 Mayl11 8909 lAUSTF555 98765Sep30 8909 OLAUSTM OLBERRM lBERRF OLBERRF OLBERRM OLBERRF O BEREM OZBERRF O2BERRM OLBERRM OlBERRF OLBERRF OLBERRM OLBERRF OZ2BERRF Octl 5 8909 Jul16 8610 Janos 8910 Augl4 8910 Febo2 8010 Oct BEL Febld 9009 Mayll 8909 Oct15 8000 3u115 8910 Jano5 8910 Augis SILO Febo2 8010 octiM 8810 Dec23 8612 LBERRF228 7417Ho0v17 8711 OLBERRM O1LBERRM DeciM 8711 sep20 8711 LlBERRM228 7417FebQ02 BBl11 LBERRF Marl 8811 Brie SBERRMI11 2222Apr 3 Navigation Home Management Import Export Gradebook Export Select Extended Format from the drop down menu Gradebook Export From this screen you can export data for a specific file format Extended Format kad Building DASL HIGH SCHOOL Term Select Term 4 Reporting Period Select Reporting Period 47 Teachers Excluded Export Fields l FormCode Gender StudentNurnber M Phone kel SSN Teachers Included MARCIA ALLEM MARK ALLEM ee S RYAN ALLSS CINDY AMON Counselor FirstName l LastNarn
133. for Medicaid Billing screen District Roster for Medicaid Billing ABCD Xooooxxx City Schools v 5 Click Create Download File 6 Click Save in the File Download window pa Download Do you want to open or save this file a Mame SL_DistrictRoster MedicaidBilling_Download csv Type Microsoft Excel Comma Separated Values File From daslweb gt While files from the Intemet can be useful some files can potentially i ham your computer If you do not trust the source do not open or save this file What s the risk 7 Select the appropriate directory and click Save in the Save As window ProgressBook Studentinformation Import Export Guide 153 This file contains comma separated values and has a CSV file extension The fields included in this file are Student Last Name Student First Name does not include middle name or initial Student ID Number Birthday in mm dd yyyy format social Security Number without dashes or spaces between numbers Address 1 house number and street name can include apartment number or building name Address 2 apartment number or building name City state ZIP Code Grade Level includes preschool kindergarten and out of district School Building Name School Building Code school Building IRN The following figure shows an example of DASL_DistrictRoster MedicaidBilling Download csv fe Studenti2698 e D E E 14456 HHHHHH 7 16E 08 645 S Main St 45804 124 3 Elida
134. formation bd This export format has no options and includes information about all teachers listing a Social Security Number in their staff member records Export Execute the Export process Fields included in the export are the following Teacher ID Teacher Social Security Number Teacher Last Name and Teacher Title Initial Empty Field two spaces inside double quotes Teacher Address Teacher City State Zip Empty Field one space inside double quotes The following figure shows an example of the Teacher Information Excelsior Export file 84 C 1390987900 ALLEN MARCIA GGOOOSE FE ALLEN MARK zu of 6ss09e7 ALLSS RYAN DOUD AMON CINDY Bzb5b4557 ASH BRITTANY 234567090 AUSTIN SHARRI 645 MAIN STREET AFT 1 LIMA OH 413 722 8741 of 6908765 BAER JOHN 090907657 BAUM SAM gana 554 BELL BILLY 123455789 BERRY DONALD 220900 RD 1 18 KALIDA 0419 475 6900 906759065 BOYER JEFF 690976709 BRIGGS DEBRA 455789012 CASTLE RONALD 900 SUGAR STREET LIMA OH 419 226 8900 bz8801234 CLARK SUSAN DU WAYNE STREET LIMA OH 413 228 3340 345578301 COUSINS DAVID 400 4TH STREET LIMA OH 419 225 7830 OF 6569032 CROFT LAURA BesanBzb54 DAILY TRISHA 907669087 DRAKE LAURA FESOOSE FE EWING MOSES 301234557 HANDLEY MARK 830 MAIN STREET LIMA OH 419 224 9000 12345670 JOHN JEFFREY 6500 VEST STREET APT 100 LIMA OH 419 226 9000 309890957 Jones Mary 090123456 LAYMAN LAURA 0208 CANTERBURY DRIVE LIMA OH 419 225 6901 5
135. g an ad hoc membership group including students who are planning on attending the JVS in the next school year The file would then be sent to the JVS staff for submission to AIR Ad Hoc Membership required Specify an Ad Hoc Membership Group to limit the report to the students in this group All other selection criteria will be ignored Click to create a new ad hoc membership You will be taken to the Ad Hoc Memberships where you can create a new ad hoc membership and return to the Air Export Choose students by ad hoc membership tab Check Public and to see Memberships created by other users in your drop down list IMPORTANT Students must have an SSID on their current FS record to be included in the extract Export Export Execute the export process with the filters selected Cancel Cancel the export process File Download Do you want to open or save this file Name AIR AV 128835373218788575 txt Type Text Document From dev webl noacsc org While files from the Internet can be useful some files can potentially harm your computer lf you do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive The following figure shows an example of the AIR Export file when a home school district is in context C AIR AV 128836805718895066 1 txt Notepad 050999050777Test JVSD Test Career Center JVSD 045111000067Test Vill SD Test High School Student67557 FRE
136. g tested in an accelerated grade N Na student is being tested in enrolled grade Blank Not Indicated assume student rs being tested in enrolled grade Numenc If accelerated testing flag is Y indicate the grade level at which the student is tested Musi be numeric Valid values are 05 and 08 Accelerated testing grade must bo higher than student s enrolled grade Alpha indicate whether the student will be administered a test in an accelerated grade level a grade level higher than the student s enrolled grade Y Yes student is being tested in an accelerated ade M No student is being tested in enrolled grade Blank ot Indicated assume student is being tested in enrolled grade Numeric lf accelerated testing flag is Y indicate the grade level al which the student is tested Must be numeric Valid values are 05 and 08 Accelerated testing grade must bo higher than student s enrolled grade A nha nurnerc Uisticts may provide teacher credential IU numbers so that teacher level results can be tracked across test administrations Alphanumeric Districts may provide teacher credential ID numbers so that teacher lavel results can be tracked across test administrations Alpha numeric Districts may provide teacher credential ID numbers so that teacher level results can be tracked across test administrations Alcha numeric Districts may provide teacher credential ID numbers so that teacher level results can be tracked across
137. gt Special Education Import 5p5 Special Education Import SpS Please select the 5ps file to import District Dalton Local Schools School Year 2013 2014 File name Browse No file selected Run Options Student Attributes FD Student Program GQ Student Special Education Events GE Student Special Education Graduation Requirement FE Student Achievement Test Student Ohio Graduation Test Student Kindergarten Readiness Assessment District Defaults to the district in context Only districts can perform the Special Education Import function You will receive the following message if a district is not in context This page can only be accessed for Districts School Year Defaults to the school year in context File name required Browse to the Special Education Import file to be imported 24 ProgressBook Studentlnformation Import Export Guide Run Options required Choose one or more Special Education Import file options The Special Education Import will process the Special Education Import files that are checked See the following sections for detailed explanation and file layouts of each Run Option e Student Attributes FD e Student Program GQ e Student Special Education GE e Student Special Education Graduation Requirement FE e Student Achievement Test e Student Ohio Graduation Test e Student Kindergarten Readiness Assessment If no Run Options are selected y
138. he number of Course Sections listed in the import file which are linked to this particular Marking Pattern Mark One Import the first Mark in the import file into the selected Mark for the listed Marking Pattern Mark Two Import the second Mark in the import file into the selected Mark for the listed Marking Pattern Mark Three Import the third Mark in the import file into the selected Mark for the listed Marking Pattern Mark Four Import the fourth Mark in the import file into the selected Mark for the listed Marking Pattern Note The Mark One Mark Two Mark Three and Mark Four can be changed as needed by choosing the correct mark from the dropdown list this list is populated by default from the Marking Patterns defined in Studentinformation see the ProgressBook Studentinformation Marks Guide for details Import marks for dropped assignments optional If checked marks will be imported for students dropped course section assignments Note Marks for removed course section assignments are not imported Reporting Term for Comments optional Select a Reporting Term from this pull down Comments included in the LOAGRADE Import file will be loaded as Comments linked to the selected Reporting Term Mark Type for Comments required Select the proper Mark Type for Comments The Mark Type for Comments drop down will be populated with values that correspond with the chosen Reporting Term for Comments Start Ove
139. heduled basis Please see the Maintaining Studentlnformation section of the ITC documentation for further details File Download Some files can harm your computer IF the file information below wal looks suspicious or you do not fully trust the source do not open or save this file File name STUD DLIMP csv File type Microsoft Office Excel Comma Separated values Fil From dsldemo mcoecn org Would vau like to open the file or save it to your computer Always ask before opening this type of file Save Save this file to your hard drive or network drive for FTP to Excelsior as needed Course Detail Information Format 78 Excelsior Export From this screen you can export data for a specific file format Course Detail Information hl Artificial Course Only Mon artificial Courses e Course Type Filter Mat Used hu Get scheduling info based on current Schedule Term ProgressBook Studentlnformation Import Export Guide Artificial Course Filter exported data by artificial course status or select Filter Not Used Course Type Filter exported data by course type or select Filter Not Used Get scheduling info based on current Schedule Term Check this box to use the current Schedule Term s scheduling information Export Execute the Export process Fields included in the export are the following Teacher ID Course ID Course Section Number Course From To Period Course Room ID The
140. heir credit values 156 ProgressBook Studentlnformation Import Export Guide Jones Mark E CORE Area Code CORE Area Count Credits Courses In Progress Credit Amount Projected Courses Credits Deficient CA ELE 1 000000 0 000000 0 000000 um O EC EC EES alues of 99 99 are not required for graduation and are not included in total 0 000000 1 000000 0 000000 0 000000 i 2 000000 0 000000 0 000000 1 000000 2 000000 0 000000 0 000000 0 000000 CORE Area Count Course Name CORE Area Count GradeL evelCourseTaken Manually Entered 0002 41 SPEECH COMMUNICATIONS 0 500000 09 e 0160 71 HEALTH AND NUTRITION TOPICS 0 500000 99 Ne Credits Courses In Progress No Records for this Student Credit Amount Projected Courses Mo Records for this Student eTranscript Transfer Navigation Home Management Import Export eTranscript eTranscript Transfer 1 On the Request Type tab click Next Ib Home gt gt Management gt gt Import Export gt gt eTranscript gt gt eTranscript Transfer eTranscript Transfer Period E From this screen you can transfer Period E eTranscript records Request Type Program 5election Transfer eTranscript Data E EE 2 On the Program Selection tab select the check box beside each student and or staff record you want to include in the transfer Or to include all records select the Select all transfers check box 3 In the Transf
141. ict DASL Local SD School Year 7005 27006 Please Note For projections change context to the new year Action e All Students student Updated since last run date we Include the deleted students since last school year Action required Choose All Students or only Students updated since a specified last run date Can also choose whether to include the deleted students since last school year Export Execute the Export process File Download lt P Some files can harm your computer IF the file information below wa looks suspicious or you do not fully trust the source do not open or save this file File name EDUCA SEO File type From dsldema mcaecn arg Would vau like ta open the file or save it to your computer Cancel More Info Save Save this file to your hard drive or network drive 64 ProgressBook Studentlnformation Import Export Guide The file is fixed width left justified with spaces for padding The file layout will be as follows with the starting point of that field and the length in parenthesis ProgressBook Studentlnformation Import Export Guide Student ID 1 9 Student Last Name 10 18 Student Given Name 28 14 Student Called Name 42 8 Resident Address 50 25 Mailing Address 75 25 City 100 18 State 118 4 Zip 122 9 Area Code 131 3 Phone 134 7 Parent Guardian 141 25 Sex 166 1 Birth Century 167 2 Birth Year 169 2
142. idence IRN The following figure shows an example of the WebXam Export file 000012 CHE MARIE BU 02891004937911WF AO DataMap Export Navigation Home Management Import Export DataMap Export This export is specifically for use by the DataMap application The DataMap application performs in depth analysis of this export data and student assessment data The DataMap Export function can be accessed only with a district in context If you do not have a district in context you will receive the following message ProgressBook Studentinformation Import Export Guide 147 DataMap Export This page is not available for your Working School With a district in context the DataMap Export will create an export file for each of the export options Class List Staff List Student List and KRA L List Ill DataMap Export From this creen you can create an DataMap export file 7 Class List 7 staff List 7 student List 7 KRA L List BRES BLACK RIVER ELEMENTARY SCHOOL BRHS BLACK RIVER HIGH SCHOOL BRJH BLACK RIVER MIDDLE SCHOOL School Year 2011 2012 2010 2011 2009 2010 2008 2000 UDS Select All Exports optional Selects all four exports to be created Individual export files are created with the names DataMap Class csv DataMap Staff csv DataMap Student csv and DataMap Kral csv Schools optional Choose the schools to be included in or excluded from the export Grade optional Cho
143. iew 8 Plus 2 Edition 094 InView Terra Nova 2 Edition 095 Terra Nova 34 Edition Complete Battery 097 Terra Nova 34 Edition Complete Battery Plus 098 Terra Nova 34 Edition Complete Battery InView 099 Terra Nova 34 Edition Complete Battery Plus with InView 100 Terra Nova 34 Edition Survey 101 Terra Nova 34 Edition Survey Plus 102 Terra Nova 34 Edition Survey with InView 103 Terra Nova 34 Edition Survey Plus with InView 104 Terra Nova 34 Edition Multiple Assessments 105 Terra Nova 3 Edition Multiple Assessments with InView 106 Terra Nova 34 Edition Multiple Assessments Plus 107 Terra Nova 34 Edition Multiple Assessments Plus with InView 108 114 122 Blank 123 136 Test Form Cat 5 A Terra Nova 15 Edition A Terra Nova 2 Edition C Terra Nova 34 Edition G ProgressBook Studentlnformation Import Export Guide 124 128 Achievement Test Level for instance Level 11 for grade 1 12 for grade 2 13 for grade 3 etc InView or TCS 2 Level 1 2 3 4 or 5 130 A scorable booklet Y or N This response determines whether the answer document is a scorable booklet Y with a pre coded Student Information Sheet or an answer sheet or folder N which does not require a Student Information Sheet 131 132 Sort type numeric All tapes are first sorted according to scorable booklets Y or N by test ID and by sort type in order to separate
144. ip Phone SchoolCode EMISStatus ParentName IzUnlisted AdmissionCentury SpecialEducation HomePhone Gender Admission Year EMISSituationID Birthdate BirthCentury W AdmissionMonth EMISSituationDescription StudentStatus Birthfear AdmissionDay Birthdate VerificationCode WithdrawalDate BirthMonth Admission Code LastStudentModifiedDate AdmissionDate BirthDay WithdrawalCentury W SchedulePriority WithdrawalCode v SSN WithdrawalYear ContactTypeCode CalendarCode Counselor WithdrawalMonth ContactTypeName Flagi SchoolYear Effective Homeroom Date required This date tells the system what FS and FD records to look for and also what date to look up homerooms for Action required Choose All Students or only Students updated since a specified last run date Can also choose whether to include the deleted students since last school year Export Fields Choose the export fields for your General Edulog Export These fields include Export Execute the Export process ProgressBook Studentinformation Import Export Guide 67 File Download Do you want to open or save this file Name EDUDA txt Type Text Document From dsldemo mcoecn org While files from the Internet can be useful some files can potentially harm your computer Ifyou do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive The file is fixed width left justified with spaces for padding The file layou
145. ipating in accelerated testing S pbonal unless student is participatmg in accelerated testing pts hi is parti opatmig in accelerated testing TIBC Ne 1 Accelerated Testing Indicator Mathamatics Accelerated Testing Grade Mathematics Accelerated Testing Indicator Socal Studies Accelerated Testing Grade Social Studies Accelerated Testing Indicator Suenre Accelerated Tasting Grada Science EE Teacher Identification Murnber Writing Teacher Identification Number Mathematics 370 Teacher Identification Number Socal Studies Teacher Identification Number scence Camrments Acceptable values Alpha Indicate whether the student will be administered a test in an accelerated grada level a grade level higher than the student s enrolled grada Y Yes student is being tested in an accelerated grade N Na student is being tested in enrolled grade Blank Not Indicated assume student is being tested in enrolled grade Numeric If accelerated testna flag is Y indicate the grade vel ai which the student is tested Must be numeric Valid values are 03 04 05 06 07 and Accelerated testing grade must be higher than student s enrolled grade Alpha indicate whether the student will be administered a test in an accelerated grade level a grade level higher than the student s enrolled grade Y Yes student is being tested in an accelerated grade N Na student i is
146. k Blank Blank v Blank E Blank e Blank Blank Primary Student Id for Export State Student ID SSID EMIS ID Home District Select School 4 If the selected Home District contains multiple high schools then the Export file will contain a separate section for each high school in the district The district Export file must be manually separated in order to create an Export file for each high school Marking Pattern Mark Types For each Marking Pattern active in Studentlnformation enter up to five Term Mark Types based on the Marking Pattern Rules to use for the exported marks The dropdowns will be filled in according to the Marking Pattern Rules at the JVS Please consult the Home School to determine which marks they want sent over Since a separate export file is created for each Home School the JVS can tailor each file to the Home School s specific needs NOTE When you Import you will be selecting a single Reporting Term Mark Type and Credit Type for each Term that will apply to all Marking Patterns so be sure to use marks that will have the same Mark Type and Credit Type regardless of Marking Pattern NOTE Marking patterns with no rules selected will not export NOTE An error message will display reminding users that at least one mark Primary Student Id for Export required Choose State Student ID SSID or EMIS ID The default is the SSID If SSID is chosen a
147. l Layout Program IEP Program 504 Program LEP Accom R Accom L Accom MA Accom SC Accom SS Accom InView ProgressBook Studentinformation Import Export Guide T A T 139 Filters School required Select the school from the district in context to include in the export file Available Student Statuses required Select one or more student statuses to include in the export file Formatting Options for the Terra Nova Grade Level required Select the grade level for this Terra Nova configuration Achievement Test Level required Select the achievement test level for this Terra Nova configuration Test Form required Select the test form that this School Grade Level will be taking Choices include CAT 5 Terra Nova 1 edition Terra Nova 2 edition Terra Nova 3 edition or Terra Nova 3 edition Barcode Layout Defaults to CAT 5 Test Id required Select the specific test ID that this School Grade Level will be taking There are multiple choices available Defaults to CAT 5 Survey Sort Order required Select the sort order for the export file Options are e UNSORTED Output is same sequence as input default e Name within Grade within School e Name within Teacher within School e Name within Teacher within Grade within School e Name within Level within Grade within School e Name within Level within Teacher within School e Name within Level within School Testing Date required
148. le will only contain one course section for each subject category Note that courses are only included in the export file if their EMIS tab contains an EMIS Subject Code that matches an EMIS subject code for the listed subject Reading and Writing courses will first look for matches on a Reading EMIS subject code 050102 050104 050106 050119 050300 or a Writing EMIS subject code 050014 050220 050400 050403 050500 059920 as appropriate and if there are no matches on these the export will look for a match on a Reading Writing EMIS subject code 050152 050154 050156 050160 050170 050180 050190 050545 051905 059930 059999 before leaving the course blank Preldent for OTELA Export Navigation Home Management Import Export Pre Identification Export Preldent for Otela Export Format Please use this export only for the OTELA Ohio Test of English Language Acquisition exports This export can only be accessed by Districts and will not include withdrawn students It will only include students whose FS record has a District Withdrawal Reason of Note The export will check for the existence of an SSID on the student s FS records so the correct students will be returned in the export Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools DAEL DASL ELEMENTARY SCHOOL DAHS DASL HIGH SCHOOL DAMS DASL MIDDLE SCHOOL
149. ll be invoked to help determine the correct value How Received optional Select how the students being imported arrived at the district Smart validation requires that How Received be selected How Received IRN optional Enter the district from which the students being imported are received SMART logic will be invoked to help determine the correct value Percent of Time optional Enter the average percent of time for the week that the students being imported participate in any instruction provided by a certified licensed employee Tuition Type optional Select the appropriate manner in which the students being imported are paying tuition to the reporting district SMART logic will be invoked to help determine the correct value 22 ProgressBook Studentlnformation Import Export Guide Attending Building IRN required Enter the IRN of the building within the district that the students being imported attend between the effective dates inclusive of the record being reported Click to open the ODE IRN Search page SMART logic will be invoked to help determine the correct value The Attending Building IRN can be a District IRN only when the value of How Received is one of the following 6 Non Public Services Only F Career Assessment Only Non instructional Supplementary or Related Services P Court Placed Students Excluding foster Care T Students Placed in Institutions Non Court Ordere
150. ll be used to report the teacher name on science teacher reports Alpha Indicata whether the student will be administered a test in an accelerated grade level a grade level higher than the student s enrolled qrade Y Yes student is baing tested in an accalarated grada N No student is being tested in enrolled grade Blank Mat Indicated assume student is being tested in enrolled grade Numene If accelerated testing lag is Y indicate the grade level at which the student is tested Must be numeric Valid values are 03 04 05 06 07 and 0B Accelerated testing grade must be higher than students enrolled grade teacher name on social studies teacher re Alpha Indicate ether the student will be ad rmunistere an accelerated grade level z grade level higher than the student s enrolled grade Y Yes student is being tested in an accelerated grade N No student is being tested m enrolled grade Blank Nat Indicated assume student is being tested m enrolled grade Numeric If accelerated testing flag is Y indicate the grade level at which the student ig tested Must be numeric Valid values are Od and OF Accelerated testing grade must be higher than student s enrolled grade ProgressBook Studentlnformation Import Export Guide 0 01 O02 3A Jpbona Optional Optional Optonal Optional unless student is participating in accelerated testing Apbonal uniess student is partic
151. mbership Group to limit the report to the students in this group All other selection criteria will be ignored Click to create a new ad hoc membership You will be taken to the Ad Hoc Memberships where you can create a new ad hoc membership and then return to the Air Export Choose students by ad hoc membership tab Check the Public And Private checkbox to see Memberships created by other users in your drop down list IMPORTANT Students must have an SSID on their current FS record to be included in the extract Students also must have a Home School IRN set on the student profile to be included in the extract Export Execute the export process with the filters selected Cancel Cancel the export process File Download Do you want to open or save this file Mame AIR AV 128835373218788575 txt Type Text Document From dev webi noacsc org ine While files from the Internet can be useful some files can potentially harm e your computer If you do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive ProgressBook Studentinformation Import Export Guide 131 The following figure shows an example of the AIR Export file when a JVS district is in context C AIR AN 128836805718895066 1 txt Notepad 050999050777Test JVSD FREDERICK 0 Student67557 Student68504 BILLIE JEAN Test Career Center JVSD 045111000067Test vill SD Test High School LO 11819
152. me Social Alpha numeric This field will be used to report the name of the Studies class or course on social studies teacher reports g Social Studies History Civics Glass Name Lourse Name Section Number and Teacher Name are optional However no classroom level report will be generated if ALL the three fields are laft blank 268 f 272 Section Mumber Social Studies Alpha numeric This field will be used to report the secbon number of ee or course on social studies teacher reports eg 01 DJ 3A 273 292 Alpha last name first name This field will be used to report the Teacher Name Social Studies Class Nama Course Nama Science teacher name on social studies teacher reports Alpha numeric This field will ba used to report the name of the class or course on science teacher reports e g Science Biology Physics Class Name Course Nama Section Number and Teacher Mama are optional However no classroom level report will be generated f ALL the three fields are left blank Pet e Lu Lu c Pad LA zali EU ra c cen CH ca in 3 3 204 Section Number Science Alpha numeric This field will be used to report the section number of the class or course on science teacher reporta e g 01 02 3A 308 327 Teacher Mame Science Alpha last name first name This field will be used ta report the teacher name on science teacher reports Alpha Indicate whether the student will be administerad a test in an accelerated grad
153. must have a state assigned unique identifier number to facilitate anonymous reporting when districts report data to the state EMIS reporting system The state wide ID provided by a third party system reports an existing ID fora student if one exists and creates new identifiers for students that cannot be matched to existing records in its system Studentinformation will create an export file see section 2A State Student ID Export for the file format to be sent to the third party for processing The vendor processes the file provides the student with a State Student ID in the original file and returns the file for importing The State Student ID is appended at the first position in the file for each student row The file layout is a comma delimited file left justified The default name given to the file by the third party vendor will be in the format of ITC name OR School District IRN Date as yyyymmdd An example of the filename would be NOACSC20040203 TXT The user can then import this file and the State Student IDs from the third party vendor will be imported into Studenilnformation ProgressBook Studentinformation Import Export Guide 5 FS Records and Missing SSIDs Students could have multiple FS records with missing SSIDs The State Student ID Import will update multiple FS records if e The most recent FS record is missing SSID e he record prior to the most recent FS record is also missing an SSID e All records prior to the
154. n the INFOhio Export tab of the DASL Options screen See the ProgressBook Studentinformation School Setup and Configuration Guide for the DASL Options INFOhio Export details Annual Record Note In order for a student to be included in the file the student must have an annual record in the current school year as well as a LIVE EMIS time period record EMIS time period records are created for all students regardless of whether a district reports to EMIS or not If a student is not included in the file and it is not because of the student s status code then the user should check the student s admission history detail records to make sure that the student has a record for the current school year Navigate to Home SIS Student Admission History Edit History Details and check for a record in the current school year Student Status Note Student status codes play a big part in which students get included in the file On the student status code maintenance page any status code defined with an internal status of Inactive or Delete will not be included in the file This may include students who are residents attending elsewhere if they use a separate status code for these students and make them inactive internally Navigate to Home Management School Administration School Codes Administration Student Status Codes to check to see how the status codes are configured Export Execute the Export process ProgressBook St
155. nd a student does not have an SSID then the EMIS ID will be included in the export record If EMIS ID is chosen and a student does not have an EMIS ID then the SSID will be included in the export record If the student does not have an SSID or an EMIS ID then the SSID EMIS ID field will be left blank in the export record Whenever possible choose to export by SSID versus EMIS ID A student in multiple districts must have the same SSID but can have varying EMIS IDs at each district An exception to this would be if the home school is a non public school and does not use SSIDs the JVS would want to do the export by EMIS ID If they chose SSID for the export file then nothing would be imported to the non public school since they do not use SSIDs 50 ProgressBook Studentlnformation Import Export Guide Home District required Choose the IRN of the Home School district to which this data applies The Home District drop down list is populated based on the building Home school IRN field on the Student Profile General tab Note for Home Districts with multiple high schools The export creates a single export file for the district selected for exporting which includes all records for each building in the selected district where one or more students had their home school set to that building If the selected Home District contains multiple high schools then the Export file will contain a separate section for each high school in the district Th
156. nformation Technology Center in validating the reporting district and batch of records The information in the Header record must match the EMIS Reporting Period the data is being loaded into If no match exists an error will appear indicating that the EMIS Reporting Periods do not match and the import will not continue any further The import file layout of the Header record will be formatted in the EMIS file record layout as defined in Chapter 5 of the ODE EMIS Manual 26 ProgressBook Studentlnformation Import Export Guide NOTE The Filler size at the end of the record depends on the record size of the records included in the batch The size of the header record must match the size of the records being reported in the batch Trailer Record The Trailer record will contain a record count of all the records in the file The Trailer record will be ignored The import file layout of the Trailer record will be formatted in the EMIS file record layout as defined in Chapter 5 of the ODE EMIS Manual NOTE The Filler size at the end of the record depends on the size of the records included in the batch The size of the trailer record must match the size of the records being reported in the batch Special Education Import SpS Student Attributes FD Navigation Home Management Import Export Special Education Import SpS Student Attributes Run Option Student Attributes Record Sort Type FD The Student Attributes import
157. nstruction provided by an employee at a non EMIS reporting entity Import File required Browse to the location of the File Name to be imported Import Import Attendance data from the import file You must confirm click OK that you really want to import this information before the import completes A list of all students in the import file that could not be imported is displayed Trying to import students whose SSN or EMIS ID already exist in the school or district causes the import of those students to fail ProgressBook Studentinformation Import Export Guide 23 Special Education Import SpS Navigation Home Management Import Export Special Education Import SpS The Special Education Import program will load data extracted from a special services application into Studentlnformation The Special Education Import will be processed primarily by the EMIS coordinator in each district The special services application will provide one file that contains the records as outlined in the following figures the file bundles all of the records together The special services application will use the EMIS Import file layouts from Chapter 5 of the ODE EMIS Manual to construct each portion of the import file The Special Education Import will check for a valid effective date and if there is no valid effective date an error will be issued and the invalid record will be rejected llb Home gt Management Import Export
158. nt Grade e Student Homeroom e Homeroom Teacher Last Name e Student Address 1 e Student Address 2 e Student City e Student State e Student Zip Code e Student Area Code e Student Phone 1 e Student Phone 2 The following figure shows an example of the Fostoria Life Touch Photo Export file A B C G H 48552258 Banana Hannah 2117 Cherry Street Lima 7001 CONTRAR JASON W 90 ELM STREET LIMA 48552281 Contrary Jesse 545 S Main Lima 5001 CONTRAR MARY M 90 ELM STREET LIMA 6001 EYE CORY RO 12 NORTH ST LIMA 4001 EYE MAGNUM 122 NORTH ST PMA 122445 EYE PRIVA 123 SECRET AVE A CO Oo 1 BR oo he 4002 FONT ELLA JAN 345 N FRONT ST LIMA 6002 FONT MICHELLE 345 N FRONT ST LIMA 4003 JOHNSON GEORGE 597 STATE STREET LIMA 6003 JONES WHITNEY 702 BRISTOL LIMA 1224 LEE HARPER 23 MOCKINGBIRD L4 LIMA 6004 LINE TROY AAF 665 SUGAR STREET LIMA 6005 MAY DAISY LEI 600 BLOOM DRIVE LIMA 5002 PERRY MICHAEL 77b BROADWAY BL LIMA 7002 PERRY RICHARD CASTLE 775 BROADWAY BL LIMA 5003 POTTS JAN MICHA 7532 BLENDON PLA LIMA 4004 POTTS JORDAN LAYMAN 7532 BLENDON PLA LIMA 7003 RING NICOLE S 9065 BLISS RD LIMA 7004 SARGENT LEANN JE CASTLE 123 Bigtop Street LIMA 4006 SAWYER THOMAS 53 MISSIS SUITE 100 LIMA 5004 SPRAT JACK JOS 890 BACON TRAIL UMA 4005 WELLS JOBETH 843 NORTHWALD DF LIMA 5005 WELLS JONA REP 843 NORTHWALD DF LIMA 7005 WILLIAMS RYAN GE 881 THAYER ROAD LIMA Lange Photo Export Navigation Home Management Import Export Photo Export
159. nt fees data for a specific file format Studentinformation gt Management gt Import Export gt STUFEES Export STUFEES Export From this screen you can export data for a specific file format Activity Start Date 7 30 2014 EB s Activity Stop Date 7 30 2014 EB s Payment Types Available Payment Types Selected Amnesty Drop d Misc Credit b o Payment Refund Activity Type s Payment Methods Available Payment Methods Selected Cash Credit Online Payment Transfer Payment Payment Type s Accounting Codes Available Accounting Codes Selected ADV BIO SUPPLIES ART SUPPLIES e gt BIOLOGY SUPPLIES BIO DE COURSE COST BASKETBALL FEES UNIFORM Accounting Code s Activity Start Date required Select the activity start date for the export process Activity Stop Date required Select the activity stop date for the export process Activity Type s optional Select available activity types to be included in the export process Payment Type s optional Select available payment types to be included in the export process Accounting Code s optional Select available accounting codes to be included in the export process Please Note that these are the actual Allocation Codes as defined in Accounting Codes Maintenance not the Accounting Codes Export Execute the export process Cancel Cancel the export process ProgressBook Studentinformation Import Export
160. ny location available Email will send the selected File Type as an email attachment to the email address specified for this Studentlnformation user Click Download Error List to create the error list File Download Do you want to open or save this file EN Name DASL_DATA csv lly Type Microsoft Office Excel Comma Separated Values File From dev webl noacsc org While files from the Internet can be useful some files can potentially harm your computer Ifyou do nottrustthe source do not open or save this file save the file to your hard drive or network drive for further processing HecordNumber RecordStatus Sortlype Student ErrorMessage eie uuum A Gl 111111111 Student EMIS ID not found Special Education Import Header and Trailer Records Navigation Home Management Import Export Special Education Import SpS any Run Option Header Record 10 3 0 16150 and later the Special Education Import will no longer expect a header record at the top of the import file The import will now expect the first line of import files to be a valid record Prior to 10 3 0 16150 the first record in the file will be a header record This record contains specific attributes of the file that must be validated before proceeding with the processing of the rest of the file Each file batch that is transmitted to a designated Information Technology Center must contain a header and trailer record These records assist the I
161. of Birth e Building IRN e District IRN The required state student id file has a large number of fields that are not actually submitted to the third party vendor The following fields are the fields that are required to be included in this export e First Name e Last Name e Date of Birth e Gender e SSN to be populated based on settings entire SSN last 4 digits or blank e Existing Student Code to be populated based on settings e Native Language e Ethnicity calculated from Local Ethnicity Category Hispanic Latino and Racial Groups field values similar to Summative Race field value e Birthplace City e Legal Middle Name e Admission Reason for students with no SSID The following additional fields will be included as well e Current Building IRN e Current District IRN e Vendor ID If the Student is missing data in any of these fields a warning page will display 34 ProgressBook Studentlnformation Import Export Guide State Student ID Export From this screen you can export data for a specific file format The following students do not one of the following fields specified These students will not be included in the export Legal First Name Birthdate Legal Middle Name Gender Legal Last Name Ethnicity Birthplace City Native Language Admission Reason Click a student s name to correct this Click Continue if you would like to create the export file without these students 71 Records Displayed Dist
162. ollowing logic e fthe imported record has the same program code and effective start date Studentinformation does not load the record e fthe imported record has the same program code and different effective start date StudentInformation updates the start date of the record e fthe imported record has a different program code did not exist previously regardless of effective start date Studentlnformation adds the record Studentlnformation imports the end date for GQ records with a program code that begins with 215 or 220 if the end date falls outside of the fiscal year of the record If the program code is 220100 or any other code the end date is imported and saved to the student s record regardless of the fiscal year Studentinformation uses the enrollment end date during EMIS processing when determining what records are sent to EMIS for the reporting period Program codes should be imported for October K and Period N June Special Education Import SpS Student Special Education GE Navigation Home Management Import Export Special Education Import SpS Student Special Education Run Option Student Special Education Record Sort Type GE The Student Special Education record import will serve as both an import of new records if no match exists or an update if a match is found The import file layout of the Student Special Education record will be formatted in the EMIS file record layout as defined in
163. omma separated Student Ids Available Schools in District reguired Select the schools that are to be included in the export file One export file will be created that will contain data for all selected schools Export Format required Select the Preldent For Pearson Educational Measurement Export Test required Select the Ohio Graduation Test Include only required students optional When this checkbox is checked the export will only include those students in the file that still need to take the test or have yet to pass all parts of the OGT Include the following grades optional Select which grade levels should be included in the OGT Pre Ident export file ProgressBook Studentinformation Import Export Guide 93 Include the following students optional Check those options that apply indicates whether you wish to include students attending elsewhere as Contract Vocational In Contract Vocational Out or JVS Students in your file Contract Vocational In Students that are non residents of your district attending as a contract vocational student Contract Vocational Out Students that are residents of your district attending another district as a contract vocational student If the district is testing these students and wishes to have the results returned to their district then include these students in your file Include CVI home school information optional Hint for non
164. on Import SpS Student Special Education Graduation Fa CUTOUTS VE sesh oed ediet used iut tiat edid veris Dele Ur hd UM d rM site 30 Special Education Import SpS Student Achievement Test FA GA Record Type MM M UM MM A ME VEN 30 Special Education Import SpS Student Ohio Graduation Test FA GX Record TY OC eR MERERI PROBUM 31 Special Education Import SpS Student Kindergarten Readiness Assessment PRAGO Le TYDE m 31 EXDOEIUEOLTIOIS aM MU Un A Emp ade maia DAP d m werent O NO ro ee 32 State Student ID ee EE 32 EOM EKON E LT UR ELE eee ee een ee ere ee 36 Discipline better Export DISO DT EE 39 Glade DOOk EXO me 43 ProgressBook Studentlnformation Import Export Guide iii Original Gradebook OO EE 44 Extended aradebOOR EX DON EE 46 POMC COON adoro quete TT 49 Home ochool Export Course e Ee EEN 49 Home School Export Attendance nensrnnenannai a 53 Finaly Dialer EX OOM utet drei ada ed td oo us Adi Lt dece htl a a dd aus 56 Edulod E XPO GE 59 za lje re e U1 oe ee 60 BA TENE OUO NEN TEE 62 Wayne Trace Lima City Edulog ee 64 General EdulOgFOMMNAU ericeira i 67 PUNCO el NEE 69 Lunch Export for WAPAK City ein Lee 70 Meals Plus Point of Sale Version 72 Meals Plus Point of Sale Version 2 erret eer nnm snik ec nn pr cR a 74 VW N MONEUNCA H E ee RE 76 EX GCISIORIE x OO EE 77 Fore al Eet edel H E xPO NN NO E elie 86 Riverside ITBS Pre Identification Evport en 87 Prel
165. ort data for a specific file format Available Schools in District Selected Schools DAES DALTON ELEMENTARY SCHOOL 3 DAHS DALTON HIGH SCHOOL F 39 DAJH DALTON INTERMEDIATE Export Format Preldent For AASWD and OCBA v Include assessments 4th Grade Social Studies 6th Grade Social Studies 5th Grade Science 8th Grade Science American Government American History i Kill I Physical Science Include the Following Students as AASWD Ad Hoc Membership Select an Ad Hoc Membership Public And Private Contract Vocational In Include CVI home school information Include the following students Contract Vocational Out lvs Include JVS home school information Return only these students Comma separated Student Ids Paper Online Paper v Separate Files for AASWD and OCBA C File Download Options FIXED v Select A Download Method v ProgressBook Studentinformation Import Export Guide 111 112 At the top of the screen select the school s to include in the export by moving them from the Available Schools in District multi select list to the Selected Schools list A single export file will contain data for all selected schools 2 In the Export Format drop down list select Preldent For AASWD and OCBA 3 In the Include assessments option select the check box beside each grade level subject to include in the export file Note Both regula
166. ort icons to match ProgressBook Suite formatting 14 2 0 Import Export Documentation N A Removed section because the icons are Key no longer included in the guide 14 2 0 Pre Identification Export 86 Updated Riverside ITBS export section to reflect new screen shots and rewrote section as procedural steps 14 2 0 eTranscripts 155 Added section 14 0 0 Special Education Import SpS 27 Updated section to include Section 504 Student Attributes FD information li ProgressBook Studentlnformation Import Export Guide Table of Contents Change o eraen Table OP COMIC E li MOOC E dere d TEE 1 Understanding the Import Export Module 1 IMO OM Gei un E 2 Aq pesi ea oe EEA RA A A RE ER RA ER 2 otatesstident BI rel EE 5 Ber Be TODON LLL 7 Hoirne seboolltmiDOF na eee ee ger ine ete battuto benef un ee eee ee ee 12 Home School Import Course History 12 Home School Import Attendance a 17 Holrie School Importe SIUderillsusi oit oc ninos A PM v aka tec nisse ence 19 Special Education IMDON SDS EE 24 Special Education Import Header and Trailer Records 26 Special Education Import SpS Student Attributes FD 27 Special Education Import SpS Student Program GQ 28 Special Education Import SpS Student Special Education GE 29 opecial Educati
167. ort loads the imported Section 504 value over the existing value using the imported effective start date closing any appropriate records as needed You should import student attribute records for EMIS Reporting Periods K and N Special Education Import SpS Student Program GQ Navigation Home Management Import Export Special Education Import SpS Student Program Run Option Student Program Record Sort Type GQ For the purpose of this section program codes will equate to membership codes in otudentlnformation for the student membership import functionality The district building will be responsible for making sure that the membership groups and codes are defined in Studentlntormation prior to the import being processed The building will also be responsible for assigning the proper EMIS code value to the membership code record prior to the Special Education Import The memberships will work under the premise that the membership group will be equal to the first two digits of the program code This standard was decided on by all ITCs The import file layout of the Student Program record will be formatted in the EMIS file record layout as defined in Chapter 5 of the ODE EMIS Manual The Student Program record import serves as both an import of new records if no match exists or an update if a match is found As of 10 2 0 new validations were implemented requiring each record to be in a certain format e Fiscal Year mu
168. ose the grades to be included in or excluded from the export This option is used by Class List Staff List and Student List exports only School Year optional Choose the school years to be included in or excluded from the export This option is used by the KRA L List export only Export Execute the export process 148 ProgressBook Studentlnformation Import Export Guide Class List The Class List option creates the DataMap_Class csv export file otudentlnformation returns records for the DataMap Class csv export file based on the value in the EMIS Subject Code field on the EMIS Override tab for the course section if defined otherwise Studentlnformation returns records based on the value in the EMIS Subject Code field on the EMIS tab for the course The DataMap Class csv export includes the following columns Subject Area ochool Code otudent ID otudent State ID First Name Last Name Gender Grade Level Code Home School IRN Home School Program Code Program Name Code otatus otudent Status Code Course Code Course Name Course Type Code Course Type Description Section Number Term Code Term Name Location Ex Teacher Code Calendar Period Days Rotation Days ProgressBook Studentlnformation Import Export Guide 149 e Teachers First Name e Teachers Last Name The following figure shows an example of the Class List output file E D E E G H J K Subject Area School Code Student Id State Student Id First
169. ot have a CTE Program of Concentration set on their Period N record Assessment Coordinator required Choose the Use Default Assessment Coordinator for Program of Concentration or Use Teacher of Record from applicable courses If the Use the Default Assessment Coordinator for Program of Concentration is selected the Default Assessment Coordinator that was chosen on the WebXam Assessment Coordinator Records screen is exported as the Assessment Coordinator If the Use Teacher of record from applicable courses is selected the teacher of record for the course section is exported as the Assessment Coordinator To determine the course section from which to extract the teacher of record Studentlnformation checks for valid values in the Curriculum Code begins with V and the EMIS Subject Code fields on the EMIS Override tab for the course section if defined otherwise Studentinformation checks for valid values in the Curriculum Code and EMIS Subject Code fields on the EMIS tab for the course Include Tech Prep Completer Students without CTE Program of Concentration optional If this option is selected you will be able to set the default CTE Program of Concentration This will be used for any student that has their Tech Prep Completer flag set to Y on their Period N record but does not have a CTE Program of Concentration saved Preview A Preview button is available that will display all the students that will be included in th
170. ou will receive the following message At least one run option must be selected Import Import the checked Special Education Import files The Special Education Import will display the following message if the import file is successfully loaded to Studentlnformation without errors The file has been loaded without errors If errors are found in the import file the Special Education Import will display the following message and the specific error records with errors The Special Education Import will not stop when an error is encountered it will continue and load all records except those with errors The file has been loaded except for the following records Record Number Record Status Sort Type EMIS StudentID Number Issue ecoococ A GI 111111111 Student EMIS ID not found Typical error messages displayed would include e Student EMIS ID not found e Student EMIS ID not found not able to match student achievement test record in Studenilnformation e Not able to match student achievement test record in Studentlnformation e Membership already exists for student not saved File Download Options Select a File Type Choose from CSV csv HTML html and TAB txt Select A Download Method Choose from Download or Email Download will create a dasl data xls dasl data csv or dasl data txt file depending on the file type you choose ProgressBook Studentinformation Import Export Guide 25 You may save this file to a
171. port Export Guide 91 e FIE 0Oor e FTE O and Sent Reason on FS Student Standing ES JV MR PS OS PI CI NI 3 Students in grades 11 12 13 a FTE O00r b FTE 0 and Sent Reason on FS Student Standing ES JV MR PS OS PI Cl NI c Student does not have a passing score for at least one part of the OGT test on an existing test record Non passing scores are as follows Test Part Social Studies Citizenship 4 f student s Grade level is UG then examine the value in the State Equivalent Grade field on the latest Student FD record for the value of the student grade level As of 10 3 0 16150 JVS students are determined by saying that only students who had JVS as their Sent To or Alt Sent To reason AND had 0 for their attendance percentage were considered JVS for purposes of this selection The same kind of logic was used for Contract Vocational Out students with CT as the Sent To or Alt Sent To reason A student s admission history records are checked to determine whether he is actively enrolled in the district or not Course section information for the courses a student is enrolled which are related to the test subject areas is also included in the record Previously Pre Ident was only including students who had an overall internal student status of Active This has been changed in the 8 2 0 release to now include actively enrolled students regardless of their status code Therefore it is no longer necessary to change
172. quired as in the example above enter student numbers separated by a comma Click Validate Student Numbers You will receive the following message if any of the student numbers are invalid AIR Export From this screen you can create an AIR export file Please correct the following errors 133123133133 is an invalid student number If the student numbers are valid you will receive validation as follows Choose students by filters Choose students by student numbers Choose students by ad hoc membership Enter a comma separated list of student numbers to include in the extract 00005743 00005745 Edit Student Numbers Students must have an SSID on their current FS record to be included in the extract Click Edit Student Numbers to further edit the student numbers before Export IMPORTANT Students must have an SSID on their current FS record to be included in the extract Choose students by ad hoc membership Choose students by filters Choose students by student numbers Choose students by ad hoc membership Choose an ad hoc membership containing students to include in the extract Select an Ad Hoc Membership ei Public And Private d Students must hawe an SSID on their current FS record to be included in the extract ProgressBook Studentinformation Import Export Guide 125 If the students have not been enrolled at the JVSD yet for the future school year the home school can create a file usin
173. r Start Over and go back to Step One 10 ProgressBook Studentlnformation Import Export Guide Next gt Process the file selected and go to Step Four The processing step may take a few minutes please notice the progress bar Step Four Results While the Import is processing the user will see the following screen LOAGRADE Import Step Four Your LOAGRADE file is being imported This may take a few moments Records Imported 0 of 6 start Over Once processing is complete the user will be presented with on screen results of the import These results will also be stored in a log file that the ITC will be able to access if needed Step Four Blank Values In Import File Course Code Course Section Number Student Number Status Mark COMPS E Blank Value For Student SOSTE 999999 Blank Value For Course Course Section Values Repla Course Code Status Old Mark New Mark Report Period ALGB P pr Mark Replaced B Ja Lee ARTB 1234567890 99999 Mark Replaced D ep CHOIRS Mark Replaced GF1 EN LA8 E Mark Replaced GP1 FLS 3 3 Mark Replaced GP1 Mark Replaced GP1 Mark Replaced GP1 Blank Values in Import File This area will display any records that contained blank values for student or course section If marks selected for import are blank they will be
174. r Tardy 21 Marking Period GPA 22 Marking Period Credits Earned 23 Cum GPA 24 Cum Credits Earned The following figure shows an example of the Student Data Extended Excelsior Export file B E D E F G H K M N O 12 B 26 1989 F EDMOND 1587 Ivy D Elida OH I 1 00 00 0000 H1 ELHS 1 1 2 9 1 19 1993 F EDMOND 1587 IVY CELIDA OF ve Elida Midd 8 29 2007 00 00 0000 ELHS Di O E 11 G tt F BRIAN 8 45817 Polin Elida OH 9 00 00 0000 ELHS Di D 4 12 8 2 1990 F ROY 8 TEJ Celia PI Lima OH 8 28 2007 00 00 0000 ELHS Di D 5 O9 SRE F ROY amp TES CELIA P LIMA OH iG Elida Midd 8 29 2007 00 00 0000 ELHS Di D 6 9 1 12 1993 F APRIL RUI1837 ARLI LIMA OH ee Elida Midd 8 29 2007 00 00 0000 ELHS Di D y 9 6 4 1993 F ALLLISON 2100 KIMELIMA OH er Elida Midd 8 29 2007 00 00 0000 ELHS Di D 8 8003 I 12 9 2 1989 M CYNTHIA 14901 Lobo Elida OH Se 8 20 2007 00 00 0000 ELHS 5j 5 g 8190 12 5 29 1990 M MARK amp T 1020 N Ea Elida OH r id 00 00 0000 ELHS Di O 10 10000 10 10 8 1991 F ANDERSC2115 PRAIELIDA OF n Ha 00 00 0000 ELHS Di O Ut 8004 11 8 14 1990 M JOHN amp M 1551 Plain Lima OH i 8 28 2007 00 00 0000 ELHS Di D 12 8502 12 7 15 1989 F GLEN amp C 4798 W SELIDA OF nd 32 00 00 0000 ELHS Di O dei 11006 9 5 10 1993 M ANTHONY 104 E NO ELIDA OF iG Elida Midd 68 29 2007 00 00 0000 ELHS Di O 14 9001 11 10 3 1990 M DOUGLAS 104 E NO ELIDA OF 8 00 00 0000 ELHS Di D 15 6650 12 2 14 1990 F DAVID SH 3100 N Co Lima OH 3 00 00 0000 EL
175. r and accelerated students are included in the grade specific options Optional If you have students who will take the alternate assessment a Select the Include the Following Students as AASWD check box b In the Ad Hoc Membership drop down list select the ad hoc membership containing these students This will update the testing value to Alternate for these students c Optional To make both public and private memberships display in the list select the Public And Private check box Optional In the Include the following students option select any of the following options to include students with these conditions e Contract Vocational In students who are non residents of your district attending as a contract vocational student e Contract Vocational Out students who are residents of your district attending another district as a contract vocational student Note If your district is testing these students and you want to receive the results you should include these students in your file Optional If you want to include contract vocational home school information on the export select the Include CVI home school information check box Note for non home schools lf you are not the resident district you want the home school to receive the information and you selected to include Contract Vocational In students you should select this check box Note for home schools If you are the home school do not sel
176. ral tab ProgressBook Studentinformation Import Export Guide 53 Note for Home Districts with multiple high schools The export creates a single export file for the district selected for exporting which includes all records for each building in the selected district where one or more students had their home school set to that building If the selected Home District contains multiple high schools then the Export file will contain a separate section for each high school in the district The district Export file must be manually separated in order to create an Export file for each High School Student Status optional Choose the Student Status of the students to include in the Home School Attendance Export If no Student Status is selected then students with all otudent Statuses will be exported Ad hoc optional Specify an Ad Hoc Membership Group to limit the report to the students in this group All other selection criteria will be ignored Check the Public and Private checkbox to see Memberships created by other users in your drop down list Export Export Attendance data After opening this file and verifying the date email the file to the Home School if necessary 10 3 0 16150 and after The Attendance file layout will be as follows The output file defaults to the name StudentAttendance000000 SEQ where 000000 is the Home School District IRN The file is fixed width files with a header row NOTE The Attended Absence Exc
177. rict Building Student Number Student Name Issue DA DA DA DA DA DA DA DA 71 Records Displayed DAEL DAEL DAEL DAHS DAHS DAHS DAHS DAHS 00013001 00001007 00001004 00005004 48652304 00004005 00005005 00007005 BOARD NICHOLAS LEE Middle Name is not specified Birthplace City is not specified Admission Reason is not specified BREWER SEAN CONORY Middle Name is not specified Birthplace City is not specified Admission Reason is not specified BROWN AARON JAMES Middle Mame is not specified Birthplace City is not specified Admission Reason is not specified SPRAT JACK JOSEPH Middle Name is not specified Ethnicity is not specified Birthplace City is not specified Admission Reason is not specified Vest Rouge Red Middle Name is not specified Ethnicity is not specified Birthplace City is not specified Admission Reason is not specified WELLS JOBETH Middle Name is not specified Ethnicity is not specified Birthplace City is not specified Admission Reason is not specified WELLS JONA RENEE Middle Name is not specified Ethnicity is not specified Birthplace City is not specified Admission Reason is not specified WILLIAMSON RYAN SETH Middle Name is not specified Ethnicity is not specified Birthplace City is not specified Admission Reason is not specified Back To Top Refresh Reload this page Brewer Sean Conory Click on the hyperlinked student names to open a new window with that student s Edit Profil
178. rict Selected Schools DAHS DALTON HIGH SCHOOL DADA DALTON ELEMENTARY DAJH DALTON INTERMEDIATE DAKI KIDRON ELEMENTARY Export Format PreIdent For KRA w The following students do not have Statewide Student Identifiers Click Continue if you would like to create the export file without these students Click the Student Name to go to the Student Profile Edit screen Click Refresh to reload the list 48 Records Displayed Grade District Building Student Number Student Name Res DLTN DAKI 00260240 ACEVEDO MICHAEL KG DLTN DAKI 00260510 ALEXANDER TIFFANY KG DLTN DAKI 00260150 BARNES SONTA DLTN DAKI 00260295 BRIGHT DUSTIN 4 Records Displayed Back To Top 5 Optional To add a missing SSID for a student so the student is included in the export a Click the student s name b On the Edit Student Profile screen FS Standing tab in the State Student ID SSID field enter the student s SSID Click Save On the Pre Identification Export screen click Refresh The student name no longer displays in the list and the student will now be included in the export e Repeat step 5 as needed to include all students in the export 6 If any student displayed in the grid click Continue Note Any students remaining in the grid are excluded from the export file 7 Save the csv file 8 If any student displayed in the grid click Cancel to return to the main view 9 In the Choose KRA Pre ID
179. rmation based on the value in the EMIS Subject Code field on the EMIS tab for the course OAA Ohio Achievement Assessment The Ohio Achievement Pre identification export process is performed whenever there is a need to create Pre identification labels to submit to the testing company prior to a test administration The Achievement Pre Ident will include the following students in the file e Any student in 3 grade through 8th grade who is actively enrolled and is attending the district e Any student in any other grade level that has an acceleration record for a test part in a specific grade level test other than their current grade level A student s admission history records are checked to determine whether he is actively enrolled in the district or not ProgressBook Studentinformation Import Export Guide 89 The Pre Identification file layout was changed this year with the addition of new fields to collect data to be used by the D3A2 project when test results are loaded into that application Classroom information on subjects taken by the student which are relevant to the Achievement Assessment subject areas is included in the records along with Teacher information identifying the student s teacher for each of the subject areas Because of this request it was necessary to load the Staff Credential ID s into the otudentlnformation Staff records for inclusion on the records Because of this option it is important that schools make sure
180. rt button listing the students with errors If the students listed do not need to be included in the file you are creating click the Continue button to create the file 94 ProgressBook Studentlnformation Import Export Guide File Download Do you want to open or save this file k Name PearsonPreldent DAHS 1211070146 txt Type Text Document From dsldemo mcoecn org While files from the Internet can be useful some files can potentially harm your computer If you do nottrustthe source do not open or save this file Save Save this file to your hard drive or network drive The export file is fixed width with spaces for padding The file layout from ODE District Test Coordinator Newsletter K 8 Assessments December 2007 is detailed in the following figure In this export file course codes longer than 10 characters are truncated to 10 characters by removing the necessary number of characters from the right side of the course code ProgressBook Studentinformation Import Export Guide 95 96 OHIO TESTS RECORD DESCRIPTION FOR STUDENT PRE IDENTIFICATION FILE New fields are highlighted in blue Home District IRN position 488 493 and Hof 529 are required for JVS students Record Length 569 Field Position Field Lenath tart End b Cn Attending School IRN 42 30 Attending District Name 30 Attending School Name 20 Student Last Name 20 Student First Name Student Middle Initial Date
181. s e Form Code 1 3 Always x01 e Student ID 4 9 e Student Name 13 20 e Course ID 33 15 e Course Section Number 48 2 e Teacher ID 50 4 e Student Gender 54 1 e Phone 55 8 formatted as nnn nnnn e Birthdate 63 8 formatted as mm dd yy e Grade 71 2 e Homeroom 73 4 e Parent Name 77 25 ProgressBook Studentinformation Import Export Guide 47 e Counselor 102 25 e Student SSN 127 9 e Student Address 136 30 e Student City 161 18 e Student State 179 4 e Student Zip Code 183 9 e Student First Name 192 9 e Student Last Name 201 22 e Credit Units 223 4 e Period of the Day 227 2 e Course Name 229 15 This export file then will be imported into the grade book packages mentioned above When grades are ready to be submitted for grade card processing the grade book package will create an export file with the grades and or attendance to be imported back into the Studentlnformation application That import process is covered in 1C LOAGRADE Import The following figures show an example of the Extended Gradebook Export file P DAS et Notepad De pdt Format Yee Dk X LOODODOTOUlCONTEARY JAS OM WELLOS K LODODOTOU3RTNG ME COLE SufAMHEOSI xLOOOOUTOONTLL LARSON Aran SETOSZ x LODOOOUTOUlCONTEARY JA OM WELLOSS xOLlO0O00TOU2P5ERAY BI HAAO MATTHOSS Xx LODOOODTOU3RIBG NE OLE AZAMHEOS1 Xx LODOOQTOUM SARGENT LEARN JEAN 053 xOLODOOOTOUTUNILLIAME
182. s Excluded A ACTIVE RES D DELETED I INACTIVE M NON RES Student Statuses Included Export Fields Student Number Birthdate Homeroom Teacher Last Name Address First Name v Gender Z Grade Code v address 2 Lol Middle Mame Lol Ethnicity Lol Parent Name address 3 Last Name Student Statuses Excluded Student Statuses Included required Choose the Student Statuses to be included or excluded in the Export Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process File Download Some files can harm your computer IF the file information below K looks suspicious or vou do nat fully trust the source do nat open or save this file File name DAHS ExE File type Text Document From dsldemo mcoecn org Would vau like to open the file or save it to your computer Cancel More Info Save Save this file to your hard drive or network drive 74 ProgressBook Studentlnformation Import Export Guide The file is fixed width left justified with spaces for padding The file layout will be as follows with the starting point of that field and the length in parenthesis Student ID 1 9 otudent First Name 10 15 otudent Middle Name 25 15 Student Last Name 40 15 Date of Birth 55 8 formatted as mmddyyyy Student Gender 63 1 Student Race 64 4 Teacher Last Name 68
183. s take attendance in a variety of ways outside of the existing Studentinformation application Therefore there needs to be a way available to import the attendance information from those outside applications If the applications can 2 ProgressBook Studentlnformation Import Export Guide produce a file in the following format then the file can be imported into Studentlnformation The file needs to be of fixed width left justified with spaces for padding The user needs to be able to assign the filename of ATT2SIS TXT to the file The import will include all records found in the external application The ATT2SIS Import accepts the following format with the starting points and lengths of fields in parentheses Student ID 1 9 Absence Date 10 8 format is yyyymmdd Absence Type 18 4 up to four letter Absence Type Code defined in Studentlnformation Absence Time 22 8 format is HH MM followed by a space and AM or PM Absence A M P M 30 1 valid values are A a m P p m and space full day Absence Reason 31 1 only importing if Absence Reason Code is one letter Absence Note 32 1 one letter Absence Note Code defined in Studentlnformation The ATT2SIS Import also accepts the following format Student ID 1 9 Absence Date 10 8 format is yyyymmdd Absence Type 18 1 one letter Absence Type Code defined in Studentlnformation Absence Time 19 8 format is HH MM followed by a space and AM or P
184. s that generate files in these formats may use as Filler instead of a space Filler can consist of any character so this will still work correctly Before beginning the import make sure you have a clear understanding of which marks are in the file Open the file from the JVS and compare the file s content to the file layout So you know marks are contained in the file before importing the file Important note to Home School districts with multiple high schools If a district has several high school buildings the export file sent by the JVS will need to be separated into a separate file for each building The file sent by the JVS is already sub divided by building so all you need to do is cut and paste into separate files Home School Import Course History Navigation Home Management Import Export Home School Import Course History Tab The Course History file layout must be as follows with the starting point of that field and the length in parenthesis Default names are likely to be StudentMarks000000 SEQ DASL or ALIEN MARK XXXX SEQ JVSGRADASL where 000000 is the Home school District IRN or XXXX is the home school four letter code 12 ProgressBook Studentlnformation Import Export Guide File Format Field Name Position Description o StudentNumber 1 9 GradelevelCode 10 11 PO LastName 12 29 FirstName 380 48 PO Calledame
185. s unexcused Tardy 40 49 1 The number of absence records marked tardy right justified School Year 54 57 4 This i the absence data School year of absence data This is not the fiscal year of Student Name Student name Last name first name The following figure shows an example of the Home School Export Attendance file WILLIAMS E THOME FLORANCE T Student51789 SAWYER 5Student81788 Student81787 Student81786 c Student81785 H Student81781 JANICE StudentS1774 SCOTT oooooooooo oooooooooo 0 00 O 0 00 O 0 00 0 O 0 0 00 0 0 00 0 O 00 O 0 00 0 0 00 O 0 00 O Prior to 10 3 0 16150 the Attendance file layout will be as follows with the starting point of that field and the length in parenthesis The output file defaults to the name otudentAttendance000000 S EQ where 000000 is the Home School District IRN The file is fixed width files with a header row ProgressBook Studentinformation Import Export Guide 55 e State Student ID SSID or EMIS ID depending on Primary Student Id for Export option selected 1 9 e School Year 10 4 e Report Term Code or Report Term Export Code depending on Home School Term Format option selected 14 3 e Absence Type 17 1 e Full Day Absences 18 3 e Half Day Absences 21 3 e fTardies 24 3 e Filler 27 12 e Student Name 39 30 NOTE The Home School Import will accept either file layout pre 10 3 or 10 3 after
186. sage will be included e Remove Pluses and Minuses from Imported Alpha Marks if selected the import will strip the or from any imported alpha marks For example an A will become an A Sending School IRN required Enter the IRN of the school providing the Marks data to be imported The entity name associated with the IRN will show in the adjacent disabled textbox Click to open the ODE IRN Search page to browse for an IRN at ODE s website Import File required Browse to the location of the file that you received from the JVS and save to your computer Import Import Marks data from the import file You must confirm click OK that you really want to import this information before the import completes Error Message Cause Resolution This is most frequently due to an EMIS ID or SSID mismatch between the JVS and home school Change the incorrect EMIS ID or SSID at the incorrect building and re export or student not found change the EMIS ID or SSID in the import file and re import Note If you ignore this error and continue on with the import this student s marks will not be imported 16 ProgressBook Studentlnformation Import Export Guide Error Message Cause Resolution No matching mark found X No matching Subject Area found XYZ This is most frequently due to a JVS using plus and minus marks and the home school using only letter marks The usual resolution is to change the mismatched mark to
187. se the EMIS situation Wizard validated against EMIS options file of all valid EMIS situations Both the EMIS Situation number and description are displayed If necessary click m to use the EMIS oituation Decision Tree Wizard to choose the correct situation EMIS Situation defaults to the EMIS situation specified in the registration defaults for the building in context If a district is in context EMIS situation defaults to the EMIS situation specified in the registration defaults for the district If no registration defaults are available EMIS situation defaults to situation 5 for regular districts or nonpublic schools 302 for JVS schools 386 for ESCs or 258 for community schools Admitted From IRN If you selected 3 6 or 7 in the Admission Reason field enter the district in which the students were previously enrolled Otherwise if you selected any other value in the Admission Reason field the Admitted From IRN field is not editable and defaults to Click a to open the ODE IRN Search page SMART logic will be invoked to help determine the correct value District Relationship optional Select the appropriate educational relationship between the students being imported and the district SMART logic will be invoked to help determine the correct value District of Residence optional Enter the district of the legal residence of the students being imported Click to open the ODE IRN Search page SMART logic wi
188. st be present and match the current school year in context e EMIS ID Building IRN and Program Codes must be valid active values for the school school year in context e Start and End Dates must be valid dates and be present in the file e End Date must be less than 1 full year past the Start Date Student Program GQ Record Special Education Import Logic 1 If the import file contains a GQ record any code with effective start date in the next school year Studentlnformation will not load the record and flag an error on the Import screen 2 f the import file contains a GQ record 215xxx Studentlnformation loads the records to the Services tab on the Special Education screen using the following logic 28 ProgressBook Studentlnformation Import Export Guide e lf the imported record has the same program code effective start date and effective end date Studentlnformation will not load the record e lf the imported record has the same program code and same effective start date but a different effective end date Studentlnformation updates the record e fthe imported record has the same program code and different effective start date StudentInformation adds the record e li the imported record has a different program code regardless of effective start date Studentlnformation adds the record 3 Ifthe import file contains a GQ record 220100 Studentlnformation loads the records to the Student Memberships screen using the f
189. st for a pre identification file for districts participating in the SAS Project The designated contact person at each ITC will send one file to ODE containing the information for their designated districts participating in the SAS Project The SAS Pre Identification Export can only be processed at the ITC level Students enrolled in multiple schools are only reported by the school at which they spend the largest percentage of time If the reason a student is attending multiple schools is AU ES JV MR or PS then the student is reported by the attending school specified on the FS Standing tab of the Edit Student Profile screen The SAS Pre Identification Export may also be known as the EVAAS Extraction The SAS Pre Identification Export returns all students in all grade levels enrolled in the current school year SAS Pre Identification Export From this screen you can export the SAS Project pre ID information for one or more districts Include Districts Select All Districts JAC Allen Educ Serv Cntr AD Arcadia Local SD AE Allen East Local SD AG Arlington Local SD AP Apollo JVSD AV Ada Ex Vill SD AW Antwerp Local SD BA Bath Local SD BF Bluffton Ex Vill SD BG Bowling Green SD CE Celina City SD FR JIN LB Pic EI up Mr Cu CG Columbus Grove Local SD LICN Continental Local SD CR Cory Rawson Local SD CV Crestview Local SD CW
190. stricts 142 ProgressBook Studentlnformation Import Export Guide Click Cancel to cancel the SAS Pre Identification Export Click Export to create a single SAS Pre Identification Export file for all districts checked Save Save this file to your hard drive or network drive The SAS Pre Identification Export creates an Excel file including the following fields The following figure shows an example of the SAS Pre Identification Export file MO dd cmn tnim n bo ProgressBook Studentinformation Import Export Guide File Download Do you want to open or save this file e d Ohio District IRN current year in context school IRN current year in context Student Grade current year in context Student SSID Name SASPreld CSV Microsoft Office Excel Comma Separated Values File 16 Type From dev webl noacsc org While files from the Internet can be useful some files can potentially harm your computer If you do nottrustthe source do not open or save this file 2012 School IRN 2011 2012 Student Grade 2011 2012 Student SSID 43505 43505 43505 43505 43505 43505 43505 43505 43505 43505 43505 43505 43505 43505 43505 43505 D 10 AG7184259 11 ANS671225 10 AO2601895 10 AX1374287 11 BB1358506 10 BB5920251 11 BB63 77509 9 BB6378630 11 BH9474506 11 BH54 5963 10 BL4075112 10 CG6317309 9 CRS42 2663 9 C52370459 7 CT3760451 8 CZ47485371 143 WebXam Export Navigation Home
191. student s district The State Student ID Export uses a student s nearest future FS FD record if no current FS FD record exists for the selected school year 32 ProgressBook Studentlnformation Import Export Guide State Student ID Export From this screen you can export data for a specific file format Header Fields IBM User ID E Source Building IRN 033084 Source District IRN 043877 Schools DASL ELEMENTARY SCHOOL DASL HIGH SCHOOL DASL MIDDLE SCHOOL Social Security Number all Digits O Last 4 Digits O Leave Empty Existing Student Code OY Used to indicate that the student has already been enrolled in an Ohio public school and likely has an existing SID If Y record will not be updated 9 N Record will be updated O This Is 4 Practice Run Student Options 9 Send Only Students With No SSID Send Only Students With SSID Send All Students IBM User ID required Enter the IBM User ID of the person who will be submitting the file This is used in the Header row of the file Important Do not use your Studentinformation User ID for this field Source Building IRN required Enter the IRN of the Building used in the export This field defaults to the IRN of the school building in context This is used in the Header row of the file If this is an ITC enter the ITC s IRN Source District IRN required Enter the IRN of the District used in the export This field
192. surement Export Test Ohio Achievement Assessment e s Include the following grades ard Grade 4th Grade 5th Grade 6th Grade v 7th Grade Bth Grade Return only these students Comma separated Student Ids Available Schools in District required Select the schools that are to be included in the export file One export file will be created that will contain data for all selected schools Export Format required Select the Preldent For Pearson Educational Measurement Export Test required Select the Ohio Achievement Assessment Include the following grades optional Select which grade levels should be included in the OAA Pre Ident export file Return Only These Students optional enter specific Student IDs separated by commas to return in the export This can be used when creating pre identification export files for alternate assessments Any 10th grade student who is actively enrolled and has not yet taken the OGT test OGT Ohio Graduation Test The OGT Pre identification export process is performed whenever there is a need to create Pre identification labels to submit to the testing company prior to a test administration The OGT Pre ldent will include the following students in the file 1 Include students who are actively enrolled at the time pre ident is processed 2 Include all 10 grade students with percent of time greater than zero except for ProgressBook Studentinformation Im
193. sv export file contains the following columns First Name Middle Name Last Name First Name Called Name otudent Number SSN Birth Date Ethnicity Gender Locker Locker Combination otatus opecial Education Grade Address Address 2 City otate ZipCode Telephone Primary Contact Type Primary Contact First Name Primary Contact Last Name otate Student ID District Admission Date Disability Condition Free Reduced Lunch ProgressBook Studentlnformation Import Export Guide 151 e Building IRN e District IRN e State Reporting ID The following figure shows an example of the Student List output file B C D E F G H l J K L IMiddle Name Last Name Called Name Student Number SSN BirthDate Ethnicity Gender Locker Locker Combination Status defect MMM XXXX73360 7 3 2002 W M A defect NNN XXXX73361 6 5 2002 W defect 000 4 7 2004 W defect PPP 6 27 2008 W FFF aaa 4 1 2000 W GGG RRR 12 29 1997 W HHH SSS 7 29 1993 W JJJ TIT 12 25 1995 W LLL TIT 4 20 1998 W 2 3 4 5 6 T 8 9 mimizimizizziszr KRA L List The KRA L List option creates the DataMap Kral csv export file The DataMap Kral csv export file contains the following columns e Last Name e First Name e Middle Name e State ID e Test Date e Score e Score Not Reported e Accommodations e School Year The following figure shows an example of the KRA L List output file D E F D H l TestDate Score Score Not Reported Accommodations School Year Cnnnnn l
194. t From this screen you can export data for a specific file format Fostoria Life Touch Photo ka Student Statuses Excluded Student Statuses Included A ACTIVE RES D DELETED gt I INACTIVE e o M NON RES Export Fields Lol Student Number Homeroom Name Lol city Lol Area Code Student Last Name Homeroom Teacher Last Name State Phone Prefix Lol Student First Name v Address Lol Zip Phone Number Student Grade Level sl Address z Student Statuses Excluded Student Statuses Included required Choose the Student Statuses to be included or excluded in the Export Export Fields The Export Fields will be defaulted uncheck those fields that you do not want to export Export Execute the Export process File Download Some files can harm your computer IF the file information below t looks suspicious or you do not fully trust the source da not open or save this File File name DAHS csv File type Microsoft Office Excel Comma Separated values Fil From dsldemo mcaecn arg Would vau like to open the file ar save it to your computer Cancel More Inta Save Save this file to your hard drive or network drive ProgressBook Studentinformation Import Export Guide 115 This file is comma delimited left justified with soaces as padding characters Fields included in the export are the following e Student ID e Student Last Name e Student First Given Name e Stude
195. t Riverside ITBS Pre Identification Export bi Grade Level ist Grade vr 4 Building Name 4g Layout 9 Long Short The long layout includes the following fields e Last Name e First Name e Birthdate e Gender e Grade e Building as you enter it in the Building Name field D RiversidePreldent TestBuilding 1202091133 1 txt Notepad File Edit Format View Help LAST NAME FIRST NAME BIRTH DATE GENDER GRADE BUILD Jones John 05 03 2002 M 1 TestBuilding Smith Kristin 08 13 2002 F 1 TestBuilding F l TestBuildinc ProgressBook Studentinformation Import Export Guide 87 Short Layout ub Home Management Import Export Pre Identification Export Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools DADA DALTON ELEMENTARY DAHS DALTON HIGH SCHOOL ee DAJH DALTON INTERMEDIATE DAKI KIDRON ELEMENTARY Export Format Riverside ITBS Pre Identification Export Grade Level ist Grade v 4g Building Name Layout Long Short Logramos ITBS Form e Logramos ITBS Level e CogAT Form CogAT Level e The short layout includes the following fields Last Name First Name Birthdate Gender Grade Building as you enter it in the Building Name field Logramos Form Logramos Level CogAT Form CogAT Level D RiversidePreldent dasl 0305081149 1 txt Notepad File Edit Format
196. t is currently under development bug 3743 The following figures show an example of the General Edulog export file Ej EDUDA SEQ WordPad File Edit View Insert Format Help Dc E amp a fm B 68 p48652258Banana 048652419Jones O00006005MAY 000004005WELLS 000004003 JOHNSON 000006001EYE 000007003RING 000001224LEE 000007001CONTRARY 000005004SPRAT 000006002FONT 000004001EYE 000006004LINE 0D0005001CONTRARY 000005002 PERRY 000007002 PERRY 0000040088 AWYER 000005005WELLS 000004004POTTS 000122445EYE 000006003 JONES 0000070048 ARGENT 000005003POTTS 000007005WILLIAMSON 000004002FONT 048652281Contrary Z EDUDA SEQ WordPad ile Edit View Insert Format Help F19870817268722176 M19290042 7 F198810041237698453 Fi9861223123098654 N19860913458769300 Mi9890716589098456 F19890511555444334 F19891030678956677 M199002 14369852369 M19880202453123789 F19690105278654738 N19870403267874612 N19890202908987876 F19871117376873245 N19871204564789874 M1989042 4099898907 H19891029258741258 F19880317453676123 M19860801756543290 F198911121236541235 F198908144563509900 F19890930565454345 N19870920890987654 M19891015134876456 F19861024568976542 M20050404 Hannah Raymond DAISY LEE JOBETH GEORGE EVAN CORY ROBERT NICOLE SUZANNE HARPER LEE JASON WILLIAM JACK JOSEPH MICHELLE LYNN MAGNUM P TROY AARON MARY M MICHAEL JAY RICHARD MATTHERICH THOMAS JACK JONA RENEE JORDAN DANIEL PRIVA WHITNEY ANN LEANN J
197. ted character to separate each field in a file With this format the default option is to place quotes around fields that contain text values These files will end with the extension of CSV as the default but the user may change the extension to his her specification ProgressBook Studentinformation Import Export Guide 1 TAB DELIMITED formatted files use a TAB character to separate each field within the file These files end in the extension TXT as the default but the user may change the extension to one of their own choosing NEW VERSIONS of Microsoft Excel can successfully import data stored in an HTML table format For this reason and greater flexibility the Excel export format will be done using HTML table tags These files will end with the extension XLS If deemed necessary at a later time this option can be revisited and additional formats such as XML or native Excel formats can be added to the list of available download options FIXED LENGTH export format is used for a number of legacy applications expecting to import and export data in a fixed length format In this format each line of the file is the same length padded with spaces if necessary and each field in the file has a designated starting position and length The padding will default to spaces being used but the user may choose a different character number to be used as padding The padding will be on the right by default but the user may change it to default to the left if nee
198. ten Readiness Assessment FA Record Special Education Import Logic 1 If the same test date required test part assessment type code GO and existing accommodation equals No Studentlnformation will load update the record with the accommodation value from the import file 2 lf no matching FA records exist no records are imported Imports may be done at any time during the school year Export Formats State Student ID Export Navigation Home Management Import Export State Student ID Export All students in the state of Ohio are required to have a state assigned unique identifier number to facilitate anonymous reporting of student data to ODE for EMIS purposes This statewide ID is provided by a third party system that reports an existing ID for a student if one exists and creates new identifiers for students that cannot be matched to existing records in the system This program export will be processed once a year or as requested There will also be the ability to initiate the program on a scheduled basis to run automatically When run in batch it will include all buildings within an ITC Regardless of whether the ITC or a specific district is in context the Ethnicity Native Language and Legal Name values are pulled from the Live record from the Student EMIS Time Period table The Live record from the Student EMIS Time Period table is the one for which the reporting period is equal to the Live reporting period for the
199. the input into homogeneous processing sets Within this order one of seven sort orders must be specified 01 UNSORTED output is same sequence as input 02 NAME within GRADE within SCHOOL 03 NAME within TEACHER within SCHOOL 04 NAME within TEACHER within GRADE within SCHOOL 05 NAME within LEVEL within GRADE within SCHOOL 06 NAME within LEVEL within TEACHER within SCHOOL 07 NAME within LEVEL within SCHOOL Y student will take Performance Assessment Thus a pre coded SISS for Performance Assessment is required Y Student will take Writing Assessment and the Writing score will appear on the CAT 5 MAP report A pre coded SISS is required for the Writing Assessment Terra Nova 2 Edition BB MA Blank 1 2 or 3 Terra Nova Export File Format 3rd Edition Barcode Layouts Grade numeric fill leading space with zero 05 for Grade 5 for example for Kindergarten use KG for Ungraded use 00 Teacher s Name alpha numeric or blank ProgressBook Studentlnformation Import Export Guide 137 103 104 111 113 122 123 128 129 132 134 135 136 137 138 139 143 144 145 146 147 148 149 150 152 153 154 155 156 157 158 159 160 161 sack ks eae tak O Od C1 Q Q N z O NO 164 138 Special Codes field numeric or blank To include the district IRN in the export file enter the district IRN in the Special Code field Test ID numeric The test ID cod
200. the internal value of your status codes for students to be included in the file As of DASL 9 0 1 8507 the OGT Pre Ident is only accessible by districts If the OGT Pre Ident is accessed with a building in context the following message will be displayed Pre Identification Export This page is not available for your Working School This page can only be accessed for Districts 92 ProgressBook Studentlnformation Import Export Guide As of 10 3 0 16150 students without SSIDs will display in a list at the bottom of the page and give the user the option to continue excluded the students in this list from the export or cancel The user can also click on the student information and have a window pop up with the Student Profile Edit screen 4 i gt Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools DAEL DASL ELEMENTARY SCHOOL DAHS DASL HIGH SCHOOL da DAMS DASL MIDDLE SCHOOL e Export Format Preldent For Pearson Educational Measurement Export Test Ohio Graduation Test v s Include only required students Include the following grades 10th Grade 11th Grade 12th Grade 13th Grade Include the following students Contract Vocational In Include CVI home school information Contract Vocational Out JVS Include JVS home school information Return only these students C
201. tinformation Import Export Guide 117 This file is comma delimited and left justified The following fields are included in the export e Student ID e Student Last Name e Student First Given Name e Student Gender e Student Birthdate e Student Grade e Student Homeroom e Homeroom Teacher Last Name e Student Address 1 e Student Address 2 e Student City e Student State e Student Zip Code e Student Area Code e Student Phone 1 e Student Phone 2 e Student Parent The following figure shows an example of the Lange Photo Export file 118 ProgressBook Studentlnformation Import Export Guide Lima Life Touch Photo Export Navigation Home Management Import Export Photo Export Lima Life Touch Photo The Lima Life Touch Photo Export is shown in the following figure They use this export file to generate bar codes for the schools and then produce a CD containing the student pictures and associated student information Photo Export From this screen you can export data for a specific file format Lima Life Touch Photo bd Student Statuses Excluded Student Statuses Included A ACTIVE RES D DELETED gt I INACTIVE E gt H NON RES Export Fields Student Number Homeroom Name Lol city Z Phone Prefix Student Last Name Homeroom Teacher Last Name State Phone Number Lol Student First Name v Address Lol Zip Parent Name Student Grade Level Address Z Area Code Student St
202. ting point of that field and the length in parenthesis Student ID 1 9 Student Last Name 10 15 otudent First Name 25 14 ochool Code 39 3 Edulog school code not Studentlnformation school code Grade Code 42 3 Edulog school code not Studentlnformation school code Resident Address 45 25 Mailing Address 70 25 City 95 18 Zip 113 9 Parent 122 25 Phone 147 10 Date of Birth 157 8 formatted as mmddyyyy otudent Status 165 1 Studentlnformation status code Withdrawal Date 166 8 formatted as mmddyyyy Note that for the Status code at position 165 any student on a non attending calendar will have the code D listed unless their Student Profile has Data Flag 3 set to J The following figure shows an example of the BATH Edulog Export file D EDUDA SEQ WordPad Oe 64 A eB D0000 1224 LEE HARPER ODOOAOOLETE BAGNUE P izz HORTH 3T OOo FONT ELLA JANE Jas N FRONT 3T 45001 JANE FUNT 1961024 EROGO 4003 T OSNSON c ed MOCKINGBIRD LANE ATTICUS FINCH EDWARD ETE 43193452234512585 1030 55511122221B5B8 770403 So STATE STREET GEORGE EWAN HoWABD JOHNSON 158505913 ODOOAOOAPOTTS UDODSUDSSELLS OOO LER ODOSOOLCONTRAEY UU SU FERRY CeO SOs POTTS OMOOOSODAEPRAT GE oe DC U U el Urin SOC S MERLS OOD SOLE TE ODO EOM FONT OOOO bio OnE OCODDO 6004 L INE ncgonnangsmA RROD UOICONTRAET cbobo TOO FERRY ODDO T0035 RONG RROD FUCO S AEGCEB DU DIOOD VISE
203. tlnformation Import Export Guide 135 Terra Nova Complete Battery 040 Terra Nova Complete Battery TCS 2 041 Terra Nova Complete Battery Plus 042 Terra Nova Complete Battery Plus TCS 2 043 Terra Nova Survey 044 Terra Nova Survey TCS 2 045 Terra Nova Survey Plus 046 Terra Nova Survey Plus TCS 2 047 Terra Nova Multiple Assessments 048 Terra Nova M A TCS 2 049 Terra Nova M A Plus 051 Terra M A TCS 2 amp Plus 052 oupera Multiple Assessments 053 Supera Multiple Assessments with Plus 054 Terra Nova Supera Survey 055 Terra Nova Super Plus 056 Terra Nova Supera with Plus 057 Terra Nova Complete Battery 2 Edition 058 Terra Nova Complete Battery Plus 2 Edition 059 Terra Nova Complete Battery InView 2 Edition 060 Terra Nova Complete Battery Plus InView 2 Edition 061 Terra Nova Survey 2 Edition 062 Terra Nova Survey Plus 2 Edition 063 Terra Nova Survey InView 2 4 Edition 064 Terra Nova Survey Plus InView 2 Edition 065 Detroit Terra Nova Survey 2 Edition Level 13 076 Missouri Slip Sheet 079 opanish Star Sabe 080 South Carolina TN Survey 081 Washoe NV TN Level 13 082 Kentucky CTBS 5 083 Terra Nova Algebra 2 Edition 084 Terra Nova Multiple Assessments 2 Edition 091 Terra Nova M A with InView 2 Edition 092 Terra Nova M A Plus 2 Edition 093 Terra Nova M A InV
204. trict in context AIR Export From this screen you can create an AIR export file Choose students by filters Choose students by student numbers Choose students by ad hoc membership Use the filters below to choose the students within the district to include in the extract Schools Available CAREER CENTER Schools Chosen v Grade Levels Available 07 07 08 08 09 09 10 10 Grade Levels Chosen Student Statuses Available A ACTIVE RES D DELETED I INACTIVE N NON RES Student Statuses Chosen Home Schools Available Home Schools Chosen 000 High School 000 East High School 001 High School 003 ton High School Include only students admitted after ka Students must have an SSID on their current FS record to be included in the extract Students must have a Home School IRN set on the student profile to be included in the extract The extraction file created by the JVSD will select all students for the specified home school who are also enrolled in the JVSD 128 ProgressBook Studentlnformation Import Export Guide Choose students by filters Choose students by filters Choose students by student numbers Choose students by ad hoc membership Use the filters below to choose the students within the district to include in the extract Schools Available Schools Chosen CAREER CENTER Grad
205. trict in context Home School IRN Reguired field Size digit school IRN contains only numeric values 0 9 Enter the IRN of the school where the student was last tested for the OGT Use the value of the Attending IRN specified on the latest FS record for the student in the district in context 85 114 30 Home district Optional field Alpgha numeric Must correspond to Name home district IRN Use the district name associated with the district IRN in context 115 144 30 Home School Optional field Aloha numeric Must correspond to Name Home School IRN Use the name of the school associated with the value of Attending building on the latest FS record Name student Name student Initial middle name month m e p eye meer een DD m m tome eem YYYY 194 194 1 Gender Required field Alpha F female M Male ProgressBook Studentlnformation Import Export Guide 127 OHIO TEST Record Description for Student Data Files Start End Field Field Name Comments Description Position Position Length 195 203 Statewide Required field between September 15 and April Student Identifier 30 of every year State assigned Student ID only SSID Combination of aloha and numeric must start with two alphas followed by numeric 0 9 SSID of the student as specified on the latest FS record for the student AIR Export JVS District in Context Navigation Home Management Import Export AIR Export JVS Dis
206. tudent ID SSID or EMIS ID The default is SSID If the user chooses SSID then the import will first try to match the student on SSID and if no match is found it will try to find a match on the EMIS ID If the user chooses EMIS ID then the import will first try to match the student on EMIS ID and if not match is found it will try to find a match on the SSID If no SSID or EMIS ID match is found the record is not imported and an error record is added to the onscreen summary or verification file depending on which option the user has chosen IMPORTANT Your selection will be determined by which ID the JVS used in the export file You will want to import on the same selection that the JVS exported Marks Import Option optional You may select one or more or none of these options e Ignore Area of Study If No Match To Existing Values If selected records with no match on Area of Study will still be imported Area of Study will be left blank and an import verification message will be included If not selected records with no match on Area of Study will not be imported and an import verification message will be included e Ignore Subject Areas If No Match To Existing Values If selected records with no match on Subject Areas will still be imported Subject Area will be left blank and an import verification message will be included If not selected records with no match on Subject Area will not be imported and an import verification mes
207. tudents Optional Home School Name ipha numeric Must correspond to Home School IRN ProgressBook Studentinformation Import Export Guide 103 At this time the export file will only contain one course section for each subject category Note that courses are only included in the export file if their EMIS tab contains an EMIS Subject Code that matches an EMIS subject code for the listed subject Reading and Writing courses will first look for matches on a Reading EMIS subject code 050102 050104 050106 050119 050300 or a Writing EMIS subject code 050014 050220 050400 050403 050500 059920 as appropriate and if there are no matches on these the export will look for a match on a Reading Writing EMIS subject code 050152 050154 050156 050160 050170 050180 050190 050545 051905 059930 059999 before leaving the course blank Note Prior to 10 3 016150 the OTELA Pre ld Export was looking at courses and teachers by Subject Area For Credit not EMIS Subject Type As a result since the Subject Area For Credit is always for non high school courses middle school and elementary courses were not getting picked up As of 10 3 0 16150 the code was modified to match on EMIS Subject Type not Subject Area for Credit Preldent for OLSAT Navigation Home Management Import Export Pre Identification Export Preldent for OLSAT dropdown Please use this export only for the OLSAT Otis Lennon School Ability Test exports
208. udentinformation Import Export Guide SE File Download Some files can harm your computer IF the file information below wal looks suspicious or you do nat fully trust the source do nat oper or zave this file File name INFOhioDASL SEL dents Et File type Text Document From dsldema mcaecn arg Would you like to open the file or save iE to your computer Cancel More Info rm ee ec ee ee Eee pm ES E ile e apenirmu this time al File Save Save this file to your hard drive or network drive Please send the file to the INFOhio support person for further processing The following figure shows an example of the INFOhio Export file INFOhioDASLStudents 1 txt Notepad Student Number Building IRN Name Graduation Wi thdrawal Date Gender Address City State Zip Phone SSN Birthdate Grade Parent Name Homeroom Teacher Name Program Code Home School Last Name First Name Middle Name Called Name Suffix Email Status Code 2306 000976 Student55219 Raegan F 645 S Main St Lima 0H 45804 555 SC CG poe joga gt 2004 04 20 kcG ee Student55219 Raegan Elizab et LU n n n m 2032 000976 Student55355 Isabelle F 645 S Main St Lima FOH 45804 555 555 5555 366117692 2001 10 20 02 x x STudent55355 Isabelle Hope m n n n A
209. udentlnformation will load update the record with applicable fields 2 lf an exact match of date type event date and assessment area code is not found studentinformation will load import the record with applicable fields Student Special Education Graduation Requirement records should be imported for Periods K and N Imports may be done at any time during the school year Special Education Import SpS Student Achievement Test FA GA Record Type Navigation Home Management Import Export Special Education Import SpS Student Achievement Test Run Option Student Achievement Test Record Sort Type FA The Student Achievement Test record import will serve as an update if a match is found The import file layout of the Student Achievement Test record will be formatted in the FA file record layout as defined in Chapter 5 of the ODE EMIS Manual 30 ProgressBook Studentlnformation Import Export Guide Student Achievement Test FA Record Special Education Import Logic 1 If the same test date assessment area code assessment type code GA required test type and existing accommodation equals No Studentlnformation will load update the record with the accommodation value from the import file 2 lf no matching FA records exist no records are imported Imports may be done at any time during the school year Special Education Import SpS Student Ohio Graduation Test FA GX Record Type Navigation Home
210. udents high school transcript data that you can then submit electronically to U S colleges and universities participating in the eTranscript initiative When preparing to transfer eTranscript data you can use the following screens to select options and see the data you are sending before you send it GPA Set Options FJ Screen Navigation Home Management Import Export eTranscript GPA Set Options FJ If you plan to send Student Academic Performance Summary FJ records in the transfer in the Cumulative GPA Sets and Single Year Only multi select lists select the cumulative and or single year GPA sets you want to include in the FJ transfer and click Submit llb Home gt gt Management gt gt Import Export gt gt eTranscript gt gt GPA Set Options FJ GPA Set Options FJ From this screen you can transfer Period E eTranscript records Cumulative GPA Sets 2013 2014 15T 9 WEEKS GPA 2013 2014 8th grade recog 2013 2014 2ND 9 WEEK GPA 2013 2014 3RD 9 WEEK GPA 2013 2014 4TH 9 WEEK GPA Single Year Only 2013 2014 15T 9 WEEKS GPA 2013 2014 2ND 9 WEEK GPA 2013 2014 3RD 9 WEEK GPA 2013 2014 4TH 9 WEEK GPA ProgressBook Studentinformation Import Export Guide 155 Graduation Core Summary Record GC Screen Navigation Home Management Import Export eTranscript Graduation Core Summary Record GC If you plan to send Student Core Summary GC records in the transfer you can
211. urse EMIS subject code of 050102 Reading K 3 or kindergarten language arts course EMIS subject code of 050152 Integrated English Language Arts K 3 along with their teacher information studentinformation gt Management gt Import Export gt Pre Identification Export Pre Identification Export From this screen you can export data for a specific file format Available Schools in District Selected Schools DAHS DALTON HIGH SCHOOL DADA DALTON ELEMENTARY DAJH DALTON INTERMEDIATE DAKI KIDRON ELEMENTARY Export Format PreIdent For KRA w Choose KRA Pre Id Type to Export Student 1 At the top of the screen select the school s to include in the export by moving them from the Available Schools in District multi select list to the Selected Schools list A single export file for each type selected of Student Teacher and Enrollment will contain data for all selected schools 2 In the Export Format drop down list select Preldent For KRA 3 In the Choose KRA Pre ID Type to Export drop down list select Student 4 Click Export If any kindergarten student does not have a state student ID SSID the student displays in a grid ProgressBook Studentinformation Import Export Guide 109 Studentinformation gt Management gt Import Export gt Pre Identification Export Pre Identification Export From this screen you can export data for a specific file format Available Schools in Dist
212. used Absence Unexcused and Tardy values are right justified 54 ProgressBook Studentlnformation Import Export Guide Start ength Comments Position End Position SSID EMIS Id 1 9 State Student Id or EMIS Id When user chooses to export SSID the process will use the SSID if the SSID is present or the EMIS Id if the SSID is not present When user chooses to export EMIS Id the process will use the EMIS Id if the EMIS Id is present or the SSID if the EMIS Id is not present Attended 10 19 1 The sum of the days attended as indicated on the student s right justified calendar day actual days minus the absence level of any absences on the calendar day Examples 1 Student s calendar day indicates 1 actual day of attendance student does not have an absence record on calendar day and then the student will be given 1 actual day of attendance 2 Student s calendar day indicates 0 5 actual days and student does not have an absence record student will be given 0 5 days attendance for the calendar day 3 otudent s calendar indicates 1 actual day of attendance student has an absence record indicating 0 5 days absence then the student will be given 1 0 5 days attendance or 0 5 days attendance on the calendar day 0 0 0 0 L Absence 20 29 1 Sum of the absence levels on all student absences marked Excused right justified as excused Absence 30 39 1 Sum of the absence levels on all student absences marked Unexcused right justified a
213. utlined Terra Nova Export File Format for details on these parameters Formatting Options for the Terra Nova 3rd Edition Barcode Label Layout Please see the previously outlined Terra Nova Export File Format for details on these parameters Save Save this Terra Nova School Grade Configuration and return to the Terra Nova School Grade Summary List You will receive the following message Please note that the School Grade Configurations are only saved until you navigate away from the Terra Nova Export screen You will need to enter the proper School Grade Configurations each time you execute the Terra Nova Export Terra Nova Export From this screen you can export a Terra Nova pre identification file The Grade Level was added successfully Save amp New Save this Terra Nova School Grade Configuration and enter an additional Terra Nova School Grade Configuration Please note that the School Grade Configurations are only saved until you navigate away from the Terra Nova Export screen You will need to enter the proper School Grade Configurations each time you execute the Terra Nova Export Cancel Do not save this Terra Nova School Grade Configuration and return to the Terra Nova School Grade Summary List ProgressBook Studentinformation Import Export Guide 141 SAS Pre Identification Export Navigation Home Management Import Export SAS Pre Identification Export The SAS Pre Identification Export fulfills ODE s reque
214. vert the file created by the external grade book package into the CLIS records The file needs to be of fixed width and left justified with spaces for padding The import will include all records found in the external application The file layout will be as follows with the starting point of that field and the length in parenthesis ProgressBook Studentlnformation Import Export Guide e Marks Course ID 1 15 e Mark One 38 3 e Marks Course Section 16 2 e Mark Two 41 3 e Filler 18 2 e Mark Three 44 3 e Marks Student ID 20 9 e Mark Four 47 3 e Marks Comment One 29 3 e Marks Work Habit 50 1 e Marks Comment Two 32 3 e Marks Citizenship 51 1 e Marks Attendance 35 3 Step One Reporting Term and File Name LOAGRADE Import Step One Reporting Term File name Prd Ignore Load Errors Next gt Reporting Term Choose the correct Reporting Term from the drop down list The Reporting Terms are defined by building File name Browse Browse to the location of the File Name to be imported The file does not need a specific file name or extension Ignore Load Errors If checked the import process will display errors in Step Two and allow you to continue which will load any records in the import file that do not have errors If unchecked the import process will not allow you to continue past Step Two if any records in the import fil
215. vide teacher credential ID numbers so that teachar lavel results can be tracked across test unless student iS participating in mech un Se du dent is participating in accelerated unless student is participating in accelerated unless sudes is participating in accelerated testing unless student is participating in accelarated p s Required for JYSD etudonte Optional for other students Optonal administrations hammer Districts may populate this field course cade Alpha numaeric Districts may populate this field with tha writing course coda Ipha numernc Districts may populate this held with mathematics course cade Alphanumeric Districts may populate this feld with the sclence course code Alphanumeric Districts may populate this field with the social studies course coda Six digit District IRM numeric 0 9 If this field ims filled out student ecoro roporte will bo mado availablo to the indicated dictrict FER Cu ca Course ode Writing Ix c cu O Ka j Ta EE a d B cu Course Gode Soclal S1udies Course Gode Science 6 Home District IRN P ca EM 6 Home School IRN Six digit School IRN numeric 0 9 If this field is filled out student score reporte will be made available to the indicated school Alphanumeric Must correspond ta Home District IRN Required for JV SD students JD Home District Name Opbux ral for other s
216. view each student s GC record information on this screen Note If you have not yet created GC records you must click Update to create these records to include in the eTranscript transfer A grid displays a list of students with GC records created To view a student s GC record in the row of the student click Details iib Home gt gt Management gt gt Import Export gt gt eTranscript gt gt Graduation Core Summary Record GC Graduation Core Summary Record GC From this screen you can verify eTranscript Graduation Core Summary Record GC records Request Type ig Update Graduation Core Summary Record CL men LI m e E m A EI Details A 10074595 JONES MARK The student s GC record details display To view credit information for a particular CORE area in the row of the area click Select Jones Mark CORE Area Code CORE Area Count Credits Courses In Progress Credit Amount Projected Courses Credits Deficient Saat me mmm nm 1 z um deci ec 2 000000 mmm n m a sest in 2 000000 mmm 1 n m am ze wm zsm ox 1 z 1 Omm sest wm 1 000000 mmm z aa Seil mm zem mmm Te IL om EE EE E EE EE E EE E EE Values of 99 99 are not required for graduation and are not included in total At the bottom of the window is a listing of courses by CORE area code that the student has taken is taking or is scheduled to take along with t
217. xecute the Export process File Download va Some fles can harm your computer IF the File information below looks suspicious or you do not fully trust the source do not open or save this file File name EDUCA SEQ File type From dsldema mcaecn arg Would vau like ta open the file ar save it to your computer j Cancel More Info Save Save this file to your hard drive or network drive 60 ProgressBook Studentlnformation Import Export Guide The file is fixed width left justified with spaces for padding The file layout will be as follows with the starting point of that field and the length in parenthesis Student ID 1 9 Student Last Name 10 15 Student First Name 25 14 school Code 39 3 Edulog school code not Studentlnformation school code Grade Code 42 3 Edulog school code not Studentlnformation school code Resident Address 45 25 Mailing Address 70 25 City 95 18 Zip 113 9 Parent 122 25 Phone 147 10 Date of Birth 157 8 formatted as mmddyyyy otudent Status 165 1 Studentlnformation status code Withdrawal Date 166 8 formatted as mmddyyyy Note that for the Status code at position 165 any student on a non attending calendar will have the code D listed unless their Student Profile has Data Flag 3 set to J The following figure shows an example of the ELIDA EDULOG Export file D EDUDA SEQ WordPad k Sof CeO 12 24LEE HARPER ODOOAOOLETE
218. xport a Terra Nova pre identification file The Grade Level was added successfully Grade Student Status Codes ELEMENTARY 01 01 N A ELEMENTARY 02 02 A HIGH SCHOOL A The School Grade Summary List will show any School Grade Configurations already added to the list This page has standard add record edit record and delete record controls Click Add New to enter a new School Grade Configuration Click Export to process the export A single District export file will be created for all of the School Grade Configurations listed File Download Do you want to open or save this file E Name TerraNovaPreldent 0603090248 t t z Type Text Document 50 7KB From dev webl noacsc org While files from the Internet can be useful some files can potentially harm g your computer If you do not trust the source do not open or save this file 134 ProgressBook Studentlnformation Import Export Guide Save Save this file to your hard drive or network drive Terra Nova Export File Format Cat 5 15t Edition 2 Edition and 3 Edition 1 13 District Name alpha numeric 14 15 otate Name two character postal abbreviation 16 30 ochool Name alpha numeric 31 32 Grade numeric fill leading space with zero 05 for Grade 5 for example for Kindergarten use 57 for Ungraded use 00 33 34 35 49 50 60 61 64 65 71 72 74 76 77 78 83 85 94 95 104 opecial Codes field numeric or blank The customer specifies which if

1704 StudentInformation Import Export Guide

Contents

Download Pdf Manuals

Related Search

Related Contents