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 !

Review Of Semester Test 1

Lesson : ICT
Class/Program : X/Core
Semester : 2 (Even)
Name : Eris Septiani
Day/Date :Wednesday,15 03 2011 (Monday, 11 04 2011)
Session : 2
Hour : 08.40-10.10 (10.45-12.00)

Please answer the following question, short and right ! Please use Full 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 Ms Word 2007 !
3. Please, Specify the function of  Office Button in Menu 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 !

NOTICE

Stricly Forbidden to operate a Laptop, Notebook , Netbook , and similar !!!


1. ~ Microsoft Office Excel 2007 to analyze your business information, create worksheets, and tracktime,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. Pull down menu
Find, find text in the document
Go to, navigate to specific place in the document
Select Object, Change to the selection cursor, so that you can select and
move ink and other objects in the document

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.

Evaluation Of Chapter 4

A. Multiple Choise

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

B. Essay

1. Write down the abbreviation and the functions of autoexec.bat.!
2. Explain the steps to copy a folder or a file!
3. Explain the steps to set a printer!
4. Write down the abbrevation of : a) AGP b) POST c) AFM d) RAM
5. What do you know about file with .com extension?

Answer :
1. autoexec.bat is a system file found originally on DOS-type operating systems. It is a plain-text batch file that is located in the root directory of the boot device. The name of the file stands for "automatic execution", which describes its function in automatically executing commands on system startup; the portmanteau was coined in response to the 8.3 filename limitations of the FAT file system family.


2. a. Search the folder or an external stroage device where your data is in
b. Right click the data to be copied
c. Click COPY to copy data or click CUT to move the data
d. Right click on the folder to place the copy result of the data
e. Click PASTE
f. Wait until the process is done which is shown by the ending of paper animation which moves from one folder to another

3. a. Click START MENU
b. CONTROL PANEL choose CLASSIC VIEW
c. Choose PRINTER
d. Choose the printer to be adjusted and right click the printer's icon
e. Choose PRINTING PREFERENCES, and then select FEATURES

4. a. AGP (Accelarted Graphics Port)
b. POST (Power On Self Test)
c. AFM ( Adobe Font Mertics)
d. RAM ( Random Acces Memory)

5. The file name extension .com has been used in various computer systems for different purposes. Originally, the term stood for "Command file" and was a text file containing commands to be issued to the operating system.

Final Evaluation

A. Multiple Choice

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

Evaluaton 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.

Chapter 5. Using Microsoft Word 2007 Word Processing Software

A. Multiple Choice

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

 B. Essay

    1. What is the difference between first line indent and hanging indent ?
           ~ First line indent is to align according to preference, either letters  or numbers on the   first line of a word or a sentence that has been bloked.
           ~ Hanging indent is align according to preference on the letter or number on the second line. third, and so on within a bloked sentence.
    2.How to insert a new column in a table ?
            ~ First, range amount of the table column do you need. The second, right click on the upper left corner of  the table and choose insert=> insert column finally the column in inserted on the table.
    3. a. What is ribbon ?
            ~ Ribbon menu is a bar that contains icons to support word processing.
        b. Name parts of the ribbon.
             ~Tab Home, Tab Insert, Tab Page Layout, Tab Reference, Tab Mailings, Tab Review, And Tab View.
    4.a. How to set the spacing in a script ?
             ~ Highlight the text to be changed.
            ~ Click on the Home tab, choose a dialog box launcer on the Paragraph groub.

             ~On the Paragraph dialog box, click Indent And Spacing.

             ~ Choose one of the spacing following options.

                Single       : 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.

             ~ Click OK to set spacing according to the preference.

        b. Name type of scripts.
               ~ Table, Graph, Picture, and Diagram Variations.
    5. Explain briefly on how to make a mass letter using the mail merge facility.
             ~ Open a new document, then click on the Mailings tab.
             ~ Choose Start Mail Merge and click Letters.
              ~Afterwards, you can make a mail merge main document as seen below.

Tugas 1 Mainance Komputer

• Bacalah semuanya, sebelum mengerjakannnya !!!
• Setelah mendapatkan Petunjuk SUHU, Pintaku Begini :

1. Buatlah E-mail bisa via Google, Yahoo, Microsoft, dll. ! 
2. Catat User Name dan Passwordnya di Buku Catatan Anda dan simpan pula di HP setelah pulang sekolah ! Andapun Wajib Ingat alias Tak Boleh Lupa !!!
   
3. Buatlah Weblog bergaya Blogspot dan jadikan E-mail Anda sebagai LOGIN ke http://www.blogger.com ! Ikuti 3 (Tiga)  Langkah Utama Yang Telah Ditentukan oleh Pihak Blogger.Com  ! 
4. Bilamana sudah jadi Blognya, maka jangan lupa mencatat Alamat Website Anda alias URL (Uniform Resource Locator) Anda !
5. Untuk sementara waktu, Anda jangan bingung urusan Background/Template. Silahkan pilih sesukanya ! Yang penting, sudah memiliki Website Berbasis CMS Bergaya Blog (WEBLOG) yakni BLOGSPOT.
6. Bilamana ada pernyataan BLOG ANDA SUDAH JADI, maka silahkan Klik Kiri 1x pada tulisan KELUAR (SIGN OUT) yang berada di Pojok Kanan Atas. Lalu cobalah untuk masuk ke Alamat Weblog Anda dengan cara mengetikkan Alamat URL Anda di Address Bar, misalnya memakai Layanan Search Engine Google. Contoh :  http://suhupspbronggolawez21.blogspot.com
   
7. Senyampang belum menghiasi Template, maka sebaiknya gantilah terlebih dahulu lewat Layanan Gratis Template untuk BLOGSPOT, misalnya lewat http://www.phyzam.com.
8. Bilamana selesai semua, maka segeralah Anda menyetorkan ke SUHU PSPB RONGGOLAWEZ21 untuk didokumentasikan yakni :

• Alamat E-mail Anda tanpa Password, sebab Password merupakan Hak Privacy Anda. SUHU dan Orang Lain tak boleh tahu kecuali Anda mengijinkan untuk suatu keperluan.
• Alamat URL Anda.
  

Catatan :

1. Bilamana Anda hanya ingin melihat Isi Website Anda yang sudah pernah dibuat, Anda langsung mengetikkan Alamat URLnya di Address Bar.
2. Bialamana Anda ingin mengelola alias utheg-utheg bin utak-atik Blognya baik Artikelnya, Desain Templatenya, dan Gadget atau Widgetnya, maka selalu gunakan Alamat E-mail dan Password Anda. Untuk ini, Anda harus masuk dulu ke http://www.blogger.com, lalu ketikkan Alamat E-mail dan Passwordnya untuk LOGIN.
3. Bilamana sudah merasa cukup untuk mengelola Blognya, maka jangan lupa selalu Klik Kiri 1x pada perintah KELUAR (SIGN OUT) demi alasan SECURITY KARYA ANDA.
4. Bilamana Ada kendala, segeralah melapor ke SUHU PSPB RONGGOLAWEZ21.
5. Blog Anda sebagai media untuk menaruh Tugas-Tugas yang Akan SUHU berikan dan selebihnya sebagai Ajang Kreatifitas Anda.

Sumber  :   http://suhupspbwongtubanronggolawez21.blogspot.com/2009/11/tugas-1-membuat-e-mail-dan-blogspot.html


Jawaban:Untuk tugas ini sudah dikerjakan dan dikumpulkan kepada SUHU PSBB RONGGOLAWEZ21