ALEX Resources

Narrow Results:
Lesson Plans (1) A detailed description of the instruction for teaching one or more concepts or skills. Classroom Resources (3)


ALEX Lesson Plans  
   View Standards     Standard(s): [MA2019] (3) 16 :
16. For a given or collected set of data, create a scaled (one-to-many) picture graph and scaled bar graph to represent a data set with several categories.

a. Determine a simple probability from a context that includes a picture.

b. Solve one- and two-step "how many more" and "how many less" problems using information presented in scaled graphs.
[SC2015] (3) 14 :
14 ) Collect information from a variety of sources to describe climates in different regions of the world.

[DLIT] (3) 23 :
17) Describe examples of data sets or databases from everyday life.

Examples: Library catalogs, school records, telephone directories, or contact lists.

[DLIT] (3) 5 :
R5) Locate and curate information from digital sources to answer research questions.

Subject: Digital Literacy and Computer Science (3), or Mathematics (3), or Science (3)
Title: Is My State at Risk for a Tornado?
Description:

This is a third-grade math lesson on the topic of tornadoes and natural disasters. Students will enter data from an internet search on the number of tornadoes occurring in each state into a spreadsheet. Students will analyze and determine which states are the most active in tornado occurrences and create bar graphs and a scaled picture graph from the data collected. 

This unit was created as part of the ALEX Interdisciplinary Resource Development Summit.




ALEX Classroom Resources  
   View Standards     Standard(s): [SC2015] (5) 16 :
16 ) Collect and organize scientific ideas that individuals and communities can use to protect Earth's natural resources and its environment (e.g., terracing land to prevent soil erosion, utilizing no-till farming to improve soil fertility, regulating emissions from factories and automobiles to reduce air pollution, recycling to reduce overuse of landfill areas).

[SC2015] ES6 (6) 15 :
15 ) Analyze evidence (e.g., databases on human populations, rates of consumption of food and other natural resources) to explain how changes in human population, per capita consumption of natural resources, and other human activities (e.g., land use, resource development, water and air pollution, urbanization) affect Earth's systems.

[DLIT] (1) 20 :
14) Discuss the purpose of collecting and organizing data.

[DLIT] (3) 23 :
17) Describe examples of data sets or databases from everyday life.

Examples: Library catalogs, school records, telephone directories, or contact lists.

Subject: Science (5 - 6), Digital Literacy and Computer Science (1 - 3)
Title: Steve Trash Science: Who Let the Cows Out / Day-tuh vs Dat-uh
URL: https://www.pbs.org/video/who-let-the-cows-out-day-tuh-vs-dat-uh-cowuav/
Description:

Steve Trash teaches kids about science with fun and magic. The show is filmed in Alabama.

Water pollution is never good. It’s even worse when your neighborhood cow is making it. Steve discusses the many ways that farmers and ranchers work to keep streams and ponds free of pollution as one example of how everyone can play a role. Then Steve delves into how scientists collect and use data.



   View Standards     Standard(s): [DLIT] (3) 23 :
17) Describe examples of data sets or databases from everyday life.

Examples: Library catalogs, school records, telephone directories, or contact lists.

[DLIT] (6) 26 :
20) Identify data transferring protocols, visualization, and the purpose of data and methods of storage.

Examples: Using an online collection tool or form to collect data that is then stored in a spreadsheet or database.

[DLIT] (7) 28 :
22) Compare data storage structures.

Examples: Stack, array, queue, table, database.

[DLIT] (8) 27 :
21) Differentiate types of data storage and apply most efficient structure.

Examples: Stack, array, queue, table, database.

Subject: Digital Literacy and Computer Science (3 - 8)
Title: Databases
URL: https://classic.csunplugged.org/databases/
Description:

This activity provides several ways to introduce students to databases, with follow-up lesson extensions for increasing database understanding. 

This report gives details of a series of computing lessons designed to relate fundamental concepts of database use and design to children in Primary and Secondary Education (ages of 6 to 16). The skills and concepts developed in these lessons begin at a very simple level but progress to cover abstract concepts such as Relational Databases. The series has been aligned to match the scope, range and targets recommended in the Computing At Schools document A Curriculum for Computing.

Contents:

This activity concludes with a “plugged-in” activity using a database system. The Digital Schoolhouse Database Detectives lesson is aimed at Key Stage 2 pupils and based on the book Certain Death by Tanya Landman. Before completing the series of database unplugged activities, the class teacher is encouraged to read the book (except the last chapter) and complete a series of encryption activities loosely based on the book, the answers providing pupils with the clues to question the database and identify the murderer.

Pupils use cloud computing technology e.g. Google Documents: Spreadsheets, to collaboratively input data about the suspects from profile cards based on the book. Pupils then perform verification on their neighbor’s data entry before downloading the spreadsheet and importing it into Microsoft Access. After importing the data, pupils first use the filter tool to solve the murder using the answers from the numeracy challenges, then create a report for the Court based on a query identifying the murderer.



   View Standards     Standard(s): [DLIT] (3) 23 :
17) Describe examples of data sets or databases from everyday life.

Examples: Library catalogs, school records, telephone directories, or contact lists.

Subject: Digital Literacy and Computer Science (3)
Title: What Is a Database?
URL: https://www.bbc.com/bitesize/articles/z8yk87h
Description:

This webpage provides students informational text and interactive tools to explore what makes a database. Students will be introduced to basic database structures. 

A database is a computerized system that makes it easy to search, select, and store information. Databases are used in many different places.

Your school might use a database to store information about attendance or to store pupils' and teachers' contact information. A database like this will probably be protected with a password to make sure that people’s personal information is kept safe. Your library might also use a database to keep track of which books are available and which are on loan.



ALEX Classroom Resources: 3

Go To Top of page