IGCSE ICT 2016 Specimen Paper 2 Document Production



hello guys my name is Evans and I welcome to this new video tutorials in the series of in looking at the 2016 specimen peppers and in the last video I did a questions from the 2016 specimen pepper 3 and I'm just starting to look at now questions from their 2016 specimen – part 2 and this is going to be quite a lengthy Pepa not video but lengthy paper due to do in that owl I've decided to to split this paper rather these tutorials into about four parts or so because of the nature of the the paths that we sub which is expected of us to demonstrate what to do this task we have document production and we also have let's see we have Dogma production then we have database there's database report this is access and we have labels as well I think I'll do this in one video and we have mail match later I'll do this in another video and you have presentation which I'll do in the last video so I have about four videos that I would do in these in this series for the 2016 specimen Peppa – and so I encourage you just to don't follow this video step by step I will trial by all means to finish this video in the next let me just say in the next one week I should record all the four videos or so on so don't be discouraged when you find this one and then don't see another section just know that I'm working on that right so without wasting much of our time I did download the files that I needed to work in this paper so these are all the source files that I need to work with in this paper and then I have my question paper as well okay so let's go straight into what is expected of us so you work for a company called stars cars you are going to perform some clerical tasks for this company so for reports the following a paragraph styles must be used with only the attribute specified in their house specification sheet and then you have these attributes that are there so this is the house style specification seat you have your title and the phones you have sensitive 24 points center-aligned subtitle and so on and so forth so don't forget about these specifications that we have here we are going to come back and actually work on on these but just know that we have the title we have subtitle we have subheadings and we have body text and we as of these are the attributes that we are supposed to I mean these styles are supposed to have okay so star company is a company that imports cars and needs to keep in contact with these distributors at the top of each sheet of the company letters star cars must have their company name and a suitable logo to represent the company so when designing company documents you may wish to add further enhancements to present a professional appearance for the company so documents must be easy to look at in the filing system all right so that's the scenario that we have and we go straight into task one so task one evidence document so open the file s16 evidence dot RTF make sure that your name Center number and candid number will be on every page of your evidence document by placing these details in the header of the document so I'm just going to go back to my source files and open s15 evidence again so I'm going to open this one with office right so this is the evidence document that we have and this is where our evidence work is going to go our screenshots and all so what we're going to do is just gonna go back to the question Peppa say we need to make sure that our names in tournament at the number appear on every page of the document so this has to be placed in the header so careful this has to be placed in the header and not in the footer so I'm going to go on inset and under head down select blank three columns and I'm going to put Candide name here Castle Evans and zm5 five as the center number five five six as well as the Candide number at the end zero zero one zero zero zero one yeah three zeros one I always use these details in all my videos so that we keep the consistency and so weigh my okay yeah so the next thing that I'm gonna do is okay so save your evidence document in your work area as evidence followed by your candid number for example evidence nine nine nine nine okay so I'm gonna save this as save us and then I browse to my work area which is the same place I am and our service as evidence then the candid number at the end and I'll click on save okay so close it there right so you need the evidence document during the examination to place your screenshots sorry about that got my interactive board sound is just way way too much let me just reduce this alternative let me just unplug the cable USB cable from there right thanks right so what about that guys yeah so what I want to do now is to go to the tasks to document production you are going to edit a document about the development of a new port okay so using a suitable software package load the file is one six spot hood RTF so I'm just going to go back to my source file and then load s once exported RTF is this far and open right so that's that's the file that we have there so I'm going to go back to questions I set the page size to fo and set the page orientation to portrait okay so let me just go back to Wed okay so this is the file that we have and you can notice just by looking at the far it has got different takes some phones this is like area 14 check this one is area 12 font size so you've got a document that has got different font types inside and so you have to be very careful when you work with such a document okay that consistency is maintained and I'll show you just in a while what I'm talking about okay when you have a document that's got different font sizes within it you must be very careful that you check that when you apply font sizes it is actually consistent – I mean consistent with the other phones okay so mmm that's it now the page size to set the page size to let me just verify we set the page size to f4 and page orientation to portrait now guys I must confess here that I'm kind of having some struggle a bit cause my internet is sort of not my internet but my computer is sort of in the background doing some stuff to just close some applications just like and maximize the resources that I have I'm trying to record this video on a very high definition so to say so I'm just closing some applications so that I don't necessarily have to okay right so I hope this is going to at least work on some minimize the use of the resources okay if it doesn't work I'll come and shut down I'm kind of downloading something the background so it's kind of taking long to respond sorry about that right so I'm gonna go on layout and go on page setup and I'm gonna change my paper to f4 and the orientation to portrait okay and that's what we're taught let me just verify okay so step aside to f4 orientation to portrait and the margins on step two must be set to two centimeters across the ball so I'm gonna go back here and go to the MAGIX I'll put two centimeters there two centimeters there two there and two there okay so just select and hold press tab key on your keyboard and can just type in what you want right so am I supposed to get evidence document just verify if I'm supposed okay so evidence play screenshots of page size and margin settings in your evidence document okay so I'm gonna go back here and click okay now what is supposed to happen guys is that you're supposed to get the evidence now to get there are two ways that you could get the evidence of paper size or margins for example for paper size they can come here and capture these screenshots of the key area is f4 okay and then for margins they can come here and let's see and capture this one okay you see that this is the custom setting okay but I always said the better one is to go for this one okay where you get this one and then captured the paper size here f4 so I'm gonna get the screenshot of this and then place it my evidence document okay let me just say okay and come here and place this in my evidence document paste it there you'll need to crop this image this guy so that this is more visible what we interested is just this page setup window the background and the word document in the background we are not interested in that so what we just interested is this one here but for the sake of time I'm going to crop the I'll leave that up to you okay so but you're in the exam you need to crop this so that this central party is actually visible right so I'm going to go back and get evidence of the imagine so I'm gonna go back here and go to imagine now you sit here evidence of orientation and evidence of the margins is on one screen so I'm gonna get a screenshot of that and go to my evidence document and just underneath here I'm gonna paste that one here again you need to crop this so that you just have the page setup window all right so they'll go so save the document in your work area use the format of your software package and give the document a new name so in other words we are working with word so we're supposed to save this actually with the format of wait okay which is a document file so save us browse and in the same area we're working I'll change the type to wet document don't forget that it should be saved to the format of the file type your work in other applications software package rather that you are using so in this case I'm using weight and I know that with the extension is I mean of Word documents supposed to be the type of file supposed to be wet document so I'm gonna rename this as s16 sport and I'm just going to say edited okay so maybe just not say edited let me just put my candidate number at the end zero zero zero zero one okay and say save and you'll get this just confirm that you want to change to the newest file format and say okay next step step three enter in the header your name and candid number left aligned and your Center number right aligned so I've come back here and go to insert and then header and then inside blank three column now guys may I say here that sometimes people say that date is better you just double click in the header there and for example just double click there and then you put in the header well you can put in the header like that but in some cases you are required to have these aligned to the margin and so it's there for example you had to type right aligned okay you have to type something at the end there whatever you typed can you see that it is not aligned to the imagine it is leaving some gap at the end there and this is the mistake line I've noticed in many ICT papers that students submit in when you are told to align something to make sure it is aligned to the margin and you find that you can't really have it aligned to the MAGIX because you are using custom like I just type in the text and trying to push this one for example pushing it close and even when I'm tapping the spacebar on my keyboard I can't push this further or closer to the margin so guys don't don't be in a hurry to do this one unless you are very very very sure that what you have been asked for is actually what you're doing so I'm gonna go an inset and I'm gonna go to header and put plan 3 column now what blank 3 column does that automatically the first part of the text is going to be aligned with the left margin and the right part of the test is going to be aligned with the right margin and it's very very useful to put headers and footers in that way so left aligned my name kazar evans and my candidate number 0 0 0 1 right aligned I'm gonna put my Center number as M 5 5 6 in the middle I don't have to leave this remember these are professional documents that we are creating you can't just leave type here this one here type here as it is I mean this is a professional document for God's sake that you are creating so you need to delete this part right like that so that looks beautiful okay so I'm gonna go back to the question paper and so enter in the footer automated file name left aligned now you must be very careful it didn't say of vomited file name and path he just said automated file name okay and insect to death dead right aligned so I'm going go back to my document and go to inset at this time when I insert a footer again I will choose blank three columns for the sake of the alignment and I'll go just click there and go to quick Pat's and go to field and then just hit F on your keyboard for the first letter for file name and you see that file name will appear alternative which case you can scroll down but it's a waste of time so just hit F then select file name there remember don't add path okay because you've not been told to add the path ok so just say ok and you see that the name of the document will be there right aligned you are taught to put the Det so just click on date and time and I love this one's beautiful sunday 10th April 2016 I'm just gonna put this one there right so right so I'm gonna delete this one as well I don't need it ok next step make sure that all the alignments match the page margins remember this is what I was talking about guys so if you had to go work in like where you just double click on the header and all the food and then you typed it won't be aligned with imagines but check this one it is very much aligned with imagines check the other one as well it is very much aligned with imagine this is beautiful guys this is beautiful ok so we've made sure that all our text actually matches the imagine the header text in the header and the text in the footer is actually corresponding to imagine make sure that the header and footer are displayed on every page so if you go back this is my page to go to page 1 and you see that you have you have your header and your footer also displayed on each page ok so like I said guys here and there you will see my word not respondents because I'm doing something the background and it's kind of using so much resource and sort of but I hope we'll be able to work without really major major major major content right so create your edit this paragraph styles to be applied to the text in the door documents are referred to refer to the house style specification sheet for details on these styles now the house Dow specification seat is actually the one that was just at the beginning of the document and this is what we're supposed to have so style is supposed to be tight or whatever Devi's old I don't know if I can put these pages or this windows side-by-side I don't know if it can work out what I want to do is okay well I can be flipping switching in between the windows here and there alternatively have a hard copy of the question paper and I can just read out what I have there but guys take note of what we have so I'm gonna go back to here and so we supposed to first of all hit edit the title so typed your style is supposed to be San serif 24 points and Center aligned so come back here so guys your styles are actually here so you see here it's written stars okay so these are the different styles that you have had in know more subtitled ID or no space in whatever whatever and those these are the different styles that we have so what we're going to do is to just edit this down so I'm going to go right click on a star source title and go to modify and then under there and then we need to set up now what we have to say so one we need to pick up a sans serif font and if you don't know what the censored font is I encourage you to just google the difference between sin self and cell phone or tentatively you can watch another video that I did I thinks of it's one of the videos I did the 2015 October November data analysis video I did thoroughly explain the difference between San serif and self font okay so so I'm gonna go for is 24 points and then Center aligned and cells to be sans-serif so I'm gonna come back here I'll make it 24 points and then I'll make it this is already a SAN serif font okay and I'll make it Center aligned okay there is no other thing that is supposed to be dead so I'll click on okay so already the title has been set okay we've modified the title next we need to modify a subtitle so subject is going to be censored as well 18 points italic underlined and right aligned well this one's got some couple of attributes nevertheless I'm just going to go there so go to style and then subtitle is this one so I'm going to right-click and modify so subtitle is going to be 18 points I think 18 points and serif so it's already sound self just need to make it 18 point and then make sure that the text is black okay and then it has to be right aligned it must be italic it must be underlined so let's just verify that okay so it must be sensor if you've done that 18 point then that italic we done that underline done that and right aligned we've just done that okay so let's go back there okay so Dan okay San serif font 18 PT it is italic it is underlined it is right aligned that should be fine say okay next we're going to set the subheading okay so subheading is supposed to be San serif as well 12 points simple lines 12 points single line spacing okay please guys this is very interesting here okay let lists it confuses you say but what is the font size for the for the subheading and stuff is supposed to be 12-point and supposed to be single line spacing with one clear line space after a subheading oh I'll quickly demonstrate what I'm talking about here okay so suppose this was a subheading okay and so it is going to be 12 points okay line spacing but a clear line spacing after each subheading which means the space between this one here and this one here this space that you have there is supposed to be a single line spacing of 12 points okay so guys take take note of that okay lest it confuses you and say but mr. Casas o su casa by the way is my my sanam with paper we begin thing but fools mr. khasinau I'm Evans casa su casa is my sign name and so you are you don't get confused when I when I do that so let's go back here and edit this one so let's got here this is supposed to be a subheading so you have a heading and you have what and everything does that you can do that you can define these headings or these styles as well so you can say create style okay and then create it's supposed to be a subheading okay and say modify so this subheading that I want to modify it has to be twelve points it has been San serif so I'll maintain I'll be right now it's important that when you are using San serif font you maintain the San serif font throughout and the cell phone that you are using you maintain it throughout don't change here use comics and they use maybe card ability I use whatever just be consistent with the people remember this is this is a professional document that you are creating so you must really be consistent must look it must look homo Sadie's must look attractive it must look professional so to say right so colour should be black of course let me just verify we have Sun surf okay twelve points single line spacing with one clear line space after each subheading or after subheading so I'm going to go back here so it's twelve point here and I'm going to go to format and go to paragraph and it must be single line space but it must be twelve as well okay because we wanted to assume the line spacing that is in between I mean the spacing that is in between that so it's a single I don't know a single line spacing the exercise it could be a 10 here but I'm not sure the single line spacing decides after that but a 12 wouldn't be too bad okay so I'll just say 12 and before I click okay I want to verify this anything so 12 points single line spacing with one clear line space after a subheading so one clear line space so after subheading we have a single space and I'll say okay so and I'll say okay here I don't know if is it supposed to be center-aligned do anything nothing okay just say okay so we've defined for subheading and you will see that it will come here as subheading okay so we've defined title to find subedit we defined subtitle we need now to define body so body is supposed to be a cell phone ten points one point five a line spacing it's supposed to be fully justified with one clear line space after each okay each paragraph so I'm gonna go back here go – there's no body here so I'm going to define a new style create a style now quit body ok body texts and I will say modify okay all okay so there is body text that is reserved so I'm just gonna create body and escrow text alternatively I can just say body is too fine okay so there you go buddy so what I want for this one is that it should be ten points and it should be a sine cell phone or make it Times Roman and it should it should be one point five spacing should be fully justified okay so I'm going to go back here and make it fully justified this one here just Phi and then go to parallel format then paragraph line spacing is supposed to be one point five and I'm gonna make this one 10 PT okay because of what we have faith so 10 PT I should be fine I should be fine okay so just verify before I eat okay okay so Sarah points 10 points 1.5 line spacing fully justified and clear space 1 clear space after each problem now guys may I also say here this is very important test by default word is actually set to add to don't add space between paragraphs of the same style okay but this one guys is very crucial what this means is that if you have multiple paragraph let me just go back here suppose this one is a paragraph and this one is a paragraph and I have rather this one is a paragraph and this one is also a paragraph in other words I have multiple paragraphs in under one heading so to say so what this does is that when you you say don't add space between paragraphs of the same style ok of the same style which means for example the style that we have defined is body ok body and if I say don't add space between paragraphs of the same style all the text that is going to be formatted with the style body is not going to have text in between the paragraphs ok so what we want is after each paragraph remember the question tells us that after there should be one clear space line after each paragraph so if you don't check this one if you don't uncheck this one like this you are not going to have spaces after each paragraph in your body text guys this is very important I'll repeat what I'm trying to say here guys that if you have multiple paragraphs and you're going to apply a style one style to multiple paragraphs this is supposed to be unchecked if you want to have some space after each paragraph okay so for example I'm going to have some space after each paragraph of 10 points okay now it's very important that you uncheck this one because if you don't and check it you need to assign that you are going to have no spaces in bit in the paragraph so after each paragraph you don't have space okay sometimes it can be before a paragraph you need to have some space so you need to be very sure that you understand the question fully and ice it is very interesting guys once you understand the question it's easy for you to already put out in the answer that is required of you but if you misunderstand the question you'll be doing the wrong thing and in the end you're going to get wrong results okay so our and check that and say okay and say before I say okay to this one it says verify one more time so Seraph ten point one point five fully justified and clear space after each paragraph so just fight ten point sensitive and the other one is done okay so let me just say okay so I'm gonna go back to the question paper okay so we done with that step there that asked us to do that that was step four now we just need to show evidence of the details of your definition of the body text paragraph style in your F this document now body text is the one that we just put the style as body last one damages from editing so I'm going to go on style so the body is this one I'm going to modify and this is what is required of this one so you have this one and then you also have this one these are the two things that we modified under body so what I'm going to do is just put this one this side okay and get the screenshot of this so I want these two windows to be there because what I want from here is evidence that I have changed my spacing after each paragraph to be 10 PT and my line spacing is actually 1.5 okay this is important and on this other window what I'm looking for is that I have applied to a style called body and I have I have plight just fight whatever now guys may I just say something here let me just say okay okay let me just say okay if you go back here this now is supposed to bear the name body text okay so man just come back here and modify the name sorry about that modify the name to protects remember I did attempt to type body text and it told me that it was the way it exists and probably it's because I tried to work through this paper beforehand so I'm good what I'm just gonna do is to put an underscore and say body text okay and say okay so I'm gonna go back here now and if I do that let me just put this here and then go there and paragraph and then drag this there so these are the two windows that I want and I'm just going to print screen there and say okay so go in my evidence document and screenshots of body text out definition let's push this down and I'm gonna put it just down here best so like I said you need to crop the outer pads what we just want is are these two windows here so I'm gonna go back here I've shown evidence step 5 insert a blank line at the start of the document and enter the title dog facilities at put paper pet part not pay bad pearpad yeah dog facilities at Port Peppa so I'm gonna go back here at the start of the document so I'm going to go to the document scroll up okay now this is where it's going to take some time to respond there you go not responding okay just grow up come on come on come on you can do it let me just try to close these guys otherwise it will it will attempt to and just close this come on what's your problem okay let me just use my task manager and force it to close okay so Firefox it was using a lot of memory and just force it to close okay that should be fine okay so what I'm gonna do now is do what what did what did I want to do okay so put a let me just copy these guides for the sake of time I want the video to be too long so I'm just gonna copy this but you're supposed to type that okay so just go back to my desktop refresh my computer a couple of times and then go to my word document so at the start of the document which is this one guys let me see if I missed something here did I skip any step no I did not I did not skip instead it looked different to document all right so at the start of the document I'm going to paste what I copied okay paste it there and I've been asked in the next step to apply the style title style okay so type dos Dow is this one here just click on it and you'll see that you come on the center next step seven below the table the title add report by and then add your name so I'm gonna go back here just below here I will say reports by and then I'll put Casa Evans and then I need to format these apply the subtitle style to this text so go back here double click on this let me say triple click get a triple click and go to format it as subtitle you see that you do a format a subtitle next after subtype doe format the rest of the Word document as body text into two equally spaced columns with one centimeter gap okay so what this mean is that this text which is supposed to be the text of the body is supposed to be formatted okay as so I'm going to go on layout and then columns then more columns two columns and then space in one centimeter and say okay so you have this as that next apply the body text style to the rest of the document okay so the body text are the one that we just created and we need to apply to the rest of the document so I'm just going to go on home and then apply body text okay now guys here I want you first of all to just just just hold for a moment I explain something notice that the whole text is highlighted right but when I hover my mouse over the body text I expect every text to be changed to ten to the size 10 but you see that some text is kind of larger than the other text and some text is way too small it is supposed to be small but it's kind of you know so this is very important guys what you need to do is just go ahead and click there and you see that some text is going to to show that it has been the text has been applying I mean so you see that for example this one is ten then check this one is 14 okay remember what I told you initially that when you have text in a document that is inconsistent where you have some text is larger than the other subject is this some Texas that you need to be very careful that you you manually make sure that document is consistent easy it would be irrelevant for you to present this document let's say to a company where you're working say this is your report that you did some Texas too small some text too large I mean it won't look nice so won't look professional and I can guarantee you you either be put on probation you'll be put on probation to see if next time you're going to produce such a document okay if you are working for me and you produce such a document and give to my clients as a report and stuff I'll definitely put you on probation and if you continue me such documents I'll fire you no apologies right so what is supposed to do guys is excited to double-click on the text that you have so select this text and manually apply the body text and you see that it's going to be then so select this one as well and click on text select this one click on body text scroll down select any other text that is there so test select this other text click on body text and so right so from there I think I should have all the text in support is now highlighted and it is now under 40 guys this is very important place in the exam you get started but why is this text like this and this other one like this this is what it supposed to do right right so let's go quiz n Pepa step 11 in the left column before the first paragraph of the document enter the subheading a major region report so I'm just gonna go there right click copy this and go back here just there right at the start of the document I'll go up there and paste in that okay okay so next identify all subheadings in the document and apply subheadings down to each one okay so this is a subheading okay so remember in step 11 this one that we have entered is actually a art and subheading so it should be part and parcel of the subheadings that we are going to identify in the document so I'm going to write double-click on that one this is a subheading this one is a subheading let me see this one is a subheading so just hold ctrl key on your keyboard and this one is a subheading as well this should be a subheading is it's its own its own as well should be a subheading this should be a subheading okay so let me just verify that I have all the subheadings that I need okay so just one two this one three four five there's no more sub edenian six I don't know if it's excellent connectivity if Excel connectivity is actually subheading is it a subheading or just a continuation of the text from the previous rather from the other column here I think yeah this is uh this is attractive too okay so this one you find this sentence is incomplete and it comes and completes on the other page rather on the other column no no it is a subheading because this one you have a four stop here at the end of page one dedicated rail sightings and then there you have at the beginning connectivity excellent connectivity is a subheading so just highlight it as well so guys is very important that you are very careful don't be in a hurry to identify the subheadings okay so because of that I need to apply the subheading format okay so just put subheading and we see that all this add the text is going to be given subheading so next find the table s16 export dot RTF and then set it at the end of the document so I'm going to go back to my source files and then I don't know if it's this one and let me just verify ya s16 export dot RTF I said rich text file and right click it and go to open ok right so what I'm going to do is just copy this ok select it want to copy the table am I I've got my menu is not sure enough okay so guys I want to copy the table but my menu for some reason is not sure enough what I'm gonna do is actually to just use ctrl ctrl C on my keyboard to copy it okay it is supposed to show me when you right-click let's it's supposed to show me the menu okay also that so there is on the keyboard also a menu button there I've just clicked on it on the keyboard and the menus pop that this is the menu I expect to her to have when um when I when I when I when I right click with my mouse alternatively I could have just copied with control C on my keyboard so I'm gonna go back here and we are told that we're supposed to put in set it at the end of the document so I'm going to go back to this document and scroll down to the end of the document so the end of the document is supposed to be now for some reason I don't know why this document left some space on this paragraph and opted to split the paragraph in a in a in that I don't know why because page 1 is fine it is filled up I expect that before we shift to before we shift to this other column this is attractive too it should continue on this page because there is so much space here so I don't know why for some reason it has thin so let me just guys highlight my whole text and find out if my under paragraph in I think line whatever my window we do and often control is on but for some reason I don't know why this one is supposed to be there so so I don't know for some reason why this is this has gone on to the other side I don't know guys I if I figure out the way I mean why it has decided to go on to the other side as opposed to because what I'm looking at currently is the fact that before a column actually could before this would go into a column alternative what I can do I'm just going to do this just as an experiment experiment rather I'm just going to make this back into a single okay so this one is not supposed to be on its own like this guy's this these are all files I think I don't know if it's a widow but it's supposed to be pushed to the next line okay just check also that you don't have a sentence that is hanging on its own then this is what orphans and widows all about but I'm just so surprised that it actually filled – this actually failed to fit on one page let me just go there and go to columns now this is you're not supposed to do this I'm just trying so to make the text so if it were in one column I'll bring back to code two columns between one column it ends there okay so if it was two columns just go there make it two columns and make it one centimeter gap it's two gone comes back – same thing okay guys I think I want a push or force myself to really work on this but I hope you understand what I'm trying to say how that this has actually pushed this to the next line and as opposed to having it in one column okay so it's not supposed to be that way so at the end of the document is actually this one so I'll press Enter key why and I have some text coming this side okay it'll work out guys you know it's like it's like the moment I pressed and then some text came to this side so I presume that the moment when I put some text here down here when I put my table it is actually going to push part of this text which is up here and it will be push this other side so let's go ahead and paste our table as you can see that the text has been posted aside freedom okay so it is fine okay so let's come back here so we've inserted the table so we make sure that the table fits the column width and apply body text to body text style to the text in the temple guys this is important sometimes some temples that when student bring them in the paestum the table extends and defeats maybe this area from here and the tempo just protrudes the magellanic pounds the reason is because you need first of all to put your cursor at the end of the sentence there and press Enter key so that the next the next whatever stuff you are going to put that images and do this one guys that I show you what I'm talking about you put your your cursor at the end of the sentence what happens is that when I press Enter key there like that the next thing that I type will take in automatically the formatting of the previous text so in a waist imagines everything will fit in even the text when I type you see that it is of the same text font size whatever it is just everything the same so this is very important guys that you do that if you want to make sure that whatever you pasted there it is of the same margins okay so I'm going to paste that like I did and then come back here to step number 15 match the cells in the top row of the table across the five columns okay and then format only this row to be Center aligned and underlined okay so I'm going to merge these cells right click for some reason I don't know why I'm not able to right click I don't know guys I'm not able to right click so I'm going to trust my my my keyboard key ok for menu I don't know what happened maybe it's a setting that disabled somewhere what so I'm gonna go in made sales once I made the sales then I'm going to go on make it ok guys we did do one thing we're supposed to apply this one step 14 I'm sorry about that we should have skipped this one apply the body text style to the text in the table so let's come back here and just select the table and go to home and apply body text and your table should look something like that yeah so select this one and then Center it and underline it okay so just verify that it's supposed to be Center aligned and underlined next step 16 apply gray light gray 20 to 40% set in to only the top two rows of the table so that means here this one and this one only should be applied to the Shetty so to in order to be to do the shading just come here this is shedding click there and then hover your mouse over these figures and you see that as you try to hover your mouse there you get this is 15% and over this one this is 25% that should be fine 25% should be fine next step 17 set or borders of the table to be visible when printed so I I just copied the table or the borders are already visible so I don't need to set the borders to be visible in print hit okay sometimes when you paste depending on how you paste it sometimes you can paste the formatting that was this step was existing with on the other page and it will come with the table sometimes it can just come with the text without the borders but you need to put the borders later on but I love to copy and paste together with the formatting that existed on the previous step okay so step 18 import the image okay import the image s16 ship dot jpg so we're going to resize this image to an to a height of three centimeters and we maintain the aspect ratio where this image is supposed to go it supposed to go on the first page just below the subheading a major original port and it's supposed to be aligned to the top of the first paragraph and some supports supposed to be aligned to the left imagine so what this means is that just at the beginning of the document just after this region of Port there just at the beginning there with the relative impressing Enter key I just put the cursor at the beginning of the northwest region country whatever and then I go to insert and then picture then browse to my files s16 ship is this one and then inset okay so you see that the picture is going to be inserted there so the next we're supposed to provide a pro format do some formatting we need to set the height to 3 centimeters and maintain aspect ratio okay so let's do that so right click there and go to what are we doing size and position then go to size it's supposed to be the absolute make sure that aspect ratio is locked if you don't lock aspect ratio when you change the height the image the width will remain as 8 and the image will be distorted so change it to 3 and you'll see that the image would automatically change its height together with its width okay next the image is supposed to be placed on the first page that's true we done that the image supposed to be below this one we've done that the image is supposed to be aligned at the top of the first paragraph okay I mean supposed to be aligned at the top of the first paragraph I think we've done that and then the image supposed to be left aligned to imagine we've done that and then we make sure that the text wraps around the image so comes here we come here and right click and then go to text rapid and select square square is the one that makes the text to wrap around the image okay so you see that the text wraps around the image the next thing is supposed to do is to make sure that it may look like this you just need to make sure that the text is aligned with the top of the first paragraph this one here the text is aligned to the top of the first paragraph just come there and just click the text the image and try to drag it to bit down there you should get this green boundaries that you're saying it shows that the image is aligned with my margin it's perfect it's green and it's aligned with the top text so in the first paragraph it's also perfect okay so that's how you can know that your image is aligned there if your image was out of place let's say your image was like that okay it is left aligned but the image is not where we want it must be aligned with the first with the paragraph it must be aligned with this paragraph here okay so you drag it down and as you drag it down you can you can you can see how it is moving so drag it there and you see that I get a green boundary left aligned and I get a green boundary top it is aligned to to the paragraph that is perfect okay so next use the information in the table so this is what the text would look like with the image and you have the text been aligned together with the image just like that perfect so use the image in the video rather in the image in the information what am I talking about haha guys get some tired I'm beginning to read insane things that don't even exist on the question paper ah this is good right so good step 19 use the information in the table that you placed in your document to produce a bar chart showing the actual export compared to plant export volumes you may need to take there you may need to take the data into another package to produce the chart okay so you may mean you can produce using width or you can produce using using another package I prefer using a different package and then just come in and pop in and impersonate there so if you come here we're supposed to use this data okay we're supposed to use this data to produce a tempo okay so what I'm gonna do is just get the last two values there why the last two values because this these ones I know this one is an axis this is for example year this is 2007 2008 2009 2010 so I know this is an axis I know this is going to be the title maybe the title of the chart or anything and then these are the values okay so instead of getting the whole values of this again I can just get or I can get this just these three okay copy them did I copy let me just get them for some reason my right clicking is not working so I'm just going to go there then copy this and then I'm going to create the chart wizard exhales very good for Chad's stuff so I'm gonna paste my work there I have the years and what so why it's been selected I'm just going to go to inset and then insert a chart that type supposed to be a chat of that type okay yeah supposed to be a chat of that type now the values that I need for the chat that these actually just these two go there and insert that okay so this is the chart that well so let's go back here so the church should display vertical bars we done with that step 20 they label a lip of the chat with the title Kai export volumes so I don't know why it's highlighting all the things I don't know what's happening with my computer today so I'm just gonna go car export volumes car is that the title in rights and engines each car export volumes car exports volumes okay as my title next category series LED board labels fully displayed okay so if I click on this and then go to there my data label should be fully displayed in fact my data labels already there you can you can see that I have the 60,000 there and what I don't need the legend so I don't need this planned actual I don't need that okay and then I don't know if I need a grid line the grid man okay looks good it makes it easy for you to read the values okay and then the axis I need them again the axis I need them so under axis titles let me just verify the title the axis titles as numbers of car that is and then yeah so here is the x-axis and then number of cars is the y-axis how do you know if you come back here you notice this is your one year two year three or four okay which is corresponding to that so what I'm going to do is just click there and go to axis title and just put them and you see that this is access title access title so I'm just gonna click there and say here this is here and then click there and say number of cars number of cars number of cars just double click the answer number of cars okay next in check this is supposed to be the this is supposed to be the category series labels must be displayed in full so I don't need to have what I have here for example one two three four I need to have the year okay so what I'm gonna do is to just go on I will now double click on this specia on here just double click in anywhere around between 1 2 3 4 just double click there what's happening consume to select okay there you go double click there and then right click and go to select data if I'm not mistaken yeah select data and then you see that you have 1 2 3 4 and then say edit ok so edit now you need to provide the range of the years that you have so you can click there and drag all the way there ok that'll be fine you see that the years are going to display there or alternatively what you can do is to type in the years manually so 2007 comma 2008 comma 2009 comma 2010 ok this this hat 10 20 2010 ok this is another way of doing that ok but you know the easier one is just ready to select which one you want to be the range so I want that one and just drag and drop there and say ok and you see that it will be there and I have ok there so I have this chat ok so in the next thing that I need to verify ok so I have the cut the type of the chat the category is displayed fully I have the figures this side and half the years this side and have the access titles as well displayed number of cars as well as the year there and that is perfect so what I'm going to do is just now to copy this and then come and paste it in my word document okay so let's just verify this any other step like we've done so place the chat at the end of the document after the table resize the church to fill the column width and keep the aspect ratio so this is very important with the system that thing that we did with the other one so what I'm going to do is just put my cursor at at the end there so make sure that it is actually it is actually there so just paste there okay just best and then my title is there my chat is there so what I'm going to do is just verify also just verify that okay just verify my diagram is there let's just verify that the chat fits the math imagines you see as you can see the chat is within the margins and this side the chat is within the margin and that should do it perfectly next down is step 21 so we supposed to do some spell check and proofread the document I won't do proofreading for the sake of time otherwise the video is going to be very long so I'll just do some spell check so I'll hit f7 on my keyboard now the first thing that you encounter is this word has occurred several times in the text pepper pepper depart depart and I want to believe this is not this is a name of something so a noun can not they can be also a word that is not English so you don't start looking for an English wedge to replace this okay you you are you are you are told that the the name is supposed to be peppered okay so don't change anything here so to save yourself time instead of just saying it no then you go to PayPal again ignore then you go to pepper Zdenek don't they a lot of them just say ignore all so all pay pods will be ignored now the next thing is you notice is 11 kilometer long okay now they the thing is that you are using a number as a standalone it's actually weird active to use a number in text and just leave the number as it is in between two texts and then this 11 kilometer is just like referring to if it was like 11 km it would have made sense the text would not have been highlighted but 11 kilometer doesn't make so much sense so what I'm going to do is just hit on change so that you have a hyphen in between 11 and kilometer to just make it like this is one one single way okay so the other thing that we need to verify so down with the spell checking we need to make sure that place page breaks if necessary to ensure that the tables do not overlap two columns of width so if you come here before even go there logistics there are no widows or orphans there are no blank pages and stuff so just come here highlight the whole text and go to paragraph and then go to line spacing we're doing open control so just click this one okay so I don't know why these are the ones sort of they're not supposed to be like that okay so I don't need these other ones I don't know why they were selecting for some reason so I just need often control to be on okay what this is going to die to do is that if there is text that is existing let's say sentence that is existing in the last part of the document on its own it's going to be pushed to the next part and then if there is a paragraph that is existing the being of the part of the existing on its own let me see yeah the beginning of paragraph' existed on a page at the end of the page for example if the beginning of paragraph' was the only one here the only text here then it needs to be pushed to the next line okay and then also if the end of the paragraph less at the end of this paragraph was ending in this single line here there is there was no this other line here it was just ending in this single line then would need to to control that as well so that's what often and we don't control do okay so okay so we're done with this one save and print your document to make sure that you've entered your Center number candid number and name on on your document it's very important the new there you go with your twenty nine marks and I'm sure you should be able to get you two in nine months so I'm just gonna go ahead and print this and just say okay okay so just go ahead and print this I'm not gonna go and go and print this I don't need to stick it or maybe let me just print it it is always these things what am i printing no no guys you know I've printed something wrong I'm printing the question Fair Park can you imagine I'm supposed to print the document it the word document this one this one I'm supposed to print now he can read it I hate the question paper okay this is funny no it don't print let me just stop my printer from printing the question paper it's not right my printer almost uh okay so there goes so I'm just gonna hit on print on this one and then it will be printed to do that but the other thing gathered i've noticed that there is some specia check the disk space here just just make sure that there's no blank spaces there okay so that's not not it's not good to have blank spaces just check the damn there are no blank spaces yeah just check that they verify there are no blank spaces okay that government looks a little bit okay I'm comfortable I'm content except that this line here it's kind of you know is this line this one here but it is too fine okay I don't think it's so much of an issue still fine okay still fine think the the other issue could be could have been that I put this one yeah so if it is like that no why should I even modify this if it's fine perfectly just like that guys I'm gonna have to stop this video I might say this video has been quite a long video 1 hours 6 minutes is quite lengthy I'm sorry for some of you guys who I would really find this video quite long but this step this video had a lot of steps that we had to do and I had to take time to really explain some of the stuff there I hope you found it informative either way and I pray you subscribe to my channel and wanted like in this video continue sharing them with your classmates your friends and recommend this channel to somebody you never know what it may do to them and yeah so thank you so much for watching and I'll see you in the next video where I will start to look at data manipulation right so see you in the next video guys

