computer applications questions

Q1. i. Explain the uses of presentation soft wares  in marketing

ii. Explain the terms virtual reality and artificial intelligence and state where each is applied

Describe the application of artificial intelligence in lifts, industry, schools, hotels,stock exchange and Motherboard assembly.

iii. Describe the merits of a computerized inventory system

iv. Describe the methods of making reservations in a computerized reservation system

v. outline the components of electronics point of sale terminal

Q2. i. define the term ergonomics and describe its application

ii. Distinguish between www, workgroups and expert system

iii. explain  computer aided learning and computer managed learning

iv.  types of software

v. computer hardware

vi application of video conferencing and teleconferencing

vii. Application of computers in the society

viii. office automation and its various applications in an office

Q3. Spread sheet.

1. Cell content formatting/various formatting and editing features in ms excel
2. Explain the procedure of Creating a chart
3. Inserting cells, columns and rows
4. Working with data from different worksheets
5. Errors in excel
6. Cell referencing, mixed, absolute an d relative and their application
7. Applications of formula and functions. From the most basic to the most complex

Q4 word processing

1. Formatting and editing features
2. Creation of charts
3. Creation of columns and inserting objects
4. Mail merge
5. Typing modes

Q5. Database

1. Data base structures/models
2. Merits and demerits of database systems
3. Uses of query in a database
4. Report generation in data base
5. Application of macro, their merits and demerits
6. Attributes in data base
7. Filtering of data
8. Creation of forms

Q6. Distinguish between

1. Orthographic projection and pictorial projections
2. Detailed drawing and combined drawing
3. Decorative and artificial type face
4. Linked object and embedded object
5. Electronic data interchange and enterprise resource planning

Q7. i. describe the various health issues associated with use of computers

and appropriate remedy for each

ii. Computer security

iii. Computer networks, types, categories, topologies, merits and demerits, communication medium, the internet, its application

and installation

iv. Internet and email window and their various components

6. application of computers in the society