IGCSE ICT Paper Practical Guide

Today I will cover May 2024 Edexcel IGCSA ICT paper 2 practical so let's continue with the paper so the first thing that they provide you instruction which is an instruction to candidate this paper consists of two section and there will be a file for software data files which is the evidence in inside the evidence folder whatever you have a theory part like you have to write you just write it here and provide your screenshot there there will be a car hire presentation and image folder will be inside the database folder and evidence will be higher cost uh for the spreadsheet and data processing you will get this this is the file and there is a scenario this is quite important like when we will continue with the database or excel during that time we need some of the information from the scenario top so which is a Maria owns hire it the company offers car hire in the UK these are the company's contact details addresses garage drive car town C 3 3 3 AR so the telephone number is this email is this and website is it this okay so let's continue with the first section which is section 1 task a 1 Maria needs a logo to be used on some of the company documents so task a1a is like you have to create a logo and the logo must be fit for purpose and combined rectangle circle circle and line shape so that means you have to combine the rectangle circle and line shapes to create a logo which represent a theme of a car hire okay include the company name hire it in a bold serif font so you have to use a serif font and it must be bold you so in this way you have to provide the text inside the logo so let's continue with the logo then we have to save the logo as logo so first of all what we will do we just uh create i just want to create a folder which is a new folder and then i will give the name of the folder is like it's up to you right i just want to give them the answer so that whatever i will right here it will maybe i can just change this one working folder okay so inside this folder i don't have anything right now so for that one you need to use photoshop but for me i don't have the photoshop currently now so i will use the photopia you will get the same thing same it's actually the same way the way we use the photoshop okay so you will add a new project maybe anything you can add just add a create and then try to make it a bit zoom so it will be a bit bigger now so we have to use the shape right so there if you click here you will get different type of shape so suppose they say that we have to create a car higher logo so that means we can create a car by using a different type of shapes so i want to add like suppose this is a rectangle then i want to add some of the wheel for the car so now i want to copy these things so for that thing here from here i will get that this shape 2 is the layer for the circle so what i want to do i want to just duplicate the layer so when i duplicate the layer shape 2 there is a copy right so now i can able to select it so maybe i can just add it here but i want to make this one as a backwards so for that thing i just put my shape at the up now both are the back back side um okay then by using line i can just draw the upper part of the car so for that things i want to use the line and then i want to add the purple of the car similar like this way and and it's okay i think i don't want to add anything else so this is the things that i want to add but they say that you have to add a higher car higher theme so for that thing maybe we can use a blue or maybe the green color which represent a safety symbol for a car right so i want to change the color for that particular thing so what we can do we will select the layer suppose i want to select the layer for the shape one and then from here i can change it to blue color yes blue color okay yes it's maybe i want to add some you know bit opacity need to be increases a bit so what can i do for that things so okay similar like this way and this two maybe you can use the same color this two will be black it's okay and i have the shape three color will be this or this i want to add this color so actually will not get this type of color so for that one what I will do I will again select on this one and try to get the value for this one this one is this color and then paste it here okay now the this thing's quite match with this so do the same thing for all so it's done so now i want to add um i have to add a level right which is a higher eight so for that thing i will add the text the text so i want to add it here yeah so higher it and then maybe i want to give the color is white color so it will be more visible so higher it's about like that way and i also have to make it bold so for that thing yeah it's already in bold it's already in sensory fansweep okay so it's done now i want to save this as a logo right so what i'll do go to your file and then you will get a number of export option but the thing is that as a logo i need a background which will be transparent so what we'll do there is one of the layer for the background just delete these things because i don't want the background now my a logo is in transparent way right so to save export is the png so when you actually when you uh create the logo as a transparent one for that thing actually png is the most uh considered as a better format image format to use so that's why i use the image format and i just save this oh because i save this but i didn't provide the name okay whatever i save it i will take the file from the download like this is the thing so i just take it inside the working folder and then just change the name to logo right so first of all i want to see actually what's the name that i what they're saying it's a logo so it will be in capital letter so just change it to capital letter Okay, so it's done. We already completed the task for question number 1A. Now we'll move to question 1B. So Maria wants to include an image in a presentation. She has an image saved as edit. Open the image and edit it to set the dimension 450 pixel width and 300 pixel height. Remove the car from the road include the logo you created in task a1 in a suitable position Make sure the company clear name is clearly visible. We'll go to our data folder So this is the data files actually and inside the data files. We have image non office and all those things So when I go to the image folder, I can see there is a pictures which is an image So we will take this one in our Photoshop, right? So what I will do go to your photoshop and then try the new one i want to add a new one or maybe i just want just i don't need open from your computer so in my computer i want to take this edit image and then open it sorry i already did these things this is not the thing maybe i need to use from here computer take this one yeah open it and this is the image so our question it was like they say that set the image to 450 to 300 pixel height and then remove the car from the road so what we'll do when we set the dimension to this it will actually make the size of the images quite smaller so it is quite harder for to the editing like removing the car so we do the second one at first then we'll move to the first one so first of all i want to hide the car so here the issue is like there is a two type of um background out there right one is a road which is a gray color another one is a brown and green color so what we'll do we'll go to the we will take the lasso tools okay so when you click here there is a thing which is called a lasso tool click on the lasso tool and also uh hold on your command or maybe ctrl and plus button get a better view of the car and then we will take only the part of the road that is considered as a gray color okay yes then we will click on edit click on the edit and there is option for fill click on the fill and then from here you just add the content hour and okay when i will click ok it just takes some of the background right but still there is some of the green backgrounder here so we need some time to do this actually so again i will take the lasso tool okay final pictures that we get without the image of the car so now what i what i will do i just need to change the size of the images so for that thing click on the image and there is option for image size so they say that we have to use the width which is a 450 and the height is 300 and then click on ok now it's become smaller now we have to add our logo hair right so for that things what we'll do where we have the logo just try to minimize these things a little bit and drag your logo hair so this is my logo i want to drag it down yeah so i take it here and then make it a bit smaller and then maybe if we put it here it will be more visible you or maybe you can put it here as well it's up to you so we add the logo and then okay right after that we have to save the image they say like what they're saying about saving saving the image save the images edit one include the logo we already take the logo remove the curve and the height and width also changes right so now save the image as edit one so click and then save save or we have to save as save or maybe export as png edit one right and to save it so it's already saved but it is saved in my download folder edit one i take it to my working folder okay so that means now the images looks like this so it's done Just like this, so it's done. so we completed task 1a and 1b and the third one is task 1a1c which is like open the document evidence enter your name candidate number and center number in the document i think you already know or if you don't know how to do that you can check my previous video where i already mentioned how to do that so answer this question in the document evidence task a1b asks you to save the edited image as edit one explain one reason why the file name should be different from the original file image file name so okay for that things maybe we can open our when our folder 2010 there is a file for evidence this is the evidence file okay so once see what can be your response type it here so i think as my point of view like the original image remain available for reverting right for reverting to its original states or for any further editing that may be required so what we can write we can write here these things the original image remains available for reverting to its original states or for any further editing that may be required so it's done control s save now we will move to the next question task a2 is like maria has information about the curse available for hire she has saved the information in the database car hire the database has three tables the car tables include information about the cars available for hire the structure of the car like they have a three type of tables in the car hire database which is one of the table name is car the another one is client the other one is booking okay this is the three table and the question starts from here it is like maria wants to use a form to add extra cars to the cars table so open the car hire database so what we'll do we just open the car hire database so from here i will take the car hire database from here so this is the database of a car hire and the question is like create a form for the curse table the form must include a form heading which is car available for hire display the width of the field name and field content to three centimeter display the field names with dark green background the field names so what we will do go to this and this is the curse table so we need to create a form right so click on the form here So when we click on the from form we will get something like this view. Here the thing is that the booking table is actually connected with the curse table. So how we can see that suppose if you want to go to the database tool and then relation you can see that this table are connected with each other. The client, booking table and the curse table. these three are connected with each other so we can able to work with only cars and client we need the booking as well because booking is the one which is connecting the car id and the client id together okay remember these things so we move to the yes whatever we move to the car table so this is the form so that's why they're saying like we'll go to the design view for the cars so this is the save what the form name decided us to give cars form right so all will be in capital later cars if or m cars form and then click ok then this is the cursed form but you have to do some editing here so which is like uh the curse what will be the title cars available for hire right so take these things and paste it here curse available for hire maybe it's just based on your just i just want to add a bold color here then display the width of the field names and field content to three centimeter so field width and field both need to be in three centimeter so what i will do because table booking is connected to this so i just don't want to remove this or do anything with these things okay i just want to design this particular things so for that thing i need the property sheet so go to the property sheet and then from here i need to add the width so with here i want to add three centimeter and then enter so now everything is in three centimeter now okay so after that they're saying like uh this one is done display the field name with dark green background line light green text and yellow three point border okay so for these things we have to design this one so just try to select the all like this way and what we have to do we just need to add the border so try to identify where is the border border width will be three point right so three point then don't use this arrow use this one so from here you can able to choose like like the green one but they also want to add the border color border style is solid border color will be yellow okay so if i go to my question dark green background light green text okay background will be dark green and light green three border okay light green text so maybe what can be the text again you need to select this four thing this one will be the light green text so this one is a four color lighter 40 percent so maybe we can add this one which is a light green text right yeah so this is done if i go to the view point you can see similar like this now align the field so that there is one centimeter gap between the field names and the field content so we have to add the gap between the two fields label and the input so we'll go to the design view again and then there is an option for a padding you need to find out about the padding uh first of all just click this for at first and then you will get the option for the padding and this is the padding so right padding maybe i can add one centimeter and then see how it looks like yes so there is a gap between one save this and go to the view so now there is a gap between right one centimeter so it's like also aligned and once again between the field name and field content okay so save the form as cars form is done take this screenshot of your form in design view so you have to open your property sheet so that you can show that uh your field name and field content why they're set to three centimeter width and green background light green text are used and the field name are aligned with the one centimeter gap this is the thing that you have to take a screenshot of these things with the property sheet that means you have to go to the design view and take the screenshot of this thing so first of all what we'll do try to select all the field and then show them that what is the width you are choosing here right so we choose like three centimeter and then you take the pictures so that's it done then a new car is available for hire use the curse form you created in task a2a to add this detail to the curse table so we have to add this so that there will be st5 standard manual and petrol okay go to the design view it should be st5 st5 then standard Choose standard, manual and petrol. after that just save these things then it's done i will move to the next question which is we save the form take a screenshot of the completed form and paste the screenshot into the evidence folder that's it so maria wants a list of curve that are large suv have automatic transmission are electric so this is the query that we have to assign to the query field right and then they say that create a query on the curse and client table to produce the list so the name of the query will be large suv query so what we will do just close everything go there and design the query from here we'll take actually we need three table here why we need three table because i already show you that we have a relation with a booking table so we just can create a query with this two when it comes to client id and car id because client and car id are not connected to each other so it will not actually filter anything if you just create a query based on cars and client so what we need we have to identify what can what will be the field that we have to show so we have to show the client name client id car id and insurance this is the this is the four field that we have to show right so we will take the client name from here then then we have client id and car id we'll take the client id from the booking car id from here and then car type right so the car type is not sorry it's insurance so we'll take the insurance from here this is the four field that we have to show but we still need to identify the car type two times i don't need just cut it i need car type transmission and fuel type this is the things that we need actually so the car type uh is large suv right so for that things you can just open the car table and from here take the large suv this is a car type right so go to the car type and in the criteria field add the suv and click on enter so it will put the quotation automatically then the transmission will be automatic transmission right so for this one go to here and take copy this one then go to your query and also automatic enter and for this one will be petrol right so take this and then enter but we don't need to show this card type this is but this is only required as a filter value so this is done then they also said something like um be shorted in descending order of client name so we have to do the sorting here so descending order choose descending done save these things uh what's what will what will be the name that you have to provide is a large suv query so copy it it will be better if you copy these things because it will reduces the mistake chances of mistake so take these things and then okay okay so we'll get the large suv query now now if you click on here you can get the okay we get the client id there is some mistakes that i did to go to here again so it's the name of the client name client id well type which is petrol is it a petrol oh sorry it's electric right so i need to go here and then take this one petrol electric save this and then when i go to the close this close this query yeah So this is the answer that we get right. So we already completed question number A to C as well. So display the order and shorter result of the query, take a screenshot and then paste it to your evidence folder. Now task A to D. So Maria wants some information on client. The list must include client who have taken out insurance and paid a deposit of more than 75 dollars. okay so now we have to create a query based on the client table so this is the three field that we have to show so okay this one is done now we will create a new query create a query design will take only the client the field that we have to show is like go to and check your it's a deposit paid client id and client name so we will take the deposit paid client id and client name right then uh deposit line okay so create a query on the client table to find the information so save the query as a client query who have taken out insurance and paid more than 75 so the deposit if you can go to deposit paid right yeah so it should be greater than 75 and uh we need to add the insurance but we will not make it visible insurance must be true right so true now save it what will the name of the query the name of the query is client query right so go here and paste it okay so we have a client query now delete everything go to yes we get the client query value now oh but the insurance is still showing so we have to not this is not this one this one this one is the client query so uh client id but we are not showing the deposit right we have to show the deposit as well go to the design view maybe yeah but this one we have to assign it at the first then save then run it okay deposit yeah we have the everything now save these things and go to your client query okay so we added the client query deposit more than yes uh okay done maria wants a database report based on the result from the client query so create a database report to display the result the database report must have a suitable title in a serif font size 25 24 so okay so for that thing close this one maybe we need to go to here and then we will create a report This is a client query report right so here first of all it will be better if we save it What if the client report save the report as a client report so I want to save it client report Okay, it's already query. I want this client report. Okay, so we added this as a client report Open it from here. It looks like this now so we have to provide a suitable title we'll go to the design view and here we will add client deposit report it's up to you you can write some other name as well it's up to you okay and we don't need this so what we'll do try to delete this we don't need date and time the size will be 24 and choose area as a serif font okay now it's visible if you should check right everything should be visible and inside the footer we actually don't need this count as well delete these things we don't need this is this one as well we don't need and delete this one as well so we have to add something in the base footer okay so if you go to the question uh have a suitable title on a serif font yeah this one is group result by deposit paid okay so this one what you have to do go to the report design and there's a group and short right click on here add a group so we want to group it by deposit paid and then save these things go to the view it will be similar like that but there is some space that we have to reduce so for that thing we'll go to the design view again and then try to reduce the space this way and okay so we add the deposit group resolve a deposit page show only the required fields okay not include an automated date and page number in the page footer yes we didn't add anything include the text insurance and deposit this is you have to add in the page footer so i just copy it and go to the report design control and from here take the label you This is actually up to you. I just want to make it a bit bolder so that it is more visible. Save it and yeah so this is the this is the answer for um question task a to d save the report as client report then take the screenshot including the base footer and everything and then paste it to here but we don't need the logo right for that one we can do one thing again go to your design view maybe i just delete these things yeah now it will pay yeah deposit paid client id and client names is the import but if you want to make it a bit upper shift it to bit upper then you can just take it like this way then you can shift it to upper one at a time and then you can check is it actually looks great or not based on that it will be okay okay so it's done we already created the client report and then the theory question which is give one validation checks that can be checked that can be used in the database so for the validation we can actually add a different type of validation we can add range check presence check type checks length check so what is the range a grain check is mostly used when you want to provide a certain number like one to hundred right suppose if you want to add a age range for that particular field you can add a range of 1 to 100 so people can able to add a age more than 100 whereas you can add the presence checks like for the car name they must have to put the card type right otherwise it will not save your field this is the thing that maybe you can add a presence check as a one of the validation then give one reason why sensible names should be used when saving a form saving a form query and report so it's like they can be found easily next time they are needed right anyone else using the database can also find them so this is the answer then move to question number three which is explained why one reason why maria has used a relationship in the database because it reduces the error right it also prevent duplicate record as well so you can write it like reduces errors because duplicate records will be prevented so this is the end of question a2e now we will start task a3 so which is maria wants you to create a presentation to display in the car hire office the presentation must include three slides so there will be three slides those slides one and two must be fit for purpose and use a green light background with dark green text then include a suitable title include slide number in the header of the each slide okay so we will we will add a powerpoint and here we'll take a blank one so what we will do at first we will just create a master slide based on the design slide one and two so use a green light background and a dark green text so for that thing we will just go here and then search for the master slide and take this one and after that go to the background style so light green right so maybe we can use any type of light green color here it's a bit maybe this one pale type yes okay and the text should be save these things okay i will save it later and the color this one is for the text so we'll click on the customize color and then instead of we will add some dark green right then if i save it's now a dark green so include a suitable title slide number in the header of each title so we have to include a suitable title i don't want to add this one here there will be a suitable title so post this one will be the title format so this one will be the suitable title and they want up okay okay got it they want uh they said that include slide number of the header in each slide so for that thing we have to add a slight number what happened Okay, so we'll add a slide number then add to apply This is the slide number. We don't need the date so just remove the date and from the slide number just take it here at the top header here and and then make it a bigger maybe 40 or yes maybe i think 40 is okay it will be more visible then go to slide master and close it okay so this way we can get a slide things so we created by using a default one the one that they are saying here so slide one must also include text from the file presentation okay so what what the data file they show us we'll go there so yes this is the data file go to the data file office 10 presentation okay for the presentation if i open the data file this is the things that we get so we have to provide a suitable title for this one so this one i can add it here maybe yes we would like to similar like this because they said the translation that we have we need to use that one so for that things we can use yes we would like to hire it uh okay okay for slide two what's name we can able to give we would like to welcome you to hire so maybe we can add welcome to hire right welcome to hire it so this is the suitable title that we provide the emmy image edit one include the image edit one to appropriate image from the image folder so we have to take the image edit one so what we will do because we we already work on this one right this is my working folder so i just drag and drop it here then i try to make it a bit smaller like this one but they also mentioned that we have to take other images as well so if i go to my emails folder then i can see what the other image can i can take which is like maybe i can take this image and two other images suppose this is one of the images i want to take and i want to take another image which is like this one so this is the another image so in total they say first they say Include the edit image and then they say this one. So this is the three images that I Took it from the slide. So in question first one is done the image edit one I already take it already included it to appropriate image from the image folder That one also done border and shadow of the image So we have to add the border right click here and then when you click on the format can able to get the shadow for shadow maybe you can increase the blur a little bit at the shadow this one also increase the blur or maybe you can do some angles it's up to you okay so i just don't want to do much more thing i just because i have to just add the shadow they didn't mention about that i have to um uh add the angle or anything then i have to add the border so for that thing if i click here um okay for the style maybe this one or maybe this one i can take this one is more more better compared to this right so take a board here yes the border is done then a footer the border and shadows on the image done a footer that states office presentation so I have to add a footer here so that one will yes I want to add a footer and footer will be office presentation yeah this one also done then a three second transition to slide two so what i will do here i will add a new slide here new slide okay so it's follow the theme that i use for my master slide that's why this is one of the easiest thing like we don't need to each and every time we don't need we don't need to select the exact background color and the text color so for these things we have we need to add a transition so for the transition when it will move to slide 1 to 2 during that time there will be 3 second transition so you will add click on after and then here I will add 3 ok so it's done now text from the presentation that include the telephone number slide 2 must include text from the file presentation that include the slide sorry phone number the phone number emboldened ok so what is the this one is the text for the slide too so i will take the text i maybe i can take everything and here i want to add a text box yes i want to add a text box here and maybe okay maybe i can just open this one in word document text box add the text box here so this one done but the thing is that this one is taking the color dark green but this one also need to take the dark because we didn't add the body there right so based on that i have to change the color for this one as well so what can I do not this I will add the same color or this one as well it should be the same color yeah same color or this one is okay but we don't need the additional information something like that this too is okay but they say the telephone number should be in bold so we will just make it a bit bolder and obviously the color need to be changed like this one right yes now it's matches so the telephone number apply the animation on each bullet so they appear separately we have to put the animation so maybe the fade in then maybe we add this transition here the same transition maybe we can add one two three okay so a three second transition to slide three so when we'll move to slide three there will be a three second transition so for that thing we'll again go to the transition select after and then click on three okay So it's done. Now we will create another new slide but for this one we are not following the theme for the master slide. It will be a bit different. So first of all because we have to add the background image here for that thing I can open my image folder and from here maybe i will take any of the image where i can give a visibility okay i can take this one so and then i will right click and send to back so when you right click and send to back it will go to the backward so now i want to increase based on the ok this portion i also have to increase a bit yeah so already yeah this is now aligned with the okay now i have to just say that in slide three a background image the company name clearly visible with a serif font and size is 60. so company name which is a higher 8 must be visible So, because the size is 60 and it should be Arial because they said Arial and I can center it. Okay, so now it's visible. Maybe I want to change the text color to maybe black. Then it will be more visible. That one is also applicable. okay or maybe the other color then a three second transition to slide one then there will be a slide one will come with a three second transition so i will add again a transition after two three okay done then i will go to the slide show slide set up i will add the loop okay so when i click ok it stands now when i will do it in the presentation mode suppose uh not this way i want to show it like this okay so it will automatically go after its second and how we can show that we add the transition for that one. If we click here, I can see there is a three second transition out there between each of the slide. Okay, so this one is done. Create the presentation task A3. So save the presentation. as office we have to save the presentation we need to save the presentation for that thing we will click on the save as and we will go to our working folder so browse maybe i want to do some browsing desktop and this is the working folder i want to give the file name to office and then save it okay So now I already saved my work of the presentation. Where it is? It's not here. Okay, save here actually. So I just move it to here. So we completed the presentation. part and provide the name which is an office task a3b answer this question in the document evidence state one reason why note section could be used for slide so that we can remember because when we use the presentation during that time we are not writing every word right we're right we are only focusing on some of the main point so during the time of presentation if you forget and if you use the note and then you write it in detail so it will be easier for you to get what's the point is actually meaning right and the people who will see it as a user they will not able to see what is right inside the note so that one will be the answer for this one and then we will move to so for that thing we will go to our working and there is an evidence file okay this one need to open with doc uh no this is not the evidence here we will write additional information can be added additional information can be added for the presenter who will do the presentation right that's it then the second question is give one reason why master slide should be used when creating presentation so this one is also one mark so for that thing we can use it it will there will be a fewer errors right that's it it will save automatically and then we don't need this sorry we don't need this actually okay where is my question paper so now we will move to the next question uh next question is 2d2 is done a3 also done focus on section b task b1 which is i think spread spreadsheet one yes so higher it offer a car hire in the uk the spreadsheet higher cost contain information on cost of cars hire for may 2024 it has two worksheet called cost and information some function require you to use more than one worksheet okay so open the spreadsheet higher cost so we'll go to the spreadsheet and then we will open the spreadsheet higher cost which is this one so in our higher cost we have a cost and information there's two spreadsheeted there so some function recall okay so that one is done task b1a set the formatting of the heading row one two that means heading row one so heading row one so this one we have to format this one they say that it should be dark color so maybe i can add black and the text should be light color so i add the text as light color uh okay white and then it should be bold as well bold font size is 24 24 alignment that means i have to align it both horizontally and vertically it's quite harder to change to the changes when it's short okay so now right it's done now so now we will move to the next question which is uh okay this one is done format the date to display as 1 may 2014 so we have this way so we have to change it so what we will do for these things we can click on the number and from here there's option for date so from here you choose the country like english so maybe india british united kingdom english 14 march okay so now it's become like this right the way they say it one may 2024 include the text may 2024 in the header so it's already have in the header now we'll move to the next question which is maria want you to use to use a spreadsheet tool to analyze the data in this spreadsheet spreadsheet use the spreadsheet function to display the cost per day for client id a b 11. So cost per day 11 right a b 11 So this one we have to identify the value for this because from the information table What's the meaning or like? Okay, we have to actually we have to create a relation between the two sheet So what's the common thing small SUV right here? We also have a small SUV. So this way we can able to connect So what you will do for this one, we will click here. We will take the VLOOKUP function VLOOKUP okay and then here we will do the matching of the same data that we have in the two sheets so that one this one we have so c4 click on the array and then go to your information and take the like this way okay so what the column that we want we want the column two so here we will add the two and we will take the exact data here so that's where for the false if you want to change a different data that during that time you can add true so i add false so now i will do some matching is it correct or not small suv 250 250 it's correct right now insurance cost for client id a b 11 insurance cost is for the higher duration not per day higher duration so this one is the insh insurance cost insurance cost that you have to identify the same way right so in information we have an information fee so if we want to get the information again you have to follow the vlookup so click on the vlookup click on vlookup and then okay after that uh okay that that which is the similar data this one right then we'll go to this one we take the whole table and from here which which column we are taking one two three we're taking the third column so three and range look up will be false because we will take the same value okay so it takes the 50 now i want to do some checking as it's 50 is correct now the question is enter a formula to calculate the cost of hire for client id ab11 so cost of hire we have to identify the cost of hire for the client ab11 so how we can get the cost of hire we will multiply this to this and then we will add the cost for the insurance right so for that things we can do like this equal and then i want to multiply this multiply e4 because cost per day number of days right so it is the total cost and then we have to add the insurance fees so insurance is f4 so sorry say four okay enter it's done right you get the answer for this one use one spreadsheet formula in the total cost column here to display the final amount to pay if a discount is given for client id ato like client id ab11 clients who have a total cost of more than 1500 receiver discount otherwise they will get the same price so for that things what we'll do we need a if else statement here so click here click on the if okay okay so logical is like if which one will be greater this one right when g4 is greater than 1500 red 1500 during that time we have to calculate the like minus the discount price right for that one the discount the total cost is this one will minus minus will minus g4 multiply from the information table because information we have the discount which is five percent okay otherwise we will get the value of the g4 and then okay so now i can get like my uh cost of fire is above 1500 more than 1500 right so that's why i get the discount which is a 1710 this one is done replicate the formula function and formula for client AB11 for all other clients. So replicate means we have to just drop and drag. So for that thing i just need to drop and drag large suv okay then for the cost of insurance as well now i want to check the larger suv 60 yes 60 then for the cost of higher yes for this one actually i need to add the dollar here otherwise it will not work okay now so it's above we get the discount this is below we are not getting the discount yes correct so we already replicate the formula enter a formula to calculate the total income for may including discount so this is the total income right for the may so total income here i have to add right for that one i i will use the sum function i will use the sum function okay and here i will select from here to this one and then i will select okay so this is the answer for my total sum now number of large suv higher so here large suv higher so here i have to use the count if function So I have to count right how many large SUV is higher. So I take the count if okay then the range will be from this table right from here to here and I want to check the large sorry sorry sorry this one the range will be from here to here and criteria will be because we will checking the large acv okay that is 11. now we'll move to next question enter a formula to calculate the total income or this one is done uh total income for me higher average cost of car per day so what is the average cost of car per day we have to calculate this one For that thing we just do the average of cost per day. So this is the cost per day right. So just click here select the average okay and then click all the things okay. So it will give you the average value. Average value so it's done. So we have a task B1C which is Format the cost worksheet so that currency value show the pound symbol with two decimal places So this is the cost right so here the currency is like this one number of days not considered as a currency insurance cost cost cost so for that thing we can add this maybe we'll do this for the first time go to the number here and then there is option for the currency so it is quite hard to find the pound one so go and find where is the pound English United Kingdom, okay, this is done now I have to do this for this Currency, okay done. Yes. No, it's okay. So just Yeah, do same for the other as well. Okay, so added the currency with two decimal values Text wrap is used for number of days higher and insurance cost. Okay number of days higher and insurance cost so this one wrap text Wrap text done Borders are displayed on all cell. Okay, so we have to add the border on all of the cells so for that things we can just take the everything like this way and then we will choose the border where is the border this is the border then on all borders yes it's done we added the all border here so borders are displayed on all cells all formula are visible in formula view so for that thing if we go to the formulas and show formula you can able to see that all the formula is visible now yes it's working perfectly receive higher cost so we have to receive it so because we already created another folder so what i will do i just save it as in my working folder so that it can create a different places for me okay so inside the desktop go to the working i reserved a saved okay done now task b2a maria has created a chart to display the information about the car on the information worksheet she wants you to add a suitable title and um suitable x and y axis okay so if you go here you will get this this this graph so when you click here there you will get the chart title click here and then maybe you can add reference higher cost higher cost of car okay and then click again here there's a xs title and yeah both way you get the xs title so y is represent cost this one represent cost and this one represent car type try to okay make the this one is upper letter c okay so it's done receive the higher cost okay so i want to again want to save it okay maria wants to see save save the spreadsheet as filter now they say this one is done received higher cost okay now save the spreadsheet as filter so we have to save this one now as a filter one so again we'll click here go to this one and then this is working filter i will just add it here as a fill filter okay then i will save it so for safety purpose what i'll do i'll just go to my because now i have a filter one and higher so i will open the filter one because now i will work with the filter one so maria wants to see some information for the large suv hired filter the cost worksheet to show the large suv hire for seven days so we'll go to the here and just remove from the formula go to the previous okay so this and then filter so the card type will be large suv right i don't need all i need large suv okay then the insurance then the number of day hires will be seven so this one this one this one done it's a seven okay so this is the things that they wanted to see display only the client id and total cost so for that things what we'll do client id and total cost inside this we all no need maybe i just hide this right click it's not working okay is there any way i can hide it in together no if you can't able to do it then just click here and then hide click here hide okay so now i have car rental client id and total cost check this maybe if they didn't say the screenshot so we save it as filters so i just receive these things so this is the end of question task b2 now we will move to b3 so they say that what does it mean b3 so for that thing i will just close these things now i will go to my working and from here i will open my evidence folder this one is task task b3 right so b3 so this means actually this one is made by name range name break nothing else so b3 i will add named name range and then give one reason why multiple worksheet are used when creating a spreadsheet so that one worksheet is not contain too much information right or maybe you can ask so that we can organize nicely organize information nicely organize information nicely okay then go to question number three explain what reason why formula replication is used in spreadsheet so that we can save time because we just need to drop and drag save time done save it close it now we'll move to the next question so task 4b is sorry b4 maria has started an information sheet and wants you to edit it open the document information sheet okay so we'll go and open the information document sheet so this is the information document sheet this is the information documents sheet they say that to edit it open the document pale green background double line border so for this one we have to add pale green background pale green background for the design and there is a base color one from here maybe we can add a pale green base color light green like yeah this one is a pale green background and there will be a border this one is a base border from the base border border base border whole document then from here we will choose like two line I choose this one this looks good yeah okay what happened page border whole document box editing we will again try to add the border is like for the design page border and then we'll go to the page border box because they say double border will choose this one and then click on the ok okay it's done so now the question is pale green done double border title dark green serif font bold and center so this one will be uh title dark green dark green serif font so this one should be dark green go to home this one should be dark green so if you want so you will choose ariel should be center align and bold as well bold this one is actually not dark green okay bullet change to a number list so this bullet i have to change it to number this one click here and from here choose the number done text wrap the current text wrap shows that the text in front of the image changes so that it are the image okay so this is actually in front of the image so double click on the image here okay this one came up then we will add maybe this one yeah maybe this one yes so now this is now around there okay paragraph with information around the paragraph the information on the 20 discount display in two column so this one 20 discount this one we need to display in two column so for that thing mark it down and go to the layout and here you have the option for the column choose the two column okay so now it's in two column but it should be in one page so I just need to make something a bit up or maybe I need to reduce some of the space okay yes add alt text car style to the image shown on the car style this is the alt text that I have to add in this image for that one click on the view alt text generate Maybe I don't need to generate, just paste it here. No need this quotation. Yeah, it's done. So now if you want to view it again, you can able to see all text is added. Then merge and center row one. Okay, merge and this is the row one. So we need to merge and center it. So where is the option for merge? Maybe we can get it here. Merge. It's done. Then. Insert the text July in row 1 so we have to add July here Insert a row between 3 & 4 add the text for a hybrid automatic and premium car So if you click here, you will get an option for the plus button then it's open right so Premium car so because we are this is a car tribe. So we add the premium and then automatic this is the automatic and then hybrid so fuel type is hybrid okay so footer july offer and right align it okay for the other things what we will do we'll add a footer so for that things maybe we can go here There is a number of footers are there choose the right aligned footer and here just paste it July offer So we add the July footer, but still it is taking so many space Okay, July footer is here. Then the information sheet must fit on one page So we have to reduce some of the space here Maybe we can just change the font size. So it will take less space then yes now it will be in one page edit the information seed save the information as information sheet too so obviously we'll go to the save as and then this pc in the working pc is seen under the working no it's not under working so desktop there's a working information sheet too i think right so save it like that then save the document as information sheet 3 like make one changes to the layout or design of the information sheet to improve the document so what's the layout we can change the thing that we can change which is like we can change the color of the background if we change it to white it will be more you know visible so for that thing we can go to the design and then page color we can choose white so now the text is more visible so after that you just save it as a information sheet 3. Answer this question in the document evidence. Make one reason why your change has improved the document. It's made the document text more visible compared to before, right? Then task B4C, give one reason why text wrap is used when presenting text and images. So why we use text wrap when we are to present the text and image neatly. That's why we use text wrap, right? Explain one reason why information is added to a footer in a Word Proceed document. we always add footer because we want to add the page number so that user know where they are in the document too right that's the thing so write it down and the end of question this is the end of paper two so please subscribe to my channel and you guys can also join my discord channel i have also facebook page yeah and then instagram page it's up to you just follow me subscribe me so you will get a lot of updates about the subject computer related subject rights for it ICT, Computer Science and IT. Thank you for listening.