50 Comments

  1. Moath Alneser said:

    My mock is tomorrow πŸ˜”

    May 22, 2019
    Reply
  2. Flaming Lion said:

    make things more easier 11:05
    U do not have to crop it. Just hold Alt+Printscreen which takes the screenshot of the window.

    May 22, 2019
    Reply
  3. Alexy Makhamreh said:

    Always saw people writing that their exam is tmw
    Now it is my turn
    Thanks chikasa

    May 22, 2019
    Reply
  4. Karam Hasanzade said:

    Do we have to crop the outer parts of the evidence picture? Is it 100% necessary?

    May 22, 2019
    Reply
  5. Olaaa Yasss said:

    Thank you so much Chickasa , amazing video with perfect explanation , life saver!!πŸ‘ŒπŸ½

    May 22, 2019
    Reply
  6. Harshala Gharat said:

    My exam is today morning,thank you chilkasa evans

    May 22, 2019
    Reply
  7. Rmax. said:

    Tomorrow is my paper 21 practical exam!
    I am pretty confident 'cause of Evans.
    Thanks man!

    May 22, 2019
    Reply
  8. Abdulla Asad said:

    Sir can you please do more papers

    May 22, 2019
    Reply
  9. Fluffy_Creature said:

    Thank you so much!!!! you are also entertaining!

    May 22, 2019
    Reply
  10. Hitesh Patil said:

    Hello sir, your videos are really helpful for me

    May 22, 2019
    Reply
  11. Taha Sulaman said:

    amazing video
    πŸ™‚

    May 22, 2019
    Reply
  12. mamta singh said:

    Tommorow are my exams and here I am learning

    May 22, 2019
    Reply
  13. Kashaf Khan said:

    PLLSSSSSSSSSSSSSSS DO ALEVELS ICT!!!!!!!!!!!!!! EDEXCEL

    May 22, 2019
    Reply
  14. WeatherForecast said:

    I was told by so many people that you were Indian… you don't sound Indian, you sound African. Am I right? Great vid btw, very helpful!

    May 22, 2019
    Reply
  15. Amoori Ahmed said:

    Actually gonna get A because of your great work

    May 22, 2019
    Reply
  16. David Kotovich said:

    u are the best

    May 22, 2019
    Reply
  17. 2308ARY said:

    Chikisada , you're an odd fellow, but I got to say, you teach a good ICT

    May 22, 2019
    Reply
  18. Zeid Badulla said:

    thank u, you video was really good

    May 22, 2019
    Reply
  19. F-27 G-489 said:

    56:31 I heard something else…

    May 22, 2019
    Reply
  20. Rahaf Raisi said:

    exam is tomorrow high level of stressss

    May 22, 2019
    Reply
  21. Ahmed Alabry said:

    you are a god thanks

    May 22, 2019
    Reply
  22. Hind Al Hashmie said:

    my exam is tomorrow πŸ™

    May 22, 2019
    Reply
  23. kxlIn iOS said:

    Unfortunately my exam is Tomorrow,days pass so quick.Thank you for help,nice explanation.

    May 22, 2019
    Reply
  24. Hassan Malik said:

    Cie paper on Tuesday

    May 22, 2019
    Reply
  25. Divyansh Sharma said:

    Hey! that's my birthday—- 16:16, which is today!!!

    May 22, 2019
    Reply
  26. blueberry Velvet said:

    Help! The green boundary does not show when I align a picture. D:

    May 22, 2019
    Reply
  27. Hello Hello said:

    Please continue with the great videos ure doing I’m probably gonna pass atleast tommorow cause of this video

    May 22, 2019
    Reply
  28. Arselio Mussane said:

    it real helped

    May 22, 2019
    Reply
  29. Mohamed Hamzawi said:

    Thank you so much for your assistance , It really helps me to get through the exam questions

    May 22, 2019
    Reply
  30. Bzrk said:

    Thx bruh

    May 22, 2019
    Reply
  31. Dhivya Shivani Raviselvan said:

    Lifesaver

    May 22, 2019
    Reply
  32. Mahima Kochar said:

    When modifying the style for the sub-heading you made the spacing after as 12pt and also the font as 12 pt. in the question paper it said 12pt, so was it for the font size or spacing? They aren't the same right?

    May 22, 2019
    Reply
  33. Lola Ahmed said:

    can u please do 2017 papers

    May 22, 2019
    Reply
  34. Abdul MateenShafiq said:

    Thank you would have failed without you

    May 22, 2019
    Reply
  35. Kabab_mey_haddi 420 said:

    Unfair ! U have microsoft sans serif font but u still use callebiri instead waaat? No reason? Btw thnx just clear this shitty doubt

    May 22, 2019
    Reply
  36. Izah Sohail said:

    Very helpful. But you talk way too much πŸ˜‚

    May 22, 2019
    Reply
  37. Rameen Adil said:

    Thanks!

    May 22, 2019
    Reply
  38. CLASH WITH CHAMP said:

    too slow and u didnot identified some questions correctly! and if the paragraph goes on the next column that will be adjusted automatically at the end of the document!

    May 22, 2019
    Reply
  39. sulaiman thiruv said:

    Thank you a lot, I would have flunked my exam if you didn't make this vidieo

    May 22, 2019
    Reply
  40. bhuneshwari singh said:

    u are sooo helpful!! I really hate ICT and know nothing about it only u help we with it Evans!!

    May 22, 2019
    Reply
  41. Rana ProGamer said:

    56:34, did you just swear?

    May 22, 2019
    Reply
  42. Yaswanth Sandaka said:

    Amazing video,
    keep it up

    May 22, 2019
    Reply
  43. Tylor Angel said:

    that accent thoouuuu dammnnnn

    May 22, 2019
    Reply
  44. The Quacken said:

    exam in 6 hours fk

    May 22, 2019
    Reply
  45. Da Chronic Vlogs said:

    got exams tomorrow . hope me luck guys ?

    May 22, 2019
    Reply
  46. Roy Cheung said:

    I think for the columns that you chose 2 columns for the selected text, but if you maybe put your cursor on the first word and did the columns thing but from this point forward i think it would work.

    May 22, 2019
    Reply
  47. Dr.Wipe_Out said:

    i didnt undersatnd too why u put 18pt and then the other one 10pt when the question didnt say it it said one line space after each paragraph and the subheading explain to me because i dont know

    May 22, 2019
    Reply
  48. Dr.Wipe_Out said:

    i really dont understand i did everything but still get some of the waterfront on top to the right of major..

    May 22, 2019
    Reply
  49. Fenix Xia said:

    i need to learn how to crop -_-

    May 22, 2019
    Reply
  50. jss said:

    whenΒ I paste my table its always really compressed what should I do, if I make it longer to make it more visible wont that lose me marks?

    May 22, 2019
    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *