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.

Tugas 8. Maintenance Komputer

Perintah SUHU Pintarkan Berkomputer (PSPB) !

1. Carilah artikel tentang segala hal yang berkaitan dengan Maintenace (Perawatan) Komputer. Komputer akan awet, tak gampang rusak bilamana Si User Komputer pandai-pandai merawatnya. Mengapa Anda terlihat cantik, gantheng dan segar ? Kuncinya,"Maintenance (Perawatan)" sedemikian rupa misalnya : mandi, gosok gigi, keramas pakai shampoo, jerawatan diobati, sakit diobati, rambut gondrong dicukur, kuku panjang dipotong, gigi tak merata dipangkur, pakaian serba rapi dan bersih, dll di mana kesemuanya tak dilakukan secara asal-asalan, namun tentunya menerapkan Aturan Main. Selama aturan main dipatuhi, maka semuanya akan berjalan normal dengan hasil memuaskan.
2. Abadikan di Blog Anda masing-masing !
3. Upayakan membuat Karya Artikel dengan Gaya Diri Sendiri tentunya akan lebih baik
4. Tidak direkomendasikan asal Copy Paste begitu saja. Bilamana Copy Paste, jangan lupa mencantumkan sumber pengambilannya.

.

YANG HARUS DICARI sebagai berikut :

1. Cara Mendeteksi Komputer Kena Serangan Virus
2. Cara Menyecan Virus
3. Cara Menangani Virus
4. Cara Menangani Virus Lokal
5. Cara Menangani Virus Asing
6. Tutorial Maintenance Komputer Personal Computer (PC)
7. Tutorial Maintenance Komputer Laptop
8. Tutorial Maintenance Komputer Notebook
9. Tutorial Maintenance Komputer Netbook
10. Tutorial Maintenance Komputer Jaringan (LAN) 
11. Tutorial Maintenance Printer
12. Tutorial Maintenance Monitor
13. Tutorial Maintenance Keyboard
14. Tutorial Maintenace Flash Disk
15. Tutorial Maintenance CD VCD
16. Tutorial Maintenance CD DVD
17. Tutorial Maintenance Mother Board (MOBO)
18. Tutorial Maintenance Hard Disk
19. Tutorial Maintenance Memory
20. Tutorial Maintenance CD ROM Jenis Read Only dan RW.
21. Tutorial Maintenace DVD ROM Jen is Read Olnly dan RW.
22. Tutorial Trik Tips Menghindari Berbaghai Jenis Penipuan Di Internet
23. Silahkan berburu Software Gratis untuk didownload yakni :

• The Latest Free ANSAV+Update
• The Latest Free NOD32+Update
• The Latest Free AVIRA+Update
• The Latest Free PDF Creator
• The Latest Free Acrobat Reader
• The Latest Free Adobe Reader
24. Jelaskan kegunaan seluruh Software yang Anda download pada soal nomor 19 tersebut di atas !

25. Sebutkan hikmah pemeberian tugas di atas bagi Anda !

Sumber  :  http://suhupspbwongtubanronggolawez21.blogspot.com/2009/11/tugas-8-maintenance-komputer.html

Chapter 3

Evaluation Of Chapter 3

A. Multiple Choice

1. a

2. c

3. b

4. e

5. e

6.a

7. a

8. c

9. a

10. c

B. Essay

Answer the following questions correctly.

1. Name several factors that make someone prefer using illegal softwares.

   Answer : * Low income

                  * Low education level

                  * The cost of a permit or licensed software is relatively expensive

                  * Low law enforcement

                  * Lack of awereness to use genuine software

2. Describe the difference between ethics and morality in the society.

    Answer : - Ethics are a concept of acknowlegdment by the society towards human thoughts, which means  that this concept evolves following men's true values

                  - Morality is a code of conduct or a common conception of what is right according to the society ( common values )

3. What is meant by the patent rights of a product?

    Answer : The patent rights of a product is a the patent right to prevent the new product to be duplicated, counter feited, or imitated by other people or company

4. Explain the correct position/posture to use a computer.

    Answer : The following things are to be noted when using a computer :

                  - Sit on a comfortable seat and if it is possible, use a seat that can be bent forwards and backwards

                  - Set thae monitor 2-3" (5-8 cm) above the eye sight.

                  - Avoid excessive light, if necessary, use a screen filter.

                  - Set the body about a hand reach from the monitor.

                  - Try to put your feet on the ground or to the leg rest on the computer table comfortably.

                  - Use the document holder to type a text that is in line with the monitor screen. 

                  - Place keybord and mouse in a reachable place.

                  - Try to keep the arm and elbow in a relaxed position and on the side of the body 

                  - Place the monitor straight from the sight.

                  - Use a keyboard desk that is movable with a mouse position adjusting keyboard position. If the keyboard desk is skewed up then the mouse has to be higher, when it skews down then the mouse should be lower. 

                  - Use a stable computer desk and a keyboard desk.

                  - Take a quick rest frequently.

5. What is the abbreviation of HAKI?

    Answer : Hak Atas Kekayaan Intelektual or World Intellectual Property Organization