So Maria wants to include an image in a presentation. She has an image saved as edit. Open the image and edit it to set the dimension 450 pixel width and 300 pixel height.

Remove the car from the road include the logo you created in task a1 in a suitable position Make sure the company clear name is clearly visible. We'll go to our data folder So this is the data files actually and inside the data files. We have image non office and all those things So when I go to the image folder, I can see there is a pictures which is an image So we will take this one in our Photoshop, right?

So what I will do go to your photoshop and then try the new one i want to add a new one or maybe i just want just i don't need open from your computer so in my computer i want to take this edit image and then open it sorry i already did these things this is not the thing maybe i need to use from here computer take this one yeah open it and this is the image so our question it was like they say that set the image to 450 to 300 pixel height and then remove the car from the road so what we'll do when we set the dimension to this it will actually make the size of the images quite smaller so it is quite harder for to the editing like removing the car so we do the second one at first then we'll move to the first one so first of all i want to hide the car so here the issue is like there is a two type of um background out there right one is a road which is a gray color another one is a brown and green color so what we'll do we'll go to the we will take the lasso tools okay so when you click here there is a thing which is called a lasso tool click on the lasso tool and also uh hold on your command or maybe ctrl and plus button get a better view of the car and then we will take only the part of the road that is considered as a gray color okay yes then we will click on edit click on the edit and there is option for fill click on the fill and then from here you just add the content hour and okay when i will click ok it just takes some of the background right but still there is some of the green backgrounder here so we need some time to do this actually so again i will take the lasso tool okay final pictures that we get without the image of the car so now what i what i will do i just need to change the size of the images so for that thing click on the image and there is option for image size so they say that we have to use the width which is a 450 and the height is 300 and then click on ok now it's become smaller now we have to add our logo hair right so for that things what we'll do where we have the logo just try to minimize these things a little bit and drag your logo hair so this is my logo i want to drag it down yeah so i take it here and then make it a bit smaller and then maybe if we put it here it will be more visible you or maybe you can put it here as well it's up to you so we add the logo and then okay right after that we have to save the image they say like what they're saying about saving saving the image save the images edit one include the logo we already take the logo remove the curve and the height and width also changes right so now save the image as edit one so click and then save save or we have to save as save or maybe export as png edit one right and to save it so it's already saved but it is saved in my download folder edit one i take it to my working folder okay so that means now the images looks like this so it's done Just like this, so it's done. so we completed task 1a and 1b and the third one is task 1a1c which is like open the document evidence enter your name candidate number and center number in the document i think you already know or if you don't know how to do that you can check my previous video where i already mentioned how to do that so answer this question in the document evidence task a1b asks you to save the edited image as edit one explain one reason why the file name should be different from the original file image file name so okay for that things maybe we can open our when our folder 2010 there is a file for evidence this is the evidence file okay so once see what can be your response type it here so i think as my point of view like the original image remain available for reverting right for reverting to its original states or for any further editing that may be required so what we can write we can write here these things the original image remains available for reverting to its original states or for any further editing that may be required so it's done control s save now we will move to the next question task a2 is like maria has information about the curse available for hire she has saved the information in the database car hire the database has three tables the car tables include information about the cars available for hire the structure of the car like they have a three type of tables in the car hire database which is one of the table name is car the another one is client the other one is booking okay this is the three table and the question starts from here it is like maria wants to use a form to add extra cars to the cars table so open the car hire database so what we'll do we just open the car hire database so from here i will take the car hire database from here so this is the database of a car hire and the question is like create a form for the curse table the form must include a form heading which is car available for hire display the width of the field name and field content to three centimeter display the field names with dark green background the field names so what we will do go to this and this is the curse table so we need to create a form right so click on the form here So when we click on the from form we will get something like this view. Here the thing is that the booking table is actually connected with the curse table. So how we can see that suppose if you want to go to the database tool and then relation you can see that this table are connected with each other. The client, booking table and the curse table.

