2_Q1-Emp-Technology.pptxICT Projects for Social Change

ICT Projects for Social Change

1. Empowerment Technologies Contextualized Online Search and Research Skills and Developing ICT Content for Specific Purposes

2. Multiple Choice : Choose the letter of the correct answer and write it on a separate sheet of paper. 1. What feature of Microsoft Word allows you to efficiently create documents that have the same general content but may have different recipients or purpose? A. mail merge C. send merge B. print merge D. view merge 2. Which of the following is not a component of the mail merge? A. address C. file name B. data file D. form document 3. Where can you find the Start Mail Merge button? A. file tab C. mailings tab B. home tab D. references tab

3. 4. What types of documents can you create using mail merge? A. envelopes C. letters B. labels D. posters 5. What button allows you to see the result of your mail merge even before you print or send it out? A. address block C. insert merge field B. field greeting line D. preview results 6. What program designed to create spreadsheets which can later be used to analyze statistical data? A. Microsoft Excel C. Microsoft Publisher B. Microsoft One Note D. Microsoft Word

4. 7. Which of the following number formats puts a dollar symbol before each value by default? A. accounting C. date/time B. comma D. percent 8. What function adds a range of cells? A. ADD C. SUM B. PLUS D. TOTAL 9. Which tab in the Format Cells dialog box where you can change the orientation of a text.? A. alignment C. orientation B. file D. view 10. What function that gets the average of a range ofcells ? A. AVERAGE C. MEDIAN B. MEAN D. SUM

5. Contextualized Online Search and Research Skills

6. Most teenagers like you, spend time online therefore, it is very important to consider what type of information you are to share because internet is a public place. What tips you can give to online users for them to be safe and protected? What do you mean by “think before you click”?

7. Are you a smarter user of search engines such as Google and Yahoo? Do you always rely on the first search results online? Have you ever searched the internet for certain information where the search engine returned a different result? For example, if you were to search for “The Madonna” as the representation of Mary in the form of an art, you would probably use the keyword “Madonna” to search for it on the net. But if you use that same keyword nowadays, you are more likely to stumble upon “Madonna”, the music artist instead. And if you used “The Madonna” to search for “The Madonna” in the first place, you will be directed in the right place.

8. Online Research The information that we need is more likely already in the internet. It is just a matter of how to look for it and how to use information from the most credible source.

9. Tips in Conducting Online Research 1. Have a question in mind . Focus on a question you want answered. 2. Narrow it down . Search engines like Google, Bing, or Yahoo use several filters to determine the most appropriate result for you. These search engines use your previous search history and geographical location then, send you the result which is the most related to you. For example, if you were to look for Tom Sawyer, the animation series, you would better use the keywords “Tom Sawyer animation” rather than just “Tom Sawyer”. 3. Advanced Search . This is the best way to filter information you get from search engines allowing you to filter out information you do not need. In Google, simply search a word like you would normally do, then click the advanced search option on the setting options button located at the upper right corner of the page. Once you are done you can now filter your search results.

10. 4. Look for a credible source . Credible sources maybe scientific journals, established news and magazine websites, online encyclopedias, and scholarly databases. 5. Give credit . If you are going to use the information from a source for educational purposes, give credit to the original author of the page or information. Example: Lapiz , Adrian Harold L. “Oleander’s Fun Facts about Bananas”. http://oleander.penz.com/random/bananalove.htm. Viewed on September 7, 2015.

11. True or False . Write True if the statement is correct and False if it is not. Place the answer on a separate sheet of paper. 1. Search engines use your previous search history and geographical location then, send the result which is the most related to you. 2. The best way to filter information from search engines is by default. 3. Internet has all the information we need. We just must look and use information from the most credible source. 4. Wikis are credible source of information even if anyone can edit its content. 5. Give credit to the original author of the information if you are going to use it for educational purposes.

