Past Paper Monday 23rd May 2011 - Morning Flashcards
State what is meant by a storage device? (1)
Storage: device used to store data (in binary format
for processing later).
State what is meant by a Input Device? (1)
Input: device used to enter data into the computer.
State what is meant by a Output Device? (1)
Output: device used to present information/the result
of processing to the user.
Which storage technique would be most suitable for handheld device used by students for field work, and why? (2)
- Solid state.
- Quick access (for instant on)/not sensitive to being
moved around while used.
Which storage technique would be most suitable for storage drives on the school’s main file server, and why? (2)
- Magnetic.
- Very Large capacity/relatively cheap.
Which storage technique would be most suitable for videos of the school production to be given to parents, and why? (2)
- Optical
- Cheap/Portable/Universally readable by a most
computers and dedicated video disc players.
The school wants the computer system to be more accessible to students with disabilities. Describe, with examples, input and output devices which are available for students with disabilities. (6)
Input devices:
- Puff-suck switch: allows mobility impaired users to
control eg clicking a mouse, by sucking or blowing
through a tube.
- Simplified/concept keyboards eg for Braille, or larger
keys.
- Eye tracking input – Camera is used to follow the
users eye movements and use these to control eg
movement of mouse on screen.
Output device:
- Braille printer – print documents on paper in braille as
raised bumps. Some braillers have plastic bumps
which can be raised or lowered by software, so output
does not have to be on paper.
- Text to speech.
- Screen magnifiers.
A shop uses a database with a DBMS to keep records of its stock. Explain what is meant by a DBMS? (3)
- A Database Management System/Used to manage the database.
- May use SQL/allows database to be queried.
- Provides facilities for creating tables/inserting data/viewing data/reporting.
- Allows data structure to be independent of the program.
- Allows relationships to be created between tables/Maintains integrity.
- Provides security features/levels of access.
Describe a ‘Form’ and give one example of how it would be used in the shop’s database. (3)
Form: (2)
- An input screen.
- Allowing chosen data items to be displayed and edited.
- Uses texboxes/drop down lists/checkboxes etc…
- When edited, the changes are updated in the database
Example: (1)
- Suitable example from shop eg enter new products.
Describe a ‘Report’ and give one example of how it would be used in the shop’s database. (3)
Report: (2)
- An output of the data in a database.
- A snapshot of the data at a given time/when printed.
- Of specified fields/Laid out in a specified format.
- Aggregates may be calculated and displayed.
Example: (1)
- Suitable example from shop eg weekly sales.
Describe HTML? (2)
- HyperText Mark-up Language.
- Text file containing the text to be displayed…
- … uses tags which indicate how to display it.
- … location of pictures/other elements to include.
- … and hyperlinks to other locations/URLS.
Explain the importance of HTML in the creation of web pages? (2)
- Web browser used to interpret the file and display the data correctly.
- Because it is an open/accepted standard…
- … data will display correctly on all browsers.
- … which conform to the standard.
What file format would be used to store a high resolution image as a desktop background? (1)
JPG
What file format would be used to store a sheet of music which is ready to be printed in the correct format. (1)
What file format would be used to store a short video extract. (1)
MPEG