these three are connected with each other so we can able to work with only cars and client we need the booking as well because booking is the one which is connecting the car id and the client id together okay remember these things so we move to the yes whatever we move to the car table so this is the form so that's why they're saying like we'll go to the design view for the cars so this is the save what the form name decided us to give cars form right so all will be in capital later cars if or m cars form and then click ok then this is the cursed form but you have to do some editing here so which is like uh the curse what will be the title cars available for hire right so take these things and paste it here curse available for hire maybe it's just based on your just i just want to add a bold color here then display the width of the field names and field content to three centimeter so field width and field both need to be in three centimeter so what i will do because table booking is connected to this so i just don't want to remove this or do anything with these things okay i just want to design this particular things so for that thing i need the property sheet so go to the property sheet and then from here i need to add the width so with here i want to add three centimeter and then enter so now everything is in three centimeter now okay so after that they're saying like uh this one is done display the field name with dark green background line light green text and yellow three point border okay so for these things we have to design this one so just try to select the all like this way and what we have to do we just need to add the border so try to identify where is the border border width will be three point right so three point then don't use this arrow use this one so from here you can able to choose like like the green one but they also want to add the border color border style is solid border color will be yellow okay so if i go to my question dark green background light green text okay background will be dark green and light green three border okay light green text so maybe what can be the text again you need to select this four thing this one will be the light green text so this one is a four color lighter 40 percent so maybe we can add this one which is a light green text right yeah so this is done if i go to the view point you can see similar like this now align the field so that there is one centimeter gap between the field names and the field content so we have to add the gap between the two fields label and the input so we'll go to the design view again and then there is an option for a padding you need to find out about the padding uh first of all just click this for at first and then you will get the option for the padding and this is the padding so right padding maybe i can add one centimeter and then see how it looks like yes so there is a gap between one save this and go to the view so now there is a gap between right one centimeter so it's like also aligned and once again between the field name and field content okay so save the form as cars form is done take this screenshot of your form in design view so you have to open your property sheet so that you can show that uh your field name and field content why they're set to three centimeter width and green background light green text are used and the field name are aligned with the one centimeter gap this is the thing that you have to take a screenshot of these things with the property sheet that means you have to go to the design view and take the screenshot of this thing so first of all what we'll do try to select all the field and then show them that what is the width you are choosing here right so we choose like three centimeter and then you take the pictures so that's it done then a new car is available for hire use the curse form you created in task a2a to add this detail to the curse table so we have to add this so that there will be st5 standard manual and petrol okay go to the design view it should be st5 st5 then standard Choose standard, manual and petrol. after that just save these things then it's done i will move to the next question which is we save the form take a screenshot of the completed form and paste the screenshot into the evidence folder that's it so maria wants a list of curve that are large suv have automatic transmission are electric so this is the query that we have to assign to the query field right and then they say that create a query on the curse and client table to produce the list so the name of the query will be large suv query so what we will do just close everything go there and design the query from here we'll take actually we need three table here why we need three table because i already show you that we have a relation with a booking table so we just can create a query with this two when it comes to client id and car id because client and car id are not connected to each other so it will not actually filter anything if you just create a query based on cars and client so what we need we have to identify what can what will be the field that we have to show so we have to show the client name client id car id and insurance this is the this is the four field that we have to show right so we will take the client name from here then then we have client id and car id we'll take the client id from the booking car id from here and then car type right so the car type is not sorry it's insurance so we'll take the insurance from here this is the four field that we have to show but we still need to identify the car type two times i don't need just cut it i need car type transmission and fuel type this is the things that we need actually so the car type uh is large suv right so for that things you can just open the car table and from here take the large suv this is a car type right so go to the car type and in the criteria field add the suv and click on enter so it will put the quotation automatically then the transmission will be automatic transmission right so for this one go to here and take copy this one then go to your query and also automatic enter and for this one will be petrol right so take this and then enter but we don't need to show this card type this is but this is only required as a filter value so this is done then they also said something like um be shorted in descending order of client name so we have to do the sorting here so descending order choose descending done save these things uh what's what will what will be the name that you have to provide is a large suv query so copy it it will be better if you copy these things because it will reduces the mistake chances of mistake so take these things and then okay okay so we'll get the large suv query now now if you click on here you can get the okay we get the client id there is some mistakes that i did to go to here again so it's the name of the client name client id well type which is petrol is it a petrol oh sorry it's electric right so i need to go here and then take this one petrol electric save this and then when i go to the close this close this query yeah So this is the answer that we get right. So we already completed question number A to C as well. So display the order and shorter result of the query, take a screenshot and then paste it to your evidence folder. Now task A to D.