12. Elaborate or expound the statement in a paragraph form with a maximum of 5 sentences and write the answer on a separate sheet of paper. I have learned that when researching online, I have to remember to ________________________________________________________________________ ________________________________________________________________________ __________________________________________________.

13. Advanced Word Processing Skills

14. In this lesson, you will explore some features of Microsoft Word necessary for mail merge and label generation and integrating images and external materials to your document. It is designed for you to create form letters or documents to various recipients, labels and envelopes for distribution and media-rich documents for printing or publishing.

15. What are the things to consider in conducting online research?

16. Read the following scenarios and describe briefly what is being asked. Write your answers on a separate sheet of paper. Scenario 1 : You were tasked to create and send out formal invitations for the 18 th birthday party of your younger sister. You were also initially given a list of twenty names of her close friends to send to. Task : Describe briefly how you would most likely complete the task of sending twenty invitations with individual names of recipients using Microsoft Word.

17. Scenario 2 : You are making a report on the effects of COVID-19 on person’s mental health. To make your report more appealing, you thought of putting a picture of the disease into your report. You also considered presenting graphical data on the trends of COVID-19 cases in Cebu City. Task : Describe briefly how you can insert pictures or images in a Word Document.

18. In the professional world, sending out information to convey important information is vital. Because of ICT, things are now sent much faster than the traditional newsletters or postal mail. You can now use the internet to send out information you need to share much faster.

19. Mail Merge and Label Generation Mail Merge is one of the most powerful and commonly used features of Microsoft Word. It allows you to create documents and merge them with another document. It is commonly used when sending out advertising materials to various recipients.

20. Two components of Mail Merge 1. Form Document is the first component of our mail merged document that contains the main body of the message we want to convey or send. • Place holders are data fields or merge fields which marks the position on your form document where individual data or information will be inserted and are denoted by the text with double-headed arrows (<< >>) on each side.

21. 2. List or Data File . This is where the individual information or data that needs to be plugged in (merged) to the form document is placed and maintained.

22. Steps in Creating a Simple Mail Merge: 1. Open Microsoft Word and start a new blank document. You can use the keyboard shortcut Ctrl+ N after Microsoft Word has been loaded or opened.

23. 2. On the Mailings tab, from the Start Mail Merge group, choose Start Mail Merge → Letters. Type the letter below. You’ll be typing in only the common parts of the letter. The text does not change for each copy you print. 3. Save your letter and name it “Sample Letter”. 4. Insert the fields you need in the letter (Name, Company, Address Line 1, Address Line 2, Address Line 3, and the Title.)

24. 5. Save the main document once more. 6. On the Mailings tab in the Start Mail Merge group, choose Select Recipients then, Type a New List. 7. Click the customize Columns button on the dialog box for the New Address List.

25. 8. Select a field that you do not need then click the Delete button. A confirmation dialog box appears. 9. Click Yes in the confirmation dialog box. The dialog box closes, and the unnecessary field disappears. 10.Repeat Steps 8 and 9 for each field you do not need. After removing the excess fields, the next step is to add the fields you need.

26. 11.To add a field that you need in your document, click the Add button. 12.Type the field name on the prompt inside a small Add Field dialog box and click the Ok button.

27. 13.Repeat Steps 11 and 12 for each new field you need in your main document. 14.Click the OK button on the Customize Address List dialog box to confirm your changes. 15.The New Address List dialog box will appear again ready for you to type in your data.

28. 16.Type the individual data from your list corresponding to Name, Company, Address Line 1, Address Line 2, Address Line 3 and Title. 17.Press the Tab key each time to enter the next field. 18.To add a new record, press the Tab key on the last field in a record, a new record is automatically created and added on the next line. 19.Repeat Steps 16 through 18 until you enter all the records you want. Once you are done typing your data, click the OK button on the Add New List dialog box to save your data. A special Save Address List dialog box pops up, allowing you to save the recipient list.

29. 20.Type a name for the address list. Name it “Client List”. 21.Click the Save button. You should be back on your main document soon after. 22.Select a field placeholder (ALL CAPS) in the main document.

