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.
Source: wikipedia CC4
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.
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
Activity 2 -Create your own newsletter with MailPoet
Create a newsletterSociety 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
- 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
School Reports
School Reports
http://www.ictlounge.com/html/data_handling_applications.htm
- Attendance reports
- Student reports
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.
Go to the University of Aberdeen’s website and search through their catalogue. What is the most obscure book you can find?
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?