2023 November Paper 2, Cambridge 0417 ICT [IGCSE] скачать в хорошем качестве

2023 November Paper 2, Cambridge 0417 ICT [IGCSE]

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: 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. ---------------------------------------------------- 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...