30. 23.Click the Insert Merge Field command button. 24.Choose the proper field to insert into your text. For example, if you are replacing the text name in your document with a name field, choose the Name Field from the Insert Merge Field menu. The field is inserted into your document and replaces the ALL CAPS text. 25.Continue adding fields until the document is complete. Repeat steps 22 through 24 as necessary to stick all fields into your document. 26.Save the main document.

31. 27.Choose Finish & Merge to edit, print, or send your merged documents through email. 28.Or you may want to choose Preview Results to check your work before you send it. 29.Save and close your document.

32. Integrating Images and External Materials Inserting pictures in your document like creating a resume improves the impression of it. Though seemingly simple to do, your knowledge on the different kinds of materials that you can insert in a Word document and its characteristics can help you create a more efficient, richer document not only in content but also in physical form.

33. A. Kinds of Materials There are various kinds of materials Microsoft Word can integrate to make the documents richer, more impressive, and more informative. 1. Pictures . These are electronic or digital pictures or photographs you have saved in any local storage device. a. .JPG/JPEG. This is the short form of Joint Photographic Experts Group. It identifies the kind of data compression process that it uses to make it more compatible and portable through the Internet. b. .GIF . This stands for Graphics Interchange Format which can display transparencies good for blending with other materials in your document and can display simple animation c. .PNG . It stands for Portable Network Graphics built around the capabilities of .GIF for the purpose of transporting images on the Internet at faster rates but does not support animation.

34. 2. Clip Art . This is generally a .GIF type; line art drawings or images used as generic representation for ideas and objects that you might want to integrate in your document.

35. 3. Shapes . These are printable objects or materials that you can integrate in your document to allow you to have some tools to use for composing and representing ideas.

36. 4. Smart Art . These are predefined sets of different shapes grouped together to form ideas that are organizational in nature.

37. 5 . Chart . It allows you to represent data characteristics and trends in a graphical manner.

38. 6. Screenshot . A more realistic image to integrate in creating reports or manuals.

39. Image Placement Inserting images into your document seems quite easy but the challenge is where to place or move it. You will now study the different characteristics of text wrapping options that you can use with the image you integrated in your document.

40. In Line with Text . It treats your image like a text font with the bottom side totally aligned with the text line and is used when you need to place your image at the beginning of a paragraph. Example: The rose is a type of flowering shrub. Its name comes from the Latin word Rosa. The flowers of the rose grow in many different colors, f rom the well-known red rose or yellow roses and sometimes white or p urple roses.

41. 2. Square. This allows the inserted image to be placed anywhere within the paragraph with the text going around the image in a square pattern like frame. Example: The rose is a type of flowering shrub. Its name comes from the Latin word Rosa. The f lowers of the rose grow in many different colors, from the well-known red rose or yellow roses and sometimes white or purple roses.

42. 3. Tight . This is almost like the Square setting where the text “hug” or conforms to the general shape of the image. Example: The rose is a type of flowering shrub. Its name comes from the Latin word Rosa. The flowers of the rose grow in many different colors, f rom the well- known red rose or yellow roses and sometimes white or p urple roses.

43. 4. Through . This allows the text on your document to flow even tighter taking the contours and shape of the image. Example : The rose is a type of flowering shrub. Its name comes from the Latin word Rosa. The flowers of the rose grow in many different colors, from the well-known red rose or yellow roses and sometimes white or purple roses.

44. 5. Top and Bottom . This pushes the texts away vertically to the top and/or the bottom of the image so that the image occupies a whole text line on its own. Example: The rose is a type of flowering shrub. Its name comes from the Latin word Rosa. The flowers of the rose grow in many different colors, f rom the well-known red rose or yellow roses and sometimes white or p urple roses.

45. 6. Behind Text . It allows the image to be dragged and placed anywhere on your document but with all the texts floating in front of it. Example: The rose is a type of flowering. Its name comes from the Latin word Rosa. The flowers of the rose grow in many different colors, from the well-known red rose or yellow roses and sometimes white or purple roses.

