Tugas 2. Semester 2 - Mail Merge

1. Definisi Mail Merge ?
2. Sebutkan dan jelaskan 3 (tiga) unsur pokok Mail Merge !
3. Sebutkan dan jelaskan tentang Database !
4. Manfaat Database ?
5. Contoh-contoh software aplikasi pembuat data berbasis Database ! Minimal 5.
6. Sebutkan dan jelaskan prosedur membuat dokumen bergaya Mail Merge !
7. Sebutkan dan jelaskan prosedur membuat Main Document (Master Surat) dalam Mail Merge !
8. Sebutkan dan jelaskan prosedur membuat Data Source (Source Data) dalam Mail Merge !
9. Jelaskan mengapa harus terlebih dahulu membuat Main Document dalam Mail Merge !?
10. Jelaskan prosedur Merger "Main Document" dengan "Data Source" dalam Mail Merge !
11. Dalam proses membuat Dokumen Mail Merge, bisa apa tidak langkahnya diubah yakni : Pertama, membuat Data Source dahulu; Kedua, membuat Main Document; Ketiga, menggabungkan keduanya ? Jelaskan dong !
12. Dalam proses membuat Dokumen Mail Merge, bisa apa tidak langkahnya diubah yakni : Pertama, menggabungkan Main Document dengan Data Source; Kedua, membuat Main Document; Ketiga, membuat Data Source ? Jelaskan lagi dong dong ah !
13. Bagaimanakah prosedur menyimpan secara aman atas Dokumen Mail Merge yang dibuat ?
14. Jelaskan, apa ekstensi file yang berupa Dokumen Mail Merge !
15. Bagaimanakah cara mengenali suatu Dokumen yang sudah dibuat dan disimpan di suatu Drive, misalnya Drive D ? Jelaskan !
16. Bagaimanakah cara membuka Dokumen Mail Merge yang sudah disimpan di suatu Drive ?
17. Bisa diedit apa tidak,"Dokumen Mail Merge" yang sudah tersimpan di suatu Drive ? Jelaskan dong caranya !
18. Bisa dicopy apa tidak ,"Dokumen Mail Merge" yang sudah tersimpan di suatu Drive ? Jelaskan dong caranya !
19. Bisa dihapus apa tidak,"Dokumen Mail Merge" yang sudah tersimpan di suatu Drive ? Jelaskan dong, mengapa menghapusnya ?
20. Dokumen Mail Merge dibuat melalui Software Aplikasi, apa namanya ?
21. Software apa sajakah yang menjadi saudara/saudari dari software Microsoft Word ?
22. Software Microsoft Word dan Saudara/Saudarinya masuk rumpun apakah ? Nama Perusahaan Produsennya ? Alamatnya termasuk Websitenya ?
23. Software Microsoft Word dan Saudara/Saudarinya, termasuk Open Source Software (Free Program) ataukah Close Source Software (Paid Program) ? Jelaskan!
24. Bisakah Dokumen Mail Merge dibuat melalui Software "Ms Excel, Ms Power Point, Ms Outlook, dan Ms Publisher ? Mengapa demikian ?
25. Bisakah Dokumen Mail Merge dibuat melalui Website Blogspot dan yang sejenisnya ? Mengapa demikian ?
26. Sebutkan dan jelaskan manfaat membuat Dokumen Mail Merge ! Minimal 3.
27. Dokumen Mail Merge yang sudah dibuat, apakah akan dicetak seluruhnya ? Mengapa demikian ?
28. Bagaimanakah cara mencetak Dokumen Mail Merge ?
29. Bisakah, Dokumen Mail Merge diconvert (diubah) dalam tampilan Dokumen Bergaya PDF ?
30. Jelaskan, apakah PDF itu ?
31. Apa kepanjangan PDF itu ?
32. Apa tujuan membuat Dokumen PDF ?
33. Dengan software apakah, bisa mengubah Dokumen Mail Merge ke dalam PDF Mail Merge ?
34. Gratis ataukah Berbayar,"Software Creator PDF" itu ? Bilamana gratis, silahkan Free Download, di manakah untuk mendapatkannya. Bilamana sudah mendapatkannya, silahkan diinstallkan ke dalam Komputer Anda ! Bilamana Berbayar, beli di manakah ? Silahkan beli, kalau memang ingin membelinya !
35. Sebutkan dan jelaskan Keunggulan dan Kelemahan Software "Open Source" dan Software "Close Source" ?

