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?