2024 November Paper 2, Cambridge 0417 ICT [IGCSE]

This is not an easy paper.
In this video i explain and solve the complete Cambridge IGCSE ICT 0417 November 2024 Practical paper 2. As in all my tutorials i show variations of questions and give important tips on solving the paper.
A great resource for all students taking this exam but also for educators teaching the course. A link to the question paper and source files can be found at the bottom of the description.
Use the time stamps in the description to jump to sections of interest.
0:00 Intro
---------------------------------------------
Task 1 (Evidence Document)
---------------------------------------------
01:03 Evidence document

---------------------------------------------
Task 2 (Document)
---------------------------------------------
02:40 Q1 renaming file, display file extension
05:09 Q2 Removing page breaks (using the show/hide)
07:00 Q3 Adding Header and Footer. Alignment
09:24 Q4 Changing paragraphs to 2 columns
10:51 Q5 - Q6 Sorting a list alphabetically and adding custom bullet [different ways demonstrated]
14:48 Q7 - Q8 Creating a style based on normal. Applying styles [Important tips here]
18:43 Q9 - Q11 Working with tables and table properties [Important tips here]
21:09 Q12 Formatting paragraph, indenting, border and shading
23:04 Q13 Checking the document

---------------------------------------------
Task 3 (Databases)
---------------------------------------------
23:50 Q14 Creating a database and Importing csv files as tables
34:34 Q15 Create relationship between tables
36:27 Q16 Creating a query
41:55 creating the report based on the query

*********************A lot of important tips here****************************
43:40 Sizing the fields in the report. We notice that not all fields imported in report.
46:41 method 1 to add a missing field in the report
49:40 method 2 to add a missing field in the report
53:11 Method 1 in applying sorting of the report
55:05 Method 2 in applying sorting of the report
*****************************************************************************

56:50 A 3rd method of adding a missing field to the report
58:27 adding and center aligning a heading
59:07 adding a calculated field to find Maximum and add label. Why we do not use Text boxes
01:01:14 adding a Page Footer
01:03:29 Q17 Creating a simple Data Entry Form
01:05:21 Q18 Import a table from csv to be used as a list in a Drop Down List box in a data entry from

*********************A lot of important tips here****************************
01:07:13 Creating the Drop Down List Box in the data entry form
01:10:19 Aligning the objects in the entry form
01:10:42 Limiting entries to the list
01:11:50 Looking at the properties of the Drop Down List Box

Here i will demonstrate how to ensure unique values are displayed in the list box as the paper does not demonstrate this
01:12:18 Demonstrating how to ensure UNIQUE values in the list (2 methods)
01:17:10 Creating the evidence and identifying what needs to be viewable
01:19:40 Q19 Adding a record in to your data entry form.

---------------------------------------------
Task 3 (Presentation)
---------------------------------------------
01:21:51 Q20 Create a presentation and import slides
01:22:44 Q21 Adding Header and Footer
01:24:28 Q22 Modifying lists and bullets
01:26:21 Q23 Delete slides
01:26:45 Q24 - Q28 Creating a Pie chart from data in csv file [Important info here]
01:32:30 Q25 Inserting a shape, size the shape and make the shape a link a slide in the presentation
01:35:43 Q30 Printing your slides

01:36:34 Recap and key takeaways on the paper

----------------------------------------------------
Download the files 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.
----------------------------------------------------
Link to tutorial on creating Charts in Excel as per requirements of the 0417 syllabus:
-----------------------------------------------------
Link to tutorial on PowerPoint:

[jisooyah]

You don’t know how much these videos mean to us. I’ve gotten an A* in all my mocks and got a 94 in my latest one JUST BECAUSE OF YOU. I love you so much dude, I’m gonna give my exams in 3 days. Cheers 🎉

[jupitersmoons]

I don't usually comment under youtube posts but I had to show my gratitude. Your videos helped me so much for my ICT exams and I was able to get an 85! I'm always recommending your videos to people because your explanations are very thorough and easy to understand. I hope you gain more recognition and never stop what you're doing for kids like me Mr Paphitis! On behalf of all your viewers we love and appreciate you ❤

[aryangangsta]

Definitely the best ICT tutorials for igcse on the internet. Mr Paphitis i cannot thank you enough for these videos. I have my feb march series examinaition for the component code 21 tomorrow and thanks to you my entire class is extremely well prepared I have recommended your channel to some of my friends from other schools and I hope over the years you gain much more recognition . all in all, thank you!

