Welcome to Yew Wah Information & Communication Technology Class For CIE IGCSE Students.

CIE IGCSE - Cambridge International Examination - International General Certification of Secondary Education.
Grade : For Age Group 14 to 16 Grade 10 ( Year 10 )
Subject Area : Information and Communication Technology - ( 0417 )

Section 18 : Topic - Data Manipulation.
In this chapter student will learn how to :

  • Understand database structures.
  • Create a database from an existing data file
  • Define database structures.
  • Enter different forms of data into a database
  • Search for subsets of data
  • Produce a Report
  • Export data and reports for use within another package
  • Sort data within a database.

Learning Objectives:

  • Assign appropriate field/data types, for example: text, numeric, (integer, decimal, percentage, currency), date/time, Boolean/ logical (yes/no, true/false, –1/0)
  • Use meaningful file and field names
  • Format fields and identify sub-types like: specifying the number of decimal places or a particular currency to be use.
  • Identify the structure of external data with different file types, for example: .csv, .txt, .rtf
  • Locate, open and import data from an existing file
  • Enter data with 100% accuracy
  • Create a calculated field, perform calculations at run time using formulae and functions, for example: addition, subtraction, multiplication, division, sum, average, maximum, minimum, count
  • Sort data using one criterion into ascending or descending order, using different field types, for example: alphanumeric, numeric, date
  • Perform searches using a single criterion and using multiple criteria, with different field types like alphanumeric, numeric, Boolean etc. and a variety of operators like: AND, OR, NOT, LIKE, >, <, =, >=, <=
  • Perform searches using wildcards
  • Produce reports to display all required data and labels in full
  • Set report titles,use headers and footers, align data and labels appropriately, produce different layouts, for example: labels
  • Format numeric data, for example: to display the number of decimal places, a variety of currencies, percentages
  • Show and hide data and labels within a report, show hidden fields, display calculations/formulae
  • Export data in common text formats, for example:.csv,.txt,.rtf
  • Export data into a graph/charting package

Module 1 - Creating a Database & Table Structure in Database.
Module 2 - Importing Data in to Database from External Sources.
Module 3 - Establishing Relations Between Tables.
Module 4 - Performing Search (Query) for filtering data.
Module 5 - Creating Reports with Expected Requirements.
Module 6 - Exporting Queries and Reports in to different formats.

Teaching Tools.
www.index.ywies.com www.udemy.com, http://www.pinterest.com, www.zoho.com, www.edmodo.com, www.sophia.com, www.vimeo.com, www.dropbox.com , www.box.com

Universities :
http://is.tsinghua.edu.cn/EN/index.htm - Tsinghua University.