Making Excel Work for You!
Organize Info, Manage Lists, Analyze Data!
3 Sessions - Come to One Session or All!
Each session will explore practical applications of MS Excel for teachers. You will learn how to save time by using spreadsheets to better organize information; summarize and analyze data with a few simple clicks (student info, PASS, etc); represent data visually (great for PAS-T); and more!
Flexible session formats will accommodate all interests and skill levels.
Excel 1: Getting Started - Thursday, April 3, 3:45-5:00
If you do not use Excel at all, this session will help you feel comfortable with some spreadsheet basics. When you leave, you will know how to
create a spreadsheet and import class rosters (use for attendance lists, homework checks, field trip lists, locker combinations, form returns, behavior tracking, etc.)
edit and format cells
set row heights and column widths
format page and print settings
Excel 2: Summarizing & Analyzing Data I - Thursday, April 24, 3:45-5:00
Once you are using Excel spreadsheets, you will want to use its capabilities to summarize and analyze data. This is very useful for analyzing MAP and PASS data as well as any other information that you maintain for classes, such as field trip lists, form/information collection, etc. In this session we will work with
functions and formulas
sorting and filtering data
creating charts and graphs in Excel