Beginning Excel PD
Welcome!
Open a new Excel spreadsheet. Start-Programs-Excel 2016
Go to my website-teacher resources and open this Smore.
Open the Tutorial Guide at the bottom of this page.
Today's Objectives
· Become familiar with terminology and tools.
· Create a simple workbook
· Add columns, rows, and pages
· Explore the formatting options within a sheet or workbook
· Create and explore formulas, sorting, and filtering
· Add and edit borders within a worksheet
· Create a simple chart
Success Criteria
· Participants can explain common basic excel vocabulary terms (spreadsheet, workbook, worksheet, cell, cell name, merge cell, border lines, gridlines, sorting, filtering)
· Participants can create a workbook.
· Participants can add data to excel spreadsheet.
· Participants can use basic text formatting in spreadsheet (i.e. color, font type, size, bold, italicize, underline).
· Participants can add new and adjust column/row widths and heights.
· Participants can adjust margins and page orientation (I.e. to fit data in printable document).
· Participants can merge cells (i.e. to create headings for data table).
· Participants can change the cell color.
· Participants can add border lines.
· Participants can use the sorting and filtering functions
· Participants can use the AVERAGE formula to find the average of a column or row.
· Participants can create a simple chart
Step by step:
1. Terminology and Basic Navigation of the Excel Program: Pages 1-4 of Excel Task Sheet (20 minutes) a. typing specific data in cells (using data from Excel Task Sheet pg 2) b. changing cell size using the data that was just entered c. making text bold using the data that was just entered d. merging and centering using the data that was just entered
2. Formulas: Page 4-5 of Excel Task Sheet (15 minutes) a. "average" formula will be used with test scores in row 3 b. copy formula for remaining students
3. Adding: Columns, Rows, Pages 6-8 in Excel Task Sheet (10 minutes) We will use existing spreadsheet from tasks 1 & 2 for this task as well.
4. Copying & Pasting: Pages 8-9 in Excel Task Sheet (15 minutes) In this task, we will learn how to copy data from another Excel spreadsheet and paste into your new spreadsheet.
5. Sorting: Page 9-10 in Excel Task Sheet (10 minutes)
6. Formatting: Page 11-16 in Excel Task Sheet (10 minutes)
7. Charts & Graphs: Page 17-19
8. Discuss Classroom Applications