Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    What You Have Learned About Handling Data

    Uploaded by

    Aliyah Luhar

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    What You Have Learned About Handling Data

    Uploaded by

    Aliyah Luhar
    25 views1 page

    Original Title

    What you have learned about handling data

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    25 views1 page

    What You Have Learned About Handling Data

    Uploaded by

    Aliyah Luhar

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    What you have learned about

    handling data
    In this unit you have learned:
    ÎÎhow to store number values using a spreadsheet Activity Drinks for sports day
    ÎÎhow to use spreadsheet functions
    A teacher wants to give students drinks at the school sports day. She asks them
    ÎÎhow to create spreadsheet formulas what drink they like best. This spreadsheet shows their answers.
    using cell references
    ÎÎhow to make pie charts and bar charts
    that show your number values.
    The activities on this page will let you see
    how much you have learned.

    1 Make this spreadsheet.


    1 What does the AutoSum button do?
    2 Use a function to add up the total number of students.
    3 Use formulas to work out the percentage of students who chose each drink.

    3 Handling data: Working with values


    2 What symbol comes at the start of every spreadsheet formula?
    4 If you have time, make a chart to show the data.

    3 In this formula what does ‘E6’ mean? =E6/F6


    Activity Label the spreadsheet
    4 What fraction means the same as 33%?  rint out the spreadsheet you
    P
    made in the practical activity.
    5 Explain how a chart helps you to understand and compare number values. If you have not completed the
    activity, your teacher will give
    you this picture of a spreadsheet.
    Follow these instructions and write a label for each thing.
    1 Draw a circle round the data that was used to make the chart.
    6 Explain the difference between a pie chart and a bar chart. 2 Draw an arrow to the cell that shows the result of the Sum function.
    3 Draw an arrow to a cell that shows the result of a formula.
    51
    50 51
    4 Draw an arrow to the bar in the bar chart that shows how many students
    chose orange juice.

    © Oxford University Press 2015 © Oxford University Press 2015

    You might also like