Indicator B14 Survey

My journey to accumulate IEP and related forms from all states (check my progress) was interrupted by my discovery of B14 Survey developed by the state of Connecticut and made available both on survey monkey and paper.  I converted the survey to a google form, Survey of Graduates or Exiters of Connecticut High Schools, that states, area education agencies and local districts can edit.  I have experienced significantly more response with the google form versus paper.  Please check my website to copy the spreadsheet and check for updates in the data manipulation.  I plan to setup the spreadsheet to allow correlation between skills covered in high school and outcomes.

Rubrics - Qualitative and Quantitative Data using Google Doc Forms

I wanted to convert a rubric that was used to produce a score based on the selection of the descriptors. I like how rubrics provide a description of a certain behavior, however, I also like the ability to produce a numerical score. The use of the If-Then formula allows for the conversion of descriptors to a numeric value resulting in both qualitative and quantitative data. I started with the AEA 10 ServiceMatrix which is used to determine special education weightings. The form and the corresponding spreadsheet can be found on the Resource subpage on my website.  I will be searching for assessments, based on a rubric, to convert to google doc forms.  Using google docs forms, the rubric can be converted to a multiple choice assessment.  The owner of the goole doc assessment can assign points to the various descriptors.  If you have a rubric you would like to have converted please send a copy to kurtis.broeg@gmail.com

Transition Services Assessment

While scanning the internet for transition assessments I discovered the Special Education Needs Assessment which was developed in collaboration with the Virginia Department of Education and the Shenandoah Valley Regional Program. (Revised March 1995).  The original document compiles data and sets priorities for improvement based on assessment of 37 criteria by a team consisting of various stakeholders.  Conversion to Google Docs allows for assessment of the criteria on a much broader level.  Summary of Responses can be used to quickly analyze data.  In addition, information compiled in the spreadsheet can be sorted to see how the different groups of stakeholders rate and value the criteria.  The Transition Services Assessment can be used by states, area education agencies, and/or school districts to appropriately allocate resources for transition services.  Please copy and edit to meet your needs.  Feedback is always appreciated at kurtis.broeg@gmail.com.

Parent Transition Survey

The Parent Transition Survey is a great tool to discover parental expectations and start dialogue that leads to a successful transition plan. The survey collects data on current needs and post secondary expectations in the areas of Living, Learning and Working. In addition to asking about post secondary expectations, the assessment asks the parents what adult services will be necessary for the post secondary expectations. The survey concludes by assessing parental awareness of adult services. I suggest copying the spreadsheet and editing the adult services to match the actual names of adult services in your area.

Revised AIR Self Determination Skills Assessments

Recently, I went to use the AIR SelfDetermination Skills Assessments and discovered that it could be improved to make the data more user friendly. I added a second sheet labeled Results that provides a quick calculation of the categories. I also converted all scores to percentages to allow for comparison across categories. Presenting the data in percentages is a change to the way the original scores were reported. I still have not discovered how to eliminate the need to copy formulas. In the results section, copy the formulas in the preceding row to the next row. Please let me know of ways I can make the assessments more user friendly by contacting me at kurtis.broeg@gmail.com

How to Copy a Google Doc Assessment from my Transition Site

Step 1: Get a google account

Step 2: Go to Broeg Transition Assessments

Step 3: Select a link under Data on any of the pages. When it opens it will look like a spreadsheet. For example: click on Numeric Parents of Teenagers Checklist Data

Step 4: On the top left corner of the spreadsheet you will see a File Menu. Click File and select “Make a copy....”

Step 5: A box will open asking you to make a new name for the document. I suggest placing the initials for High School or your name in front of the existing name. For example “KB Numeric Parents of Teenagers Checklist.”

Step 6: Now go to your Documents from the iGoogle page and you will find the Google Doc. Click on the Google Doc to see the spreadsheet.

Step 7: You can send the form to recipients or produce a link on a website. To send the form: Click on form above the spreadsheet. Select send form. A box appears that allows you to enter the emails of the people you wish to send the form. If you have google mail and have the people saved in contacts you can select choose from contacts. To add a link to a website of the form: Click on form and select edit form. Now highlight and copy (Command +C) the url located at the lower right corner of the form. Use this to hyperlink to your own website. Users of your site will only be able to enter data.

Please let me know if the above steps do not work and/or can be improved. You can contact me at kurtis.broeg@gmail.com. Thanks.

21st Century Skills Assessment – New and Improved

After using the assessments and receiving feedback from others, I have divided the assessments into parts to make them more user friendly. I also changed the scoring of each part to a percentage range of zero to one hundred for each assessment. I start by giving the assessment that matches the student's age range. For instance, if I assess a student who is currently in tenth grade I start with 21^st Century Skills: Employability Skills Part 4. If the student's total score is less than 70%, I give the student the Employability Part 3 Assessment and continue the process until the student scores above 70%. Using the assessment in which the student scores over 70%, I list the essential skills the student scores above 70% as the skills the student can perform and list the essential skills below 70% as areas in which the student needs instruction. The use of 70% is based on the 0-3 (Disagree-Agree) scale I use on all the assessments. The elements of the essential skills are based on expected desired levels. Does someone want to norm the 21^st Century Assessments? Norming would bring great attention to the areas of Living and Working. My assumption is that many students with disabilities would perform above typical peers. While the data for students scoring significantly below peers can be used to guide special education services. Please take a look at the new and improved 21stCentury Skills Assessments.