46. 7. In Front of Text . This allows your image to be placed right on top of the text as if your image was dropped right on it. Example: The rose is a type of flowering. Its name comes from the Latin word Rosa. The flowers of the rose grow in many different colors, from the well-known red rose or yellow roses and sometimes white or purple roses.

47. Complete the table below. Write your answer on a separate sheet of paper. MICROSOFT WORD Features Description 1.   2.  

48. Advanced Spreadsheet Skills

49. This lesson is designed for you to familiarize Microsoft Excel.

50. What features of Microsoft Word do you think will be of great help to you in your chosen future career?

51. Are you familiar with this logo? What features of Microsoft Excel you are acquainted with?

52. Whether you work in the field of accounting or not, the truth is whatever you do should be accounted for because the resources you use cost you expenses. Whether what work you will have in the future, it is important to understand how a company spends to be able to deliver a product or service. These factors could easily be computed using spreadsheet programs. Spreadsheet Software allows users to organize data in rows and columns and perform calculations on the data. These rows and columns collectively are called worksheet. Examples of Spreadsheet

53. To open Microsoft Excel, Press “Windows Logo” + R then type “excel” then enter. Key Terms in MS Excel: 1. Row is the horizontal line of entries in a table. 2. Column is the vertical line of entries in a table. 3. Cell is the place where information is held in a spreadsheet. 4. Spreadsheets consist of several individual sheets; each sheet containing cells is arranged in rows and columns. 5. Active Cell is the selected cell.

54. 6. Column Heading is the box at the top of each column containing a letter. 7. Row Heading is the row number. 8. Cell Reference is the cell address of the cell usually combine letter and number (ex. A1, B4, C2). 9. Merge is combining or joining two or more cells. 10. Formula is an expression which calculates the value of a cell. 11. Functions – are predefined formulas and are already available in Excel. 12. Formula Bar is the bar that displays the contents of a cell.

55. Other terms: 1. Accounting Number Format – a number format that is used for accounting. 2. Orientation – the angle at which a text is displayed. 3. Count – a function used to count the cells with content in a range. 4. Sum – a function used to compute for the summation of the number of a range. 5. Average – a function used to compute for the average of the number of a range.

56. 6. COUNTIF – a function used to count the cells with a specified content within a range. 7. SUMIF – a function used to compute for the summation of a range if a certain condition is met. 8. AVERAGEIF – a function used to compute for the average of a range if a certain condition is met. 9. Range – the range of cells where you want to look for the criteria. 10. Criteria – a value or label that determines if a cell is part of the range to be averaged. 11. Average Range – the actual range of cells that will be averaged, if omitted, the range will be used instead. 12. =MIN(range) – returns the smallest number within the range. 13. =MAX(range) – returns the largest number within the range.

57. Exploring Microsoft Excel A. Open Microsoft Excel and create a spreadsheet file named “ MyExcel _(type your last name)”. Using the worksheet sheet1, go to cell B1 and enter the data as shown below. You should be able to enter the value for Quantity, Purchase Price, Retail Price, Price, and Profit. Remember that: a. Quantity is the number of purchased items. b. Purchase Price is the cost of item from supplier. c. Retail Price is the selling price in the market. d. Price is the sub-total per item obtained by computing the product of Quantity and Retail Price. e. Profit is the difference between Purchase Price and Retail Price multiplied by Quantity. Required: (Always start the formula with “=” sign) Example: =C2*E2

