Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Database Lesson Plan: Understanding Databases and Data Handling Software, Study notes of Human Rights

This lesson plan covers the importance of databases and the use of data handling software. Students will learn what a database is, the functions of data handling software, and the advantages of computer databases over paper-based ones. They will also discuss security and human rights issues related to the storage of personal data in computer databases.

Typology: Study notes

2021/2022

Uploaded on 09/12/2022

aramix
aramix 🇬🇧

4.5

(29)

368 documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Lesson Plan
Databases and the use
of data handling software
Teacher’s Notes
Time (min) Activity Further Notes
10 Using a projector, display the Interactive Starter Activity.
This is intended to illustrate the importance, ubiquity and
commercial value of databases.
It can be paused to discuss the points made.
10 Watch the set of videos pausing to discuss the content.
5 Discuss the videos to assess learning. Ask questions
such as:
• Whatisadatabase?
• Whatnameisgiventosoftwareapplicationsthat
assistusinmanipulatingdata?
• Whatdatabasemanipulationsdoesitassistwith?
A persistent and ordered collection of
data.
Datahandlingsoftware.
Creation of database, inserting and
importing data, interrogation, producing
forms and reports.
15 Pupils to complete Worksheet 1 either on paper or on a
computer.
Ask individual students for their responses and discuss
withtheclasssothatallstudentshavethecorrect
answers.
Answersprovided.
Askstudentswiththecorrectresponses
toexplaintotheclasshowtheyarrivedat
theiranswers.
15 The students use the Interactive Activity 1
Theyshouldworkthroughthequestions.
Extension Challenge/Homework
Students to complete and submit Worksheet 2 for
homework.
5Plenary
Using a projector display the Interactive Plenary
Activity.
Use this to initiate a discussion on the security and
human rights issues raised by the storage of personal
data in computer databases.
Length 60 mins Specification Link 2.1.5/a_b
Learning objective
Candidates should be able to:
(a) describe a database as a persistent organised store of data
(b)explaintheuseofdatahandlingsoftwaretocreate,maintainandinterrogateadatabase.
®
pf3
pf4

Partial preview of the text

Download Database Lesson Plan: Understanding Databases and Data Handling Software and more Study notes Human Rights in PDF only on Docsity!

Lesson Plan

Databases and the use

of data handling software

Teacher’s Notes

Time (min) Activity Further Notes 10 Using a projector, display the Interactive Starter Activity. This is intended to illustrate the importance, ubiquity and commercial value of databases. It can be paused to discuss the points made. 10 Watch the set of videos pausing to discuss the content. 5 Discuss the videos to assess learning. Ask questions such as:

  • What is a database?
  • What name is given to software applications that assist us in manipulating data?
  • What database manipulations does it assist with? A persistent and ordered collection of data. Data handling software. Creation of database, inserting and importing data, interrogation, producing forms and reports. 15 Pupils to complete Worksheet 1 either on paper or on a computer. Ask individual students for their responses and discuss with the class so that all students have the correct answers. Answers provided. Ask students with the correct responses to explain to the class how they arrived at their answers. 15 The students use the Interactive Activity 1 They should work through the questions. Extension Challenge/Homework Students to complete and submit Worksheet 2 for homework. 5 Plenary Using a projector display the Interactive Plenary Activity. Use this to initiate a discussion on the security and human rights issues raised by the storage of personal data in computer databases. Length 60 mins Specification Link 2.1.5/a_b Learning objective Candidates should be able to: (a) describe a database as a persistent organised store of data (b) explain the use of data handling software to create, maintain and interrogate a database.

(a) Explain what is meant by a ‘database’.

A database is a persistent and organised store of data.

(b) Give two examples of paper-based databases.

Telephone directory, encyclopaedia, address book, diary. Any suitable.

(a) Data handling software enables us to easily create and manage computer

databases. List the ways in which the software assists in data management.

Create data structure, enter and delete data, import data, interrogate the data,

update the data.

Creation of forms and reports.

(b) Make a list of the advantages of computer databases over paper-based ones.

You may need to carry out some research to find out all of the advantages.

Large databases take up far less space.

Quicker to interrogate the data.

Easily sort the data into any order.

Easy to edit the data – no messy crossing out.

Can print multiple copies.

Can attach to emails.

Can use for mail merge letters.

C) Why might data held in a computer database be less secure than paper-based

versions?

Harder to tell if the data has been changed.

Smaller physical size and easier to steal.

Easier to access – do not have to physically enter a building, office and/or filing cabinet.

Can be accessed from many computers on a network and from anywhere in the world if

it is online.

(a) Explain what is meant by a ‘database’. (2)

A persistent (1) and organised (1) collection of data.

(b) List three databases which may hold information about you and your family. (3)

Any suitable including:

School management system, banks and building societies, medical, libraries, shops, on

line merchants and service providers, government departments such as DVLA, HMRC,

DWP, police.

(a) What is the name given to software applications that assist users in maintaining

and using databases. (1)

Data handling software.

(b) List three database functions that the software assists with. (3)

Create data structure, enter and delete data, import data, interrogate the data, update

the data.