2024 June Paper 21, Cambridge 0417 ICT [IGCSE] MUST WATCH

This is one of the trickiest papers yet. It is the 2024 June paper 21 and it is a packed paper with quite a few new twists. In this tutorial, 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 and anyone who wants to learn more on Word, Access, Excel chart creation and PowerPoint. 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.

00:00 Intro
--------------------------------
Task 1 (Evidence Document)
--------------------------------
01:14 Check you have all files
01:40 Creating the Evidence document (I added my details at the end before printing)

--------------------------------
Task 2 (Document)
--------------------------------
02:53 Q1- Saving the .rtf as a document and checking the preset settings
05:35 Q2- Header and Footer. (explanation about place holders here)
09:23 Q3- Creating a new style, based on normal
14:13 Q4-Q5- Apply style / Change paragraphs to 2 columns
16:52 Q6- Modify existing style
20:36 Q7- Apply and modified numbered list (align with dialogue box or using the ruler)
24:35 Q8- Inserting image, rotating, text wrap
26:55 Q9- Formatting a table, fixed size, row height, table alignment (this is quite new)
31:45 Q10- Spell check, proof read, checking for widows and orphans, split tables and slit lists, print document

--------------------------------
Task 3 (Database)
--------------------------------
33:50 Q11- Importing a csv file. (formatting the date field).
41:49 importing a second table and adding a new field as a primary key, formatting time datatype
46:52 Q12- Creating a one to many relationship. Appropriate screenshot
49:39 Q13- Creating a query and report, Important info here
53:48 creating a new field which is calculated at runtime. Formatting the new field.
56:16 adding the criteria for the query. Using the OR operator
58:05 Creating the report based on the Query
59:25 Choosing which method to use to apply the sorting. 2 methods demonstrated.
01:08:12 Q14- Adding a new field in an existing table
01:09:54 Understanding radio buttons and what data they store
01:13:15 Q15- Creating a Data Entry Form
01:15:16 Q16- Add a radio button option group to the form, connected it to a field and format the form. (Important info here)
01:23:00 Q17- Adding a new record using the newly created option group. (Bonus tip, changing an item in the form to a combo box and adding a button)
01:27:39 Q18- Automated selection in table. (use of text filters)

--------------------------------
Task 3 (Presentation)
--------------------------------
01:29:58 Q19- Create a presentation from an rtf file
01:31:21 Q20- Modify the Master slide
01:33:39 Q21- Editing bulleted list
01:36:07 Q22- Delete Slides
01:36:28 Q23-Q24-Q25- Create a chart from the csv file. (Important info on charts here)
01:39:47 Q26-Q27- Format axis values on the chart and place chart in slide
01:41:41 Q28- Create and edit and action button which opens a local file. Add text to the shape.

-------------------------------
01:47:39 Wrap up

-----------------------------------------------
Link to download the resource files:

[ariszne]

I'm sitting my exam at the end of this September, and I'm very nervous but you have made me quite confident in a lot of the things required to do. Thank you and pray for me lol.

[Keratin]

19:17 evidence style modified & applied
21:54 list: aligned to left margin
27:47 table
Access:
37:16 long or short text
41:13 evidence
42:13 create new primary key field
54:15 query design calculation
Report:
1:04:39 title centre align
1:08:16 new field
Form:
1:14:55
1:17:12 radio buttons
1:23:30 dropdown list

1:28:14 automated selection method

Presentation:
1:33:13 footer
1:34:46 list
1:36:37 bar chart
1:42:04 action button

[chaitalisajnani]

Sir, I came to thank you for all your videos on igcse ict 2024, your videos really helped me switch my D to an A in my actual exam!! I'm glad I found you during my last moments of preparation during my boards. Please keep creating them for future IGCSE aspirants!!

[Polina-lqn]

Ive never really understood ict but this video made me feel so confident in my mocks. I haven’t gotten the results back yet but im sure they’re going to be great. Thanks a lot!

[spidext]

Your a lifesaver man, my exams tommorow and im just binge watching your videos

[SlavaKorshikov-kh]

Thank you sir, I have got my exam in September and you really helped me to get A*. I love u, u r my GOAT!!!!

[_sylviaaa]

Hi sir, it's me again. Just finished my ict paper and your tips and brief explanation really helped tremendously! It's somewhat as if I'm doing the paper with you! 😂 Test went great, was super easy all thanks to you. I was extremely clueless in class as my teacher did not go through them as detailed as you did, just here to say big thanks 🙏🏻

[reneegroza]

26:55 i thought i was supposed to take the picture to the right mirgin

[vivaanlalwani]

You taught me more in 1 video than my teacher did in the full year

[fatimahshahid]

Thank you this will help me in my paper tomorrow

[sadiajunaid]

I am giving my papers on 26th of September and I was pretty scared but ur videos came on a clutch. It really helped me in understanding the practical papers especially and I hope I get an A*. Plus thank you a lot, a lot of prayers :))))

[mobilefp]

Thanks man this really saved me right before the prelim exam paper as i had no way of actually doing the practical paper on my own because my laptop stopped working just 4 days earlier but after watching this vid im sure that i can get good marks in the paper im writing this at 2 am while my prelim exam is at 8 am so gotta get some sleep

[bao_sus]

thank you for the content sir, you have single handedly saved my prelims, im commenting so others are also able to discover the absolute gem of a channel you host

[tsuki]

these videos are going to finally help me get an A* in my upcoming practicals sir, my theory is already above 90%. these videos are very helpful!

[glyzer]

I am in AS levels now, unfortunately I didn't choose CS or ICT as my subject option but still look at your videos and remember my examination preparation days. Thank you so much for making me go through it Mr. Nicos, your videos helped me a lot and now I am getting an award from my school for good effort. 🙏🙏

[indrani]

Hello sir I have a doubt at around 39:48, after I applied all the formatting as you've shown for date and time, it is still in MM/DD/YYYY format, while the paper is asking for DD/MM/YYYY format. At the start of creating the table through the wizard I had also fixed the date format in the advanced tool. It's still not showing... And I would also like to point out with all due respect that in the word document part, the picture was supposed to be right aligned 😊

[Lin-jtzz]

Just finished answering O/N series for ict paper2(it was harder than other papers ) and I cannot thank you enough ahehe. I will keep watching your videos for paper 3 and paper 1 toooo

[Meta.Ripple]

7 daysss for the Igcse oct/nov series 🥹

[MistaBrunch]

You, dear sir, are a great, great man

[FarfarFafa]

You're so helpful!! I was so scared when I heard about Yahmad's channel being removed, I'm so glad I've found a replacement