Washington Framework for Comprehensive Guidance and Counseling

Keep current on useful technology to monitor student progress

School counselors need a way to evaluate if the interventions they are using with individual and/or groups of students are 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 have 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, and GPA has risen.

Sample useful tools are available to you for little or no cost.

  • Surveys are available in the Framework Resources section and from a variety of sources such as: Counseling Technology.Net Surveys  https://www.counselingtechnology.net/aboutSurveys.php , Survey Monkey, and Google Docs . For a service that collects and analyzes bullying survey data go to Report Bullying. Com ( http://www.reportbullying.com/bullying-schools-anti-bullying-surveys.htm)  To create surveys for internet-capable devices such as mobile phones and tablets use mobosurvey (http://www.mobosurvey.com/)
  • EZAnalyze is a free Microsoft Excel Add-In designed by a school counselor 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 PCs. Here is a link to the Features found within the program. EZAnayze can be used in conjunction with a tool like Data Mining (see below) to filter and group at-risk students based on universal screening factors like grades, discipline, and attendance.
  • Data Mining from attendance programs used in the school districts. This is a process that allows counselors to “mine” or pull out, specific data from, for example, the WSIPC Skyward Point-and-Click (WESPaC) software to create reports or School-Wide Information System (SWIS).  Data Mining Reports could be used to screen students for indicators like attendance, discipline, and grades.
  • Washington Education Decision Support System (WEDSS): WEDSS is a data warehouse created for users of WESPaC. Counselors that have access to WEDSS will be able view and analyze student data including state assessments, MAP testing, and other district specific data, such as a global view of student data.  WEDSS also includes an at-risk-module that can help School Counselors identify students at risk.
  • Crystal Reports is a Washington Education Decision Support System (WEDSS) application used to design and generate reports from a wide range of data sources. Several other applications, such as Microsoft Visual Studio, bundle an OEM version of Crystal Reports as a general purpose reporting tool.  WSIPC has developed two reports: Prevention and Intervention Summary Report and Detailed Report.  These reports can be used to identify students at risk from a macro view of a whole grade level of students to a micro view of an individual student.
  • The School-Wide Information System (SWIS) is a web-based information system designed to help school personnel to use office referral data to design school-wide and individual student interventions.  http://www.swis.org/