Big 5 Generator Directions
Contents
1. My School Cumulative ODR s by Time of Day My School October ODR by Time of Day for Month F z m October TTTTTTTTT T TT TTTTTOTTTTTTTTTTTTTTTTTTTTTTA e Graphs will appear to the right The top graph will graph the A graphs e cumulative number of ODR s per time of day for the year to date e The bottom graph will chart ODR s for the specific month designated on the school set up page e ifthe bottom graph does not chart the desired month change the name of the month from the school set up page e Save e Click Back to Main KA N U Pp Hw A Ss O 16 Page Step 6 Triangle Graph The triangle graph charts the percentage of students with 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 help you to catch students who qualify for Tier Il and Tier Ill interventions early 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 Big_5_Generator_5 21 2012 Home Insert Page Layout Formulas Data Review View Developer Verdana 2 IA A r F Format Painter PRE L Clipboard a Font Alignm2. ick to Main Based on 2010 2011 SWIS Statistics SCHOOL 0 Entering your total number of students in the yellow box will allow you to generate a PER DAY PER MONTH MEDIAN lt 50th percentile gt for MAJOR Office Discipline Referrals Your student population divided by 100 Median for Elementary Schools is 21 referrals per 100 students 9 E JE 24 Page 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 Big 5 Generator 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 3 3 av Spelling F IM Z 5 a CB UB 422 Research Alt Click Wr De d Error Checking C Shared Workspace j G Share Workbook Protection u Online Collaboration e Formula Auditing gt Macro gt T AutoCorrect Options Customize 1 Click on Tools from your menu bar 2 Click on Options 25 Page
3. 2010 menu XI ad T E ala File Home Insert Page Layout Formulas Data Review View Developer la Save A Save As EF Open Cd Close Information about Big 5 Generator 5 21 2012 C Users wayg Desktop Big_5_Generator_5 21 2012 xlsm Permissions ET 92 One or more sheets in this workbook have been locked to prevent unwanted changes to the data Protect 2 Recent Workbook nm Unprotect n rp c School Set Up Unprotect New Per Day Unprotect Properties 7 Behavior Unprotect Size Print Location Unprotect Title Time Unprotect Tags Save amp Send perday Generator Unprotect Print Monthly Unprotect Related Dates Help Print Cumulative Unprotect Categories Last Modified Today 1 00 PM 3 Options Created 10 16 2008 9 36 AM Last Printed Today 1 12 PM Exit Prepare for Sharing ZE Before sharing this file be aware that it contains E Bu RE i Related People Jo ment propen prin path autho name and e Click on Save and Send STT File Home Insert Page Layout Formulas Data Review la Save GAl Save As EF Open CH Close Save amp Send Send as Attachmel Info c Recent New File Types Al Change File Type Create PDF XPS Document Send as PDF e Click Create PDF e You will be asked a second time to click Create PDF 23 Page X Publish as PDF or XP CLA gt Computer gt Local Disk C Users gt wayg gt Desktop Y o l p mm DR J5 dert Dcp Organ
4. 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 Users Manual you may contact your SW PBS consultant or call Gordon Way at 816 235 5656 31 Page Appendix A Big 5 Tally Sheets Per Day Data 2012 2013 Days School Major Referrals for Per Day Rate was in Session Month Divide second column by first column Total Students Total Students with Total Students Total with 0 1 Office 2 5 Office with 6 Office School Disciplinary Disciplinary Disciplinary Enrollment Referrals Referrals Referrals 32 Page May June Behavior Data o IIIIIIIIIII zIWIIIAIUUII III9I IS TTT LAL ETE eM TT es TTL TEL ELT EL a II IIIIIIIIIIIIIIIIIIII TTL ELE TTT EE mad iii M rl LL x Dit D E gt E SZ Sas I 46 0 c lt B o 161 O 2 AS 5 2l o a SB a as Sal S gS BIS a2 i ol oa al 5 gt vj al gal o Go G 8 9 S O CI Gl o Cc al GU an YC a G o S GI GI O Ql G
5. kc umkc File name Big 5 Generator 5 21 2012 Excel Workbook Excel Macro Enabled Workbook Excel Binary Workbook Excel 97 2003 Workbook XML Data Single File Web Page Web Page Excel Template Excel Macro Enabled Template Excel 97 2003 Template Text Tab delimited Unicode Text XML Spreadsheet 2003 Microsoft Excel 5 0 95 Workbook CSV Comma delimited Formatted Text Space delimited Text Macintosh Text MS DOS CSV Macintosh CSV MS DOS DIF Data Interchange Fg SYLK SymboligLi Excel Add In Excel 97 200 PDF XPS Document OpenDocument Spreadsheet 30 Inappro Lang Aggress ion Fight 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 5 11 2012 2 50 PM 5 11 2012 1 59 PM 5 21 2012 4 27 PM 7 12 2011 11 06 AM Type File folder File folder File folder File folder File folder File folder File folder File folder File folder File folder File folder File folder File folder Microsoft Excel M Shortcut Step 1 Click down arrow on Save as Type menu Step 2 Click PDF e Name the document and designate the folder in which you want to save it e In Save as Type click the down arrow and indicate that you want to save itas a PDF 22 Page OR e Go to the button Ba 2007 or File
6. Attendance Referrals for that Month Referrals Referrals for that Month Major 0 58333 10 e 22 30 1 3636 22 28 1 2727 e e Oe f a D 5 October s aa eve E O ass el Lad aa ETR EEEEEFEEEERE a B December x i5 30 Wo _ 15 R Januar 0 Februar 15 26 1 8667 15 26 173333 f 2 s 16667 2153 a D 21 31 4 47639 of eov 1 5833 24 36 1 5 24 34 141667 pIw o SL as tal 25 a3 ao ZS ai 14 pT TV O 26 50 1 9231 26 48 1 8462 26 46 1 76923 C DIV 0 sas as as asp au as a es x apwo x 5 ds 32 5 da 28 5 az 24 d Div0 _ To Jeomo o Is _ UTC evo Tomo Enter the number of days that school was in session for students for each month under the column marked Days of Student Attendance Enter the number of major office discipline referrals ODR s for each month in the column marked Major referrals for that month If you have data for multiple years you can track changes over time by completing the table for those years My School Major Referrals Per Day Per Month Over Time 2009 2010 i 2010 2011 2011 2012 E 2012 2013 September November December e The graph for multiple years over time will appear to the right of this table 9 Page school year My School Monthly Per Day Rate to Date E 2012 2013 A gt AO AA e Graph for the current school year to date will appear underneath
7. Triangle Graph Over Time October 2012 2013 E 6 Referrals 2 5 Referrals E 0 1 Referrals e The other graph depicts long term trends for up to the last four years 19 Page e Graphs on this page can be selected copied and pasted into other office documents to share with stakeholders e lf 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 Step 7 Printing Graphs and Saving as PDF All 5 of the Big 5 Graphs are now on the printing pages There is a page that shows cumulative data for the year as well as multi year data for the Per Day Per Month and Triangle Graphs There is also a page that allows you to print your Big 5 graphs for any given month provided you selected that month on the school set up page and you have entered complete data for that month Big_5_Generator_5 21 2012 Insert Page Layout Formulas Verdana 22 F Format Painter E Font B3 EM SWPBS SWPBS Set Up Data Entry Triangle Graphs Generator School Set Up Per Day Data Entry Triangle Graphs Monthly Per Day Generator Location Data Entry Time Data Entry e From the Main Menu choose the graphs you wish to print Monthly or Cumulative This will take you to the desired print page 20 Page E tome Insert Page Layout Formulas Data Review View Developer t gt r X E SEE il 723 Ruler Form
8. current month only e Ifthe bottom graph does not chart the desired month choose the desired month from the drop down menu on the school set up page e Save e Click Back to Main 14 Page Step 5 Time of Day This graph allows you to chart when students are behaving inappropriately ET gt Oy E File Home Insert Page Layout Formulas Data s C o B E S Verdana 7122 AA 43 Copy v Paste B Z U yr A Review View Developer n i of 3 ie s0 00 onditional Form N Fo yrmatting as Tab F Format Painter Clipboard B3 fe SWPBS Font Alignment Number SWPBS Set Up Data Entry Triangle Graphs Generator School Set Up Per Day Data Entry Triangle Graphs Monthly Per Day Generator Location Data Time Data Entry e From the Main Menu click the Time Data Entry button Page Layout Formulas Data Review View Developer Verdana 10 AA Pa Wrap Text Ho Z U ae c EE Fad Merge amp Center lt gt lt J Format Painter Alignment Clipboard Number e Onthe Time Data Entry page type in the number of office referrals by time of day for the given month to the nearest 15 minutes 15 Page Big_5_Generator_5 21 2012 Microsoft Exc Home Insert Page Layout Formulas Data Review View Developer Cut x Verdana Copy 7 a mM III Insert Delete ff F Format Painter Clipboard a Ali Number tes Cells D43 v
9. J Remove personal information from fle properties on save Macro seca EY Adjust the sacurky level for Hez that might cortar macro viruses and specify names of trusted macro developers Go to Security Tab 3 Click on the Security tab 4 Click on Macro Security 26 Page Very High Only macros installed in trusted locations wil be allowed to run All other signed and unsigned macros are disabled CRC do pese peritos Lorem oS hp ent ally disabled You can choose whether or not to run potentially unsafe A oca aosssan KL EOS SSS ESE SEE SSS OES EES EOS OSE SOS MSE SS SSS ESET EHTS FES ESE SESS SSE e L LT 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 Choose Medium security level 5 Click on the button next to Medium 6 Click OK 27 Page E DeeShen Zen XinglOCR Project MC Excel contains macros Macros may contain viruses It is usually safe to disable macros but the macros are legitimate you might lose some functionality Enable Macros By selecting Medium you will receive a warning every time you try to open a file with macros For the Big 5 Generator you will need to enable the Macros For other programs enable macros only if you trust the source 28 Page For Office 2007 and 2010 You can ch
10. Macro Settings IS 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 From the Main Menu click the School Set Up button Enter the school name in the designated space 30 Page Wrong month appears on the graph title and data for the wrong month is charted From the Main Menu click the School Set Up button Choose the desired month from the drop down menu for Month This will cause the graphs to reflect data from the desired month You click in a cell and receive an error message or another blank cell is selected The Big 5 Generator has been protected to prevent users from inadvertently deleting a formula that generates the graph You may only click on or enter data into yellow cells You cannot select copy or paste a graph from the Print pages The Print pages cumulative and monthly are protected to make printing easier You may select copy and paste graphs on the data entry pages Error Message
11. Using the Big 5 Generator Center for PBS College of Education Missouri Department of University of Missouri Elementary and Secondary Education Contents EIZ EST SANA u u Re ee eee eee ee 3 Using the BIB 5 Generator T 5 Ste pis cool 0 Las ns us s s s 5 Step Per Di Po Nr im u uuu ETA usa 7 Step o UAL ari ias E E AEE E E S EEE E T EA E 10 Step A Ree ele aa ee ee eee ee ee ee eee ee 13 Step o Ti ONDAS uuu uuu ree ee eee ne eee ener 15 Ste DO lg eto i 0 keener ee E ne eer eer ee eee 17 Step 7 Printing Graphs and Saving as DDE sss 20 6 OR ER E E 5 55 23 Fer DV GENET T O uuu fr opa as 24 Tirol S NOOIT aasi E EE EE EE 25 You are not prompted to enable content or the buttons do not woIrk 25 OTIC HT SS aeceasuetennee nitdeeateeeteees 25 or O lli e 2007 AN 2 0 Os pac 2 E E E E 29 School name does not appear ON graphs essen 30 Wrong month appears on the graph title and data for the wrong month is charted 31 You click in a cell and receive an error message or another blank cell is selected 31 Error Message Converter Failed to Save FG sese 31 OLEOS I OP REDE ENCERRAR PRIDE RPE O EE O RO s E 31 2 Page Getting Started Rationale The Big 5 Generator was developed to assist schools in organizing Office Discipline Referral ODR data making it easier to track progress identify challenges and develop school wide interventions to address these challenges Main M
12. _5 21 2012 C Users wayg Desktop Big_5_Generator_5 21 2012 xlsm EF Open 4 Close Permissions ey Protect Workbook v Main J School Set Up Recent New Per Day Behavior Print Location Time Save amp Send Print Monthly Help 73 Options Exit e Clickon Save As Computer Local Disk C gt Users wayg gt Desktop perday Generator Print Cumulative Prepare for Sharing Before sharing this file be aware that it contains Organize v New folder Developer a One or more sheets in this workbook have been locked to prevent unwanted changes to the data Unprotect Unprotect Unprotect Unprotect Size Unprotect Title Unprotect Tags Unprotect Unprotect Unprotect Properties v Categories Related Dates Last Modified Created Last Printed Related People Today 1 00 PM 10 16 2008 9 36 AM Today 1 12 PM BI Desktop e Jg Downloads k Dropbox a Recent Places Name p Coventry Health Care J DESEs The Work p Ei Committee h Emerging 2 Day 8 J Fee Structure 2012 2013 dk Mileage Logs J Recognition2012 School Data Profile L SET 2012 State Meeting May 2012 Summer Institute 2012 Summer Training 2012 B Travel Expense Records E Big_5_Generator_5 21 2012 A Documents Shortcut a Libraries Documents Music Pictures EE Videos JE Computer amp Local Disk C G2 Workgroups Mk S Campus Networl G wayg
13. ange 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 x il id Lo x Big_5_Generator_5 21 Home Insert Page Layout Formulas Data Review View Developer EJ Record Macro oe Properties ce Map Properties 78 Import al E o Fa FZ Expansion Packs Ta Export sJ Use Relative References Gel View Code EE i Visual Macros Add Ins COM Insert Design Source Document Basic AY Macro Security Add Ins Mode lt Run Dialog ba Refresh Data Panel Code Add Ins Controls XML Modity SWPBS SWPBS Click here to Data Entry Triangle Graphs Generator enable change security level Behavior Data Entry e On the Developer tab click Macro Security o If the Developer tab is not displayed click the Microsoft Office Button Ea click Excel Options and then in the Popular category under Top options for working with Excel click Show Developer tab in the Ribbon 29 Page Trusted Publishers Macro Settings sted Locations U U L IC k d IS ab l C O Disable all macros without notification all macros with sted Documents Disable all macros with notification no ti f C ati on d Disable all macros except digitally signed macros O Enable all macros not recommended potentially dangerous code can run tiveX Settings Developer
14. ent Number B3 fe SWPBS SWPBS Set Up Data Ent Triangle Graphs Generator School Set Up Per Day Data Entry Triangle Graphs Monthly Per Day Generator Location Data Entry Time Data Entry e From the Main Menu click on the Triangle Graphs button 17 Page Step 1 Choose the Choose Grade closest grade Configuration configuration l rades E 6 for your Grades K 6 I Grades 6 9 school from Grades 9 12 drop down Grades K 8 or K 12 Table 4A Enter data below Step 2 Enter Lizz the number of 2012 2013 students with o T Oprefor oor O id correct year 2009 2010 f d 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 SWIS National Data Norms established the previous year for that particular school configuration e Instep 2 enter the year to date number of students who have 2 5 ODR s and 6 or more ODR s e lf you have data from past year s you may enter these numbers as well to give you a graph showing long term trends 18 Page My School Grades K 6 Triangle Graph October 2012 2013 E 6 Referrals 2 5 Referrals E 0 1 Referrals Grades K 6 2012 2013 My School National Comparison Grades k A e 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
15. enu The Main Menu is a new feature we have added in an effort to make navigating the Big 5 Generator easier m To enable macros click here Home Insert Page Layout Formulas Data Review View DE d Cut Past ni o 00 Conditi F t aste Bi wer 0 EE a4 Merge amp Center r 3 jo go conditiona ormat F Format Painter i z i i Formatting as Table Clipboard P Alignment Number l ES Verdana 2 IA E Wrap Text Set Up Data Entry Triangle Graphs Generator School Set Up Monthly Per Day Generator Location Data Entry Time Data Entry e The first time the Big 5 Generator 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 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 Big 5 Generator 3 Page Security Warning E JeeShen Zen XingiOCR ProjectiJMC Excel xis contains macros Macros may contain viruses It is usually safe to disable macros but the macros are legitimate you might lose some functionality Ena ble Macros e lf you are using office 1997 2003 you may or may not receive 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 functio
16. for a disciplinary reason regardless of time spent out of the instructional setting 3 You may only enter the cells in the table that are white 4 A per day rate should be calculated for each month and automatically will display in the third column for each year entered This data will also automatically be entered into two more tables and associated graphs below My School Major Referrals Per Day Per Month Over Time 2009 2010 2010 2011 S Attendance Referrals Days of Student Attendance Major Referrals for that Month N NS NlolPer Day Ra yo 10 28 25 al October December Janua Februa March April Ma June July IN e funfa al la Ln jo LGV ais Lg a E Fa RN s l al lG AININ S DIV 0 u FEDERN TSD SEBES Ea eso Disp E ONN SD Ivor ED IVO EDTV 6 EDTUTO 2011 2012 2012 2013 Attendance Days of Student Referrals for that My School Major Referrals Per Day Per Month Over Time September November December My School Monthly Per Day Rateto Date SE FSPEPPESALS S E g Pp E ELE SE lt w e This will take you to the Per Day Per Month Page 8 Page ina i b 10 38 AM 5 23 2012 L March P April B Mas 4 June 5 July Major Referrals Per Day Per Month Over Time 2009 20 2010 2011 2012 2013 Per Day Ra
17. haviors Directions Enter the number of major office referrals for each month by behavior in Table 1A You may only type in the white section If Monthly Graph bottom graph does not show the current month or current month s data go to school set up page and choose the appropriate month from the drop down menu My School Cumulative Behavior 2012 2013 PIS E gt HE gt Disrespect K 2012 2013 Inappro Lang Prop Damage Forgery Theft Disrespect Aggression Fight Innapro Affect Out Bounds Il lt e On this page in the cells under the column for the desired month type in the number of ODR s received in that particular behavior category 11 Page My School Cumulative Behavior October 2012 2013 Make certain the correct month and data are shown in the monthly Disruption Foge Theft Out Bounds Gang Display Tobacco combust Unkn own w R E m La L E Inn apro Affect My School October ODR s by Behavior for Month m October o Tardy Skip Prop Damage Inappro Lang Disrespect Disruption Fog ern Theft Inn apro Affect Out Bounds Gane Display Tobacco combust LUnkn own Aggression Fig ht e AGraph will appear to the right of this table The top graph will show the trends by months for the current school year to date e The bottom graph will chart data for the month entered on the Sch
18. ize v New folder A J Dropbox 2 Name Date modified E Recent Places r k Coventry Health Care 4 23 2012 2 02 PM File folder DESEs The Work 5 14 20121 23 PM File folder El Committee 4 20 2012 12 08 PM File folder Emerging 2 Day 8 3 28 2012 4 17 PM File folder i Fee Structure 2012 2013 5 3 2012 10 52 AM File folder a Mileage Logs 5 11 2012 3 07 PM File folder Recognition2012 5 2 2012 2 15 PM File folder School Data Profile 5 2 2012 2 52 PM File folder SET 2012 4 17 2012 10 34 AM File folder State Meeting May 2012 5 7 2012 3 49 PM File folder G2 Workgroups k 3 a ass k Summer Institute 2012 5 17 2012 4 13 PM File folder amp Campus Network eee eee ee rte name SERGSERESSTN ATTA Save as ype RC Libraries Documents ad Music E Pictures EE Videos jE Computer Local Disk C Open file after Optimize for Standard publishing publishing online and printing Minimum size publishing online lt Hide Folders e Name the file and indicate the file where you want to save it Per Day Generator The per day generator automatically calculates the median 25 percentile and 75 percentile for a school with your enrollment and compares it to SWIS national data This form was automatically completed from when you entered your schools data in the School Set Up Page Insert Page Layout Formulas Data Review View Developer Verdana N A gt Big E EE Bree
19. nality 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 Big 5 Generator The Big 5 Generator summarizes the who what when where and how often of your school s discipline data This information is vital for effectively intervening at the school wide level Step 1 School Set Up The first step in using the Big 5 Generator is to complete the School Set Up page The information on this page is critical for the graphs to function properly Big_5_Generator_5 21 2012 Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Verdana 122 FLA A Insert Delete F M IH 3 Copy 7 r U A F Format Painter n Z S Clipboard P Font Alignment Number S Cells B3 C SWPBS SWPBS Set Up Data Entry Triangle Graphs Generator School Set Up Per Day Data Entry Triangle Graphs Monthly Per Day Generator Location Data Entry Time Data Entry e To goto the School Set Up page click on the School Set Up button 5 Page E Cut E b u Verdana sa Copy T Paste ko N BF Format Painter B 7 U pii Clipboard Font Alignment fe October A D CQ sJ Ch Un EM School Name My School Month Year 2012 2013 Type Year November ae December Jan
20. ool Set Up page e Ifthe bottom graph does not chart the desired month choose the desired month from the drop down menu on the school set up page e Save e Click Return to Main 12 Page Step 4 Location This worksheet creates graphs that chart where problem behaviors are occurring Big_5_Generator_5 21 2012 Home Insert Page Layout Formulas Data Review View Developer E Cut d Cu Verdana 7122 IA A 3 Copy Paste FSU gt has Me F Format Painter tated Clipboard a Font Alignment Number B3 Fe SWPBS SWPBS Set Up Data Entry Triangle Graphs Generator e From the Main Menu click on the Location Data Entry button Clipboard 9 j Alignment Number D27 Table 2A My School CumulatiW QODR by Location to date oe Playground November December February 28 3 Hall Breezewa Cafeteria fice known aaa e On the Location Data Entry page enter the number of office referrals for the current month in the table 13 Page AM E E MAO Sr O Qp O e E E d PES E OE SPE SF FS V O o E cP ot 67 re e q N q Q a 5 a ad PG se D ha P My School October ODR s by Location for Month E b s Do La So a 3 Ra I oo s _ A a he ye an e There will be two graphs that appear to the right of this table The top graph is the cumulative graph for the school year and the bottom graph is the graph for the
21. q GI al GIS ol MO elai S o 5 a GI SJ B ol Yl Cc of LE ol ZI 21 GB o S EI o o N lt Ol AT TEI O F Wi GC C1 Ol Kl S O O lt c O m lt 33 Page Weapons J Std Sd Other 1d j j _ S Unknown o ft j S S _ j S Toa 1 j j j lj lj j S Location Data 2012 2013 34 Page HIHIH iii HIHIH iii HATTA pee PURUN per N ee TET e A e Other Location To 1 df df L S S o Unknown Location Totals j i RO 3 j j j 1 35 Page Time of Day Data 2012 2013 7 30 7 45 8 00 8 15 Ul 10 00 10 15 10 30 10 45 11 00 11 15 11 30 11 45 12 00 12 15 12 30 12 45 1 00 1 15 1 30 1 45 2 00 2 15 2 30 2 45 3 00 3 15 3 30 3 45 4 00 4 15 4 30 4 45 Total W CO HIO uo Un O Ln O 36 Page 37 Page
22. r students for different numbers of days 7 Page xd E File Home Insert Page Layout Formulas d Cut sa Copy 7 Verdana Paste r U GP Format Painter ae Font Clipboard P Data Review View Wrap Text Alignment Big_5_Generator_5 21 2012 Microsoft Exce Developer F lt 0 oo 00 gt 0 Formatting Conditional lt Format as Table B3 f lt SWPBS Set Up Data Entry School Set Up Per Day Data Entry Behavior Data Entry Location Data Entry Time Data Entry e Togotothe button from Page Layout Formulas Data Review Verdana Ba Copy aste GF Format Painter Clipboard G B Z View SWPBS Triangle Triangle Graphs Developer Wrap Text EE Merge amp Center Alignment Graphs Generator Monthly Per Day Generator Cumulative 57 Format as Table Conditional Formatting S e T EA Delete Format Cells Sort amp Find amp 2 Clear 7 Filter gt Select gt Editing Per Day Data Entry page click the Per Day Data Entry the Main Menu L17 A Back to Main SchoolSet Up Per Day Per Month Rate 1 Enter Number of days for each month that students attend school Include any early release as a day only if you count it as a student attendance day 2 Enter total number of major referrals only for that month Major referrals are any time a student leaves academic instruction
23. the multi year graph e Both of these graphs can be selected copied and pasted into PowerPoint or other documents that you wish to share with stakeholders e Save e Click the Back to Main button Step 3 Behavior This graph allows you to chart what are your most frequent problem behaviors The behavior categories are those used by School Wide Information Systems SWIS 10 Page PHIS yy OLS Wed ueq Big_5_Generator_5 21 2012 Microsoft Excel File Home Insert Page Layout Formulas Data Review View Developer Cut B amp Cu Verdana v 22 A Va d Wrap Text F 7 Ea 2 N lt E amp Copy 7 va Paste r U rad Merge amp Center 9 lt 0 00 Conditional Format Insert Delete F s B gt f E fo 00 gt 0 Format Painter w Formatting as Table Clipboard a Alignment Number Cells B3 SWPBS Set Up Data Entry Triangle Graphs Generator gt ol e To navigate to the Behavior Data Entry page from the Main Menu click on the Behavior Data Entry button x d lt G 7 CU Ui Big_5_Generator_5 21 2012 Microsoft Exce File Home Insert Page Layout Formulas Data Review View Developer K Cut be sa Copy 7 ur anit a aste BZ U by A Fad Merge amp Center 9 sa 200 Conditional Format GV Format Painter a Gw EE I Formatting as Table Verdana 10 A A Va Wrap Text Clipboard P Font Alignment Number D21 gt LU f Problem Be
24. uary Number of Stud February March April Number of Stud r Number of Students Enrolled 2010 2011 Number of Students Enrolled 2009 2010 e Enter school name this will cause your school s name to appear on the graphs e Enter Month using the drop down menu Important by entering Month you are telling the Big 5 Generator which month s data you want to appear in the By Month graphs 6 Page c Nai k Big 5 Generator 5 21 2012 Microsoft Home Insert Page Layout Formulas Data Review View Developer Verdana B T fe October School Name My School 2012 2013 Type Year Number of Students Enrolled 2012 2013 Number of Students Enrolled 2011 2012 Number of Students Enrolled 2010 2011 Number of Students Enrolled 2009 2010 e Enter year this will cause the year to appear on the cumulative graphs If you like you can use school year i e 2012 2013 e Enter September enrollment for each year that you wish to include data Important The Per Day Per Month graphs will not work if you do not enter enrollment information e Once you have completed the information for this page click the Back to Main button Step 2 Per Day Per Month This graph tells you how often problem behaviors are occurring The Per Day Per Month table and graphs will provide you with information on the daily rate of office referrals allowing you to compare months in which school is in session fo
25. ula Bar Q m R E FE Q View Side by Side F T Camchranniec Cren a tu ua Synchronous Scrolling Normal Page Custom Full O Gridlines Headings Zoom 100 Zoomto New Arrange Freeze Save Switch Macros Views Screen Selection Window All Panes Unhide Reset Window Position Workspace Windows v Y Workbook Views Show Zoom Window Macros fe D E E G H I J K L M N o P Cumulative Data 1 E i My School 5 Backto Main 7 October 2012 2013 10 My SchoolMajor Referrals Per Day Per Month Over Time E 16 17 18 19 20 21 22 G 2009 2010 2010 2011 23 24 25 0 5 2011 2012 sm 2012 2013 26 27 28 29 b G fea o a 5 v z 30 5 E 5 F F s 3 31 F 5 S 5 E 32 a o 33 E 34 I 35 My School Cumulative Behavior October 2012 2013 36 37 ss ll 38 39 40 41 42 43 a 44 15 45 46 E 47 10 p mSeriesl e This page is protected If you wish to select copy and paste a graph you must go to the data entry page for the desired graph This was done to make printing easier e To print print as you normally would print from Excel Creating a PDF in Office 2007 and 2010 To create a PDF you may do one of two things e Goto the button Ba 2007 or File 2010 menu 21 Page X z 9 G File Home la Save GR Save As Insert Page Layout Formulas Data Review View Information about Big_5_Generator
Download Pdf Manuals
Related Search