So Maria wants some information on client. The list must include client who have taken out insurance and paid a deposit of more than 75 dollars. okay so now we have to create a query based on the client table so this is the three field that we have to show so okay this one is done now we will create a new query create a query design will take only the client the field that we have to show is like go to and check your it's a deposit paid client id and client name so we will take the deposit paid client id and client name right then uh deposit line okay so create a query on the client table to find the information so save the query as a client query who have taken out insurance and paid more than 75 so the deposit if you can go to deposit paid right yeah so it should be greater than 75 and uh we need to add the insurance but we will not make it visible insurance must be true right so true now save it what will the name of the query the name of the query is client query right so go here and paste it okay so we have a client query now delete everything go to yes we get the client query value now oh but the insurance is still showing so we have to not this is not this one this one this one is the client query so uh client id but we are not showing the deposit right we have to show the deposit as well go to the design view maybe yeah but this one we have to assign it at the first then save then run it okay deposit yeah we have the everything now save these things and go to your client query okay so we added the client query deposit more than yes uh okay done maria wants a database report based on the result from the client query so create a database report to display the result the database report must have a suitable title in a serif font size 25 24 so okay so for that thing close this one maybe we need to go to here and then we will create a report This is a client query report right so here first of all it will be better if we save it What if the client report save the report as a client report so I want to save it client report Okay, it's already query.

