Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 177 - CodePilot V5.0 C8
P. 177

    LAB LEARNING                                              21 st
                                                                                          Century   #Critical Thinking
                                                                                           Skills  #Technology Literacy
                            Analyse and interpret the data by performing the following tasks:
                            (a)   Enter the data for 5 students in an Excel worksheet. The columns should include Name,
                                 Age, Favourite Colour and Height (in cm).
                                                                  Sample Data

                                            Name          Age      Favourite Colour     Height (cm)
                                          Ava              12      Blue                      145
                                          Rohit            13      Green                     150
                                          Muskan           12      Red                       140
                                          Nitin            14      Yellow                    160
                                          Anika            13      Pink                      155

                            (b)   Create a column chart to visualise the heights of the students. Use the students’ names
                                 on the X-axis and their heights on the Y-axis.
                            (c)  Sort the data by age in ascending order (youngest to oldest).

                            (d)  Use the AVERAGE function in Excel to calculate the average age of the students.

                                       CODE CHECK                                                Century   #Critical Thinking
                                                                                                  21 st
                                                                                                  Skills  #Technology Literacy
                         A school is organising a Maths competition and wants to find out how many students are interested
                         in taking part. A survey was conducted among the 500 students in the school and the results are
                         shown in the pie chart alongside:                                                  Both Maths
                         Based on the given data, answer the following questions:                     22.2%  & Science
                                                                                          Only   44.4%
                         (a)   How many  students  (out  of 500)  are interested  in the   Maths      33.3%
                             Maths competition?                                                              Only
                                                                                                            Science
                         (b)   How many students are not interested in Maths at all?

                          SOCIAL SIGHT                                                            21 st
                                                                                                 Century   #Media Literacy
                                                                                                  Skills  #Social Interaction
                       Conduct a survey in your class to find out how students use Data Science tools in their daily lives such
                       as fitness apps, weather apps or shopping recommendations. Collect the responses and present a
                       visual summary using a pie chart or bar chart.

                      PEDAGOGY PATHWAYS

                      «    Explain the difference between structured, unstructured and semi-structured data with examples.

                      «     Explain the tools and technologies used in Data Science.

                                                                                                                      175
                                                                                                         Data Science

| 172 173 174 175 176 177 178 179 180 181 182 |