[Paper: 0417_s22_qp_31]
In this video i solve the complete Cambridge IGCSE ICT 0417 June 2022 practical paper 31
A great resource for all students taking this exam. A link to the question paper and source files can be found at the bottom of the description.
For this paper i used Dreamweaver (for the web design and style sheets), Photoshop (for the image editing) and Excel for the Spreadsheet component.
-----------Web Design-----------
0:00 Intro, preparing for the exam (create evidence and working folder)
02:37 Modifying image in Photoshop
05:11 Displaying files, file type, and dimensions of files as evidence
06:40 Analyzing question 2 (creating a web page and add a table)
Number of columns and rows, Borders, table margins, border collapse property,
cell width and height
12:17 Creating the webpage and table as described in Q2 in Dreamweaver
15:18 setting the cell width/height percentages
19:17 Q3 webpage title
20:02 Q4 default target window
21:15 Q5 Adding images, videos in table cells. The objects to fit the maximum width, height
of the cell, maintaining the aspect ratio
26:22 inserting Video and fixing width to width of cell. Adding a message if video is not
supported by the browser
30:41 Q6 adding alternative text to images
32:28 Q9 inserting text from text file and typed with Paragraph
33:46 Q10 Hyperlinks on images, open in parent window
35:17 Q12 renaming and attaching the stylesheet to the web page
37:33 Q13 Analyzing the stylesheet we need to make and understanding which tags we will need
Understanding Table tags
45:39 Q13 creating the style sheet we have analyzed in Dreamweaver
01:00:00 Q14 Getting the evidence of HTML source and your webpage in the browser window
----------Spreadsheets-----------
01:03:58 Q15 Spreadsheets, opening and saving files, add header
01:06:11 Reviewing the spreadsheets
01:09:05 Q16 Vlookup function
--------Resources-----------
Download the question paper and exam files here:
https://thejuniorschool-my.sharepoint.com/:f:/g/personal/nick_theseniorschool_com/EiyIm9OWh-xLgIaugygcrrMBGjCYes_70fbVPBz5vTFd2g?e=O2EfBC
