Difference between revisions of "ICT student textbook/Spreadsheet for data analysis"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | {{Navigate|Prev= | + | {{Navigate|Prev=Data representation and processing level 3|Curr=Spreadsheet for data analysis|Next=Multi page text document}} |
| − | + | ||
| − | ''' | + | '''<u><big>{{font color|brown|Analyzing data with spreadsheets}}</big></u>'''<br> |
| + | '''In this activity, you will have large data sets on different items and you will learn methods of analyzing with spreadsheets.''' | ||
<div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;"> | <div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;"> | ||
{| cellspacing="0" | {| cellspacing="0" | ||
| [[File:Book.jpg|none|80px|Book image]] | | [[File:Book.jpg|none|80px|Book image]] | ||
| − | | style="padding-left:2px;"| Go to <br/> [[ICT teacher handbook/Audio visual communication|Teacher | + | | style="padding-left:2px;" | Go to <br /> [[ICT teacher handbook/Audio visual communication|ICT Teacher Handbook]] |
|}</div> | |}</div> | ||
===Objectives=== | ===Objectives=== | ||
| − | # | + | #Using spreadsheet for data analysis |
| − | #Analyzing data and representing using charts and graphs | + | #Being able to identify how to group and view data |
| + | #Analyzing data and representing using charts and graphs; understanding what to analyze in a given data set | ||
| + | #Understanding the meaning of average, percentage difference, percentage share, growth rates, minimum and maximum and other such functionalities. | ||
| + | #Learning the use of different functionalities in spreadsheet for numerical analysis | ||
===What prior skills are assumed=== | ===What prior skills are assumed=== | ||
#Familiarity with ICT environment | #Familiarity with ICT environment | ||
| − | #Using spreadsheet | + | #Understanding of data organization |
| + | #Using spreadsheet for data inputs | ||
| + | #Making charts in spreadsheet | ||
| + | ===Resources needed=== | ||
| + | #Computer lab with projection equipment | ||
| + | #Student generated data sets | ||
| + | #Secondary data sets | ||
| + | #Handout for [[Learn LibreOffice Calc|LibreOffice Calc]] | ||
| + | #Handout for [[Learn LibreOffice Writer|LibreOffice Writer]] | ||
| + | ===Digital skills=== | ||
| + | #[[Learn LibreOffice Calc|Working with spreadsheets]] | ||
| + | #[[Learn LibreOffice Calc|Making plots and graphs]] | ||
| + | ===Description of activity with detailed steps=== | ||
| + | ====Teacher led activity ==== | ||
| + | '''''Analyzing data from tabulated data - Rainfall''''' | ||
| − | + | Your teacher will help you analyze the data of rainfall in Telangana, using available data. Click [[:File:Spreadsheet analysis teacher data file.ods|here]] for the file. Look at the data and discuss with your teacher what are the various data measures that can be calculated. For example, some questions from this data can be the following: | |
| + | #What is the maximum rainfall amount? Which year? | ||
| + | #What is the minimum rainfall amount? Which year? | ||
| + | #What is the average rainfall in the last ten years? | ||
| + | #Is there any pattern of rainfall? | ||
| + | #Are there other data that you can study along with this data to understand the weather and climate in Telangana? For example, what could be the connection between rainfall data and temperature, crop production or floods? | ||
| + | #Which is the best way to represent this data as a graph? Why? | ||
| + | #What are the additional data sets you would collect? | ||
| + | '''''Analyzing data from tabulated data - Temperature''''' | ||
| − | # | + | Your teacher already discussed the rainfall data with you. You may have wondered about temperature. In the attached file, alog with Telangana rainfall, you also have details of annual and seasonal, maximum and minimum temperature in India. Look at the data and discuss with your teacher what are the various data measures that can be calculated. Your questions may be: |
| − | # | + | #What is the maximum temperature by season? Which year was it? |
| − | # | + | #Which year had the highest maximum temperature? Is there any connection between the two? |
| − | # | + | #By how much does the maximum temperature vary across seasons? |
| + | #What is the difference between maximum and mean temperature? | ||
| + | #Which is the best way to represent this data as a graph? Why? | ||
| + | #What are the additional data sets you would collect? | ||
| + | #Can you conclude anything from this data set? | ||
| − | === | + | <gallery mode="packed" heights="300px" style="text-align:left"> |
| − | + | File:Rainfall data.png | |
| − | + | File:Annual and seasonal mean temperature.png | |
| + | </gallery> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
====Student activities==== | ====Student activities==== | ||
| + | Your teacher would have made different data sets for your analysis. Look in your folder on your computer for these data sets. For each of the data sets, identify how you would like to group the data, what to analyze, what measures are important to calculate (average, percentage share, percentage change, minimum, maximum, etc), and also plot the graphs. | ||
| + | #The Indian government conducts census, from time to time, to understand how the population is growing as well as to get some information on how the population is distributed. Would you not like to know about yourself? Check the file [[:File:Simplifed_Census_Data_India_and_Telangana.ods|here]] for the census data. | ||
| + | #Some data on fruits and flowers and some horticulture products grown in India have been compiled across 10 years. Analyze the data for yourself to see how much more you can learn about flowers and fruits! Click [[:File:Spreadsheet analysis student data file.ods|here]] for the file. | ||
| + | #You are so familiar with the cellphone. Would you like to see how India's cell phone use compares with the world. Click [[:File:Mobile Connections Spreadsheet Analysis Student data file.ods|here]] for the file. | ||
| + | #Another interesting data is on the number and types of vehicles on the road in India. See what kinds of analysis it is possible to make about this. Click [[:File:Spreadsheet analysis student data file.ods|here]] for the file. | ||
| + | |||
| + | <gallery mode="packed" heights="250px" style="text-align:left"> | ||
| + | File:Population data by gender and urban-rural composition.png | ||
| + | File:Number of vehicles on the road.png | ||
| + | </gallery> | ||
===Portfolio=== | ===Portfolio=== | ||
| − | # | + | #In your continuing portfolio, you should create your own spreadsheets with the analysis. |
| − | # | + | #Your portfolio should also include a text document with a written description of the analysis. |
| − | # | + | #Your concept map with highlights of your analysis for presentation. |
| + | |||
| + | [[Category:Level 3]] | ||
| + | [[Category:Data representation and processing]] | ||
Revision as of 12:16, 25 March 2017
Analyzing data with spreadsheets
In this activity, you will have large data sets on different items and you will learn methods of analyzing with spreadsheets.
Objectives
- Using spreadsheet for data analysis
- Being able to identify how to group and view data
- Analyzing data and representing using charts and graphs; understanding what to analyze in a given data set
- Understanding the meaning of average, percentage difference, percentage share, growth rates, minimum and maximum and other such functionalities.
- Learning the use of different functionalities in spreadsheet for numerical analysis
What prior skills are assumed
- Familiarity with ICT environment
- Understanding of data organization
- Using spreadsheet for data inputs
- Making charts in spreadsheet
Resources needed
- Computer lab with projection equipment
- Student generated data sets
- Secondary data sets
- Handout for LibreOffice Calc
- Handout for LibreOffice Writer
Digital skills
Description of activity with detailed steps
Teacher led activity
Analyzing data from tabulated data - Rainfall
Your teacher will help you analyze the data of rainfall in Telangana, using available data. Click here for the file. Look at the data and discuss with your teacher what are the various data measures that can be calculated. For example, some questions from this data can be the following:
- What is the maximum rainfall amount? Which year?
- What is the minimum rainfall amount? Which year?
- What is the average rainfall in the last ten years?
- Is there any pattern of rainfall?
- Are there other data that you can study along with this data to understand the weather and climate in Telangana? For example, what could be the connection between rainfall data and temperature, crop production or floods?
- Which is the best way to represent this data as a graph? Why?
- What are the additional data sets you would collect?
Analyzing data from tabulated data - Temperature
Your teacher already discussed the rainfall data with you. You may have wondered about temperature. In the attached file, alog with Telangana rainfall, you also have details of annual and seasonal, maximum and minimum temperature in India. Look at the data and discuss with your teacher what are the various data measures that can be calculated. Your questions may be:
- What is the maximum temperature by season? Which year was it?
- Which year had the highest maximum temperature? Is there any connection between the two?
- By how much does the maximum temperature vary across seasons?
- What is the difference between maximum and mean temperature?
- Which is the best way to represent this data as a graph? Why?
- What are the additional data sets you would collect?
- Can you conclude anything from this data set?
Student activities
Your teacher would have made different data sets for your analysis. Look in your folder on your computer for these data sets. For each of the data sets, identify how you would like to group the data, what to analyze, what measures are important to calculate (average, percentage share, percentage change, minimum, maximum, etc), and also plot the graphs.
- The Indian government conducts census, from time to time, to understand how the population is growing as well as to get some information on how the population is distributed. Would you not like to know about yourself? Check the file here for the census data.
- Some data on fruits and flowers and some horticulture products grown in India have been compiled across 10 years. Analyze the data for yourself to see how much more you can learn about flowers and fruits! Click here for the file.
- You are so familiar with the cellphone. Would you like to see how India's cell phone use compares with the world. Click here for the file.
- Another interesting data is on the number and types of vehicles on the road in India. See what kinds of analysis it is possible to make about this. Click here for the file.
- Population data by gender and urban-rural composition.png
- Number of vehicles on the road.png
Portfolio
- In your continuing portfolio, you should create your own spreadsheets with the analysis.
- Your portfolio should also include a text document with a written description of the analysis.
- Your concept map with highlights of your analysis for presentation.