Tugas 2. Semester 2 - Mail Merge

Kerjakan di Weblog Anda masing-masing dengan segala aturan yang sudah diajarkan oleh SUHU PSPB RONGGOLAWEZ21 !!!

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" ?

Selamat mengerjakan !   Pelajar Sejati, Perjuangannya ? Berkelanjutan !   Pelajar Semelekete, Perjuangannya ? Berhenti !

 

http://suhupspbwongtubanronggolawez21.blogspot.com/2010/03/tugas-2-semester-2-mail-merge.html

Review of Middle Test 2

Review of Middle Test 2

Lesson : ICT Day/Date : Wednesday, 03 15 2011
Monday, 11 04 2011
Class/Program : X-C/Core Session : 2
Semester : 2 (even) Hour : 08.40-10.10
Name :Sholihin Tri Bagaskara





Please answer the following questions, short, and right! Please useful english version!

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 and each function of office button in MS Word 2007!
4. Please, specify all the member of View Menu in Ms Word 2007!
5. Please, specify the advantage of managing file in Ms Word 2007!



NOTICE !
Strictly forbidden to operate a Laptop, Notebook, Netbook, and similar!!!!!!


ANSWER :

1. * Microsoft Office Excel 2007 to analyze your business information, create worksheets, and track
time,costs, resources, and people
* Microsoft Office Word 2007 to create, manage, store, and convert documents
* Microsoft Office Publisher 2007 to produce professional publications
* Microsoft Office Outlook 2007 with Business Contact Manager to manage customers, contacts, and
sales
* Microsoft Office PowerPoint 2007 to create dynamic sales presentations
* Microsoft Office Accounting Express 2008 to save time, organized, and do business online with a
complete accounting solution for small businesses
* Microsoft Access 2007 to create a database and then filter, sort, form a graph, and visualize business
information
* InfoPath 2007 to lower the cost of transaction execution and business process technology with advanced
electronic form
* Communicator 2007 to communicate more easily with colleagues and clients in locations and different
time zones using a variety of communication techniques that include instant messaging, voice, and video
* Groove 2007 to collaborate with others in a dynamic in a single workspace that unites all members of the
team, tools, documents, and information
* OneNote 2007 to gather and organize handwritten notes, audio and video recordings, Web research,
screen clippings, pictures, etc. all in a single location.


2.


3. a. New, to make a new document
b. Open, to open a document
c. Save, to save an updated document
d. Save as, to save an unnamed document or to save an old document with a new name
e. Print, print a document
f. Prepare, to prepare a document to be distributed
g. Send, to send a document to another person
h. Publish, to distributed a document to another person


4. Print Layout, Full Screen Reading, Web Layout, Outline, Draft, Zoom, 100%, One Page,Two Pages, Page Width.


5. To Make documents such as, letters, reports, and booklets.

Final Evaluation

A.multiple choice

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

Evaluation Of Semester 2

 A.Multiple choice






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


B. Essay

1. Explain how to change a desktop background.
2. What is the use of a screen saver ?
3. Name and explain briefly the device that can enhance the picture quality.
4. What is the advantage of managing file?
5. How to cancel a deletion in the recycle Bin?
6. Name and explain the briefly about the control size button/
7. What is the Print preview icon for?
8. What icon used for writing mathematical equations or formulas?
9. Describe the steps to create page numbers.
10.How to set a distance among sentences?

ANSWER

1. To change a desktop background can be done by double-clicking Personalization icon on Control Panel. Then click Desktop Background and choose a picture to set as the background display in monitor and click OK.
2. Screen saver is to maintain the monitor display.
3. The device that can enhance the picture quality is monitor and VGA card. The resolution will be higher when using a non-board ( outside the motherboard ) VGA card, which based on AGP ( Accelerated Graphics Port ) or PCI Express.
4. The advantage of management file:
   - For human : We can know where the file has place with easy
   - For computer : To shorten the working power because it work without we must click much time to find where the file had store, beside it the management of file for save the file or data on storage data ( Hard Disk, UFD, CDROM, etc ), manipulating file's copy, change, delete and so on.
