November 12, 2008 at 7:23 PM -0500 wrote:
>We built a complete Grades & Comments system to replace a legacy system.
>It is an extranet that teachers can access wherever they can get an
>Internet connection. Parents can log in and see grades and comments as
>well. IT was built with Cold Fusion and SQL. It has worked well and has
>evolved to include attendance as well.
This is exactly what we did. I had already built a basic student info
system for tracking information on students, and I converted an old FMP
solution to the web using ColdFusion and MySQL. We've tweaked it now to
where it works well for us.
Teachers submit comments. Academic advisors (2 for each form, split by
sex), read and approve the comments (or do slight edits if needed). Once
approved, we print out the reports using Crystal Reports connecting to the
MySQL db.
I'm looking at being able to do the comment reports through the web as
well, but I'm not there yet. We're also planning to move this way for our
advisor letters (3x/year), but that's a more complicated issue because of
divorced parents, name salutations, etc.
The difficult aspect of all of this is that our main database is
Blackbaud's Reg Office 7 (EE). I finally figured out how to connect to the
database, but I have to manually parse the tables to get the data out and
into ColdFusion.
Peter Hoopes
Director of Technology
St. Andrew's School
phoopes@standrews-de.org
=====================
[ For info on ISED-L see http://www.gds.org/ISED-L ]
Submissions to ISED-L are released under a creative commons, attribution, non-commercial, share-alike license.
RSS Feed, http://listserv.syr.edu/scripts/wa.exe?RSS&L=ISED-L
