Te Kete Ipurangi Navigation:

Te Kete Ipurangi

Te Kete Ipurangi user options:

You are here:

Creating a datasheet of assessment data

Quantitative data in the form of scores can be entered into a spreadsheet in several ways:

  • Data can be downloaded from a database, 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 into a spreadsheet. Results can be copied from any digital table of figures 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. 
    • Types of useful information: 
      • Date and type of assessment 
      • Student name and number 
      • Year level, gender, and 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 that 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, view this video tutorial on Creating a datasheet of assessment data.