1 / 13

Working with Structured Data: Lessons on Data Formatting and Spreadsheet Management

In this lesson, we will explore the fundamentals of working with structured data, focusing on data formatting and spreadsheet management. Key objectives include understanding the essential characteristics of reliable websites, utilizing Boolean operators for effective web searches, and learning how to construct and format data tables effectively. Activities include personal data examination, exploring suitable formats for various data types, and tasks involving the analysis of UK banknotes. Students will apply these skills in practical settings, enhancing their ability to manage and analyze structured data.

eve
Télécharger la présentation

Working with Structured Data: Lessons on Data Formatting and Spreadsheet Management

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. Functional ICT Lesson Five Working with structured data (1/3)

  2. Recap What should websites be? • valid • accurate • reliable What can you use to narrow down a web search? • Boolean operators What allows you to access to the internet? • Browsers What can you use to search for information? • Search engines Bookmarks allow you to ..........................? • save pages for future use AND OR NOT

  3. Working with structured data Week 5 Week 6 Week 7 Week 8

  4. Working with structured data Lesson Aims and Objectives • structure and present data in a table You will learn how to: • build a data table • enter meaningful field names • work with different types of data • format data • sort data in different ways

  5. 10 mins Structuring Data – Starter Task Task – What personal data do you think the college holds about you? How could this be stored in a spreadsheet? Right Click on the Cell

  6. 10 mins Formatting Structured data Task – What format type is most suitable and is it a meaningful data name? • Name • Age • Date of birth • Part number • Stock code (alpha and numeric) • Address • Cost • Company name • Salary • Order date • Course code • Car registration Extension task : What other data elements can you format?

  7. The Spreadsheet Column Column Header Cell Row Data Table

  8. Recap - Structured data Format the cells or columns to suit the data type Use meaning data names Spreadsheets consist of rows, columns and cells A range is a collection of two or more cells. Data can be formatted by : • Right clicking on cell or column • Select format cell • Select data type

  9. 10 mins Structuring Data Task – What obvious features differentiate UK bank notes? http://www.bankofengland.co.uk/banknotes/current/index.htm

  10. Structuring Data Can you identify each of the bank notes individually?

  11. 10 mins Structuring Data Task – Using the internet, create a spreadsheet that could log all of the information about UK bank notes? Ensure that appropriate data types are used. http://www.bankofengland.co.uk/banknotes/current/index.htm Extension task : Format your spreadsheet using other types of formatting.

  12. Skill Check • enter suitable field names • format data types • enter and edit records • understand the difference between rows, columns and cells

  13. Homework Look at 5 spreadsheets you use at work and evaluate what different data types are employed and whether they are suitable for the type of data. Record your details and any changes you would make.

More Related