Download Computer Exam: Higher Cert in Computing - IT Support 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)
(Spring)
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) Define the term “computer crime” ( 4 marks)
(b) Describe four types of computer crime and discuss possible computer crime-prevention techniques (16 marks)
OR
Q2 (a) How many bits are there (i) in a kilobyte? (ii) in a gigabyte? (iii) in a megabyte? (6 marks)
(b) The systems development life cycle is a sequence of steps followed by a project team. Describe, in detail, each of these steps (14 marks)
Q3 The following is an Access Database exercise. Ensure that, upon creating the database initially, you save it onto your floppy disk. Call the database Zipadee Doo Dah Takeaway Food Company. Marks will be lost if you have not saved correctly, as instructed, or if nothing shows up on your diskette.
Zipadee Doo Dah Takeaway Food Company, established in 1999, supplies high-quality takeaway dishes to homes all over Cork.. Eight items of information are held on each order received. Walt Preston, manager of the business, wishes to transfer these order details to a computer database file;
The information held on each order is as follows;
- Customer – Customer’s Name
- Address – Customer’s Address
- Time – Time of Order
- Distance – distance in miles from shop
- Dish – Name of dish
- Size – large (L), medium (M) or small (S)
- Price – the Price of the dish ordered
- Delivery – whether or not the dish was delivered (Y or N)
Set up a database table on your computer, holding the details on the ten customers 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.
Surname First Name Address Time Distance Dish Size Price Delivery Deasy George 17 Russell Ave^ 18:33^6 Pork Steak^ L^ £10.15^ Y Finlay Aileen 2 Kinkalla Road^ 17:51^10 Burger Steak^ L^ £6.20^ Y Bradley Joseph Elkhound Drive^ 18:55^4 Chicken Pasta^ S^ £6.50^ N Allen Kieran Hilltip Crescent^ 18:03^9 Crispy Cod^ L^ £8.55^ Y Evans Robert 108 The Wood^ 18:24^2 Chicken Hearty^ M^ £6.55^ Y Barber Anne 45 Church Hill^ 17:46^13 Beef Stew^ M^ £8.90^ N Gannon Susan 43 Luddock Ave^ 18:15^7 Chicken Kebab^ S^ £5.80^ Y Deasy Kieran 195 Kinkalla Road^ 16:40^6 Sirloin Steak^ L^ £13.25^ Y Kiernan Brian 1 Rose Crescent^ 17:05^10 Loin of Lamb^ S^ £5.25^ N Curran Kieran “The Acre”, Glenmill^ 18:37^5 Sweet & Sour Pork^ S^ £4.25^ Y Hobbs Greg “Camella”, Risbrook^ 17:30^5 Quiche Salad^ L^ £7.20^ N Keats Aileen 28 Kinkalla Road^ 16:51^11 Burger Steak^ M^ £3.85^ Y
1 Save the table as SUNDAYORDERS and carry out the following tasks;
EACH QUERY SHOULD BE SAVED AS FOLLOWS;
Querynumber and your initials e.g. if your name is John Smith and you are saving query1, it will be saved as Query1JS (3 marks)
Set up and save a query showing all details of orders which: 2 Were medium sized (Query1) (3 marks) 3 Were large sized and less than 10 miles from the shop (Query2) (4 marks) 4 Were small sized and delivered before 18:30 hrs (Query3) (4 marks) Set up and save a query which: 5 sorts the table SUNDAYORDERS into ascending alphabetical order using size as a primary sort, customer surname as a secondary sort and first name as a final sort (Query4) (6 marks) Set up and save a query from the Query4 file displaying only: 6 the customer surname, first name, address, type, size and price of dishes which were not delivered (Query5) (6 marks) Set up and save a query showing all details of orders by: 7 customers who live on Kinkalla Road (Query6) (6 marks) Set up and save a query from the SUNDAYORDERS table displaying only: 8 the customer surname, first name, address, name of dish, size of dish, and delivery status of all dishes worth more than £7.00, delivered before 18:00 hrs to customers located more than 5 miles from the shop (Query7) (8 marks)
