Repository logo
 
Publication

Using a spreadsheet to support e-assessment

2017Conference object Open access
Simple item page
dc.contributor.authorAzevedo, Jose Manuel
dc.contributor.authorPedrosa, António
dc.date.accessioned2018-01-03T09:13:17Z
dc.date.available2018-01-03T09:13:17Z
dc.date.issued2017
dc.description.abstractSome of the courses of the scientific area of Mathematics at ISCAP use multiple choice questions (MCQ) tests as a fundamental part of the assessment. The assessed topics include Differential and Integral Calculus, Algebra, Statistics, and Financial Mathematics. In the undergraduate programs of Accounting, Marketing and International Commerce, these courses are taught in theoretical-practical classes and their main objective is to provide the necessary support tools to other courses of these programs. On the other hand, these undergraduate programs, in particular Accounting, have many classes and many students, so MCQ tests have been an indispensable tool for both continuous and final exam assessment. The open source MOODLE platform, used through a local network intended only for continuous assessment, has been the support software for MCQ tests. In order to integrate student classifications so as to be more easily retrieved by all teachers, and in order to obtain them more quickly, an MS ExcelTM spreadsheet was developed. This allows us to automate the whole process from collecting the students’ answers, to obtaining their final classification and calculating important statistics. This paper describes the development process of this tool, which has proved extremely important in the e-assessment method already implemented. Therefore, some of the results presented show: (i) the substantial reduction in the time elapsed between the moment the tests were carried out by the students and the moment of the publication of the grades; (ii) the existence of automatic control in case of duplication of tests by the same student, (iii) the action of complementing MOODLE in the treatment of negative grades of students; (iv) the possibility of performing several statistical analysis that can be organized by class, by subject, by attendance regime to classes (nocturnal versus diurnal), and include comparisons with previous years and tables of frequencies of grades.pt_PT
dc.description.versioninfo:eu-repo/semantics/publishedVersionpt_PT
dc.identifier.isbn978-1-911218-59-3
dc.identifier.isbn978-1-911218-60-9
dc.identifier.urihttp://hdl.handle.net/10400.22/10673
dc.language.isoengpt_PT
dc.peerreviewedyespt_PT
dc.publisherAcademic Conferences and Publishing International Limited (United Kingdom)pt_PT
dc.relation.publisherversionhttp://www.academic-bookshop.com/ourshop/prod_6222116-ECEL-2017-PDF-Proceedings-of-the-16th-European-Conference-on-eLearning.htmlpt_PT
dc.subjectE–assessmentpt_PT
dc.subjectMS Excelpt_PT
dc.subjectMultiple choice questionspt_PT
dc.subjectMathematicspt_PT
dc.subjectHigher educationpt_PT
dc.subjectContinious assessmentpt_PT
dc.titleUsing a spreadsheet to support e-assessmentpt_PT
dc.typeconference object
dspace.entity.typePublication
oaire.citation.conferencePlacePorto, Portugal - ISCAP - IPPpt_PT
oaire.citation.endPage47pt_PT
oaire.citation.startPage39pt_PT
oaire.citation.title16th European Conference on eLearning - ECEL 2017pt_PT
person.familyNameAzevedo
person.givenNameJose Manuel
person.identifier.ciencia-idD412-FBB4-852A
person.identifier.orcid0000-0001-6951-4278
person.identifier.ridA-1161-2017
person.identifier.scopus-author-id56895690500
rcaap.rightsopenAccesspt_PT
rcaap.typeconferenceObjectpt_PT
relation.isAuthorOfPublication3dcacd67-8df3-48da-804c-0b2036f35554
relation.isAuthorOfPublication.latestForDiscovery3dcacd67-8df3-48da-804c-0b2036f35554

Files

Original bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
Using_a_Spreadsheet_to_Support_ e-Assessment_Jose_Azevedo_Complete_ECEL17.pdf
Size:
318.53 KB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.71 KB
Format:
Item-specific license agreed upon to submission
Description:
Download

Collections

ISCAP - Matemática - Artigos