Lesson plan

Topicmea9b402ed87d3eaf_1528449000663_0Topic

A spreadsheet as a databasedatabasedatabase

Levelmea9b402ed87d3eaf_1528449084556_0Level

Second

Core curriculummea9b402ed87d3eaf_1528449076687_0Core curriculum

Grade VII and VIII

II. Programming and solving problems by using the computer and other digital devices. Using computer applications the student:

3) creates documents and presentations, including those in a cloud in order to solve problems and create papers from various fields (subjects), adjusts the format and the appearance of the research papers to their content/purpose and demonstrates the following skills:

c) performing calculations specified in the curriculum of various subjects within the scope of primary school and useful in everyday life and implementing selected algorithms in a spreadsheet: entering data in a worksheet table, using basic functions, using relative, absolute and mixed references, presenting data in the form of various charts, ordering and filteringfilteringfiltering data.

Timingmea9b402ed87d3eaf_1528449068082_0Timing

45 minutes

General objectivemea9b402ed87d3eaf_1528449523725_0General objective

Creating databases.

Specific objectivesmea9b402ed87d3eaf_1528449552113_0Specific objectives

1. Creating a database in a spreadsheet.

2. Organizing and filtering data.

Learning outcomesmea9b402ed87d3eaf_1528450430307_0Learning outcomes

The student:

- creates a database in a spreadsheet,

- performs operations on data in a table.

Methodsmea9b402ed87d3eaf_1528449534267_0Methods

1. Discussion.

2. Learning through observation.

Forms of workmea9b402ed87d3eaf_1528449514617_0Forms of work

1. Individual work.

2. Class work.

Lesson stages

Introductionmea9b402ed87d3eaf_1528450127855_0Introduction

The teacher initiates a short discussion.

People have been always collecting data. Its ways and methods change with the technological development. Nowadays data are collected in databases. The students give examples of databases they come across every day.

The students formulate the definition of a databasedatabasedatabase.

A database is a set of organized data associated with a specific issue.

What operations can be performed in a database?

Basically a database can be treated as a tool for:

- storingstoringstoring,
- browsingbrowsingbrowsing,
- searchingsearchingsearching,
- sortingsortingsorting information.

Proceduremea9b402ed87d3eaf_1528446435040_0Procedure

The simplest way of visualising the stored data is to organize them into tables. Begin creating a databasedatabasedatabase with designing it. It is important what data you want to store. It is crucial that particular columns (fields) contain data of the same type. Particular rows (records) store data referring to the values of the columns.

Creating a table in Excel facilitates managing and analysing data, and enables accessing the built‑in features of filteringfilteringfiltering, sorting and shading rows. It also enables using various formulas in the so called Total Row at the bottom of the table. You can create a table by using one of the two methods:

[Interactive graphics]

In both cases Excel displays the Create Table dialogue box, which enables specifying the range of cells in the table. After creating the table, you will see the Table Tools with the Design tab. By using the tools on the Design tab you can adjust or edit the table. You can enter data into the table directly in worksheet cells or by using a special data form.mea9b402ed87d3eaf_1527752256679_0In both cases Excel displays the Create Table dialogue box, which enables specifying the range of cells in the table. After creating the table, you will see the Table Tools with the Design tab. By using the tools on the Design tab you can adjust or edit the table. You can enter data into the table directly in worksheet cells or by using a special data form.

Task 1

In a spreadsheet, insert the table shown in the illustration by using one of the presented methods. Sort the students alphabetically in an ascending order, and then again by the recordrecordrecord numbers.

[Illustration 1]

The feature of creating data forms:

The Form buttonbuttonbutton is not included on the ribbon in Excel and if you want to use it, you must add it to the Quick Access Toolbar.

[Illustration 2]

After placing the cursor in any part of your table, select the Form buttonbuttonbutton. Excel will automatically create a data formdata formdata form for the selected table.

The data form contains buttons that enable:

- insertinginsertinginserting a new row,
- deletingdeletingdeleting an existing row,
- moving to the previous or next row,
- finding only rows that meet specified criteria.

Task 2

In a spreadsheet, create a data formdata formdata form for the table you used in the previous task. Practice the effect of the available buttons.

[Illustration 3]

Filtered data include only rows that meet the specified criteria, other rows are hidden. You can copy, find, edit, format and print the filtered data and create charts based on them.

Task 3

Find the filter commands in your programme for designing spreadsheets. Use the table from the previous task. Display all the persons:

- whose first name begins with A,
- who got the highest mark (A) in computer science,
- whose first name contains the letter J or M.

Lesson summarymea9b402ed87d3eaf_1528450119332_0Lesson summary

A table in which particular columns (fields) contain data of the same type, while rows (records) store data referring to the values of the columns can be treated as a tabular database. You can perform typical database operations on such a table, like sorting (organizing records in a specified order) or filtering (displaying records meeting specified criteria).mea9b402ed87d3eaf_1527752263647_0A table in which particular columns (fields) contain data of the same type, while rows (records) store data referring to the values of the columns can be treated as a tabular database. You can perform typical database operations on such a table, like sorting (organizing records in a specified order) or filtering (displaying records meeting specified criteria).

Selected words and expressions used in the lesson plan

browsingbrowsingbrowsing

buttonbuttonbutton

data formdata formdata form

databasedatabasedatabase

deletingdeletingdeleting

fieldfieldfield

filteringfilteringfiltering

insertinginsertinginserting

recordrecordrecord

searchingsearchingsearching

sortingsortingsorting

storingstoringstoring

mea9b402ed87d3eaf_1527752263647_0

mea9b402ed87d3eaf_1527752256679_0

mea9b402ed87d3eaf_1528449000663_0

mea9b402ed87d3eaf_1528449084556_0

mea9b402ed87d3eaf_1528449076687_0

mea9b402ed87d3eaf_1528449068082_0

mea9b402ed87d3eaf_1528449523725_0

mea9b402ed87d3eaf_1528449552113_0

mea9b402ed87d3eaf_1528450430307_0

mea9b402ed87d3eaf_1528449534267_0

mea9b402ed87d3eaf_1528449514617_0

mea9b402ed87d3eaf_1528450135461_0

mea9b402ed87d3eaf_1528450127855_0

mea9b402ed87d3eaf_1528446435040_0

mea9b402ed87d3eaf_1528450119332_0

database1

filtering1

storing1

browsing1

searching1

sorting1

record1

button1

data form1

inserting1

deleting1

field1

Scenariusz

Topicmea9b402ed87d3eaf_1528449000663_0Topic

Lesson stages

Selected words and expressions used in the lesson plan