Exercises

1 State the elements of hardware that make up a microcomputer system. Give examples of each element.

2 Briefly describe the four generations of computer hardware, with an example from each generation.

3 Give three examples of 8 bit microcomputers.

4 What are the main factors attributed to the success of the IBM PC?

5 What is the main difference between hardware and software? Give an example of microcomputer hardware and software.

6 Categorise the following items as either operating system software or application software a) Windows 98

b) Windows 3.1

e) WordPad f) Access g) Delphi

7 What is the difference between machine code and an assembler programming language?

8 What is the difference between a high-level and low-level programming language.

9 Give an example of a third-generation language and a fourth-generation language.

10 What is a fifth-generation programming language? Give an example.

11 Why was the fourth-generation language Basic regarded as anathema to the acquisition of structured programming skills?

12 What is the difference between a compiler and an interpreter? Give an example of a high-level language that is compiled and one that is interpreted.

13 What is the difference between VB and VBA?

14 What is the difference between a third- and a fourth-generation language? Give an example of each.

2 Recorded Excel macros

Introduction 24

The problem scenario 25

Creating a new macro 27

Working with macros 33

Macros for Excel charts 36

The Visual Basic toolbar 39

Macro security issues 40

Exercises 41

0 0

Post a comment