1 / 12

Data Sorting in Excel

Data Sorting in Excel. Lesson. Bellwork: Explain the difference between ascending and descending order when sorting records. Why would you need to sort records? Give examples. Weekly Goal Log Assignment:

autumn-burke
Download Presentation

Data Sorting in Excel

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. Data Sorting in Excel Lesson

  2. Bellwork: Explain the difference between ascending and descending order when sorting records. Why would you need to sort records? Give examples. Weekly Goal Log Assignment: The student will review terms, take notes, and complete the on your own exercise on page 318.

  3. Learning Objective • By the end of the lesson, the student will be able to display an understanding of sorting records in a database in Excel by designing a database to track homes for sale and sorting it by square footage.

  4. Definitions • Ascending = A-Z, 1-100, Dates oldest to most recent • Descending = Z-A, 100-1, Dates most recent to oldest • Key – One level within a sort • You can sort on a maximum of three keys in a single sort

  5. What is the key for this sort?

  6. Sort with different keys • Last Name Ascending • Make the second key State • Make the third key City

  7. Assignment • On your own page 318 • Track homes for sale in your area • Find at least 15 homes • Enter them in the order that you find them • Sort them when you have all 15

  8. Closure • What are the steps for sorting records and give an example of why you would need to do a data sort in Excel.

  9. Bellwork: What is a key? And how many keys can you set? Weekly Goal Log Assignment: The student will finish the on your own exercise on page 318.

  10. Bellwork: If you want dates to be organized from most recent to oldest, what would you do? Weekly Goal Log Assignment: The student will finish the on your own exercise on page 318. If you are finished - you may begin page 322 on your own.

  11. Bellwork: Do you know what an autofilter is? What is it? Weekly Goal Log Assignment: The student will begin page 322 on your own.

  12. Bellwork: How do you set up an autofilter? Weekly Goal Log Assignment: The student will finish page 322 on your own.

More Related