In this video i solve the complete Cambridge IGCSE ICT 0417 March 2022 practical paper 31
A great resource for all students taking this exam. A link to the question paper and source files can be found at the bottom of the description.

0:00 Intro
----------------------------

Task 1
1:21 Checking files and creating evidence document
----------------------------

Task2
2:53 File management
----------------------------

Task3 Web design
6:18 Q2 Analyzing the question
7:40 Q2 creating a table, properties, merging cells
12:37 Q3 Html Title
13:14 Q4 Default target window (what is it?)
14:24 Q5 Q6 Q7 adding images, video and setting dimensions
18:48 Q8 Q9 Q10 adding text and creating hyperlinks
21:48 Q11 attach stylesheet
22:33 Q12 creating a stylesheet and attaching it so it is priority
Table align, border collapse, cell padding, top margin, and more
32:27 previewing webpage with stylesheets, testing the attributes
35:31 screenshot of stylesheet
36:34 Q13 copy your HTML source code, display your webpage in your browser
----------------------------

Task 3 Spread Sheets
38:53 reading ahead of questions to understand what we will be doing.
40:11 Q11 - Q19 modifying spreadsheet, deleting duplicates, header, filename, printing the print preview
46:41 Q20 creating a spreadsheet and formatting
55:15 analyzing given data
57:08 Q21 VLOOKUP and dynamic column lookup. Make sure errors are not displayed. A complete explanation as to how and why i solve the problem the way i do.
01:05:00 Q22 A complete explanation as to how and why i solve the problem the way i do.
01:10:53 Q23 Q24 adding header info and printing the formulae
01:13:25 Q25 Q26 Q27 Changing values to test formulas and print
----------------------------

Task 5
01:16:25 Printing the evidence document
--------------------------
01:17:23 Final words

Link to download the resources for this paper:
https://www.dropbox.com/scl/fo/ccwij9...

Tutorial on Tables
   • TABLES  in web pages / modifying prop...