Functional ICT. Lesson Five Working with structured data (1/3). Recap . What should websites be? valid accurate r eliable What can you use to narrow down a web search? Boolean operators What allows you to access to the internet? Browsers
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Working with structured data (1/3)
What should websites be?
What can you use to narrow down a web search?
What allows you to access to the internet?
What can you use to search for information?
Bookmarks allow you to ..........................?
Lesson Aims and Objectives
You will learn how to:
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
Task – What format type is most suitable and is it a meaningful data name?
Extension task :
What other data elements can you format?
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 :
Task – What obvious features differentiate UK bank notes?
Can you identify each of the bank notes individually?
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.
Extension task :
Format your spreadsheet using other types of formatting.
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.