5. The steps to cancel deleting file or folder that had store in Recycle Bin we can do these :
   - Choose the Rcycle Bin icon on the Folder panel.
   - Choose the file or folder to cancel the delection.
   - Next, from the ,menu pop up by right clicking the file, choose Restore.
6. These are three control size button, namely :
   a. Close, to close the window.
   b. Restore, to re-show the previous size button.
   c. Minimize, to hide the window.
7. To preview and make changes to page before printing.
8. For writing mathematical equations of formulas we can click Equation icon on Insert tab, group of symbols.
9. Here is how to add page numbers :
   - Click insert tab.
   - Click Page number until the page number location option appears.
   - From those options, we determine the page number position, for example to put the page number on the bottom of the page, choose the Bottom of Page ( Footer ). Then, choose the preferred format.
   - 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.
   - To choose the numbering format, click the arrow below the Number Format and set the numbering format.
   - Click the OK button to close the Page Number Format dialog box.
   - Click OK to finish the page number and its format setting.
10. To set a distance among sentences of paragraph :
      - 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 options.
      - Click OK to set spacing according to the preference.

Evaluation Of Chapter 5. Using Microsoft Words 2007 Words Processing Software

Evaluation of Chapter 5

Multiple choice

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


Essay
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 a ribbon?
      b.  Name part of the ribbon.
4.   a.  How to set the spacing in a script?
      b.  Name type of scripts.
5. Explain briefly on how to make a mass letter using the mail merge facility.

                                                            ANSWER.................
1.first line: 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 within a blocked sentence.
2. a. place the cursor on a table that will be inserted a column.
    b. click the layout tab, look in the Rows & Columns group.
    c. if we are to insert a column on the right side of te table, click Insert Right, whereas to insert a new column on the left side, click Insert Left.
3. a. ribbon is a bar that contains icons to support word processing.
    b. home, insert, page layout, reference, mailing, review, view.
4.A.a. highlight the text to be changed.
       b. click on the home tab, choose a dialog box launcher on the paragrafph group.
       c. on the paragraph dialog box, click indent and spacing.
       d. choose one of thespacing following options.
          singel   : 1 space
          1,5 Lines : 1,5 space
          Double : 2 space
          At least : the spacing is determined according to the minimum size line with the maximum size font
          Exactly : the spacing is determined equally without font adjustment
          Multiple : the spacing is determined by a percentage
       e. click ok to set spacing according to the preference.
    B. Name type of script: Table,grapt,picture and diagram variation
5.Creating  a mass mail with the mail merge
    a.  making a mail merge main document
           1).  open a new document,then click on the Mailing tab.
           2).  choose start Mail Merge and click Letters.
           3).  Afterwards, you can make a Mail Merge main document as seen below.
  
    b.  Making a Mail Merge Database
            the next step after making the Mail Merge main dcument is the make database that contains  supporting information in the mail merge. Database consists of several fields according to the necessity and each field contains records.you make the database separately from the mail merge main document. You can make this sample database using Microsoft Excel 2007.

   c.  Combining the Mail Merge Document and the Database
             1).  Click Mailings tab and choose Select recipients. Click use Existing List
             2).  Find the database file location and click Open.
             3).  Erase the dots within the document.
             4).  Place the cursor under the sentence "Yth.", where the dots were erased.
             5).  Click the insert the field icon on the Mailings tab, then the field option on the database  will                     appear.
             6).  Do the same step on places to be filled in the fields on the database, as follow. Kepada                     Yth.   <status> < nama > d/a < alamat > < kota >
             7).  Activate mail merge by clicking the preview Result icon on the Mailings tab after you are done.
             8).  you can click the next records icons to see the next records.
             9).  Click finish and merge then choose print document to print the document.