MS Word Activity1

Instruction:

1. Create the given business letter under the filename of "MyLetterActivity".
2. For the margins: all the margins should be 1".
3. Paper size: A4
4. Font sizes must be 11pts
5. Use the Trebuchet font.
6. Add header and footer for your letter and insert logo or picture, put your company name and mailing address as a header and your company’s motto as a footer. You can use any picture you want for the logo.
7. Paragraph spacing between paragraphs should be 11 points.
8. Paragraph alignments should be justified.
9. Paragraph style on the body of the letter should be Body text.
10. For the numbered list , change the style to MyList, Bullet position: Indent at= .5 ; Text position: tab space after= .75; indent at=.35

Sample letter:

16 December 2006

Mr. John Cruz

Manager
Mine Company
87 Delaware Road
Hatfield, CA 08065

(082) 123-456

Dear Mr. Cruz,

I am writing to apply for the programmer position advertised in the television. As requested, I am enclosing a completed job application, my certification, my resume and three references.

The opportunity presented in this listing is very interesting, and I believe that my strong technical experience and education will make me a very competitive candidate for this position. The key strengths that I possess for success in this position include:

• I have successfully designed, developed, and supported live use applications
• I strive for continued excellence
• I provide exceptional contributions to customer service for all customers

With a BS degree in Computer Programming, I have a full understanding of the full life cycle of a software development project.

I also have experience in learning and excelling at new technologies as needed.

Please see my resume for additional information on my experience.

I can be reached anytime via my cell phone, 0919-1216060. Thank you for your time and consideration. I look forward to speaking with you about this employment opportunity.

Sincerely,

[Put your signature here]

[FirstName LastName]

SAMPLE OUTPUT:

Click the image to view larger size....

Operate a Word Processing Application Questions

GENERAL QUESTIONS:

1. What will you do if you have newly installed software, then you don’t know how to use it? Give 3 answers.
2. What are the safety precautions in order to prevent document loss in case of power interruption?
3. Ways in restricting your files from unauthorized access.
4. Ways in transferring content from one application to another.
5. Ways in viewing the toolbars of an application.
6. What are the types of printers?
7. How to install/configure a printer?
8. What is a folder? What are the steps in creating a folder?

WORD PROCESSING QUESTIONS:

1. What is Word Processing?
2. What is the use of MS Word in the business?
3. What are the parts of an MSWord Environment?
   
4. How to format the fonts of a document?
   
5. Is there a way to standardize the format of your MS Word document? How? Kindly give at least 2 answers.
6. How to correct the spelling and grammar of a document?
7. How to set the autocheck spelling and grammar?
8. How to change the case of a text of a document?
9. What objects can you insert on MSWord?
10. What is the procedure in inserting/creating object from other application to MSWord?
11. Can you work using Paint inside the MS Word? What are the steps?
12. What will you do if you want to remove a portion of a picture and you have no access to software for photo editing?
13. How to change the paper size and the margins of a document?
14. How to insert and format bullets and numbering lists on a document?
15. How to insert and format borders and shadings on a document?
16. What is Mail Merge?
17. What is the use of Mail Merge? Give examples.
18. How to insert and format diagrams on document?
19. What is a Drop Cap and how to format a Drop Cap?
20. How columns are are made on a document?
21. How to insert and format table on document?
22. How to convert paragraph of text to table?
23. How to convert table to text?
24. How to use breaks (Page break, Column break, Text wrapping break)?
25. How to insert and format page numbers?
26. What kind of printer to use in printing your document in MS Word?
27. What will you do in your new printer in order to be use in printing a document in MS Word?
28. What are footnote, captions, cross reference, index and table? And how to insert it on a document? How to use it?
29. You want to create a resume or other documents and you don’t know its format. What MS Word utilities or features will you use to create the document without worrying its format? Kindly give 2 answers.
30. Types of file that you can save with MSWord.
31. How to print a document?

How to Be Happy

