Empowerment Technology Week 3-4, Summaries of Technology

Download Empowerment Technology Week 3-4 and more Summaries Technology in PDF only on Docsity! DEPARTMENT OF EDUCATION CITY SCHOOLS DIVISION OF MALOLOS MARCELO H. DEL PILAR NATIONAL HIGH SCHOOL CITY OF MALOLOS, BULACAN S.Y. 2020 – 2021 SECOND SEMESTER LEARNING ACTIVITY SHEET IN EMPOWERMENT TECHNOLOGIES QUARTER 3 WEEK 3: ADVANCED WORD PROCESSING SKILLS In a professional world, sending out information for dissemination is very vital. With the use of ICT, things can be easily and quickly put across rapidly than the traditional newsletter or postal mail. Internet can aid to send the letter in an instant. This activity sheet will show you how a letter can be made using Microsoft Word – an automated way of doing it and even sending it to many designated recipients. PLEASE DO THE FOLLOWING TASKS BELOW BECAUSE YOU WILL BE NEEDING THEM DURING THE ONLINE DISCUSSION. SCENARIO 1 : You are tasked to send a formal letter of invitation for a promo campaign of a company. TASK 1: Prepare a list of 10(ten) names of loyal customers for this letter to send out. Below is a format/sample of the customer information you need. TASK 2: Make an invitation letter that you can personalize, send, and distribute. Refer to the sample below. Scenario 2: Get a topic from an old newspaper or an article online which discusses about Climate Change in the Philippines or environmental issues. TASK 1: Make a summary of the topic/ article TASK 2: Provide a sample picture that you can insert in your report. TASK 3: You will also need to research and present a graphical data about the article. MAIL MERGE AND LABEL GENERATION This module will allow you to learn one of the most convenient and commonly used features of Microsoft Word called “Mail Merge”. You will create documents and combine or merge them in another document or data file. It is commonly used when sending out advertising materials to various recipients. TWO COMPONENTS OF MAIL MERGE 1. Form Document ✓ The document that contains the main body of the message we want to convey or send. ✓ The Place holders are also included in the form document which is also referred as data fields or merge fields. Reminder: The main body is the part of the document that remains the same no matter whom you’ll send it from the list. 2. List or Data File ✓ This is where individual component or data that needs to be plugged in (merged) to the form document is placed and maintained. ✓ One can easily add, remove, modify or extract data more efficiently by using other data management applications like Excel or Access and import them in word during the mail merge process. ADDITIONAL INFORMATION: Label generation is included in mail merge feature on Microsoft Word. You can maximize this feature when you need to send it to individual recipients in an envelope with the matching address printed directly on it and in a mailing label to stick upon. This is only used when physical copy of the letter is really needed. STEPS IN CREATING SIMPLE MAIL MERGE 1. Open Microsoft Word and start a new blank document. You can use the shortcut key Ctrl + N after Microsoft Word has been loaded or opened. 2. On the Mailings tab, from the Start Mail Merge group, choose Start Mail Merge -> Letters. 20. Type a name for the address list or customer records. Label it “Client List”. NOTE: Make sure to save your Client List inside the folder you created with your Sample Letter so that it will be easy for you to locate the files and revise when necessary. When you need to add more names or customer records. You can access your Client List, open it and add the data you need to add then save. It will automatically be included in the mail merge data. 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. 24. Click the Insert Merge Field command button. 25. 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. 26. Continue adding fields until the document is compete. Repeat steps 22 through 24 as necessary to stick all fields into your document. 27. Save the document. 28. You can choose Preview Results to check your work before you send. Click it again to get it back to return to merged fields. 29. Choose Finish & Merge to edit, print or send your merged documents through email. 30. You should get a merge document close to this one. 31. Since the total customer information inputted in the merged document is 10, same number of pages must be seen in your output. Save and close your document. INTEGRATING IMAGES AND EXTERNAL MATERIALS Integrating or inserting pictures in your document is fun and it improves the impression of your document. A common use of inserting a picture is when you create a resume. Knowledge in the different kinds of materials that you can insert or integrate 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. A better understanding of the physical form of your document as well as the different materials you integrate in it would allow you to be more efficient and versatile in using Microsoft Word. KIND OF MATERIALS There are various kinds of materials that Microsoft Word is capable of integrating in order to make you documents richer, more impressive and more informative The screenshot above shows the kind of materials that can be integrated or inserted in your Microsoft Word document. One important thing to remember is that images and other materials are not to be inserted as images for design purposes only, but they are used to enhance or improve the effectiveness of the message you want to convey. 1. Pictures. These are electronic or digital pictures or photographs you have saved in any local storage device. There are 3 most commonly used types of picture files. a. .JPG. Short for .jpeg or Joint Photographic Expert Group. It identifies the kind of data compression process that it uses to make it more compatible and portable through the internet. This image file can support 16.6 million colors making it suitable when working with full color photographic images. b. .GIF. This stands for Graphics Interchange Format. This image is capable of displaying transparencies. It is capable of displaying simple animation. It can only support up to 256 colors which is good for logos and decors with very limited or solid color. c. .PNG. This pronounce as “ping”. It stands for Portable Network Graphics. Its development was basically for the purpose of transporting images on the internet at fast rates. It does not support animation like .GIF. It can display up to about 16 million colors, so image quality for this image file type is also remarkably improved. 2. Clip Art. This is generally a.GIF type; line art drawings or images used as generic representation for ideas and objects that can be integrated in the document. Microsoft Word has a library of clip arts that is built in or can be downloaded freely. 3. Shapes. These are printable objects or materials that can be integrated in the document to enhance the appearance or to allow anyone to have some tools to use for composing and representing ideas of messages. 4. Smart Art. These are predefined sets of different shapes grouped together to form ideas that are organizational or structural in nature. It is used to graphically represent an organization, process relationship or flow for infographic documents. QUARTER 3 WEEK 4: ADVANCED SPREADSHEET SKILLS Whether you work in the field of accounting or not, whatever you do should be accounted for. This is because the resources you use cost you expenses. If you become a scientist, an engineer, a yoga instructor, a bartender or an airline pilot, it is important to understand how a company spends to be able to deliver products or services. These factors could easily be computed using spreadsheet programs like Microsoft Excel or Google Sheets. Let us start by forming a product or service that you can sell or offer around the campus. It can be sweets like polvoron or yema, small souvenirs like keychains or bag tags, or services like foot spa or harana (serenade) for hire. Add a personal twist to your product which could be something marketable to your target community. You may add malunggay to your polvoron. The keychain may contain caricature of the buyer. Also, you can create artworks and sell them as a product or service. On a sheet of paper, fill out the information of your product. A sample is shown below. Estimating the Product Cost Using Microsoft Excel Let us assume that we are going to sell milk tea with the following information. We will use Microsoft Excel to find out if our estimated sale price is reasonable considering the actual price of the ingredients. 1. Copy this information: Tips: To get the values with PHP or Philippine peso sign use the Accounting Number Format. You can use the shortcut key CTRL + 1 to show the Format Cells dialog box, click the Accounting in the category where you see options for the currency you need. The default currency is dollar symbol ($). To change this, click the drop-down arrow at the currency button then select More Accounting Formats, then change the symbol to PHP. To help you understand, how the SUM formula in Microsoft Excel works, this is the simple way to do it. You will get the sum of 100, 200 and 300 using the SUM function or formula. In cell F4, you type = (equal sign) then type SUM followed by open parenthesis, place or drag your computer mouse or cursor to cell C4 up to cell E4 then close parenthesis to end your formula then press enter. Your formula will look like this =SUM(C4:E4) as shown in the image. You will get 600 as your answer. In arithmetic calculation using your knowledge in General Mathematics, you are adding 100 + 200 + 300 = 600 but this time you will add it using Microsoft Excel application, you will use SUM as the formula or function to use in this case. Remember that when you add two addends, you call the answer SUM in mathematical sense. This closely related to our ongoing activity. Let’s try to use SUM function of Microsoft Excel in vertical image with a data inside it as shown below. How are you going to use it? Simply, in cell C6, type = (equal sign) then type SUM followed by open parenthesis, drag your computer mouse or cursor to cell C3 down to cell C5 then type close parenthesis and hit enter key. The answer will be 600. It is simply adding the range of cells with given values. The formula you created is =SUM(C3:C5). There must be no spaces in between these characters in any formulas that you use in Microsoft Excel. Otherwise, it will be a formula error. 2. Use the sum formula to get the summation of the values for C4 to C7. The SUM formula is =SUM(C4:C7). Type this on cell C8 as shown below: 3. Check if our estimated price will earn us profit. Type the additional format of information shown below then apply the arithmetic formula for subtraction. The formula now will be =C9-C8 or total minus estimated price. 4. The result if PHP 2.20. Our estimated price is not profitable. Let us make an adjustment. Include the information below and deduct the total from the New Sale Price. 5. The result is PHP 7.80. This is definitely profitable at this price. However, this does not guarantee our product’s success. 6. Save your file as Cost of Ingredients.xlsx. • To get the result of the average for quality based on the survey of the teachers, this is the formula used: =AVERAGEIF(E5:E19,"Teacher",F5:F19). This means that to get the average for student about quality, you will just replace the criteria “Teacher” to “Student”. The same steps apply to get the teacher average and student average for taste, presentation and product. You will need to follow the same formulation but this time just change the average range. Using Countif Formula The syntax is =countif(range,criteria). Using the =countif function will allow us to count the number of cells that contains something. However, in this case we will only count the ones that have YES in them. • To get the number of respondents who answered YES for satisfied, the formula is =COUNTIF(J5:J19,"yes") while for recommended, you will need to adjust the range to get it while the criteria is still the same. The same formula will be used to get the values for the prices by changing the range and the criteria from “yes” to “x” since x entails to the responses of the respondents in the survey made for the price options. The following are key terms that you need to understand: • Range – the range of cells where you want to look for the criteria. • Criteria – a value or label that determines if a cell is part of the range to be averaged or counted. • Average/count range (optional) – the actual range of the cells that will be averaged or counted, if omitted the range will be used instead. To make a generalization about the values in the table above. The result garnered for teacher average is 3.00, student average got 2.90 while combined average was 2.93 which will be our basis for interpretation, you can say that the presentation of the product needs improvement because it is below the average. REFERENCES: ❖ pp. 7 – 17, TVL Empowerment Technologies, Quarter 3 Module 6, Department of Education Division of Pasig City ❖ pp. 7 – 15, TVL Empowerment Technologies, Quarter 3 Module 7, Department of Education Division of Pasig City