DATA COLLECTION and DATA ANALYSIS
Discuss and address points of confusion that come up from completed lecture
Model a lesson that integrates personal productivity tools to promote student
Provide an opportunity for students to use a new
data recording and analysis
and examine how it can be integrated into the classroom to achieve educational
Have students propose an activity for a specific subject specific case.
available: 115 minutes
Students enter lab and engage in discussion facilitated by AI. (15 minutes)
Focus of discussion is on the completed lecture worksheets
Why did students make the decisions they did?
What are likely challenges that would be faced w
hen implementing the
How could the challenges be addressed?
Model a technology integration lesson plan activity to learn a tool.
different subject matters (multidisciplinary lessons)(try grouping them together).
First model how GNARly was applied
Show an example of how the approach translates into a learning
Provide a list of tools. Students do workouts with a tool that's unfamiliar to them.
Use EDUCW200 Delicious site to gather bookmarks associated with
See presentation for more details
You have just started to teach your future class. In order to decide some of the activities
you will do or in order to get some background info to design your future classes more
appropriately for your class you prepared a questionnaire for your students a
some data that will help you. Now it is time to record the data to your database. Later,
you will use them as you need.
you have your data in a spreadsheet, you can
experiment with numbers without having to RE
DO all the calculations. You
organize your data in different ways.
Both your home computer and your computer in your class have Microsoft Excel so you
decided to use Excel to record your data.
Instructor will have students launch Microsoft Excel. Explain th
at a major strength of
Excel is that you can perform mathematical calculations and format your data.
Instructor and students type categories in the first row and enter some fictional
data in the below cells.
Then have the students open an existing spreadsh
eet with the data collected
from a questionnaire.
Demonstrate and explain how to freeze panes, manipulate data, modify a
worksheet, sort and filter data
Calculate average of test scores
Graph average of grades of test scores across
Several of the 5
grade Science standards states that s
udents will be able to identify
processes all scientists use, such as collection of relevant evidence, the use of logical
reasoning in order to make sense of t
he evidence. The
s also include
that students learn how to calculate mean and median of a set of data. As you think, it
will be very difficult and time consuming to calculate means and medians of a large
amount of data for students. For instance, you want y
our students to record weather
data and analyze it in several ways.
Let’s assume that your students already collected the weather data in a document. You
want them to enter the data in a spreadsheet. Let’s open a Google spreadsheet.
Instructor will prepare
a set of fictional data as a word document before the
Students fill columns in an Google Spread sheet, copy and paste data from
the word document.
Calculate average of weather variables, minimum and maximums.
Create graphs to demonstrate relationshi
ps among weather variables and
compare average weather variables in different months
Math and Science
Fourth and fifth graders are ready to begin creating spreadsheets and
adjusting them to meet the needs of the data
. Track family water use for
week, combine class data into a spreadsheet, calculate totals, and
averages. If each family used this much water every week, calculate totals
for the year. Use data to estimate water use for the whole city, etc.
Instructor explains the scenario and hav
e students create fictional data in a
spreadsheet to include water use of family members.
Lab Presentation: Not ready yet
Microsoft Excel Tutorials:
Google spreadsheets Tutorial:
ed by Microsoft)