Download Interoperability - Computer Applications - Past Exam and more Exams Computer Applications in PDF only on Docsity!
Cork Institute of Technology
Higher Certificate in Computing in Information Technology
Support - Stage 1
(NFQ – Level 6)
Spring 2006
Computer Applications
(Time: 2 Hours)
Examiners: Mr. J. Greenslade Ms. S. Flannery Dr. D. O’Maidin
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 SPAM;
(b) Write a paragraph on each of the following terms associated with the Internet
(i) Interoperability (ii) FTP (iii) Usenet
OR
Q2 (a) Write an essay on the life of Grace Murray
(b) (i) Explain the difference between RAM and ROM. Why are both types of memory used in a computer? (ii) What elements affect the performance of a computer system? How?
Q3 The following is an Access Database exercise. Name this database “PopMusic”.
“PopMusic” contains statistical information on various pop artists. The information held on each artist/band is as follows:-
- Artist Name – Performer name
- (^) Country of Origin – Performer nationality
- Number International Awards – number of worldwide awards
- Highest UK Chart Place – highest ever spot reached in UK pop charts
- Record Company – name of artists’ record company
- US Chart Success? – whether or not artist has hit the US pop charts
- Average Annual Earnings –current earnings from royalties each year
Set up a database holding the details on the ten artists 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.
Artist Name Country of Origin
No. International Awards
Highest UK Chart Place
Record Company US Chart Success?
Average Annual Earnings €m
Coldplay England^182 3 Parlophone^ Y^ 6.
Pulp England 98 47 Island Records N 0.
The Corrs Ireland^173 1 EMI^ N^ 4.
Travis England 138 5 Plant N 3.
The Cranberries Ireland^111 8 A&R^ Y^ 3.
Enrique Iglesias Spain^109 1 Universal^ Y^ 5.
Westlife Ireland 544 1 RCA Y 12.
Paolo Conte Italy^87 49 Atlantic^ N^ 1.
Elton John England 698 1 Mercury Y 23.
Paul McCartney England^1476 1 EMI^ Y^ 26.
1 Save the table as “MusicStats” 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 artists:- 2 Whose first name begins with “P” (Query1) 3 Who hail from Ireland (Query2) 4 Display the artists who have won 500 or more international awards (Query3) Set up and save a query which:- 5 sorts the table “MusicStats” 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 artist name, country of origin, record company of artists who hail from either Ireland or England and where a verage 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 record company name and displays the results in descending order according to highest UK chart placing (Query6) Set up and save a query from the “MusicStats” table displaying only:- 8 the artist name, country of origin, highest UK chart place, for all artists who have had US success, have average annual earnings in excess of €5m but who have won less than 500 international awards (Query7)
- Implement spreadsheet protection so that data can only be entered in the following cells
- use the password protect
- A
- A
- A11:B
- B5:B and so that formulas and functions are not displayed in the formula bar
- (^) Save the spreadsheet to your folder naming the file INVOICE
