In this video i explain and solve the complete Cambridge IGCSE ICT 0417 November 2023 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. 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
-----------------------------------
0:40 Task 1 Evidence document
-----------------------------------
-----------------------------------
1:57 Task 2 Word Processing
-----------------------------------
Q1 Saving the document and displaying the file and file type
5:06 Q2 Remove page Breaks
6:07 Q3 Header Footer (what not to do)
8:56 Q4 Columns
10:47 Q5 creating styles (important tips on creating styles)
15:37 Q6 applying styles
16:31 Q7 Move a paragraph
18:07 Q8 - Q11 Creating a chart and implementing various properties (important tips on chart creation)
24:27 Q12 Insert chart in document
26:04 Q13 Modify List style
28:59 Q14 Indenting paragraph
30:19 Q15 Spell check document
31:44 Printing your document

-----------------------------------
32:26 Task 3 Databases
-----------------------------------
Q16 analysing the datafile and importing csv as a table
Using conditional formatting to identify the primary key filed
36:24 importing the csv file as a new table
43:24 Q17 Importing a second csv file as a new table
45:44 Create a relationship
47:48 Q19 find and change data in a record
49:45 Q20 Adding a new record
Creating a data entry form (not required in this paper but demonstrated)
54:26 Q21 Creating a tabular report (basic query and report)
01:05:56 Q22 Creating a tabular report (create new field at run time, adding totals at end of report)

-----------------------------------
01:21:31 Task 4 Presentations
-----------------------------------

01:21:57 Q23-Q24 importing an .rtf file and setting up a header

Adding a table in PowerPoint
01:23:54 Q25 Changing layout and adding and formatting a table
01:25:29 Q26 adding data from csv file to the table
01:27:01 Q27 Format cell size
01:28:21 Q28 Format the table as displayed in the question paper (merge cells, text orientation, alignment, etc.)
01:30:40 Q29 modifying a bullet list, indenting
01:32:23 Q30 Add link to text to link to a slide in the presentation
01:34:55 Q31 Printing slides, 2 to a page
01:36:06 Wrap up
----------------------------------------------------
Download the files for this paper:
https://www.dropbox.com/scl/fo/3e4r8e...
----------------------------------------------------
Link to tutorial on creating Charts in Excel as per requirements of the 0417 syllabus:
   • Excel Charts and Graphs [IGCSE ICT 0417]  
-----------------------------------------------------
Link to tutorial on PowerPoint:
   • PowerPoint complete guide, [Cambridge...