Empowerment Technologies, Exercises of Technology

Download Empowerment Technologies and more Exercises Technology in PDF only on Docsity! a DepED DEPARTMENT [fl OF EDUCATION Empowerment Technologies Quarter 1- Module 6: Imaging and Design for Visual Message Using Infographics CO_Q1_Empowerment Technologies SHS Module 6 Empowerment Technologies Alternative Delivery Mode Quarter 1- Module 6: Imaging and Design for Visual Message Using Infographics First Edition, 2020 Republic Act 8293, section 176 states that: No copyright shall subsist in any work of the Government of the Philippines. However, prior approval of the government agency or office wherein the work is created shall be necessary for exploitation of such work for profit. Such agency or office may, among other things, impose as a condition the payment of royalties. Borrowed materials (i.e., songs, stories, poems, pictures, photos, brand names, trademarks, etc.) included in this module are owned by their respective copyright holders. Every effort has been exerted to locate and seek permission to use these materials from their respective copyright owners. The publisher and authors do not represent nor claim ownership over them. Published by the Department of Education Secretary: Leonor Magtolis Briones Undersecretary: Diosdado M. San Antonio Development Team of the Module Writers: Kiel Ajello Z. Pecjo Editor: Lorena J. Mutas Reviewers: June Rose A. Estrada Illustrator: Kiel Ajello Z. Pecjo Layout Artist: Kiel Ajello Z. Pecjo Management Team: Malcom S. Garma, Director IV Genia V. Santos, CLMD Chief Dennis M. Mendoza, Regional EPS In Charge of LRMS Micah S. Pacheco, Regional ADM Coordinator Loida O. Balasa, CID Chief Grace R. Nieves, Division EPS In Charge of LRMS Lorena J. Mutas, Division ADM Coordinator Printed in the Philippines by Department of Education — National Capital Region Office Address: Misamis St., Bago Bantay, Quezon City Telefax: 02-929-0153 E-mail Address: depedncr@deped.gov.ph What I Need to Know This module was designed and written with you in mind. It is here to help you master the nature of computer. The scope of this module permits it to be used in many different learning situations. The language used recognizes the diverse vocabulary level of students. The lessons are arranged to follow the standard sequence of the course. But the orderin which you read them can be changed to correspond with the textbook you are now using. The module mainly focuses on one lesson: Lesson 1 - Principles of Visual Message Design Using Infographics Learning Competencies and Codes: 1. Use image manipulation techniques on existing images to change or enhance their current state to communicate a message for a specific purpose. CS_ICT11/12-ICTPT-Ie-f- After going through this module, you are expected to: 1. understand the infographics or similar graphs and its importance in showing information; 2. identify which infographic or graph is most appropriate for a particular set of information; and 3. create infographics or similar graphs using a spreadsheet application. CO_Q1_Empowerment Technologies SHS Module 6 & What I Know Directions: Choose the letter of the best answer. Write the chosen letter on a separate sheet of paper. 1. Which is an example of infographics? A. Graphics C. Pictures B. Illustration D. Charts and Graphs 2. Which of the following is considered most important in creating a table in excel? A. There must be a data table in excel. B. There must be a reason to use infographic. C. There must have PowerPoint installed. D. There must have an image ready for your infographic. 3. Which of the following is NOT the purpose of infographics in the presentation of data? A. It helps people interpret data visually. B. It engages audience in your presentation. C. It helps the presentation to be more visually attractive. D. It improves people understanding in data gathering. 4, Whichis the main use of line graph? A. To visually present the data. B. To see trend of data change. C. To compare difference between data. D. To show hierarchy between data sets. 5. Which should be done first in making a graph in excel? A. Inthe ribbon, click Insert > Charts. B. Press right click then click insert table. C. Select the drag cells needed for the chart. D. In the Insert tab click, Table then click the desired table. 6. Which chart is best used if you want to visually show the trend your data is suggesting? A. Pie Graph. C. Bar Graph B. Line Graph D. Radial Graph 7. Youwant to visually compare different data group to other data group, which graph should you use? A. Pie Graph. Cc. Bar Graph B. Line Graph D. Radial Graph 8. How do you rename the name of graph into “Graph 1” Microsoft Excel? A. Press right click then select rename, a window will appear then type “Graph 1”. B. Press Ctrl + A then Ctrl + R, rename the chart to “Graph 1” C. Double click the name of the chart and type “Graph 1”. D. Graph names can’t be changed as they follow the name from the selected data 2 CO_Q1_Empowerment Technologies SHS Module 6 9. How do you resize a graph? A. Click the graph then click and drag any of the eight handles in the edges of the graph. B. Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired. C. Select the table the press Ctrl + Arrow Keys. D. You can’t change the size of graphs. 10. What is the best situation to use pie graph? A. Comparing value or proportions of a dataset. . When you want to visually present a data with a circle. B. C. If the information you want to present is about ratios. Dz 11. Whichis > If the data presented is related to food the best situation to use radial Graphs? On data that is about geometric radius or radii. . Similar to Forest graph but is present circular visually. B. C. Forcomparing different numeric value by area occupied. Dz 12. How to di A. B. . Radial graph is not an actual graph that can be used. rag select cells in Microsoft Excel? In the formula bar type the range you want to be drag selected. . Click on the first cell then while pressing shift, click the second cell specified. C. Press Ctrl + S, then click on the desired cell range. D. You can’t drag select cells in Microsoft Excel. 13. What is the main advantage in the use infographics in a document? A. B. Cc. D. 14. What are A. B. C It will make the presentation more visually appealing. It makes document shorter and less cluttered It makes data presentation easier to understand. . It shows that you're professional. the steps in creating a chart in Microsoft Excel In the ribbon click Insert then click the charts you want to use then drag select the cells needed to be presented. Press right click then click insert table then in the window select the table you want to present. Select the cells to be presented then press insert in the ribbon then click the desired chart. D. Select the table then press right click then press insert chart. 15. What is the main use for bar graph? A. B. Cc. D. To compare different data group from other data group. To show percentage or rates. To show rate of change over time of values. . To present relationship of data to other data. 3 CO_Q1_Empowerment Technologies SHS Module 6 Graphs and Charts as Infographics Graphs and charts are representation of data (mostly numeric) through graphics. There are many types of charts. Their uses depend on what you want to show or report. The following are some of the charts and their uses. Bar graphs - These are primarily used in comparing sets of data. They visualize the difference between values in a table and show rate of change over time. (Figure 2.1 is an example of a Bar graph) Line graphs - These are similar with bar graphs in terms of use, with a difference that line graphs are more suitable in showing trends. Pie charts - These are circular statistical graphical representation of proportion or percentage. Forest graphs - These graphs are used to visually represent values within a group and compare them to other groups. Radial graphs - These are similar to a forest graph in many aspects but are presented using a circle. gz, ch a iY Figure 2.2: Forest and Radial Graph Creating Infographics using Excel 1. Inyour desktop, create a document named ‘Sales Data’. (Always remember to save your progress by pressing Ctrl + S.) A 8 c D — F G H ‘ 4 K Lt 1 January February March April May June July August September October November December 23,000 4100 4,030 5,200 6,600 9,320 8,560 9,420 7,530 10,190 11,900 13,010 Figure 2.3: Sample Sales Table NOTE: 2. Inyour work area, copy the set of data. (see Drag Selection Figure 2.3) You drag select by clicking on the first cell then while pressing 3. Drag select A1 to L2, then in the ribbon press shift, chick the second cell Insert then in the charts section, click the specified. Particularly in this desired chart. For example, click Insert Column example, click on Al then press Chart or Area Chart. (See Figure 2.4) shift and L2. 6 CO_Q1_Empowerment Technologies SHS Module 6 ei Cees Dery @- oy J | oO , @ Store 1? le Recommended Table Pictures Online 3 My Add-ins Recommended ~ | 4 -ins PivotTables Pictures + My a Charts - Tables ustrations Add-ins Charts 5 ro ood pro rag Figure 2.4: Inserting a Chart 4. A dropdown window will appear as seen in Figure 2.5,in the 2-D Column section, select Clustered Column. It will create a graph as seen in Figure 2.6. To rename, double click the name of the graph then type the “Sale Rending Graph” (Steps 5 to 7 are already tackled in earlier modules. You may refer to Module 2.2 “Working with Spreadsheets” detailed instructions) for more . To resize, click the graph then click and drag any of the eight handles in the edges of the graph. fe me J 2-D Coh ba ane Line Column FD |B AB me 3-D{ Clustered Column Use this chart type to: L— + Compare values across a few Li be categories. Use it when: + The order of categories is not important. [hil More Colamn Charts. 7. To reposition the graph, click and drag the Figure 2.5: Line Graph Selection graph to the desired position. 8. You can copy and paste the graph to other Microsoft Office application. To copy press Ctr] + C then press Ctrl + V to paste. Chart Title + 28000 a 12000 T! 00 00 e000 -aTl ® Fe ‘Api ten hey shupest—Seonember —Orteber ber Be Nay Figure 2.6: Sample Column Chart CO_Q1_Empowerment Technologies SHS Module 6 Infographic Image and Graphical Formatting The visual preference of people when it comes to gathering data must not be discounted. When making an infographic specifically a graph, it is necessary it is tailored to our target audience. In MS excel there are options in editing, manipulating and formatting visual elements in our graph. Design Tools a CHART TOOLS 1. To access the Chart Tools where Design and TEAM DESIGN FORMAT Format Menu tools can be found you must first select any Graph that you want to edit. In the ribbon. The said Menu tools will be available = oo | Conditional_Format as as seen on figure 2.7 Figure 2.7: Chart Tools “4 | Normal 2. Click on Design, In the Chart Styles section click More (as seen on figure 2.8). It will expand and display multiple Chart Styles options as seen on Figure 2.9. f wo Lactull ama sul al) snes = Ena sata Chart Styles Figure 2.8: More button Figure 2.9: Multiple Chart Styles Option 3. In the Multiple Chart Styles you can choose different types of styles that can accommodate different styles requirements or preference. Click and explore any of each to see their differences. For the purpose of demonstration, click Style 14 as seen on figure 2.10. ett Sa if covet] _ | Style 14 Ee a P53 ae Se Figure 2.10: Multiple Chart Styles Option 8 CO_Q1_Empowerment Technologies SHS Module 6 8. How do you resize a graph? A. Click the graph then click and drag any of the eight handles in the edges of the graph. B. Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired. C. Select the table the press Ctrl + Arrow Keys. D. You can’t change the size of graphs. 9. How do you rename a graph into “First Data” in Microsoft Excel? A. Press right click then select rename, a window will appear then type “First Data’. B. Press Ctrl + A then Ctrl + R, rename the chart to “First Data” C. Double click the name of the chart and type “First Data”. D. Graph names can’t be changed as they follow the name from the selected data. 10. What is the purpose of the Formula Bar? . It allows an easy to see input box for formula in a cell B. It is a selection of shortcuts different formula in Microsoft Excel C. It is the formula that allows computation of values from different D. > cells. The Formula Bar is a label below the cell that indicates the result of a formula 11.Which Ribbon Menu is needed to be selected to change the font? A. Home C. Page Layout B. Insert D. Cell Formatting 12.How do you assign which cell the formula = (Al + A2) + A3 will be displayed on? A. On the formula bar type cell address B. Press right click then select Cell Format then click on the Formula tab, type which cell you want that formula will be displayed C. In the ribbon click Cell Formatting then select the formula then type where it will displayed. D. Type the formula where you want it to be displayed on. 13.Which Ribbon Menu is needed to add a Chart? A. Home C. Page Layout B. Insert D. Cell Formatting 14.With this formula = Expense!C12, what does the Expense! part means? A. Ita variable that allows quick reference of a value. B. It is formula label, allowing the user to manage all the formula. C. It indicates that the cl2 to be displayed is on the sheet Expense D. This is not a proper use of the formula. 15.How do you change formula style in a sheet? A. Click Insert > Cell Formatting > Table Format > Table Style B. Click Home > Format as Table > Table Style C. Click Cell Formatting > Format Table > Table Style D. You have to select each cell then add cell borders to each of them 11 CO_Q1_Empowerment Technologies SHS Module 6 % RY Additional Activities Graphing the Graph Following the instruction for Survey Graphing activity. Make a line graph with the same data used in the previous activity. Show both graphs to at least 10 people then ask which graph is best used in comparing data. Record the result then make a Pie Graph. Create a Word document and named it “Graph Survey”. Copy and paste your graph with a brief description regarding your findings. 12 CO_Q1_Empowerment Technologies SHS Module 6 Cm Answer Key ST ‘VT ‘er “ST Tr ‘OT <mmmaaAma«ngs<sAMom oO aaotoOor quaulssassy OST dad ‘vr Ver OSI VIL d ‘or d ‘6 aq: d Vv Oo a a d ANG fH ORK oO a Mouy J DUM References Rethmeyer , Emily. “NOT ALL GRAPHICS ARE INFOGRAPHICS: GETTING BACK TO BASICS”. Last Modified October 16, 2017. “https: //mbbagency.com /blog/not- graphics-infographics-getting- back-basics/ 13 CO_Q1_Empowerment Technologies SHS Module 6