Hands on Data
Presented by
Siu Chan
Hafeez Abdul
Masa Naito
Hands on Data
Introduction
What is DATA
Where can DATA be found
In School/Education
Manage DATA Analysing DATA
Database Problem Scenario
Spreadsheet Demonstration
Software/Programs Tutorial/Practice
Introduction: What is Data?
Introduction: What is Data?
Lieutenant Commander
Data, played by Brent
Spiner, is a character in
Star Trek: The Next
Generation television
series and in the four
subsequent The Next
Generation films.
Introduction: What is Data?
The term data means groups of information that
represent the qualitative or quantitative attributes of
a variable or set of variables.
Information or facts that have been gathered in
order to be studied.
Introduction: What is Data?
Data is a collection of information that we
can manage and use meaningfully;
thus it exits really "everywhere" as long as
you can categorise them for further studies
Introduction: What is Data?
Introduction: What is Data?
Introduction: What is Data?
Introduction: What is Data?
: Animal-Mammal-Dog-Black
: Animal-Mammal-Dog-Grey
: Animal-Mammal-Cat-Black
:Animal-Mammal-Cat-Grey
Introduction: Where can Data be found?
Clothes Music Movie
Type Title Title
Brand Genre Genre
Size Artist Year
Colour Length Director
Price Language Cast
Price Length
Price
Introduction: In School/Education
Student Class Exam
Name Class code Subject
Student No. Name Date
Gender Grade Year
Birthday
Year Grade
Class
Teacher Class
Year
Address Location Marks
Phone No. No. of Total mark
students
Introduction: In School/Education
Word Writing Task Cultural Event
Verb Language Name
Adjective No. of word Date
Preposition Variation of Season
Auxiliary verb words used Event type
Noun Functions & Description
Pronoun Structures Comparison
Numeral
Manage DATA: How do you manage Data?
Manage DATA: DataBase
Database:
Collection of the organised information.
Classification based on following criteria:
Type of the contents - bibliographic, full-text, numeric, image etc.
Type of database model - Relational model, hierarchical model,
network model etc.
Examples:
students’ record, teachers’ record, sales record, and customers’ record.
Manage DATA: Database System
Database Management System:
Software package that helps to use databases.
Examples:
Microsoft Access, SQL Server, Oracle, MySQL,
PostgreSQL, FileMaker, RDBMS, dBASE, Clipper, and
FoxPro
Manage DATA: Spreadsheet
Spreadsheet:
An application used for managing, analysing and
presenting information.
Software Packages:
Create, store and manipulate data using spreadsheet
application.
Examples:
Microsoft Excel (MS Office)
Apple Numbers (iWork)
OpenOffice.org Calc (OpenOffice)
Manage DATA: Advantages of MS Excel 2007
Tools to accomplish Forecast data trends
tasks Sharing
1 million rows and Access permissions
16000 columns Compression and
Professional-looking recovery.
3-D charts Connect to remote
Interactive pivot table databases.
views
Problem Scenario
Mrs. Jones is the year 5 teacher.
In this term, she asked the class to practice
the arithmetic of the four operations (+, –, ×,
÷) from week 2 to week 8, using the program
“Basic4” installed on the classroom
dedicated PCs.
Problem Scenario
The program “Basic4” contains a table with
the student practice log. At the end of the
school term, Mrs. Jones wants to analyze the
student practice progress such as:
No. of questions practiced per student
For each of the four operations (+, –, ×, ÷), the
number of questions practiced per student
For each student, the percentage of correct
answers
For each student, the percentage of correct
answers for each operation (+, –, ×, ÷)