I am a history teacher. I have created an Omeka site with the Curatescape theme for my students to present local history. Next year, my students will be transcribing a series of Civil War enlistment records. I would like for them to be able to attach an image of the record to their transcription. I would like for them to be able to manipulate the data, examine patterns, averages, etc. I could have them simply use a spreadsheet, but it isn’t really optimal.
I noticed that Reclaim offers the SQL tool. Is that the route I should take? Does it allow the generation of reports, allow calculations, allow the data to be searchable from a front end on the Omeka site?