[Paper: 0417_s23_qp_21]
In this video i explain and solve the complete Cambridge IGCSE ICT 0417 June 2023 Practical paper 21. As in all my tutorials i show variations of questions and give tips on solving the paper.
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.
Use the time stamps in the description to jump to sections of interest.


0:00 Intro
---------Word Processing---------
0:51 Starting the paper, question 1
06:40 Question 2 (Header / Footer)
09:14 Questions 3 - 4 (Styles) HOT TIPS included
14:18 Question 5 (Change layout to Columns with spacing)
15:49 Questions 6 - 8 (insert images, rotate, text wrap, align)
19:13 Question 9 (bullets and indenting)
21:22 Question 10 - 12 (Tables)
28:07 Question 14 (check your document)


---------Databases---------
31:50 Question 15 (checking the data before importing) HOT TIP HERE using conditional formatting
Creating a database and importing data to new table
41:57 Questions 16 - 17 importing data as tables
46:07 Question 18 (creating relationships)
50:32 Question 19 (adding a record) User friendly Data Entry Forms demonstrated here.
54:46 Question 20 (Creating a Query and report)
01:07:10 Question 21 (more complex query and report, wildcard, multiple criteria with AND)


---------Presentation (Chart included)---------
01:20:50 Question 22 (Importing slides)
01:22:29 Questions 23 - 24 (Master Slide and layouts)
01:26:12 Questions 25 - 30 (Creating and modifying chart properties, add to slide, , presenter notes, printing notes page)
01:32:52 Question 31 (creating link to email with subject)
01:35:34 Question 32 (printing presentation 2 slides per page)




Link to download the resource files for this paper:
https://www.dropbox.com/scl/fo/kg7fd2...


Link to the tutorial on creating charts in Excel. Tutorial is focused on the requirements of the 0417 ICT syllabus:
   • Excel Charts and Graphs [IGCSE ICT 0417]