Jawaban ulang UTS

Question:

1.Please,specify and each function about all the members of Microsoft Office 2007!
2.Please,specify and each function about all the members of Pull Down Menu in Ms Word 2007!
3.Please,specify the function of Office Button in Ms Word 2007!
4.Please,specify all the members of View Menu in Ms Word 2007!
5.Please,specify the advantage of Managing Files in Ms Word 2007!

Answer:

1.- Microsoft Word is make a document,make a letter,a repprt.
- Microsoft Exel is make a repport the work use table,number,grafik,etc.
- Microsoft Power Point is make a persentation.
2.# Home
# Insert
# Page Layout
# References
# Mailing
# Review
# View
3. a.New :to make a new document
b.Open :to open a document
c.Save :to save an update document
d.Save As :
e.Print :to print a document
f.Prepare :to be distributed
g.Send :to sent a document
h.Publish :a document to another person
i.Close :to close the active document
j.Resent document
k.Word Option
l.Exit Word
4.-Print Layout
-Full screen
-Web Layout
-Out line
-Draft
-Ruler
-Etc
5.M.Word 2007 Pro Fides main marge facilyty to make remare latter/document.

Evaluation of Semester 1

A. MULTIPLE CHOICE
PAGE 110 - 115

1. D
2. C
3. D
4. C
5. A
6. B
7. C
8. E
9. E
10. D
11. C
12. B
13. C
14. E
15. B
16. E
17. A
18. E
19. E
20. B
20. C
21. A
22. A
23. B
24. B
25. C
26. A
27. E
28. D
29. A
30. C

B. ESAI

1. Explain the proper way to turn a computer On and Off !
Turn On the computer :
a.Ensure that all power cable in a computer are connected
b.Turn On the CPU by pressing the ON or Power button on the casing
c.Turn On the monitor by pressing the On or Power button on the monitor
d.Wait until the booting procedure is finished, which is shown by the desktop appearance on the monitor screen.
Shut Down on the computer :
a. Close all active application programs.
b. Click the Start button on the desktop menu.
c. Click the Shut Down button
d. Wait a moment until the computer is shutting down.

2. Name several categories of application software !
a.Word Processor (Office Suite)
b.Graphic Suite
c.Multimedia
d.Web Browser

3. Explain briefly about computer operation !
a. user
b. input
c. CPU
d. output
e. and back to the user

4. What is the abbreviation and the function of ROM !
ROM = Read Only Memory. ROM is to save computer operation program .

5. Name word processing software from Windows Vista operating system !
Those are Notepad and Wordpad

6. Name types of flash memory that you know !
CF, SD, MMC, Memory Stick and xD

7. Name three examples of computer network topology !
a. Bus Topology
b. Star Topology
c. Ring Topology

8. What are the ethics in using ICT device in the places of worship ?
kuTo avoid ICT device and To switch into silent or vibrate mode

9. Name aspects to be aware of in using a cellphone ?
a. Use a handsfree device to reduce the electromagnetic wave. Even though it has not been clinically proven, electromagnetic wave can distrub brain cells and can cause cancer. Using cellphones for a long period of time can heat the ears.
b. Do not use the cellphone while driving. Besides it is against the rule, it distracts the driver's concentration. IF it is really necessary to use cellphone, use a handsfree device.
c. Do not use cellphone on a plane. The electromagnetic wave transmission distrubs the navigation system in the cabin that could cause a plane uncontrolled or lose direction
d. Do not use a cellphone in a gas station. The warning is because it can break the cellphones or the filling up digital devices in the gas station.

10. Describe the advantage of using genuine software !
a. Free application software updates
b. Official technician support
c. Upgrade discount
e. Software manual
f.Guaranteed free from virus and spyware

Evaluation of Semester 2

A. MULTIPLE CHOICE

01. A 11. C 21. B
02. E 12. D 22. D
03. A 13. A 23. C
04. A 14. C 24. A
05. B 15. A 25. D
06. E 16. D 26. D
07. A 17. D 27. A
08. A 18. A 28. A
09. A 19. A 29. B
10. A 20. B 30. A

