Beginning Excel for Visual Representation and Data Analysis

Learn how to make the most of Microsoft Excel by exploring ways to increase your productivity, visual representation, and data analysis into your classroom. With CCSS, students are expected to conduct research across the curriculum then display their data findings visually. ISTE Student Nets requires students to collect and analyze data to identify solutions and/or make informed decisions. Excel simplifies and streamlines these task and many more. Find out how to make the most of this indispensable tool.

Bell Work

  • Log into Edmodo
  • Join the Excel Training group - 84aic7


  • Become familiar with terminology and tools
  • Explore the formatting options within a sheet or workbook
  • Create and explore formulas, sorting, and simple chart and graphs
  • Explore options for using to analyze classroom data

TEAM Rubric - Instructional Plans, Use of Data

What is it we want our students to learn?
How will we know if each student has learned it?
How will we respond when some students do not learn it?
How can we extend and enrich the learning for students who have demonstrated proficiency?

Standards - CCSS Math, CCSS ELA, and Literacy/Science/Technology

Digital Citizenship-  Internet Safety

ISTE/NETS – Critical Thinking, problem solving, and decision making
Collect and analyze data to identify solutions and/or make informed decisions.

Excel Basics

  • Terminology
  • Tools
  • Formatting
  • Formulas
  • Charts
  • Sorting
  • Preferences / Menu
  • Classroom Applications /Templates


How will you be able to use this in your classroom?
Is there anything else you would like to know about Excel?
Can I come and help you further in your classroom?

Evaluation – complete online PD evaluation