1_Reports_lp_l2_v1

Long-term plan unit:

 10.3A Information Systems

School

Date:

Teacher name:

Grade: 10

Number present:

Grade:

The topic of the lesson:

Reports

Learning objectives(s) that this lesson is contributing to

  10.3.2.5 create reports using extracted data (SQL)

Assessment criteria

●        Create a report based on two tables using the Report Wizard tool.

Success criteria

All learners will be able to know:

create a report for data output

Language objectives

Students can:

create reports using extracted data

Vocabulary and terminology specific to the subject:

Forms, reports, Form Wizard, Report Wizard, Constructor.

Useful expressions for conversations and writing:

The report is intended for ...

Value links

Group work , co-operation, time management, academic integrity

Cross curricular links

English

Previous learning

 -

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

Beginning

0-2

Warm up

Definition of the topic.

Setting lesson objectives and success criteria

Middle

2-15

Divide into groups: 2 students, 6 groups

Purpose: mini project for 30 minutes

Topics of mini projects:

1. Library (publisher, books, issue and reader).

2. Toy shop (Manufacturer, toys, sale, buyer)

3. School (classes, pupils, curators, teachers)

Stages of development of project work.

Objective: to structure the basic concepts of a DBMS

• Create a table

• Create a relationship (One to Many, One to One, Many to Many)

Stages of development of project work. Requests, forms, report.

Objective: to structure the basic concepts of the DBMS. Selection of the necessary information. Visually convenient and attractive interface.

• Create queries (minimum 3)

• Create a form (form wizard)

• Create a report

Presentation

https://www.youtube.com/watch?v=MekzqZsSFeU

https://www.youtube.com/watch?v=9d4BPUpuUS8

End

 32-40

Reflection

The learners speak in a circle with one sentence, choosing the beginning of a phrase from the reflective screen on the board:

Today I found out ... it was interesting ...

it was hard ... I was doing the job ...

I realized that ... now I can ...

I felt that ... I acquired ...

I learned ... I did it ...

I could ... I will try ...

I was surprised ... he gave me a lesson for life ...

Cards

Differentiation – how do you plan to give more support? How do you plan to challenge the more able learners?

Assessment – how are you planning to check students’ learning?

Health and safety regulations

Additional support.

Work in pairs / groups - support for classmates.

Help the teacher, if required.

More capable learners can demonstrate aspects of their decisions that seem interesting / more complex to the other learners.

Answers questions and a session of answers.

Use questions when completing a task.

Use survey questions to understand the results / success of learners at each stage of the lesson.

Remind of some safety rules when working with computer equipment, for example, that you must be careful when installing the screen, keyboard and mouse; beware of wires, as they pose a threat to movement.