IGCSE ICT May June 2020 Paper 21 Data Manipulation (Database Part 1)

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ต.ค. 2024
  • In this video, I solve questions from the May/June 2020 IGCSE ICT Paper 21.
    DOWNLOAD FILES USED IN THIS VIDEO
    You can download the question paper, mark scheme, worked and source files from this link: www.dropbox.co...
    HOW TO SUPPORT THIS CHANNEL
    If you would like to support this channel, you can donate any amount via this link: paypal.me/Evan...

ความคิดเห็น • 124

  • @juanbordoy9537
    @juanbordoy9537 4 ปีที่แล้ว +48

    The return of the king

  • @serafina2881
    @serafina2881 4 ปีที่แล้ว +39

    my paper is literally in an hour. Thank you so much! you’ve saved my whole class. Good luck for everyone sitting for Oct/Nov 2020

  • @waleedoo
    @waleedoo 4 ปีที่แล้ว +38

    Man Im now in University and still subscribed to you, nice to see the dedication, keep it up Sir.

    • @EvansChikasa
      @EvansChikasa  4 ปีที่แล้ว +9

      Much appreciated Waleed, I hope you are enjoying your university studies

  • @amalthiru206
    @amalthiru206 3 ปีที่แล้ว +20

    My 94% (A*) in ICT in June 2018 was all because of you! Thank you so much!!

    • @EvansChikasa
      @EvansChikasa  3 ปีที่แล้ว +6

      Wow, excellent work Amal, and thanks for using my videos. All the best in University

    • @ProGamer-wb4zs
      @ProGamer-wb4zs 3 ปีที่แล้ว +4

      hii amal, can we talk pls?

  • @ramandeepsingh1694
    @ramandeepsingh1694 4 ปีที่แล้ว +21

    Hi I just realized that you have missed one point for step 23 which is to sort your data in descending order of point. pls check

  • @appi654
    @appi654 4 ปีที่แล้ว +15

    Im now a university student and finished half of my degree, really happy to see you upload again and it was nice to smile and look back. Keep up the great work guiding the youth.

    • @EvansChikasa
      @EvansChikasa  4 ปีที่แล้ว +5

      Thank you Fawaz for dropping by. So glad to hear you are now in University. I wish you the very best for your studies

  • @joelloforte4220
    @joelloforte4220 4 ปีที่แล้ว +109

    Who is here because they have exams tomorrow ?😂😂

  • @Momodou667
    @Momodou667 3 ปีที่แล้ว +5

    my practical exam is tomorrow and im telling all my friends to watch him

  • @romeo9782
    @romeo9782 3 ปีที่แล้ว +5

    This man is a real life saver 😭

  • @alexacortana123siri9
    @alexacortana123siri9 4 ปีที่แล้ว +13

    Sir please do the May June 2020 paper 32 as quick as possible my exam is in 3 days and your videos are amazing

    • @faheem4581
      @faheem4581 4 ปีที่แล้ว +1

      Yes, please upload as soon as possible, my exam is tomorrow

    • @ruthmukherjee9937
      @ruthmukherjee9937 3 ปีที่แล้ว

      @@faheem4581 how was ur exam😂

    • @faheem4581
      @faheem4581 3 ปีที่แล้ว +2

      @@ruthmukherjee9937 Practicals went awesome, theory not so good, but overall A*

    • @ruthmukherjee9937
      @ruthmukherjee9937 3 ปีที่แล้ว

      @@faheem4581 ayy nicee, have mine in 3 days, mocks

    • @faheem4581
      @faheem4581 3 ปีที่แล้ว

      @@ruthmukherjee9937 ohhh, gl

  • @badxbane4001
    @badxbane4001 2 ปีที่แล้ว +2

    you've saved the exams of my whole class and they are subscribed to you.thankx evans chikassa for this supportive content for student

    • @EvansChikasa
      @EvansChikasa  2 ปีที่แล้ว

      Great to hear that. Regards to the class and all the best

  • @sydneyhazel277
    @sydneyhazel277 3 ปีที่แล้ว +6

    thanks again!! i love the extra explanations + some small chit chat :)) makes this more fun

  • @5ulood3bdulla36
    @5ulood3bdulla36 4 ปีที่แล้ว +4

    EXAM TODAY , in 2 hours or less , need your prayers sir !

    • @mikmongo8921
      @mikmongo8921 4 ปีที่แล้ว +2

      same less than 2 hours

    • @5ulood3bdulla36
      @5ulood3bdulla36 4 ปีที่แล้ว +1

      @@mikmongo8921 how did it go ?

    • @mikmongo8921
      @mikmongo8921 4 ปีที่แล้ว +1

      @@5ulood3bdulla36 ez

  • @shahidkhan-yn1jv
    @shahidkhan-yn1jv 3 ปีที่แล้ว +2

    brother seriously you saved my exammm......may God bless youu

  • @oloratokefhilwe7094
    @oloratokefhilwe7094 4 ปีที่แล้ว +5

    i beg of you , please alevels IT

  • @optimus9165
    @optimus9165 2 ปีที่แล้ว +1

    Is it bad sign if I learnt more from this than I did from 2 months of my teachers screaming her lungs out and not making sense.

  • @irewolebolusemihi1374
    @irewolebolusemihi1374 ปีที่แล้ว

    WOW my exams are in 11 days and im grinding so hard, I"ve seen all kinds of teachers but youre one of a kind thank you!

  • @jennirenepandit
    @jennirenepandit 3 ปีที่แล้ว +2

    THIS is a teacher.

  • @d3einc393
    @d3einc393 4 ปีที่แล้ว +4

    Hi sir , please may you kindly help with AS Level 9626 IT May/June 2020.
    Then I have a question. How come you don't do A level IT papers?😭it would be really nice if you did them. You are reliable and trustworthy lol.
    Thank you for the effort you have put to help us in different areas though😊

  • @clchan1587
    @clchan1587 4 ปีที่แล้ว +4

    hi sir did you sort into descending order of Points?? i dont think i saw it

  • @niayayayayayay
    @niayayayayayay ปีที่แล้ว

    tmrw is my first ict board exam and i dont know ANYTHING, this man is saving my life.

    • @bonsaidaddy9970
      @bonsaidaddy9970 ปีที่แล้ว

      did u pass?

    • @bonsaidaddy9970
      @bonsaidaddy9970 ปีที่แล้ว

      u have more guts than me bro goddamn studying right before the exam

  • @ajarpandey7660
    @ajarpandey7660 3 ปีที่แล้ว

    Really ! Thankful to you as these resources help me a lot for my upcoming ICT examinations

  • @tiktokfindscomp
    @tiktokfindscomp 2 ปีที่แล้ว

    omg thank youuu i have watched so many vids and not a single one mentioned the difference between query and report

  • @peterclaver9419
    @peterclaver9419 3 ปีที่แล้ว +1

    What do they mean by do not group the data

  • @AY-Gamers7148
    @AY-Gamers7148 ปีที่แล้ว

    thankss my paper is exactly after an hour you saved my life

  • @criminson3720
    @criminson3720 4 ปีที่แล้ว

    The videos u make are soo damn helpful please continue uploading good ict videos they seriously help us alot

  • @husenmosa9942
    @husenmosa9942 3 ปีที่แล้ว +1

    Hi
    I have a question if I created a form and entered the new record in it.
    Is it better?

  • @SamuraiEU
    @SamuraiEU 4 ปีที่แล้ว +2

    Love the videos man you helped me a ton

  • @idrisisaacmohammed2495
    @idrisisaacmohammed2495 4 ปีที่แล้ว +1

    thank you very much chikasa the it veteran🙏
    💪

  • @joelloforte4220
    @joelloforte4220 4 ปีที่แล้ว +1

    In question 23 about queries its double click in the right side of the mouse ?

  • @yeesha5674
    @yeesha5674 3 ปีที่แล้ว +1

    hey Mr Chikasa, I tried importing a file and Access had sent this notification 'Text file specification field separator matches decimal separator or text separator' and I'm not sure what do. May I have your assistance

    • @EvansChikasa
      @EvansChikasa  3 ปีที่แล้ว +2

      Hi Yeesha, which exam paper is that so I have a close look at the error?

    • @yeesha5674
      @yeesha5674 3 ปีที่แล้ว +1

      @@EvansChikasa Oct/Nov 2019

  • @UlemuZK
    @UlemuZK 4 ปีที่แล้ว

    Your videos are much appreciated , thank you

  • @oobryoob917
    @oobryoob917 2 ปีที่แล้ว

    absolute King 🙏

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

    I love you and your videos you make me stressed free 😂🎉

    • @EvansChikasa
      @EvansChikasa  10 หลายเดือนก่อน +1

      Thank you :)

  • @RAGEFIFA2113
    @RAGEFIFA2113 4 ปีที่แล้ว +2

    from where can i get the files for the exam?

    • @EvansChikasa
      @EvansChikasa  4 ปีที่แล้ว +2

      Ahmad Aoude in the description section of this video

  • @taneeshasalkar503
    @taneeshasalkar503 ปีที่แล้ว

    I have a question...my yes/no shows check boxes...how do it change it to words ? and do i have too ?

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

    Hi
    One question how to remove the Am/Pm when you changed it to long time? at 9:00
    And do we lose marks if we keep it in? becuse i lost some marks in my mocks for this

  • @mikemiller6635
    @mikemiller6635 3 ปีที่แล้ว

    love your channel keep up the good work

  • @quarantinefun7390
    @quarantinefun7390 3 ปีที่แล้ว +1

    what do u use for taking screen shot its so quick

    • @EvansChikasa
      @EvansChikasa  3 ปีที่แล้ว +1

      I use a software called Lightshot. It’s free to download

    • @quarantinefun7390
      @quarantinefun7390 3 ปีที่แล้ว +1

      @@EvansChikasa ok thanks

  • @ishanchoudhary4179
    @ishanchoudhary4179 3 ปีที่แล้ว

    30:35 Sir so if in the Or category I write 'Female' Yes and 'Expert'. It should give me proper result right?

  • @musa2908
    @musa2908 2 ปีที่แล้ว

    my paper 2 is tommorow thanks alot!

  • @Sheidheda670
    @Sheidheda670 4 ปีที่แล้ว +1

    Please Sir can you solve AS ICT june 2020? If u want the supporting files i can give them to you

    • @EvansChikasa
      @EvansChikasa  4 ปีที่แล้ว +1

      I will have a look at them

    • @Sheidheda670
      @Sheidheda670 4 ปีที่แล้ว

      @@EvansChikasa drive.google.com/file/d/16nfDsqPnhEOKqX3Kmep_ZFwYV44kl0OP/view?usp=drivesdk

  • @teenXplayboi
    @teenXplayboi 3 ปีที่แล้ว

    Sorry but u forgot the descending order in points

  • @almoilofficial2460
    @almoilofficial2460 4 ปีที่แล้ว +1

    People make memes about Indians teaching, what about Chikasa?

    • @shaheer_04
      @shaheer_04 3 ปีที่แล้ว

      he is a legend. chikasa for life.

  • @rouvendsouza3016
    @rouvendsouza3016 2 ปีที่แล้ว

    Thank you, really helpful

  • @alaaelnour3727
    @alaaelnour3727 4 ปีที่แล้ว

    Sir does it matter if we don't delete the date and page number in the page footer when not asked to?

  • @rebekahmathai4544
    @rebekahmathai4544 2 ปีที่แล้ว

    hi, i have a question.
    1. when i made my query and tried to run it, it said the formatting wasnt the same in the query and in the table. how should i fix it?
    2. when i try to change the report from design view to layout view, it asks to enter parameter of something. i'm not sure how to do that..
    thank you

    • @EvansChikasa
      @EvansChikasa  2 ปีที่แล้ว

      Hi Rebekah, I am not sure about your first question unless I see a screenshot of what error you are getting. Regarding your second question, it just means the name of your run field or search criteria has a spelling error. Check that the spelling is correct and that the Capitalization is acurate. Kind regards

  • @Joseph.Jacob..7
    @Joseph.Jacob..7 ปีที่แล้ว

    Sir, for Question 22, every time I try to save the database after creating the new record I receive an error stating that it was not successful because it will create duplicate values in the index, primary or relationships.
    Do you happen to know the problem behind this? If so, please tell me

    • @EvansChikasa
      @EvansChikasa  ปีที่แล้ว

      Choose the correct primary key 🔑 field. You are setting a primary key on a field that has duplicate values. Primary key must be unique for every record

  • @maamnii
    @maamnii ปีที่แล้ว

    MS Access is licensed software. If I want to practice at home, what are the free alternatives I can use for database. Can I use MySQL?

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

    28:31 "Women are licensed to equality" 😂

  • @blessingbhebe
    @blessingbhebe 3 ปีที่แล้ว

    thank you sm for your help !

  • @Callmemaher
    @Callmemaher 3 ปีที่แล้ว

    Hey, I have an important question. Now, I do the report from Report and not from Report Wizard. The difference is the cell borders show up in the final printout. Will I lose mark if I do so? Or Is it accepted in the mark scheme ?
    Thanks in advance

    • @EvansChikasa
      @EvansChikasa  3 ปีที่แล้ว

      You can disable the borders. Take the report in Design View, select the cells with the borders, right-click and go to Properties. Under the Format tab, find Border Style and select Transparent from the options. Take it back in Report view. Hope that helps

    • @Callmemaher
      @Callmemaher 3 ปีที่แล้ว

      @@EvansChikasa Thank you so much. I'm truly relieved . Thanks again.

    • @EvansChikasa
      @EvansChikasa  3 ปีที่แล้ว

      @@Callmemaher No problem bro

  • @Aaditya.GT3
    @Aaditya.GT3 3 ปีที่แล้ว

    PRO VIDEO HELPED ,ME A LOT

  • @MuhammadAli-wx9om
    @MuhammadAli-wx9om 3 ปีที่แล้ว

    thank u soo much ur the great

  • @AbdulRahman-pr4vo
    @AbdulRahman-pr4vo ปีที่แล้ว

    Sir, do you know where to download access for free?

    • @EvansChikasa
      @EvansChikasa  ปีที่แล้ว

      No I dont. You can just get a paid version (Office365), it is safer and faster

  • @abdulrahmanmohamed2470
    @abdulrahmanmohamed2470 2 ปีที่แล้ว

    Motivational Speech 23:25

  • @karimallam4757
    @karimallam4757 3 ปีที่แล้ว

    this is so useful

  • @michaelanunn1156
    @michaelanunn1156 2 ปีที่แล้ว

    Yay

  • @anthonyoshijo6191
    @anthonyoshijo6191 4 ปีที่แล้ว

    Please you need to make your procedures more understandable

    • @EvansChikasa
      @EvansChikasa  4 ปีที่แล้ว

      Anthony Oshijo which part do you understand and what procedures would you recommend

  • @sollaris_
    @sollaris_ 4 ปีที่แล้ว

    Sir in Paper 3 could you use VS code?

    • @EvansChikasa
      @EvansChikasa  4 ปีที่แล้ว

      Cynthia no you can’t, must be HTML and CSS

    • @sollaris_
      @sollaris_ 4 ปีที่แล้ว

      Evans Chikasa Sir I meant the program visual studio code

  • @bonsaidaddy9970
    @bonsaidaddy9970 ปีที่แล้ว

    28:28 lmao what 💀 cool video tho

  • @_saif27
    @_saif27 3 ปีที่แล้ว

    ur amazing

  • @Astrophysicists
    @Astrophysicists 3 ปีที่แล้ว +1

    watch it in x1.5
    thank me later

  • @RandyTang-q3k
    @RandyTang-q3k ปีที่แล้ว

    @serafina2881
    2 years ago
    my paper is literally in an hour. Thank you so much! you’ve saved my whole class. Good luck for everyone sitting for Oct/Nov 2020