SPELL Fact Sheet - Santa Clara County Office of Education
Contents
1. EL in ELD amp Acad Sub 515 4 530 PL EL in ELD amp Acad Sub 3 479 4 530 Brandon Garcia Laura Kansas Middle g B 528 i 532 3 522 L Garcia Pen Carlos A 513 500 4 532 3 522 oon TT i Elementary 3 483 3 512 3 520 School Georgia F Garg Jennifer Elementary s Enana 612 B f Scale Score Garcia Mayra A Emi Indicate scores considered for met not met status Columns headers not highlighted indicate display only scores Show Reporting Parameters Fig 4 AMAO 1 Report in detail format showing individual student scores Santa Clara County Office of Education Page 14 of 38 Version 4 0 SChool Plan SPELL User Manual What do you see on the AMAO 1 Detail Report The detail screen displays following data points and offers some filtering capabilities for further analysis 1 Student ID 2 Student Name 3 Name of School 4 Grade 5 EL services being received by the student 6 EL designation of the student 7 CELDT Overall scores proficiency level and scale score for two years 8 CELDT sub skill scores for two years 9 An indicator for whether the student met or did not meet AMAO 1 10 The column headers of the scores that must be compared for the purposes of measuring progress in English are highlighted in blue Column headers of other scores presented for reference only are2. For those students who do not have prior year annual score initial scoi Fig 1 AMAO 1 Summary Report at District Level What do you see on the AMAO 1 Summary Screen The title of the screen AMAO 1 Report Annual Progress for Learning English 03 04 displays the description of the report as well as the year you selected in the previous screen The Summary tab displays the following 1 The level at which you are viewing the report for the district fora particular campus or for a grade This level of access each user has will be governed by the permissions granted at the time of setting up the account A campus user will be able to access data for their campus only To go from one level to the next simply click on the name of the district or Santa Clara County Office of Education Page 11 of 38 Version 4 0 SChool Plan SPELL User Manual campus Fig 2 shows us which campus in a district met or did not meet targets Fig 3 shows us which grade in a campus met or did not meet standards 05 06 AMAO Summary Detail Name of the District Maple Valley School District Number of Annual CELDT Takers 1161 Number of CELDT Takers Last Year 1494 Number of Student s With Valid CELDT Score 922 609 Number of Student s Meet AMAO 1 Target Percentage 52 Percent Meeting AMAO 1 v Met Target for AMAO 1 Campus N
3. 24 SPELL AnalySIS aciei aa QU Dc ME Cb NI DUE VK NEED VV Gd taU 25 1 17 Reclassification HODONL oue ptc d um De eR UA SSMUS RAM M DIR Un ERUI MSIE UN NEA 25 1 17 1 Whats SPELL IGOR 4 vccscsenerenaseuonanerenencsiontaeaeneannennaeneuenaetaneneneetes 25 1 17 2 Generating Reclassification Report esssssssssss 26 1189 SPELL AMA Ze 6 sordos anaon enaena AEEA EEEE EEEE NEER 28 1 18 1 What is the SPELL Analyzer cccccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeees 28 Selecting Roster for Report Generation cccccccsssessseeeeeeeeeeeeeeeeeeeeeeeeeeeeees 30 1 19 Understanding CELDT testing reporting cycles and the need for rerostering in SPELL cometer eid temi buste abu derieun c ieee awe ade yar Dede nee e Rd eint 30 1 20 Selecting a Roster using Basic Settings sssssssss 30 1 21 Selecting a Roster using Advanced Settings ssssss 31 SPELL System Administrative Functions eeeeeeeeeeeeeee 32 1 22 Managing User ACCOUNIS atn tpe nix xn muU ipa apo ue riga 32 1 22 1 Searching for a User ACCOUNL eeeeeeeeeeeeeeeeeeeeeneeeeeeeeeeeeeeeee 33 1 22 2 Creating a New User Account eeceeeeeeeeeeeeeeeeeteeeeeeeeeeeteeees 34 1 22 3 Making Changes to an Existing User Account 35 1 22 4 Resetting User Passwords ssssssssseenen 36 1 22 5 Deleting Users mTT
4. middle 01 14 1999 01 14 1999 amp E E p E E 2 10158 VemeyM Midde 02 22 1999 02 22 1999 6 3 500 509 ri i 5 a p Es 8 10219 Flores Jesus Middle 08 30 1999 08 30 1999 6 School Tennessee 10226 Flores Edwin Middle 08 30 1999 08 30 1999 6 a 2 460 459 2 46725 0 ep H p Flores Tam Middle 00 26 1999 10 17 2000 6 School I 1 10231 a 3 519 S28 07 16 3 p em i 5 i 2 3 3 Morea Tennessee 10237 ia A Middle 01 05 1958 11 14 2000 7 512 538 250 4 flores Tennessee 10261 Arvinjeet S Midde 08 30 1999 08 30 1999 6 5 E EL 576 589 567 H Delaware 10307 cjaudia Hogh School 09 03 1996 09 03 1996 9 EL 3 Sii 487 518 H i ss ss ss 10 Gees Mal Schoo 4701 1993 09 01 1593 ssi oss 8 610 Tennessee 10003 Fomanseys middle 08 30 1999 08 30 1999 6 3 sar sa s29 a sae 3 School E L i _ 10014 Semang Midde 08 30 1999 08 30 1999 6 a s64 589 scolis s a 2 1 i tx x x oe e e e e t x o cease Flaresca Delaware Fig 8 Reclassification report detail Santa Clara County Office of Education Page 27 of 38 Version 4 0 SChool Plan SPELL User Manual 1 18 SPELL Analyzer No of years in District From All To All w Score Filtering Parameters You can identify specific student groups based on their performance on assessments that you are monitoring for reclassification m Enterthe score
5. 1 16 2 AMAO 3 Detail Report After generating the AMAO 8 report click on the detail tab This displays individual student level data on the AMAO 3 Data displayed include 1 The Total Number of Records this is the number of students who are included in the AMAO 3 cohort Note that the system displays 30 records per screen and provides a next button to view the rest of the students Student ID Student Name Name of the School US Entry Date the date student was first enrolled in a US school District Entry Date date when student was first enrolled in the particular district Grade EL Services services being provided to the student under Title III EL Designation note that on the AMAO 8 report RFEP students are also included 10 CST ELA Proficiency Standard and Scale Score to be considered proficient in ELA a student must have proficiency level of 4 or better Ifa student has met proficiency requirement the score is highlighted in green Scale score is displayed for reference of how close to or far away from proficiency a student is 11 CST Mathematics Proficiency Standard and Scale Score the student is expected to have a proficiency level of 4 or better on the Math part of the CST as well to have met AMAO 8 proficiency requirement 12 CAHSEE ELA and CAHSEE Mathematics Proficiency Level and Scale Score if a student is in the 10 grade that students CAHSEE scores are taken into consideration
6. From All v To All v Number of years in District From All v To Alv Show Only Students Who are AMAO3 Proficient O Only Students Who are not AMAO3 Proficient A Student US Entry District ee EL Id Name School Date sidus Ium Designation ennessee Hass r ELinELD C j1n003 Middle School jpavsaiieee psvsarisss 6 a SDAIE B 1 x rl Tennessee 10000 Henry H Middle 09 05 1997 08 30 1999 8 RFEP M S sem dus x _ School i IEEE a Tennessee EL in ELD pu TNR viale Schoo pevsalsse SNE LES 9 jasoa epe m p meg pp E x 09 01 1998 09 01 1998 7 RFEP 3 338 3 313 x js i inessee l I inosa Middle School 09 30 1999 06 30 1999 6 RFEP sec RT s4 v Pernt Fessahaye Tennessee ral a es P 3002 Middle School 8 90 1999 08 30 1999 RFEP 43622286 x Y nnecticut 10124 Figueroa Elementary 08 28 2000 08 28 2000 5 RFEP 392 aoa i ao Nicholas S School 4 m 10138 Fine ol 02 03 1999 02 01 1999 7 RE EL sigs 2 ges x Firouzman m ELinELD em mu il 0157 banya middle School 01 14 1999 01 14 1999 9 aspare 2 269 3 338 x Fischer Tennessee ELin ELD prm Vianey M Middle Schoo 02 22 1999 02 22 1999 6 p parg EL ips 2 299 x Meo Rodolfo Tennessee pores Qo Haa School 7903 3995 os 28 2000 sa _ jare 3 307 3 323 oe Ln x Fisher Tennessee
7. who are ready for reclassification and those that are not ready Since each districts goal is to reclassify as many students as possible identifying those students who are close to meeting SPELL Index is important SPELL Analyzer is the query engine that will help them to identify these students What are the Query Options SPELL Analyzer allows the district to query for a range of values on assessments and scores that are defined on the Admin SPELL Index screen Hence if CAT6 ELA and Math NPR and NCE were set up as additional district criteria on Admin SPELL Index Setup screen they should be able to query for values of those scores Query Options must include 1 Level of Query district school grade If you do not select a level then the default level at which you have access to data is considered 2 Scores to Query By a State mandated reclassification SPELL Index assessments and scores b CLEDT Overall Proficiency Level c CELDT Sub skills Proficiency Level Santa Clara County Office of Education Page 28 of 38 Version 4 0 SChool Plan SPELL User Manual d CELDT Overall scale score even though this score is not state mandated it is available for query e CELDT Sub skills scale score even though this score is not state mandated it is available for query f CST Scale score B District mandated reclassification SPELL Index assessments and scores 1 All those subjects scores and assessments chosen by the dis
8. ALL my criteria You can then further filter this using Reporting Parameters For example after you generate this list of students you can click on the program EL in ELD in Reporting Parameters and see the same list filtered for students who received that program Santa Clara County Office of Education Page 29 of 38 Version 4 0 SChool Plan SPELL User Manual Selecting Roster for Report Generation SPELL allows users to select a roster and then run AMAO and SPELL Analysis reports The need to do this is driven by CELDT testing cycles and usage of that data not only in meeting mandated reporting requirements but also in informing instruction To accommodate the latter SPELL includes a feature allowing users to choose whether they wish to view reports from the AMAO meeting mandated achievement goals perspective or from the perspective of viewing current students performance and using that data to inform instruction going forward 1 19 Understanding CELDT testing reporting cycles and the need for rerostering in SPELL In displaying detailed AMAO reports SPELL versions prior to 3 0 listed students who took the annual CELDT assessment testing between July and October results returned in January The next update of student roster would only be completed the following year when CELDT was administered again This process allowed a school district school to study which students had met AMAO targets and identify bubble groups of
9. H E i a 10170 eT Middle Schoo 08 27 1998 08 27 1998 7 RFEP 370 354 v 10210 Flores Araceli i Middle Schc i 08 30 1999 08 30 1999 6 RFEP 381 384 d 10219 Flores Jesus pes i 08 30 1999 losj0 999 6 EDD EL 2 zes s 328 E x in Tennessee ELinELD Ta kaal 10226 Flores Edwin Middle School 09 30 1999 08 30 1999 6 asa apa 9 s om m x ELinELD 10231 Flores Tam C 08 26 1999 10 17 2000 6 EL 3 325 3 318 10231 Flores Tam C Middle School 09 Bee SS genae Bs 0 speso m se o o Flores Tennessee ELinELD a si pe 10257 emmanuel Middle School 01 05 1998 11 14 2000 7 A SDAIE EL 2269 2 277 x Flores Tennessee EL in ELD 20261 _larvinjost s__ Midale Schoo P0901999 emen 6 lasoare E ims 1 ja X Tennessee E a e nex 10296 Middle School 0923 1999 09 23 1999 RFEP B 3 me x Floresca Mitzi Tennessee ELinELD S E 1036 d Middle School 08 30 1999 08 30 1999 9 asoa amp 236 2 4 x I 10336 Fojas Juan M lene Middle 08 30 1999 08 30 1999 amp prep 3 350 x Foley Tennessee ELinELD 5 paste Stephanie R Middle School 08 30 1999 08 30 1999 6 la spare EL 2 289 2 290 x Fonseca Tennessee pins Ricardo Middle Sch yj 01 24 2001 05 03 2001 7 MES RFEP 3 js 3 33 x iy Tennessee ELin ELD s lie se 20395 Forney Tr H middie School 08730719
10. Password box Repeat the new Password in Retype New Password box Click on Login This saves your new password and allows access to the system at the same time You can use the new password to login on subsequent use of SPELL Santa Clara County Office of Education Page 10 of 38 Version 4 0 SChool Plan SPELL User Manual Chapter 3 Annual Measurable Achievement Objectives Reports AMAO 1 Report includes students who are making progress in learning English AMAO 2 Report includes students who have attained English Proficiency There are various guidelines to identify students who must be considered as part of the cohort group for each of these reports For this information please refer to the document Guidelines to understand the 2003 04 Title IIl Accountability Reports on the California Department of Education website It is available at http www cde ca gov sp el t3 documents amao04 doc AMAO 1 Report Annual Progress in Learning English 05 06 05 06 AMAO m Summary Detail l EL B Print PDF Name of the Region Report i Number of Annual CELDT Takers 1161 Number of CELDT Takers Last Year 1494 Number of Student s With Valid CELDT Score 922 I Number of Student s Meet AMAO 1 609 Target Percentage 52 Percent Meeting AMAO 1 66 1 Met Target for AMAO 1 M District Name Achieved 9o Met Target for AMAO 1 1 Maple Valley School District 66 1 ov Show Reporting Parameters
11. You can use a combination of these filters for powerful analysis on the AMAO 2 Report For example you can filter for all students who speak Spanish as the home language by checking that box under Home Language and then use the header option to filter for students who receive EL in SDAIE services and have Santa Clara County Office of Education Page 18 of 38 Version 4 0 SChool Plan SPELL User Manual been in the District for 2 years to see how many of the Spanish speaking students receiving that service have met AMAO 2 targets after being taught in the district for 2 years 1 14 AMAO 3 Adequate Yearly Progress for English Learner Subgroup at the LEA Level AMAO 3 measures whether the LEA s EL subgroup met the 2006 AYP participation rate and percent proficient requirements 1 AMAO 8 relating to meeting AYP requirements for the EL subgroup is based on data from the California Standards Test CST the California Alternate Performance Assessment CAPA and the California High School Exit Examination CAHSEE 2 AMAO 3 is only applicable to LEAs 1 15 Students included in AMAO 3 Students are included in the AMAO 8 calculation if 1 They were part of the EL AYP subgroup and counted on the R 30 census and were e In grade 2 8 and tested on CST in ELA and Mathematics e In grade 10 and tested on CAHSEE in ELA and Mathematics e In grade 2 8 and 10 and tested on CAPA in ELA and Mathematics 2 For AMAO 3 there
12. contain jase rtiecianiieniienttonddaviies Metibendlansienaias 7 Chapter 2 Getting Started sisisicciinaienssatincianseneasauaianapacnansetvagnessanaewiandascasaaananas 8 1 4 Technical Requirements Checklist eeeeesesessessss 8 T5 Logging in caduiarnnancciasnneidonunicnetnoniecadnuiastnatcataetiennanuemid 9 1 6 Troubleshooting Login Issues eeeeseeneeeeeeeeer 10 1 7 Changing your PassWOL e tee e eder ete or bebe etae etin 10 Chapter 3 Annual Measurable Achievement Objectives Reports 11 1 8 AMAO t Summary Report sssssssseeeeeen 11 19 AMAO T Detail HGDOFIL aieo e tex hn ex een ui on aede 14 1 10 Filtering Data on the AMAO 1 Report ssssssssseee 15 1 11 AMAOs 2 Summary Report sssssssssssssesseeenenee 16 1 12 AMAO 2 Detail Report esessssssssseeeeeeeeennnnnneeenrnn 17 1 13 Filtering Data on the AMAO 2 Report 18 1 14 AMAO 3 Adequate Yearly Progress for English Learner Subgroup at the LEA Level tT 19 1 15 Students included in AMAO 8 8 ccccceeeeeeeeeeeceeeeeeeeeeeessnneeeeeeeees 19 1 16 Generating the AMAO 3 Report in SPELL sesesssssss 20 1 16 1 AMAO 3 Summary Report sssssseeneeeeeenn 20 1 16 2 AMAO 3 Detail Report eeseesessssssssssseeeeeneer nnne 22 1 16 3 Filtering the AMAO 3 Detailed Report for Further Analysis
13. criteria each student has met highlighted in yellow and their SPELL Index the number of criteria they have met If a students SPELL Index is equal to that of the district then the student has met all criteria and is ready for reclassification 6 You can use the same filtering criteria as the AMAO reports for further analysis on this report Amp Im e Santa Clara County Office of Education Page 26 of 38 Version 4 0 SChool Plan SPELL User Manual SPELL Analysis _ _ Criteria 4 arie E x OROT 05 06 Reading Proficiency Level a EL Services All z EL Designation Aii x c amp prorOs w i ini 3 No of years in US School From Alv To Al SIT 99 95 BA Scale Score 35 No of years in District From Al m To Ally Show O Only Students Who Met SPELL Index O Only Students Who Did Not Meet SPELL Index All Students Total Records 1 30 of 1555 Cesta cruor cst Student Student lt pant US Entry pert j L S e Oygg Lstenina Speaking Reading Writing MA SPELL Met 1d Name Date Entry Services Designation Qa Index INDEX 05 06 05 06 osos osos OF ss 5s EL in wo 2 eae E 607 2804 ELin D amp soar amp y t 5 E Fierros Oregon a Yafe gh Schoo 09 03 1996 08 27 1998 9 559 584 i 5 z 5 572 5n 76 s72 Tennessee 10139 Pardeep Middle 02 01 1999 02 01 1999 7 p H Fe on Be T g I Tennessee 10157 Drew
14. is mobility exclusion for AYP calculations Only students who are continuously enrolled in the LEA from the prior California Basic Educational Data System CBEDS data collection date to the test date CST CAPA or CAHSEE test date as relevant are counted in the AYP calculation for the LEA 3 ELs that are in their first year in a U S school but not yet completed a year on the date of testing are not included in the percent proficient calculation for the LEA However these students are included in the participation rate calculation 4 R FEP students who are not proficient for three years on the CST in ELA after being reclassified are also included in AMAO 3 1 An LEA is an educational agency that received Title IIl funds or services in 2005 06 An LEA may be a school district county office of education COE or a direct funded charter school Direct funded charter schools that receive Title III funds will receive a Title III Accountability Report Annual CELDT takers from direct funded charter schools will be removed from the sponsoring district or COE Santa Clara County Office of Education Page 19 of 38 Version 4 0 SChool Plan SPELL User Manual 5 Refer to the Information Guide on the CDE Web site at http www cde ca gov sp el t3 acct asp for more specific information about the calculation of AYP 1 16 Generating the AMAO 3 Report in SPELL To generate the AMAO 8 report Login to SPELL with the username and pa
15. name or a part of it if you are not sure of how exactly the name was submitted into the database 4 To search for existing users enter filter criteria in the text drop down boxes and click Find Users button You can use one or a combination of values to search for an account For example if you would like to search for all teacher users whose first name starts with Sa you can enter Sa for first name and select teacher as the user role from drop down box 5 The page refreshes and the query results are listed in the Search Results area 1 22 2 Creating a New User Account You can create new users if you have been given rights to do so Before adding a user account use the Find User option to see if the user already exists in the system Click on Admin icon Click on Users button Click on New User button This brings up the screen to add a new user All mandatory fields on this screen are marked with a See Fig 3 O I Welcome to SPELL Admin Setup SPELL Index AMAO 3 Setup Users Spell User Profile User Id MBrown User Role District User v District Maple Valley School District v Name First MI Last Mary Brown Phone Number 650 934 6161 Email admin schoolcity com Force Password Change on Next Login Set Password to password Allow User to Add Users LI Fig 3 User profile screen to add a new user a Enter a User ID This can be both
16. not highlighted 11 For each student who met AMAO 1 the scores that indicate that he she met the target are highlighted in yellow 1 10 Filtering Data on the AMAO 1 Report You can filter data on the report using two sets of options The options contained in the A Report header area which allows you to filter data By campus By grade By type of EL services By EL designation You also have the choice of viewing only those students who met AMAO 1 or only those who did not meet AMAO 1 Ung I It B Reporting Parameters at the bottom of the screen 1 Click on Show Reporting Parameters at the bottom of your screen to display demographic and program parameters 2 Check appropriate boxes to filter the report for that sub group 3 You can use a combination of these filters for powerful analysis on the AMAO 1 Report For example you can filter for all students who speak Spanish as the home language by checking that box under Home Language and then use the header option to filter for students who receive EL in SDAIE services to see how many of the Spanish speaking students receiving that service have met AMAO 1 targets Santa Clara County Office of Education Page 15 of 38 Version 4 0 SChool Plan SPELL User Manual 1 11 AMAO 2 Summary Report MR em puma AMAO 2 AMAO 2 Report Annual Progress in Attaining English Proficiency 05 06 05 06 AMAO ea Summary Detail Print PDF Name of the Region SCCOE Report N
17. numeric as well as alphanumeric and may contain the special characters _ underscore and Period It can be 40 characters long b Select the Role i If the user must have access to data for all schools select District User Santa Clara County Office of Education Page 34 of 38 Version 4 0 SChool Plan SPELL User Manual ii For a principal who must access one school s data select Campus User Then from the drop down select the name of the district and the campus c Enter user s first and last name Each of these fields may be 50 characters long Last name is mandatory d Enter phone number and email These are optional entries only e The system assigns a default password as password every time you setup a new account You will find the Set Password to password option checked by default for a new user f If you would like to force the user to change his her password to a more secure one check the option Force Password Change on Next Login g Allow User to Add Users option when checked gives the user whose account you are creating the ability to add other user accounts h Click Add User to finish creating user account 1 22 3 Making Changes to an Existing User Account To edit a user account search for it using search parameters and Find User option 1 On the search results screen find the user whose account needs to be edited 2 Click on Edit next to that user account
18. students who had not met targets This would be parallel to the state AMAO reports After completing redesignation SPELL reports had reduced value until the next reporting and analysis cycle School districts expressed a desire to continue to use this application reporting cycles to inform classroom instruction for English Learners This could only be meaningful to the user if rosters were refreshed in the Fall to reflect current students grades and campuses where they were placed SPELL therefore allows every user to view reports from both perspectives by selecting either one of the rosters AMAO rosters or refreshed rosters at any point in time This feature will be available to school districts who submit the SPELL Extract data again in the Fall 1 20 Selecting a Roster using Basic Settings Select your roster before running any of the reports To do so 1 Click on My Settings on the top right corner of your screen 2 If you wish to run reports from AMAO reporting timeframe this will be the same timeframe of Title III reporting from the state select the radio button AMAO Roster 3 If you wish to run the AMAO reports for your current student population click radio button My Roster and then select the school year from the drop down list If you select default from the list then the roster settings Santa Clara County Office of Education Page 30 of 38 Version 4 0 SChool Plan SPELL User Manual preset by your sy
19. then printed or stored on the user s computer To support this please download and install the free Adobe Acrobat Reader from www adobe com Microsoft PowerPoint optional SChool Plan DMM includes a charting module Charts generated can then be copied to PowerPoint for presentations Any user who wishes to use this feature must ensure that PowerPoint is installed on their computer Microsoft Excel optional All data viewed in SChool Plan DMM can be exported to Excel and then combined reformatted sorted or rearranged as required Any user who wishes to use this feature must ensure that PowerPoint is installed on their computer Santa Clara County Office of Education Page 8 of 38 Version 4 0 SChool Plan SPELL User Manual MISCELLANEOUS Popup Blocker Turn off popup blockers Popup blockers that are part of applications like the Google Toolbar or Yahoo Toolbar are designed to prevent annoying advertisement popup windows However they also block legitimate popup windows in other web applications like SChool Plan SPELL and must be turned off to allow proper functioning of the application Proxy and Firewall If a firewall is in place ensure that it allows access Settings to SChool Plan SPELL This is something your school district network administrator can check for you This is applicable only if you are working within a networked environment like a school district o
20. 521 4 551 4 530 X x School Tennessee Gagandeep EL in ELD 10692 Catherine C Middle 08 31 1999 08 31 1999 7 B ah ate 525 4 567 8 523 5 567 519 571 sss X v Tennessee Gamboa EL in ELD 10872 v Middle 09 01 1998 02 28 2000 7 spale 2 485 3 S11 3 503 1 459 2 465 4 528 3 S08 4 530 W x Tennessee Gamboa ELin ELD 10873 Same Middle 08 16 1999 02 28 2000 6 spale 3 500 2 476 1 460 2 475 3 523 3 484 3 4972 4 amp 1 X x m Kansas Other EL 10914 da y Middle 09 04 1998 02 16 2000 7 Inst 3 510 3 516 2 492 2 498 3 503 3 509 4 542 4 548 X x Esmeralda Y School Services Washington Garcia EL in ELD 11082 Jacquelin a Elementary 08 28 2000 09 28 2000 Sg cdaie 3 507 3 516 2 499 3 S01 3 515 4 529 3 Si2 3 so5 x x Fig 6 AMAO 2 detail screen What do you see on the AMAO 2 Detail Report 1 Student ID 2 Student Name 3 Name of School 4 Grade 5 EL services being received by the student 6 EL designation of the student 7 CELDT Overall scores proficiency level and scale score for two years 8 CELDT sub skill scores for two years 9 An indicator for whether the student met or did not meet AMAO 1 10 The column headers of the scores that must be compared for the purposes of measuring progress in English are highlighted in blue Santa Clara County Office of Education Page 17 of 38 Version 4 0 SChool Plan SPELL User Manual Column headers of other scores presented for reference only are not highlighted 11 For
21. 6 CELDT 05 06 Reading Scale Score 7 CELDT 05 06 Writing Proficiency Level 3 8 CELDT 05 06 Writing Scale Score 9 CST 04 05 ELA Scale Score 325 Fig 6 Admin screen to setup SPELL Index State mandated criteria are preset As described in section 4 1 1 What is Spell Index state mandated criteria are preset in SPELL This means that all districts start with a SPELL Index of 5 and can then add local reclassification criteria A SPELL administrator can add local reclassification criteria This needs to be done once and changed only if criteria change at any point in time To add local reclassification criteria 1 Click on Admin icon on the top right corner of the screen 2 On the SPELL Index setup screen note that state mandated criteria are preset 3 Input your district s threshold for California Standards Test CST English Language Arts ELA Scale Score 4 Click on Add New Row to start adding local criteria 5 Select the assessment to consider as local criteria For example the district Writing benchmark 6 Select the Subject For example Writing 7 Select the type of score For example Proficiency Level 8 Enter the threshold required for classification For example Proficiency Level of 2 9 Click on Save and Update Spell Index 10 Note that the SPELL Index is incremented every time you add another criterion 11 While printing out the Reclassification reports you may wish to include other scores for teachers to
22. 99 08 30 1999 9 aspa 414 x Fosbenner Kansas Middle 10409 fredrik 3 School 0872871999 08 28 1999 6 mreP S o a ical Ei v 10421 Foster Wasay Trs cil 03 14 2000 03 14 2000 6 ELIDELD EL sm he E E x lio 25 Foulkes Tennessee pega ee E leelo Rm a E 77 9n 10425 ima Middle S ol 93 14 2000 03 14 2000 RFEP 388 3 331 x Fountain Kansas Middle x Ier 77 ea i pecora passed equ imer m Isis tae v eer pecu e Ey 10534 Frizado Nabil mm 08 30 1999 08 30 1999 6 RFEP 369 3 32 x School Furtado Kansas Middle 10849 eek eol 08 28 1999 08 28 2000 6 RFEP 39 3 38 x PS Performance Standard SS Scale Score i criteria met _ Indicate scores considered for met not met status Columns headers not highlighted indicate display only scores Show Reporting Parameters Fig 2 The AMAO 3 Detailed Report Santa Clara County Office of Education Page 23 of 38 Version 4 0 SChool Plan SPELL User Manual 1 16 3 Filtering the AMAO 3 Detailed Report for Further Analysis The AMAO 3 Detailed Report provides two sets of filters The first set in the header allows you to filter the report by 1 School if a district level person is viewing the report If a school level person is viewing the report the view is limited to his her school only Grade EL Services being received by the students EL Designation of the s
23. C 36 1 23 Setting up your districts SPELL INdeX eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 37 1 24 System Administrator Function Associated with AMAO 783 38 Santa Clara County Office of Education Page 4 of 38 Version 4 0 SChool Plan SPELL User Manual Welcome Welcome to Version 4 0 of the SPELL Module of SChool Plan Santa Clara County Office of Education SCCOE schools share the challenges and rewards of serving a large student population with a heritage and language background other than English This is a prevailing and growing trend throughout California To assist teachers meet the needs of these students SCCOE developed SChool Plan for English Language Learners SPELL This version of SPELL is easier to use than earlier versions Data presented in SPELL can also be accessed in the Data Management Module DMM of SChool Plan A main benefit of SPELL is the specialized nature of the application it presents data and reports that facilitate EL instruction and meet Title III reporting requirements SPELL features that support student reclassification from EL to RFEP are time savers for district office staff They also support teachers who must explain language classification to parents of EL students Users must provide two years of data to satisfy minimum requirements in the SPELL database Districts that have installed the Extract Transform and Load ETL tool will have data automatically tran
24. E CAPA and are in the cohort for AMAO 8 based on criteria described above in section 3 8 Target Percent Proficient for English Learner subgroup this is the AYP proficiency target for EL subgroup for 2005 06 Both ELA and Mathematics targets are listed Achieved Percent Proficient for English Learner subgroup this indicates if the EL subgroup met the proficiency requirement as per AYP for that year on the CST ELA and Mathematics Met minimum group size indicates if the EL subgroup is numerically significant by AYP guidelines Santa Clara County Office of Education Page 20 of 38 Version 4 0 SChool Plan SPELL User Manual 8 Is AMAO 3 applicable AMAO 3 is only applicable if the EL subgroup is numerically significant based on AYP guidelines and inclusion rules Note The AMAO 3 summary report may indicate that an LEA has met participation rate and percent proficiency requirement However that data is only valid if Is AMAO 3 applicable displays a check for yes If it displays a x then please ignore proficiency and participation rate indicators This means that the LEA has not met either the participation rate or the minimum group size requirements for AMAO 3 9 Met Target for AMAO 8 this indicates whether or not the EL subgroup Version 4 0 A AMAO 3 S AMAO 3 Report adequate Yearly Progress for English Learner Subgroup 05 06 05 06 AMAO Summary Detail m Print PDF
25. Name of the Region SCCOE Report Number of CELDT Takers 1572 a Number of CST Takers 5030 Number of CAHSEE Takers 1024 Export to x Excel Number of Valid Participants 1071 ELA Target Percent Proficient for English Learner Subgroup 23 0 Achieved Percent Proficient for English Learner Subgroup 42 5 Met Participation Rate for English Learner Subgroup d Met Percent Proficient or Above for English Learner Subgroup d Met Minimum Group Size oY Math Target Percent Proficient for English Learner Subgroup Achieved Percent Proficient for English Learner Subgroup Met Participation Rate for English Learner Subgroup oY Met Percent Proficient or Above for English Learner Subgroup d Met Minimum Group Size ov AMAO3 Is AMAO 3 Applicable Met Target for AMAO 3 rd Is AMAO 3 Applicable 1 Maple Valley School District v District Name Met Target for AMAO 3 Show Reporting Parameters Fig 1 The AMAO 3 Summary Screen Note the Is AMAO 3 Applicable indicator The Summary table also includes the ability to drill down from district to school and then to grade levels AMAO 3 is only valid for districts and schools but not at the grade level Data displayed at grade level on the AMAO 3 summary drill down in SPELL is derived from school data and is not mandated by Title III at grade level Santa Clara County Office of Education Page 21 of 38 Version 4 0 SChool Plan SPELL User Manual
26. SChool Plan SChool Plan for English Language Learners SPELL User Manual Version 4 0 SANTA CLARA COUNTY OFFICE OF EDUCATION 1290 Ridder Park Drive San Jose CA 95131 SChool Plan powered by SchoolCity Inc Copyright Copyright 2006 SchoolCity Inc All rights reserved Confidential and proprietary information of SchoolCity Inc is contained herein Any reproduction use appropriation or disclosure of this information in whole or in part without the specific prior written authorization of the owner thereof is strictly prohibited Failure to observe this notice may result in legal proceedings or liability for resulting damage or loss Any and all information or specifications are subject to change without notice Revisions 01 22 2007 4 0 Welcome Included welcome message Chapter 1 New section providing an introduction to SChool Plan and its modules Chapter 3 New section on AMAO 3 Report Chapter 5 New chapter on rerostering data in SPELL Chapter 6 New section on system administrator function associated with AMAO 3 report SChool Plan SPELL User Manual Contents Welcome Losada aaraa Eaa aaa a E aaa 5 Chapter 1 Introduction uo ode paecsst etie ER Yibhwiu e irR RR bela Dr RVA EN tii bra dw UR 6 1 1 What is SOhoDDPPIafVs s ioo petris cq eve etra x rixa uk uet iqetrqs t cq net tqet ue us 6 Tu Introduction to SPEL sneinen aiai e 7 1 3 What do SPELL reports
27. Schoo USEntry District ad Overall Test Reading Listening Speaking Writing Met Met Name 00 Date perdis e services 04 05 05 06 04 05 05 06 04 05 05 06 04 05 05 06 AMAO1 AMAO2 Tennessee Fine EL in ELD 10139 Pardeep Middle 02 01 1999 02 01 1999 7 a SDAIE f F F ii if LE is T M chool Tennessee Fischer EL in ELD 10158 Vianeym Middle 02 22 1999 02 22 1999 6 Sena 3 504 3 500 1 449 2 492 4 533 3 504 3 493 X x Tennessee Flores EL in ELD 10226 Edwin Middle 08 30 1999 08 30 1999 6 a spale 2 453 2 461 1 460 1 459 2 450 2 460 2 4532 467 X x Tennessee Flores EL in ELD 10237 Pore ie Middle 01 05 1998 11 14 2000 7 S SDAIE 519 s89 2 484 4 538 v School Other EL Flores Delaware 10307 Gaudia High School 09 03 1996 09 03 1996 9 Inst 516 3 511 3 513 3 518 510 3 487 4 532 4 555 X x Services Floresca Delaware 10315 karna B High School 09 03 1996 10 04 1999 9 3 505 3 490 1 452 2 475 4 530 3 500 3 508 3 488 X x Tennessee 10316 Moresca middie 08 30 1999 08 30 1999 6 FLINELD 3 492 3 5042 488 3 503 3 495 3 509 3 490 3 498 X x Mitzi I perse amp SDAIE Tennessee Foley EL in ELD 10340 Stephanie n Middle 08 30 1999 08 30 1999 6 aspar 3 518 3 5213 513 3 516 3 SiS 3 515 45304538 X x Tennessee 10395 PY Tri Middle 08 30 1999 08 30 1999 6 SABAE 3 493 3 524 2 488 3 516 3 495 4 537 3 4973 509 X x School Gabriel Tennessee 10671 Jocelyn Middle 08 30 1999 08 30 1999 6 3 524 3 513 3 532 2 481 3 508 3
28. See Fig 4 Version 4 0 Welcome to SPELL Admin Setup SPELL Index AMAO 3 Setup Users Spell User Search User Id Role v First Name Last Name District Name Campus Name Find Users that match the criteria above or add a New User Spell User Search UserID User Name User Role D MBrown Mary Brown Central Office User Fig 4 Edit button on User Search Results screen 3 On the next screen make changes as required 4 You cannot change the User ID Santa Clara County Office of Education Page 35 of 38 Version 4 0 SChool Plan SPELL User Manual 5 f there were errors in the User ID you will need to delete the account and recreate it 6 Save changes 1 22 4 Resetting User Passwords If a user forgets his her password it cannot be retrieved Instead you can reset the password back to the default of password To do this Find the user account using search parameters and Find User Click on Edit Check the box Set Password to password You can also check Force Password Change on Next Login to ensure that the user sets up a new secure password This is however optional only Save changes Now the user can login with his her user ID and password as the password um zd sium oo 1 22 5 Deleting Users To delete a user 1 Locate the user account using Find User and search parameters 2 Click on Remove next to the user account
29. alysis tab provides access to two features 1 Reclassification Report 2 Spell Analyzer 1 17 Reclassification Report The Reclassification Report includes students who are ready to be reclassified based on state and district mandated criteria SPELL allows reclassification to be based on not only state mandated criteria but on those as well as local district mandated ones To understand how SPELL handles this it is important to first understand what SPELL Index is 1 17 1 What is SPELL Index The state mandates that to be considered for reclassification students must score as listed below CELDT Overall proficiency level of 4 or better CELDT Listening and Speaking proficiency level of 3 or better CELDT Writing proficiency level of 3 or better CELDT Reading proficiency level of 3 or better CST ELA Scale Score of xxx xxx is defined by the district not the state a Explanation for definition of xxx The state mandates that the student s CST English Language Arts score must be considered for reclassification However the state does not define what score the student has to achieve on the CST ELA Each district can setup its own score threshold b The state provides a guideline only The guidelines are c CST ELA scale score is the score to consider d The district must set its own threshold for what that expected scale Score is It can range from the beginning of Basic level up to the mi
30. ame Achieved 9 6 Met Target for AMAO 1 1 Amazon Elementary School 70 8 2 Connecticut Elementary School 96 6 v 3 Delaware High School 69 2 4 Georgia Elementary School 46 3 x 5 Kansas Middle School 55 6 Ld 6 Oregon High School 70 5 Ld 7 Tennessee Middle School 73 8 v 8 Washington El it ool 58 0 ov Show Reporting Parameters For those students who do not have prior year annual score initial score is used for calculation ly Settings AMAO 1 Report Annual Progress in Learning English 05 06 05 06 AMAO Summary Detail Name of the Campus Georgia Elementary School Number of Annual CELDT Takers Number of CELDT Takers Last Year Number of Student s With Valid CELDT Score Number of Student s Meet AMAO 1 Target Percentage Percent Meeting AMAO 1 Met Target for AMAO 1 Grade Achieved 9 Grade 0 60 0 Grade 1 61 9 Grade 2 33 3 13 6 Grade 4 55 6 Grade 5 62 5 Met Target for AMAO 1 D SSXX amp S amp Show Reporting Parameters For those students who do not have prior year annual score initial score is used for calculation Santa Clara County Office of Education Page 12 of 38 Version 4 0 SChool Plan SPELL User Manual 2 The summary tab also gives us the number of students who took the CELDT in the year you selected and the number of students who took the CELDT the previous year 3 From these two nu
31. d point of the Basic level i e usually between 300 and 325 Beyond the above list of assessments each district may decide what other assessments and scores they wish to consider toward reclassification The district may also determine what is considered a reasonable threshold of performance for each of those assessments These assessments could include even local assessments p m Santa Clara County Office of Education Page 25 of 38 Version 4 0 SChool Plan SPELL User Manual The total of state mandated criteria and district defined criteria for reclassification is the SPELL Index for that district 1 17 2 Generating Reclassification Report m aw Version dio x NOT SPELL Analysis SPELL Index Report Redesignation Report 05 06 05 06 AMAO es Summary Detail Print PDF Name of the Region SCCOE Report Number of CELDT Takers 1572 Number of Student s Meeting SPELL Index 115 Gy Percent Meeting SPELL Index 7 3 Export to Excel District Name Meeting SPELL Index 1 Maple Valley School District 7 4 Show Reporting Parameters Fig 7 Reclassification report summary To generate the Reclassification report Click on the SPELL Analysis Tab Select the year for the report Click Run Report This screen displays the number of students who met SPELL Index and the percentage of those who met SPELL Index on the Summary tab Reclassification detail report shows the
32. each student who met AMAO 2 the scores that indicate that he she met the target are highlighted in yellow Additional data displayed on AMAO 2 Detail Report additional to what is displayed on the AMAO 1 Report 1 Year of US entry 2 Year of district entry Entry grade from which the student has been continuously enrolled in this district 3 An indicator for whether the student met or did not meet AMAO 2 or not 1 13 Filtering Data on the AMAO 2 Report You can filter data on the report using two sets of options The options contained in the You can filter data on the report using two sets of options The options contained in the A Report header area which allows you to filter data By campus By grade By type of EL services By EL designation By Number of Years in US Schools For example a value of 2 to 2 would display students who have been in US Schools for 2 years 2 to 4 would display those that have been in US schools for 2 to 4 years By Number of Years in District You also have the choice of viewing only those students who met AMAO 2 those who did not meet AMAO 2 and those who met AMAO 1 made progress but not AMAO 2 but did not attain proficiency in English e gs od qoc ND B Reporting Parameters at the bottom of the screen 1 Click on Show Reporting Parameters at the bottom of your screen to display demographic and program parameters 2 Check appropriate boxes to filter the report for that sub group 3
33. gh 10307 Claudia School 5 3 516 3 his 3 513 510 4 532 4 555 i 3 505 1 452 3 508 3 488 Floresca Delaware High Karla B School A Floresca Mitzi Tennessee ir 10316 lle S 5 Las 509 3 22 10315 Xx X S Foley Tennessee amp Ei p E Stephanie R Middle School 3 ics 515 t 529 4 538 Fonseca Tennessee 19357 Ricardo Middle School ES sel ip Tennessee EL in ELD amp 10395 Forney Tri H Middle School SDAIE Gabriel Tennessee E 10671 Secelyn Middle School o pj 3 m 521 4 ssp 4 530 Gagandeep Tennessee EL in ELD amp 10692 Catherine C Midde S SOAIE 525 8 587 571 4 542 4 559 Gamboa Tennessee ELin ELD amp 10872 d SOME 528 3 508 4 530 ELin ELD amp SDAIE is g Tennessee ELin ELD amp I0892 Gamez Luis E gie s EAE 557 Bss Hs 110340 x L 3 493 3 537 3 497 3 509 10873 484 3 497 2 461 121 Other EL Inst S09 4 542 4 548 Gamon Kansas Middle School IGervicas 10914 Esmeralda Y jg Delaware High t 1101 vere Bue S 638 569 568 Aa a a Pal Vi a aa 11081 Garcia Mario DS laware High 571 4 554 T Garcia 11082 Jacquelin A 529 3 ux i EL in ELD amp prono i Middle School SDAIE Garci Georgia ELin ELD amp jui g Acad Sub S15 3 512 School ji PL 537 4 532 11143 z 437 1 433
34. instead of CST to indicate if the student has met proficiency requirement for AMAO 3 A student is expected to have a P Pass on CAHSEE ELA and Mathematics 13 If a student has been tested on CAPA then CAPA Proficiency Level is taken into consideration instead of CST and CAHSEE The expected proficiency level on the CAPA is 4 or better In SPELL CAPA scores are not displayed in a separate column DRN o N Note In SPELL CAPA and CST scores are uploaded together For a Special Ed student who was eligible for CAPA testing his her CAPA score is displayed in the CST columns Similarly for a 10 grade Special Ed student CAPA score is displayed in the CST column and there will be no score in the CAHSEE column 14 The last column provides a quick indicator of whether the student has or has not met AMAO 3 proficiency requirement This is based on the test Santa Clara County Office of Education Page 22 of 38 Version 4 0 SChool Plan SPELL User Manual taken into consideration for that specific student whether it is CST CAHSEE or CAPA as discussed above ly Settings Logout T TE ATTIE Ye Version 4 0 Atad L AMAO 3 te Yearly Progress for English Learner Subgroup 05 06 05 06 AMAO EL Designation Number of years in US School
35. mbers the number of students who have CELDT Annual scores for two years Number of Students with valid CELDT scores is computed 4 Note Students who have matched CELDT Annual scores for two years are considered toward AMAO 1 and AMAO 2 reporting However for 2003 04 CDE is taking into account students who have two years CELDT scores irrespective of whether those are from Annual or Initial administrations 5 The summary also gives us the number of students who met AMAO 1 6 The target percentage is defined by CDE for each year The percentage for 2003 04 is 51 for AMAO 1 7 The actual percentage who met AMAO 1 for the level at which you are viewing the data is displayed 8 AM indicates Met AMAO 1 and a XX indicates Did not meet AMAO 1 Santa Clara County Office of Education Page 13 of 38 Version 4 0 SChool Plan SPELL User Manual 1 9 AMAO 1 Detail Report 05 06 AMAO v Grade an v O Only Students Who Met AMAO1 Only Students Who Did Not Meet AMAO1 9 All Students Total Records 1 30 of 922 Next gt Fine Pardeep lt CELDT Overall CELDT 3 500 1 449 10219 RE i IEEE 10226 Fores Edwin Middle 1 461 1 460 2 450 2 2 453 2 467 i I School l t DEN Bama t eza st of i ied Flores Tennessee EL in ELD amp 10237 emmanuel Miedles SDAIE Es pipes fs san Sion 2 404 4 sse Flores Delaware Hi
36. omprehensive reporting linked to research based best practices that help educators track and analyze student performance and generate reports including state mandated reports such as School Accountability Report Card SARC and Single Plan for Student Achievement SPSA SChool Plan consists of four modules 1 Data Management Module DMM is a assessment data analysis and reporting system on student performance across state and local assessments Administrators and teachers use the data for reporting and support decision making to impact instruction in the classroom 2 Site Plan and Reporting Module PRM apply research based improvement processes and generate multiple reports such as the School Accountability Report Card SARC the Single Plan for Student Achievement SPSA and an Executive Summary SARC Report 3 SChool Plan for English Language Learners SPELL provides AMAO estimates and redesignation reports It brings together data related to English Learners in a way that provides differentiated instructional support through specific query and analysis I THIS DOCUMENT IS THE USER MANUAL FOR SPELL 4 SChoolCharts SChoolCharts provides predefined charts for schools to immediately use with various audiences All charts are produced using state data files Districts are not required to submit any data You can view CELDT data in both DMM and SPELL You can use SPELL specifically to estimate Title Ill mandated Annual Mea
37. r school not to your home computer Monitor Display Set your monitor s resolution to 1024 x 768 Resolution SChool Plan SPELL is designed to work best at a resolution of 1024 x 768 At smaller resolutions SChool Plan SPELL screens will be larger than what your monitor can accommodate and will require that you scroll sideways To avoid this change the resolution of your monitor using directions provided by the manufacturer of your computer 1 5 Logging in 1 In your browsers address box type the web address assigned to your district for SPELL For example http spell sccoe org yourdistrictname O1 4 C2 n COON OD Enter your Username Enter your Password Click on Login On the home screen select the report you wish to run by clicking on the appropriate tab The tab named SPELL Analysis contains the Reclassification report as well as SPELL Analyzer Select the year for which you wish to run the report Click Run Report The system displays a message window showing what student roster is used in the report Please see Chapter 5 Selecting Roster for Report Generation for information on selecting a roster Santa Clara County Office of Education Page 9 of 38 Version 4 0 SChool Plan SPELL User Manual 9 This brings up the report in summary format by default but you can also click on the Detail tab for that report 1 6 Troubleshooting Login Issues The most common e
38. ranges that you wish to filter for The assessment list presented here and the scores you can query by are based on your district s choice of assessments toward reclassification 2 Do not enter any values for those assessments or scores that you do not wish to include for filtering 3 If you wish to display only those results that meet ALL the values you entered select Display results that meet ALL my criteria 4 If you wish to display results that meet ANY of the values you entered check Display results that meet ANY of my criteria 5 Click Run SPELL Analyzer Display results that meet ALL my criteria Display results that meet ANY of my criteria Assessments Considered for Reclassification Score Values to Filter For SPELL Index From To CELDT 05 06 Overall Test PS From To CELDT 05 06 Overall Test ss From To CELDT 05 06 Listening Speaking PS From To CELDT 05 06 Listening Speaking ss From To CELDT 05 06 Reading PS From To CELDT 05 06 Reading ss From To CELDT 05 06 Writing PS From To CELDT 05 06 Writing ss From To CST 04 05 ELA ss From 300 To 320 Fig 10 SPELL Analyzer showing query options 1 18 1 What is the SPELL Analyzer The Reclassification report gives us a list of students who met or did not meet SPELL Index Each district is therefore able to quickly generate a list of students
39. re and indicate if targets have been met or not Detailed reports contain individual student records with relevant data for two years Santa Clara County Office of Education Page 7 of 38 Version 4 0 SChool Plan SPELL User Manual Chapter 2 Getting Started SPELL is a web based application The application is hosted on a remote server and accessed through a web browser It does not need to be setup on each user s computer If you are a SChool Plan DMM user then your system is already configured to also support SPELL If you are not a SChool Plan DMM user then please check against the following list to make sure your computer is ready to support SPELL SPELL is compatible with both the PC as well as the MAC environments However the browser used on each of these platforms is different Please use the checklist below to make sure your computer is setup correctly to use SPELL TECHNICAL 1 4 Technical Requirements Checklist 6 Adobe Acrobat Reader 1 Minimum CPU Pentium Ill 300 MHZ Macintosh PowerPC 2 Memory 128 MB 128 MB 3 Operating System Win2k WinXP Mac OS version 8 6 or WinNT WinME or later Win98 4 Browser Internet Explorer 6 0 Firefox 1 5 or higher or higher Netscape 7 0 or higher 5 Internet Connection Minimum 56k Minimum 56k modem modem Broadband Broadband recommended recommended ANCILLARY SOFTWARE Most reports in SChool Plan DMM can be converted to PDF format and
40. rrors that may prevent successful login are 1 Incorrect URL To resolve this recheck the URL in your browser including the abbreviated district name as assigned Please check with your district SPELL administrator if in doubt Note that the SPELL URL does not include a www as would most other websites Make sure you have NOT entered a www Incorrect Username or Password If either the Username or Password were incorrect the screen displays a message User authentication action failed Please try again If this error message appears please check your Username and Password and re enter it Note that both the Username and Password are NOT case sensitive If you have forgotten either your Username or Password please contact your SPELL DMM Administrator 1 7 Changing your Password You are assigned a Username and default Password when you first start using SChool Plan DMM In order to preserve the security of your account it is advisable to change your Password from time to time You can change your Password from the Login screen To change your password Nh 9o eo On ea o Enter Username and Password current in Name and Password boxes Locate the checkbox I want to change my password on the Login screen and check it Then click on Login The system displays a Change Password Details popup window Enter the Password you are currently using in the box for Old Password Enter the new Password in New
41. sferred from the district student information system to SChool Plan For districts that manually upload data from outside sources to the district File Transfer Protocol ftp site at SCCOE we provide technical service and support All required data scripts needed to use SPELL are available and included in the Welcome Packet We want data loading to be simple so we encourage you to call with any questions that you might have We are committed to providing tools that assist educators in building a world class educational community We appreciate your patronage and welcome your feedback Complete information about SChool Plan can be found on the Standards and Assessment home page of the SCCOE web site http www sccoe org schoolplan Sincerely Dale Russell Ed D Director Standards and Assessment Santa Clara County Office of Education Updated January 25 2007 9 45 a m Santa Clara County Office of Education Page 5 of 38 Version 4 0 SChool Plan SPELL User Manual Chapter 1 Introduction Welcome to SChool Plan for English Language Learners SPELL Thank you for choosing SPELL as your data analysis and reporting solution for English Learners EL 1 1 What is SChool Plan SChool Plan is an application suite designed by the Santa Clara County Office of Education SCCOE as a comprehensive system that provides school personnel with a Web based solution for data analysis reporting and data hosting It facilitates c
42. ssword assigned to you Click on the third tab AMAO 3 Select the reporting year AMAO 8 reports for years prior to 2005 06 are not available in SPELL Click Run Report The system displays a message that the students included in the AMAO 3 report are from roster year 2005 06 i e students who tested on CST CAHSEE CAPA in 2005 06 Click OK If you wish to view this report with rerostered students please use the My Settings option This displays the report in summary format by default Note that a details tab is also available and provides access to the detailed report that lists individual students Also notice the Print PDF and Export to Excel options on the left to generate a PDF report and to export data to Excel 1 16 1 AMAO 3 Summary Report The AMAO 3 summary report lists the following information 1 2 Number of CELDT Takers total number of students who tested on the CELDT for the year 2005 06 Number of CST takers total number of students who tested on the CST for the year 2005 06 This number is not limited to EL students only This number includes students who tested on the CAPA Number of CAHSEE takers number of students who tested on the 10 grade census administration of CAHSEE in March for the year 2005 06 This number is not limited to EL students only Number of valid participants this is the number of students from the AYP EL subgroup who tested on the CST CAHSE
43. stem administrator will be the ones applied to your reports If you select 05 06 AMAO the reports will display students from AMAO reporting timeframe after the annual CELDT testing for 05 06 If you select 06 07 reports display students re rostered in the Fall 4 Click the button Apply Note By default the roster selected by your district s system administrator is used to run all reports When you make your roster selection your choice overrules the selection made by the system administrator 5 Now click on Home icon on the top right corner and then generate your reports 1 214 Selecting a Roster using Advanced Settings Advanced Settings allow the user to select different rosters for different reports For example a user may wish to run the AMAO reports using AMAO Roster annual CELDT testing timeframe but use the current roster to view SPELL Analysis report To set Advanced Settings click on the link Advanced on the top right corner of the My Settings screen To make a different roster selection for each report Click on the to the left of the report name For each year of reporting select the roster you would like to view Repeat these steps for each report Click Apply To return to default roster selection setup by your system administrator click Default Oe ey Santa Clara County Office of Education Page 31 of 38 Version 4 0 SChool Plan SPELL User Manual SPELL Sys
44. surable Achievement Objectives AMAOs and to generate the Reclassification report You can use DMM when you need to compare more than two year s CELDT scores and also to compare CELDT scores with CST CAHSEE or other local assessments Santa Clara County Office of Education Page 6 of 38 Version 4 0 SChool Plan SPELL User Manual For a complete understanding of the Title III reporting guidelines please refer to the Information Guide on the California Department of Education website It is available at http www cde ca gov sp el t3 acct asp 1 2 Introduction to SPELL SPELL is a web based data analysis and reporting system designed specifically to meet the needs of EL monitoring SPELL produces the following reports and also includes a powerful query option AMAO 1 Report AMAO 2 Report AMAO 3 Report Reclassification Redesignation Report SPELL Analysis a powerful query to identify students close to reclassification on the plateau of learning bubble group These reports include several filtering capabilities that are detailed later on in this document 1 3 What do SPELL reports contain Each SPELL report is presented in a summary and a detailed format The reports can be run at the district campus and grade level It is therefore possible to not only view if a district has has not met AMAO targets but also identify which campuses and grades met did not meet targets Summary reports give an overall pictu
45. t a school may have met them Oo RON The Is AMAO 3 Applicable indicator on the AMAO 3 Summary Screen is an indicator of whether AMAO 3 is applicable to that LEA based on these two criteria Santa Clara County Office of Education Page 38 of 38 Version 4 0
46. tem Administrative Functions If you have been assigned rights as a system administrator for SPELL you will see the Admin icon on the top right corner of your screen after you login This gives you the ability to manage three sets of functions 1 Setting up SPELL Index setting up your district s redesignation criteria 2 AMAO 8 Setup entering participation rate and minimum group size information required for AMAO 8 report 3 User account management e Search for and locate a user account Add new users Edit user accounts Reset user passwords when they forget passwords Delete users Version 4 9 Welcome to SPELL Admin pLIEe Setup SPELL Index AMAD 3 Setup i Users Setup SPELL Index Reporting Year 056 Fig 1 Admin icon in top right corner 1 22 Managing User Accounts SPELL supports two types of users district level and campus level users In addition to this every district must also assign a SPELL system administrator If you are a system administrator you can add and manage district level and campus level user accounts At this time SPELL does not support teacher level accounts Santa Clara County Office of Education Page 32 of 38 Version 4 0 SChool Plan SPELL User Manual If you are a district level user you can add or manage other campus level accounts If you have been assigned those permissions by the system administrator 1 22 1 Searching for a User Account You may need
47. to search for a user account 1 When you want to add a new account and you want to make sure it does not already exist in the system When you want to edit an account and need to locate it When you want to delete an existing account N Welcome to SPELL Admin Setup SPELL Index AMAO 3 Setup Users Spell User Search User Id Role v First Name Last Name brown District Name Campus Name that match the criteria above or add a New User Spell User Search Action UserID User Name user Role Fig 2 Find User Screen To find a user account 1 Click on the Admin icon 2 Click on the Users tab 3 The Find User screen appears It contains various parameters which you can use to locate a user a User ID You can search for a user using their User ID b Role You can search by type of user district level users campus level users c First Name You can search for a user using their First Name or a part of it For example sarah would find all users whose first name is sarah searching for sa finds all users whose names start with sa d Last Name You can search for a user using their Last Name or a part of it e District Name You can search for a user using the name of the district or a part of it Santa Clara County Office of Education Page 33 of 38 Version 4 0 SChool Plan SPELL User Manual f Campus Name You can search for a user using their campus
48. trict 2 No query is available on the display only assessment scores C Query Filtering AND and OR condition 1 Display results that meet ALL my criteria will be an AND condition which means that only students records that meet all criteria selected will be listed 2 Display results that meet ANY of my criteria will be an OR condition which means that students records that meet any of the criteria selected will be listed You can query for students who did not meet specific reclassification targets by using a combination of options listed above For example let us say that your districts CST threshold is 320 If you would like a list of all students who missed being reclassified due to their performance on the CST by a small margin you can enter a range of 300 to 319 on the SPELL Analyzer screen CST Scale Score and run your query If you wanted a list of students who were not reclassified because their CELDT Writing skills were marginally poorer than required a proficiency level of 3 would mean that they met required criterion you can query for CELDT Writing Proficiency Level of 2 to 2 If you wanted a list of students who missed either the CST ELA threshold or the CELDT Writing you can enter the same parameters as above and then select the radio button Display results that match ANY of my criteria If you would like a list of students who missed either one of these two criteria select the radio button Display results that match
49. tudents you can use this as a filter to see for example how just the RFEP students have fared on the AMAO 8 report Number of years in US Schools Number of years in District Filter for only students who have met AMAO 3 Filter for students who have not met AMAO 8 this would be a bubble group for intervention 9 View all students who are in the AMAO 8 cohort WP CON ODO The second set of filters is demographic filters accessible by a single click on the Show Reporting Parameters link at the bottom of the screen Use these elements to filter the report by demographics or programs The demographics are current as of the day of testing on the CST CAHSEE CAPA The two sets of filters can be used in conjunction to provide very detailed analyses For example by selecting primary language Spanish from the Reporting Parameters you can first filter the AMAO 8 report to only display Spanish speaking students You can then apply the filter in the header to show only student who have not met AMAO 3 You would then have a bubble group of Spanish speaking students who have not met AMAO 8 Further to this you can apply the filter for RFEP from EL Designation in the header This will give you a very valuable report of redesignated Spanish speaking students who have not met AMAO 3 Santa Clara County Office of Education Page 24 of 38 Version 4 0 SChool Plan SPELL User Manual SPELL Analysis The SPELL An
50. umber of Annual CELDT Takers 1161 EAS Number of CELDT Takers Last Year 494 w Number of Student s In Cohort 356 Export to Excel Number of Student s Meet AMAO 2 146 Target Percentage 31 4 Percent Meeting AMAO 2 41 0 Met Target for AMAO 2 ov District Name Achieved Met Target for AMAO 2 1 Maple Valley School District 41 0 v Show Reporting Parameters For those students who do not have prior year annual score initial score is used for calculation Fig 5 AMAO 2 summary report What do you see on the AMAO 1 Summary Screen This report is similar to the AMAO 1 summary report except that it shows the target percentage for AMAO 2 as mandated by CDE Santa Clara County Office of Education Page 16 of 38 Version 4 0 SChool Plan SPELL User Manual 1 12 AMAO 2 Detail Report rioa ton a A Ooa MMAMAOLE2 noe m x AMAO 2 Report Annual Progress in Attaining English Proficiency 05 06 05 06 AMAO m nc EN Print PDF Region SCCOE Report d District All Iv E School an v Grade An v EL Services All v Export to Excel Number of years in US School From All m To All v Number of years in District From alx To All Show Only Students Who Met AMAO2 O Only Students Who Did Not Meet AMAO2 O Only Students Who Met AMAO1 and did not meet AMAO2 9 All Students Total Records 1 30 of 356 Next at CELDT CELDT CELDT CELDT Student Student
51. view and then make their reclassification recommendation These may not be strict reclassification requirements You Santa Clara County Office of Education Page 37 of 38 Version 4 0 SChool Plan SPELL User Manual can add those scores and display them on the report without incrementing the SPELL Index by checking the box Read Only 12 After all criteria have been entered you can then run the Reclassification Report 1 24 System Administrator Function Associated with AMAO 3 Each districts SPELL system administrator is required to enter certain data points into SPELL prior to making AMAO 8 reports accessible to users within the district To enter these data Login as a system administrator Click on the AMAO 3 Setup tab Select the reporting year Click Setup AMAO 3 On the next screen with the help of the drop down options provided indicate the following details for the district and then for all schools in the district e Whether or not the district school has met AYP participation rate requirements in both ELA and Math e Whether or not the district school meets minimum group size requirements as per AYP subgroup guidelines e This data is available on the CDE AYP Reports http ayp cde ca gov If a district school has NOT met participation rate or minimum group size criteria then AMAO 3 is NOT applicable to that district school It is conceivable that the district may not have met these requirements bu
52. you wish to delete 3 Confirm that you wish to delete the account Setup SPELL Index AMAO 3 Setup Users Spell User Search User Id Role v First Name Last Name District Name Campus Name that match the criteria above or add a New ser Spell User Search serID User Name user Role Brown Mary Brown Central Office User Fig 5 Remove button to delete a user from User Search Results screen Santa Clara County Office of Education Page 36 of 38 Version 4 0 SChool Plan SPELL User Manual 1 23 Setting up your districts SPELL Index Welcome to SPELL Admin Setup SPELL Index I AMAO 3 Setup Users Setup SPELL Index for the year 05 06 ool reper yt state at or above the th sto oni ba dispajad n your SPELL Recla nter will be considered a pass on that criterion apo buen ot be counted toward SPELL Index check the Display tie u would like some s bo i SPELL Index is the total ee pom HD eclassification criteria Any student who has a Spell Index that is equal to the District s SPELL Inde sidered ready for reclassific Score To Be Threshold for Considered Reclassification BS MUS Assessment Subject CELDT 05 06 Overall Test Proficiency Level 4 CELDT 05 06 Overall Test Scale Score CELDT 05 06 Listening Speaking Proficiency Level 3 CELDT 05 06 Listening Speaking Scale Score 1 2 3 4 5 CELDT 05 06 Reading Proficiency Level 3
Download Pdf Manuals
Related Search