IGCSE ICT February March 2018 Paper 21 Mail Merge Section



hello guys Evans here and welcome to this video in this video we'll now start to look at tasks for flow for the moment in the February 2018 IGCSE ICT epi' to one the last couple videos we looked at document production then we finished data manipulation and now we start took damage a memo will be sent to the new post page where teachers create a step in success create mmh memo using 18:03 memo para TF as the master document and 18:03 mmh dot CSV as the data source so in the master document replace your personal details with first of all let's let's do this let's have our master document ready and our source file ready so the master document is supposed to be memo where you see you just open it with word and now we are going to import our our source file so use an existing list and go to read files and pick up mail Mitch okay so don't worry about this just select the default windows default it's talking about encoding and just say select windows default if using a Windows computer isn't Mac I think there should be something else that should be able to do pop-up um I'm not sure I don't work with Mac but there should be something that should yeah so mark you have Mac yeah so you can select mark okay so that is done then the next now we need to do is to in the master document is your personal peoples with your name centered on bank and Amba so personal details master Bookman so you personal details where they yeah so replace this with your name set the number and candy number so that's our Evans zm5 five six and zero zero zero one okay and then next replace to this debt with a dead field to display s debt the format Edie okay and mmm why okay so let's go there so the debt supposed to be here so to these deaths just select it like that then go to inset quick cuts and then field and then hit D on your keyboard to go to dates okay D and then select the depth with DD mmm shows you that it's the full month name okay for month name so for my name is this one example this is 13 August 2018 okay notice it's D then mmm mmm why why why so there's one more day that is missing here so you can just simply add it right from there okay so that becomes DT what this mean is that you have a something like let's say today if it was the fifth term just write in five – right throw five and because there are two characters that I am quiet so that is done and you have the dataset in Hogan so that is done then so maintain they exist in spacing and punctuation and replace the Chevron's with text and context with the appropriate measures from the source but always the spacing should not be changed so this is why when you highlight you need to make sure that you just reach at the end of the angle bracket vector if you exist if you if you've got beyond that you are going to change the order or rather their spacings and lay out the bottom mailings and insert merge field this is first name okay then highlight this one and just end right there and in sit family name then stuff ID okay so just about that and that's stuff ID then first name again so you go around your document looking up for places or areas where you can it's a family name where you can insert the Chevron's okay so that's Department okay job description job description then read through office faculty fuckity then you receive the best pay base pay okay so this will increase annually with invest agreed pay scale you have put a whatever you have been allocated and internal telephone number of this one so make sure it just ends there telephone okay and yep that should be done good so proof read and spell check the memo so when you proofread you just going through make sure that there are no spelling errors and stuff so f7 on your keyboard or or function f7 ignore grandma so if you're not here to to work around which one is the correct sentence and stuff like that we're not doing English exam okay so ignore drama but take notice of spelling so it shows you spelling but what is required here is Tamara or tewara not Tamara written here the aura the aura is a noun and it's not an English English name so it annoyed and this is grammar so ignore grammar and spelling and grammar is done so that is good okay so the next thing that you're supposed to do display the match field codes and dead field then take screenshots and place this in your place document so what you need to do is to display this there so you can you can simply just from here just highlight and then right-click and Tocco field codes I need to show the mage field codes as they are okay now when you do that just either print this in my case I can simply just copy it since it needs to be pasted in the evidence document just copy it and paste it in the evidence document okay let's see supposed to be new absolutely new and then just from there get it up to there and paste it in the evidence document okay so copy and paste it in the evening so this is step number evidence eight so evidence eight where you so close this is I need this one close evidence seven evidence 80cm and paste it right there okay so that should be fine so Dan with this one and they'll go with your Formax next memos are required for only those where the years of service is one and so we need to use a criteria to find where the years of service is one so just come here and then I'm going to toggle back just highlight them again and right-click and Tocco again toggle field codes so that you have the names back okay so now you've got to edit recipient list and go to filter because you want to now extract only those that meet a certain criteria so the years of service equal to one and say okay and so that should be done and say okay and then you have your reports and so now the next that you supposed to do is it says print merge and print letters on it to staff members so what you need to do now is to go mr. go-to here you can check out first we can preview the results see that they are there you can print out these you can merge and finish and print out these individual merged letters other than that so you can do your printouts here guys I'm not going to do the printout show you how to do that the next that you can do is to provide evidence of the data source and the selection of recipe for the memo so a bright screen short evidence of your data source and selection of recipients for the memo what you need to do is to go to here not here you go here and go to edit recipient and then drag this window this site it's important and then go to a filter and then have this video as well so you can have two windows so this is evidence of your data source and that so you can get screenshots if you want you can get screenshot of this window actually just get this okay this is enough so this is evidence of your data source that you've selected your thing and this is evidence of the query that period material that you used and you can copy this and paste it right in your in your thing so just say ok and go ahead and paste it just little here step 29 and that should be fine okay alternatively what you can do is to even enlarge it a little bit so that it's it's um yeah it's a bit visible so just make the text wrap around it so just bounce it from this side as well yeah that's that's full visible alternatively you can get these windows separately get a screenshot of this and get a screenshot of this so this shows you that you produced the data source that is also the printout can also be episodes okay in my opinion this window is not necessary the Medfield recipient window what is important is the query option wind okay so so match managed can also be used for generating personalized letters discuss the advantages and disadvantages of using manage to generate personalized letters to offer investing places 6000 students and type your answers in your own words in every instrument using no more than anyway so it's a very short thanks and you just need to look up that you need to show only four point okay so um here you need to provide evidence so you can start manage makes it easy to write letters to multiple multiple students it saves time of typing individual type in six thousand individual letters okay also one letter the master file okay the master file can be edited only once once and the changes will be yeah it did once and the changes can be applied okay the changes can be applied or the letters okay so maybe we can talk about its advantages the disadvantage of mailmen is that if there is a mistake in the master file if there is a mistake in the master far all the letters will have copy that mystic okay I don't know how many I have written so far but you can think of other stuff as well advantages of a disadvantage of male mesh there are many other this can be applied this is a zip okay that's fine we're not here to correct the grammar okay so if there's a mistake in there then and also if there is an error in the master file then in the printed letters for example let's say in the printed letters then all the letters will have to be reprinted which can be time-consuming as well as costly okay I think guys this is this is this is good okay so that marks the end of marriage and thank you so much guys for watching and I'll see you shortly when we do the last part of this question which is prison