Nobody is happy all the time, but some people are definitely more fulfilled than others, and it doesn't seem to have much to do with material goods or high achievement---things many people spend a lot of their time worrying about. So what do they have that you don't?


HERE ARE THE STEPS THAT WILL HELP YOU ATTAIN HAPPINESS:

1. Relax. Lighten up. Don't take yourself too seriously. Try not to over analyze things. Stress can cause many mental, physical, and spiritual problems in your life. One of the major causes of stress is worrying about things that are out of your control. Learn to recognize these things and if you can truly do nothing about them, then just let them go. Take time to laugh at yourself and the situations you find yourself in. Laughter is a powerful, positive medicine and the calmer and more peaceful you can take things, the happier your life will be. It wouldn't be life if some bad things don't happen.
   
2. Take the good with the bad. No one is happy all the time. Everyone has something of sorrow intermingled with the gladness of life. The trick is to make the laughter outweigh the tears. We cannot change the past, but we can enjoy today, and look to the future. If we are prepared to take ownership for the past and accept that everything that's happened in our life, good and bad, has made us the person we are - the battle is half won.
   
3. Be thankful. A key component of happiness is acceptance - learning to be grateful for what you have. A lot of people know it but don't keep it in their minds. Comparing your life with others' is dangerous. Accept the gifts you have and know that no one is better than or less than anyone else's. Keep a "gratitude journal". Every day, write down a few things that you are thankful for and then review what you have written in past entries. It's a great way to remind yourself to be thankful for what you have and to boost your mood.
   
4. Be yourself. Much criticism is caused by people who are discontented with themselves, not with you. One way to get in touch with yourself is through journaling, diaries or (lately) blogs. Your goal may be to open up completely to yourself and learn to be your own best friend by being completely honest with yourself. What do you want out of life? What makes you truly happy? Who do you want to be?
   
5. Pursue goals that make you happy. Strive for long term goals rather than short term satisfaction. It's very easy to gain short term satisfaction--a quick high, a fast relief from your current problems (such as drugs, alcohol, sex). But it is what it is, a "short term" satisfaction, and the effects die out very soon, leaving you with an empty feeling that is sometimes worse than before. Set long term goals, goals which take time, thought, and effort to achieve. This will make you continually work towards improving yourself bit by bit and will give you the satisfaction of bringing a permanent change in your life.
   
6. Focus on the Objective. If the thoughts you are thinking are not giving you that 'good feeling', then think about something else that will make you feel good in that moment. Observe your thoughts and ideas consistently throughout the day (diary/journal if possible). Sometimes this may not be as easy as you think if you are stuck in a "destructive" train of thought and your brain chemicals are getting fired up and forming "anxiety or anger" thoughts. Anxiety, fear and anger patterns can be interrupted by focusing on something else. This will dissipate the rush of chemicals that are making you feel bad. Immediately then go back to picturing scenes/remembering things/imagining, planning stuff that makes you feel good.
   
7. Develop healthy relationships.
   
• Family. If you want a stronger relationship with your family, you're going to need to be honest with them. Tell your family about your life and don't insult them - it hurts them just as much as it hurts you to be insulted. If you are in an abusive family, you must find a way to stop the abuse and that may include separation.
• Have a healthy relationship. If you're dating, get involved with activities that reflect who you are, and get to know people who like the things you do. Get involved with someone who loves life and pursues happiness the way you do. If you're in a relationship, strive to make that relationship healthy.
• Choose your friends carefully. Nearly everyone needs someone who cares for them and treats them well. If you have friends who are treating you badly, or are not supportive of you and your goals to improve your life, then ditch them and find friends that do care about you. If you can't find any friends like that in your current circumstances, then look elsewhere. If you're feeling sad, there's nothing like going out with your friends to make you feel better. Surround yourself with friends who are beneficial, encouraging, and helpful. We all need this continuing, nurturing encouragement to make solid desired progress in life.
8. Make someone else happy. When you're feeling powerless to create happiness in your life, do something to make someone else--anyone--happy, and you'll remember how easy it really can be. Isn't it true the happiest people we know are typically the ones who for some foolish reason are always ready to give you the clothes off their back? And frequently it is true that the most discontented people are the ones who are selfish, demanding, and inconsiderate of others. The happiest days of our lives, when we really dig down deep, is when we see the smile on the face of a person who we care about. Even helping a stranger can remind you of how much you really have, because of how much you can give. Serve at a rescue mission and you will learn the meaning of "I cried because I had no shoes and then I met a man who had no feet."

