Some documents for the S7 level in ICT.

Official syllabus:

It is the 2019 syllabus which is available at the following link.

How to program in PHP + MySQL:

1) Install the following softwares:
  * A PHP editor, e.g. https://netbeans.apache.org/ (or Visual Studio as on the school computers)
  * A PHP + SQL server, e.g. https://www.wampserver.com/ for Windows or https://www.mamp.info/en/downloads/ (select ``MAMP & MAMP PRO 6.6'', you probably have an Intel processor so select the Intel one).

a) Using WAMP (Windows Apache MySQL PHP):
  * Put any PHP file you want to test into C:/wamp64/www/.
  * Make sure wampserver is running and has opened a local PHP server (the ``W'' icon on the bottom right of your screen should be green).
  * Open your browser and type http://localhost/TP6_Exo1.php (or the name of your script) to test your php programs.
  * Open phpMyAdmin to update your database (click on the green ``W'' icon and then phpMyAdmin, 5.1.1).

b) Using MAMP (Mac Apache MySQL PHP):
  * Put any PHP file you want to test into /Applications/MAMP/htdocs/.
  * Make sure MAMP is running and has opened a local PHP server.
  * Open your browser and type http://localhost/TP6_Exo1.php (or the name of your script) to test your php programs.
  * Open phpMyAdmin to update your database (inside MAMP, click on ``WebStart'' and then MySQL, phpMyAdmin).

2) If you only test really simple PHP scripts (no SQL, no GET / POST), you can go online:
  * https://phpsandbox.io/
  * https://www.w3schools.com/php/phptryit.asp?filename=tryphp_compiler
  * https://sandbox.onlinephpfunctions.com/
  * https://paiza.io/en/projects/new

Documents:

Some of the documents shared in this section have been reproduced thanks to documents shared by other colleagues. Let them be thanked for eternity (and beyond). It is not easy to always create works ex nihilo, and their help was more than valuable.

11/09/2022:
  * Work1: HTML ; the associated files TP1_Basic.html and TP1_Errors.html.

18/09/2022:
  * Work2: Tables, CSS ; the associated files TP2_2019_BTest.html and TP2_images.zip (source: December 2019 B Test, Mr. Santos Pereira).

25/09/2022:
  * Work3: HTML Forms ; the associated image TP3_select_all_white.png.
  * Associated websites: https://www.mtgpics.com/search ; https://www.magic-ville.com/fr/rech_avancee ; http://www.barsamian.am/mathsexams/.

02/10/2023:
  * Teacher absent.

09/10/2023:
  * Work4: PHP ; the associated files TP4_Welcome.txt and TP4_Form.txt (open them to see the code, download and rename them to .php to use them).
  * The php file (we only seen the output, not the code!): TP4_Welcome.php.

16/10/2023:
  * Work5: PHP ; the associated files TP5_String_manipulation.txt and TP5_Variable_range.txt (open them to see the code, download and rename them to .php to use them).

23/10/2023:
  * Work6: PHP: group test ; the associated files: TP6_Exo1.txt and TP6_Exo2.txt (open them to see the code, download and rename them to .php to use them).
  * Work7: PHP: GET and POST; the associated files: TP7_Form.html (click to test the POST method), TP7_Post.txt (open it to see the code) and TP7_Get.php (click and modify the url to test the GET method), TP7_Get.txt (open it to see the code, download and rename it to .php to use it).

06/11/2023:
  * Pedagogical day: no course.

13/11/2023:
  * Install and use WAMP. Do the Work 7 on your fresh installation to test that everything works.
  * (For those who finish earlier) Work8: phpMyAdmin; the associated files: TP8_Library_database.sql and TP8_Php_sql_first.txt (open it to see the code, download and rename it to .php to use it).

20/11/2023-Up to prebac:
  * Semester 1 Project: Build your website from scratch.
  * During each course: bring your laptops, use WAMP / MAMP for your project.

22/01/2024 and 29/01/2024:
  * Two weeks of prebac.

05/02/2024 and 19/02/2024:
  * Oral presentation of your projects.

26/02/2024:
  * How to hack a website? SQL injection.

04/03/2024:
  * Graphs: a slideshow introduction.
  * Work9: Graphs (1/5); the associated Python code.

11/03/2024:
  * End of Work9.
  * Work10: Graphs (2/5); the associated Python code.

18/03/2024:
  * End of Work10.
  * The following Python code uses no external libraries and computes the derivative of a function that uses the variable "x", if we give its expression as a string. It is the compilation of our works 9 and 10, together with a parser (that converts the expression string to a Tree): derive.py. The fact that is uses no external library makes this program usable on your calculator (Numworks, TI 83 Premium CE Python).