Functional ict
This presentation is the property of its rightful owner.
Sponsored Links
1 / 13

Functional ICT PowerPoint PPT Presentation


  • 54 Views
  • Uploaded on
  • Presentation posted in: General

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 Presentation

Functional ICT

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Functional ict

Functional ICT

Lesson Five

Working with structured data (1/3)


Recap

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


Working with structured data

Working with structured data

Week 5

Week 6

Week 7

Week 8


Working with structured data1

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


Structuring data starter task

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


Formatting structured data

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?


The spreadsheet

The Spreadsheet

Column

Column Header

Cell

Row

Data Table


Recap structured data

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


Structuring data

10 mins

Structuring Data

Task – What obvious features differentiate UK bank notes?

http://www.bankofengland.co.uk/banknotes/current/index.htm


Structuring data1

Structuring Data

Can you identify each of the bank notes individually?


Structuring data2

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.


Skill check

Skill Check

  • enter suitable field names

  • format data types

  • enter and edit records

  • understand the difference between rows, columns and cells


Homework

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.


  • Login