TIPS:

• Try thinking of a creative vow and write it down. Make it something like: I vow to give at least one compliment to someone each day and I'll try to control my anger by counting in my head before reacting.

WARNINGS:

• Happiness requires balance. Don't become so caught up in your own happiness that you forget about everyone else's. And don't base your own happiness on making others feel good; people-pleasers are usually very unhappy on the whole.
• Even in the most terrible times, do not turn to alcohol, drugs, or anything else that is addictive, abusive to the health of you or others. Bad habits grow like weeds - they are easy to get, but hard to get rid of. Many addictive "solutions" can make your problems much worse.

HOW TO EMBED A FLASH FILE

Step 1: Open/Customize your blog's layout.

Step 2: Add a page element.

Step 3: Select the HTML/JavaScript page element and add to your blog.

Step 3: Copy the code below and paste it to the Configure HTML/JavaScript dialog box.

<br /><embed pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" quality="high" allowscriptaccess="always" flashvars="file=playlist.xml&autostart=true" type="application/x-shockwave-flash" src="type the url of your flash file here" allowfullscreen="true" height="size" width="size"></embed><br/>

Sample:



Step 4: Click Save button.

USE E-MAIL AND SEARCH THE WEB USING BROWSERS

INSTRUCTION:

1. Change the homepage to “ilovegod.com”.
2. Visit a website using search engine having a topic about “Management Information System”.
3. Bookmark any website that sells computer parts/devices and the searched website having the topic about “Management Information System”.
4. Reply any message on your inbox and cc to me (gemcat_the_peacemaker@yahoo.com) use automatic signature and bcc to anyone on your contact list.
5. Send an email to me (gemcat_the_peacemaker@yahoo.com) with attached files that you have been made on MS Word, MS Excel and MS PowerPoint and the topic that you had search with a subject of “My Final Assessment Exam” and do not put a signature on it.
6. Put any message and check the spellings of your message.
7. Sort your Inbox by date.
8. Add contact on your address book.

Fist name: Peter

Last name: Parker

E-mail Add.: peterparker@yahoo.com.ph

9. Add any website in favorites.

OPERATE A PRESENTATION PACKAGE

INSTRUCTION

1. Create a presentation that contains 10 slides and apply a footer using the master slide. The footer should be the name of your company. Set all the font faces to Arial, for the title the font size is 30 and font size 24 for the subtitle.

2. In slide 1, the title is your name and put anything in your subtitle.

3. Next slide must contain a picture of a computer and describe it on the other side of the picture and provide a title.

4. The following slide must contain the title of the assessment that you’re taking and the core units of competencies. The core units of competencies must be in bulleted form.

5. Make your organizational chart to the next slide.

6. Put the chart that you have created in MS Excel in the next slide.

7. Next slide must contain about your comment with regards to the assessment exam.

8. Make a marketing income of your company versus other company in one of your slide.

9. Be sure that you created a table and a chart.

10. Put in one slide the mission, vision and services or products of your company.

11. Last slide must contain the word “Thank You and God bless” with and apply an animation on it.

12. Save your presentation as “My Presentation” on your folder.

OPERATE A SPREADSHEET APPLICATION

INSTRUCTION:

