AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com

Communication Technology · Secondary 2

15/15 weeks ready · Follows the order of the Egyptian Ministry of Education and Technical Education textbook Information and Communication Technology – The Web Site Design Project, Second Year of Secondary School (Grade 11), Term 1 (English and Arabic editions, 3 units: Basics of Web Site Design, Requirements and Production Stages of the Project, Creating the Pages of the Illustrated Dictionary of Computer Terms site; the two editions have the same units, topics and code but different page layouts and a few different details). All explanations, exercises and quizzes are Darslab’s own.

Term 1Unit 1 Basics of Web Site Design (free and open-source programs, static and dynamic pages, servers, scripts, HTML, PHP, localhost and hosting, SQL, session; planning the dictionary site); Unit 2 Requirements and Production Stages (designing the site pages, relational databases: tables, keys, relationships, the Terms table); Unit 3 Creating the Site Pages (project folders, HTML pages and links, header page, PHP variables and constants, the database connection page, operators, if and switch, the Add Term page); review and own mini-project

1

Free programs, web pages and servers Unit 1 Basics of Web Site Design (1): the aim of the unit, free and open-source programs, static and dynamic web pages, servers and scripts

2

HTML, PHP, publishing and the session Unit 1 Basics of Web Site Design (2): HTML, PHP and the web server program, publishing (localhost or hosting), SQL and the database system, web-server packages, the session

3

Planning the illustrated dictionary site Unit 1 Basics of Web Site Design (3), Topic 2 Planning the Project Site: aim and importance, the list of tasks, the main page, hosting choices, folders and the three stages

4

Designing the site pages Unit 2 Requirements and Production Stages of the Project (1), Design web pages stage: the three stages, a scheme of the site pages, the job of each page, header and connection pages written once and included

5

Tables, fields and keys Unit 2 Requirements and Production Stages of the Project (2), Create database tables stage (1): database, table, record, field, field types and sizes, flat and relational databases, the primary key

6

Relationships between tables Unit 2 Requirements and Production Stages of the Project (3), Create database tables stage (2): relationships between tables: one to one, one to many, many to many, foreign and composite keys

7

The database program, the Terms table and SQL Unit 2 Requirements and Production Stages of the Project (4), Create database tables stage (3): the database program, tables and queries, the Terms table of the dictionary, the four SQL commands

8

Folders and the structure of HTML Unit 3 Creating Site Pages (1), Topic 1 PHP & HTML and the applications of designing web sites: project files and folders, the structure of an HTML page, saving and testing pages

9

Links, visual editors and the header page Unit 3 Creating Site Pages (2), Topic 1 (continued): linking pages, typing code or using a visual page editor, the header page with banner and menu

10

PHP basics: echo, variables and constants Unit 3 Creating Site Pages (3), Topic 1 (continued): PHP code in a page, echo and print, comments, variables, quotes and types, constants

11

The connection page Unit 3 Creating Site Pages (4), Topic 1 (end): the page that connects to the database: what a connection needs, reading a connection page, keeping secrets

12

Operators and the if statement Unit 3 Creating Site Pages (5), Topic 2 Operators and conditional statements in PHP: arithmetic, assignment, comparison and logical operators, if, else, elseif and the in-line if

13

switch, forms and the Add Term page Unit 3 Creating Site Pages (6), Topics 2–3: the switch statement; the Add_Term page: designing the form, GET and POST, form controls, including the header and connection pages

14

The Add Term code Unit 3 Creating Site Pages (7), Topic 3 Add_Term.php page: the short PHP code and what it lacks, the precise code with checks and messages, saving the record and checking the table

The Egyptian Ministry of Education and Technical Education (MOETE) is not affiliated with, and does not endorse, Darslab. Lessons follow the order of the Ministry’s textbooks; all explanations, exercises and quizzes are Darslab’s own. Pictures of animals, plants and objects: Twemoji, CC BY 4.0.