Revision Questions sorted to Chapter 25 (and all remaining) Stephen Doyle "Information Systems for You"

Applications * Software * Spreadsheet * Office

What is a spreadsheet? Who will use it?

A spreadsheet is a program that allows to enter data (in so-called "CELLS") and give you the option of doing all kinds of calculations automatically (after filling in some formulas). The first spreadsheet was Lotus-123, nowadays most people use Excel (from Microsoft). * Essential for spreadsheets is also, that they allow to create visual (colorful) CHARTS and GRAPHS of your calculations and results. * * People who make use of a spreadsheet: * - bookkeepers (do calculations, budgeting) * - teachers (to calculate grades) * - bankers (to do calculations about rent, mortgages etc.)

Control Systems * Hardware * Input Devices * Programming * Pseudo-Code * Algorithms

The oxygen content and temperature in a fish tank have to be controlled. * * (a) Write an algorithm to achieve this. * (b) State six items of hardware, other than the processor, that the system must contain.

Hardware * Input Devices * Output Data

What is DTP?

Desktop publishing (DTP) is the process of creating printed documents that look professionally produced, using page layout software running on a personal computer, along with a high-quality, yet affordable, printer. * To publish something with the traditional method, you would send typed or handwritten text to a typesetter, who would turn it into typeset text called "galleys," which took a couple of days. If there were corrections, it took another couple of days to get those back. If you didn't know how to lay out the pages yourself, you'd take the galleys to a print shop, along with your art (illustrations and photographs). The people there would cut up the galleys with scissors and paste the pieces onto the pages along with the artwork. If something needed to be changed on the finished "paste-up" or "mechanical," it would be possible, but a lengthy and expensive process. Finally, the print shop would reproduce the document in quantity. Instead, you might pay a graphic designer to take the project from conception to completion, and the designer would go through this process, creating the mechanical herself and taking it to the print shop to be reproduced. * * With desktop publishing, by contrast, you can create the entire document sitting at your own desk. You can think of the page layout software and the computer as the typesetting and layout area, and the laser printer as the printing press. You proof the project on your own printer; if it isn't right, you just turn back to your computer, make the changes, and print it again.

Input Devices * Output Devices

Give two distinctive features of a computer system needed to do CAD

Can do 3D usually. * Can show high resolution (small details) * Shows exact measurements * Allows changes in the model