@paphitisn the paper was interesting. The database section of the paper had included adding lists to the form which had me thinking fot a few, but i cracked it after some thought all thanks to your teaching skills.
@AishaPatel-g8w awesome, well done. That is what these papers are about. There are questuins that require you to keep calm and think. It is problem solving using the skills you have learnt. Good job.
i"d like to point out a mistake you made on 1:10:46 when you made the criteria for the "rank", in the question its stated that they wanted 200 or less ranked so the formula must be (=200) which makes the criteria that you wrote ask for 200 or above ranked games
tysm it really helped for today's feb/march paper, can you make a vid FOR "PAPER 3" 2023..... exam is on 6th feb, 4 days away !! (also can you cover X-lookup, as it's not there in any past papers yet for practise)
Already published. I already have a tutorial on Xlookup. You can see it here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dbCvU1zkoPM.htmlsi=1PRJKBHPjfOt2ExU
I am the videos are helpful. Thanks for the comment and the subscribe. As for Pep Guardiola did not know who that was but i guess i can see a slight resemblance. We have the same hair style.
May i ask why only design view is used whe editing the report, why not laytout view so that you wont have to keep switching between the two @@paphitisn
Hi I am going to do the may/june 2023 paper 2 on Wednesday and I was wondering if I should practice more on labels. And can you share some tips or difficulties that you had during the exam 🥰🙏🏽
@@uzumaki7108 Labels are pretty basic providing you can create the query. The only thing you can practice is creating custom labels. Practice making your own label dimmensions and number of columns.
Amazing video!! really helped with all the doubts I have! One thing id like to point out though, in 27:27 I'm sure they mentioned to make italic numbered list...weren't we suppose to make it italic?
@@paphitisn Thank you! And here too 1:30:59 I'm pretty sure the points were supposed to be in italics. Overall, thank you for the effort into this! I really appreciate it.
Thankyou so much sir, the video really helped me a lot while solving the 2024 feb/march series yesterday. Could you please make a video on Paper-3 as the exam is in 4 days.
mr nico do you have any videos for making links? i remembered that during one of my exams we had to make a link and that made me fail the exam since i didn’t expect it to be there. and if you do can i please know what’s it titled as im having my exams in a couple of days and i’m preparing now since i’m unsure of what would come exactly. all i know is that it’s paper 2
Here are links to past papers i solved where you have to add links to either files, locations or emails in PowerPoint and Word. Watch these sections and you will be a master on links :) from 2023 specimen paper, links in PowerPoint: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzfJRivKIyU.html From 2024 March paper 21, links in powerpoint: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6SVShuPsBTk.html From 2024 June P21, action button with link PowerPoint ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jDHgMuZPbp8.html From June 2024 paper 22, creating link to email in word ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vsd5TnNR8Sc.html
Do you mean 1 page wide or 1 page? Please note that i made a mistake which was highlighted by some of the viewers in the comments. For the Rank the question stated 200 or less so i should have used =200 so this would effect the number of results. This might be what is different in your report.
You dont have to for the exam but it is always good to have it enabled. If you know what it does then it is quite useful when designing databases. You do not need to know what it is for the exam but if you want i can explain it to you.
Sans Serif is not a font. It is any font that does not have serifs. Serifs are the little ticks on the letters. Compare Times New Roman and Aerial. You will see Times New Roman letters have little ticks. These are serifs. Any font with this ticks are Serif fonts. Fonts without these serfs are Sans Serif Fonts. Sans in French means Without and the ticks are known as Serif so Sans Serif. The 2 fonts to use int he exam (only because it is what is used in the marksheets) is Times New Roman for Serif and Arial for Sans Serif.
hello sir, in 31:24 while editing the document before printing you dont move the two words "to reach" even though they appear to be orphaned, was this a mistake or is their placement fine?
That is an orphan and i should have dealt with it. Well done for spotting it. This is exactly why you should check the printouts. It is difficult to identify small things like this from a screen which you scroll up and down.
I’m gonna do my exam in 2 hrs,thank you so much for helping me out throughout the entirety of ICT! I love you and I’m grateful for everything you’ve done for us!
@@cristianprodan5565 database was quite difficult.. PowerPoint and word were a breeze. I suggest focusing on database (assuming you’re doing variant 1 p2)
hey sir, i was doing a past paper but while finishing i realized the numeric values were in hastags like this ### during the query, was wondering why and how i could fix it please...
I just gave the 2024 may June variant one papers and they told us to columnar database with a group, if possible can you make a video on it so I can assure my marks
Hello sir, I did really well in the Paper 2 exam today because of your videos. You helped me a lot. But I have one question. In the question where it says to select text from a certain subheading to a certain paragraph and make it into 2 columns, I accidentally didn't include a full stop of the last paragraph and deleted the full stop accidentally, so the last paragraph doesn't end with a full stop. Is this fine, or will I lose a mark?
Well done!!! As for your question i dont think the examiner is going to notice the full stop. They are trained to mark positively so they will take a glance at the starting and ending words, so you should be ok. Please let me know what was in the paper. Did it include creating a chart in Excel, did it have Forms or Labels in the database? Well done once again, proud of you as you must have put in a lot of effort to prepare.
@@paphitisnThank you so much sir. The Paper was very similar to the 2023 Oct/Nov paper. The one thing that was different in the Word Document Production task was instead of importing an image and placing it in a paragraph, we had to insert our own cloud shape with the text "Cloud Gaming" With a 5 cm width. The databases part did not include forms or labels, but we just had to import 3 tables, create relationships between the tables, add new values to the table and create 2 reports. In the presentations part, we just had to create a vertical bar chart in Excel and place it in one of the slides, and we also had to edit a word to make it a link to a different document. Other than that everything was similar.
The database was pretty easy, just the two reports(the entire paper was basically a mirror of this one that you solved). There was a chart in excel but we had to paste it in the presentation. One of my database came in two pages whereas the question specified 1 page. I think I'll lose a mark there, and I alligned a shape wrong in word, so a mark there as well. In the chart, it said to only include age categories, so I omitted the total bar as well, hope that's correct. And there was a list in word which was split over two columns so I created some space for it to move to the next column and used widow/orphan control which also created some space to eliminate the widow. Will that cost me a mark for consistent spacing?@@paphitisn
@@mathskafunda4383 for the spacing it should not be an issue as it is not really spacing but ensuring you do not have split lists. as for the chart, yes removing the total would be correct if it did not ask to include the total. Sounds like you did a good job. well done.
thank you this helped a lot, but i have a questions, i know game_code was the appropriate primary field, but why couldnt have rank been chosen? it also had unqiue values for every record?
At 35:36 when i apply conditiinal formating you will see that rank has some cells highlited meaning they are duplicates, therfore can not be used as a primary key. The only column with no highlighted cells is game code.
@paphitisn i was about to ask why some values such as 5 were highlighted then i scrolled down and saw there were some duplication, thank u thats a neat trick t
only if the text or what needs to be seen is not visible or clear. Otherwise there is no issue with dark mode. You just need to be extra cautious with your printouts to make sure everything is readable and easy to see.
what an amazing teacher. thank you so much my exams are upcoming. i’ve stressed but just relying and learning from your videos thought me a lot. lots of love mister nico ❤
Best of luck with your exams. Thank you for your comment and kind words.remember to read intructions carefully and use all tbe time you have availae. Keep an eye on the time. Looking forward to hearing how you do.
i have a question, its asking me to only show the records that start with the word "cyrus" how do i write it because , like**cyrus** shows words with cyrus in them
like*cyrus* will return everything that contains cyrus if you want everything that starts with cyrus then it would be like cyrus* For everything that ends with cyrus then it would look like like*cyrus Notice the * positions.
This happens when you increase the size of the report in design view by clicking on the edge of the report and dragging it to the right. Students do this to have more space so that it is easier to make all the fields fit. First dont do that. Second, if you get that message print anyway. If your printout is OK and everything is displayed without any data being cut off then it is ok. Leave it as the examiner will only get the printout. If data is being cut off or it does not print the columns on one page wide then you will need to modify the report in design view to make the report narrower or do the report again and do not change the width of the report.
Please make a video ASAP for ICT Paper 3 for this series as we have our exam on 6th feb Also i have a doubt: What if i use a different tag for example rather than so is that ok and will i get marks. Please do mention this in your video you'll be making for Paper 3 Thank you
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.
It is supposed to be italic so you did the right thing. I will need to see the marksheet to see if you get a mark because the mark for formatting text is usually combined with other things like the title and the list italic so if you did not make the list italic you lose a mark. What is certain is that if you did not make the list italic you would lose a mark.
@@paphitisn I absolutely nailed it! This exact paper came and apart from the brief moments of panic when I forgot how to create columns I did great. Even triple checked I had the right order in the report thanks to you 😅
@@jadeobsessed1281 that is FANTASTIC. Well Done. Getting this exact paper was a spot of luck but takes nothing away from the effort you put in to preparing and learning the skills required. Great job. Thanks for comming back and letting us know how it went.
@@paphitisn Thank you so much for making these videos and even taking the time to go into the comments and check with us. I'll definitely be sticking around and hopefully find some web expression videos
I had a question - at 1:23:30 why did you prefer just using a textbox over using the UI's header and footer insert? I just thought that since the qp asked for a "header", we'd have to do it from that way only. @paphitisn
I have found the UI to be problematic at times so i prefer test box. Plus it is a consistent way to add any new info. As for the Exam there is no right and wrong way, as long as the print out looks like it is supposed to and any evidence you need to provide is correct then you are good. Remember, this is not a Microsoft exam so you can use any presentation software to take the exam so the exam board cannot require you to use features of PowerPoint.
hello, thank you for the tutorial, but on document production your second page, the second column has an orphan, that aside your databse, the second report has the "year 200 or less" wrong, you wrote ">=200" and it should've been "
yes, after indenting it generates an orphan which i should have resolved. Well spotted. This is why you must check your printing before submitting. I don't print so it is difficult to spot. As for the
Hello Sir, Just wanted to thank you for providing us with this resources and helping us to improve our knowledge!! My exam went really well !! Hoping for a 70 …. It wouldn’t be possible without your videos !! 🙏🏻🙏🏻☺️ Looking forward to paper 3, just gonna watch your videos and learn 🙏🏻🙏🏻
Like operator is used to find patterns using wild cards like the asterisk. for this particular query you do not need to add the like and can simply use the wild card and text. The reason i use it and teach my students to use it is for 2 reasons. First it reads better as a command so it is easier to remember and second because if you are asked to find a text pattern like A*1123 which should return all the items where the asterisk can be any value but begin with A and end with 123 then you will need the Like operator and they will already be familiar with it.
@@paphitisn excuse me sir, I have one doubt , today I done my board exam on paper 2. In that I have done on mistake . On query they asked to add a new data on the database. But when I entered it's automatically round offed . So will they decrease marks for these. And how much mark? .
@@mrmaster9362if they asked for the daya to be 2 decimal places for exMple, and yours is rounded then you will lose 1 mark. If they did nkt specify what formating that number should have then, you will not lose marks as examiners mark positively. They will not cut marks if you did something you were not asked to do, unless it effects something else you were supposed to do.
Your videos are truly amazing. I'm doing M/J 2024 sessions, variant 2, and paper 22 is on April 16, I don't have much time. Kindly make any video regarding web authoring, using microsoft web expressions, and all the key features maybe using past papers. Thanks again, Nicos.
This video helped me alot for my ICT Exams ever since i seen your videos, you were a life saver! you helped in Excel, word, database and such more. Thank you so much for helping me in Exams
Thank you for your kind words. It sounds like you put in a lot of hard work so all the credit it yours. i am glad i was able to help. Thank you for your comment.
A couple of questions: 1-Will the examiner mark my work based on the files/documents saved or my printouts? 2-Where do I save my resultant files/the edited ones? In the same document of my given source files? 3-Are we allowed watches to the exam hall (of course only displaying time)? 4- In terms of paper 2, Should I complete the tasks in their relative order or should I start with the one I think is easiest for me?
1 -Examiners only mark form the printouts. No electronic files are sent. 2 -Best to save in the same area as the source files. You can make a copy of the source files elsewhere incase you need them as a backup. 3 -there should be a clock or a projected time in the hall. I do not allow any watches or other electronic devices. Depends on the exam center. Digital or smart watches are not allowed. 4 -If you are comfortable with all the components then do them in the correct order as it will be easier for you to track what you have completed. I do suggest good time management. I don't really suggest doing things in a random order.