MapStats/BasicQueries: Difference between revisions

From OLPC
Jump to navigation Jump to search
(New page: Image:MapStats4.png)
 
No edit summary
 
Line 1: Line 1:
The [[MapStats]] activity can introduce students to basic queries. Queries are used to read information out of a database.

A query can be made by selecting values from a list, then pressing Run.

[[Image:MapStats4.png]]
[[Image:MapStats4.png]]

The above query colors countries with any (ocean) coastline red. It can be run on any of the standard maps.

==Name Queries==
Each place has a name. You can use the query SELECT WHERE (name) IS (equal to) ( India ) to select India.

See what happens when you use (less than) or (greater than) with the (name) property.

Be aware: the Asia map may light up only part of some countries.

==Historical Queries==
Each country has a year of independence, and each state in the USA has two years (of becoming a US territory and becoming a state).

Be aware:
* SELECT WHERE (independence) IS (equal to) ( 1960 ) selects only countries which gained their independence in 1960.
* To select countries which gained independence by 1960, use (independence) IS (less than) ( 1961 )
* The (territory) year is when the land was acquired, not the same as when it became an official territory

The years chosen were collected from Wikipedia and other online sources - there is no political intent.

Latest revision as of 21:50, 20 May 2009

The MapStats activity can introduce students to basic queries. Queries are used to read information out of a database.

A query can be made by selecting values from a list, then pressing Run.

MapStats4.png

The above query colors countries with any (ocean) coastline red. It can be run on any of the standard maps.

Name Queries

Each place has a name. You can use the query SELECT WHERE (name) IS (equal to) ( India ) to select India.

See what happens when you use (less than) or (greater than) with the (name) property.

Be aware: the Asia map may light up only part of some countries.

Historical Queries

Each country has a year of independence, and each state in the USA has two years (of becoming a US territory and becoming a state).

Be aware:

  • SELECT WHERE (independence) IS (equal to) ( 1960 ) selects only countries which gained their independence in 1960.
  • To select countries which gained independence by 1960, use (independence) IS (less than) ( 1961 )
  • The (territory) year is when the land was acquired, not the same as when it became an official territory

The years chosen were collected from Wikipedia and other online sources - there is no political intent.