Summary:
I have chosen to do a prototype of a bigger project that can't be completed during this week. I would like to integrate various Google Tools in a process work flow environment.
Business Need:
In OSSS -Office of Special Student Services, there is room for a streamlined process, by which students get into the "system" to be evaluated. As that process moves along, various evaluations may need to be done. The system currently uses email to track who is doing what and whether or not evals are completed. Only the emailer and recipients of the email are kept in the loop. I'd like to centralize the information and provide a way for everyone involved to take ownership of their piece to provide a resultant database/spreadsheet with status. (This may be unrealistic but it's certainly a potential project).
Process Workflow:
Currently, we have several sources which directly feed specific people withing the OSSS. They would provide the student name and date of birth, school, information as to whether or not there is a Prior Written Notice, etc. Those individuals have to reach out to other departments to find out more of the parent/teacher concerns about this child to determine what kind of evaluations need to be done. Further down the road, a CSE meeting is setup. The evaluators need to know the CSE date to ensure that their evaluations are done in a timely manner.
Potential Development:
I'm hoping to create a form/forms that can be submitted by the initiators of the process (perhaps a list of individuals) to create new student names (and accompanying info) to be merged into the centralized spreadsheet. As I go along, I may want to use other Google Tools to embellish this process, but this is my starting point.
What do you think?
I love this idea! Raqelle had tried something like this a few months ago by creating a spreadsheet with student name, DOB, CSE date and name of each evaluator and date of evaluation. problem is, many ppl we work with don't have google mail or didn't bother filling in their piece. still, if this gets implemented OSSS-wide, I would LOVE it! Maybe include an area where ppl can put a 2 sentence summary and where they stand on CSE recommendations...
ReplyDeleteWOW! Well, leave it t Karen to go big or go home. I love that you are going to work toward an end product that will serve the needs of so many educators. A spreadsheet, such as this, where all the information on a student is in one place and accessible to all would be great. It would have definitely helped one of my students this year to begin his speech services earlier. By the time our school psychologist was able to get the right information from the right person after the "red flags" went off, a lot of time had passed.
ReplyDeleteYes, Raquelle did set up a google doc a while ago and I made some modifications to it, including adding columns, filters, sorting, data validation with lists, conditional data displays, and more but you're correct in that it just didn't get off the ground. Only 3 speech therapists were using it. Maybe this will help boost that document. I'd like to make it more accessible to the appropriate people than it currently is. I will take everyone's comments under consideration and would obviously have to get approvals before actually launching this "tool".
ReplyDeleteSpeak of innovative and daring!!! I love the idea as many of us testing have no idea who else is testing and when. Sometimes when I enter the information on a child's IEP I notice that the child got the ed, psych, and speech evals on the same day. Using your idea we could post projected testing dates so the poor child is not subjected to a full day of intensive evals. Keep us posted as you get creative!!
ReplyDeleteMy comment which I posted was not published. I will try again.
ReplyDeleteKaren, I think this is a great idea. In order to work it would have to come from the top down. If someone at the top would input the info. it would be very helpful for the team members when testing... It would help organize a lot of people and make things more efficient and quicker.
ReplyDelete