Didactic application for assessment in Excel

Imparting of knowledge, its verification and assessment represent the most important teacher’s tasks. The examination results are equally important for the student and for the teacher. On the basis of the results the teacher assesses if the teaching aims were achieved, if the knowledge was imparted correctly and plans their further work. The student assesses their learning progress. Nowadays there are several various ways for teachers to assess students’ knowledge; from classic oral and written assessment to the latest forms of computer based assessment of knowledge. With the use of the appropriate software the latter can save a considerable period of teacher`s time. The diploma paper presents how Microsoft Excel, one of the major programs of Microsoft Office, can be used by teachers. It describes how to compose crosswords, quizzes and linking exercises. It also provides how student’s initial, present and final knowledge can be assessed. The exercises can be composed in a way that the student gets the feedback about the correctness of the answer as soon as it has been chosen. The main purpose of the diploma paper was to program the didactic application ADEA (Assessment Didactic Excel Application) in programing language Visual Basic for Application (VBA) which works in Excel. The application helps teachers in composing questions for oral and writing examination, correcting and assessing the exams, copying out the results and also in making a random seating order. In the end the didactic characteristics of the application were evaluated by teachers with various computer skills. Teachers with the lack of computer skills would probably need more time while adopting the application ADEA since they firstly have to master the basics of Microsoft Office Excel. Eventually all the input time and effort would be refund frequently