Edexcel iGCSE ICT Paper 2, Database Question - May 2019

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ก.ค. 2024
  • #iGCSE #iGCSEICT #EdexceliGCSEICT #Access #Databases
    In this video I do a past paper database question from May 2019. The practical exam is three hours long and contains a mixture of different questions with the output printed documents which are handed in to your examiner.
    This question is a typical database question where you are given a database then asked to sort it, query it and produce a report of the query. the total marks are 24 and in this video I break down how to get those marks whilst also dealing with the technical aspects of how to do the database task.
    The key exam tips here are to read the instructions very carefully, be sure what the house style is and follow it to the letter. If you are asked to name a file a certain way then do this, if you're asked to write in capitals then make sure you do this, don't lose easy marks!
    Timestamps:
    Questions
    Intro (00:00)
    A2 A & B - (05:00)
    A2 C - (06:16)
    A2 D - (07:07)
    A2 E - (11:03)
    A2 F - (20:24)
    Here are links to the materials:
    Paper 2:
    www.dropbox.com/s/juqrtxn6gr7...
    Holidays database:
    www.dropbox.com/s/gfdhpgiwpnt...
    Good luck, please like and subscribe!

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

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

    Thank you so much! This was extremely helpful Mr.Harrison.

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

    I'm glad I stumbled across this video. Very detailed and explanatory. This is super useful as iGCSEs are coming up! Thanks Mr. Harrison!

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

      You're welcome, good luck with your iGCSEs and please check out my other iGCSE ICT videos!

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

      @@MarkHarrisonCS Thanks! Will definitely check your other vids!

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

      Oii sihas its me

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

      @@just_avocado How did you do?

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

    thank you Sir Harrison for this tutorial it was really helpful, since my exams are reaching in a few weeks
    (final)

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

    YOU EARNED YOURSELF A SUBSCRIBER... NEEDED THIS FOR MY HOLIDAY HOMEWORK

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

      Gang wth are you doing here cr😭😭

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

    Wow!It's really awesome.Thank u very very much.I like it and it's very helpful for my IGCSE 2021 exam.I am really getting help by it.

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

      You're welcome, thanks for watching and good luck with the exams!

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

    This video helps a lot to me.Thank you very much

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

    To the point
    Helped me a lot
    Short
    Very explanatory
    Thank you so much❤️

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

      amr you are right

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

    Your videos are best.I was having some doubt but now it's clear for me

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

      You're welcome, thanks for watching!

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

    Thanks alot for this Sir! I have my mocks in a few hours and this was very helpful!

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

    Nice, some good questions for revision :)

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

    Thank you for helping Mr Harrison

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

    this video is amazing
    bleaze do more videos about zis topics

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

    Thank you, this is really useful!

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

    Thank you for this!

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

    Thanks,ur always helpful

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

    Hi sir, I have a question for the computer Science assessment. Is python stuff going to be in the test?

  • @Unknown-fj3xh
    @Unknown-fj3xh 3 ปีที่แล้ว

    hey do you have pearson edexcel as level papers?

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

      Sorry @Unknown, I cannot access these.

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

    HI, thanks a lot, gained yourself a sub :) , just wondering what version of word is that?

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

      Thank you! Much appreciated. It's Word 2016.

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

    Hello sir, just had a small confusion, using destination_form the record was added in the table, but why doesnt it show up in the query of task A2d ? otherwise the video was very helpful

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

      Not sure I understand the question?

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

    what does house style mean in Task A2a?

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

      As mentioned on the first page of the exam paper, this is a specific set of colours, fonts, etc. to be used.

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

    Sir, at 8:59 when there 2 similar fields such as in this case, Blue Water 1 and Blue Water 2, we should enter Like “Blue Water*” but, what would be the other instances where we should use the * ?

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

      Good question, use it when you have another instance where it has 1 or 2 after it, like the movie title Back to the future 1, Back to the future 2 would be Back to the future *.

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

      @@MarkHarrisonCS Thank you Sir :)

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

    sorry sir, i want to ask at 4:05 you added a logo is it the same logo as the one we did in task A1 or should it be different and how can we know?
    Thank you it is great :)

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

      Yes, it should be the same from A1.

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

      @@MarkHarrisonCS ok thank you

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

    thank you for helping sir

  • @Feryal-2009
    @Feryal-2009 3 หลายเดือนก่อน +1

    Hi i have my igcse exams soooo soon ( after 1 month) and uhh I got stuck on the "house style" image that i don't even know from where you got it or made it becasue i went to the images and i didn't even find it and it does not says for us to make the logo for the house style somone explain to me please as fast as you could pleaseeeee

    • @MarkHarrisonCS
      @MarkHarrisonCS  3 หลายเดือนก่อน +1

      I think you need to make your own log, using the house style mentioned.

    • @Feryal-2009
      @Feryal-2009 3 หลายเดือนก่อน +1

      thank you sooo muchhhhh@@MarkHarrisonCS

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

    Nice video

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

    At 15:57 where did you choose the logic from?

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

    Yo this was helpful thanks

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

    thanks this helped a lot if you can do a video on igcse photoshop it would be great

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

      You're welcome. Please see this video for Photoshop: th-cam.com/video/1btJF2Injek/w-d-xo.html

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

      @@MarkHarrisonCS alright thanks, have you done any videos on Dreamweaver

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

      @@tharunnnds6066 No, sorry!

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

    i donnnot have database
    can i use any other microsoft please help sir

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

      You need a database to practice this. You cannot use any other software, sorry.

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

      The app name is actually Microsoft Access

  • @tasneemal-yahyaei8601
    @tasneemal-yahyaei8601 4 ปีที่แล้ว +1

    Thank you! Reminder you didn't link the logo

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

      Created another time. Thank you!

  • @ani-hz6tq
    @ani-hz6tq 3 ปีที่แล้ว

    also love ur videos u r so helpful thank you sir!

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

    please do a video for pratical past paper 2020

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

    khalid omar likes you

  • @ani-hz6tq
    @ani-hz6tq 3 ปีที่แล้ว

    Please make video on database of 2018

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

      Maybe one day. I tend to stick to the new specification.

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

    you are very helpful thankyou. only 46 more subs for 1k

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

    damn 24 minutes for 24 marks