ALEX Resources

Narrow Results:
Lesson Plans (1) A detailed description of the instruction for teaching one or more concepts or skills. Learning Activities (1) Building blocks of a lesson plan that include before, during, and after strategies to actively engage students in learning a concept or skill. Classroom Resources (2)


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 Learning Activities  
   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.
[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: Mathematics (3), Digital Literacy and Computer Science (3)
Title: Edmodo: Communication is Key
Description:

"Edmodo is where education meets innovation. Edmodo was created to bring education into a 21st century environment."

Description provided by: www.edmodo.com




ALEX Learning Activities: 1

Go To Top of page
ALEX Classroom Resources  
   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: 2

Go To Top of page