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

2024 November Paper 2, Cambridge 0417 ICT [IGCSE]

This is not an easy paper. In this video i explain and solve the complete Cambridge IGCSE ICT 0417 November 2024 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 --------------------------------------------- Task 1 (Evidence Document) --------------------------------------------- 01:03 Evidence document --------------------------------------------- Task 2 (Document) --------------------------------------------- 02:40 Q1 renaming file, display file extension 05:09 Q2 Removing page breaks (using the show/hide) 07:00 Q3 Adding Header and Footer. Alignment 09:24 Q4 Changing paragraphs to 2 columns 10:51 Q5 - Q6 Sorting a list alphabetically and adding custom bullet [different ways demonstrated] 14:48 Q7 - Q8 Creating a style based on normal. Applying styles [Important tips here] 18:43 Q9 - Q11 Working with tables and table properties [Important tips here] 21:09 Q12 Formatting paragraph, indenting, border and shading 23:04 Q13 Checking the document --------------------------------------------- Task 3 (Databases) --------------------------------------------- 23:50 Q14 Creating a database and Importing csv files as tables 34:34 Q15 Create relationship between tables 36:27 Q16 Creating a query 41:55 creating the report based on the query ********************A lot of important tips here*************************** 43:40 Sizing the fields in the report. We notice that not all fields imported in report. 46:41 method 1 to add a missing field in the report 49:40 method 2 to add a missing field in the report 53:11 Method 1 in applying sorting of the report 55:05 Method 2 in applying sorting of the report ***************************************************************************** 56:50 A 3rd method of adding a missing field to the report 58:27 adding and center aligning a heading 59:07 adding a calculated field to find Maximum and add label. Why we do not use Text boxes 01:01:14 adding a Page Footer 01:03:29 Q17 Creating a simple Data Entry Form 01:05:21 Q18 Import a table from csv to be used as a list in a Drop Down List box in a data entry from ********************A lot of important tips here*************************** 01:07:13 Creating the Drop Down List Box in the data entry form 01:10:19 Aligning the objects in the entry form 01:10:42 Limiting entries to the list 01:11:50 Looking at the properties of the Drop Down List Box Here i will demonstrate how to ensure unique values are displayed in the list box as the paper does not demonstrate this 01:12:18 Demonstrating how to ensure UNIQUE values in the list (2 methods) 01:17:10 Creating the evidence and identifying what needs to be viewable 01:19:40 Q19 Adding a record in to your data entry form. --------------------------------------------- Task 3 (Presentation) --------------------------------------------- 01:21:51 Q20 Create a presentation and import slides 01:22:44 Q21 Adding Header and Footer 01:24:28 Q22 Modifying lists and bullets 01:26:21 Q23 Delete slides 01:26:45 Q24 - Q28 Creating a Pie chart from data in csv file [Important info here] 01:32:30 Q25 Inserting a shape, size the shape and make the shape a link a slide in the presentation 01:35:43 Q30 Printing your slides 01:36:34 Recap and key takeaways on the paper ---------------------------------------------------- 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...