There are several ways by which quantitative data in the form of scores can be entered into a spreadsheet:
Data can be downloaded from a data base, either a digital assessment tool (for example, e-asTTle) or a student management system, in the form of a
CSV (comma separated value) file
( 3 KB)
. CSV is a simple file format used to move tabular data between different computer programs that support compatible file formats.
Quantitative data from other assessments, for example Overall Teacher Judgments, can also be entered onto a spreadsheet. Results can be copied from any digital table of figures, simply by cutting and pasting. The spreadsheet should contain all the student information that is necessary to be able to analyse the data closely. For the accumulation of data over time (longitudinal data), it is essential to have enough information by which you can identify tests and students. Suggestions are: Date of the assessment, type of assessment, student name, student number, year level, gender, ethnicity, assessment result.
If you have downloaded data from a database, you may find that you have columns of extra information that you don’t need for your data storage or analysis. Remove these, making sure you do this consistently across all data sets. See the Cleaning and Formatting Data section.
If the assessment tools are not digital, information will need to be entered manually, either into the Student Management System (SMS) and downloaded, or straight into a spreadsheet. An example of data which would need to be entered manually is Overall Teacher Judgments.
To learn how you can create an assessment datasheet, using data downloaded from a database as the starting point, see the video tutorial below.