I’m so grateful for you to making these videos. They are indeed life saver for me. I quit studying in school after they had done teaching the whole syllabus and started to self study by myself to save cost. So I’m glad that I found your channel. It is really helpful for me. You teach us like your own students without keeping any tips. I’m so grateful and appreciate your works. Please keep doing this. And I guess I did well in today paper 2 , before exam night, I binged watch your database videos. They are really helpful. THANK YOU SO MUCH
First let me thank you for your very kind comment. I am very happy my tutorials helped you and i am glad you feel you did well in paper 2. Good luck with paper 3. Please reach out if you need any support.
i have my paper 3 igcse exam tomorrow and i cant thank u enough for helping! I just have one question; the css designer, would i be allowed to use it for my exam tomorrow?
i am glad these video tutorials are helping you prepare. Good luck with your exam tomorrow. make sure to come back and let us know how you did. Some info on what was included in the exam would also be great.
Thank you for your kind words. Receiving comments like yours, being able to reach out and help so many students globally makes me the luckiest and happiest teacher. i am glad i was able to help you, good luck with your exams, make sure you come back and let us know how you did.
I have a question, does the spec state what software we have to use or does it depend on the exam center (my school). Because in our school we use Microsoft Web Expression 4 which is very old. And all your videos are in Dreamweaver, which is much better and convenient. Cambridge IGCSE™ Information and Communication Technology 0417 This is the spec I do, so could you please help me?
both microsoft web expression 4 and dreamweaver are allowed, it depends on the exam center (in this case, your school), but dont worry since the code is generally the same but there could be a change in the interface i guess.
The exam is not application specific so you can use any software you want for any of the components. Schools have an option of software so the students go with waht the school offers. At the end of the exam the exams officer or the head of department has to fill in a form specifying the software that the students used.
@@mathskafunda4383 i really admire you students that have to code the majority of the paper 3. I now some students they use Note++ or visual code so it is much harder for them. Frontpage is even harder in my opinion. I used to teach it with front page many, many years ago. Respect to you.
@@paphitisnThe paper went really well!! It was very similar to the may/june 2021 paper 31 paper.. the hot air balloon, serengeti, Africa etc. (which I exactly watched yesterday In your channel!!) Thank you sooo much for the help sir! 😊😊😊😊😊 going to watch the theory vid now, thank you so much 🙂🙂😄
your videos have really helped me the past 2 days, before yesterday i was very ill and i watched your paper 2 videos. yesterday i took my mock and i was soooo happy because it was super easy. today i'm doing the same for paper 3; wish me luck on my mock tomorrow. Thank you so much.
Quick Question, I am writing my examination in Zambia and I am writing it in the British Council. I will be Writing ICT 0417, my practical examinations will be in the beginning of April, however for the web design part, i don't know if they use dreamweaver, so in this case, what do I do?
Hello Sir, I'm thankful to you for making such great tutorials. Just in the spreadsheet task, the Headings and other numeric data is to be formatted in Calibri Light not Calibri as shown in Question Paper. I will have my exams in 2025 Feb March and your videos have helped me so far.
I dont keep the completed files after i have solved them. Why would you need the solved files if they are soled in the tutorial but you can also download the marksheets with solutions.
the videos are so helpful i watched your paper 2 video the day before without having any idea about majority of the topics and i ended up getting full marks !!!! thankyou so much!
Wow that is awesome. Well done! I do wonder however, why you had no idea about the majority of the topics just before the exam. In any case you must have really paid attention to the tutorial content to be be able to get full marks. well done.
@@paphitisn oh no this was my mocks and i'm talking about revision which i hadn't done since last year your video was very helpful in clearing a lot of doubts and reviving my memory :)
You will need to check with the exam center at which you will be taking the exam. I dont see any reason why not as long as you can carry out all the required skills and produce the correct outpouts without internet connection then it should be ok. However you will need to find an exM center that has that software installed on their computers.
If you watch the paper 3 videos you will see all that yiu eed for css. Doing a video only on css will not help that much as you need to base the exercises on the guven scenarios.
Thank you for these videos sir, my paper 3 went really well just made a mistake in a lookup question. If it was not for your videos, I do not know how I would have revised
I'm happy that the paper was tough, but I did well so the thresholds should be slightly lower. A question I have: I forgot to name some cells(it was discreetly mentioned in the format your excel to look like the one in the paper) but nowhere was evidence for it asked, and it obviously isn't shown in the prints, so how will they even check that? Maybe in the excel formulas that use that range?
If they asked you to create a named range, then that range would have been for the table for the lookup function so they will see it in the formula. This will only be a 1 mark so i would not worry about it. Sounds like you did a good job. Well Done!
Sir, I also have one more question. I took 2 screenshots to display the web page in the browser. Will I be losing marks for that, it didn't mention that the web page needs to come in 1 page.@@paphitisn
@@paphitisn Hello Sir, another doubt I have: I took 2 screenshots to show the entire web page in the browser so will I lose a mark for that? It didn't say in the question that the screen shot should only be one page.
@@mathskafunda4383 If it did not say that it should display the whole webpage then you will not lose a mark. If it said to take a screen shot from the browser displaying the whole page then you will. SO you should be fine.
Hi, great video, thanks for sharing. I have one question though, I looked at the mark scheme for this paper and for questions 11 and 12 it shows dollar signs before each cell number. For example =SUM($C4:$F4). I am just wondering if this makes a difference and if I will lose marks if I don't add this. Thanks.
The dollar sign is used for relative and absolute references. In this case it is not needed so you will not lose marks because the dolar sign indicates that the column letter is not allowed to change. When we copy downwards the column letter does not change anyway so there is no need for the $ sign.
Sir do we have to show both file name and file path together or do we just show file path. because u have shown both, but when u click file path file name is automatically added.
If you took the exam at school, did your teacher keep a copy of your electronic files? If yes the exams officer can contact the exam board and ask if it is possible for them to attach the copy of your html code.
No this is not required. In the question paper the dotted borders are there to indicate NO border. If you do add Borders though you will not lose marks as marks are awarded positively. so as long as you do what you are supposed to do you will get the marks. You would only lose marks if it said specifically No borders.
Greetings .... i wanted to ask ? for question 7 on,[Styles h1 and h2 must be blue with no other colour components.] why do we use 0000FF I DONT GET where it comes sorry..
with hexadecimal colour the first 2 number represent the Red, the next 2 number represent the Green and the last 2 numbers represent the blue. The smallest value of intensity is 00 and the maximum is FF. So, if we want pure red then the code would be FF0000 which means that Red is maximum intensity at FF and Green and Blue are off with minimum intensity, both at 00. so Pure green would be 00FF00 and pure blue would be 0000FF. Remember that the order is always Red Green Blue (RGB)
Thank you so so so much for your videos! I have started watching them since last year and I am a little sad as I just took my last ict practical exam, which means I probably won’t come around often anymore :( but I just really want to express my thanks, and wishing you all the best too!!
That is such a nice comment, thank you. I am glad my tutorials have been a good learning resource for you. Take care and good luck with your future endeavors. If you ever need help with excel you know where to go :)
Luckily this was an easy paper with no lookups or meta tags. Surprisingly, my paper went really smooth while practicing and just took 1 hour 30 minutes to complete
Yes. The procedure if i remember correctly is: Insert -> Media ->Windows Media Player then click to show all files and find your video file. your video is added. To change the dimension sizes. right click on the video ->active X properties -> click the tab Object Tag set the size you want. In the same window you will also find the alternative text box. This is where you would type the error message in the event that your browser does not support the video type.
thank you so much sir, wrote the theory paper today watching your theory video as a guide. you have helped me tons on paper 3 and 2. thank you so much sir, will let you know with the results in may 🙂🙂🙂🙂
That is awesome. Glad to have helped. Well done. You can now take a well deserved rest, unless you have other exams and the rest will have to wait. Looking forward to hearing yiur results.
Yes web expression is a bit different but what is important is to be able to understand what the question wants you to do. Once you have that then figuring out how to do it is a lot easier. I think the hardest component of paper 3 is the Spreadsheet as it requires you to first understand what to do and then figure out how to do it. The web design although quite a lot is involved 90% of it is the the same all the time so do 4 -5 papers and you basically have 90% of the paper. In HTM, a table, images / video with sizing, text, meta tags. Then css, learn the basics like table, td, headings, body, font and that is it. That is 80 to 90 percent of the web design.
Thank you this is really helpful and understanding but one mistake i have to point out at 22:22 the mistake in the css is that Border-collapse: collapse is written as "collapsee" which is the error we had to correct. Nevertheless, thanks a lot for the video
Yes you are right. well spotted. i corrected this later in the tutorial but did not point it out. Good job. This is why i generally prefer my students delete the css and start it from the beginning.
Hi I have a question. When you are setting the font for the h1,h2 font family why do u put the other fonts in speech marks but not the sans-serif? Doesn't it also have a space ? 29:42
XLOOKUP is an option. You can use XLOOKUP to replace Vlookup, Hlookup and lookup. You do not have to use it. You can use the other lookup functions instead. You will not get a question that will require the use of Xlookup. If you see the papers, they ask you to use a lookup function to solve a problem, they don't specify which one. So as long as you know and understand the other 3 lookup functions then you can solve any question. If you prefer to use the Xlookup to replace the other 3 that is also fine. Personally i tell my students to avoid the Xlookup as it is a new function and is not represented in the mark sheets yet.
I have exam tomorrow. You helped a lot with paper 2. But as I have experience in web development, your code is not the most optimized. That's why I dont like dw. Like that paddings in four lines looks wrong, but still, thanks for helping us with preparations
I am glad the tutorials helped you. For the web design you have to understand that this is not a web developmentbcourse and the level of thebassessment is basic. There a a number of things which are a bit outdated, like the use of tables but it is what the syllabus requires.
Thank you so much Sir for your support and uploading this video for us !! Did my paper 3 today and it went really really good !! Hoping for something good ...... Also can you pls share some tips about the paper 1 (Theory). That would really help...😊
That is great news. I am glad it went well for you. As for the theory, here is a video tutorial that will help you tremendously. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F5dBT2z1k9Q.htmlsi=eXeLFHuSpqi19CWd You can download the files i used in this vide from a link in the video description.
@@paphitisnThank you so much Sir!! I will check it out and surely let you know how the exam went...... 😊🙏🏻 Will be forever grateful for your support 🙏🏻
I messed up on Paper 2 yesterday because of Labels in MS Access which is why I almost missed out on the final PPT part. Tomorrow I have to do Paper 3 and this tutorial has helped me out alot, hopefully I can score high on this paper and pass IGCSE. Thank you!
wouldn't the width of the logo be written as style="width:100%" instead of width="100%"? as in the qp it says "Use inline style attributes to make sure that logo fits the full width of cell B". I always check the ms for this sort of questions but the ms for oct nov 2023 did not show the sample answers so i could not check. Anyway thanks for the tutorials they were amazing!
Thank you very much for all the help sir The paper went very well, there was mostly css modification and the video had to autoplay when the web page was opened In the excel we mostly needed vlookup, hlookup and basic functions along with the formulas they gave us But overall the paper was quite easy
Because there are no fixed values that i want to be absolute in the sum function. I want the referencint to be relevant so that as i duplicate down it uses the new cell references for the sum function. If you do not get this concept i strongly suggest you watch this tutorial as understanding relative, mixed and absolute references is extremely importatnt in Excel. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qgankq3WqAE.htmlsi=BRQSQKX0GIG--Dpf
the question paper specifically asks you to use video and source tags to add the video, so embed will not be included in the marksheet. Examiners will be looking for the video tag.
There are no software or hardware requirements. This is up to the school or exam center. Here is the link from CIE regarding software and hardware requirements. help.cambridgeinternational.org/hc/en-gb/articles/360000997069-FAQs-for-IGCSE-Information-and-Communication-Technology-0417-0983#anchor_17