[Hidden-tech] suggestions needed for a relational database

[Town Websites]

It sounds like your main problem isn't in the database but rather in how
people will enter the information.

 

If you want the system to be inexpensive and internet-accessible, MySQL is
the easy choice for the database.   If you want it to be easy for someone
with a little training to be able to browse, a database query tool called
"Navicat" gives you a flexible and easy to use browsing and reporting tool.

 

However, what you really need to improve the process sounds like  a good
easy to use front end design, that would be the web pages and forms they
would use to enter their data, if you're building it to use in a web
browser.

 

There are likely some complete packages for tracking this type of
information if you look in the right place, which would just require
configuration with some attention paid to the usability of the input
screens.  Otherwise find a good designer able to design web forms and sit
down with them to describe what needs to be done.

 

Charlie

 

From: Keri Heitner [mailto:Kheitner at earthlink.net] 
Sent: Thursday, March 11, 2010 9:55 AM
To: 'hidden-discuss'
Subject: Re: [Hidden-tech] suggestions needed for a relational database

 

Thank you for all of the suggestions. Here is additional information about
what will be tracked and who will be entering the data: 

 

The purpose is to track student information to see if the program is helping
with GPA, test scores, etc. Instructors collect data on: GPA pre- and
post-course, math test scores, which students dropped out during the school
year, which students went on to a 4-year college, attendance, graduation
rates, infraction rates. 

 

Staff running the course at another college use  Efforts to Outcomes
software. The problem is that many teachers stopped uploading the above
information because the process was very tedious. So the database must
support multiple users and be easy to use.  

 

Keri

.       Keri L. Heitner, Ph.D.
All Aspects Research
413 549-0154 ph/fax (ET)
 <mailto:kheitner at earthlink.net> kheitner at earthlink.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20100311/9f33e417/attachment-0001.html