Merging Data Worksheet
Grade 7 Math worksheet on merging data, including identifying common fields, combining datasets, and analyzing merged information.
Includes
Standards
Topics
Merging Data Worksheet
Name:
Date:
Score:
Read each question carefully and provide the best answer. This worksheet focuses on understanding and merging data from different sources.
Scenario: A school wants to analyze student performance by combining data from two different sources: 'Student_Grades' and 'Student_Attendance'.
Student_Grades Table:
Student ID | Subject | Grade 101 | Math | 85 102 | Science | 92 101 | English | 78 103 | Math | 90 102 | History | 88
Student_Attendance Table:
Student ID | Days Absent | Days Tardy 101 | 3 | 1 102 | 1 | 0 103 | 2 | 2
1. What is the common field between the 'Student_Grades' and 'Student_Attendance' tables that would allow them to be merged?
Subject
Grade
Student ID
Days Absent
2. When merging two datasets, the common field used to link them is often called a .
3. Merging data allows us to get a more view of the information by combining related details.
4. If you merged the 'Student_Grades' and 'Student_Attendance' tables, what new insights could you potentially gain about student performance?
5. It is always possible to merge any two datasets, regardless of their content.
True
False
6. Imagine you have a third table named 'Student_Contact' with the following data:
Student_Contact Table: Student ID | Parent Name | Email 101 | Jane Doe | jane.doe@example.com 102 | John Smith | john.smith@example.com 104 | Alice Brown | alice.brown@example.com
If you wanted to merge 'Student_Grades' and 'Student_Contact', which student's grade data would NOT be included in the merged result if you performed an 'inner join' (meaning only records with matching IDs in BOTH tables are included)? Explain why.