1. Create a worksheet exactly as shown in the example as well as its formats under the filename of “MyExcel”.
2. Rename the worksheet as Sales Revenue Report.
3. The amount of Furniture has a constant value of 13,500 in every month.
4. The amount of Garments increases 2% in every month.
5. The amount of Kitchenware doubles the value on the next month.
6. The Sales discount will be 12% of the sum of Furniture, Garments and Kitchenware in each month.
7. Gross sales will be the sum of Furniture, garments and Kitchenware deducted by sales discount.
8. In the expenses, copy the values as shown in the example.
9. Compute for the total expenses which are the sum of the expenses of each month.
10. The Gross profit of a month will be gross sales deducted by the total expenses.
11. The cumulative profit (loss) of a month will be the gross profit of the month plus the cumulative profit of the previous month.
12. If the accumulative profit is less than zero (0), the font color will change into red.
13. Compute for the total or the sum of Furniture, Garments, Kitchenware, sales discount, gross sales, the expenses, total expenses and the gross profit.
14. The headers on the first month up to the last month should have a yellow color and the total should be blue with double underlined at the bottom using borders.
15. Put a Light Turquoise fill color on the totals cells.
16. Create a bar chart for the Furniture, Garments and Kitchenware from the first month up to the last month and put it on another sheet.

Note:

The values of Furniture, Garments and Kitchenware from the first up to the last month must display on the chart.

Sample:

Click the image to zoom...

OPERATE A WORD-PROCESSING APPLICATION

Instruction:

1. Create the given business letter.
2. For the margins: all the margins should be 1".
3. Paper size: A4
4. Font sizes must be 11pts
5. Use the Trebuchet font.
6. Add header and footer for your letter and insert logo or picture, put your company name and mailing address as a header and your company’s motto as a footer. You can use any picture you want for the logo.
7. Paragraph spacing between paragraphs should be 11 points.
8. Paragraph alignments should be justified.
9. Paragraph style on the body of the letter should be Body text.
10. For the numbered list , change the style to MyList, Bullet position: Indent at= .5 ; Text position: tab space after= .75; indent at=.35
11. Save the document as “MyWord” on your folder.

Sample letter:

16 December 2006

Mr. John Cruz

Manager
Mine Company
87 Delaware Road
Hatfield, CA 08065

(082) 123-456

Dear Mr. Cruz,

I am writing to apply for the programmer position advertised in the television. As requested, I am enclosing a completed job application, my certification, my resume and three references.

The opportunity presented in this listing is very interesting, and I believe that my strong technical experience and education will make me a very competitive candidate for this position. The key strengths that I possess for success in this position include:

· I have successfully designed, developed, and supported live use applications

· I strive for continued excellence

· I provide exceptional contributions to customer service for all customers

With a BS degree in Computer Programming, I have a full understanding of the full life cycle of a software development project.

I also have experience in learning and excelling at new technologies as needed.

Please see my resume for additional information on my experience.

I can be reached anytime via my cell phone, 0919-1216060. Thank you for your time and consideration. I look forward to speaking with you about this employment opportunity.

Sincerely,

[Put your signature here]

[FirstName LastName]

Just a reminder

Good day guys...

Kindly finish answering all the items in a particular part of the assessment exam before you post your comment.

Note:

1. Pls. post your comment on my blog not just only on yours.
2. Kindly put your name/s after you've answered so that I can easily check who is posting the answers.
3. Kindly post your answers until this day only (July 21, 2008). You may use the school computer laboratories provided that the instructor who is having a class on the laboratory will allow you to use. Naay internet cafe! Gamita pud ninyo ug tarung ui! ayaw cg ug friendster2x! hehehe Seriously kindly finished your assessment exam within this day.
4. Just always take good care of yourself and always pray to God for His guidance... Au2x pirmi...

Best,

Gemar B Cacatian

Preassessment Part 5 (Use e-mail and search the web using browsers)

