Computer
Application
Technology
Term 2 Practical
Click here for complete bundle:
CAT Grade 12 Practical - Term 2
, Preface
✓ If the formatting in PowerPoint appears incorrect on your computer, please use
the PDF version or upgrade to the Windows 11 version.
✓ You may adapt and change these PowerPoints as you wish and as it suits your
schoolwork.
✓ You are also welcome to share any modifications with me that I can add to the
document, with credit to you.
✓ If there is any work that is not included in the document or if any of the work is
incorrect, please send me an email.
✓ You may not sell the documents, but you may refer anyone to my website.
✓ Happy studying!
info@mathwithmegan.co.za
,● Mail merge :
Index
○ how to mail merge in word, using an excel spreadsheet for a
mail merge, objects, manipulating a table, manipulating an
image, embedding objects, linking objects
● Text functions:
○ left right mid, concatenate, concatenate and the operator,
LEN, VALUE, FIND, function combinations
● Tables in HTML:
○ HTML tables, creating a HTML table, creating a website
Click on the chapter to go to the slide
, MAIL MERGE
How to mail merge in Microsoft Word 1.You start by
clicking on the
The following documents are used: mailings tab in
• Main document- contains the text word, then select
and graphics you want to send. start mail merge
• Mailing list- contains the personal and choose what
and contact information of people type of document
you want to send the email to. you want.
• Merged document- contains both
the main document and mailing
list.
, 2.Type common parts of the letter that do not change
and then type the fields you need that must be replaced.
4.Insert place
holders where you
want to place
personalized data for
example name or
last name by
selecting your text
and clicking on insert
merge field. After
inserting merge field
3.Click on select recipients and your place holders
use an existing list, you can also should look like this.
sort and filter to find only the
recipients you want to include.
, 5.Continue adding fields till your
document is complete and then you
can view the final result by clicking on
preview results. You can also skip and
check if everything is in order.
6.If you are happy with the results you
can click on finish and merge and choose
how you want to finish the merge.
, Using an excel spreadsheet for a mail merge
First you should check the spreadsheet and ensure the column names are the same as the field
names, check that all the data you want to import is on the same spreadsheet, change and add what is
needed, format values so that word can read it and save your document in a place where it is easy to
find.
Open word select mailings, start your mail
merge and when you select your recipients
you select use and existing list. Then you
browse for your spreadsheet and once you
select it click on open. Once you open your
list select the sheet you want to merge.
, After you select the sheet you want to merge, select insert
merge field and choose the fields you want to insert. Once
you are done you can preview the results again and if you’re
happy you can finish the merge.
You can also insert a spreadsheet by
select object then text from file.
Browse until you find the spreadsheet and
insert it into word.
, Objects
Manipulating a table
Manipulating an image
Embedding objects
Linking objects
, Manipulating a table
Once you have created a table you can edit it by clicking on the table. It will open a
design tab on the ribbon and that allows you to make changes to the table
Manipulating an image
When you insert an image you can wrap or resize the picture.
• Resizing and cropping: cropping is when you cut the edges of a picture.
• Rotating or applying text wrapping option: The type of text wrapping used will
show the way text flows.
• Applying different styles and other formatting effects: This includes changing
the border of a picture.
• Adjusting the brightness, contrast and the color of the picture.
