ICT student textbook/Spreadsheet for data analysis - Revision history

Yogi: 1 revision imported: from troer

2017-06-28T09:04:24Z

1 revision imported: from troer

Ranjani: /* Student activities */

2017-06-11T18:06:51Z

Student activities

Yogi: 1 revision imported

2017-05-17T12:41:34Z

1 revision imported

Harish at 06:46, 25 March 2017

2017-03-25T06:46:33Z

Ranjani at 10:14, 23 November 2016

2016-11-23T10:14:13Z

Ranjani at 10:00, 23 November 2016

2016-11-23T10:00:08Z

Ranjani: Created page with "{{Navigate|Prev=Text document with data analysis|Curr=Spreadsheet for data analysis|Next=Multi page text document}}"

2016-10-15T06:32:37Z

Created page with "{{Navigate|Prev=Text document with data analysis|Curr=Spreadsheet for data analysis|Next=Multi page text document}}"

New page

{{Navigate|Prev=Text document with data analysis|Curr=Spreadsheet for data analysis|Next=Multi page text document}}

@@ Line 10: / Line 10: @@
 ===Objectives===
-#Using spreadsheet for data analysis
+#Using a 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
@@ Line 21: / Line 21: @@
 #Using spreadsheet for data inputs
 #Making charts in spreadsheet
-===Resources needed===
+===What resources do you need===
-#Computer lab with projection equipment
+# Working computer lab with [[Explore a computer|projector]]
 #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]]
@@ Line 44: / Line 46: @@
 '''''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:
+Your teacher already discussed the rainfall data with you.  You may have wondered about temperature.  In the attached file (above), along 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?
@@ Line 50: / Line 52: @@
 #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?
+#What additional data sets would you collect?
 #Can you conclude anything from this data set?
@@ Line 60: / Line 62: @@
 ====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.
+#From time to time, 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.
+#Another interesting data is on the number and types of vehicles on the road in India.  See what kinds of analysis is possible with this data. Click [[:File:Spreadsheet analysis student data file.ods|here]] for the file.
 ===Portfolio===

@@ Line 1: / Line 1: @@
-{{Navigate|Prev=Text document with data analysis|Curr=Spreadsheet for data analysis|Next=Multi page text document}}
+{{Navigate|Prev=Data representation and processing level 3|Curr=Spreadsheet for data analysis|Next=Multi page text document}}
-Identification of data sets pending - suggestions from core group requested
-'''Title of Activity'''
+'''<u><big>{{font color|brown|Analyzing data with spreadsheets}}</big></u>'''<br>
 <div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;">
 {| cellspacing="0"
 | [[File:Book.jpg|none|80px|Book image]]
-| style="padding-left:2px;"| Go to <br/> [[ICT teacher handbook/Audio visual communication|Teacher Transaction Notes]]
+| style="padding-left:2px;" | Go to <br /> [[ICT teacher handbook/Audio visual communication|ICT Teacher Handbook]]
 |}</div>
 ===Objectives===
-#Ability to use spreadsheet for data analysis
+#Using spreadsheet for data analysis
-#Analyzing data and representing using charts and graphs
+#Being able to identify how to group and view data
 ===What prior skills are assumed===
 #Familiarity with ICT environment
-#Using spreadsheet
+#Understanding of data organization
-===Resources needed ===
+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:
+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?
-===Digital skills===
+<gallery mode="packed" heights="300px" style="text-align:left">
+File:Rainfall data.png
+File:Annual and seasonal mean temperature.png
 ====Student activities====
 ===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.

@@ Line 8: / Line 8: @@
 |}</div>
-=Objectives=
+===Objectives===
+#Ability to use spreadsheet for data analysis
+#Analyzing data and representing using charts and graphs
-−
+===What prior skills are assumed===
+#
+#
@@ Line 26: / Line 23: @@
+#
-=Digital skills=
+===Digital skills===
+#
+#
-=Description of activity with detailed steps=
+===Description of activity with detailed steps===
-==Teacher led activity==
+====Teacher led activity====
+#
+#
@@ Line 45: / Line 40: @@
 ##
 ##
-==Student activities==
+====Student activities====
-=Portfolio=
+===Portfolio===
+#
+#
+#

← Older revision		Revision as of 10:00, 23 November 2016
Line 1:		Line 1:
	{{Navigate\|Prev=Text document with data analysis\|Curr=Spreadsheet for data analysis\|Next=Multi page text document}}		{{Navigate\|Prev=Text document with data analysis\|Curr=Spreadsheet for data analysis\|Next=Multi page text document}}
		+	Identification of data sets pending - suggestions from core group requested
		+	'''Title of Activity'''
		+	<div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;">
		+	{\| cellspacing="0"
		+	\| [[File:Book.jpg\|none\|80px\|Book image]]
		+	\| style="padding-left:2px;"\| Go to <br/> [[ICT teacher handbook/Audio visual communication\|Teacher Transaction Notes]]
		+	\|}</div>
		+
		+	=Objectives=
		+	#
		+	#
		+	#
		+	#
		+
		+	=What prior skills are assumed=
		+	#
		+	#
		+	#
		+	#
		+	=Resources needed =
		+	'''Hardware, software, Files'''
		+	#
		+	#
		+	#
		+	#
		+
		+	=Digital skills=
		+	#
		+	#
		+	#Link to tool page as needed
		+	#Link to tool page as needed
		+
		+	=Description of activity with detailed steps=
		+	==Teacher led activity==
		+	#
		+	#
		+	#
		+	#
		+	##
		+	##
		+	##
		+	##
		+	#
		+	##
		+	##
		+	==Student activities==
		+
		+	=Portfolio=
		+	#
		+	#
		+	#
		+
		+	=How to use the template=
		+	#<nowiki>{{subst:ICT-Project}}</nowiki>
		+	#After the template is inserted go to the side box syntax and add the corresponding chapter link from the teacher handbook
		+	Add a link to the Teacher Handbook

← Older revision	Revision as of 09:04, 28 June 2017
(No difference)

← Older revision	Revision as of 12:41, 17 May 2017
(No difference)