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

2024 November Paper 3, Cambridge 0417 ICT [IGCSE]

In this video i explain and solve the complete Cambridge IGCSE ICT 0417 November 2024 Practical paper 3. 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 and anyone who wants to learn more on Web Page Design and Excel. 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. A link to the resource files and links to other tutorials to support your learning for this paper can be found below. 0:00 Intro ---------------------------------------------- Task 1 Files and Evidence Document ---------------------------------------------- 0:55 Checking the files and creating the Evidence Document ---------------------------------------------- Task 2 Spreadsheet ---------------------------------------------- 01:54 Q1- Analyze the spreadsheet, adding header and saving file 06:22 Q2- Formatting the spreadsheet 08:56 Text wrapping [nice tip here] 10:39 Q3, Q4- Calculating Sum and Average 11:57 Q5- Nested IF Function 13:40 Understanding IF and Nested IF functions 16:50 Entering the Nested IF Function 17:59 Checking the formulas to make sure they can replicate (Relative and Absolute references) 19:49 Q6- Vlookup function with calculation, check replication 21:58 Q7- Replicate formulas form questions 3 to 6 22:35 Q8- Format cells 23:00 Q9- CountIF functions with replication 24:57 Q10- 24:57 Printing the formulas 27:13 Q11- Conditional formatting 30:18 Format font and print showing values ---------------------------------------------- Task 3 File Management ---------------------------------------------- 32:23 Creating folder and managing files ---------------------------------------------- Task 4 Web Page [Using Dreamweaver] ---------------------------------------------- 32:53 Q13- Open CSS and create 2 classes [a couple of methods demonstrated here] 36:17 Q14- Removing borders of table, adding details and saving the web page 38:58 Q15- Identifying paragraphs and creating them. Adding styles 41:11 Adding class to selected paragraph [Important info here] 44:28 Creating paragraphs and applying list style 45:59 Q16 Q17- Adding page name and default target window 47:42 Q18 Q19- Adding hyperlinks and target window 49:05 Q20- Adding a character set and a page description Q21- Copying the HTTML source code and displaying your webpage in the browser [make sure your screenshots display all the info] 53:44 Recap of paper ------------------------------------ Link to download the resource 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 IF Functions (nested functions):    • Excel IF functions explained: IF, Nes...   Link to tutorial on references in Spreadsheets (Absolute, Relative, Mixed):    • Excel References, Relative, Absolute ...   Link to tutorial on Web Design Metatags:    • Dreamweaver Head section Meta tags - ...