Characteristics of Standard Applications Software and Application Areas Flashcards
What is a word processor?
A generic applications package that allows the entry, editing and formatting of text to create a range of documents.
Give 3 examples of documents created in a word processor?
Letters, memos and reports.
What does WYSIWYG stand for?
What you see is what you get. This means that the user can be sure the screen layout will match the printed layout. Most word processing packages have this.
What is a desktop publishing package?
This allows users to combine images and text to create publications.
Give 4 examples of publications made with a desktop publisher.
Flyers, brochures, posters, business cards.
What is a spreadsheet package?
Spreadsheet packages enable the user to produce both mathematical and financial models, and to produce graphs to represent the data. They process data and can perform a lot of calculations so are mostly used for processing numerical data.
Can a spreadsheet handle text?
Yes.
What does a database package do?
Database packages enable the user to handle data, such as sorting and searching. The data can be split into tables and relationships, created between the tables to allow the data to be joined together.
What does a web authoring package do?
You can create websites in this OR even in a word processor if you convert the document to a web page. Some training will be needed to use this sort of software.
How are web authoring packages used?
Web pages are visual representations of code, generally HTML. Most web authoring packages do not require the user to write any code as pages are created using a graphical interface. It is then possible to edit the code to perfect it, if you know how.
Most web authoring software packages offer formatting facilities such as:
Colour options for background, text, lines and boxes. Font size/style. The positioning of objects and layout of items such as tables.
What does HTML stand for?
Hypertext Mark-up Language
What are the advantages of creating a website using web authoring software?
The exact effects required can be developed/ There are wizards for specific tasks. WYSIWYG. A site manager can be used.
What are the disadvantages of creating a website using web authoring software?
Some degree of knowledge and technical ability are required as not all concepts from word processing will apply. And it’s often more expensive to purchase than a standard applications package.
What are the advantages of creating a website using standard application software? (Such as a word processor)
Very little technical knowledge is required. If a standard word processor can be used then a web page can be easily created. And it is likely the user already has a standard applications package so no extra cost on software.
What are the disadvantages of creating a website using standard application software? (Such as a word processor)
It is very difficult to get the page to look exactly how you want. It’s not WYSIWYG. The code is messy and often not compatible with all browsers. Likely to be no site management or uploading tool.
What is presentation software?
Can be used to produce presentations to be shown on printed acetate or a computer and projector, to an audience. Good for presentations for speeches. You can set timers on them to run automatically without user interaction.
Describe some features of a school administration system.
Systems used within schools and colleges to assist in the day to day running of the establishment.
What are three features of a school administration system?
A database to hold records, a facility to record students marks and an attendance monitoring facility.
What must the database within a school administrations system do?
Be able to store students’ personal details such as next of kin, doctor, mode of transport to school and also give a unique identification number, a UPN (Unique pupil number).
What must the facility to record students marks within a school administrations systems do?
This must record subject marks against students, store historical data against the student and be able to prepare reports based on students results.
What must an attendance monitoring facility within a school administrations system do?
The system must be able to record student attendance, absence and type of absence. Summarise their attendance. Produce lists of outstanding absences and produce required averages for school documentation.
What is a stock control system?
A system that knows how much of each item is in stock, when orders are due and how much stock is required on certain days. It can sometimes order stock and update stock records when the stock is delivered.
What is JIT ordering in a stock control system?
Just in time ordering. This means that the stock held is being kept to a minimum and materials are delivered on the day/day before. This is so the profit is spent on more stock.
Who are the two main users of a stock control system?
Shops and manufacturers.
Describe shop stock control systems.
Shops try to keep their shelves stocked but they do not want too much. Stock control systems for the shops need to be linked to the sales system to try to identify trends. They need to know of special offers that may increase sales.
Describe the manufacturing stock control systems.
They need to know all of the components required to create a product. They are linked into the ordering system so they can see how much stock they require to meet demand.
What 6 things must the manufacturing stock control system have?
Have a list of all stock items and suppliers, a list of all components for the item if the stock is manufactured, know the minimum and maximum stock levels, be able to work out how much to order, have links to the orders database and update the stock records when deliveries are received.
What are booking systems?
Many things can be booked like train tickets, show tickets or doctor’s appointments. Booking systems are a way of doing this.
What are the three main ways of using a booking system?
The telephone, the internet or by person/post/fax. Booking through the internet is the most popular.
What must a booking system allow a user to do?
Select a time and date, select an event, specify numbers (adults, children), check availability, check price, change options, confirm and pay.