use database filter and sort functions in microsoft access and excel to create fun, curriculum...
TRANSCRIPT
![Page 1: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/1.jpg)
Use database filter and sort functions in Use database filter and sort functions in Microsoft Access and Excel to create fun, Microsoft Access and Excel to create fun, curriculum driven projects for kidscurriculum driven projects for kids
By Sandy DounceBy Sandy DounceTechnology Integration Specialist (retired)Technology Integration Specialist (retired)
![Page 2: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/2.jpg)
• Technology Integration Specialist Computer Teacher – 21 years
• Technology curriculum design (Methacton & Philadelphia Archdiocese)
• Workshop presenter (Methacton, PETE&C , MEC Archdiocese of Philadelphia, and Montgomery County Intermediate Unit)
• Author/co-author of various journal articles• Author of Database Magic: Using Databases to Teach
Curriculum in Grades 4-12 (ISTE, 2008)• Teacher certification in PA (Elem. & Instructional
Technology),• BA in French, MA (Student Personnel Work)• Additional courses in math & computer programming• Please see my WIKIS for presentations and more classroom
projects http://Ingegrate–Tech.wikispaces.com
http://Databasemagic.wikispaces.com E-Mail [email protected]
2
![Page 3: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/3.jpg)
3
Scientific researchStatistical analysis LibrariesGovernmentLaw enforcement
Forensic scienceComputer programmingEngineering AnalysisNatural disastersBusinesses
Using database sort & filter functions …Using database sort & filter functions … •requires following directions•encourages critical thinking/problem-solving•provides opportunities for statistical analysis•gives students practice at finding facts quickly•fosters cooperative learning
Databases Are Used Everywhere
![Page 4: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/4.jpg)
Example:Database File Title: The 50 States
Record: Arizona Field Names: State name, Capital, population, state bird, state tree, state flower, famous people, important dates, etc. 4
![Page 5: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/5.jpg)
.Form –
List –
5
View A Database View A Database as a …
State Capital Location Pop. P. Rank Park, Trails, etc
AlabamaMontgomery South 4500752 23Gulf Islands National Seashore
Alaska Juneau West 648818 47Denali; Gates Of The Arctic N.P.
Arizona Phoenix S. west 5580811 18Grand Canyon, Petrified Forest N.P.,
ArkansasLittle Rock South 2725714 32Hot Springs N.P.
![Page 6: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/6.jpg)
Sort data by field Filter data using several fields
(queries)
Create reports using sort and/or filter functions to analyze data (using calculations)
Organize & summarize scientific & business data (including calculations)
Print a list or one record per pageMerge data into a word processor 6
![Page 7: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/7.jpg)
The sort & filter functions are data-collecting tools. The resulting statistics can be used by students to analyze data and answer questions or solve problems.
We will be looking at a database on Ancient Western Civilizations to create and analyze statistics.
7
![Page 8: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/8.jpg)
8
Use the advanced filter icon (Access 97-2003)
Click the pull-down in Advanced to select the advanced filter in (2007-2010)
![Page 9: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/9.jpg)
9
OccupationOccupation GreekGreek RomanRoman
EmperorEmperor 00 1212
LeaderLeader 66 1010
PhilosopherPhilosopher 99 11
GeneralGeneral 55 1111
WriterWriter 1515 1717
DictatorDictator 00 22
MathematicianMathematician 66 00
![Page 10: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/10.jpg)
Based on the statistics created using filtering techniques answer these questions:
Which civilization appears to be more interested in education?
Which has a stronger government?
Which is more war-like?Why might the database be inaccurate? 10
![Page 11: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/11.jpg)
11
InventionField used Name
Birth Death
Made Processing sugar faster & safer
facts1806-1894
Devised an Irrigation System
facts1731-1806
first name Elijah McCoy 184-1929
Process for straightening hair
facts1867-1919
last name Frederick Jones 1892-1961
Norbert Rillieux
Benjamin Banneker
Steam engine lubricator
Madame C.J. Walker
40 patents in the field of refrigeration
![Page 12: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/12.jpg)
Database filters allow students to gather data from several fields. analyze the data, and solve a problem.
ProblemYou work for the State Department and are in charge of giving aid to countries in South America that are not prosperous.
12
![Page 13: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/13.jpg)
13
(Prosperous – successful, well-to-do, comfortable)
![Page 14: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/14.jpg)
14
Life Expectancy
- % urban
-Literacy rate
-per capita income
![Page 15: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/15.jpg)
First, use filters on the Geography Database to determine which countries are prosperous.
15
Next, analyze the data. What do youNext, analyze the data. What do you notice about the lists in each field younotice about the lists in each field you searched?searched?List the countries that need helpList the countries that need help
![Page 16: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/16.jpg)
16
Literacy RateLiteracy Rate Life Expectancy % Urban Per Capita Income
Guyana Chile Uruguay Argentina
Uruguay French Guiana Argentina Chile
Argentina Uruguay Chile Uruguay
Chile Argentina Venezuela Brazil
Susriname Paraguay Brazil Venezuela
Paraguay Venezuela French Guiana Colombia
![Page 17: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/17.jpg)
Discuss the relationship between the 4 statistics searched. (literacy, urbanization, income, and life expectancy)
Simpler questions for younger students: Why would people who know how to
read live in cities? Why would people who are educated
live longer?17
![Page 18: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/18.jpg)
18
![Page 19: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/19.jpg)
19
You are a landscape architect. You have a client who has an ugly 4 foot tall fence that she wants to cover. She likes red flowers. You want to cove the fence as much of the year as possible.
Use the gardening database to find the flowers.
![Page 20: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/20.jpg)
Databases can do various mathematical calculations.
When creating a report number fields can be averaged or a sum found. Records can also be counted.
20
![Page 21: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/21.jpg)
Example:Where in the World is Mrs. Dounce?
Fields needed :Continent, Country, Cities, Climate, Exports, Languages, Special Facts, and Waterways
21
![Page 22: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/22.jpg)
22
Denmark, EurGr. Britain, Eur
Panama, NAVenezuela, SATrinidad-TobagoBrazil, SA
Argentina, SANigeria, Afr.
Senegal, Afr.Morocco, Afr.Spain, PortugalNetherlands,Eur.
Ireland
DenmarkG. Britain
![Page 23: Use database filter and sort functions in Microsoft Access and Excel to create fun, curriculum driven projects for kids By Sandy Dounce Technology Integration](https://reader031.vdocuments.us/reader031/viewer/2022032707/56649e3a5503460f94b2b8cb/html5/thumbnails/23.jpg)
Once teachers learn to use databases, they can let their imaginations go wild and create challenging and fun lessons in all curriculum areas.
23