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.