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…

Institutions face both challenges and opportunities in communicating with external constituent groups, from marketing new programs to attracting visitors and soliciting alumni. A college or university's tight-knit community of students, alums, and friends adds a special dimension to the higher education experience; bonds formed in college often…

This qualitative research study examines librarians' research data management (RDM) experiences, specifically the factors that influence their ability to support researchers' needs. Findings from interviews with 36 academic library professionals in the United States identify 5 factors of influence: (1) technical resources; (2) human resources; (3)…

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…

To guarantee high-quality services, health professionals are required to successfully maintain their extensive knowledge base. M, health professionals are forced to consistently stay up-to-date in their field in which new knowledge is evolving continuously. Hence, there is a strong need for effective support during their lifelong, self-directed…

The objective of this audit was to determine whether the U.S. Department of Education's (Department) overall information technology (IT) security programs and practices were effective as they relate to Federal information security requirements. To answer this objective, the Department's performance was rated in accordance with Fiscal Year (FY)…

Data visualization is a key component to business and data analytics, allowing analysts in businesses to create tools such as dashboards for business executives. Various software packages allow businesses to create these tools in order to manipulate data for making informed business decisions. The focus is to examine what skills employers are…

This case describes a real-world scenario based on a fictional new commuter airline seeking to develop a database to support their operations. Students are asked to design and develop a database to allow the airline to track flights, passengers, bookings, and more, based on a set of business rules, default data, and other requirements. The case…

Data science has maintained its popularity for about 20 years. This study adopts a bottom-up approach to understand what data science is by analyzing the descriptions of courses offered by the data science programs in the United States. Through topic modeling, 14 topics are identified from the current curricula of 56 data science programs. These…

While working in the Social and Emotional Support Services (SESS) for Montgomery County Public Schools in Maryland (MCPS), the author initiated a project to collect data on services to students with emotional needs. During the 2016-2017 school year, MCPS was the 17th largest school district in the country with nearly 160,000 students speaking 150…

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…

The purpose of this study is to build a model for Digital Content Management (DCM) in agricultural university libraries in Bangladesh. The model focuses on identifying the necessary tools and techniques required for DCM and finding out the problems and prospects of DCM for enhancing resource sharing among the agricultural universities in…

The Center for the Integration of IDEA Data (CIID) Data Integration Toolkit is designed to support SEA [state education agency] efforts to integrate Individuals with Disabilities Education Act (IDEA) data with their statewide longitudinal data systems (SLDSs) and includes: (1) A sample road map articulating typical steps and tasks required for…