EMT-11_12-Q1-0404-PF-LED.pdf for education

This ppt can help students on how to create spreadsheet

1. Empowerment Technologies
Senior High School Applied -Academic
Unit 4: Spreadsheet Skills
Lesson 4
Inserting Graphs and Charts

2. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Have you tried using
graphs and charts in a
presentation before?
2

3. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
How did it help
with your
presentation?
When do you
think is the best
time to use
graphs and
charts?
3

4. Learning
Objectives
At the end of the
lesson, you should
be able to do the
following:
ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
4
●Understand the purpose of
graphs and charts in
spreadsheets.
●Use graphs and charts
properly.
●Insert independently graphs
and charts in spreadsheets.
4

5. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
5
Areyoufamiliarwiththedifferentkindsofgraphsand
charts?Doyouknowwhichkindtousefordifferent
purposes?
McDonaldhasabigfarmandisaskingforyourhelpto
makeasimplerepresentationofhisfarmanimals’
population.Usingthedataonthenextslide,createan
appropriategraphorchartinsidethebox.
5

6. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
6
6
Chicken Cow Pig Dog Sheep Horse
25 5 10 15 20 5

7. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
1.What kind of graph or chart did you use for
the given problem?
7
GraphsandCharts

8. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
2.Why did you use that kind of graph or
chart?
8
GraphsandCharts

9. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
3.What are the different kinds of graphs and
charts that you know of? What do you think is
the importance of each one? What are their
uses?
9
GraphsandCharts

10. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
What is a graph?
10

11. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Agraph is
considered to be the
most basic way to
represent data
visually.
11

12. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
What is the
difference
between a
graph and a
chart?
12

13. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Chartsare more complex
than graphs. Charts are
usually used to compare
and contrast parts of the
same data against one
another.
13
13

14. What are the different kinds of
graphs and charts according to
their purpose?
14

15. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Kinds of Graphs
and Charts
●Column
●Line
●Pie
●Bar
●Scatter
●Area
●Stock
●Surface
●Radar
15
15

16. How can I insert a graph or chart
in a spreadsheet?
16

17. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Steps to Inserting Graphs
and Charts
1.Enter the data into a
worksheet.
2.Select a graph or chart
type.
17
17
1
2

18. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Steps to Inserting Graphs
and Charts
3.Create your graph or
chart and adjust using
Quick Layout.
4.Add chart elements.
18
18
4
3

19. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Steps to Inserting Graphs
and Charts
5.Change the format.
6.Move the chart.
19
19
6
5

20. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Chart
Elements
●Chart title
●Axis titles
●Legend
20
20

21. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Chart
Elements
●Display
labels
●Data table
●Axes
●Gridlines
21
21

22. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Chart
Elements
●Plot area
●Trendline
●Error bars
22
22

23. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Practice 1
Erly would like to create a
simple pie chart to represent
her ideal budget for the
month of March. Help her
follow the right steps to
creating a pie chart in
Microsoft Excel by
sequencing the steps on the
next slide.
23

24. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
24
Write numbers 1-7 with 1 being the first step and 7 being the
last.
__________Choosethepiecharticonandselectthesimplepieamongthe
options.
__________Movethecreatedpiecharttoanotherworksheet.
__________Applystylesandcolorstothecharttomakeitaesthetically
pleasing.
__________Enterthedesireddatafortheidealbudget.
__________Makenecessaryadjustmentstothetitleanddataintheaxes.
__________HighlightthecellsthatcontainthedataandclicktheInserttab.
__________Addoreditdifferentelementsofthechartforherdesiredlayout.

25. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Practice 2
Determine whether the
statements in the next
slide are best practices
when creating graphs and
charts by drawing a smiley
face inside the circle for
each number. Otherwise,
draw a sad face.
25

26. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
26
1.Make your graph or chart simple and
clean.
2.Choose the appropriate kind of graph or
chart.
3.Use unnecessary legends in your graph
or chart.
4.Stick only to standard graphs and
charts.

27. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
27
5.Apply needed elements in your graph or
chart.
6.Display all the data that can be
displayed in your graph or chart.
7.Decorate your graph or chart with lavish
colors and styles.
8.Produce a graph or chart that is
readable.

28. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Choose the word
from the bank on
the next slide that
best matches each
definition.
28

29. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
29
1.Alineinsidethechartwhichrepresentstheoverallprogressofthedatais
called________________________.
2.Ifyouwishtodisplaylinesinsidetheplotareaofyourgraphorchartfor
betterrepresentation,add______________________.
3.Anelementwhichshowstheprecisionofthemeasurementofdatawiththe
helpofstandarddeviationiscalled_______________.
4.Wheninputtingthedata,whatyouputinthefirstboxwillreflectthe
_______________ofthegraphorchart.
5.A_______________________isanexplanationofthecharactersandsymbols
insideyourgraphorchart.
292929
29
legend gridlines
vertical axis
error bars horizontal axis
trendline

30. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
Identify which kind of graph
or chart is best to use in
each statement on the next
slide. Provide a short
explanation why you think
it’s the appropriate.
30

31. ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
ENGAGE EXPLORE EXPLAIN EXTEND
EVALUAT
E
31
1.Katewouldliketouseavisualrepresentationofherdatathatwill
displaythetrendsofhersetsofdata.
2.Marionewouldliketouseavisualrepresentationofhisdatathatwill
comparehisdatawithanothersetofdatawithnegativevalues.
3.Rubywouldliketouseavisualrepresentationofherdatathatwill
showonlyapercentagefromthewholesetofdata.
4.Allanwouldliketouseavisualrepresentationthatwillanalyzehis
setsoffinancialdata.
5.Miowouldliketouseavisualrepresentationthatwillshowhislarge
setsofdataina3-Dlandscape.
313131
31

32. Wrap Up
Graphsareconsideredtobethemostbasicwayto
representdatavisually,whilechartsareconsideredtobe
themostpleasingway.Withgraphs,youusuallydealwith
differentdataparameters.Withcharts,youareusually
comparingandcontrastingpartsofthesamedataagainst
eachother.
Therearedifferentkindsofgraphsandchartsforgeneral
usesuchascolumns,line,pie,bar,andscatterplot.
32

33. Wrap UpTherearealsootherkindsofgraphsandchartsformore
case-specificusesuchasareacharts,stockcharts,surface
charts,doughnutcharts,andradarcharts.
Thefollowingarethebasicstepsforcreatinggraphsor
charts.
Step1:Enterthedataintoaworksheet.
Step2:Selectagraphorchartkind.
Step3:Createyourgraphorchartandadjustusing
QuickLayout.
Step4:Addchartelements.
Step5:Changetheformat.
Step6:Movethechart.
33

34. Bibliography
34
“Excel 2013: Charts.” GCFGlobal.org.
https://edu.gcfglobal.org/en/excel2013/charts/1/(accessedApril212020).
“ExcelChartingBasics:HowtoMakeaChartandGraph”.Smartsheet.
https://www.smartsheet.com/how-to-make-charts-in-excel(accessedMarch
302020).
“UsingMicrosoftExcel:CreatingandModifyingCharts.”ResearchGuides.
University of Michigan Library, June 17, 2019.
https://guides.lib.umich.edu/c.php?g=283162&p=1886446