Open Source Tutor
Open Source Tutor
  • 205
  • 657 523
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 …
มุมมอง: 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 - All Pseudocode
มุมมอง 18Kปีที่แล้ว
9618 - A level - All Pseudocode
9618 - A Level - Paper 4 walkthrough - Python
มุมมอง 6Kปีที่แล้ว
9618 - A Level - Paper 4 walkthrough - Python
Inkscape is Great for making Thumbnails
มุมมอง 258ปีที่แล้ว
Inkscape is Great for making Thumbnails
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
Staying Motivated in Digital Painting
มุมมอง 60ปีที่แล้ว
Staying Motivated in Digital Painting
A Level - 9626 - Javascript - Whole Syllabus
มุมมอง 9Kปีที่แล้ว
A Level - 9626 - Javascript - Whole Syllabus
Day 7 FinalProject
มุมมอง 29ปีที่แล้ว
Day 7 FinalProject
Day 6 Putting it all together
มุมมอง 65ปีที่แล้ว
Day 6 Putting it all together
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 4 Basic Forms
มุมมอง 39ปีที่แล้ว
Day 4 Basic Forms
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

ความคิดเห็น

  • @pardeepgaming9629
    @pardeepgaming9629 3 วันที่ผ่านมา

    hi

  • @milkbread4527
    @milkbread4527 3 วันที่ผ่านมา

    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.

    • @opensourcetutor1878
      @opensourcetutor1878 วันที่ผ่านมา

      Thanks for your thoughtful comment. I am on vacation now. I will read it carefully and respond when I get back!

  • @stwah_isreal
    @stwah_isreal 18 วันที่ผ่านมา

    Wont let me

  • @bhaveshmahakal
    @bhaveshmahakal 27 วันที่ผ่านมา

    Thank you 😊

  • @RC-Heli835
    @RC-Heli835 หลายเดือนก่อน

    Man this is just what I needed!😀

  • @dietpanini4000
    @dietpanini4000 หลายเดือนก่อน

    Goodluck to anyone binge watching videos before the exam tmrw !

    • @Zecos
      @Zecos หลายเดือนก่อน

      MEEEE RN 😭😭😭

    • @dietpanini4000
      @dietpanini4000 หลายเดือนก่อน

      @@Zecos I'm actually so cooked 💀 Good luck <3

    • @Zecos
      @Zecos หลายเดือนก่อน

      @@dietpanini4000 frrr I started prep like an hour ago and ive got my exam in 8 hrs ☠️ finna pull an all nighter smh

    • @rajveerjolly7933
      @rajveerjolly7933 หลายเดือนก่อน

      @@dietpanini4000 Cooked to the max. Watched it in 2x with skipping around lmao, worked

    • @rajveerjolly7933
      @rajveerjolly7933 หลายเดือนก่อน

      @@Zecos what's the plan ? past papers ? I tried to do one with linked lists and I was mad confused

  • @lmaolmao593
    @lmaolmao593 หลายเดือนก่อน

    can u share the link for the checklist?

    • @dietpanini4000
      @dietpanini4000 หลายเดือนก่อน

      It's in the description

  • @aymantariq7120
    @aymantariq7120 หลายเดือนก่อน

    pro tip from non pro: click Format at the top and then configure IDLE to change text size. thx for this vid

  • @AhmadouBaye
    @AhmadouBaye หลายเดือนก่อน

    i hate it when my dog goes bow wow

  • @leila9139
    @leila9139 หลายเดือนก่อน

    Amazing the night before my final ! thank you so much

  • @distractions3470
    @distractions3470 หลายเดือนก่อน

    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.

    • @opensourcetutor1878
      @opensourcetutor1878 หลายเดือนก่อน

      Best of luck!

    • @xxowrrxx
      @xxowrrxx 24 วันที่ผ่านมา

      Yooo I also have an exam tomorrow

  • @mohamedmahmoud-df5xd
    @mohamedmahmoud-df5xd หลายเดือนก่อน

    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?

  • @moiz.3979
    @moiz.3979 หลายเดือนก่อน

    26:10 if we write not before cheating, it will turn into true because the value of cheating was false

    • @opensourcetutor1878
      @opensourcetutor1878 หลายเดือนก่อน

      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

  • @leila9139
    @leila9139 หลายเดือนก่อน

    This was sooo helpful! thank you

  • @minerva3511
    @minerva3511 หลายเดือนก่อน

    Thank you for this!

  • @Thenthen158
    @Thenthen158 หลายเดือนก่อน

    OMFG I'M HAVING THE EXAM NEXT WEEK AND U SAVED ME LAST MINUTE=))) TYSMMMM

    • @anas6501
      @anas6501 หลายเดือนก่อน

      Same😭😭 Its on Friday and I am still struggling on pseudocode

    • @ordinary-bo3xs
      @ordinary-bo3xs หลายเดือนก่อน

      @@anas6501 I actually know nothing, im cooked

    • @oenguine
      @oenguine หลายเดือนก่อน

      @@ordinary-bo3xs same

    • @aalok2423
      @aalok2423 หลายเดือนก่อน

      wait ur doing your AS levels too? 😭😭😭

    • @anas6501
      @anas6501 หลายเดือนก่อน

      @@aalok2423 why do you think we all are here😭😭😭

  • @purple.4955
    @purple.4955 หลายเดือนก่อน

    It's amazing video, a few variations and possible mistakes, but as a refresher it's amazing. THANK YOU!!!

    • @opensourcetutor1878
      @opensourcetutor1878 หลายเดือนก่อน

      Thanks. Let me know in the comments if you saw a specific mistake.

  • @Mr_Boness
    @Mr_Boness หลายเดือนก่อน

    what is "inner left"?

    • @opensourcetutor1878
      @opensourcetutor1878 หลายเดือนก่อน

      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.

  • @kufff
    @kufff 2 หลายเดือนก่อน

    thankyou

  • @fluffybunnylee9037
    @fluffybunnylee9037 2 หลายเดือนก่อน

    hi, could i ask how we should display a certain number of reports of a line of the txt file?

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      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.

  • @davidb.e.6450
    @davidb.e.6450 2 หลายเดือนก่อน

    Thanks soo much on behalf of all of us using open source apps for our exams! God bless!

  • @ryankneen6763
    @ryankneen6763 2 หลายเดือนก่อน

    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

    • @agastya9785
      @agastya9785 2 หลายเดือนก่อน

      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

  • @abdulqodirmir
    @abdulqodirmir 2 หลายเดือนก่อน

    Amazing! Thanks! But more and simpler explanation for the 10th question would be much appreciated! Thanks again!

  • @riflevisiongaming9921
    @riflevisiongaming9921 2 หลายเดือนก่อน

    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?

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      That's right. After adding the grades table the link table was no longer necessary

  • @Anshu_saru
    @Anshu_saru 2 หลายเดือนก่อน

    why do we while true at try and except method

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      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

  • @khadichamadaminova2877
    @khadichamadaminova2877 2 หลายเดือนก่อน

    omg wtf you saved my life😭thank you so much

  • @JuancharroVlogs
    @JuancharroVlogs 2 หลายเดือนก่อน

    Thank you so much!!!

  • @chizaramoranezi4964
    @chizaramoranezi4964 2 หลายเดือนก่อน

    The exam is tomorrow 😭

  • @tozer0
    @tozer0 2 หลายเดือนก่อน

    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.

  • @riflevisiongaming9921
    @riflevisiongaming9921 2 หลายเดือนก่อน

    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?

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      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)

  • @simpleandminimalmaybe
    @simpleandminimalmaybe 2 หลายเดือนก่อน

    very helpful, thank you.

  • @h.sabha995
    @h.sabha995 2 หลายเดือนก่อน

    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

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      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.

  • @Cringetopia
    @Cringetopia 2 หลายเดือนก่อน

    is bro using linux?

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      Yes, I am!

    • @Cringetopia
      @Cringetopia 2 หลายเดือนก่อน

      @@opensourcetutor1878 dayum, how'd you get js/html working on visual basic?

  •  2 หลายเดือนก่อน

    excuse me sir, how many papers do you recommend solving?

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      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.

  • @bissessurtushal
    @bissessurtushal 2 หลายเดือนก่อน

    Thank you Sir ❤

  • @musiga_ve
    @musiga_ve 2 หลายเดือนก่อน

    Can you please cover Normalisation to 3NF, Data dictionary, and file and data management?

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      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!

    • @musiga_ve
      @musiga_ve 2 หลายเดือนก่อน

      @@opensourcetutor1878 thank you.

  • @xanax6555
    @xanax6555 2 หลายเดือนก่อน

    thanks

  • @saadnaeem1252
    @saadnaeem1252 2 หลายเดือนก่อน

    where can i find videos on 10.2, 10.3 and 10.5?

  • @C2trappy-bw8tr
    @C2trappy-bw8tr 2 หลายเดือนก่อน

    ndiwe machine

    • @C2trappy-bw8tr
      @C2trappy-bw8tr 2 หลายเดือนก่อน

      translation: youre a machine

  • @lenfiks6233
    @lenfiks6233 2 หลายเดือนก่อน

    Арс , если ты читаешь этот коммент , то знай , видео реально полезно

  • @adilrasul4180
    @adilrasul4180 3 หลายเดือนก่อน

    can i watch this video to study the 2023 syllabus ?

  • @prettymugisa
    @prettymugisa 3 หลายเดือนก่อน

    God bless you fr

  • @jessemcjordanm9935
    @jessemcjordanm9935 3 หลายเดือนก่อน

    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

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      Are you using Excel? Did you unpin the ribbon?

    • @jessemcjordanm9935
      @jessemcjordanm9935 2 หลายเดือนก่อน

      @@opensourcetutor1878 All went well in the end I did my practical on the 17th thanks for the help

  • @unknown36556
    @unknown36556 3 หลายเดือนก่อน

    thankyou so muchhhh

  • @riadulislam4849
    @riadulislam4849 3 หลายเดือนก่อน

    Very helpful sir. Thank you a lot.

  • @daraabahmed8993
    @daraabahmed8993 3 หลายเดือนก่อน

    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?

    • @opensourcetutor1878
      @opensourcetutor1878 2 หลายเดือนก่อน

      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.

  • @mrsscapybara
    @mrsscapybara 3 หลายเดือนก่อน

    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

    • @opensourcetutor1878
      @opensourcetutor1878 3 หลายเดือนก่อน

      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

  • @jparchive296
    @jparchive296 3 หลายเดือนก่อน

    Are you an angel

  • @Sudharsan04
    @Sudharsan04 3 หลายเดือนก่อน

    May god bless you

  • @JgTheUnrealistic
    @JgTheUnrealistic 3 หลายเดือนก่อน

    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