DCT Directions - Missouri Schoolwide Positive Behavior Support
Contents
1. Open file after publishing Step 1 Name file e Name the file and indicate the file where you want to save it e Click Publish 30 Page the Review View Developer Date modified 4 23 2012 2 02 PM 5 14 2012 1 23 PM 4 20 2012 12 08 PM 3 28 2012 4 17 PM 5 3 2012 10 52 AM 5 11 2012 3 07 PM 5 2 2012 2 15 PM 5 2 2012 2 52 PM 4 17 2012 10 34 AM 5 7 2012 3 49 PM 5 17 2012 4 13 PM online and printing A Minimum size publishing online Step 2 Click Publish Type File folder File folder File folder File folder File folder File folder File folder File folder File folder File folder File folder DataCollectionTool5 22 2012vlookup Mi Troubleshooting Guide This guide is intended to address common problems associated with the different versions of Excel used throughout the state You are not prompted to enable content or the buttons do not work If the first time that you open the Data Collection Tool you do not receive a message prompting you to enable content or enable macros and the navigation buttons do not work your security settings may be set to high To Change The Security Level How you change your security settings from High macros are disabled to Medium Macros are disabled but you are prompted to enable them depends on what version of office you have Office 2003 Insert Format Tools Data Window Help y Pr Spelling F7 22. 71 e To navigate to the Quick Big 5 from the Main Menu click on the Quick Big 5 button 14 Page Clipboard P Font O J n a c e a fe ef ifj c u rn 15 Page nT nst nite Design Layout Format Analyze a o ep ts General X lt 3 Normal 2 Normal 3 Normal pag i i gt En 7 Fy 9 9 08 Conditional Format Good l Inset Delete Format z sort amp Find amp sf p m a 2 Clear 7 Filter Select x ont Alignment Number Styles Cells Editing Woo Chart 8 X fe SERIES BehaviorbyStudent B 3 BehaviorbyStudent A 4 A 7 BehaviorbyStudent B 4 B 7 1 A B G D E F G H J K L M N O 2 PivotTable Field List vx a 7 85 Ly o P dd y W4 Choose eke he add eert 87 lt 5 5 Eltast Name o o o Ba First Name 88 F F z 2 Grade a an T Gender 89 En oo a Ethnicity 90 Prace referring Staff Member 91 Month v Date of ODR 92 V Month E Time closest 15 min 93 Major Behaviors by Students Location 94 V Major Offense 35 T Minor Offenses 95 Others Involved T Possible Motivation 96 3 T Administrative Decision 97 T Days of Suspension 98 C Comments Zal 25 99 100 Drag fields between areas below 2 YZ Report Filter E Legend Fields 101 Month z 102 1 5 mE Total 103 104 i 105 106 0 5 f Axis Fields Ca E Values 107 Student Numb
3. Day Per Month Majors by Student Minors by Location i 13 14 Time Minors by Time 16 17 18 Minors By Motivation 19 20 Minors by Student 22 23 Majors Digging Deeper rs by Motivation Others Involved 26 v 4 m gt fy 11 23 AM a t Pr ia 4 5 29 2012 Back to Main Step 1 Choose the Choose Grade closest grade Configuration configuration Gradeske for your Grades K 6 Grades 6 9 school from Grades 9 12 drop down Grades K B or K 12 Enter data below Step 2 Enter the number of 2012 2013 students with 3914 2912 2 5 and 6 correct year 2009 2010 e Using the drop down menu on Step 1 choose the option closest to your school configuration This sets the National Comparison triangle to the 23 Page SWIS National Data Norms established the previous year for that particular school configuration Ear TEE ox Home Insert Page Layout Formulas Data Review View Developer a o e Cut we cig Hir a 7 ET AutoSum B amp Cu Calibri In vlAN Der Si wrap Text General El Hi Normal 2 Normal 3 Bad gm EK ia Z Autosu a Fy Ba Copy 7 ES n i X 5 Fill a Paste f B Z U amp A ZES EE a Merge amp Cener 9 8 309 Conditional Format Good Neutral Calculation Check Cell Insert Delete Format 5 Sot amp Find amp hd J Format Painter a a SSS EE Me 00 0 Formatting as Table h2 hd 2 Clear Filter Select St
4. Involved 26 27 Referrals by Gender Majors by Grade 29 30 TA z Race and Ethnicity Majors by Staff C il Ready PT sam 140 g a mego AM 5 29 2012 Step 6 Minors The Data Collection Tool also allows users to chart minor behaviors This is especially useful for schools that are implementing at the Tier Il and Tier III levels as it allows for the early identification of students who might otherwise fly below the radar Tracking minors also allows schools that have relatively few office referrals to develop schoolwide interventions based upon their specific needs 21 Page Fe ae a Home Insert Page Layout Formulas Data Review View Developer amp cut Calibri vu A g Fez gt c Wrap Text General Md E HB Normal 2 Normal 3 B 4a Copy ENE S Se z P Format Painter B 7 U i7 D7 A EES EE fH Merge amp Center 7 9 3d Sea coms Good calculation E clipboard x Font x Alignment F Number D18 v fe J K L M N P Q R S T U Big 5 Charts Minors Triangle Majors Trian Minors Quick Big 5 Quick Big 5 Behavior Month Totals Location Minors by Behavior Day Per Month Majors by Student Minors by Location Minors by Time Minors By Motivation Minors by Student e To navigate to the minors charts simply click on the button labeled with the desired chart located beneath the Minors heading e These charts will only provide meaningful information if you h
5. macros but F the macros are legitimate you might lose some functionality Enable Macros nable Macros By selecting Medium you will receive a warning every time you try to open a file with macros For the Data Collection Tool you will need to enable the Macros For other programs enable macros only if you trust the source 34 Page For Office 2007 and 2010 You can change macro security settings in the Trust Center unless a system administrator in your organization has changed the default settings to prevent you from changing the settings Step 1 Click i Developer Tab Home Insert Page Layout Formulas Data Review View Developer El EJ Record Macro e Ey Properties T Map Properties ER Import e ES ES j Use Relative References i Ge View Code Pe Expansion Packs ar Export Visual Macros l Add Ins COM Insert Design Source B a Document Basic AY Macro Security Add Ins Mode B Run Dialog 4 Refresh Data Panel Code Add Ins Controls XML Modify E F G H l J K L M N D Data Collection Tool Step 2 Click here to enable change t UP Data Entry Big 5 Charts Majors Data Entry Quick Big 5 Behavior set Up Student Demographics Per Month Totals Location Per Day Per Month Majors by Student Time ml ma e On the Developer tab click Macro Security o Ifthe Developer tab is not displayed click the Microsoft Office Button Ea click Excel Options and then in th
6. number 20 Page Step 5 Majors Digging Deeper These graphs allow you to find additional information that can be helpful as you make decisions that will impact the learning environment for your students This allows you to chart possible motivation others involved the number of referrals by race ethnicity gender and grade level administrative decision number of days of suspension for the school year and the number of days of suspension per student It also allows you to chart office referrals written by staff member which can be useful for identifying staff members with particularly challenging student behaviors or who might benefit from additional strategies Cut al g ma FSS AutoSum F B Cu Calibri u QJ a V Biwrap Text General H 2 4 Normal 2 Normal 3 Bad gm K is draa aY Fy Ba Copy 7 a x 5 Fill Paste tie er Aryl BS S GF i X o lt 0 00 Conditional Format Good Neutra C feiss T Insert Delete Format Sot amp Find amp X F Format Painter B Z U 2 pl J a vir athe a 00 20 ormatti l l EEE h z X X amp 2 Clea Filter Select Clipboard x Font Alignment z Number Py Styles Cells Editing S T U 5 Majors Data Entry Quick Big 5 Behavior 8 Per Month Totals Location pis vO fe E F G H l J K L M N O Triangle Per Day Per Month Majors by Student 19 j 20 21 22 23 Majors Digging Deeper Majors by Motivation Others
7. properties printer path author s name and related dates Check for 8 er Categories Save amp Send tn Content that people with disabilities are unable to read Related Dates Help Last Modified Today 11 42 AM 3 Options R Versions Created 6 1 2011 11 29 AM B a R Today 11 42 AM autosave Last Printed 5 22 2012 11 00 AM it M a heel EN Today 11 31 AM autosave ere Today 10 56 AM autosave Author M Wav Gordon e Click on Print 26 Page Xi DTT as Home Insert Page Layout Formulas Data Review View Developer la Save Print Gl Save As deb B Copies 1 en O kn Print e A Ee Ga Printer i My School 7 HP Deskjet 6940 series Copy 1 Recent g Ready of Per Day Per Month Printer Properties a2 New Settings ot Print en ef EK Print Active Sheets v Only print the active sheets 5 Save amp Send LE ii Pages to ot Help BB Collated oe ne FE ee P eE l H Options EEE Portrait Orientati FF F S SF S F S v ss a Pd F P Exit Portrait Orientation ii id P Pi E Fo fo Letter X Major Behaviors 85 x11 Normal Margins H Left 0 7 Right 0 7 i amp A Ao e Click on the Print button Creating a PDF in Office 2007 and 2010 If you want to create a PDF of a single graph anywhere in the Data Collection Tool simply click on that graph then perform the following steps If you want to create a PDF of all 5 graphs on either of the
8. to chart En Hom Page Layout Formulas Data Review View Developer amp Cut a ue A 7 sas AutoSum T Cu Calibri iu A gt SF wrap Text General k 7 Normal 2 Normal 3 Normal Bad cm CX CW E AutoSum oY A Za Copy a5 8 Ge Br a Conditional Format 43 Son amp Finc amp Formatting as T able 20 Op Fromat Punte BI SD Ae EEE RR Huete Sne AB Good NERA an TERETE et oee rome pbo k ji font pe Angnment Sty Dem Mms hed A B C D Back to Main Menu m Series1 N O N e h hh lO je sislele sia hess 8 sleje vlo u elwin Oo oS o o H N gt Leal oo Ll N gt Rd dd AT Az dd _ NN w N e To navigate away from the Quick Big 5 page scroll to the top and choose one of the three navigation buttons 17 Page Home Insert Page Layout Formulas Data Review View Developer C v B amp Cut Calibri il viA A gt c Wrap Text General Md 5 Normal 2 Normal 3 Nor ns A ee m g 99 Conditional Format Good l aste ners JEEZ Bt Merge amp Center 9 59 Conditional Forma Neutral Cah ze D in 9 es ote Formatting as Table GV Format Painter Clipboard F Font Tu Alignment ra Number Tu Styles Data Collection Tool School Set UP Data Entry Big 5 Charts Minors Majors Set Up Data Entry Quick Big 5 Behavior Minors Quick Big 5 Student Demographics Per Month Totals Location 10 11 12 Per Day Per M
9. Downloads 924 n PESA p Coventry Health Care 4 23 2012 2 02 PM_ File folder ro gt E DESEs The Work 5 14 2012 1 23PM File folder zi Recent Places k d U db El Committee 4 20 2012 12 08 PM File folder S o JJ Emerging 2 Day 8 3 28 2012 4 17 PM _ File folder eg Libraries my B D z p Fee Structure 2012 2013 5 3 2012 10 52AM File folder sl Documeni d n p Mileage Logs 5 11 2012 3 07 PM File folder kn Bh Recognition2012 5 2 2012215PM_ File folder L Pictures a 4 J School Data Profile 5 2 2012 2 52 PM File folder z Videos 5 SET 2012 4 17 2012 10 34 AM File folder J State Meeting May 2012 5 7 2012 3 49 PM File folder jE Computer z J Summer Institute 2012 5 17 2012 4 13PM File folder amp Local Disk C ee M Summer Training 2012 5 11 2012 2 50PM File folder S Workgroups k a a J Travel Expense Records 5 11 20121 59PM _ File folder S2 Campus Networl r 3 SE r hy Big_5_Generator_5 21 2012 5 21 2012 4 27 PM Microsoft Excel M 142 KB Ge wayg kc umkc i er hy Big_5_Generator_11 12Template_082411 5 23 2012 1 37 PM Microsoft Excel M 179 KB Er DataCollectionTool5 22 2012vlookup 5 25 2012 3 52PM Microsoft Excel M 1 027 KB File name DataCollectionTool5 22 2012vlookup v Save as type Par PE Excel Workbook F Excel Macro Enabled Workbook Excel Binary Workbook Excel 97 2003 Workbook S Cl 1 k d XML Data tep 1 Clic own Single File Web Page oo ie arrow on Save as Excel Template mg Excel Macro Enabled Template T P
10. Formulas Data f l ties Calibri yn A a se sa Copy 7 a aste ESE Fy en Format Painter Boal 2 A A Clipboard Font G7 hd ie A B C D 1 A School Name 3 My School A 5 Student Enrollment 6 g 9 10 11 Enrollment by Ethnicity 13 Non Hispanic Latino 14 15 16 Enrollment by Race 17 Asian 18 Native American 19 White 20 African Native Hawaiian 21 Pacific Islander V9 2009 2010 school year The Data Collection Tool uses Federal Race and Ethnicity designations When the Data Collection Tool counts office referrals by race and ethnicity it does not count students who are marked as Hispanic as under the racial categories i e a student marked as African American Black and Hispanic will only be counted as Hispanic when charted by race and ethnicity data entry page 6 Page Enter teacher names These will be added to the drop down menu on the e Enter the number of days that school is in session for students for each month This information is used to chart the number of office referrals per day per month e Save e Click the Back to Main Menu button 7 Page Step 2 Student Demographics The student demographics page acts as a data base that remembers information on student demographics so that when you are entering ODR information on the Data Entry page you do not have to repeatedly enter demographics information for students who are already in the system and who have mul
11. O A a ag D Research Alt Click rie Sn fe Error Checking c fi Shared Workspace EC Share Workbook Protection gt Online Collaboration Formula Auditing gt Macro ZE AutoCorrect Options Customize 1 Click on Tools from your menu bar 2 Click on Options 31 Page C Remove personal information from file properties on save Macro securty Adjust the sacurky level for Mes that might contain macro viruses and specify names of trusted macro developers Go to Security Tab 3 Click on the Security tab 4 Click on Macro Security 32 Page Very High Only macros installed in trusted locations wil be allowed to run All other signed and unsigned macros are disabled CRC anea arros tron rexel erneer degeen ally disabled You can choose whether or not to run potentially unsafe L OS OS OS 6 EOS SSS FSS SEE SSS OES EES EOS OSES OS MSE SS SSS ESET nr FES ESE SSS SSE SS nt Tnet es Low not recommended You are not protected from potentially unsafe macros Use this setting only if you have virus scanning software installed or you have checked the safety of all documents you open rn _cancel_ a Choose Medium security level 5 Click on the button next to Medium 6 Click OK 33 Page E eeShen Zen Xing OCR Project JMC_Excel xds contains macros Macros may contain viruses It is usually safe to disable
12. Quick Big 5 pages major or minor click off the graphs then go through the following steps To create a PDF you may do one of two things e Go to the button Ea 2007 or File 2010 menu Home Insert Page Layout Formulas Data Review View Developer la Save een Information about DataCollectionTool5 22 2012vlookup EE IE C Users wayg Desktop DataCollectionTool5 22 2012vlookup xism amw EF Open j Close nn a Permissions Protect Info ET En One or more sheets in this workbook have been locked to prevent unwanted changes to the data A 1 DataEnt Unprotect Recent Workbook and PIAS Properties New z Size 1 00MB Prepare for Sharing ik ae Print 2 Before sharing this file be aware that it contains ean Ch 5 kf Document properties printer path author s name and related dates Edea eck for Rl R Save amp Send en Content that people with disabilities are unable to read Related Dates zet Last Modified Today 11 42 AM Options Versions Created 6 1 2011 11 29 AM RO F Today 11 42 AM autosave Last Printed 5 22 2012 11 00 AM Fvit e Click on Save As 27 Page Save As X Th gt Computer gt Local Disk C Users wayg Desktop gt j X 5 Search Desktop p mm z o Organize v New folder a ne x INT Inse BE Desktop Name Date modified Type Size 7 Z B
13. The generator will produce 2 graphs The first is a triangle showing your school s data to the right of the National Comparison for your school s grade configuration My School Triangle Graph Over Time October 2012 2013 E 6 Referrals 2 5 Referrals m 0 1 Referrals e The other graph depicts long term trends for up to the last four years 25 Page e f you want to print from this page click anywhere off of the graphs and print as you normally would Only the graphs will print e Save e Click Back to Main Printing To print any single graph in the Data Collection Tool simply click on the graph then follow the steps below If you want to print all five graphs on either the major or minor Quick Big 5 pages click anywhere off of the graphs then follow the steps below e Go to the button 53 2007 or File 2010 menu U ek E E Home Insert Page Layout Formulas Data Review View Developer la Save 5 y Information about DataCollectionTool5 22 2012vlookup al Save As S Je C Users wayg Desktop DataCollectionT ool5 22 2012vlookup xlsm menten Ey Open Gf Close P Permissions Info ay i One or more sheets in this workbook have been locked to prevent unwanted changes to the data a Doeg DataEntry Unprotect Recent Workbook N Properties 7 ew Size 1 00MB E Prepare for Sharing aag Print en Before sharing this file be aware that it contains g Tag e ags Document
14. Using the MO SWPBS Data Collection Tool Office Referrak per Students Proportion of Referrals by Race Ethnicity 70 00 66 67 i 60 00 48 37 50 00 40 00 33 33 5 39 30 00 ihri 24 20 00 24 m Percentage of ODR s Nare Beeri 10 00 3 89 m Percentage of Enrollment og eten Er I PAF De espe E 0 00 Per Day Per Month om NS x Er ar g x NS F z 01 0 047619048 Center for PBS College of Education University of Missouri Missouri Department of Elementary and Secondary Education Contents SNS Sea E e A eeen 3 Usine the Data Collection TOO nme eenen 5 is ok SCO Ba ra sac eeccnetcge cnc E E E E E E mer datiteucet 5 Step 2 student B 0 8 e124 gc 0 C aa eet een nnn ve eee ee eee 8 Step Data BAE mmniet E doden serene 10 Step Be SCHANS eeens 13 step 5 Majors Digging Deeper sacscicccscsszsitixccinccsatvactescosicuneseeeassudesiceveateascindyeicuessbounavndaddassendeeccvednaiceeniens 21 Ste O NIDO aataciuiracdecastvedignernclssuvis sociecgtccnetne AE 21 Step 7 Triangle GA hinne nenten savencecectsceecasutsssesscitanesneueasaisaneorsasuiaecectaieciussnseees 22 PENNO ennen benedenstad 26 Creating a PDF in Office 2007 and 2010 unansensennennennenennennennennenneenennensenennennenneeneen 2 TOUNEN OOUNE SUWAS inenen A 31 You are not prompted to enable content or the buttons do not work enaar raereensenn 31 To Change The Security Level nnansensennennennerne
15. Workbook must be saved in a shared location Create PDE XPS Document Attach a PDF copy of this workbook to an e mail ea Document looks the same on most computers Help EE Preserves fonts formatting and images l poe Content cannot be easily changed Options 5 EJ Exit _ Attach a APS copy of this workbook to an e mail xps Document looks the same on most computers Preserves fonts formatting and images Send as XPS Content cannot be easily changed e Click on Save and Send xa ye i File Home Insert Fage Layout Formulas Data Review View Developer ln Save eee Save amp Send Send Using E mail Save As E Attach a Er Open ir gt Eve E a Chi Close a Save to Web send as Attachment Info h E e Ewe New File Types En Send a Link Kee Print FAN change File Type A Wo E g Create PDF XPS Document Attach a Doe Heln Den e Click Create PDF e You will be asked a second time to click Create PDF 29 Page Insert Page La Z Publish as PDF or XPS Organize New folder Je Dropbox El Recent Places Libraries E Documents a Music Pictures E Videos jE Computer g Local Disk C E Workgroups k Ce Carnie Nehanrl ppe out Formulas Data Name Coventry Health Care DESEs The Work EL Committee Emerging 2 Day amp Fee Structure 2012 2013 Mileage Logs Recognition2012 School Data Profile SET 2012 State Meeting May 2012 D Summer Institute 2012
16. Y r Excel 97 2003 Template yp m 25 Text Tab delimited e enu 26 Unicode Text 77 Gia XML Spreadsheet 2003 Microsoft Excel 5 0 95 Workbook 28 CSV Comma delimited 29 Formatted Text Space delimited 2 Tos Macintosh Step 2 Click PDF Text MS DOS 31 _ CSN Macintosh 32 3 CSV MS DOS 33 DIF Data Interchange Format 2 5 f _ SYLK Symbolic Link 34 gt Excel Add In 35 _ Excel 97 2003 Add In 15 Y 20 XPS Document 37 1 Y OpenDocument Spreadsheet 7 ota 38 0 5 PA PA 39 fo y anll e r e Name the document and designate the folder you want to save it to e In Save as Type click the down arrow and indicate that you want to save itas a PDF Or e Go to the button Ea 2007 or File 2010 menu 28 Page Fil led y i mij ts JataCollection Tool5 22 2012vlookup ylicrosoft Excel File Home Insert Page Layout Formulas Data Review View Developer lal Save y a Save amp Send Send Using E mail Save As d Attach a copy of this workbook to an e mail E Open E u E A REN thi _ Everyone receives separate copies of this workbook Close Changes and feedback need to be incorporated manually Q Save to Web Send as Attachment Infa mms Recent fa eee Create an e mail that contains a link to this workbook a Everyone works on the same copy of this workbook New File Types Everyone always sees the latest changes Send a Link Keeps the e mail size small Print AN Change File Type A
17. al 2 Normal 3 Normal Bad 4a Copy i y A Paste T E eE Ee E E E z POE center 9 8 99 Conditional Format Neutral Calculation Check Cell J Format Painter me a ee s os Formatting v as Table mmm Pi u Number Styles Mac c9 v fe School Set UP Data Entry Big 5 Charts Minors Triangle Generators Majors set Up Quick Big 5 Behavior Minors Quick Big 5 Triangle Generator Student Demographics Per Month Totals Location Minors by Behavior Per Day Per Month Majors by Student Minors by Location Minors By Motivation Minors by Student Majors Digging Deeper Majors by Motivation Others Involved Referral by Gender Majors by Grade Race and Ethnicity Majors by Staff Administrative Decision Days of Suspension Student e Thefirst time the Data Collection Tool is opened macros must be enabled Usually this option is in a bar just below the Excel toolbar ribbon It will typically read Security Warning Macros have been disabled Enable Content 3 Page e In Office 2007 or 2010 click on the box marked Enable Content Once this has been done the buttons can be used to navigate around the Data Collection Tool Sec urity Warning Ed E eeShen Zen XinglOCR Project JMC_Excel ds contains macros Macros may contain viruses It is usually safe to disable macros but F the macros are legitimate you might lose some functionality e f you are using Office 1997 2003 you may or may not rec
18. ale hispanic Latino 5 A OE E 6 po S nn Use the drop down boxes 7 acon An e Native Hawaiian Pacific to enter demographic 8 E EE EE Se Ceca COSrap 9 a a ee ee information 10 ae Se ee E 11 A ee ee S e Assign a student number for each student or enter the number assigned to the student by the district and enter it in the first column e The Data Collection Tool will not allow you to enter the same number twice e Enter the student s last name then first name e Choose the demographic information that best fits the student from the drop down menu in each cell e Save e Click either Back to Main or Data Entry 9 Page Step 3 Data Entry The data entry page is where individual ODR s are entered into the system This becomes the data base which then generates the various graphs Home Insert Page Layout Formulas Data Review View Developer a Cut po 2 2 Calibri l TIA A Per p Wrap Text General 7 Normal 2 Ea Copy Paste _ B 7 U ii Z Ht Merge amp Center gt GU 392 Conditional Format Good lt F Format Painter a iF B Formatting gt as Table 7 Clipboard F Font Ta Alignment Fa Number Ta 1 2 Data Collection Tool 4 School Set UP Data Entry Big 5 Charts 3 Majors 3 Student Demographics Per Month Totals Location Per Day Per Month Majors by Student e Click on the Data Entry butto
19. ave used the Data Entry page to collect minor behavior incidents Step 7 Triangle Graph The Triangle Graph charts the percentage of students with 0 1 Office Referrals ODR s 2 5 ODR s and the 6 or more ODR s This graph is cumulative for the year so the comparison to the SWIS National Averages are only valid once the school year has ended However the process of identifying students with 2 5 ODR s and 6 or more ODR s can aid in the early identification of students who might benefit from Tier Il and Tier IIl interventions Therefore this graph should be updated monthly The final graph of the year allows you to monitor annual outcomes for students and to progress monitory your SW PBS systems for your school 22 Page KIT STE kk ataCollection Tool5 22 2012vlooku lele Home Insert Page Layout Formulas Data Review View Developer a o E gt a Calibri u A A 2 oe Wrap Text General E 5 Normal 2 Bad s m E ia asl Ay See Ff Format Painter B Z Ur Ay S EE Merge Center SO 50 ae oma Good Neutral Calculation Msert Delete Format Baert Sata mida Clipboard u Font A Alignment z Number Styles Cells Editing Dis M f v j E J K L M N O Q R i U V W X Y E 4 Big 5 Charts Minors Triangle Generators 5 Majors Quick Big 5 Behavior Minors Quick Big 5 Triangle Generator 8 SE Month Totals Location Minors by Behavior 10 11 12
20. bri vu z Der E Wrap Text General Md E B 7 Normal 2 Normal 3 N a Copy Paste prin pointer B Z Wr Biv HA FEE EEE Mergea Center S 8 58 Conditional Format Good Neutral CG Clipboard Tu Font Tu Alignment Tu Number Ta Styles D38 6 fe Pi A B c l l F G H 19 I En OE 21 0 5 2 ik 23 0 24 25 26 27 28 z 30 31 32 JJ 34 _35 Look up Student names by entering student number in cell below 36 Student Number First Name Last Name 3s 38 Ooo N A N A 39 i e In order to identify the name of a student that is graphed by number enter the number in the box labeled Student Number Home Insert Page Layout Formulas Data Review View Developer amp Cut a e Calibri 711 v IA AIS Yor g Wrap Text General Md Normal 2 Normal 3 Normal Ba Copy Paste _ ihe v sn ENT 0 00 Conditional Format Good Neutral Calculation GP Format Painter u rae 2 en pen a ii Merge amp Center ak vre Formatting v as Table v Styles Clipboard E Font Ta Alignment a Number a A B G H I 19 4 a 21 4 MM 23 24 z i 5 25 2 6 N to 27 28 z 30 31 32 e 34 J 35 Look up Student names by entering student number in cell below 36 37 Student Number First Name Last Name 38 nen oe 39 40 a 42 e The Data Collection Tool will look up the name of the student who has that student
21. d Merge amp Cente 5 v 9 io zo Conditional ormat Gooc GP Format Painter an aii a n Formatting as Table Clipboard a Font Alignment Number A3 fe 111111 B E D E Directions The first time you enter data on a student you must complete the student 1 demographics record After that you will enter the student number tab over then complet the ODR record 15 Se ST RE a e e S e e e This will automatically fill in the demographic data that you entered for that student on the demographics page If no data appears you will need to enter this student on the demographics page e The cells for student name grade gender ethnicity and race are protected You will not be able to type directly in these cells If the student number does not call up the desired student s demographic data check the 11 Page number If the number is correct make certain that you have entered the student into the student demographics page ACRA BT File Home Insert Page Layout Formulas Data Review View Developer rp Cut A de Cu Calibri 11 A DataCollectionTool5 22 2012vlookup Microsoft Excel ll ll 5a Copy 7 l BZU Format Painter a Paste mM Mm Ilil Clipboard Font Alignment Number Styles H5 fe F c MEME J K L M N o A B c D E Directions The first time you enter data on a student you must complete the student demographics record After that you will ent
22. e Popular category under Top options for working with Excel click Show Developer tab in the Ribbon 35 Page sted Locations Step 3 Click disable all macros with notification Disable all macros without notification sted Documents Disable all macros with notification Disable all macros except digitally signed macros Enable all macros not recommended potentially dangerous code can run Developer Macro Settings T Trust access to the VBA project object model Protected View Message Bar External Content File Block Settings Privacy Options e Inthe Macro Settings category under Macro Settings click Disable all macros with notification e The Microsoft office button was replaced by the File tab in office 2010 The information on changing security settings in Office 2007 and 2010 came from http office microsoft com en us excel help change macro security settings in excel HP010096919 aspx School name does not appear on graphs page From the Main Menu click the School Set Up button Enter the school name in the designated space 36 Page You click in a cell and receive an error message or another blank cell is selected Several pages of The data collection Tool have been protected to prevent users from inadvertently deleting a formula that generates the graph For example you will not be able to e
23. eive a message stating that Macros may contain viruses It is usually safe to disable macros but if the macros are legitimate you might lose some functionality If this message pops up you will want to click Enable Macros e Important If you still have trouble using the navigation buttons see the troubleshooting guide at the end of this document to change the security settings in excel 4 Page Using the Data Collection Tool The Data Collection Tool can be used to collect aggregate and summarize office referral data to aid in problem solving A variety of information is collected from individual disciplinary incidents The Data Collection Tool pools the data provides aggregate graphs as well as graphs disaggregated to provide useful information for schools to use as they make decisions that will impact student behaviors and school climate Step 1 School Set Up The first step in using the Data Collection Tool is to complete the School Set Up page The information on this page is critical for the graphs to function properly kd Dr ataCollectionTool5 22 2012vlookup Home Insert Page Layout Formulas Data Review View Developer Cut m a 7 e 7 Calibri 111 vi ag Yar Sy Wrap Text General v K Normal 2 23 Copy nn ee am Paste B Z Url i r D A EES tE kad Merge amp Center X 9 lt 00 Conditional Format Good F Format Painter Formatting 7 as Table 7 Clipboard a Font a A
24. ent s demographic Doe Jane Wh it record wall fill in If this does tt student if d 4 5 Vom OE John _1 male Hispanic Latino Whit 6 111111 Doe John 1imale Hispanic Latino Whit 7 222222 Doe Jane Hispanic Latino Whit 8 e To navigate away from this page choose one of the navigations buttons in the upper left hand corner Step 4 Big 5 Charts The Big 5 Charts answer the questions how often per day per month what problem behavior where location when time and who majors by student of problem behavior This allows you to develop schoolwide interventions that target the situation in your school This section of the menu page allows you to navigate to a Quick Big 5 page which has all 5 of the Big 5 graphs for quick reference You can also navigate to individual Big 5 graphs as well as a graph that charts the absolute number of referrals for each given month per month totals 13 Page Page Layout Formulas Data Review View Developer Calibri l ay EZE Pr Wrap Text General E7 Normal 4 Copy QF Format Painter Oo EE NO i au gt Formatting as Table Clipboard Tu Fant Ta Alignment Ta Number Tm Data Collection Tool School Set UP Data Entry Big 5 Charts Majors A 2 J Data Entry Quick Big 5 Behavior 7 8 3 Student Demographics Per Month Totals Location Per Day Per Month Majors by Student Time 16 C 5S 5
25. ep 1 Choose the closest grade Grades K 6 configuration for your school from drop down Step 2 Using the Major Month Behaviors by Students graph to the right enter Major Behaviors by Students the number of students ne with 2 5 and 6 ODR s 3 a My School Grades K 6 Triangle Graph 2012 2013 Step 3 Click off of the graphs then print m 6 Referrals 2 5 Referrals m 0 1 Referrals Grades K 6 2012 2013 blank 222222 111111 My School Triangle Graph Over Time 2012 2013 11 25 AM 5 29 2012 gt Ir hag CD e In step 2 enter the year to date number of students who have 2 5 ODR s and 6 or more ODR s These numbers can be found on the Major Behaviors by Students graph that was included for this purpose make certain that if you changed the graph to look at a specific month that you use the Month filter button on the upper left hand corner of the graph to change the graph back to show All months e f you have data from past year s you may enter these numbers as well to give you a graph showing long term trends This data is charted in the Triangle Graph Over Time 2012 2013 graph see below 24 Page My School Grades K 6 Triangle Graph October 2012 2013 E 6 Referrals 2 5 Referrals m 0 1 Referrals Grades K 6 2012 2013 My School National Comparison Grades k A e
26. er the student number tab over then complete 1 the ODR record 111111 Doe john Ijmale Hispanic Latinfwhite Haris WilliamT 222222 Doe_ ane 3 Female Hispanic latinjWhite Dewey John _ a 6 7 8 11 12 13 14 15 e Once you have called up demographic information by tabbing over complete the information for the specific office referral Notice that some of the cells utilize drop down menus Also notice that the staff names that were entered on the school set up page appear in the drop down menu for Referring Staff Member e Either the number of Major Offenses or number of Minor Offenses is the dependent variable for most of the charts If you do not enter either a major offense or minor offense the entry will not show up in any of the charts Make sure you enter one or the other and choose the category of behavior that best describes what happened e Important If you enter a Major Offense do not enter a Minor Offense for the same referral You will only enter one offense major or minor per office referral A rule of thumb is to record the behavior that triggered the decision rule for recording the behavior e Click Save before navigating away from this page 2 12 Page A3 Jf 111111 PA B C D E Back to Main Menu Student Demographics Directions The demographics r 1 the ODR record Hispanic Latino 3 Female Hispanic Latino 0 Enter Student Number Stud
27. er v Count of Maj v 108 0 109 g S z 110 5 A TEI LJ e Y E Defer Layout Update 4 ull gt Ready 2 Ea 140 gt v a z f 10 15AM a EE me 0 5 29 2012 e f you click on any graph A pivot table field list will appear e Making changes on the pivot table field list will change what the graph charts so it would be best not to use it unless you are comfortable using pivot tables in Excel e Also notice that most of the graphs will chart Blank This will show you any instances where the independent variable has not been entered on the data entry page In the above example it would chart any office referral that did not have a student number entered e When any one of the graphs is chosen printing will only print that particular graph and not all of the graphs on the page e To print all of the graphs on the page simply click in the empty space between the pivot table field list and the graphs When the pivot table field list disappears you may print as you normally would print from excel 16 Page lt lt lt ae 87 E 88 5 F 5 A en 89 rs co ed 90 91 Month Ce BS 102 7 nn 104 nn 106 n lt e In Excel 2010 you can change the specific month that you want to graph To look at a specific month click on the down arrow on the Month filter button located in the upper left hand corner of the chart Click on the month you want
28. lignment x Number D18 vO fe 2 Data Collection Tool Data Entry Big 5 Charts Majors 2 Student Demographics 10 11 Per Day Per Month Majors by Student 13 14 15 Time 16 17 as C 19 20 21 e Togo to the School Set Up page click on the School Set Up button Per Month Totals Location 5 Page DataCollectionTool5 22 2012vlookup Microsoft Ex View Developer Por General F ey Normal 2 f iT Ha Merge amp Center G y a lt 0 00 Conditional Format Good i f Formatting as Table Alignment _ Number l J K L M Back to Main Menu Days in Staff Staff Member session Number Last Name First Name Manth Menn Horae August 2 Montessori Maria September 3 Dewey John October AlHarris William T November 5 December OO p e A w h gn sj U B anl Enter school name this will cause your school s name to appear on the graphs in the example the school is named My School Enter School September enrollment information for the current school year It is optional to enter enrollment for years going back to the Enter the number of students enrolled by race and ethnicity This is needed for the graphs that chart discipline data by race and ethnicity and can help you to to spot possible problems of disproportionality in discipline referrals a led Or rid a Neg a Home Insert Page Layout
29. n 10 Page ataCollectionTool5 22 2012vlookup Home Insert Page Layout Formulas Data Review View Developer Cut en oo _ B amp Calibri vi A A gt Wrap Text senera X Fa A Normal 2 Normal 3 es 4a Copy D OC a en F m t j aste B Z U 27 A SE E faq Merge amp Center v 9 io zo Conditiona orma Gooc GP Format Painter aad ee x Formatting as Table Clipboard a Font Alignment Number Style A3 x f Eni a i B G H l J K L M E D E Back to Main Menu Student Demographics Directions The first time you enter data on a student you must complete the student 1 demographics record After that you will enter the student number tab over then complete the ODR record Enter Student Number Student s demographic record willfillin fthisdoes _ S S S S S d S S not happen gotostudent _ J o To To J y SS SS NS a a demographics and ee es es O CE AS hr completetheinformation SS a A e ce for the next avaliable line eS eS S Oooo S e e Each row represents the record for one office referral e Enter the student number in the student number column and tab over x W I a ataCollectionTool5 22 2012vlookup Home Insert Page Layout Formulas Data Review View Developer Cut a r B amp Cu Calibri vil yA A Wrap Text zenera X FS A Normal 2 Nor a ia Copy 7 en si 9 00 C Van ame j aste B iu A A 2 2 45 2E ka
30. nnenneneenennenneeneeneeneenensententeneeneeneensnnsntsnenntentenenn 31 School name does not appear on graphs page nnunsansensersennennenennennennenneeneenvenennsnannennennenneeneen 36 You click in a cell and receive an error message or another blank cell is selected sauss 37 Data on Graph appears to be different from what was entered on Data Entry page 37 Error Message Converter Failed to Save File unu nsannsensensenensensensennsensensennennennensennennornsensenn 37 OEM A EE E EAE A E N E A E A A A AE T EEA 37 2 Page Getting Started Rationale The Data Collection Tool was designed to summarize office discipline referral ODR data in a variety of ways Quick Big 5 graphs answer the questions who what when where and why of problem behavior so that schools can design interventions that address problem areas It also collects and summarizes additional data that can be used to help schools to identify other potential areas for improvement For example the data collection system graphs by grade level making it possible to determine if an intervention should target a particular grade level Main Menu The Main Menu allows for easy navigation of the Data Collection Tool To enable macros click here Fall D gt ede File Home Insert Page Layout Formulas Data Review View Developer amp Cut J Calibri vi y A A Md General E T gt Norm
31. nter demographics information directly onto the Data Entry page You will only be allowed to enter this information on the Student Demographics page however you will only need to do this one time per pupil Data on Graph appears to be different from what was entered on Data Entry page Check to make sure that you have selected All on the Month filter see Step 4 above Error Message Converter Failed to Save File Finally there is one other possibility for those of you who are having trouble converting this file to earlier versions of Excel Apparently there was a problem with one of the Microsoft converter service packs The converter at the following link is supposed to solve the problem This has worked Some districts will only allow individuals with administrator rights to load files or do updates The link is http www microsoft com download en details aspx displaylang en amp id 1285 Other If you encounter a problem that is not addressed in this User s Manual you may contact your SW PBS consultant or call Gordon Way at 816 235 5656 37 Page
32. onth Majors by Student Minors by Location 13 14 16 e To navigate to individual Big 5 charts simply select the button of the chart that you want to see We will look at the Majors by Student chart to show a special feature of the graphs that chart with individual students as the independent variable WD ONU A w N Minors by Behavic 18 Page a gt l Ba copy Paste Format Painter Clipboard Tu Font B Z Ur Er ssl ESE G Merge amp Center 9 g 593 Conditional Format Good Formatting 7 as Table ao dn D38 fe A B 1 Month All A 2 3 RowLabels Count of Major Offense 4 blank 5 222222 2 6 111111 3 7 Grand Total 5 8 z 10 11 12 13 14 15 16 ag 18 19 20 21 22 23 24 25 26 27 28 29 30 al 32 JJ Month v Major Behaviors by Students i i T T blank 222222 111111 Back to Main Menu Student Demographics Data Entry Look up Student names by entering student number in cell below Student Number First Name Last Name ___ NA NA Uit e This graph charts students by their student number This is in part to make a neater easier to read graph It also allows you to share the graphs and still meet FERPA confidentiality requirements 19 Page Home Insert Page Layout Formulas Data Review View Developer amp Cut Cali
33. tiple ODR s This also helps to establish consistency in the demographic data i e misspelling a student s name a oF oe l ollectionTool5 22 2012vlooku Home Insert Page Layout Formulas Data Review View Developer a amp cut Calibri ri TAA Xor c Wrap Text General hd El 5 Normal 2 B Copy a Paste A conmat Pointer PLUIE DA BE RE FR ime Center 3828 Conditional Format GE Clipboard P Font F Alignment P Number D18 vO fe 1 2 Data Collection Tool a School Set UP Data Entry Big 5 Charts 5 Majors Data Entry Quick Big 5 Behavior Student Demographics Per Month Totals Location 11 PerDay Permonth Majors bystudent Per Day Per Month Majors by Student 13 14 16 17 19 20 21 e This will take you to the student demographics page 8 Page x WI gt en os DataCollectionTool5 22 2012vlookup Microsoft Home Insert Page Layout Formulas Data Review View Developer Cut Di 7 B d Cu Calibri ln TIA a Bae Wrap Text General F ey Normal 2 Sa Copy 7 mar Paste _ B Utr amp Ar B 1E tE fal Merge amp Center 9 9 398 Conditional Format Good gt Format Painter ii 2 2 re A gt Formatting as Table Clipboard Tu Font z Alignment z Number Back to Main Menu Back to Data Entry 1 Student Demographics 2 3 liiiijboe john tmale Hispanic Latino White 22222a d0e jane a Fem
Download Pdf Manuals
Related Search