Page 55 - CT_AI_Class-7
P. 55
Spreadsheet Files
Spreadsheets store data in tables and allow you to perform
calculations, sort data and create charts.
Example: If you record your exam marks in a spreadsheet, you can
calculate your average grade and even create graphs to track your
progress.
Web and Mark-Up Files
Some data is stored in special formats for websites.
HTML files: Used to create web pages and display content.
XML files: Store data using labels to describe the information.
Example: A webpage like Wikipedia is created using an HTML
file, telling the computer what text and images to display.
Media Files
Media files store non-text information like images, videos and
audio.
Images: JPG, PNG, GIF
Videos: MP4, MOV
Audio: MP3, WAV
Example: When you take a photo with your phone, it is saved as a
JPG image.
Why Data Format Matters?
The format of data affects how easily it can be read, analysed and shared.
Reading data: Well-organised formats, like databases, allow for quick searching, while messy
data can be hard to read.
Analysing data: Organised formats like spreadsheets make analysis faster and easier. Messy
data takes longer to process.
Sharing data: Formats like CSV are easy to share between programs, while images or
unorganised data may be harder to use.
Example: If your grades are stored in a CSV file, your teacher can quickly open it in Excel,
calculate your average and compare your performance with others. This is much faster than
using handwritten records.
Organising Data for Analysis
Once you collect data, it must be organised properly. Disorganised data can be confusing and
hard to understand. Organising data helps you make sense of it and use it effectively.
Data Visualisation and Analysis 53