[ChrisZemen]

You helped me much for my IGCSE ICT, for both papers I cannot describe how much I am grateful to have found your channel. Both practical papers were easy thanks to your amazing tutorials THANK YOU

[hqbiba]

I've got my paper 2 tomorrow and I cannot explain how much your videos mean to me, I picked ict as a filler subject because I need 8 subjects and honestly your videos go over things I didn't know and they've helped me so much. You really need more recognition and keep doing what you're doing, believe me a lot of us have gained so much from your videos. We love you so much Mr!! Thank you for helping me since the start of year 10 all the way to the end of year 11 :))

[ruve]

Hands down one of the best ICT teachers on the internet right now!! Thank you so much for helping me with my ict journey! I’m giving the feb march series and this channel has helped me so much with practicals and all the attention to detail you put in these videos, you’re an absolute legend !!

[notleon]

I remember how much I crammed your videos in my IGCSE year. Thank you, Mr. Paphitis. I got an 87 which was quite close of getting A*. All the deducted points were the mistakes from Paper 1 I reckon, because I knew I didn't make a single mistake in Practical works. Thanks again!

[saimashaikh]

Hands down the best ICT teacher in existence! You cant fathom how much you have helped me with these videos of yours, your teaching style, and the way you give multiple ways to do a thing, masterclass! God bless you and everyone else!

[noscope]

Best ICT 0417 Tutor!! Seriously, props to you man for bringing out content as amazing as this!!

[hamzamohamed]

Hey Nicos, my exam is today in an hour, I just wanted to say thank you for everything as you have truly truly truly saved me in ict as it was a dreadful subject for me earlier, keep doing what you do as you truly make so much people happy and help so much people in ways you wouldn't imagine ❤

[frxstified]

I'm taking my paper 2 exam tomorrow and this video has helped me alot! Honestly one of the hardest papers i've attempted for paper 2 but you explained it really well and now I'm confident I'm gonna ace tomorrows exam! Thanks alot Sir, may god bless you! 💝💝

[fazalshah-tvoz]

the GOAT of ICT here to save me once again. I love all the videos you make and the minute changes to the system and display just for us to understand and learn better. Really appreciate the detailed overview of it all and I'd just like to thank you yet again!

[PentaWebDeveloper]

Thank you so much for this amazing ICT video! It was a huge help in preparing for my ICT Paper 2. Your explanations were clear and straightforward, making complex concepts easy to understand. I truly appreciate the effort you put into this – it really made a difference for me!

[WinterPhoenix-vppd]

This was a massive clutch for me as i've got feb/march coming up next week. Thanks a load, it really helped me clear all my doubts for p2. Ill update my results here when i get them fs. :)

[TkTroleXx]

I dont usually comment on youtube videos, or in fact anything in general, but i just had to show my appreciation to u as u have helped me a ton over the last few months..

A friend of mine recommended me ur videos and i started watching them quite a while back actually, i love how u explain more than needed and like this subject not JUST for the sake of it, but actually have a passion and enjoy educating others as well! I went from a D student to an A* student in my mocks in just under 5 months from seeing ur videos...

MASSIVE THANK YOU once again, i have my boards on the 30th of Jan, and u have really helped me understand this subject and not just learn without understanding anything. I will make sure to recommend ur videos to my juniors as well in 9th grade..

THANK YOU

[ShivamKaria-vd]

sir, I truly hope you have a long, happy, and healthy life. The world needs more amazing teachers like you who help students learn and achieve their goals. Thank you for all that you do!❤

[shamrockshaker]

i was hoping you would do the newest paper because i have my paper 2 in 7 days since im giving the feb march series thank you so much i couldnt have become so confident with ICT without your and with the help of your videos i scored a 205/220 in my ICT mocks an A* !!!!

[sikaapeagyei]

Used 1hr and 35 min for thw whole paper. Includoing recordings and explanation. you are a legend. Thanks for the great videos

[andrewsafe]

I had no clue what am doing my igcse is in 3 days but thanks to you am saved

[theopposite_]

i have my paper 2 and 3 in a week and idk anything binging all your videos in one night, you really explain things so well and im sure ill get an a* with your help thanks sir