![Nicos Paphitis](/img/default-banner.jpg)
- Видео 140
- Просмотров 1 484 210
Nicos Paphitis
Кипр
Добавлен 24 ноя 2009
Channel dedicated to providing in depth learning resources for students and tutorials for educators on using technology in the classroom to assist teaching and learning. Learning resources are primarily focused on the ICT IGCSE [0417] practical units and Minecraft Education Edition. Educator tutorials are based on different aspects of technology so as to either teach new skills or make work easier. From remote learning techniques, assessment, Excel skills, advanced techniques and more.
How to IMPORT your timetable from ISAMS to your Calendar
Quick tutorial on how to import your Timetable from ISAMS to your calendar. Outlook Calendar, Google Calendar, iCalendar.
Very useful tip for educators.
Very useful tip for educators.
Просмотров: 14
Видео
2024 June Paper 31, Cambridge 0417 ICT [IGCSE]
Просмотров 3389 часов назад
In this video i explain and solve the complete Cambridge IGCSE ICT 0417 June 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 sour...
2024 March Paper 31, Cambridge 0417 ICT [IGCSE]
Просмотров 90821 день назад
In this video i explain and solve the complete Cambridge IGCSE ICT 0417 March 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 sou...
2024 March Paper 21, Cambridge 0417 ICT [IGCSE]
Просмотров 1,3 тыс.Месяц назад
In this video i explain and solve the complete Cambridge IGCSE ICT 0417 March 2024 Practical paper 2. 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 Word, Access, Excel chart creation and PowerPoint. A link to th...
Create a SEARCH FORM - easily find records [Microsoft Access]
Просмотров 388Месяц назад
Learn how to create a form with multiple input objects (text, combo boxes, options etc.) which you can use to enter search criteria and find records in a table quickly and easily. And functional buttons to run a query and reset your form directly from the form. 0:00 Intro 01:19 Demonstrating the Search Form i will be creating 05:10 Understanding the mechanics of how the search form works 07:04 ...
Excel SUM / SUMIF / SUMIFS explained.
Просмотров 3942 месяца назад
Learn about the various SUM functions and how to use them in different scenarios using constants, cell references, strings and wild cards. This is a complete tutorial so even if you are totally new to Excel you will learn how to use the various functions. This is a great tutorial for anyone taking the Cambridge ICT IGCSE 0417 Examination [ IGCSE ICT 0417 ]. 0:00 Intro 0:59 An analogy of the fun...
2023 SPECIMEN Paper 2, Cambridge 0417 ICT [IGCSE]
Просмотров 9 тыс.4 месяца назад
In this video i solve the complete Cambridge IGCSE ICT 0417 2023 Specimen practical paper 2 The Specimen paper is not an actual paper that was taken by students but a sample paper which is issued when there is a syllabus change. It is issued as there are no past papers based on the syllabus as it is a new syllabus and therefore it gives a good look in to the demands of the papers based on the n...
2023 SPECIMEN Paper 3, Cambridge 0417 ICT [IGCSE]
Просмотров 9 тыс.4 месяца назад
In this video i solve the complete Cambridge IGCSE ICT 0417 2023 Specimen practical paper 3 The Specimen paper is not an actual paper that was taken by students but a sample paper which is issued when there is a syllabus change. It is issued as there are no past papers based on the syllabus as it is a new syllabus and therefore it gives a good look in to the demands of the papers based on the n...
MIE Expert Self-Nomination guide 2024-25 for New and Returning MIEE's
Просмотров 3,7 тыс.4 месяца назад
This tutorial is for educators that are interested in nominating themselves as Microsoft Innovative Educator Experts (MIEE). It covers the process and NEW requirements for both returning MIEE’s and those applying for the first time (New Nominations). The information included in this tutorial is based on the, WW Educator Community 2023-2024 MIEE/SCS/INC call, so special thanks to Sonja Handeland...
Organize ONEDRIVE Files shared WITH YOU
Просмотров 6355 месяцев назад
If you have multiple people sharing files or folders with you for collaboration, it can get really difficult to keep them organized. In this tutorial i show you how you can easily and quickly organize files/folders shared with you. This can be done through 365 or directly from Windows Explorer. The best part is it will sync across devices. 0:00 Intro 0:49 Understanding what shared files are 01:...
2022 March Paper 31, Cambridge 0417 ICT [IGCSE]
Просмотров 4,3 тыс.5 месяцев назад
In this video i solve the complete Cambridge IGCSE ICT 0417 March 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. 0:00 Intro Task 1 1:21 Checking files and creating evidence document Task2 2:53 File management Task3 Web design 6:18 Q2 Analyzing the question 7:40 Q2 creating a...
2023 November Paper 3, Cambridge 0417 ICT [IGCSE]
Просмотров 26 тыс.6 месяцев назад
In this video i solve the complete Cambridge IGCSE ICT 0417 November 2023 practical paper 3 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. 0:00 Intro to paper Task 1 Evidence document 01:35 Creating the evidence document Task 2 File management 03:20 Q1 Creating folder and displaying files details h...
2023 November Paper 2, Cambridge 0417 ICT [IGCSE]
Просмотров 31 тыс.6 месяцев назад
In this video i explain and solve the complete Cambridge IGCSE ICT 0417 November 2023 Practical paper 2. 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. A link to the question paper and source files can be found at the bottom of the description. Use ...
Creating a Database with ACCESS - Quick intro
Просмотров 4046 месяцев назад
This is a a quick tutorial on how to create a simple flat file access database. This is a beginner level tutorial. If you want to learn how to use Access then make sure to check out my playlist which focuses on the Cambridge ICT 0417 syllabus. found here: ruclips.net/p/PLWeerq9oa1ncpklXGN8OFjVGQzK29znF_
2023 June Paper 32, Cambridge 0417 ICT [IGCSE]
Просмотров 6 тыс.7 месяцев назад
In this video i solve the complete Cambridge IGCSE ICT 0417 March 2023 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. 0:00 Intro Task 1 01:40 Setting up the Evidence document Task 2 Image Editing and file manipulation 03:28 Creating your folder 04:36 Image manipulation demonstrat...
Reading Progress & AI tools COMPLETE GUIDE
Просмотров 2737 месяцев назад
Reading Progress & AI tools COMPLETE GUIDE
2023 March Paper 31, Cambridge 0417 ICT [IGCSE]
Просмотров 4,8 тыс.8 месяцев назад
2023 March Paper 31, Cambridge 0417 ICT [IGCSE]
Guide to answering ICT Theory Paper 1, Cambridge 0417 ICT IGCSE, [May/June 2022 paper 11 solved]
Просмотров 13 тыс.9 месяцев назад
Guide to answering ICT Theory Paper 1, Cambridge 0417 ICT IGCSE, [May/June 2022 paper 11 solved]
2023 June Paper 31, Cambridge 0417 ICT [IGCSE]
Просмотров 23 тыс.10 месяцев назад
2023 June Paper 31, Cambridge 0417 ICT [IGCSE]
2023 June Paper 21, Cambridge 0417 ICT [IGCSE]
Просмотров 22 тыс.11 месяцев назад
2023 June Paper 21, Cambridge 0417 ICT [IGCSE]
Microsoft Word, Introduction to BASIC SKILLS
Просмотров 76711 месяцев назад
Microsoft Word, Introduction to BASIC SKILLS
DATA ENTRY Forms in EXCEL [NO Coding or Macros needed]
Просмотров 4,2 тыс.Год назад
DATA ENTRY Forms in EXCEL [NO Coding or Macros needed]
EXCEL Functions auto-update as data is Filtered [AGGREGATE]
Просмотров 2,9 тыс.Год назад
EXCEL Functions auto-update as data is Filtered [AGGREGATE]
Bypass or Disable Windows 11 "Show More Options" context menu
Просмотров 27 тыс.Год назад
Bypass or Disable Windows 11 "Show More Options" context menu
Mail Merge PICTURES to documents [step by step]
Просмотров 30 тыс.Год назад
Mail Merge PICTURES to documents [step by step]
Create PERSONAL student folders within Class Teams
Просмотров 640Год назад
Create PERSONAL student folders within Class Teams
Export a list of all Teams members as a CSV file
Просмотров 26 тыс.Год назад
Export a list of all Teams members as a CSV file
Bookings not syncing with Outlook Calendar [FIXED]
Просмотров 11 тыс.Год назад
Bookings not syncing with Outlook Calendar [FIXED]
Dreamweaver Worked Exercises (2)- Cambridge ICT IGCSE 0417 Web Design
Просмотров 2,7 тыс.Год назад
Dreamweaver Worked Exercises (2)- Cambridge ICT IGCSE 0417 Web Design
Can you please teach how to use comboboxes
Have a look at this tutorial on creating Data Entry Forms. It covers Combo Boxes. ruclips.net/video/zRO2oxJKmvs/видео.htmlsi=Fqav0OSj06KhHhBg
Sir can you please help how to add a 12 point space after a table, should I select the table and then go to paragraph setting to make it 12pt after or should I select the space after the table and make it 12 pt?
Either your table can not fit in the column wo move the while table to the next column, or, you have a section break which is splitting the table. Or, it could be something else. I can't really help unless i am able to see the file. If you are not able to find the reason, i suggest you remove the table, make sure everything is correct and then add the table again. The work you put in to try and solve this is going to teach you so many things and will improve your skills way more than just solving a paper . It is worth putting in the effort to resolve this.
Nice and easy! Thanks Nick.
@paphitisn , what does it mean when my webpage displays diamond question marks after using the meta charset tag in my html?? how do I get rid of them?
these are usually not supported character sets, but it depends on if i am understanding what you are describing and where these are appearing.
@@paphitisn could I email you a screenshot?
@@asantee_sana19 sure
I used my finger nails to take out the rivets a few are bleeding wouldn't recommend.
@@shadowslayer7574 ouch. Not a good idea. Hope the rest of the repair does not involve more physical pain.
Im at the part when i need to melt them in i was very carefull up to this point i need this to work
My keyboard wasn't broken the case was cracking in between the keys from this hinge area. I bought a new case for it which was not an easy feat. Hopefully I can finish this job with the zip tie trick.
@@shadowslayer7574 take your time. Let us know how your repair goes.
@@paphitisn What brand zip tie do you use? If you don't mind me asking idk if you said it in the video I just read a comment saying brand could matter.
@@shadowslayer7574 Nothing in particular. The ones i used had no brand name. Best way is to to do a test on one rivet to see if the 2 plastics weld together. Brand name is not the issue. It is what plastic the case of your laptop and zip tie are made of so simply going by zip tie brand is not going to help. Test one rivet.
@@paphitisn Okay thank you, i kept the scrap pieces of plastic so i can test on them. Thank you for all the help.
This is so helpful especially since I’m giving my CIE earlier than usual, I love your videos and I can’t tell you how many hours I spent watching them. Please continue making more tutorials 🙏
Thanks, Nicos, what a time saver and really simplified explanation of the whole merging / save file process
Hi Peter. I am glad you found this useful a d easy to follow. Thanks for your comment.
Hi, how can i use this to ky existing forms?
W
I've been watching your videos for a few months now. And I'm getting A now thanks to you. I was a C grade and you brought me up. Thank you so much.
Thankyou for your comment. It is a perfect representation of what my channel and video tutorials are about. Providing useful resources to students that want to improve. Going from a C to an A is no easy task, congratulations. I would love to hear how you do in the final exams. Next goal, an A*
nice but not try it yet
You're amazing sir!
you are the absolute best!!!!
@@alvaropinsiroli4568 i am glad you find the tutorials helpful. Thanks for your comment.
excelentvide
I scored A* just from watching you sir thank you for your guidance
WOW, AWESOME. Well Done! That is a fantastic achievment. Although my tutorials may have helped you prepare, the A* is down to you and all your hard work. Congratulations. Thanks for comming back toet me know how you did. Keep up the hard work and you will achieve all your goals.
I got A* after watching your video. Thanks a lot!!
That is AWESOME, WELL DONE!!! a fantastic achievement. Thanks for coming back and letting me know. I am glad the tutorials helped you.
I remember being in the exam centre and attempting this paper, was so confused about the countifs part. The solution only came to my mind in the last 10 mins
I hope you managed to add the functions in 10 min. Goes to show that you need to give your self time to understand the question so that you can figure out which function is needed.
@@paphitisn yeah, thankfully I was. Initially when I saw the excel functions and even after spending 20 minutes on them, I couldnt figure em out, I was so sure Id have to skip them but i didnt give up till the last moment.
@@damian2972 good job. Making use of every minute is the way to go. Even if you have answered everything you still use every minute to check and recheck
Thankyou. You've been so helpful.
I am glad these tutorials are helpful. Thanks for your comment.
Thank you so much for all the great tips! There is SO much reading on this exam and it was so stressful with a time limit! Still with your tips, really knowing the rubrics, and taking the practice exams that I purchased with the exam, I PASSED! Thank you!
Thanks for your comment. That is an amazing achievement, well done! It is not an easy exam to prepare for. I am glad the tutorial helped you prepare.
You're the best, god bless you NICK!!!
And you. Thanks for your comment. I am glad you found this usefull.
Amazing, Thank you very much
Hello sir if it is ok for you could you plz do 0417/31/m/j/24 and 32 🙏
These have only just recently been release so i will be solving and posting the June 2024 papers in due time.
Thank you for your reply sir@@paphitisn
Thank you, Sir. Just what I needed.
I am glad you found this usefull.
good morning Mr. Nicos as you might already know yesterday was reuslts day and if it wasn’t for your help and videos i wouldn’t have reached an A. thank you again and no words can describe how much you have done for me
The words in your comment have described everything. Thank you for your comment. An amazing achievement, WELL DONE! and well deserved. I am proud of you.
Great thanks
Thank you sooo much for all your help I secured an A* in ICT and I had no teacher I did it with God and RUclips thank you so so much I’ll tell everyone about your channel😊
That is absolutely AWESOME!!! Well done and congratulations on such a great achievment. It just goes to show that if you are dedicated you will suceed. I am so glad my tutorials helped you on your path of success. Keep up the hard work and you are bound to achieve whatever you put your mind to thankyou for your comment.
Yooo Mr Nicos my mans thanks for carrying me on the ICT practicals. During my mock exams I’d usually get a U grade on the practical exams because I didn’t know everything but I spent weeks memorizing your videos before the real IGCSE exams. I ended up getting a 79% which was a B, 1 mark away from a A. If it wasn’t for you, I would’ve been detained again. Thanks for saving my education :>
That is absolutely FANTASTIC! Well Done. I am so happy i was able to help you through my tutorials. 1 mark away from an A is worth asking for a remark. I would definitely go for a remark as it is not possible to go down to a C but possible to get an A (not that it matters). Well done once again, really happy and proud of you. Thanks for coming back and leaving your comment,
hello sir, had a quwery that how does weightage for ict work, like total marks count upto 220, i.e 70+70+80, but what is it weighted ot makei it out of 280. looking forward to a quick response.
@@AbdullahJan-kh3di paper 1 is 40%, papers 2 and 3 are each 30% of your final grade
@@paphitisn thank you!
How much that I need to get from the customer to replace this kind of keyboard.
This is entirely up to you. Only you know your worth. If you are experinced in this sort of repair then you will know that there is responsibility on your end on the event that you can not repair the device or you make it worse. If you are not experienced then you need to inform the customer of the risk that the repair may fail. If it does they take on the responsibility but you will need to decide who forks the bill for the bought parts. So at the end of the day your experience will determine the charge.
how to add text styles in ppt in the master slide
Be blessed so helpful, Nice instructions
@@GideonMacks thank you for your comment. I am glad this was helpful.
is this applicable to Office 365? Apps for Enterprise? the problem i encounter is that the original document close upon execution so only the first record is processed. It stops after processing the first record. How can i work around it?
Definately applicable. Dows it generate both the word and pdf of the first record? If yes check the file folder path and file names of the second record. To check, delete the first record so the second becomes the first. Run the macro, does it generate? If it does then you have probably made a change to the macro. Use the original macro.
@@paphitisn thank you for your reply and for your video. another subscriber here. Yes it always create the first record only. It generates both doc and pdf. I did not change anything. i just copy paste it, i also watch your video, checked them all lcharacter per character and renamed all my files to your files. My excel file however does have other columns, could it have affected the merge? how can i send a a screenshot of the error?
its work. thanks. but how to save pdf format?
i am glad. If you are the one generating the merged document, you will prefer this method so that it will automatically generate pdf documents as well: ruclips.net/video/NVk-XJ_4K8o/видео.htmlsi=RdHmeTQSqqpCrCu_
I got an A thanks to u❤
Congratulations, well done. That is a great achievement. I am glad the tutorials helped you prepare.
Hi Nicos, thank you, this helped. Just wondering how to navigate because l need to put the date at the top but obviously with the date l cannot split the documents properly
If you are the one doing the merging, look at this method instead. ruclips.net/video/NVk-XJ_4K8o/видео.htmlsi=QaCJh00cV6u0Jogv
sir at 9:40 in the video you mentioned we are not supposed to write in bullet points, but can we write like this for example in online shopping Advantages: faster as it saves time to travel to the store, saves money by ordering from home rather than travel to the store and buy items.... Disadvantages: Requires a stable internet connection. possible for hackers spying upon your personal data while you proceed to checkout.... please suggest, and if a question has two marks for mentioning the points: "Saves time to travel to store" "Saves money to travel to store" what if we compare both statements as "saves time and money to travel to the store and then order" will this still give me 2 marks?
if it is a compare and contrast question on or a question then no. I fit a a 2 mark question it will not be be a compare and contrast . If it asks for advantages and disadvantages then yes but you need to elaborate. As long as you elaborate on how time and money is being saved. What is faster? The number of marks will give you a good indication on what you need to answer.
sir can you please make a video on html using Microsoft web expression, as my school is using this software for IGCSEs, please help me sir, you have helped me a lot in practicals, just one more, 🙏 🙏
Sorry but i dont use web expression so i am not the right person to create a tutorial on it.
Hi Mr.paphitis can you link those excel sheets so we can practice as well
i don't keep the files i use for tutorials, sorry. The amount of data on these spreadsheets is very small so you can easily copy the data in your own spread sheet so that you can practice.
Sir for the Sum range function of (F3:F15, excel is showing an error that "Formula omits adjacent cells" even you have that error see the green strap on the cell, but when I tried clicking on the symbol, there was an option "update formula to include cells" and when I clicked the option, it didn't make any change to the formula but gave an answer "416160" can you please help which one should I follow?
This error simply means that you have made a selection (F3:F15) and these cells contain numbers for example. The cells next to this range, in this case cells F16, F17 and onwards also contain numbers. Excel is simply saying that you may have forgotten to select these cells. As long as you know what you have selected and it is correct then it is fine. In my exercises i only used small ranges of numbers so Excel is basically saying, maybe you wanted to use the other cells as well. I hope that makes sense.
Do we have to set table height as 90% aswell?? I am using frontpage
@@whiteninja7287 n No, the height is relevant to the content you put. You only need to set the width of the table. If you did put the height also you would not lose marks.
Nahhhhh, this teacher is way too good tbh..... Im pretty sure paper 3 is now secured for me... God bless you sir!!
Thanks for your comment. I am glad you found the tutorial useful. If you check out my playlists you will find tutorials for all the components for paer 2 and 3, uncluding me solving past papers. I also have a great tutorial on solving paper 1 questions with same answers. Good luck with your exams.
@@paphitisn Will do!!..your work is much appreciated sir🫡
I had a question that is when creating relationships do we need to enforce referential entegrity??
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.
Anyone has an update to this on the new Teams and updated Chrome browser? Nicos' step no longer works =(
This is extremely useful!!! THANK YOU!!!
I am glad to hear it. Thanks for your comment.
Ive been watching video after video, no-one has explained yet how to get OneDrive to show-up in File Explorer in the first place. I only see my files in the browser, they are not showing up in file explorer.
Send me an email at paphitisn@gmail.com and i will help you.
this helped a lot but i dont think one report is for 27 points im sure its the whole database
i am glad the tutorial helped you. Yes, the report is 13 marks. The whole database section is 27 marks for this paper.
Thank you very much 🙏🙏🙏
You are welcome.
Thank youuu!!
what does double or single mean in the data types
@@HamdanAllie it indicates the number of decimal digits allowed after the decimal point. Double allows for mor decimal digits than Single. Can't remember how many for each type for Access. I think it is 7 deci.al places for Single and 15 for double. Either will be more than enough for the exams so it does not really matter which one you use for numbers with decimal places.
@@paphitisn Thank you very much