Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
database lessons for middle school
1,222 views
Skip to first unread message
EDTECH Editor-Hogan
Mar 14, 2012, 9:56:43 AM3/14/12
to
From: "Lawsky" <law...@optonline.net>
Hi All,
Can anyone give me an idea of what you do to teach databases to middle
school students?
I usually have them create tables with their names and addresses and then
have them query the database.
I know I'm bored with this lesson. I'd appreciate it if you'd let me know
what you do to teach databases.
Thank you,
Diana Lawsky
computer education
North Bergen, NJ
law...@optonline.net
---
Edtech Archives, posting guidelines and other information are at:
http://www.h-net.msu.edu/~edweb
Please include your name, email address, and school or professional
affiliation in each posting.
To unsubscribe send the following command to: LIST...@H-NET.MSU.EDU
SIGNOFF EDTECH
Hi All,
Can anyone give me an idea of what you do to teach databases to middle
school students?
I usually have them create tables with their names and addresses and then
have them query the database.
I know I'm bored with this lesson. I'd appreciate it if you'd let me know
what you do to teach databases.
Thank you,
Diana Lawsky
computer education
North Bergen, NJ
law...@optonline.net
---
Edtech Archives, posting guidelines and other information are at:
http://www.h-net.msu.edu/~edweb
Please include your name, email address, and school or professional
affiliation in each posting.
To unsubscribe send the following command to: LIST...@H-NET.MSU.EDU
SIGNOFF EDTECH
EDTECH Editor-Hogan
Mar 14, 2012, 3:28:25 PM3/14/12
to
From: "Randy Edwards" <redw...@golgotha.net>
> Can anyone give me an idea of what you do to teach databases to middle
> school students? I usually have them create tables with their names and
> addresses and then have them query the database.
I'm not exactly sure what you're seeking/asking or why you're bored, but
here are a few ideas.
First, liven up the data. Names and addresses *are* boring. :-)
One gimmick I use is to have students manipulate casualty figures of WWII,
both military and civilian, and both dead and wounded. Then have the students
retrieve the data and graph it out in a pie chart. It's always an eye-opener
to see how much the USSR suffered in a graphical form.
Can you install a MySQL server on a machine? Doing that will allow you to
teach an overview of SQL queries and you can go as deep in SQL as you want.
Having the students access MySQL via telnet will also show the students
alternative ways of accessing the database, and many think that such
text-mode
queries/manipulation are really cool.
Regards,
.
Randy
--
Fast fact: The average person born in 1945 received two more years of
schooling than his parents. The average person born in 1975 received only
half
a year more of schooling than his parents. -- Timothy Noah
<http://www.slate.com/id/2266025/entry/2267384/>.
> Can anyone give me an idea of what you do to teach databases to middle
> school students? I usually have them create tables with their names and
> addresses and then have them query the database.
here are a few ideas.
First, liven up the data. Names and addresses *are* boring. :-)
One gimmick I use is to have students manipulate casualty figures of WWII,
both military and civilian, and both dead and wounded. Then have the students
retrieve the data and graph it out in a pie chart. It's always an eye-opener
to see how much the USSR suffered in a graphical form.
Can you install a MySQL server on a machine? Doing that will allow you to
teach an overview of SQL queries and you can go as deep in SQL as you want.
Having the students access MySQL via telnet will also show the students
alternative ways of accessing the database, and many think that such
text-mode
queries/manipulation are really cool.
Regards,
.
Randy
--
Fast fact: The average person born in 1945 received two more years of
schooling than his parents. The average person born in 1975 received only
half
a year more of schooling than his parents. -- Timothy Noah
<http://www.slate.com/id/2266025/entry/2267384/>.
EDTECH Editor-Hogan
Mar 14, 2012, 3:28:52 PM3/14/12
to
From: "Larry Phillips" <larrry....@gmail.com>
I had the class build a class spreadsheet with a variety of data items,
some numerical and some not. For the last iteration, I had the student
fabricate data. Fabricating data offered opportunities to discuss the
treatment of outliers and validating information. :)
The class data was used for graphing and filtering.
The spreadsheet was then imported to a regular database and queried.
For high school students, the database was turned into a relational
database.
--
Larry Phillips
FutureCraft
http://www.clubwebcanada.ca/l-pphillips/
Quantum 2000: Education for Today and Tomorrow
http://www.clubwebcanada.ca/l-pphillips/quantum
Finding a Way
http://findingaway.blogspot.com/
Alberta Consumers' Association
http://albertaconsumers.org
Conversations about education
Ed Conversation mailing list
http://www.topica.com/lists/edconversation/
edconversati...@topica.com
I had the class build a class spreadsheet with a variety of data items,
some numerical and some not. For the last iteration, I had the student
fabricate data. Fabricating data offered opportunities to discuss the
treatment of outliers and validating information. :)
The class data was used for graphing and filtering.
The spreadsheet was then imported to a regular database and queried.
For high school students, the database was turned into a relational
database.
--
Larry Phillips
FutureCraft
http://www.clubwebcanada.ca/l-pphillips/
Quantum 2000: Education for Today and Tomorrow
http://www.clubwebcanada.ca/l-pphillips/quantum
Finding a Way
http://findingaway.blogspot.com/
Alberta Consumers' Association
http://albertaconsumers.org
Conversations about education
Ed Conversation mailing list
http://www.topica.com/lists/edconversation/
edconversati...@topica.com
EDTECH Editor-Hogan
Mar 14, 2012, 3:29:24 PM3/14/12
to
From: "Judy Robison" <jrob...@saintjohnsprep.org>
It's been awhile, but I used to use some of the live data that NOAH
streamed and had students organize it into useful formats (I did not try
to keep the data live, just had them grab it at specific points in time -
like during class!) I'm not even sure what is available anymore, but live
data seemed to appeal to them.
Judith Claire Robison
Director of Technology
Saint John’s Catholic Prep
Frederick, MD
It's been awhile, but I used to use some of the live data that NOAH
streamed and had students organize it into useful formats (I did not try
to keep the data live, just had them grab it at specific points in time -
like during class!) I'm not even sure what is available anymore, but live
data seemed to appeal to them.
Judith Claire Robison
Director of Technology
Saint John’s Catholic Prep
Frederick, MD
EDTECH Editor-Hogan
Mar 14, 2012, 3:29:32 PM3/14/12
to
From: "Susan Gear" <SG...@bucyrusschools.org>
Hi Diana,
Try this--when I used to teach database we would play a game of "Guess
Who" using data about the teaching staff. First we would list all
teachers with the following fields:
last name
gender
subject
grade level
hair color
marital status
glasses/no glasses
facial hair-ex.-mustache, beard
I would allow students a couple of days to gather all the data.
When their database was complete I would put the names of all staff in a
hat and choose one. The students would have to ask me questions and then
using my answers, sort their databases. As they narrowed the choices down,
eventually they were able to correctly guess the answer. The students
seemed to enjoy it.
Another activity I would have them do is to bring in a list of their cds,
video games, or dvds from home and create a music or media library
database. We would use the following fields:
artist
name of album
recording company
year released
type of music--ex.--country, rap, pop, etc.
Another was the 50 states with the following fields:
state name
nickname
flower
motto
year became a state
Hope these ideas help.
Susie Gear
retired and loving it, middle school Computer Tech Teacher
Hi Diana,
Try this--when I used to teach database we would play a game of "Guess
Who" using data about the teaching staff. First we would list all
teachers with the following fields:
last name
gender
subject
grade level
hair color
marital status
glasses/no glasses
facial hair-ex.-mustache, beard
I would allow students a couple of days to gather all the data.
When their database was complete I would put the names of all staff in a
hat and choose one. The students would have to ask me questions and then
using my answers, sort their databases. As they narrowed the choices down,
eventually they were able to correctly guess the answer. The students
seemed to enjoy it.
Another activity I would have them do is to bring in a list of their cds,
video games, or dvds from home and create a music or media library
database. We would use the following fields:
artist
name of album
recording company
year released
type of music--ex.--country, rap, pop, etc.
Another was the 50 states with the following fields:
state name
nickname
flower
motto
year became a state
Hope these ideas help.
Susie Gear
retired and loving it, middle school Computer Tech Teacher
EDTECH Editor-Hogan
Mar 14, 2012, 3:29:39 PM3/14/12
to
From: "Jessica Meadows" <jes...@gcflearnfree.org>
Diana,
We have a series of database (Access specific) tutorials. They are created
for adults but you may be able to get something out of it to be able to
use in your classroom: http://www.gcflearnfree.org/access I especially
think the Introduction to Databases video is very cute and could be very
engaging: http://www.gcflearnfree.org/access2010/1.2
Let me know if there is anything we can do to help or if you have any
questions.
Jessica
Jessica Meadows, M.Ed.
Social Media Marketing Specialist
GCFLearnFree.org
828-7490 x 110
Join Us Online:
Website http://www.GCFLearnFree.org
Spanish Site http://www.GCFLatino.org
Blog: http://blog.gcflearnfree.org/
Twitter http://www.twitter.com/GCFLearnFree
Facebook http://www.facebook.com/GCFLearnFree.org
YouTube http://www.youtube.com/gcflearnfree
LinkedIn: http://www.linkedin.com/company/gcflearnfree-org
Google+: http://www.gplus.to/gcflearnfree
Diana,
We have a series of database (Access specific) tutorials. They are created
for adults but you may be able to get something out of it to be able to
use in your classroom: http://www.gcflearnfree.org/access I especially
think the Introduction to Databases video is very cute and could be very
engaging: http://www.gcflearnfree.org/access2010/1.2
Let me know if there is anything we can do to help or if you have any
questions.
Jessica
Jessica Meadows, M.Ed.
Social Media Marketing Specialist
GCFLearnFree.org
828-7490 x 110
Join Us Online:
Website http://www.GCFLearnFree.org
Spanish Site http://www.GCFLatino.org
Blog: http://blog.gcflearnfree.org/
Twitter http://www.twitter.com/GCFLearnFree
Facebook http://www.facebook.com/GCFLearnFree.org
YouTube http://www.youtube.com/gcflearnfree
LinkedIn: http://www.linkedin.com/company/gcflearnfree-org
Google+: http://www.gplus.to/gcflearnfree
EDTECH Editor-Hogan
Mar 14, 2012, 3:29:46 PM3/14/12
to
From: "Larry Phillips" <larrry....@gmail.com>
I had the class build a class spreadsheet with a variety of data items,
some numerical and some not. For the last iteration, I had the student
fabricate data. Fabricating data offered opportunities to discuss the
treatment of outliers and validating information. :)
The class data was used for graphing and filtering.
The spreadsheet was then imported to a regular database and queried.
For high school students, the database was turned into a relational
database.
I had the class build a class spreadsheet with a variety of data items,
some numerical and some not. For the last iteration, I had the student
fabricate data. Fabricating data offered opportunities to discuss the
treatment of outliers and validating information. :)
The class data was used for graphing and filtering.
The spreadsheet was then imported to a regular database and queried.
For high school students, the database was turned into a relational
database.
Larry Phillips
FutureCraft
http://www.clubwebcanada.ca/l-pphillips/
Quantum 2000: Education for Today and Tomorrow
http://www.clubwebcanada.ca/l-pphillips/quantum
Finding a Way
http://findingaway.blogspot.com/
Alberta Consumers' Association
http://albertaconsumers.org
Conversations about education
Ed Conversation mailing list
http://www.topica.com/lists/edconversation/
edconversati...@topica.com
FutureCraft
http://www.clubwebcanada.ca/l-pphillips/
Quantum 2000: Education for Today and Tomorrow
http://www.clubwebcanada.ca/l-pphillips/quantum
Finding a Way
http://findingaway.blogspot.com/
Alberta Consumers' Association
http://albertaconsumers.org
Conversations about education
Ed Conversation mailing list
http://www.topica.com/lists/edconversation/
edconversati...@topica.com
EDTECH Editor-Hogan
Mar 15, 2012, 11:45:29 AM3/15/12
to
From: "Harold Olejarz" <hole...@gmail.com>
Hi,
We do several projects with data and spreadsheets. Take a look at:
http://techteam7-1.pbworks.com/w/page/20332872/Data%20Analysis%20and%20Presentation
Harold
Harold Olejarz
Google Certified Teacher
Personal Website - www.digitalharold.com
Hi,
We do several projects with data and spreadsheets. Take a look at:
http://techteam7-1.pbworks.com/w/page/20332872/Data%20Analysis%20and%20Presentation
Harold
Harold Olejarz
Google Certified Teacher
Personal Website - www.digitalharold.com
EDTECH Editor-Hogan
Mar 15, 2012, 11:45:38 AM3/15/12
to
From: "al carfamily" <free...@yahoo.com>
This is a lesson I created that uses a spreadsheet to record historical
data. It could be easily modified for a data base and makes the lesson
integrated.
http://www.reacheverychild.com/lessonplans/plan9.html
Alan Haskvitz
National Teachers Hall of Fame
National and International Teacher of the Year
This is a lesson I created that uses a spreadsheet to record historical
data. It could be easily modified for a data base and makes the lesson
integrated.
http://www.reacheverychild.com/lessonplans/plan9.html
Alan Haskvitz
National Teachers Hall of Fame
National and International Teacher of the Year
EDTECH Editor-Hogan
Mar 15, 2012, 4:40:51 PM3/15/12
to
From: "Gordon Dahlby" <gda...@gmail.com>
You might try authentic databases of size and scale that the students rarely
see. Then ask some analysis questions.
For example data from CIAfactbook, or raw data from cities, counties, etc.
or departments of natural resources or weather. With 5-10K data points and
a dozen fields or such, students would get a good grasp on how to search and
filter data and then ask�how would one represent that to a given public.
Gordon
You might try authentic databases of size and scale that the students rarely
see. Then ask some analysis questions.
For example data from CIAfactbook, or raw data from cities, counties, etc.
or departments of natural resources or weather. With 5-10K data points and
a dozen fields or such, students would get a good grasp on how to search and
filter data and then ask�how would one represent that to a given public.
Gordon
0 new messages