data_collection.docx - educw200

perchmysteriousΔιαχείριση Δεδομένων

30 Νοε 2012 (πριν από 4 χρόνια και 8 μήνες)

221 εμφανίσεις

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

Teacher newsletter

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
you have your data in a spreadsheet, you can
experiment with numbers without having to RE
-
DO all the calculations. You
can easily
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.

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
want them to enter the data in a spreadsheet. Let’s open a Google spreadsheet.

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

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

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.

Lab Presentation: Not ready yet

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


Google spreadsheets Tutorial:

1.

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


Data collectio
n

Software
:

-

Microsoft
Excel

-

Google spreadsheets

-

OpenOffice.org Calc

o

Gnumeric


o

KSpread


o

ZCubes
-
Calci

o

Resolver One
[6]

Database Software
:

o

Microsoft Access

o

OpenOffice.org Base

o

Amiga Datastore


o

Alpha Five


o

Borland Paradox


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