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
برامج حرة وصفحات الويب والخوادم 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
HTML وPHP والنشر والجلسة 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
تخطيط موقع القاموس المصوّر 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
تصميم صفحات الموقع 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
الجداول والحقول والمفاتيح 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
العلاقات بين الجداول 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
برنامج قاعدة البيانات وجدول المصطلحات ولغة 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
المجلدات وبنية صفحة 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
الروابط والمحررات المرئية وصفحة الترويسة 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
أساسيات PHP: echo والمتغيرات والثوابت Unit 3 Creating Site Pages (3), Topic 1 (continued): PHP code in a page, echo and print, comments, variables, quotes and types, constants
صفحة الاتصال بقاعدة البيانات 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
المعاملات وجملة if 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
switch والنماذج وصفحة إضافة مصطلح 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
كود صفحة إضافة مصطلح 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.