In Excel use the Tab or Arrow keys to move from cell to cell.
Excel teaching points
- Rows – Horizontal named 1, 2, 3, etc. Show how rows are widen to fit data. Mouse must be in a plus sign position between rows. Click and drag.
- Columns – Vertical named A, B, C, etc. Show how columns are widen to fit data. Mouse must be in a plus sign position between columns. Click and drag.
- Cell – point of where rows and columns meet. Explain how to name a cell. Column then row = A1, A2, etc.
- Font section on Home Tab. Font type, size, bold, italic, underline, borders, fill color, font color.
- Alignment section on Home Tab. Align - top, middle, bottom, left, center, right, orientation, wrap text and merge cells.
- Fill color – click on the cell then click on the down arrow beside the paint can. Change the color.
- Border – click on the cell then click on the down arrow beside the border button. Add a border.
- Sum function – demonstrate how to add formulas.
- Charts – demonstrate how charts are made from data.
Steps for creating a chart
Click on the Insert tab.
Click on the down arrow before Pie button.
Click and choose on a pie graph.
Click Select Data button.
Highlight the title row down to the last row of data but don’t highlight the total row.
Click Ok button and your chart appears in the square.
Under Chart Layouts you can change the way your chart looks.
Under Chart Styles you can change the style of your chart.
All charts must have a chart title. If the chart type does not include one then you must insert a text box and put one in.
You can change a chart’s color: background, pie pieces, everything. Play around with your chart.
Type your name in a cell somewhere on the page.
Click on File and print preview button. You need to make sure that your chart and table and name are on the same page. If not, move the chart underneath your table so it will fit.
Once you are done save your document as a pdf by following the steps below. To receive a 4 you must put it in my folder.
Steps for Saving Excel Charts
File
Save As
Dropbox
Grade
Mrs. Jenkins folder
Your Teacher’s folder
Project folder
File name is student name project name
Save as type is PDF (this is important as voice thread won’t upload excel documents)
Save
Check that your file is display on my screen. If so you did it! If not, try again.
Excel Games
K/1st Introduction - Hidden Ships
2nd/3rd Introduction - Seedball
Video from BrainPOP Jr. about Charts and Graphs
Comments (0)
You don't have permission to comment on this page.