Excel-Beginning
Basics for Visual Representation & Data
Objectives:
- Become familiar with terminology used in Microsoft Excel
- 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
Excel Basics
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
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
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.
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.
**Copy & Paste "Fake Homeroom" spreadsheet from teacher apps to your desktop.**
---------------------------------------------------------------------------------------------------------
Sorting: Page 9-10 in Excel Task Sheet (10 minutes)
Formatting: Page 11-16 in Excel Task Sheet (10 minutes)
Charts & Graphs: Page 17-19
Discuss Classroom Applications
Share School Templates (optional)
Remember...
Cindy Evans, Tech Coach
Email: evansc@rcschools.net
Website: http://cindyevanstech.weebly.com/
Phone: 615-904-6771
Twitter: @evanscsts