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 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 & 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

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

Activity 3 - Add a superhero to the Super Hero list.

Please note you can only complete this activity if you are in the classroom using one of Mr west’s tablets.

School Reports

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

  • Attendance reports
  • Student reports

report

Activity 4 - View your exam report on Quizmaster

Log in to quizmaster and have a look at your report on quizmaster.

http://quiz.mr-west.uk

 

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

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

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?