Exploratory data analysis (EDA), data visualization, and visual analytics are essential for understanding and analyzing complex datasets. In this project, we explored these techniques and their applications in data analytics. The case discusses Tableau, a powerful data visualization tool, and Google BigQuery, a cloud-based data warehouse that…

The National Institute of Mental Health created the National Database for Autism Research (NDAR) to accelerate autism knowledge through data sharing and collaboration. However, our experience using NDAR reveals systematic challenges across several aspects of data submission, selection, management, and analysis that limit utility of this resource.…

While geographic search filters exist, few of them are validated and there are currently none that focus on Germany. We aimed to develop and validate a highly sensitive geographic search filter for MEDLINE (PubMed) that identifies studies about Germany. First, using the relative recall method, we created a gold standard set of studies about…

Despite enacting well-intentioned policies to improve teacher recruitment and retention, many states continue to face significant staffing challenges, particularly in high-need schools and hard-to-staff subjects such as math, science, and special education. Two years ago, the National Council on Teacher Quality (NCTQ) set out to explore the…

Faced the vast amount of information, choosing the appropriate materials is a prerequisite for effective self-directed learning. The recommendation algorithm is a kind of intelligent technology that can accurately locate the required information which the users care about most. However, many recommendation techniques experience can not be trained…

Aim/Purpose: This paper addresses the lack of a standardized approach to information dashboard design and the absence of integrated Information Governance (IG) principles in this context. Background: This study addresses the critical role of IG principles in ensuring dashboards are reliable, secure, and effective. By integrating IG principles into…

This study investigates how article downloads from ScienceDirect changed after Temple University Libraries downsized its all-inclusive Elsevier big deal bundle to a selective custom package. After the libraries lost current-year access to nearly half of Elsevier's active journals, the total downloads from Elsevier journals declined by 16.2 percent…

California's information about opportunities and outcomes in early learning and care, TK-12 schools, colleges, social services, and employment is currently disconnected. A longitudinal data system can be a powerful tool that allows California to identify bright spots, inequities, and roadblocks in our educational system, especially for students of…

In 2019, California passed legislation that called for the creation of its longitudinal data system, the Cradle-to-Career (C2C) Data System. Since then, the state has allocated $40.52 million in funding to support the agency's efforts. Given the substantial state investment and the potential for more, better, and accessible data to answer critical…

The "Forum Guide to Metadata" presents and examines the ways in which metadata can be used by education agencies to improve data quality and promote a better understanding of education data. Supported by metadata-related case studies from state and local education agencies, the guide highlights the uses of metadata from a technical point…

SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature,…

Planning for the sustainability of data system integration should be a fundamental part of the initial project plan. Taking a long-term view rather than a project-to-project approach improves the data culture and chances of success. The intent of this tip sheet is to identify key components, strategic timing, and planning considerations for…

Eleven states have worked with CIID, over the past three years, to integrate their IDEA data and to implement Generate, a software application that improves data quality and automates reporting through standardization. These eleven states have realized notable data quality improvements that will be shared in this brief to help states across the…

CIID has implemented Generate in 9 state education agencies (SEAs), and through this work SEAs have realized a variety of improvements to their special education data in terms of overall data quality, improvements to data governance structures, and ease of federal reporting. This brief is the second in a series looking at data quality. Here, we…

High-quality data is essential when looking at student-level data, including data specifically focused on students with disabilities. For state education agencies (SEAs), it is critical to have a solid foundation for how data is collected and stored to achieve high-quality data. The process of integrating the Individuals with Disabilities…