Edexcel iGCSE ICT Paper 2, Database Question - May 2019
#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
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
4 жыл бұрын
You're welcome, good luck with your iGCSEs and please check out my other iGCSE ICT videos!
@just_avocado
4 жыл бұрын
@@MarkHarrisonCS Thanks! Will definitely check your other vids!
@nemesiz762
3 жыл бұрын
Oii sihas its me
@rotarytexas3972
Жыл бұрын
@@just_avocado How did you do?
Thank you so much! This was extremely helpful Mr.Harrison.
YOU EARNED YOURSELF A SUBSCRIBER... NEEDED THIS FOR MY HOLIDAY HOMEWORK
@I_got_the_sauce
4 ай бұрын
Gang wth are you doing here cr😭😭
thank you Sir Harrison for this tutorial it was really helpful, since my exams are reaching in a few weeks (final)
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
4 жыл бұрын
You're welcome, thanks for watching and good luck with the exams!
Thank you for helping Mr Harrison
@MarkHarrisonCS
4 жыл бұрын
You're welcome!
This video helps a lot to me.Thank you very much
To the point Helped me a lot Short Very explanatory Thank you so much❤️
@wafeeq9593
2 жыл бұрын
amr you are right
Your videos are best.I was having some doubt but now it's clear for me
@MarkHarrisonCS
3 жыл бұрын
You're welcome, thanks for watching!
Thanks alot for this Sir! I have my mocks in a few hours and this was very helpful!
@MarkHarrisonCS
3 жыл бұрын
You're welcome, good luck!
this video is amazing bleaze do more videos about zis topics
Thank you for this!
@MarkHarrisonCS
3 жыл бұрын
You are most welcome!
Nice, some good questions for revision :)
@MarkHarrisonCS
4 жыл бұрын
Glad you liked it!
Thank you, this is really useful!
@MarkHarrisonCS
3 жыл бұрын
Glad it was helpful!
Thanks,ur always helpful
@MarkHarrisonCS
4 жыл бұрын
You're welcome1
Hi sir, I have a question for the computer Science assessment. Is python stuff going to be in the test?
@MarkHarrisonCS
4 жыл бұрын
No, not tomorrow.
thank you for helping sir
@MarkHarrisonCS
3 жыл бұрын
You're very welcome!
HI, thanks a lot, gained yourself a sub :) , just wondering what version of word is that?
@MarkHarrisonCS
3 жыл бұрын
Thank you! Much appreciated. It's Word 2016.
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
3 жыл бұрын
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
3 жыл бұрын
@@MarkHarrisonCS Thank you Sir :)
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
3 жыл бұрын
Yes, it should be the same from A1.
@islambaher5936
3 жыл бұрын
@@MarkHarrisonCS ok thank you
Nice video
@MarkHarrisonCS
4 жыл бұрын
Glad you liked it.
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
3 жыл бұрын
Not sure I understand the question?
thanks this helped a lot if you can do a video on igcse photoshop it would be great
@MarkHarrisonCS
3 жыл бұрын
You're welcome. Please see this video for Photoshop: kzread.info/dash/bejne/Y5aorKhredHQlc4.html
@tharunnnds6066
3 жыл бұрын
@@MarkHarrisonCS alright thanks, have you done any videos on Dreamweaver
@MarkHarrisonCS
3 жыл бұрын
@@tharunnnds6066 No, sorry!
Yo this was helpful thanks
@MarkHarrisonCS
3 жыл бұрын
Glad to hear!
hey do you have pearson edexcel as level papers?
@MarkHarrisonCS
3 жыл бұрын
Sorry @Unknown, I cannot access these.
what does house style mean in Task A2a?
@MarkHarrisonCS
2 жыл бұрын
As mentioned on the first page of the exam paper, this is a specific set of colours, fonts, etc. to be used.
At 15:57 where did you choose the logic from?
@abdelrahmanayman9148
2 жыл бұрын
LOL
@h6__9m
2 жыл бұрын
@@abdelrahmanayman9148 😂?
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
3 ай бұрын
I think you need to make your own log, using the house style mentioned.
@Feryal-2009
3 ай бұрын
thank you sooo muchhhhh@@MarkHarrisonCS
Thank you! Reminder you didn't link the logo
@MarkHarrisonCS
4 жыл бұрын
Created another time. Thank you!
also love ur videos u r so helpful thank you sir!
@MarkHarrisonCS
3 жыл бұрын
Glad you like them!
i donnnot have database can i use any other microsoft please help sir
@MarkHarrisonCS
2 жыл бұрын
You need a database to practice this. You cannot use any other software, sorry.
@alpharaharold5378
7 ай бұрын
The app name is actually Microsoft Access
please do a video for pratical past paper 2020
@MarkHarrisonCS
3 жыл бұрын
Will do.
khalid omar likes you
@fariselhaddadicsbr1141
2 жыл бұрын
what are you saying ya maafen
@nabeelmuhamadragheedhaikal2563
2 жыл бұрын
@@fariselhaddadicsbr1141 ratio + L + bozo
Please make video on database of 2018
@MarkHarrisonCS
3 жыл бұрын
Maybe one day. I tend to stick to the new specification.
you are very helpful thankyou. only 46 more subs for 1k
@MarkHarrisonCS
3 жыл бұрын
Nearly there!
damn 24 minutes for 24 marks