# data_collection.docx - educw200

Data Management

Nov 30, 2012 (5 years and 7 months ago)

248 views

DATA COLLECTION and DATA ANALYSIS

Goals

1.

Discuss and address points of confusion that come up from completed lecture
worksheets

2.

Model a lesson that integrates personal productivity tools to promote student
learning

3.

Provide an opportunity for students to use a new
data recording and analysis

tool
and examine how it can be integrated into the classroom to achieve educational
goals

4.

Have students propose an activity for a specific subject specific case.

Time Line

Time

available: 115 minutes

Students enter lab and engage in discussion facilitated by AI. (15 minutes)

o

Focus of discussion is on the completed lecture worksheets

o

Why did students make the decisions they did?

o

What are likely challenges that would be faced w
hen implementing the
proposed approaches?

o

How could the challenges be addressed?

Model a technology integration lesson plan activity to learn a tool.

Use
different subject matters (multidisciplinary lessons)(try grouping them together).
(30
-
45 minutes)

o

First model how GNARly was applied

o

Show an example of how the approach translates into a learning
experience

Provide a list of tools. Students do workouts with a tool that's unfamiliar to them.
(30)

o

Use EDUCW200 Delicious site to gather bookmarks associated with
subject

specific websites

o

o

See presentation for more details

Activity 1
:

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
nd collected
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.
If
experiment with numbers without having to RE
-
DO all the calculations. You
can easily
organize your data in different ways.

decided to use Excel to record your data.

Data Recording:

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
,etc.

Data Analysis:

-

Calculate average of test scores

-

Graph average of grades of test scores across
classes

Activity 2

Several of the 5
th

grade Science standards states that s
t
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
Science standard
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

o

Instructor will prepare

a set of fictional data as a word document before the
lab.

o

Students fill columns in an Google Spread sheet, copy and paste data from
the word document.

o

Calculate average of weather variables, minimum and maximums.

o

Create graphs to demonstrate relationshi
ps among weather variables and
compare average weather variables in different months

Activity 3

Math and Science

o

adjusting them to meet the needs of the data
. Track family water use for

a
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.

o

Instructor explains the scenario and hav
e students create fictional data in a
spreadsheet to include water use of family members.

Microsoft Excel Tutorials:

1.

http://www.baycongroup.com/el0.htm

2.

http://www.usd.edu/trio/tut/excel/

3.

http://www.fgcu.edu/support/office2007/Excel/index.asp

4.

http://www.vertex42.com/Excel2007/excel
-
tutorial.htm

1.

http://computerworld.com/action/article.do?com
mand=printArticleBasic&articl
eId=9001087

Data collectio
n

Software
:

-

Microsoft
Excel

-

-

OpenOffice.org Calc

o

Gnumeric

o

o

ZCubes
-
Calci

o

Resolver One
[6]

Database Software
:

o

Microsoft Access

o

OpenOffice.org Base

o

Amiga Datastore

o

Alpha Five

o

o

Datawasp

o

dBase

o

FileMaker Pro

(formerly
Claris

Filemaker)

o

Kexi

o

Lotus Approach

o

NeoOffice

o

Oracle XE

(Express Edition)

o

Sun StarBase

o

Foxpro

(later acquir
ed by Microsoft)

o

SQLite

o

Sybase PowerBuilder

o

MySQL

o

PostgreSQL

o

Omnis Studio