2022 March Paper 31, Cambridge 0417 ICT [IGCSE]

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:
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.

Tutorial on Tables

[PCTEDIX]

your a life saver. my exam is tommorow and iam gonna ace it becuase of ur help

[Txki-chan]

Exel formulas are so fun and satisfying when you understand the question. For question 21, it took me quite a while to understand, but once I got it, I couldn't believe how simple it actually was. The trick was to not use a fixed value in the formula, but a cell content containing the value (the column index number) we want, allowing it to be replicable. The examiners are really getting creative with these questions, haha. Btw, I truly appreciate how you dig deeper into questions and really emphasise on the fact that people should understand the questions and think creatively. You always add more info and solve the questions several times in different ways to make sure you cover everything. truly the best Ict teacher to ever exist!

[yo_fav_gangsta]

You are literally the reason I'll be able to solve any paper 😭😭😭

[Blood]

This man actually teaches me ict better than my teacher 😭

[ramosm]

This guy is carrying my entire classes ict mock results

[Keratin]

Hiii! I just finished my igcse exam paper 3 today and wanted to say that your videos are so helpful and i think i did pretty well. Thank you for sharing ur knowledge with us. i’ll be having my theory paper next week. Keep up the quality content 🎉😊🎉

[Bfi]

22:23 when I add the stylesheet, everything is perfectly fine except that my background is black. in yours it has some type of flags. why is that?

[g-khantnyar]

Love your videos man!!! You really remove some weight on my shoulders when it comes to ICT, I am not confident with my abilities at the moment, but I am proud to say that Ive come a long way! Keep up the great work!

[doctorirrelevant]

sir thanks to your videos i was able to prepare for my ict practicles in a week because of you and ajirotech thank you without you guys i wouldnt have know any of the exam questions

[damian]

i was just attempting this paper, thank you, had a question, for fitting the image inside the cell, if we simply modfiy the width to 100% without adding style=, that wont deduct our marks right?

[RithwikChitla]

Just finished my paper wrote awesome all thanks to you

[maryamassem]

Hi from Doha!! I love your I went from a 4 to a 9 because of you🎉🎉🎉

[RahafFahmy-eg]

Thank you very much, it is very benifical, hope you reach millions of subscribers cause you deserve this ❤

[Teresa-bzpe]

hello, at 1:03:05, why do we add A2 instead of the usual col index number (number 2)? I'd like to really understand

[nameless.reaper]

watching this 1 day before my final exam

[AmnaKhurram-pz]

my vlookup gives an error message eventhough i did it step by step with you

[justifyl]

Hello I have a question. In question they said the table must fit 90% of width AND HEIGHT of the browser, so why we only setted for width

[Bayan]

Can you use other applications such as web expression for the website authoring

[majedadnan]

Hello teacher i wanted to thank you for carrying my paper 2 mock if you could post past papers in web expression more before may June papers thank you ❤

[aleezayounas]

Sir in question 21 can't we use HLOOKUP instead of VLOOKUP?