2024 June Paper 22, Cambridge 0417 ICT [IGCSE]

In this video i explain and solve the complete Cambridge IGCSE ICT 0417 March 2024 Practical paper 22. 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 (Evidence) & Task 2 (Document)
--------------------------------------
01:32 Read through the first sections
03:26 create the evidence document (Tip on enabling the ruler)
04:26 Q1- check the document, save as a Word document.
05:57 Q2- Header and Footer (important info on using the place holders)
08:43 Q3- Change layout to columns, equal width with gap
10:48 Q4- Modify a style
14:07 Q5/Q6- Sorting a list and alignment
16:06 Q7/Q8- Insert image, align and add a link to an email
20:31 Q9/Q10/Q11- Tables, add remove columns and rows, formatting
24:29 Q12- Checking for split lists/tables, widows orphans.

--------------------------------------
Task 3 (Databases)
--------------------------------------
25:55 Q13- Import first csv as new table
31:12 Import second csv as new table
34:52 Q14- Creating a one-to-many relationship
36:15 Q15- Adding a new record in a table. (i demonstrate a quick data entry form also)
39:23 Q16- Understanding what we have to do to create the report. (A lot of important tips here)
41:10 Creating The query
46:04 Creating the report based on the query.( here i demonstrate 2 ways to apply the sorting and the differences of each)
51:25 applying sorting in the design view of the report
52:54 finishing the report (IMPORTANT info on adjusting the filed row height to make the report fit on 2 pages)
55:41 Q17- Understanding what we need to do to generate the labels.
57:55 creating the query to generate the labels.
01:00:12 Creating custom sized labels (IMPORTANT info on custom labels here)
01:03:36 Understanding the importance of selecting the query before creating the labels
01:05:47 Formatting the labels
01:07:21 modifying the margins to make sure we get 10 labels per page

--------------------------------------
Task 4 (Printing the Evidence)
--------------------------------------
01:08:52 Printing the evidence document

--------------------------------------
Task 4 (Presentation)
--------------------------------------
01:09:33 Q18- Create presentation from .rtf file
01:10:32 Q19- Reading the instructions and setting up the Master slide (shapes, titles, page numbers etc..)
01:15:59 Q20/Q21/Q22/Q23- Create a chart (important chart creating info here)
01:21:20 adding the chart to the slide
01:22:18 Q25/Q26 Adding presenter notes and printing slide with presenter notes, printing 6 slides to a page

01:24:00 Wrap up.

Access the resource fies for this paper so that you can practice:
https://www.dropbox.com/scl/fo/twtud5...