Lesson 7- Imaging and Design for Visual Message Using Infographics
Lesson 7- Imaging and Design for Visual Message Using Infographics
Imaging and Design for Visual Message 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.
Which should be done first in making a graph in excel?
Select the drag cells needed for the chart.
In the Insert tab click Table then click the desired table.
Press right click then click insert table.
In the ribbon, click Insert > Charts.
Which is the main use of line graph?
To show hierarchy between data sets.
To see trend of data change.
To visually present the data.
To compare difference between data.
How do you resize a graph?
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.
Click the graph then click and drag any of the eight handles in the edges of the graph.
Select the table the press Ctrl + Arrow Keys.
You can’t change the size of graphs.
How do you rename a graph into “First Data” in Microsoft Excel?
Press Ctrl + A then Ctrl + R, rename the chart to “First Data”
Double click the name of the chart and type “First Data”.
Graph names can’t be changed as they follow the name from the selected data.
Press right click then select rename, a window will appear then type “First Data”.
How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?
Press right click then select Cell Format then click on the Formula tab, type which cell you want that formula will be displayed
In the ribbon click Cell Formatting then select the formula then type where it will displayed.
Type the formula where you want it to be displayed on.
On the formula bar type cell address
With this formula = Expense!C12, what does the Expense! part means?
It a variable that allows quick reference of a value.
It indicates that the c12 to be displayed is on the sheet Expense
This is not a proper use of the formula.
It is formula label, allowing the user to manage all the formula.
Which of the following is NOT the purpose of infographics in the presentation of data?
It engages audience in your presentation.
It helps the presentation to be more visually attractive.
It helps people interpret data visually.
It improves people understanding in data gathering.
How do you change formula style in a sheet?
You have to select each cell then add cell borders to each of them
No comments