1_Forms_lp_l1_v1

Long-term plan unit:

 10.3A Information Systems

School

Date:

Teacher name:

Grade: 10

Number present:

Grade:

The topic of the lesson:

Forms

Learning objectives(s) that this lesson is contributing to

10.3.2.4 create a form for data entry  (SQL)

Assessment criteria

●        creates a form based on a single table using the Form Wizard tool;

●        creates and saves a new record in the database using the form;

Success criteria

All learners will be able to know:

create a form for data entry

Language objectives

Students can:

Describe form concepts in databases

Vocabulary and terminology specific to the subject:

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

Useful expressions for conversations and writing:

To create a form you need ...

The form 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-15

Warm up

Definition of the topic.

Setting lesson objectives and success criteria

Definition. Students write definitions in a notebook:

A form in a database is an object with which we can add, edit, or display data that is stored in a database.

Middle

11-20

Division into groups. The teacher divides the class into groups of 3-4 people using the online service: https://castlots.org/razdelit-na-gruppy/ (on the slide, clicking on the picture will automatically open the website). Students need to make 2 false and 2 true statements in the group using information from the handout. Time to compile 5 minutes. Then they exchange with the other groups and solve their tasks, thus realizing mutual training. Then the learners conduct mutual evaluations and give feedback to other groups on the results of the assignment.

https://castlots.org/razdelit-na-gruppy/

Cards

Theoretical material

20-38

Practical work 1.

According to the instructions, students should create a form based on a single table using the Form Wizard. Having completed the task ahead of time, more capable students perform an additional task for practical work.

Relaxation. Students perform a physical exercise for 1.5 minutes.

End

 38-40

Reflection

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.