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.
Thanks so much for showing how to hide worksheets. However is there a way I can encrypt the entire workbook with a password before entering it, but keep it on auto save so multiple people can still edit at the same time?
Hi Nicos. Great vid. I tried this but I can’t seem to get the image to appear. No error occurs, it just doesn’t show. I wanted a different signature to appear based on the school house they belong to
i would suggest you double check you file path as specified in your spreadsheet. Make sure it is correct and that the file names of the images are correct.
Hey Sir. I have a question. For database, price said currency symbol and 0 decimal place but you put one…was that an error or I’m supposed to do that too?
hey nicos thanks for giving a brief and detailed explanation thanking for ages for my good score in particles i would highly appreciate the tip that need to taken to crack my ict theory
Hi, this is realy helpful once I figured out the solution to the errors Ive been receiving 😢 i got “ the selection does not consist of heading levels” after trying to create a show document Hope you could help! 😊
this is a great method if someone else did the merge and sent you the merged document . If you are doing the merge then i suggest you use this method. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NVk-XJ_4K8o.htmlsi=qVkowMeIp0ZrYCPT
This man is a legend, my teacher is way too lazy to teach us, and she just gives us past papers as a test, and since all of them are the same i came here for help im in form 2 (Grade 9) thanx alot!!! im gonna ace my exam tommorow (and if i remember, i might post my results) :]
How to get files in Onedrive - Personal?...I am asking this bcoz i have already used shared file in windows explorer in onedrive - personal for almost 2 years now..but suddenly i stopped showing and syncing shared with me folder in my explorer... I already tried these : 1. unlink and relikng account. 2. uninstall and reinstall onedrive. 3. relaunching onedrive. 4. restarting PC. 5. after uninstall i removed all local files and reinstalled still no use. 6. windows is up to date . i already checked. 7. one drive is up to date. 8. revoking access and giving access again but no use (here i also tried doing uninstallation, relink etc.). PLz help.....
Thanks for this resource! I am also getting the error, "A field calculation error occurred in record #". I don't have any calculations in my workbook. I also created a new one from scratch and that didn't fix it, either. I've been googling like crazy with no solution. I'm doing the merge from a folder on my desktop, not in the cloud. It's only like 4 merge fields (a name, a date, a $, and a number). Is it mad because my document is 30 pages long?
Adding: It leaves me with the saved files having that error message listed 3 times, and then it has OPEN the documents done correctly but named wrong, so I still have to Save As.
I would first test with a single page document to see if that is the issue and go from there. If the single page document gives you the same error then you will need to check the collum titles in the spreadsheet so that they are correct and check that the file paths are also corrrect.et me know how it goes.
@@kelseyberteaux6093 it could be a memory (ram) issue. You could try on another device or increase the number of pages when you merge till you find the limit . I have never merged a doc more than 15 pages long.
Thanks for the very detailed presentation. I have a small question, i didn't see such an option in your Video. I want to create a service to book a course, is there a way to prevent a user to book the same course more than once ?
Sorry for delayed response. Unfortunately this is not an option in bookings and is a well known issue. I discourage multiple bookings by requiring users to enter a one time password to make their booking. This required them to enter a valid email address. The other way to combat this is if the users booking are all in your company then you could make an MS Form which people can only submit once and after they have completed a simple form like name and email it will give them the link to the booking page. As the form is set up for only 1 response then they can only make 1 booking (unless they copy the url). As i said there is not inbuilt way.
Thank you Nicos, This is such a useful Tutorial. Thank you also for the downloads. I am getting an error message run time error 5852 requested object is not available. Something to do with marking the last page - do I have to edit the document on the last page with a zero?
Makesure you are not saving the files in a synced cloud folder like onedrive or in a protected location. Use documents or desktop location. Make sure you have acurately entered the folder locations in the spreadsheet. Make sure the headings of the columns in the spreadsheet are exactly correct unless you have changed the code. Let me know how it goes. Your error is related to it not finding the folder locations so double check everything.
Hi Nicos, thank you so much for this excellent tutorial! It will save me so much time! However I am getting an error message - runtime error 5852 requested object is not available. Its something to do with marking the last page? If you can help, it will be very much appreciated.
Make sure the paths are correctly identified in the spreadsheet. Nake sure rhe headings are exactly as i named them unless you modified the code. Do not use a synced cloud drive as your location to save the files. Your error is related to it not being able to find the path you directed it to save the files. Let me know how it goes.
@@paphitisn Does it make a differnece that I am on a apple mac - my path names are such /Users/sandra/Documents/MailMerge/WordDocs /Users/sandra/Documents/MailMerge/PdfDocs
@@SandraMeechamyeah probably. I had another person that was trying to get this working with a mac. Cant remeber the outcome. Have a look through the comments and you may find the comment and maybe find an answer.it should work on a mac providing the path name is correct and accessible without access restrictions. Let me know how it goes.
they have a copy of the protected doc. This way they can test their code and see if they got all the answers correct. if not then the doc does not open. When they open the doc they read the instructions and send you an email or give you the secret message in the document. If you do use this i would love to hear feedback from you and how your students found it.
this is a better version and way more fun. It resolves the issue where students get stuck on one question and can not move on. as a result they give up . ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yPdgas5b-ws.htmlsi=MM1eu6VA5uB2XIa_
@@paphitisnThank you! This is actually for work :) I’m creating a Virtual Escape room for our monthly happy hour as we all work remotely. This was super helpful!
@@Unluckywinner805 then you really need to use the modified version i sent you. it is really fun and very frustrating. Especially if you want to get creative. The first version will also work great. Would love to hear how it goes.
@@bhuvanashreesai6598 for the IGCSE syllabus probably for now, yes. Will still be making more on Exxel but i think for 0417 exam, the playlist is complete.
Hey Nicos! I got an A(88) in ICT IGCSE this feb/march 2024 all thanks to your videos 😄😄 Without your help I couldn't have accomplished it. Btw wondering do you teach for IT As and A level? Wondering if you could make some videos on it :)
That is amazing, well done. I am glad the tutorials helped you. Thank you for coming back and letting us know how you did. We have moved from A level ICT to Computer science but i have not had the time to produce videos on these subjects. For ICT a lot of the material used in the IGCSE is relevant, the main difference is you are not guided on which formulas to use and you will need to build formulas by nesting formulas in Excel. For Databases it is quite similar but what most students find difficult is normalizing tables to create relational databases. Other components are multimedia components and this really depends on the software used by the exam center.
A job like this can be a bit overwhelming. However, if you are planning to buy a new one why not give it a go, especially if you are planning to throw out the old one. The best way to learn is to practice with zero risk and as you have decided to throw it out anyway, you have zero risk, apart for the 30 odd dollars you are going to spent on the replacement keyboard.
This was so HELPFUL!!!! You saved me so much time! I was trying to figure out how to add a bookable session for up to 4 people. Very easy to understand the step by step process. I set up my booking page while you demonstrated! Thank you again!
Hi, this is fantastic! It worked like a charm when I tried it as an example. However, now that I try it again with final set of images I have, I get an error "Error! Bookmark not defined." I have the same full folder and file path in excel. When I toggle the bookmark I see INSERTPICTURED:\FOLDER1\Temp.PNG. Please help
that error is associated with it not being able to find the files. Check your paths to the pictures. Let us know if you getting working and what your issue was as it could help others.
When I click "create" I can see that it wants to create separate documents, but it doesn't. I'm getting the sense that it has something to do with being synced to One Drive. How do I circumvent this?
Do not use a synced folder like onedrive as your target folder to create the files. Change the target folders to a filder on the desktop or any other llocal location whic does not require elevated user access. Your documents folder will also work.
Great step by step presentation, thank you. Good to learn to start with Forms for Excel. A question please - Do you have a video or steps on how to get multi-choice text answers from a question in Forms, to populate into separate columns when the results appear in Excel? Currently all the answers are appearing in one cell separated by semicolons. I'm hoping there's a nice solution as the results appear, rather than having to manipulate the text after in Excel. Thanks
I would need to see an example but from what you have explained, directly from Forms no. From Excel though it is a simple task of selecting the data with the answers separated with ; from the Data ribbon select Text to Columns, Click next and in the section, other, for the separator enter semi colon. ; Your answers will be separated in to columns.
@@paphitisn Thank you, yes, I have been able to do the Text to Columns. Unfortunately the options don't necessarily appear in the same columns, because Forms is not counting blanks. So I have to do a lot of manipulation of the text in Excel. Is there a way to add something (like "n/a") for options that are not selected by the responder when they fill out the form? Perhaps that would let all the options or "n/a" appear in the correct column? Thank you again
@@DianaJ88_ Hi, if you are able to send me a sample form and a copy of the results i will try to see if i can come up with a solution for you. Again, a dummy sample form with the results. Make sure no personal data is included.
Just want to say thank you again for your help and suggesting VLOOKUP using Mixed References. Your teaching on the videos makes often complicated formulas easy to understand and use!!
You're officially my new hero! I was trying to merge a document into individual files and all of the other video tutorials caused my images to disappear and the document spacing to get thrown way out of wack. This was absolutely PERFECT for my needs. And THANK YOU for making the code available for us to download.
That is great to hear. I am really glad this tutorial helped. Thanks for your comment. Just to let you know, i also have a tutorial on merging images. Particularly great for certificates.
I dont understand the question but i have complete tutorials on HTML and CSS code. They are based on the ICT IGCSE curriculum. If you have trouble finding them let me know
This was fantastic and wonderful to use for making a photo directory with names of those in the photo listed below. THANK YOU SO MUCH. Following the channel for more awesome hacks!
Hey Nicos, this is a GREAT demo, in fact it could be the best I've watched (and I've watched LOADS). I really like your presentation, delivery, step flow: where you're not 'fluffy' nor spend time on additional info (like the formulas). I also like that you don't going on and on and on about background what you can use the form for and so forth (which again, anyone wanting to know the 'meat' of the how-to doesn't actually require. You also have clear English and didn't seem to talk to fast where I had to 'rewind' to catch what you were demonstrating. So, what about the things I didn't find helpful or like..... hmmm, I have to think really hard and get back to you on that one........... In the meantime, MANY THANKS! 😉
Hehe, you had me worried at the end. I am glad you found this tutorial useful and easy to follow. Thank you for the kind words in your comment, i enjoyed reading it.
I use hot air gun, that way when i lift the metal plate - plastic rivets thin out and are easy to put on the metal back on. But marking is a great idea, as i sometimes skip one or two..
Have not tried using hot. My fear was that you would not have to peel off the back plate in parts as you would not be able to remove the back plate in one due to the rivets cooling down. Possibly running the risk of either bending the back plate or overheating the face plate of the keyboard. If it worked for you that is great. If you can reuse the entirety of the rivets to refasten the new keyboard then that is perfect.