I want this client report. Okay, so we added this as a client report Open it from here. It looks like this now so we have to provide a suitable title we'll go to the design view and here we will add client deposit report it's up to you you can write some other name as well it's up to you okay and we don't need this so what we'll do try to delete this we don't need date and time the size will be 24 and choose area as a serif font okay now it's visible if you should check right everything should be visible and inside the footer we actually don't need this count as well delete these things we don't need this is this one as well we don't need and delete this one as well so we have to add something in the base footer okay so if you go to the question uh have a suitable title on a serif font yeah this one is group result by deposit paid okay so this one what you have to do go to the report design and there's a group and short right click on here add a group so we want to group it by deposit paid and then save these things go to the view it will be similar like that but there is some space that we have to reduce so for that thing we'll go to the design view again and then try to reduce the space this way and okay so we add the deposit group resolve a deposit page show only the required fields okay not include an automated date and page number in the page footer yes we didn't add anything include the text insurance and deposit this is you have to add in the page footer so i just copy it and go to the report design control and from here take the label you This is actually up to you.

I just want to make it a bit bolder so that it is more visible. Save it and yeah so this is the this is the answer for um question task a to d save the report as client report then take the screenshot including the base footer and everything and then paste it to here but we don't need the logo right for that one we can do one thing again go to your design view maybe i just delete these things yeah now it will pay yeah deposit paid client id and client names is the import but if you want to make it a bit upper shift it to bit upper then you can just take it like this way then you can shift it to upper one at a time and then you can check is it actually looks great or not based on that it will be okay okay so it's done we already created the client report and then the theory question which is give one validation checks that can be checked that can be used in the database so for the validation we can actually add a different type of validation we can add range check presence check type checks length check so what is the range a grain check is mostly used when you want to provide a certain number like one to hundred right suppose if you want to add a age range for that particular field you can add a range of 1 to 100 so people can able to add a age more than 100 whereas you can add the presence checks like for the car name they must have to put the card type right otherwise it will not save your field this is the thing that maybe you can add a presence check as a one of the validation then give one reason why sensible names should be used when saving a form saving a form query and report so it's like they can be found easily next time they are needed right anyone else using the database can also find them so this is the answer then move to question number three which is explained why one reason why maria has used a relationship in the database because it reduces the error right it also prevent duplicate record as well so you can write it like reduces errors because duplicate records will be prevented so this is the end of question a2e now we will start task a3 so which is maria wants you to create a presentation to display in the car hire office the presentation must include three slides so there will be three slides those slides one and two must be fit for purpose and use a green light background with dark green text then include a suitable title include slide number in the header of the each slide okay so we will we will add a powerpoint and here we'll take a blank one so what we will do at first we will just create a master slide based on the design slide one and two so use a green light background and a dark green text so for that thing we will just go here and then search for the master slide and take this one and after that go to the background style so light green right so maybe we can use any type of light green color here it's a bit maybe this one pale type yes okay and the text should be save these things okay i will save it later and the color this one is for the text so we'll click on the customize color and then instead of we will add some dark green right then if i save it's now a dark green so include a suitable title slide number in the header of each title so we have to include a suitable title i don't want to add this one here there will be a suitable title so post this one will be the title format so this one will be the suitable title and they want up okay okay got it they want uh they said that include slide number of the header in each slide so for that thing we have to add a slight number what happened Okay, so we'll add a slide number then add to apply This is the slide number. We don't need the date so just remove the date and from the slide number just take it here at the top header here and and then make it a bigger maybe 40 or yes maybe i think 40 is okay it will be more visible then go to slide master and close it okay so this way we can get a slide things so we created by using a default one the one that they are saying here so slide one must also include text from the file presentation okay so what what the data file they show us we'll go there so yes this is the data file go to the data file office 10 presentation okay for the presentation if i open the data file this is the things that we get so we have to provide a suitable title for this one so this one i can add it here maybe yes we would like to similar like this because they said the translation that we have we need to use that one so for that things we can use yes we would like to hire it uh okay okay for slide two what's name we can able to give we would like to welcome you to hire so maybe we can add welcome to hire right welcome to hire it so this is the suitable title that we provide the emmy image edit one include the image edit one to appropriate image from the image folder so we have to take the image edit one so what we will do because we we already work on this one right this is my working folder so i just drag and drop it here then i try to make it a bit smaller like this one but they also mentioned that we have to take other images as well so if i go to my emails folder then i can see what the other image can i can take which is like maybe i can take this image and two other images suppose this is one of the images i want to take and i want to take another image which is like this one so this is the another image so in total they say first they say Include the edit image and then they say this one. So this is the three images that I Took it from the slide. So in question first one is done the image edit one I already take it already included it to appropriate image from the image folder That one also done border and shadow of the image So we have to add the border right click here and then when you click on the format can able to get the shadow for shadow maybe you can increase the blur a little bit at the shadow this one also increase the blur or maybe you can do some angles it's up to you okay so i just don't want to do much more thing i just because i have to just add the shadow they didn't mention about that i have to um uh add the angle or anything then i have to add the border so for that thing if i click here um okay for the style maybe this one or maybe this one i can take this one is more more better compared to this right so take a board here yes the border is done then a footer the border and shadows on the image done a footer that states office presentation so I have to add a footer here so that one will yes I want to add a footer and footer will be office presentation yeah this one also done then a three second transition to slide two so what i will do here i will add a new slide here new slide okay so it's follow the theme that i use for my master slide that's why this is one of the easiest thing like we don't need to each and every time we don't need we don't need to select the exact background color and the text color so for these things we have we need to add a transition so for the transition when it will move to slide 1 to 2 during that time there will be 3 second transition so you will add click on after and then here I will add 3 ok so it's done now text from the presentation that include the telephone number slide 2 must include text from the file presentation that include the slide sorry phone number the phone number emboldened ok so what is the this one is the text for the slide too so i will take the text i maybe i can take everything and here i want to add a text box yes i want to add a text box here and maybe okay maybe i can just open this one in word document text box add the text box here so this one done but the thing is that this one is taking the color dark green but this one also need to take the dark because we didn't add the body there right so based on that i have to change the color for this one as well so what can I do not this I will add the same color or this one as well it should be the same color yeah same color or this one is okay but we don't need the additional information something like that this too is okay but they say the telephone number should be in bold so we will just make it a bit bolder and obviously the color need to be changed like this one right yes now it's matches so the telephone number apply the animation on each bullet so they appear separately we have to put the animation so maybe the fade in then maybe we add this transition here the same transition maybe we can add one two three okay so a three second transition to slide three so when we'll move to slide three there will be a three second transition so for that thing we'll again go to the transition select after and then click on three okay So it's done.

