2024 March Paper 21, Cambridge 0417 ICT [IGCSE]

In this video i explain and solve the complete Cambridge IGCSE ICT 0417 March 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 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.

0:00 Intro
-------------------------------
Task 1 [01:13 Evidence Document]
-------------------------------
01:13 Checking files and setting up the evidence document.
-------------------------------
Task 2 [02:38 Word Processing]
-------------------------------
02:38 Q1-Checking and saving your document. (Important saving info here)
06:18 Q2-Header and Footer. (Important tips here)
08:42 Q3-Applying columns to text
09:52 Q4-Numbering
11:28 Q5-Create a style (important tip here)
15:26 Q6-Apply styles
16:06 Q7-Moving a paragraph
17:34 Q8 Q9 -Inserting a shape, adding text and changing settings
22:50 Q10-Checking your document
-------------------------------
Task 3 [24:42 Data Base]
-------------------------------
24:42 Q11-Identifying the Primary key filed in a csv file and importing the csv file as a table. (important tips here)
35:39 Q12 Q13-Import .csv files as tables without changing datatypes
38:59 Q13-Create table relationships
40:47 Q14-Add a record.(i also create a data entry form)
45:11 Q16-Creating a query and report. (1st sorting method demonstrated)
57:10 Q17-Creating a query and report. (2nd sorting method demonstrated)
-------------------------------
Task 4 [01:17:41 Presentation]
-------------------------------
01:17:53 Q18-Import slides rom a .rtf file
01:19:10 Q19-Mater slide
01:21:3 Q20-Applying slide layout
01:22:00 Q21-Deleting slides
01:22:28 Q22 Q23 Q24 Q25 -Creating a Chart from .csv file and formatting (important tips here)
01:28:07 Q26-Adding the chart to selected slide
01:29:23 Q27 Adding a link to open a file
01:30:51 Q28-Adding presenter notes and printing notes page
01:31:40 Q29-Printing selected slides, 2 slides to a page
-------------------------------
Task 5 [01:32:35 Print evidence document]
-------------------------------
-------------------------------
01:32:43 Wrap up
-------------------------------
Link to download the resource files used in the tutorial:

[Ryan-etzi]

I scored A* just from watching you sir thank you for your guidance

[xxaru]

watching your videos for 2025 boards r the only thing which is getting me an A* in boards
very gratefull

[prawnydagrate]

ON24 candidate with paper 2 tomorrow, these tutorials are really helpful!

[Keratin]

Word
16:38 move paragraph
17:46 shape
23:11 make sure
Access
25:32 examine file for primary key
30:37 long integer
59:29 calculation
Presentation:
1:20:10 logo
1:22:52 bar chart
1:32:59 save your chart

[CRabirana]

Writing my paper 2 exam in like 2hrs and i learnt quite a lot from watching your tutorials, thank you!

[HammadKhan-zt]

i have an exam in the next hr this helped e soo much ong thank u soo much guruji i love u ur the best

[Ellie_Pyae]

In no. 15, when I make data entry, there is an error and it cannot save and it give read only.
The error is ""The change you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field that contain duplicate data or redefine the index duplicate entries and try again "".

[Angel-vqzz]

Hello! I wanted to know in database igcse if when adding a new record in the table, you could do it anywhere, as in I added it at the very end, so its the last record of my table, Thank you for your videos!

[rudieee]

A humble request to show your evidence doc. at the end because i usually compare mine with yours.

[pranitshah]

Hello. I was wondering in the Step 5 evidence, shouldn't we include the paragraph tab. otherwise the line spacing is not mentioned in the evidence snipshot

[myerix]

Hi! While I was doing q17 designing the query, I couldnt possibly open the ‘property sheet’ to place 2 decimal places. No matter how many times I clicked it didn’t show up. Any solutions?

[paphitisn]

New records are added at the end in the first empty row at the end.

[kswnb]

i noticed that in the previous past papers, there are questions to be answered in the evidence document, for example difference between relational and the other database. has those questions been removed in the 2024 syllabus for paper 2 and paper 3?

[tayyabasafder]

I wanted to ask do the access report have to be printed on one page or it can be two pages and if yes how to force all data on one page? Also all the final documents that we have to print, do we print them ourselves or just set them to the printer and the examiner will bring it to us?

[Ellie_Pyae]

which microsoft office like 2019 or 2016 or office 365 is used in word processing ? Can we use office 365 ???

[fatimahshahid]

Thank you sir this video helped me today

[LaibahKashif-yg]

hi those vids are AMAZING!!! i understand everything...just a small question, when adding a new record, if u dont make a report and just type it on the bottom, Will it make any diffrence or will there be any problems

[yeettime]

Hello. For Task 15. When I fill the new records on the table, it gives me an error.

It says "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate values and try again."

Can you help me fix that solution. I did set the correct primary key and follow everything.

[takshjain]

in step 10 why u did not correct the spellings?

[MrTSAh-hq]

Good day, I was wondering what is the best approach to studying for paper 1? My mocks are approaching and I have a very compressed timetable