Sentiment Analysis OCR

Hello! I have all my school reports from when I was a child. There are 11-12 school reports in total. The first starts in year 1993 and covers the first half of my schooling. All the reports from 1993 until 1999 contain hand written text and cover from prep/foundation until year 6. The second half from 2000 until 2004 and describe my high school experience and the text is printed via a computer. I would like to run text and sentiment and sentiment analysis to unlock and discover key themes per yea over time, and each half year, each report is either covering the first or second half of an allocated year and to identify and uncover any consistent themes over time. The analysis should also identify any outlier years and the corresponding reasons why based on teacher feedback. How can I quickly create a database of the text and have the analysis completed automatically? It’s very important that each report is analysed and categorised by yeat and which half year. Cheers