Now we will create another new slide but for this one we are not following the theme for the master slide. It will be a bit different. So first of all because we have to add the background image here for that thing I can open my image folder and from here maybe i will take any of the image where i can give a visibility okay i can take this one so and then i will right click and send to back so when you right click and send to back it will go to the backward so now i want to increase based on the ok this portion i also have to increase a bit yeah so already yeah this is now aligned with the okay now i have to just say that in slide three a background image the company name clearly visible with a serif font and size is 60. so company name which is a higher 8 must be visible So, because the size is 60 and it should be Arial because they said Arial and I can center it.

Okay, so now it's visible. Maybe I want to change the text color to maybe black. Then it will be more visible.

That one is also applicable. okay or maybe the other color then a three second transition to slide one then there will be a slide one will come with a three second transition so i will add again a transition after two three okay done then i will go to the slide show slide set up i will add the loop okay so when i click ok it stands now when i will do it in the presentation mode suppose uh not this way i want to show it like this okay so it will automatically go after its second and how we can show that we add the transition for that one. If we click here, I can see there is a three second transition out there between each of the slide. Okay, so this one is done. Create the presentation task A3.

So save the presentation. as office we have to save the presentation we need to save the presentation for that thing we will click on the save as and we will go to our working folder so browse maybe i want to do some browsing desktop and this is the working folder i want to give the file name to office and then save it okay So now I already saved my work of the presentation. Where it is?

