Excel Basics: Understanding Your Assessment Tracker

Learning the basics of using excel, simple formulas, and applying this to your assessment tracker.
Please bring your assessment tracker on a thumb drive or external hard drive.

Agenda


Dates:Mar.30, 2011
Topic: Excel Basics




Time
Topic
Resources
3:45
Sign In

Carolyn Semet and Beth Richards, Technology Innovation Specialists

Get and sign for your external hard drive if you haven't received one already
JOIN our learning network if you are not a member: http://ted21c.ning.com/


READ


RESPOND
4:00
Welcome

Carolyn Semet and Beth Richards, Technology Innovation Specialists
csemet@schools.nyc.gov and brichar4@schools.nyc.gov
Learning the basics of using excel, simple formulas, and applying this to your assessment tracker.


external image moz-screenshot-36.png
4:05
Excel Voabulary and Basics

4:15
Getting to Know Excel Formulas

4:30
Useful Tips and Tricks

4:45
The Assessment Tracker - How it works

Laurie Baum, Teaching Matters

5:00

*
5:20
Create an excel spreadsheet

5:40
Share your spreadsheet

5:55
Complete evaluation
  • Borough hosting: Manhattan
  • Class: PDN Afterschool PD

6:00
Adjourn


Excel Vocabulary

Active Cell – This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected.
AutoSum Function that automatically adds selected cells.
Cell – This is the place where information is held in a spreadsheet.
Cell Address – Use this to know the exact location of a specific cell. Noting the intersection of the column and row forms it. The last cell address on a worksheet is IV65,536.
Column – In a spreadsheet, these are the vertical spaces. Columns are headed with letters. There are a total of 256 columns on one worksheet. The last column is IV.
Microsoft Excel A spreadsheet application tool that analyzes data in a table format using formulas.
Name box – Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.
Row – In a spreadsheet, the row is the horizontal group of cells. Rows are named with numbers, i.e.1, 2, 3. There are a total of 65,536 rows on a worksheet.
Sheet tabs – Labels located at the bottom of the workbook window indicating the worksheets.
Spreadsheet – A document that is used to crunch numbers and formulas.
Sort – In a database, this function puts the records into a specific order.
Workbook – An Excel document which contains three worksheets by default but can have more than three.
Worksheet – A single sheet contained in an Excel workbook.


Excel Resources

Excel Topics to cover:

navigate the worksheet
enter labels and values
format cells, columns, rows
filter and sort data
print and create charts