DEWIS can be developed by a school counseling department, built into a strategic plan for a school and/or district, and integrated into a school improvement plan for your building principal. The basic functions are necessary to build a system at either the local or state level:
School Counselors can use a variety of products to help identify students who may be at risk of dropping out. The Renton Public Schools Publication Getting to High School Graduation: Identifying Early Warning Indicators to Prevent Dropouts is an excellent article to get familiar with universal screening factors necessary to identify students at risk of dropping out of high school.
The main universal screening factors that School Counselors can focus in on are:
EZAnalyze is a Microsoft Excel Add-In designed to enhance the capabilities of Excel by adding “point and click” functionality for analyzing data, creating graphs, and creating new variables. It works on both Macs and PC’s, except for Excel 2008. EZAnalyze is free to use by any School Counselor. EZAnayze can be used in conjunction with a tool like Data Mining. Student Data can be mined then a School Counselor can use EZAnalyze to filter and group students based on universal screening factors like grades, discipline, and attendance. Here is a link to the Features found within EZAnalyze. EZAnayze can be used for universial screening of researched support indicators like attendance, behavior, grades, GPA, state testing scores to build groups of students who may be at risk of dropping out of school.
Develop an Intervention Map of your school then determine which interventions will be used with which students over time
Here is an example of intervention mapping of an elementary school, middle, and high schools.
Please download tool to map out interventions found within your school.
School Counselors will need a set of tools to connect time spend with a particular student and/or group of students to an intervention. EZAnalzye Time Tracker is not dependent on a school district’s student information system. Any School Counselor can download EZAnalyze Time Tracker for free. The School Counselor sets up their own intervention codes, imports a list of current students, and can begin tracking time linked to an intervention in a matter of minutes. The School Counselor only needs a computer with EZAnalyze TTE and Microsoft Excel. The database file can be saved on the local School Counselor’s computer, or saved on a thumb drive that can be locked in a file cabinet. Another tool avaliable to School Counselors who use Skyward tools like WESPaC and/or Web is the Guidance Module. The Guidance Module is not a stand alone setup for a School Counselor like EZAnalyze TTE. The Guidance Module is integrated with the school district’s student information system. School Counselors can run data minner reports, roll up data from elementary, middle, to high school, and create a check-in point for any student coming into a counseling or career center.
The EZAnalyze TimeTracker is a free macro-enabled Excel workbook designed to perform note-keeping and time-tracking functions, and generate reports for accountability and improved service to students. It now works on both Macs and PC’s, except for Excel 2008.
The Guidance Module is a tool found within WESPaC. School Counselors can load student engagements that need to be tracked over time into the guidance system. The School Counselor then can setup a student kiosk to track time spend on a particular intervention.
School Counselors are going to need a way to evaluate if the interventions they are using with individual and/or groups of students is making a positive difference. School Counselors can use a survey to measure pre- and post- perceptual data with students to determine if their beliefs, attitudes, and perceptions about their situation has improved. At the same time, School Counselors can use a data analysis tool to measure if attendance has improved, grades have risen, negative behavior has decreased, failure rate has decreased, testing scores have improved, GPA has risen, and etc.
Survey Tool for Perceptual Data: The great piece about using surveys from counselingtechnology.net is that you can setup the survey to work with EZAnalyze. At the same time, this survey tool is free to any Professional School Counselor.
Counseling Technology – http://www.counselingtechnology.net/