Microsoft Excel Pivot Table offers easy analysis of data...any data. These directions will guide you step-by-step on how to enter, store and analyze data of office referrals. Any software can help you efficiently enter data, but this template will guide you step-by-step through the in-depth data analysis process.
What comes with this purchase? An Excel spreadsheet with pivot table set up and ready to use AND a 13-page document that gives you step-by-step directions on how to use this product.
The Microsoft Excel Spreadsheet with Pivot Tables already created FOR you in this product allows you to:
o Analyze your office referral day by student-you can see who your heavy hitters are.
o Determine what infraction most often occurs.
o Analyze month to month data. Are your office referrals increasing or decreasing?
o Determine which teachers have the most/fewest office referrals.
o Analyze the type of consequences are used most often.
o Compare office referrals by grade level, location, time of day etc.
o Print data monthly or yearly for comparison or to share with the school’s at-risk team.
o Print data on heavy hitters in order to develop behavior management plans to address student needs.
o Print at the end of the year to maintain a complete list of data for future reference. This information can also be preserved electronically.
• Microsoft Excel 2010 is the minimum requirement, which needs to be installed on the computer you will be using.
• The directions you will receive with your product are very detailed and easy to follow. A basic understanding of how Excel spreadsheets work is helpful. These directions were written for PCs but are easily adapted for Mac users.
See TheThreeSquarePegs.com blog for more information on how Office Referral Analysis has been used.