![Open Source Tutor](/img/default-banner.jpg)
- 205
- 657 523
Open Source Tutor
เข้าร่วมเมื่อ 9 ต.ค. 2011
Hi,
I'm a huge open-source-nerd, and if you are too then this channel might be interesting for you!
This channel contains a bunch of tutorials all about open source software. The goals of the channel are:
- To help out open source projects by providing training/documentation
- To help out open source projects by giving demo's/examples
- Teaching is learning: if you really want to learn something well, try teaching it
- To teach: spreading knowledge for it's own sake
I'm a huge open-source-nerd, and if you are too then this channel might be interesting for you!
This channel contains a bunch of tutorials all about open source software. The goals of the channel are:
- To help out open source projects by providing training/documentation
- To help out open source projects by giving demo's/examples
- Teaching is learning: if you really want to learn something well, try teaching it
- To teach: spreading knowledge for it's own sake
9618 - A Level - Paper 1 Databases: All SQL syntax
The SQL syntax is not too complicated to understand, but it's a pain to memorise it all. That's why I created a list of 19 simple questions to help you out!
Download the exercises and solutions: paulgieske.gumroad.com/l/xpedx
In this video we cover all the SQL syntax for the Cambridge International A Level syllabus 9618.
DML (Data Manipulation Language): - SELECT - WHERE
- ORDER BY - SUM - COUNT - AVG - INSERT INTO - DELETE FROM - UPDATE - GROUP BY - INNER JOIN
DDL (Data Definition Language): - CREATE DATABASE - CREATE TABLE - ALTER TABLE - PRIMARY KEY - FOREIGN KEY … REFERENCES …
Download the exercises and solutions: paulgieske.gumroad.com/l/xpedx
In this video we cover all the SQL syntax for the Cambridge International A Level syllabus 9618.
DML (Data Manipulation Language): - SELECT - WHERE
- ORDER BY - SUM - COUNT - AVG - INSERT INTO - DELETE FROM - UPDATE - GROUP BY - INNER JOIN
DDL (Data Definition Language): - CREATE DATABASE - CREATE TABLE - ALTER TABLE - PRIMARY KEY - FOREIGN KEY … REFERENCES …
มุมมอง: 612
วีดีโอ
9618 - A Level - Pseudocode Paper 2 walkthrough
มุมมอง 3844 หลายเดือนก่อน
In this video we will walk through another paper 2 of the 9618 syllabus. 00:00:00 Introduction 00:00:21 Question 1 (basic questions) 00:10:16 Question 2 (bubble sort, flow chart) 00:25:25 Question 3 (abstract data type: cyclic queue) 00:38:40 Question 4 (testing, state transition diagram) 00:43:41 Question 5 (appending to file) 00:58:41 Question 6 (coding challenge: touchscreen)
9618 - A Level - Floating Point Representation (4 easy steps)
มุมมอง 2345 หลายเดือนก่อน
In this video we learn to calculate the Mantissa and the Exponent in 2's complement form to represent floating point numbers in binary. The 4 steps 1) Convert the number to Real binary 2) Convert the number to 2's complement form : - prepend with 0, if negative then flip the bits and add 1 to the LSB 3) Normalize: - shift up the decimal point to the left or right - negative numbers start with 1...
Trigonometry Practice Questions (IGCSE 0580)
มุมมอง 1288 หลายเดือนก่อน
Here are some practice Trigonometry questions for the Cambridge mathematics syllabus (0580). 00:00:00 Introduction 00:01:08 Question 1 00:04:07 Question 2 00:06:07 Question 3 00:07:50 Question 4 00:10:20 Question 5 00:14:20 Question 6 00:18:17 Question 7 00:28:25 Question 8 00:36:50 Question 9 00:43:12 Question 10 00:44:02 Question 11 00:53:20 Question 12
IGCSE Maths (0580) Past Paper Practice Problems - Mensuration
มุมมอง 1678 หลายเดือนก่อน
In this practice we walk through easy, medium and difficult past paper problems for IGCSE Cambridge Mathematics (0580). I recommend you try the problems yourself before watching the solution. Get the questions and the mark scheme here: - paulgieske.gumroad.com/l/fewvm This topic covers: - Area and perimeter of shapes such as: rectangles, triangles, trapeziums, parallelograms, circles and sector...
9618 - A Level - Computer Science Paper 2 Walkthrough (Pseudocode)
มุมมอง 2K9 หลายเดือนก่อน
I am going to walk through the summer 2023 paper 2 exam (zone 2). I will show all solutions, explain my thinking and also give tips on how to approach some questions. I have made some mistakes! Can you spot them? Let me know in the comments! 00:00:00 Introduction 00:02:04 Question 1 00:12:44 Question 2 00:25:45 Question 3 00:40:24 Question 4 00:49:17 Question 5 00:58:05 Question 6 01:15:45 Ques...
9626 Animation - Opentoonz - Whole syllabus
มุมมอง 641ปีที่แล้ว
This video covers the whole syllabus for 9626 animation through a series of exercises. In this video we will be using Opentoonz which is free and opensource. Resources: paulgieske.gumroad.com/l/bhxvm My website: paulgieskeblog.com/ Contents: 00:00:00 Introduction 00:02:00 Download ffmpeg, overview 00:15:15 Exercise 1 (frame-by-frame) 00:31:58 Exercise 2 (transformation tweens) 00:48:00 Exercise...
9626 - Photoshop - Whole syllabus
มุมมอง 1.9Kปีที่แล้ว
IMPORTANT note: Contrary to what I said in the video, I do think there is some chance that you will be asked to TRACE a bitmap during the exam. In this case you should do it in either Illustrator or in Inkscape. Make sure you know how, just in case! - Inkscape: th-cam.com/video/NOy21HAwp7c/w-d-xo.html In this video we cover all the photoshop specified in the a level 9626 syllabus for photoshop....
9626 - Inkscape and Gimp - Whole Syllabus
มุมมอง 779ปีที่แล้ว
In this video we will cover the entire A level syllabus for graphics, both vector and raster. Today we will be doing the free and open source version: Inkscape and Gimp. I recommend these for the exam because students can easily install them on their home computers and can do homework and self-study without needing to rely on the school computers or being forced to pay expensive license fees. R...
9618 - A Level - Python syntax - Whole syllabus (Paper 4)
มุมมอง 6Kปีที่แล้ว
In this video we will cover all the syntax we need to know for paper 4 for the 9618 currculum/syllabus. Note: - Hopefully this checklist is complete. If you can think of something I should add please share in the comments. - This is about syntax only. We do not cover other important topics like ADT's, sorting etc... Resourcse: paulgieske.gumroad.com/l/cdvey My website: paulgieskeblog.com/ Conte...
LipSyncing in Opentoonz using Papagayo
มุมมอง 420ปีที่แล้ว
In this video we talk about lipsyncing. It can be done manually, or we can use another FOSS tool (Papagayo) to help automate it! Get the resources: paulgieske.gumroad.com/l/sijhi Get the whole course at Udemy: www.udemy.com/course/getting-started-animating-with-opentoonz/?referralCode=AC48BD5842376C88D101 See my website: www.paulgieskeblog.com/
Animating flexible objects in opentoonz
มุมมอง 376ปีที่แล้ว
In this video we will learn about the plastic tool, which is perfect for anything flexible like a creepy tentacle. Get the resources: paulgieske.gumroad.com/l/sijhi Get the whole course at Udemy: www.udemy.com/course/getting-started-animating-with-opentoonz/?referralCode=AC48BD5842376C88D101 See my website: www.paulgieskeblog.com/
Rigging in Opentoonz
มุมมอง 1.7Kปีที่แล้ว
In this video we rig our character using the skeleton tool. The skeleton tool makes cut out animation easy! Get the resources: paulgieske.gumroad.com/l/sijhi Get the whole course at Udemy: www.udemy.com/course/getting-started-animating-with-opentoonz/?referralCode=AC48BD5842376C88D101 See my website: www.paulgieskeblog.com/
Opentoonz: Stage Schematic
มุมมอง 943ปีที่แล้ว
In this video we will learn about the stage schematic which is another way of grouping layers and giving them a hierarchy. Get the resources: paulgieske.gumroad.com/l/sijhi Get the whole course at Udemy: www.udemy.com/course/getting-started-animating-with-opentoonz/?referralCode=AC48BD5842376C88D101 See my website: www.paulgieskeblog.com/
Intro: Chapter 5 Opentoonz: rigging, plastic tool, lipsyncing
มุมมอง 330ปีที่แล้ว
Hello everybody. In this series of video's chapter we will be creating a short animation in the style of South Park. Through the course of this project we will learn the following tools: - Stage schematic - Rigging / skeleton tool - Plastic tool - Lipsyncing with Papagayo Get the resources: paulgieske.gumroad.com/l/sijhi Get the whole course at Udemy: www.udemy.com/course/getting-started-animat...
9618 - A Level - Paper 4 walkthrough - Python
มุมมอง 6Kปีที่แล้ว
9618 - A Level - Paper 4 walkthrough - Python
Digital Painting: How I finally started getting better
มุมมอง 80ปีที่แล้ว
Digital Painting: How I finally started getting better
AS/A Level - 9626 - MS Excel - Whole Syllabus
มุมมอง 10Kปีที่แล้ว
AS/A Level - 9626 - MS Excel - Whole Syllabus
A Level - 9626 - Javascript - Whole Syllabus
มุมมอง 9Kปีที่แล้ว
A Level - 9626 - Javascript - Whole Syllabus
A2 Level - 9626 - Mail Merge - Whole Syllabus
มุมมอง 4.6Kปีที่แล้ว
A2 Level - 9626 - Mail Merge - Whole Syllabus
A2 Level - 9626 - Animation - Adobe Animate - Whole Syllabus
มุมมอง 7Kปีที่แล้ว
A2 Level - 9626 - Animation - Adobe Animate - Whole Syllabus
Day 5 Recognizing basic forms in reference
มุมมอง 31ปีที่แล้ว
Day 5 Recognizing basic forms in reference
Day 3 Shapes - Rough lines - Finished lines
มุมมอง 26ปีที่แล้ว
Day 3 Shapes - Rough lines - Finished lines
Day 2 Recognizing shapes and curves in reference
มุมมอง 27ปีที่แล้ว
Day 2 Recognizing shapes and curves in reference
hi
Dear Mr. Gieske, Thank you very much for this video, alongside the other videos on your channel. You’ve been a massive help to myself and my fellow peers taking this exam. Apart from expressing my gratitude, I would also like to point out some potential errors - although they could just be misunderstandings for my part - to help my fellow peers. I noticed the use of “AS" instead of a colon throughout the video, e.g - DECLARE arrayScores AS ARRAY[0:5] OF INTEGER. In the pseudocode guide, a colon is used instead. Do you think that examiners would be harsh in this respect (i.e - would they not allow the mark for “AS")? Also, just to nitpick (sorry!) but the pseudocode guide says, "It is good practice to explicitly state what the lower bound of the array (i.e. the index of the first element) is because this defaults to either 0 or 1 in different systems. Generally, a lower bound of 1 will be used.” and you said at 56:02 that “it’s pretty normal to start at 0”. At 1:26:40, I believe the there should be = instead of : after TYPE. At 1:33:56, I believe that there is not meant to be a colon at the end of the line. At 1:36:41, it seems that your solution is completely different from the solution in the pseudocode guide (as the exact same example was used). The solution in the pseudocode guide was the following: TYPE LetterSet = SET OF CHAR DEFINE Vowels ('A','E','I','O','U'): LetterSet I do not have enough knowledge/experience to say that your solution is wrong, but I’m wondering if solutions that differ from the pseudocode guide are still accepted by examiners. Once again, thank you very much for all your hard work.
Thanks for your thoughtful comment. I am on vacation now. I will read it carefully and respond when I get back!
Wont let me
Thank you 😊
Man this is just what I needed!😀
Goodluck to anyone binge watching videos before the exam tmrw !
MEEEE RN 😭😭😭
@@Zecos I'm actually so cooked 💀 Good luck <3
@@dietpanini4000 frrr I started prep like an hour ago and ive got my exam in 8 hrs ☠️ finna pull an all nighter smh
@@dietpanini4000 Cooked to the max. Watched it in 2x with skipping around lmao, worked
@@Zecos what's the plan ? past papers ? I tried to do one with linked lists and I was mad confused
can u share the link for the checklist?
It's in the description
pro tip from non pro: click Format at the top and then configure IDLE to change text size. thx for this vid
Thanks for the tip!
@@opensourcetutor1878 na ty
i hate it when my dog goes bow wow
Amazing the night before my final ! thank you so much
Best of luck!
I have the exam tomorrow. Wish everyone watching this at the last moment good luck for your exam. Also pray for me, I am cooked.
Best of luck!
Yooo I also have an exam tomorrow
in 1:08:05 , it is supposed to be counter < 1, because if its counter > 0, the loop will end after the first try, because the counter will be 9, and 9 > 0, which is correct so it closes the loop right?
That's correct, thanks for spotting
26:10 if we write not before cheating, it will turn into true because the value of cheating was false
That's correct. So in other words, because cheating is FALSE the condition (NOT cheating) turns to TRUE. So we proceed with the congratulations message
This was sooo helpful! thank you
Glad it was helpful!
Thank you for this!
OMFG I'M HAVING THE EXAM NEXT WEEK AND U SAVED ME LAST MINUTE=))) TYSMMMM
Same😭😭 Its on Friday and I am still struggling on pseudocode
@@anas6501 I actually know nothing, im cooked
@@ordinary-bo3xs same
wait ur doing your AS levels too? 😭😭😭
@@aalok2423 why do you think we all are here😭😭😭
It's amazing video, a few variations and possible mistakes, but as a refresher it's amazing. THANK YOU!!!
Thanks. Let me know in the comments if you saw a specific mistake.
what is "inner left"?
Don't worry, it's not on the syllabus. But basically it is the same is inner join, but while inner join only shows the records where both keys match, inner join left shows all records in the left table.
thankyou
hi, could i ask how we should display a certain number of reports of a line of the txt file?
If you want to display multiple lines from a text file you could use a loop and read each line and then output it one by one.
Thanks soo much on behalf of all of us using open source apps for our exams! God bless!
Exam this Tuesday and wish I found this channel esrlier. Watched your Access video last night and just watched this. Think you might be my saviour
i havent prepared at all lol, got really good in AS but got so drained that didnt prep for A2. Without these vids god knows where i would be @opensourcetutor1878
Amazing! Thanks! But more and simpler explanation for the 10th question would be much appreciated! Thanks again!
Sir when you deleted the student and class link table it’s cause the same thing was present in the grades table but with more fields and useful information right.The grades table basically did what the previous link table did but more,am I right?
That's right. After adding the grades table the link table was no longer necessary
why do we while true at try and except method
While true will loop indefinitely. In this case we need to be careful: We need to make sure we include conditions which will break the loop, and then use the keyword 'break' to end the loop. It's basically the same thing as a conditional loop but the breaking condition(s) is/are included somewhere in the loop
omg wtf you saved my life😭thank you so much
Thank you so much!!!
The exam is tomorrow 😭
GL!
One of the most straight-to-the-point and well summarized videos I've ever seen so far. My exam is near and I needed some tips and tricks that could possibly help me, and I stumbled upon this. Absolutely love you for all the educational contents.
sir at 7:50 on the top right we have 2 colored boxes: one red and one blue. Does the red one only affect paint and does the blue box only affect the eraser tool?
Great question. The eraser behaves in quite an intuitive way for some reason. In some cases it paints with the background colour instead of erasing. Have a look at this thread for an explanation (community.adobe.com/t5/photoshop-elements-discussions/help-my-eraser-tool-is-painting/td-p/2927045)
very helpful, thank you.
can you please do a quick video for illustrator in the near future? your videos are really helpful and i have exam on 23rd of april
Thanks. Sorry, I am super busy I don't have time. I recommend inkscape if you have the choice. In my opinion it's a bit better and it's free to install.
is bro using linux?
Yes, I am!
@@opensourcetutor1878 dayum, how'd you get js/html working on visual basic?
excuse me sir, how many papers do you recommend solving?
I'd say the more the better, but of course you have to balance it depending on how much time you have and also consider the workload for your other exams too. Now that we are approaching the exam perhaps try to do 1 paper every two days.
Thank you Sir ❤
Can you please cover Normalisation to 3NF, Data dictionary, and file and data management?
Sorry, I don't have any time right now. But since this comment already has 3 likes I'll consider it for next exam series (sorry, that doesn't help you though) Good luck on your exams nevertheless!
@@opensourcetutor1878 thank you.
thanks
where can i find videos on 10.2, 10.3 and 10.5?
ndiwe machine
translation: youre a machine
Арс , если ты читаешь этот коммент , то знай , видео реально полезно
can i watch this video to study the 2023 syllabus ?
Yes!
God bless you fr
It's sad to say but there's a vast difference between excel and the platform you're using. I got stuck at highlighting the cells
Are you using Excel? Did you unpin the ribbon?
@@opensourcetutor1878 All went well in the end I did my practical on the 17th thanks for the help
thankyou so muchhhh
Very helpful sir. Thank you a lot.
question while doing file management is it important to declare the variables as an array or not cause i think the programme would work just fine without it or not?
You could probably do it without arrays. The advantage of using arrays though, is that you store all those values in memory and can easily access it again in the future.
for the amy question would this code be okay too? DECLARE DoctorsNote : BOOLEAN DECLARE NoteFromParents : BOOLEAN IF DoctorsNote TRUE OR NoteFromParents TRUE OUTPUT (‘’You can retake the exam’’) ELSEIF OUTPUT (‘’You cannot retake the exam’’) ENDIF
Close but we need to do IF DoctorsNote=TRUE OR NoteFromParents=TRUE THEN ... Also no need to use ELSEIF. Simply use ELSE instead. Also, just to nit-pick a bit: technically the two booleans should get assigned some value after being declared. If not they will have a value of NULL by default
Are you an angel
May god bless you
OH MY GOD IVE BEEN LOOKING FOR SO LONG TO FIND AN ANIMATION SOFTWARE THAT OFFERS SHAPE TWEENING FOR FREE! If this works how I want it to... thank you.. thank you so much