Merging Large-Scale Assessment Data for Secondary Analysis: Experiences with EQAO’s Data

Gul Shahzad Sarwar, Carlos Zerpa, Christina van Barneveld, Marielle Simon, Karieann Brinson


This paper is a narrative of our experience in analyzing and merging data files provided to us by the Education Quality and Accountability Office (EQAO). In the paper, we propose a scheme of merging data files by means of Structured Query Language (SQL, pronounced as “sequel”). Although, the narrative of our experiences using this merging scheme could have been extended to any number of data files, the aim of this work was to merge only three EQAO data files. Via this merge process, we were able to gain meaningful information and facilitate the analysis of EQAO data to answer our research questions. By using SQL queries, our approach was not only to analyze the available data files but also to construct a narrative about viewing and handling data contained in the files.

Full Text:




  • There are currently no refbacks.

Journal of Education and Learning   ISSN 1927-5250 (Print)   ISSN 1927-5269 (Online)

Copyright © Canadian Center of Science and Education

To make sure that you can receive messages from us, please add the '' domain to your e-mail 'safe list'. If you do not receive e-mail in your 'inbox', check your 'bulk mail' or 'junk mail' folders.