10 Comments

  1. Mojahid Elnourain said:

    Mrs evans whenever i want to a database sheet there would be imports errors

    May 22, 2019
    Reply
  2. Lardka Badaa said:

    Thank you very much Mr Evans
    I do not have MS Office or any other similar softwares, so i have been completing my ICT mocks just by watching your videos and they helped me ALOT. So i want to thank you and wish you to make more videos to help other upcoming IGCSE candidates.

    May 22, 2019
    Reply
  3. Victor_2199 said:

    Thank you very much Sir! You explaining makes it very easy to understand the way how to do it.

    May 22, 2019
    Reply
  4. Samaja said:

    Mr Evans, I want to thank you for the amount of effort you put into your videos. I am sitting my o levels JUNE 2019 and honestly, your videos help me and many others tonnes so keep it up!!

    May 22, 2019
    Reply
  5. Joel Abraham said:

    nice intro music bro

    May 22, 2019
    Reply
  6. New Day Rocks said:

    upload document production part 2

    May 22, 2019
    Reply
  7. lionel mezy said:

    si sos del cole balmo y t pusiste a leer esto suerte mañana xd evans puto amo

    May 22, 2019
    Reply
  8. WENANY AUGUSTINE said:

    Awesome 123 try computer science too

    May 22, 2019
    Reply
  9. Awesome 123 said:

    Thanks, Evans chikasa for helping me achieve A* in ict. 😊 Hope you can help in AS levels too.

    May 22, 2019
    Reply
  10. Queen of Hearts said:

    Hello sir, I just wanna say thank you for everything that you upload in your channel. It helps me alot throughout my igcse journey. To be honest, I used to get straight UG since year 10 in ICT coz I never get it. I got my results yesterday And by watching your videos, I managed to pass and get a C in ICT June IGCSE series 2018. Thank youu so much. May God bless you. I adore you for being so passionate when it comes to teaching. ☺☺ I wouldn't be able to pass without your videos. Thank youu. ☺☺

    May 22, 2019
    Reply

Leave a Reply

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