58. 3. Fill in the table above by computing for the a. Price =C2*E2 press “enter” =C3*E3 press “enter” =C4*E4 press “enter” =C5*E5 press “enter” =C6*E6 press “enter” b. Profit =(E2-D2)*C2 press “enter” =(E3-D3)*C3 press “enter” =(E4-D4)*C4 press “enter” =(E5-D5)*C5 press “enter” =(E6-D6)*C6 press “enter” c. In cell C7, compute for the sum of all the items sold; =SUM(C2:C6) press “enter”. d. In cell C9, compute for the 12% of the Total Price; =(SUM(F2:F6)*0.12) press “enter”. e. In cell C8, compute for the difference of the Total Price and the 12% Vat; =(SUM(F2:F6)-C9) press “enter”. f. In cell C10, compute for the sum of sub-total and 12% Vat; =SUM(C8:G9) press “enter”. g. In cell C11, compute for the sum of all the profits earned; =SUM(G2:G6) press “enter”. h. Save the file.

59. 4. Copy the given table above with your answers on a separate sheet of paper or you may take screen shot and submit it to your teacher.

60. What I Have Learned Fill in the missing letters to get the desired term. Write your answer on a separate sheet of paper. 1. It provides an automated way of displaying any statistical data. M _ _ r _ _ _ _ t E _ _ e l 2. It is combining or joining two or more cells. _ e _ g _ 3. Predefined formulas and are already available in Excel. F _ _ _ t _ _ _ s 4. An example of a spreadsheet software. G _ _ g _ e S _ e _ _ s 5. These are rows and columns in a Microsoft Excel. W _ _ _ s h _ _ t _

61. For learners with computer at home, you may do these: 1. Create a simple mail merge document following the steps presented in lesson 2. 2. Integrate images and external materials to your word document. Download the following files through the following links or URLs and save them on your Desktop: • Solar.jpg-http://1drv.ms/1mvv5KG • Joe.png-http://1drv.ms/1mvvbl7 • Sample letter.doc-http://1drv.ms/1mvvKLP

62. Steps a. Open the Sample Letter.docx from your desktop. b. Place your insertion point or cursor to where you want the image or picture to appear. c. Go to the illustrations group under the Insert tab on the ribbon or menu. d. Click on Picture, then Insert Picture from File. e. The Insert Picture dialog box will pop up almost like your file explorer window. Navigate your Desktop and click on the Solar.jpg file. f. Click the Insert button to insert a copy of the Solar.jpg picture on your document.

63. g. Right-click on the image then click on the Wrap Text sub-menu. On the fly out, click on the Square option. h. Drag your image to the desired location on the document. i . Repeats steps 2 through 6. Place the insertion point at the very end of the document and insert the Joe.png image. j. Right-click on the image then click on the Wrap Text sub-menu. On the fly out, click on the Behind Text option. k. Now to insert chart on your document, place your insertion point or cursor on the position where you want the chart to appear.

64. l. In the Illustrations group under the Insert tab, click on Chart. m. On the right pane, inside the Insert Chart dialog box, scroll down to the Pie row, and select Exploded Pie in 3D. n. An Excel worksheet will pop up showing the default data that Microsoft Word uses for the chart. Modify the data by changing “Sales” to “Volume” and the labels 1st to 4th QTR to “Europe”, “America”, “Middle East”, and “Asia” respectively. o. Drag the chart’s corner handle to suitable size. p. Click on the chart’s Text Wrap option and select Top and Bottom. q. Drag the chart to the center of the page in between the third and fourth paragraph of your document. r. Save your document.

65. 3. Send your output via any platform available or take a screenshot and send it to your teacher through messenger.

66. For learners without computer at home, do this: 1. On a short size bondpaper , create a simple flow chart that summarizes the steps in creating a merge document. Insert objects/pictures in your chart by drawing it manually. Be creative in your presentation. Your teacher shall rate your output using the rubric below. Category Exemplary 4 Accomplished 3 Developing 2 Beginning 1 Content The output exceeds the expectations The output is complete. The output is somewhat complete. The output is incomplete. Attractiveness The flow chart is exceptionally attractive in terms of design, layout, and neatness. The flow chart is attractive in terms of design, layout, and neatness. The flow chart is acceptably attractive though it may be a bit messy. The flow chart is distractingly messy or very poorly designed. It is not attractive.