Hello, this is Justin, thank you for stopping by! I have over 25 years' experience teaching IT & Computer Science in the UK, and have been running this channel since 2008.
I welcome all comments and suggestions for future videos.
Thank you for taking the time to browse my videos - I sincerely hope you find them useful. If you do, please leave a comment, and consider subscribing.
Пікірлер
Best Video ever
Can you make more scratch videos please
Everytime I follow this Exsel keeps closing and crashing out on me… can you help know what I can do about this?
You are back!
Absolutely, and with a ton of new content I'm so excited to share!
Great tip there, and welcome back.
Thank you so much Andrew!
I copied your codes but it is not working can i send you my work?
The code in 8:50 to 10:26
Do feel free to share your Scratch project link here and I'll certainly try to take a look.
Thanks :D
You're welcome!
That was easy. Thank you!
Glad it helped!
I use "Justification" to have wonderful right-hand edges. Indeed, when using hyphenation, it creates jagged edges. Hyphenation creates an unprofessional, unreadable document. It is especially important not to have hyphenation when creating a book. One gets into widows and orphans -- ESPECIALLY with hyphenation. I don't like words hyphenated between pages? I am not sure I can think of an instance where hyphenation would be preferred. Thank you for your video.
Please say me how to put 3 hearts on the top and make one go if i die.....
Although it's for a different Scratch game, I do show how to add a lives counter in this video: kzread.info/dash/bejne/hntkxrppn9mxc9Y.html
Does this method also allow for subfolders in each folder? Great tip!
Yes, you can, although you'd need to add some additional lines to the Excel sheet if that's how you were creating it. Let's say you have folders named 'A', 'B', and 'C', and inside each of those folders you wanted folders named 'Data', 'Images', and 'Assets'. Here's what you'd need: MD "Folder A\Data" MD "Folder A\Images" MD "Folder A\Assets" MD "Folder B\Data" MD "Folder B\Images" MD "Folder B\Assets" MD "Folder C\Data" MD "Folder C\Images" MD "Folder C\Assets" It is also possible to cut this down using a loop, like this: SET folders=A B C SET subfolders=Data Images Assets FOR %%F IN (%folders%) DO ( FOR %%S IN (%subfolders%) DO ( MD "Folder %%F\%%S" ) ) I hope that helps, but do feel free to ask anything else. (I'm looking forward to when the Discord server goes live and questions like this can be shared more easily).
If you already have first and last names combined into a single column, then why bother splitting them if all you’re going to do is combine them back together with your formula?
Ah, it appears you have just discovered the mighty INVIDEO AI-tool, eh? Wow, do I LOVE-that-thing TOO!
Just experimenting! Not sure whether I'll stick with it, and it certainly won't replace my normal weekday videos, but thought it might help get the message out that this channel is active again!
@@TheTechTrain Awesome!
17:43 mins got me i dont have that much time there is only 2 hours for my school exibition
To create anything more than something "that'll do", you need to put in more time than those who are willing to settle for less than you can achieve.
@@TheTechTrain That"s right Do you only do scratch videos because i just want to subscribe to your channel and learn new things from you in my next exibition @TheTechTrain?
I do a lot more than just Scratch. Through my channel you can learn coding in Scratch, Small Basic, BBC Microbits, JavaScript, Roblox coding, and VBA. Lots of new tutorial series on the way soon (including a whole new Scratch game tutorial). Plenty to keep you busy! But if you have any suggestions or requests, do let me know.
MR J ARNOLD you did a mistake in editing the video you put the forever block without showing us in 11:25
Super easy fix! Great tutorial!
Thanks! Very glad it was helpful.
thankyou
You're welcome!
Simply great solution. Is there a way to create sub folder simultaneously when main folders are being created ?
Yes, you can, although you'd need to add some additional lines to the Excel sheet if that's how you were creating it. Let's say you have folders named 'A', 'B', and 'C', and inside each of those folders you wanted folders named 'Data', 'Images', and 'Assets'. Here's what you'd need: MD "Folder A\Data" MD "Folder A\Images" MD "Folder A\Assets" MD "Folder B\Data" MD "Folder B\Images" MD "Folder B\Assets" MD "Folder C\Data" MD "Folder C\Images" MD "Folder C\Assets" It is also possible to cut this down using a loop, like this: SET folders=A B C SET subfolders=Data Images Assets FOR %%F IN (%folders%) DO ( FOR %%S IN (%subfolders%) DO ( MD "Folder %%F\%%S" ) ) I hope that helps, but do feel free to ask anything else. (I'm looking forward to when the Discord server goes live and questions like this can be shared more easily).
I see #10 being quite the lot useful in Colouring ASCII art and the likes! :-)
Yes, that's a good point.
Dang! I never knew that Excel could be used to code things like creating folders in Windows, itself! This is a game-changer, for game-development! :-) Thank you so very much! :-)
I'm so glad you feel this is a useful thing to know! I hope it helps save you a bit of time in future.
@@TheTechTrain Oh, defs! I also see it being loads useful in sorting Voice-Files for games and such into unique directories, based on auditory categories and properties, such as formant, pitch, style, vocal-mode, et-cetera! Thank you so very much!
Really glad to hear that! If there's anything else you're aware of could do with being made a bit more time efficient, let me know and I'll see if I can come up with something. 👍
How about how to find and replace text of only a certain colour in, not Word, but PowerPoint?! Also, does this folder trick work in Excel 2021?
The use of a spreadsheet to help with creating the batch file creation of folders isn't just limited to Excel - you could just as easily use Google Sheets. Normal search and replace in PPT would not be able to identify specific colours of text, but I imagine it might be possible to use VBA to achieve that. Quite a niche need though!
15:00 i believe George Boole and not Charles Boole, Sir!
Oh my goodness, you're absolutely right! I clearly had a 'dumb' moment there. How silly of me - thank you for pointing out the correction!
thank you very much this was very helpful
Glad it was helpful!
im a young kid whos learning coding and my sessions are on friday and on other days im bored so i watch these (and damn, 12 cups of tea per day!? you must be really british lol)
That's fantastic that you're learning coding, and in your own time too! You'll be pleased to know that I have just relaunched my channel after three years away, and have a ton of coding tutorials planned/scheduled, including Small Basic, BBC Microbits, JavaScript, Python, and more. I also have a series coming out on creating your own games in Roblox and Unity, as well as 3D modelling in Blender to create game assets. I hope that will help with your boredom! And yes, you're right, I am very British, and am almost entirely powered by tea! ☕
Super
Thanks
I am American.. but UK educational contents are superior than American’s. 😅
This was excellent! Thank you.
You're very welcome!
I like your intro. Did you make that in ppt? I'll search your channel, but I'd be grateful of you saw and replied. Thx
Go to the arcade. He faces up and down. Have you only ever played the atari 2600/VCS version?
my is not working proper
good
Thank you so much
You're most welcome
you do hardwork ☺☺ really
Thank you, I'm glad you're enjoying the series!
Thank you, so helpful and easy to understand
Glad it was helpful!
You saved me
So glad!
Thank you!! Why did they put margin editing under "file" instead of "format"???
Glad it helped sort your issue!
crazy
so useful even now, thank you
Glad to hear!
tip: use clones to make the dots so that you dont take up lots of sprites
YOU ARE AN ANGEL!!!!! THANK YOU SOOOOOO MUCH!!!!!!!
Dear Mr. Arnold, thanks very much for this lessons block about Scratch. I'm sitting here next to my 12 year old sun and we are learning scratch together. It's a pity that there is no new videos coming out from you.
How fantastic that you are learning Scratch together, and that you're finding my tutorials useful. There are three Scratch courses available on my channel - this one, the Pacman game tutorial (kzread.info/dash/bejne/iZuhtLhrm7nge84.html&pp=gAQBiAQB) and the Platform game tutorial (kzread.info/dash/bejne/dKSEqsSapNq0eLA.html&pp=gAQBiAQB). Also... good news! I am returning to KZread, and have already recorded a heap of new videos which are currently scheduled to start going out from July 1st, and I have some great new courses, lessons, and series that I'm really excited about, so perhaps something new for you both to follow? If you have any questions or suggestions, do feel free to get in touch! Thanks again, and happy Scratching! 😊
Fantastic!!!
Glad you like it!
@thetechtrain can you help us register for the courses, I can't see the registration button or link. If I click on the course it just stuck on the same page.
The whole of this video course is freely available on this channel, just follow this playlist: kzread.info/head/PLKoCr_fHsiX8vrW6ybX2VcUvGDCSIxC8U&si=CntuAh4IKIXsyBiY
Ok thank you , what about the quizzes?
Ah, I think that maybe when I created these videos four years ago I may have mentioned my other website, computerscience.click, which (at the time) did include quizzes. Unfortunately that site has been restructured, and at the moment the quizzes aren't available. I'm so sorry. It's on my list to review, but at thr moment I'm very busy preparing to relaunch this KZread channel with a whole range of new courses and tutorials. Please do let me know if I can help at all.
@@TheTechTrain thank you for the reply, it means a lot. Just wanted to start with the introduction to scratch. It would be awesome if I could get the quizzes by email that is if you still have them.
They were online based quizzes, and I'm not even sure if they exist still to be honest. I'll take a look and see if there's anything I can do, but I believe they were part of a learning platform that's no longer connected. I'll let you know. Are you a teacher, looking for the quizzes for your students?
Your instructions are easy to follow and to the point. Thank you
Glad it was helpful!
How to make website link open in chrome new tab I want whenever I click on a weblink inside a pdf I want to open in a new tab Currently the situation is when I click on weblink it will start opening in same tab Please tell the Solution for this
How to make website link open in chrome new tab I want whenever I click on a weblink inside a pdf I want to open in a new tab Currently the situation is when I click on weblink it will start opening in same tab Please tell the Solution for this