3 Webpage to a Database_lesson_plan1

Short Term Plan

Long-term plan unit: 10.4А Web-development		School:
Date:		Teacher name:
Grade:		Number present:		absent:
The topic of the lesson:		Linking a Webpage to a Database
Learning objectives(s) that this lesson is contributing to		10.3.3.3 link a webpage to a database
Assessment criteria		• know what form is and how it is used. • know the elements of the form and attributes. • know the purpose of the button, methods and attributes of the button. • be able to create forms with examples
Success criteria		All learners will be able to know: • know what form is and how it is used. Most learners will be able to know: Know steps of methods of linking page Some learners will be able to know: Know and could link webpage to database without any help
Language objectives		*Useful phrases for dialogue / writing* • Website, webpage, HTML, CSS, tag, javascript, script, PHP • The script is used for ,,,, • The form is intended for ..., • Multiple selection drop-down menus ..., • The "Submit" button defines a button for ..., • The action attribute defines ..., • Method Attribute specifies the HTTP method (GET or POST) to be used ... • Always use POST if these forms contain ...
Value links		Group work , co-operation, time management
Cross curricular links		English
Previous learning		Tags, tables, scripts
Plan
Planned lesson stages	Planned activities				Resources
Beginning 0-1 2-3 3-13	Question for students: - Can you remember what we discussed in our previous lesson? Teacher: - I want (would like) to introduce today’s topic about …/ What do you think today’s topic is? The presentation of the theme and lesson objectives. *Fair of ideas.* Students demonstrate their sites. Students in pairs evaluate each other using the same evaluation criteria, and provide constructive feedback: 1. The webpage was divided into different parts using a div tag. 2. For the design of each block, the CSS style was correctly created. 3. Properly used HTML tags to create the structure of a web page. Students observe and leave stickers depending on the choice of the best design. Red, green, yellow. The teacher chooses himself, depending on which color and grade for the site. Discussing students gather in groups for a classmate whose site is best liked. Caffolding: teacher support for students to become aware of an intellectual “conflict”, to gain knowledge of the frontier of their knowledge and to advance the learning task by expanding these frontiers.				Presentation Stikers https://www.w3schools.com/howto/default.asp
Middle 14-24 24-34	Theory Teacher explain what form is. After that students and teacher do linking to database step by step Practical work. The formed groups begin to study the forms they like.				Appendix 1 https://www.youtube.com/watch?v=qm4Eih_2p-M https://myrusakov.ru/javascript-skripty.html appendix 2
The end of the lesson 35 - 40	At the end of the lesson, learners reflect on their learning: ✓ What has been learned ✓ What remained unclear ✓ What needs more attention
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 learners’ learning?		Health and safety check ICT links
Differentiation can be expressed in the selection of tasks, in the expected result from a particular student, in providing individual support to the student, in selecting the educational material and resources, taking into account the individual abilities of the students (Theory of Multiple Intelligence by Gardner). Differentiation can be used at any stage of the lesson, taking into account the rational use of time.			Use this section to record the methods that you will use to assess what the students have learned during the lesson.		Health and safety check links. Used active exercises. Items applied from the Safety Rules in this lesson.
Reflection Were the lesson objectives/learning objectives realistic? Did all learners achieve the LO? If not, why? Did my planned differentiation work well? Did I stick to timings? What changes did I make from my plan and why?			Use the space below to reflect on your lesson. Answer the most relevant questions from the box on the left about your lesson.

Summary evaluation What two things went really well (consider both teaching and learning)? 1: 2: What two things would have improved the lesson (consider both teaching and learning)? 1: 2: What have I learned from this lesson about the class or individuals that will inform my next lesson?

Appendix 1

Technically you cannot link HTML to a database as HTML is static — it cannot talk to a database.

HTML is a language to display elements in your browser and works client side only - -only on the browser.

The database sits on the server and as HTML is static it cannot connect and interact with the server.

However if on the server you have a programmable code such as PHP you can use this to carry instructions to and from the database and then output the appropriate HTML.

For example if your database has a table with a list of peoples’ first names, you can then do a search of the database with PHP for all names beginning with B and display them in HTML by outputting the appropriate HTML from PHP (PHP can write HTML).

So instead of having a web page called page.html, your PHP page would be called page.php and it would have code to search the database and then output the resulys to the browser. When you look at the code in the browser it will be static (there will be no PHP code there) as the code has been outputted by the PHP script to show only first names starting with B.

If you then add more names starting with the letter B to the database, the output of the page.php file will then show more first names with letter B’s

(https://www.quora.com/How-do-you-link-a-database-to-HTML)

Appendix 2

An HTML form with two input fields and one submit button:

<form action="/action_page.php" method="get">

First name: <input type="text" name="fname"><br>

Last name: <input type="text" name="lname"><br>

<input type="submit" value="Submit">

</form>

Definition and Usage

The <form> tag is used to create an HTML form for user input.

The <form> element can contain one or more of the following form elements:

<input>