Visual PowerPoint summaries covering term 2's practical work for Computer Application Technology Grade 12. These summaries are ideal for matric CAT learners. Revision packages, additional resources and practice papers gathered from online resources are included.
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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller mathwithmegan. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $6.81. You're not tied to anything after your purchase.
