Download Formula Bar - Computer Applications - Past Exam and more Exams Computer Applications in PDF only on Docsity!
Cork Institute of Technology
Higher Certificate in Science in Computing in Information Technology
Support – Stage 1
(NFQ Level 6)
Autumn 2006
Computer Applications
(Time: 2 Hours)
Examiners: Mr. J. Greenslade Mr. J. Walsh Ms. S. Flannery
INSTRUCTIONS
Answer Q1 or Q2 before attempting any other question. You must hand up Q1 or Q2 to your supervisor before logging onto your computer.
Questions 3 and 4 must be attempted. You will be supplied with a floppy disk. Ensure your name appears on each assignment and on your floppy disk before handing to your supervisor.
The examination consists of Q1 or Q2 - theory 20 marks Q3 - Access – Database 40 marks Q4 - Excel – Spreadsheet 40 marks
Q1 (a) Write a short essay on current trends in information technology;
(b) Write a paragraph on each of the following terms associated with Excel, explaining what each is and the use of each in computer applications;
(i) If function (ii) Formula bar (iii) Protection of the sheet
OR
Q2 (a) Write an essay on input devices
(b) Write a paragraph on each of the following terms associated with Access, explaining what each is and the use of each in computer applications;
(i) Table (ii) Query (iii) Primary key
Q3 The following is an Access Database exercise. Name this database “Vineyards”.
“Vineyards” contains statistical information on various wine producers. The information held on each vineyard is as follows:-
- Vineyard Name –Name of vineyard
- Country of Origin – Country in which vineyard is registered
- Number International Awards – number of worldwide awards
- World Ranking – highest ever position in world placings
- Marketing Agent – name of Marketing Agent
- Irish Market Success? – whether or not vineyard has been successful in Ireland
- Average Annual Earnings –current earnings from sales in Ireland each year
Set up a database table holding the details on the ten vineyards listed below. You can use the italicized words given above as field names but you must decide on the relevant data type for each field.
Vineyard Name Country of Origin
No International Awards
World Ranking
Marketing Agent Irish Market Success?
Average Annual Earnings €m Grape Valley Australia 182 3 P & M Wine Agents Y €5. Wine Galore Australia 98 47 Island Link Inc N €0. Le Vinequin France 173 1 Expert Transfer Ltd N €4. Blue Mountain Vines Australia^138
Wine Casket Hauliers N^ €3. Chateau Blanc France 111 8 Lanomne Inc Y €3. Malaga Fine Wines Spain^109 1 Universal^ Y^ €5. Chateau de Coup France 544 1 Rapid Routers Y €12. Tuscany Grapes Italy 87 49 Atlantic Transfers N €1. Brisbane Winery Australia 698 1 Mercury Movers Y €23. Appleton Vineyard Australia^1476 1 Expert Transfer Ltd^ Y^ €26.
1 Save the table as “WineStats” and carry out the following tasks;
EACH QUERY SHOULD BE SAVED AS FOLLOWS; Query number and your initials e.g. if your name is John Smith and you are saving query1, it will be saved as Query1JS
Set up and save a query showing all details of vineyards:- 2 Whose first name begins with “B” (Query1) 3 Who hail from France (Query2) 4 Display the vineyards which have won 500 or more international awards (Query3) Set up and save a query which:- 5 sorts the table “WineStats” into ascending order based on “Country of Origin” and descending order based on “No International Awards” (Query4) Set up and save a query from the Query4 file displaying only:- 6 the Vineyard Name, Country of Origin and Marketing Agent of artists who hail from either France OR Australia and whose average annual earnings equal or exceed €5m (Query5) Set up and save a query which:- 7 Searches through the Query4 file for the character sequence “lan” under Marketing Agent name and displays the results in descending order according to world ranking (Query6) Set up and save a query from the “WineStats” table displaying only:- 8 the Vineyard Name, Country of Origin, World Ranking, for all vineyards that have had Irish market success, have average annual earnings in excess of €5m but who have won less than 1000 international awards (Query7)
