1 / 30

Excel Basics for Data-Driven Instruction

Learn how to leverage Excel in the classroom for formative instruction practices, assessment, and student success. Explore data entry, charts, formulas, and more!

jersey
Télécharger la présentation

Excel Basics for Data-Driven Instruction

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Basics for Data Driven Instruction Chris Knight JCS Instructional Technician knightc@k12tn.net 865-397-6398 Amy Sharp JCS Instructional Data Coach sharpa@k12tn.net 865-397-2939

  2. Why all the DATA? • Data tells us where our students are currently performing, so that we can guide them to the next level of success! This process is the basis of formative instruction practices. • Formative instruction and appropriate assessment are key elements of the new evaluation model.

  3. Excel as aClassroom Tool

  4. The Ribbon

  5. So how do I use it in the Classroom?

  6. Entering Data • Charts • Merge Cells • Page Layout • Sorting • Single • Multiple • Formulas • Sum • Count • CountA • CountIF • Copy Cells • One to Multiple • Ascending Count • Multiple to Multiple • Find and Replace • Freeze Panes • First Row or Column • Pick the Spot

  7. Copy One Cell to Multiple Cells

  8. Copy One Cell to Multiple Cells

  9. Copy One Cell to Multiple Cells

  10. Find & Replace

  11. Find & Replace

  12. Find & Replace

  13. Freeze Panes

  14. Freeze Panes

  15. Charts – All Graph Options

  16. Charts – All Graph Options

  17. Charts – Bar Graph

  18. Charts – Bar Graph

  19. Charts – Column Graph

  20. Charts – Column Graph

  21. Merge Cells

  22. Merge Cells

  23. Page Layout

  24. Sorting Cells

  25. Sorting Cells

  26. Sorting Cells

  27. Sorting Cells by Multiple Columns

  28. Sorting Cells by Multiple Columns

  29. Sum

  30. Sum

More Related