Page 56 - CT_AI_Class-7
P. 56
Arranging Data in Tables
One of the easiest ways to organise data is by using tables. Tables help you sort and compare
data quickly. When data is clearly laid out, it’s much easier to spot patterns and trends.
Tables make it easy to:
Compare values: You can quickly see which student has the highest or lowest marks in each
subject.
Identify patterns: Spot trends, such as which students are consistently doing well in both
subjects.
Prepare data for charts and graphs: You can create charts from tables to better visualise
the data.
Example:
Student Name Maths Marks Science Marks
Raj 85 78
Asha 92 88
Kiran 79 90
In this example, Asha scored the highest marks in both Maths and Science, while Raj scored the
lowest in both subjects. You could also use this table to create a bar chart showing the marks for
each student in each subject.
Preparing Data for Visualisation
Before creating charts or graphs, it’s important to clean and organise the data. If the data is
messy or disorganised, it can lead to incorrect results or misleading charts. Clean and well-
organised data is key to creating accurate and meaningful visualisations.
Here are the steps to clean and organise data:
Remove errors or duplicates: Check for mistakes or repeated information. For example, if a
student’s name appears twice with different marks, fix that.
Fill missing values: If data is missing, add or correct it. For example, if a student’s marks are
missing, ask the teacher for the correct score.
Remove errors or Fill missing Arrange data Group related
duplicates values in order items
54 Artificial Intelligence (CT & AI)-VII
