2024 November Paper 3, Cambridge 0417 ICT [IGCSE]

Опубликовано: 25 Январь 2025
на канале: Nicos Paphitis

10,008

158

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