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 Ribbon Menu is needed to add a Chart?
Insert
Home
Cell Formatting
Page Layout
How do you resize a graph?
Select the table the press Ctrl + Arrow Keys.
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.
You can’t change the size of graphs.
Click the graph then click and drag any of the eight handles in the edges of the graph.
Which Ribbon Menu is needed to be selected to change the font?
Insert
Cell Formatting
Home
Page Layout
With this formula = Expense!C12, what does the Expense! part means?
It indicates that the c12 to be displayed is on the sheet Expense
It a variable that allows quick reference of a value.
It is formula label, allowing the user to manage all the formula.
This is not a proper use of the formula.
How do you resize a column or width?
In the Formula bar type (h[value]w[value]).
Click and drag the column or row heading.
Select the cell the press right click, select format cell then change height and width values.
Click the cell then in the ribbon select format cell then change height and width values.
How do you rename a graph into “First Data” in Microsoft Excel?
Double click the name of the chart and type “First Data”.
Press right click then select rename, a window will appear then type “First Data”.
Graph names can’t be changed as they follow the name from the selected data.
Press Ctrl + A then Ctrl + R, rename the chart to “First Data”
Which of the following is NOT the purpose of infographics in the presentation of data?
It improves people understanding in data gathering.
It helps people interpret data visually.
It engages audience in your presentation.
It helps the presentation to be more visually attractive.
Which is an example of infographics?
Illustration
Pictures
Charts and Graphs
Graphics
Which is the main use of line graph?
To show hierarchy between data sets.
To visually present the data.
To see trend of data change.
To compare difference between data.
How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?
In the ribbon click Cell Formatting then select the formula then type where it will displayed.
Press right click then select Cell Format then click on the Formula tab, type which cell you want that formula will be displayed
Type the formula where you want it to be displayed on.
On the formula bar type cell address
What is the purpose of the Formula Bar?
It is the formula that allows computation of values from different cells.
The Formula Bar is a label below the cell that indicates the result of a formula
It allows an easy to see input box for formula in a cell
It is a selection of shortcuts different formula in Microsoft Excel
Which should be done first in making a graph in excel?
Select the drag cells needed for the chart.
In the ribbon, click Insert > Charts.
Press right click then click insert table.
In the Insert tab click Table then click the desired table.
What is the formula that will add the contents of the cells C1 and C10?
No comments