Agenda - BHS Library
Microsoft Excel? Class 3-14-2014AgendaGoals – you should leave this instruction time being able to do the followingComfortably be able to create at least one of the excel graphs available from the suite. Edit graphs including title axis labelsseries labelsExamples of graphsLine graph (time series)Pie ChartColumn (aka bar chart)X-Y Scatter PlotclimatographMore information on ExcelStart: Please open excel and then choose your graph type:TO CREATE A TIME SERIES LINE GRAPH – Copy and paste the following data into an excel spread sheet.MonthAverage High (°AF)Average Low (°AF)Jan3317Feb3619Mar4528Apr5938May7047Jun7857Jul8362Aug8159Sep7352Oct6341Nov5033Dec3722At the top of the spread sheet click on the ‘insert’ tab.Select just the data portion of the information (shaded in green)Up top of excel you should see chart options select line chartTo add titles and axis select the ‘layout’ option at the top.TO CREATE A PIE CHART – Copy and paste the following data into an excel spread sheet.Letter GradeOccurancesA68B15C5D0Not Yet…0Still to Take2At the top of the spread sheet click on the ‘insert’ tab.Select just the data portion of the information (shaded in green)Up top of excel you should see chart options select pie chartTo add titles and axis select the ‘layout’ option at the top.TO CREATE A COLUMN/BAR CHART – Copy and paste the following data into an excel spread sheet.Table: Favorite Type of MovieComedyActionRomanceDramaSciFi45614At the top of the spread sheet click on the ‘insert’ tab.Select just the data portion of the information (shaded in green)Up top of excel you should see chart options select column chartTo add titles and axis select the ‘layout’ option at the top.TO CREATE AN X-Y SCATTER PLOT– Copy and paste the following data into an excel spread sheet.Basalt SamplesSampleMass (g)Volume (cm3)Density (g/cm3)B178.1425.03.13B261.1920.62.97B359.5119.23.10B438.3910.13.80B5102.1636.52.80B653.6716.63.23B7118.3240.02.96B836.5813.32.75B942.9614.03.07B1071.0026.02.73B1170.0824.52.86Class Average3.04At the top of the spread sheet click on the ‘insert’ tab.Select just the data portion of the information (shaded in green)Up top of excel you should see chart options select X-Y Scatter (points only) chartTo add titles and axis select the ‘layout’ option at the top.TO CREATE A CLIMATOGRAPH –In some instances the graphs are so complicated to explain I give the students a template and have them modify the data. Excel is set up so that the graphs automatically change.A climatograph is a double Y axis graph which has precipitation data on one Y and temperature data on the other. Please look under the following link for Copy of Climatograph Template for Earth ScienceThis will automatically download an excel template. I then have my students go out to , select a city of their choice and modify the graph. MORE INFORMATION – we have but skimmed the surface , for more information direction and help try the link below. LOCAL HELP – if after the class you run into issues in attempting to create a specific graph/chart do not hesitate to contact me either via e-mail (skoziol@) or my extension within the district 413-323-9419 x2130I hope the class has been helpful. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- engineering statistics excel tutorial
- ms galvinhill comp classes home
- highlights of using excel 97 to perform selected
- making a pie chart in excel
- making graphs with excel
- ms excel mcq quiz set 1 e library wcl
- agenda bhs library
- ms excel session 5 topics tech help today
- using microsoft excel to create pie charts for the bean lab
Related searches
- business review agenda sample
- powerpoint agenda template
- management review agenda examples
- introduction meeting agenda sample
- printable weekly agenda 2020
- agenda for introductory business meeting
- free agenda templates in word
- free meeting agenda templates printable
- free blank meeting agenda template
- word meeting agenda template
- democratic agenda for socialist america
- new world order agenda stages