It's not here. Okay, save here actually. So I just move it to here.

So we completed the presentation. part and provide the name which is an office task a3b answer this question in the document evidence state one reason why note section could be used for slide so that we can remember because when we use the presentation during that time we are not writing every word right we're right we are only focusing on some of the main point so during the time of presentation if you forget and if you use the note and then you write it in detail so it will be easier for you to get what's the point is actually meaning right and the people who will see it as a user they will not able to see what is right inside the note so that one will be the answer for this one and then we will move to so for that thing we will go to our working and there is an evidence file okay this one need to open with doc uh no this is not the evidence here we will write additional information can be added additional information can be added for the presenter who will do the presentation right that's it then the second question is give one reason why master slide should be used when creating presentation so this one is also one mark so for that thing we can use it it will there will be a fewer errors right that's it it will save automatically and then we don't need this sorry we don't need this actually okay where is my question paper so now we will move to the next question uh next question is 2d2 is done a3 also done focus on section b task b1 which is i think spread spreadsheet one yes so higher it offer a car hire in the uk the spreadsheet higher cost contain information on cost of cars hire for may 2024 it has two worksheet called cost and information some function require you to use more than one worksheet okay so open the spreadsheet higher cost so we'll go to the spreadsheet and then we will open the spreadsheet higher cost which is this one so in our higher cost we have a cost and information there's two spreadsheeted there so some function recall okay so that one is done task b1a set the formatting of the heading row one two that means heading row one so heading row one so this one we have to format this one they say that it should be dark color so maybe i can add black and the text should be light color so i add the text as light color uh okay white and then it should be bold as well bold font size is 24 24 alignment that means i have to align it both horizontally and vertically it's quite harder to change to the changes when it's short okay so now right it's done now so now we will move to the next question which is uh okay this one is done format the date to display as 1 may 2014 so we have this way so we have to change it so what we will do for these things we can click on the number and from here there's option for date so from here you choose the country like english so maybe india british united kingdom english 14 march okay so now it's become like this right the way they say it one may 2024 include the text may 2024 in the header so it's already have in the header now we'll move to the next question which is maria want you to use to use a spreadsheet tool to analyze the data in this spreadsheet spreadsheet use the spreadsheet function to display the cost per day for client id a b 11. So cost per day 11 right a b 11 So this one we have to identify the value for this because from the information table What's the meaning or like? Okay, we have to actually we have to create a relation between the two sheet So what's the common thing small SUV right here? We also have a small SUV. So this way we can able to connect So what you will do for this one, we will click here.

We will take the VLOOKUP function VLOOKUP okay and then here we will do the matching of the same data that we have in the two sheets so that one this one we have so c4 click on the array and then go to your information and take the like this way okay so what the column that we want we want the column two so here we will add the two and we will take the exact data here so that's where for the false if you want to change a different data that during that time you can add true so i add false so now i will do some matching is it correct or not small suv 250 250 it's correct right now insurance cost for client id a b 11 insurance cost is for the higher duration not per day higher duration so this one is the insh insurance cost insurance cost that you have to identify the same way right so in information we have an information fee so if we want to get the information again you have to follow the vlookup so click on the vlookup click on vlookup and then okay after that uh okay that that which is the similar data this one right then we'll go to this one we take the whole table and from here which which column we are taking one two three we're taking the third column so three and range look up will be false because we will take the same value okay so it takes the 50 now i want to do some checking as it's 50 is correct now the question is enter a formula to calculate the cost of hire for client id ab11 so cost of hire we have to identify the cost of hire for the client ab11 so how we can get the cost of hire we will multiply this to this and then we will add the cost for the insurance right so for that things we can do like this equal and then i want to multiply this multiply e4 because cost per day number of days right so it is the total cost and then we have to add the insurance fees so insurance is f4 so sorry say four okay enter it's done right you get the answer for this one use one spreadsheet formula in the total cost column here to display the final amount to pay if a discount is given for client id ato like client id ab11 clients who have a total cost of more than 1500 receiver discount otherwise they will get the same price so for that things what we'll do we need a if else statement here so click here click on the if okay okay so logical is like if which one will be greater this one right when g4 is greater than 1500 red 1500 during that time we have to calculate the like minus the discount price right for that one the discount the total cost is this one will minus minus will minus g4 multiply from the information table because information we have the discount which is five percent okay otherwise we will get the value of the g4 and then okay so now i can get like my uh cost of fire is above 1500 more than 1500 right so that's why i get the discount which is a 1710 this one is done replicate the formula function and formula for client AB11 for all other clients. So replicate means we have to just drop and drag. So for that thing i just need to drop and drag large suv okay then for the cost of insurance as well now i want to check the larger suv 60 yes 60 then for the cost of higher yes for this one actually i need to add the dollar here otherwise it will not work okay now so it's above we get the discount this is below we are not getting the discount yes correct so we already replicate the formula enter a formula to calculate the total income for may including discount so this is the total income right for the may so total income here i have to add right for that one i i will use the sum function i will use the sum function okay and here i will select from here to this one and then i will select okay so this is the answer for my total sum now number of large suv higher so here large suv higher so here i have to use the count if function So I have to count right how many large SUV is higher.

