2021 June Paper 31, Cambridge 0417 ICT [IGCSE]

[0417_s21_qp_31 ]
In this video i solve the complete Cambridge IGCSE ICT 0417 June 2021 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 and setting up your working folder and creating your Evidence document

----------------Web Design--------------------------
Question 1:
3:00 create a new folder and move all files web design related files to the new folder
Question 2:
6:15 Creating the table structure (rows, columns, merge cells) and setting widths and heights of cells
Question 3,4:
11:39 Title and default target name
Questions 5,6:
13:04 Adding images, making images fit in the cells maintaining aspect ratio
Questions 7,8
19:41 Add alternate text for to images
Questions 9,10,11, 12:
22:04 Adding text from file to the webpage, linking to a local webpage, attaching a stylesheet
Question 13:
26:30 Editing the stylesheet
(Background colour, image background, font styles, table alignment, efficient programming techniques, add a comment)
Evidence
38:55 Creating the evidence for the webpage and stylesheet

----------------Data Analysis (Spreadsheets)--------------------------
Question 14:
43:22 Analysing the files you will be working with, headers
Question 15:
Formatting a spread sheet
Question 16,17:
51:19 Vlookup Functinos
Question 18:
56:26 Hlookup function, nested Hlookup inside an IF function
Question 19,20,21
1:04:46 Printing (formulas, results)

Link to the source files i used in this video:
Due to copyright restrictions from CIE i am not able to provide the resource files for this paper. Please seek to get the resource files from your teacher.