Using a Spreadsheet to Process and Analyse Student Marks
Bibliographic Data
| ID | 19377791 |
|---|---|
| Authors | Kevin C Cox (0000-0002-3275-6692, corresponding author), Kevin Cox |
| Year | 1993 |
| Volume | 18 |
| Issue | 2 |
| Pages | 115-123 |
| Publication date | 1993-01-01 |
| Open Access | No |
| Type | ARTICLE |
| Venue | Assessment & Evaluation in Higher Education (JOURNAL) |
| Journal identifiers | ISSN: 0260-2938 • E-ISSN: 1469-297X |
| Publisher | Informa UK Limited (PUBLISHER • GB) |
| DOI | 10.1080/0260293930180203 |
| OpenAlex | W1991432466 |
| Language | EN |
| References cited | 1 |
This paper shows the use of a spreadsheet to process and analyse student assessment marks. The ideas are illustrated with examples from data for a first year programming subject, but the processing and analysis functions apply to many other assessment situations. The functions described are data collection and control, allocating grades, checking consistency across tutorials and analysing relationships between items of assessment and grades. The paper shows how to derive information from assessment marks with a widely available, inexpensive computer tool. The work is part of an ongoing project to raise the awareness of assessors to the possibilities of marks analysis to improve subsequent decisions
Data collection · Data science · Mathematics education · Programming language · Statistics · World Wide Web · Computer Science · Educational Technology and Assessment · Engineering · Engineering Education and Pedagogy · Experimental Learning in Engineering · Mathematics · Psychology · Artificial Intelligence
| Highly cited | No |
|---|