kopilkaurokov.ru - сайт для учителей

Создайте Ваш сайт учителя Курсы ПК и ППК Видеоуроки Олимпиады Вебинары для учителей

Designing a database

Нажмите, чтобы узнать подробности

Информатиканы ағылшын тілінде үйрену. (сабақ жоспары)

Просмотр содержимого документа
«Designing a database»



Subject: Informatics

Chapter : 2 Database Basics

School:

Theme: 2.2 Designing a database

Date:


Teacher s name:


Grade:9


Number present:


absent:


Learning objectives

Identify the date types

To explain and to know new terminology on topic the designing a database

Lesson objectives


All learners will be able to: to explained the designing a database.

Identify and practiced design a database

To discuss of date types and design a database

Language objective


To use new terminology during the lesson

To customise-баптау

To do list-жұмыстар тізімі

To resize-өлшемін өзгерту

Edge-шеті

To combine-біріктіру

Area-аудан

To break-бөлу

To scroll-айналдыру

Immediate-тез арада

Previous learning


What is a database?

Planned timings


Planned activities


Resources


Start

5 min









Main Part

30 min






















































End


Greeting.T greets learners

Checking up the homework

You’ll divide into 3 groups,then introduces to the learning objectives and asks to find out the topic of the lesson looking at the picture.

Presentationlessonobjectives

Let,s start new lesson with questions:

What is abest way to keep information about books at a library?

On previous chapter we talk about library and bookkeeper. How do you think what will be a good way to keep

Work in group with posters

1.GroupTo explain design a database

2.Group :To find the types of database data

3. Group :To make a database data

Group assessment



1st group

2nd group

3rd group

1

Use new vocabulary






3

Use own ideas




4

Speak clearly





Answering this questions identifies the content of the table and name of the table and the field types.

What is your aspect and events to be tracked and processed?

Which fields do you need to organize similar values and data?

Which type of data will you store in these fields?

Work in pairs.Work the book:

Complete the table.Write a group of characters reference

Number

Data|time

Currency

Hyperlink






Work in individual (жеке жұмыс)

Practical work:1 First of all take a piece of paper and try to plan field for your new table. Write the following fields o the paper: ID, name of book, author, Genre, Published date, Quantity ,popularity. Now try to identify what field types are required for the fields you have written. Draw the following table:

2 To draw your own database

3Choose one of the options below and try to make a database design. Discuss database designs with your classmates.Think about what fields can be used:

1Student registration form

2.computer Lab inventory

3.Music and movie store

Formative assessment(using geometrical shapes) No mistakes

1-2 mistakes3-4 mistakes


H ow do we build a new database?

Where do we use a table in daily life?



Interactive board

pictures







Poster,pictures







Informatics.Book.9grade




кесте


Worksheet


stickers

Assessment


Peer assessment. Group assessmentFormative assessment(using geometrical shapes)


Homework


Make at least 10 fields with different data types and apply them into your database.


presentation

Reflection


Ss are given stickers to write 3 sentences about what they have learnt today.







Получите в подарок сайт учителя

Предмет: Информатика

Категория: Планирование

Целевая аудитория: 9 класс

Скачать
Designing a database

Автор: Хасенова Гульбану Булатовна

Дата: 23.05.2020

Номер свидетельства: 551115

Похожие файлы

object(ArrayObject)#863 (1) {
  ["storage":"ArrayObject":private] => array(6) {
    ["title"] => string(83) "Science on the service of  mankind,урок по английскому языку "
    ["seo_title"] => string(61) "science-on-the-service-of-mankind-urok-po-anghliiskomu-iazyku"
    ["file_id"] => string(6) "188700"
    ["category_seo"] => string(15) "angliiskiyYazik"
    ["subcategory_seo"] => string(5) "uroki"
    ["date"] => string(10) "1426714157"
  }
}

Получите в подарок сайт учителя

Видеоуроки для учителей

Курсы для учителей

ПОЛУЧИТЕ СВИДЕТЕЛЬСТВО МГНОВЕННО

Добавить свою работу

* Свидетельство о публикации выдается БЕСПЛАТНО, СРАЗУ же после добавления Вами Вашей работы на сайт

Удобный поиск материалов для учителей

Ваш личный кабинет
Проверка свидетельства