Skip to content
Learnearn.uk » IGCSE ICT Home » Data Handling Applications

Data Handling Applications

Introduction

Data Handling Applications

Data handling is concerned with how data is inputted, stored and output in computer systems.

It didn’t long take long from when computers were invented for businesses and organisations to appreciate the potential benefits that ICT could bring to a business.

Surveys

Surveys

Surveys and questionnaires are highly useful data gathering tools for any business or organisation and have been used long before the invention of computers. They allow the collection and compilation of both qualitative and quantitative data.

Whilst surveys are incredibly useful, they can also be massively time consuming in all stages of the process, due to the volume of data the needs to be processed.

Advances in ICT have made  massive difference to the way that surveys and questionnaires are designed, conducted and analysed.

Improvements include:

  • The ability to design surveys using word processing
  • The ability to conduct surveys over the internet / on computer
  • The ability to produce statistical analysis automatically.

survey

Activity 1 Â - Fill out the Mr West survey

Mailing lists

Mailing Lists & Electronic Newsletters

Mailing lists are a great way of keeping people informed about an area of interest that they have subscribed to.

Mailing lists were original expensive and time consuming to run, with letters being printed on a printing press and being sent through the post to hundreds, if not thousands of people.

ICT has allowed the following improvements to mailing lists:

  • Automated subscribe and unsubscribe systems
  • Automated mass mailing via email to subscribers

newsletter

Activity 2 -Create your own newsletter with MailPoet

Create a newsletter

Society Records

Society Records

Societies, such as the Scouts association, Duke of Edinburgh award and other organisations need to store information about their members. This information can include:

  • Name
  • Address
  • Email
  • Telephone
  • Membership type (member, leader, assistant, coordinator)
  • Date joined
  • Membership status (active, expired,suspended)

This data used to be stored on paper, which was a slow and unreliable process. In the last 25 years this data has steadily moved to electronic format, such as using a spreadsheet or database software.

More recently there has been  a massive movement towards online membership management, for example the eDofE system,  or the online scout membership database.

Advantages of electronic records include:

  • Easy adding / editing of data
  • Ability to search and sort data
  • Ability to use mail merge to produce many individualised letters from one template.
  • Easy backup and storage
  • Security – you can password protect and encrypt files / databases for added security

 

societies

 

School Reports

School Reports

http://www.ictlounge.com/html/data_handling_applications.htm

  • Attendance reports
  • Student reports

report

 

Libraries

Libraries

http://www.ictlounge.com/html/data_handling_applications.htm

Library inventory management systems include:

  • Book search systems ( by title , author, publisher, etc)
  • Book lending management.

library

Activity 5 - Search for an odd book

Go to the University of Aberdeen’s website and search through their catalogue. What is the most obscure book you can find?

http://www.abdn.ac.uk/library/collections/

Homework

Homework

Complete the quiz on QuizMaster, titled ‘6.2 Data Handling Applications Quiz’

Resources

Note to self for next time – too much content for 1 lesson. Split 2 two lessons.

Add interactive part – sts design their own questionnaire on google forms and get others to fill in?