So I take the count if okay then the range will be from this table right from here to here and I want to check the large sorry sorry sorry this one the range will be from here to here and criteria will be because we will checking the large acv okay that is 11. now we'll move to next question enter a formula to calculate the total income or this one is done uh total income for me higher average cost of car per day so what is the average cost of car per day we have to calculate this one For that thing we just do the average of cost per day. So this is the cost per day right. So just click here select the average okay and then click all the things okay.

So it will give you the average value. Average value so it's done. So we have a task B1C which is Format the cost worksheet so that currency value show the pound symbol with two decimal places So this is the cost right so here the currency is like this one number of days not considered as a currency insurance cost cost cost so for that thing we can add this maybe we'll do this for the first time go to the number here and then there is option for the currency so it is quite hard to find the pound one so go and find where is the pound English United Kingdom, okay, this is done now I have to do this for this Currency, okay done.

Yes. No, it's okay. So just Yeah, do same for the other as well. Okay, so added the currency with two decimal values Text wrap is used for number of days higher and insurance cost.

Okay number of days higher and insurance cost so this one wrap text Wrap text done Borders are displayed on all cell. Okay, so we have to add the border on all of the cells so for that things we can just take the everything like this way and then we will choose the border where is the border this is the border then on all borders yes it's done we added the all border here so borders are displayed on all cells all formula are visible in formula view so for that thing if we go to the formulas and show formula you can able to see that all the formula is visible now yes it's working perfectly receive higher cost so we have to receive it so because we already created another folder so what i will do i just save it as in my working folder so that it can create a different places for me okay so inside the desktop go to the working i reserved a saved okay done now task b2a maria has created a chart to display the information about the car on the information worksheet she wants you to add a suitable title and um suitable x and y axis okay so if you go here you will get this this this graph so when you click here there you will get the chart title click here and then maybe you can add reference higher cost higher cost of car okay and then click again here there's a xs title and yeah both way you get the xs title so y is represent cost this one represent cost and this one represent car type try to okay make the this one is upper letter c okay so it's done receive the higher cost okay so i want to again want to save it okay maria wants to see save save the spreadsheet as filter now they say this one is done received higher cost okay now save the spreadsheet as filter so we have to save this one now as a filter one so again we'll click here go to this one and then this is working filter i will just add it here as a fill filter okay then i will save it so for safety purpose what i'll do i'll just go to my because now i have a filter one and higher so i will open the filter one because now i will work with the filter one so maria wants to see some information for the large suv hired filter the cost worksheet to show the large suv hire for seven days so we'll go to the here and just remove from the formula go to the previous okay so this and then filter so the card type will be large suv right i don't need all i need large suv okay then the insurance then the number of day hires will be seven so this one this one this one done it's a seven okay so this is the things that they wanted to see display only the client id and total cost so for that things what we'll do client id and total cost inside this we all no need maybe i just hide this right click it's not working okay is there any way i can hide it in together no if you can't able to do it then just click here and then hide click here hide okay so now i have car rental client id and total cost check this maybe if they didn't say the screenshot so we save it as filters so i just receive these things so this is the end of question task b2 now we will move to b3 so they say that what does it mean b3 so for that thing i will just close these things now i will go to my working and from here i will open my evidence folder this one is task task b3 right so b3 so this means actually this one is made by name range name break nothing else so b3 i will add named name range and then give one reason why multiple worksheet are used when creating a spreadsheet so that one worksheet is not contain too much information right or maybe you can ask so that we can organize nicely organize information nicely organize information nicely okay then go to question number three explain what reason why formula replication is used in spreadsheet so that we can save time because we just need to drop and drag save time done save it close it now we'll move to the next question so task 4b is sorry b4 maria has started an information sheet and wants you to edit it open the document information sheet okay so we'll go and open the information document sheet so this is the information document sheet this is the information documents sheet they say that to edit it open the document pale green background double line border so for this one we have to add pale green background pale green background for the design and there is a base color one from here maybe we can add a pale green base color light green like yeah this one is a pale green background and there will be a border this one is a base border from the base border border base border whole document then from here we will choose like two line I choose this one this looks good yeah okay what happened page border whole document box editing we will again try to add the border is like for the design page border and then we'll go to the page border box because they say double border will choose this one and then click on the ok okay it's done so now the question is pale green done double border title dark green serif font bold and center so this one will be uh title dark green dark green serif font so this one should be dark green go to home this one should be dark green so if you want so you will choose ariel should be center align and bold as well bold this one is actually not dark green okay bullet change to a number list so this bullet i have to change it to number this one click here and from here choose the number done text wrap the current text wrap shows that the text in front of the image changes so that it are the image okay so this is actually in front of the image so double click on the image here okay this one came up then we will add maybe this one yeah maybe this one yes so now this is now around there okay paragraph with information around the paragraph the information on the 20 discount display in two column so this one 20 discount this one we need to display in two column so for that thing mark it down and go to the layout and here you have the option for the column choose the two column okay so now it's in two column but it should be in one page so I just need to make something a bit up or maybe I need to reduce some of the space okay yes add alt text car style to the image shown on the car style this is the alt text that I have to add in this image for that one click on the view alt text generate Maybe I don't need to generate, just paste it here. No need this quotation. Yeah, it's done.

So now if you want to view it again, you can able to see all text is added. Then merge and center row one. Okay, merge and this is the row one.

So we need to merge and center it. So where is the option for merge? Maybe we can get it here. Merge. It's done.

Then. Insert the text July in row 1 so we have to add July here Insert a row between 3 & 4 add the text for a hybrid automatic and premium car So if you click here, you will get an option for the plus button then it's open right so Premium car so because we are this is a car tribe. So we add the premium and then automatic this is the automatic and then hybrid so fuel type is hybrid okay so footer july offer and right align it okay for the other things what we will do we'll add a footer so for that things maybe we can go here There is a number of footers are there choose the right aligned footer and here just paste it July offer So we add the July footer, but still it is taking so many space Okay, July footer is here.

Then the information sheet must fit on one page So we have to reduce some of the space here Maybe we can just change the font size. So it will take less space then yes now it will be in one page edit the information seed save the information as information sheet too so obviously we'll go to the save as and then this pc in the working pc is seen under the working no it's not under working so desktop there's a working information sheet too i think right so save it like that then save the document as information sheet 3 like make one changes to the layout or design of the information sheet to improve the document so what's the layout we can change the thing that we can change which is like we can change the color of the background if we change it to white it will be more you know visible so for that thing we can go to the design and then page color we can choose white so now the text is more visible so after that you just save it as a information sheet 3. Answer this question in the document evidence. Make one reason why your change has improved the document. It's made the document text more visible compared to before, right? Then task B4C, give one reason why text wrap is used when presenting text and images.

So why we use text wrap when we are to present the text and image neatly. That's why we use text wrap, right? Explain one reason why information is added to a footer in a Word Proceed document.

we always add footer because we want to add the page number so that user know where they are in the document too right that's the thing so write it down and the end of question this is the end of paper two so please subscribe to my channel and you guys can also join my discord channel i have also facebook page yeah and then instagram page it's up to you just follow me subscribe me so you will get a lot of updates about the subject computer related subject rights for it ICT, Computer Science and IT. Thank you for listening.

Transcript for:IGCSE ICT Paper Practical Guide

Transcript for:
IGCSE ICT Paper Practical Guide