Thursday, Oct 17- 8th Grade Databases- Sorting and Filtering

Bellringer: 
1. Look on the board if your name  is on the board     work on the missing assignment. 
2. Go to http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
Choose exercise 6 and then click on the word "start."
Record you typing speed and accuracy on the form.
You must have 98% or higher accuracy.
3. Finish your NSA text based questions.

What are we learning?
Understand the basics of databases. 
How is database information used, organized, and managed in business? 
What formatting options are available when creating databases?

Guided Lesson: 
Intelligence gathering has occurred throughout history. 
New word "query"- A database query is a piece of code (a query)
that is sent to a database in order to get information back from
the database. Queries can be saved. You can also "filter" information
in a database to find information that meets certain conditions,
such as all students, who are older than 13 years old. 

@Physical sorting exercise

@Physical filtering exercise demonstrating the AND and OR connectors

@We will use the BB_Inns Database to sort and to do some simple filters.

Independent Activity:
The first database test will be on these questions.
 http://www.quia.com/rr/956502.html
There are some questions we covered today.

To put data in a particular order is to sort.

Ascending is small to large, A-Z order.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific 
criteria or condition is called a filter or query. 

 

Exit Activity: 
CIA code breaking

Code 3

https://www.cia.gov/kids-page/games/break-the-code