scanning/OCRing form data into Excel for summarization

joejoejoe1

New Member
Joined
Jan 4, 2006
Messages
5
Hi all,

Not sure if this is the right forum, but it does involve Excel.

I know how to create custom Excel forms. What I'd like to do is create such forms for teachers in a school to keep track of student behavior infractions (e.g. inappropriate disruptive behaviors - forms have to be paper based - no teachers have laptops, many are not technical, etc).

Then, the forms would be distributed to teachers, and they would create one "behavioral incident report" for each student for each infraction (maybe even log multiple infractions onto a single form, haven't decided) - it would include Teacher name, student name, checkboxes/radio lists for infraction, etc). Many different teachers/administrators would be logging this data onto different forms for the same student.

The part I have no idea how to automate is the scanning in of these forms - OCR'ing / translating the data into Excel so that for a student, we can summarize the number and type of infractions per week, month, etc.

If anyone can give tips and recommend the best software for the job (freeware/shareware solutions are desirable - not required :) I would really appreciate. Thanks very much.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
When I saw this post I subscribed, hoping someone would know the answer. The concept is intriguing.

Does anyone have any suggestions relating to joe's question?
 
Upvote 0

Forum statistics

Threads
1,224,586
Messages
6,179,718
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top