Mr Mark's ICT Website
  • Home
  • Primary
    • Class Rules
    • Grade 3 >
      • Starting with Searches
      • Exploring Programming Quizzes
      • Exploring Multimedia
      • Introduction to CAD design >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
        • Lesson 6
        • Lesson 7
      • Developing Game Design >
        • 3B1
        • 3B2
        • 3B3
      • It’s Cool To Be Kind
      • Online Safety >
        • What is Cyberbullying?
        • To buy or not to buy
        • Keep it to yourself
        • E-mailing
        • Online Communication
    • Grade 4 >
      • Exploring Documents
      • Exploring Spreadsheets
      • Exploring Programming/ Scratch
      • Exploring Images >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
        • Lesson 6
        • Lesson 7
      • Exploring Programming/ Scratch Snake Game >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
      • Don’t Fall For Fakes
      • Online Safety >
        • Cyber Bullying
        • Super Searchers
    • Grade 5 >
      • Multimedia for a Purpose
      • Programming for a Purpose/ Scratch Quest Game
      • Exploring CAD design >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
      • Video for a Purpose >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
        • Lesson 6
        • Lesson 7
      • Website Design for a Purpose
      • Online Safety
  • Secondary
    • ICT >
      • Grades >
        • Grade 6 >
          • Spreadsheets
          • Coding
          • E-Safety
          • Computer Animation
          • Video Editing
        • Grade 7 >
          • Databases
          • Computer Peripherals
          • Computer Hardware
          • Image Editing
          • Flash Animation
          • Computer Animation
          • 3D Design
        • Grade 8
    • iGCSE >
      • iGCSE ICT NOTES
      • Types and components of computer systems
      • Input and output devices
      • Storage devices and media
      • Networks and the effects of using them
      • The effects of using IT >
        • Employment
        • Working Patterns
        • Microprocessors in the Home
        • Health Problems
      • ICT applications >
        • Communication Applications
        • Data Handling Applications
        • Measurement Applications
        • Microprocessors
        • Modeling Applications
        • Applications in Manufacturing
        • School Management Systems
        • Booking Systems
        • Banking Applications
        • Medical Applications
        • Library Applications
        • Expert Systems
        • Retail Applications
        • Recognition Systems
        • Monitoring & Tracking
        • Satellite Systems
      • The systems life cycle
      • Exam Paper 1
      • Exam Paper 2
      • Exam Paper 3
      • Website authoring
  • Contact
  • Home
  • Primary
    • Class Rules
    • Grade 3 >
      • Starting with Searches
      • Exploring Programming Quizzes
      • Exploring Multimedia
      • Introduction to CAD design >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
        • Lesson 6
        • Lesson 7
      • Developing Game Design >
        • 3B1
        • 3B2
        • 3B3
      • It’s Cool To Be Kind
      • Online Safety >
        • What is Cyberbullying?
        • To buy or not to buy
        • Keep it to yourself
        • E-mailing
        • Online Communication
    • Grade 4 >
      • Exploring Documents
      • Exploring Spreadsheets
      • Exploring Programming/ Scratch
      • Exploring Images >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
        • Lesson 6
        • Lesson 7
      • Exploring Programming/ Scratch Snake Game >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
      • Don’t Fall For Fakes
      • Online Safety >
        • Cyber Bullying
        • Super Searchers
    • Grade 5 >
      • Multimedia for a Purpose
      • Programming for a Purpose/ Scratch Quest Game
      • Exploring CAD design >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
      • Video for a Purpose >
        • Lesson 1
        • Lesson 2
        • Lesson 3
        • Lesson 4
        • Lesson 5
        • Lesson 6
        • Lesson 7
      • Website Design for a Purpose
      • Online Safety
  • Secondary
    • ICT >
      • Grades >
        • Grade 6 >
          • Spreadsheets
          • Coding
          • E-Safety
          • Computer Animation
          • Video Editing
        • Grade 7 >
          • Databases
          • Computer Peripherals
          • Computer Hardware
          • Image Editing
          • Flash Animation
          • Computer Animation
          • 3D Design
        • Grade 8
    • iGCSE >
      • iGCSE ICT NOTES
      • Types and components of computer systems
      • Input and output devices
      • Storage devices and media
      • Networks and the effects of using them
      • The effects of using IT >
        • Employment
        • Working Patterns
        • Microprocessors in the Home
        • Health Problems
      • ICT applications >
        • Communication Applications
        • Data Handling Applications
        • Measurement Applications
        • Microprocessors
        • Modeling Applications
        • Applications in Manufacturing
        • School Management Systems
        • Booking Systems
        • Banking Applications
        • Medical Applications
        • Library Applications
        • Expert Systems
        • Retail Applications
        • Recognition Systems
        • Monitoring & Tracking
        • Satellite Systems
      • The systems life cycle
      • Exam Paper 1
      • Exam Paper 2
      • Exam Paper 3
      • Website authoring
  • Contact
Search by typing & pressing enter

YOUR CART

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.

Picture

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

Picture

ICT has allowed the following improvements to mailing lists:

Automated subscribe and unsubscribe systems

Automated mass mailing via email to subscribers


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)

Picture

​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

Picture

School Reports

A school would typically keep data on student academic performance in a computerised database.

This would allow the school to easily track how students were doing as the year progressed, as well as making the creation of printed reports very easy (compared to hand writing every report)

​A typical school report database might contain:
Pupil information (name, contact details, etc.)
Staff information (name, bank details for pay, etc.)
Timetable (rooms, times, subject, staff, classes, etc.)
Pupil attainment (marks, grades, comments, etc.)
Pupil behaviour (dates, incidents, notes, etc.)
Administration data (letters, forms, etc.)
Financial records (wages, fees, etc.)
​Exam entries (times, dates, pupils, results, etc.)

Picture

Rather than use lots of different systems to manage this information, many schools use a School Management System (sometimes called a School Information System, or SIS). This is a system that manages all of a school's data in a single, integrated application.

Picture

Having all of the information in a single system allows schools to more easily connect data together.

For example, when viewing a pupil's record, the user could follow a link to the pupil's class, and from there a link to the pupil's teacher, and from there a link to the teacher's other classes, and so on.
​

​These connections between sets of data allow complex tasks to easily be performed such as:
Sending letters to all parents of pupils who scored below 50% in their last English test Printing personalised timetables for IGCSE pupils (even though they have all chosen different options) Monitoring the progress of pupils in multiple subjects, over a number of years


Library Systems

Libraries often contain many thousands of books, magazines, CD-ROMs, etc. In fact, some of the largest libraries (e.g. The British Library in the UK) contain well over 100 million items - that's a lot of things to keep track of!

For this reason, libraries use computer-based systems to keep a record of their books, and of the people who borrow the books.

Picture

A computerised library database allows for:
Quick and easy searching for books
Easy printing out of book lists / labels
Easy tracking of book loans (who has it, when it was borrowed, etc.)
Automatic printing of warning letters for borrowers who have not returned books

International Standard Book Number (ISBN)
Every published book has an International Standard Book Number (ISBN).

The ISBN is typically printed on the back of the book in numeric form, and as a barcode (to allow for quick data entry)

The Book Database
A typical library book database might contain:

Book ID (number / text)
Title (text) Author (text)
Publisher (text)
ISBN (number)
Fiction / non-fiction (boolean)
Genre / category (text)
Cost (number)
​Date of purchase (date)

Picture

The Borrower Database
A typical library borrower database might contain:

Borrower ID (number / text)
Name (text) ​
Phone number (text)
Address (text)
E-mail address (text)
Date of birth (date)

Picture
Picture