Basic HTML Version

|  | Table of Contents |  | View Full Version

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

| 50 51 52 53 54 55 56 57 58 59 60 |