B. ESSAY

1. explain how to change a desktop background?

* choose desktop background to set the picture.
* Subsequently chose a picture to set as the background.
* If you do wish to have a picture at the background display on the monitor the picture can be eliminated by choosing solid color in the picture location options and then choose the color as a background


2. what is the use of a screen saver ?
Screen saver is to protect the screen from the electron that jumps in high speed because of the magnetic and electric field efect inside the monitor

3. name an explain brefly the device that can enhhance the picture quality ?

* Besides the monitor, another device to support the display quality is VGA card (a graphic card).
* The resolution will be higher when using a non-on-board. (outside the motherboard) VGA card, which based on AGP (Accelerate Graphics Port) or PCI Express

4. what is the advantage of managing file ?
-Help us find a file/folder with spesific criteria

5. how to cancel a deletion in the recycle bin ?
-choose the Recycle bin icon on the folder panel
-choose the file or folder to cancel the deletion
-next, from the menu abobe choose Restore this item or by right clicking the file , choose Restore

6. name an explain breifly about the control size column?
There are 3 control size buttons, namely
a. Close, to close the window
b. Restore, to re-show the previous size window
c. Minimize, to hide the window

7. what is the print priview icon for?
Print Preview, to view the print layout

8. what icon is used for writing mathematical equation or formulas ?
Formula Bar

9. describe the steps to create page number?
several documents require page numbers. Here is how to add page numbers.
a.Click the Insert tab
b.click Page Numbers until the page number location appears
c.from those option, we dtermine the page number position, for example to put the page number onthe bottom of the page, choose the Bottom of Page (Footer). Then, choose the preferred format.
d.to set the number format, click the Insert tab then click Page Numbers then choose the Format Page Number icon until the Page Number Format dialog box appears.
e.to choose the numbering format, click the arrrow below the Number Format and set the numbering format
f.click the OK button to close the Page Number Format dialog box
g.click OK to finish the page number and its format setting

10. how to set a distance among sentence ?
Here are the following steps to set the chracter spacing.
-Select the test to be set
-click on the Home tab, choose the dialog box launcher on the Font group to show the Font dialog box
-Scale option is to set the scale to adjust the space among characters
-Spacing option is to adjust the space among characters
-Position option is to set the character position towards a line

Evaluation Of Chapter 5

1. B
2. C
3. D
4. B
5. B
6. D
7. A
8. D
9. C
10. D

 B.ASSAY
Answer the following questins correctly.
1. What is the difference between first line indent and hanging indent?
2. How to insert a new column in a table?
3. a.What is ribbon
    b. Name parts of the ribbon.
4. a. How to set the spacing in a script?
    b. Name type of script.
5. Explain briefly on how to make mass letter using the mail merge facility.

Answer:
1. - First line indent : It is to align according to preference,either letters or numbers on the first line of a word or a sentence that has been blocked.
    - Hanging indent : It is to align according to preference on the letter or number on the second line,third,and so on with in a blocked sentence.
2. a. Place the curser on a table that will be inserted a colunm.
    b. Lick the LAYOUT tab,lok in the ROWS & COLUMNS group.
    c. If we are to insert a column on the right side of the table,click INSERT RIGHT,whereas to insert a new column on the left side,click INSERT LEGT.
3. a. it is a bar that contains icons to support word processing.
    b. Home,Insert,Page Layout,References,Mailings,Review,View.
4.a. >highlight the text to be changed.
       > click on the Home tab, choose a dialog box  launcher on the paragraph group.
       > On the Paragraph dialog box, click Indent and Spacing.
       > Choose one of the spacing following optipons.
            Single     : 1space
            1,5 Lines : 1.5 space
            Double    : 2 space
            At least    : the spacing is determined according to the miximum size font.
            Exactly     : the spacing is determined  equally wihthout font adjustment.
            Multiple   :  the spacing is determined by a percentage.
     > Click  OK to set spacing according to the  preference.
   b. Tables,Graph, picture, and diagram variation.
5. - Open a new document,then click on the Mailing tab.
    - Choose START MAIL MERGE and click LETTERS.
    - After wards you can make a mail marge main document as seen below.