2022 June Paper 21, Cambridge 0417 ICT [IGCSE]

[Paper: 0417_s22_qp_21]
In this video i solve the complete Cambridge IGCSE ICT 0417 June 2022 practical paper 21
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.

--------Word Processing(Word)---------
0:00 Intro / setting up the Evidence file
2:00 Q1 checking the document and saving as a Word Doc
04:15 Q2 Adding header and footer / understanding placeholders
06:47 Q3-Q4 Creating styles / based on normal /understand why the text changes when a style is created / apply styles
11:19 Q5 Change layout to 2 columns / checking alignment of columns
13:20 Q6 inserting image (rotate, size, maintain aspect ratio, text wrap)
17:24 Q7-Q8 Sorting a list (apply custom bullets / align / line spacing / space after last line)
20:33 Q9 Modify a style
22:46 Q10-Q11 Tables (format, design, merge cells, apply style, modify width, text wrap, line space after table)
26:35 Q12 Check your document / print

-----------Databases (Access)-----------
26:58 Creating your database file
28:28 Q13 Import CSV file as a new table in the database
Here i demonstrate what happens if you import wrong, how to identify the error and how to repair
34:36 Importing second CSV file as a new table in the database (2 decimal places fixed, currency 0 decimal places)
41:35 Q14 Creating a One-to-Many relationship (what does this mean, how to remove an extra table added, generate a valid screenshot)
44:13 Q15 Here i demonstrate how to quickly add the data but i also demonstrate
how to generating a user friendly Data Entry form to add data
49:53 Q16 Creating a query and producing a tabular report based on the query
(How to approach query and reports, query filters, modifying the report so that it displays all the data, formatting)
01:09:27 Q17 Query and Labels
01:13:42 creating a custom label

-----------Mailmerge-----------
01:19:36 Q18-Q19 Save the data file as an Excel Workbook
Link document with data source / insert merge fields / add date field (not requested in paper)
01:25:15 printing the master document
01:25:38 Set an automated filter (using an OR statement)
01:27:49 Q21 Merging the document and printing

-----------Presentation (PowerPoint)-----------
01:29:15 Q22 Creating a presentation and importing slides from an RTF file
01:30:23 Q23 Modifying the slide master
01:32:41 Q24-Q25 Changing slide layout / deleting a slide
01:33:34 Q26-Q30 Creating a (complicated) chart and inserting into the slide
01:40:48 Q31 Modifying bullets (adding custom bullets)
01:42:27 Printing techniques

Download the the question paper and the files used in the video
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.