

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Instructions and questions for a higher certificate in science in computing in information technology - support exam. The exam covers computer crime, data types and sizes, and database and spreadsheet creation and queries. Students are required to answer questions related to computer crime prevention, data sizes, and database and spreadsheet setup and queries. The exam consists of multiple-choice and database query questions.
Typology: Exams
1 / 3
This page cannot be seen from the preview
Don't miss anything!
Examiners: Mr. J. Greenslade Mr. J. Walsh Ms. S. Flannery
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)
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;
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;
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)