Excel Basics

Big image

Overview of Today's session

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.
Excel 2013: Getting to Know Excel

Objectives

Participants will:

  • Become familiar with terminology used in Microsoft Excel
  • Create a simple workbook
  • Write a simple formula
  • Create simple charts
  • Sort a simple text chart
  • Format cells
  • Add columns/rows
  • Filter information

Standards

TEAM Rubric Planning: Assessment- how assessment results will be used to inform future instruction

CCSS Algebra I & II, Core Math I, II, III : Statistics & Probability - Summarize, represent, and interpret data on two categorical and quantitative variables 6. Represent data on two quantitative variables on a scatter plot, and describe how the variables are related. -Make inferences and justify conclusions from sample surveys, experiments, and observational studies.

College and Career Readiness Anchor Standards for Speaking and Listening Presentation of Knowledge and Ideas 5. Make strategic use of digital media and visual displays of data to express information and enhance understanding of presentations.

NETS ISTE Standards - 4. Critical thinking, problem solving, and decision making Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources.

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

Agenda


  • Terminology
  • Tools
  • Formatting
  • Formulas
  • Charts
  • Sorting
  • Classroom Applications
  • Review Time! Let's Kahoot!
  • Wrap-Up and Evaluate

Wrap Up & Evaluate


1. Use the Comment Stream below to share how you can use Excel in your classroom this year.

2. Complete the PD Survey found below.