1. What is internet?
2. What is the use of internet?
3. Give examples of information you can get in the net.
4. What are the requirements in order to have internet connection on your personal computer?
5. What are those internet connections?
6. What is ISP?
7. What are the other services does the ISP rendered?
8. What is a web browser?
9. Give at least 3 examples of web browser.
10. How to change the default homepage?
11. What are the uses of internet options?
12. What is URL or web address and what it is use for?
13. Give at least 3 examples of URLs.
14. What is a search engine? Give at least 4 examples of it.
15. How to establish links to a certain websites?
16. What is favorites and bookmark? What are their differences?
17. Discuss what is CC and BCC in sending an e-mail.
18. What will happen to the e-mail messages send by a sender if the inbox of the receiver is full?
19. What if you have sent an e-mail to a wrong address? What will happen?
20. Can you print the content of the webpage? How?

Preassessment Part 4 (Presentation package)

1. What is Presentation package?
2. What is the use of MS PowerPoint in the business?
3. What are the procedures in creating slide master?
4. How to rearrange the arrangement of slides in a presentation?
5. How to add animation to your slide presentation?
6. How many ways you can apply animation in your presentation?
7. How to insert and format picture in your slide?
8. How to insert and format table in your slide?
9. How to insert and format chart in your slide?
10. How to insert and format an organizational chart?
11. How to standardized the format of your presentation?
12. How to print a presentation?

Preassessment Part 3 (Speadsheet Application)

1. What is Spreadsheet application?
2. What is the use of MS Excel in the business?
3. What command will you use to change the page layout and the format of the sheets of a workbook?
4. What is circular reference? And kindly give an example of circular reference.
5. How could you identify if the sheet suffers from circular reference?
6. How to locate the circular reference?
7. How to identify if the result of a formula that you made is correct?
8. How to display the content of a certain cell to another cell? What if it is from other sheet? For example content of a cell on sheet2 to sheet1.
9. What are the Excel worksheet functions that you can use in MS Excel?
10. Give at least 10 types of charts that are used in MS Excel.
11. Give 4 types of charts that could be used to plot two dimensional tables see for example a chart use to plot a certain country against their population.
12. How to insert/format charts?
13. How to print a workbook?

Preassessment Part 2 (Word Processing)

1. What is Word Processing?
2. What is the use of MS Word in the business?
3. What is Mail Merge?
4. What is the use of Mail Merge? Give examples.
5. Is there a way to standardize the format of your MS Word document? How? Kindly give at least 2 answers.
6. How to correct the spelling and grammar of a document?
7. How to change the case of a text of a document?
8. What objects can you insert on MSWord?
9. What is the procedure in inserting/creating object from other application to MSWord?
10. Can you work using Paint inside the MS Word? What are the steps?
11. What will you do if you want to remove a portion of a picture and you have no access to software for photo editing?
12. How to change the paper size and the margins of a document?
13. How to insert and format bullets and numbering lists on a document?
14. How to insert and format diagrams on document?
15. What is a Drop Cap and how to format a Drop Cap?
16. How columns are are made on a document?
17. How to insert and format table on document?
18. How to convert paragraph of text to table?
19. How to convert table to text?
20. How to use breaks (Page break, Column break, Text wrapping break)?
21. How to insert and format page numbers?
22. What kind of printer to use in printing your document in MS Word?
23. What will you do in your new printer in order to be use in printing a document in MS Word?
24. What are footnote, captions, cross reference, index and table? And how to insert it on a document? How to use it?
25. You want to create a resume or other documents and you don’t know its format. What MS Word utilities or features will you use to create the document without worrying its format? Kindly give 2 answers.
26. Types of file that you can save with MSWord.
27. How to print a document?

Preassessment Part 1 (General Knowledge)

Good day guys! Answer the following questions correctly. Give your best shots in answering the questions. Good luck, have a great day and God bless us all...

1. Give at least 5 different filename extensions.
2. What will you do if you have newly installed software, then you don’t know how to use it? Give 3 answers.
3. What are the safety precautions in order to prevent document loss in case of power interruption?
4. Ways in restricting your files from unauthorized access.
5. Ways in transferring content from one application to another.
6. Ways in viewing the toolbars of an application.
7. What are the types of printers?
8. How to install/configure a printer?
9. What is a folder? What are the steps in creating a folder?