Download Engineering Exam: Computer Studies for Maintenance Technology Students and more Exams Computer Science in PDF only on Docsity!
Cork Institute of Technology
Higher Certificate in Engineering in Maintenance Technology Stage 1
(National Certificate in Engineering in Maintenance Engineering – Stage 1)
(NFQ – Level 6)
Summer 2005
Computer Studies
(Time: 3 Hours)
Instructions: Answer any FOUR questions. All questions carry equal marks. Save all files to the floppy discs supplied. Descriptive answers may be entered into the answer books supplied. Place your name on your disk & save a copy of your answers to your student directory on the network.
Examiners: Mr. D. O’Brien Mr. R. Simpson Mr. J Connolly
Q1. MS Word (a) Use MS WORD to reproduce the sketch of the parallel and angular misalignment as illustrated in figure 1. Save this document as MS Word.doc on your floppy disc. Save a copy to your student directory on the network. Q1 (a) and (b) may be completed in the same document. (15 marks)
(b) Inadequate compressed air pressure in a plant lead to the undertaking of a study. Readings from 10 pressure indicators were taken over a three-day period. The results are shown in table 1 beneath. Reproduce this table in MS Word. (10 marks) Table 1: Compressed Air Line Pressure Indicator Readings (barg).
Day 1 Day 2 Day 3 PI 1 6.5 6.3 5. PI 2 7.2 7.3 7. PI 3 7.1^ 6.9^ 6. PI 4 6.9 6.4 6. PI 5 6.5 6.9 6. PI 6 6.9^ 6.7^ 6. PI 7 6.5 6.3 6. PI 8 6.1 5.9 6. PI 9 6.8^ 6.9^ 6. PI 10 6.7 6.5 6.
Q2. (^) MS Excel
Table 2 beneath shows the pressure readings taken seven times in one day from five pressure gauges on a steam line within a facility.
Table 2. Steam Line Pressure Readings.
(a) Replicate the above table in a new workbook in Excel. Save this new workbook as “ Steam Pressure.xls ” on your floppy disc and in your directory on the network. (4 marks)
PI 1 (bar) PI 2 (bar) PI 3 (bar) PI 4 (bar) PI 5 (bar) Set 1 2.5 3.5 6.5 4.8 6. Set 2 6.5 6.5 4.5 5.6 4. Set 3 9 7 5.5 5.5 5. Set 4 5 6 9 6.8 6. Set 5 3.5 9.3 6.5 6.5 6. Set 6 4.8 6.4 5.6 6.1 6. Set 7 5.0 6.8 6.2 5.8 5.
Q3. MS Access
The mechanical seals on certain glass-lined vessels in a plant are to be replaced. Glass Lined Vessel Details and Replacement Dates & Assigned Fitters are shown in Table 4 & 5.
(a) Create a new database and save as Mechanical Seal.mdb on your floppy disc. Reproduce
these two tables using Forms in Access. When completed, copy Mechanical Seals.mdb to your student directory on the network. (15 marks)
(b) Define the relevant table Relationships and Run a Query ( entitled Motor Power ) that will select only the vessels with 1.5kW motors from the following headings: Vessel ID No, kW, Impeller Type, Agitator Mechanical Seal Replacement Date & Assigned Fitter. (5 marks) (c) Generate a Report ( entitled Assigned Fitter ) based on the above information. (5 marks)
Table 4. Glass Lined Reactor Details.
Vessel ID No. (^) Capacity (litre) Working Pressure (barg)
Max Temp (^0 C)
kW Impeller type
R-100-GL (^500) FV to 2 177 1.5 3-blade retreat curve R-101-GL (^500) FV to 1 177 1.5 3-blade retreat curve
R-200-GL (^1000) FV to 7 343 1.5 3-blade retreat curve
R-203-GL (^1000) FV to 6 260 1.5 (^) 3-blade retreat curve
R-500-GL (^2500) FV to 7 232 5.5 3-blade retreat curve R-501-GL (^2500) FV to 7 232 5.5 4-blade curved turbine
R-502-GL (^2500) FV to 7 232 5.5 3-blade retreat curve
R-1000-GL (^4500) FV to 3 177 7.5 (^) 3-blade retreat curve
Table 5. Replacement Dates & Assigned Fitters.
Vessel ID No. (^) Agitator
Mechanical Seal Replacement Date
Assigned Fitters
R-100-GL 15/06/05 (^) Tom Murphy, Pat Whelan R-101-GL 15/06/05 (^) Robert Dillon, Tadgh
McCarthy
R-200-GL 15/06/05 Ray O’Connor,
Paul Whelton R-203-GL 13/07/05 (^) Tom Murphy, Pat Whelan R-500-GL (^) 13/07/05 Robert Dillon, Tadgh McCarthy R-501-GL (^) 13/07/05 Ray O’Connor,
Paul Whelton R-502-GL (^) 20/07/05 Tom Murphy, Pat Whelan R-1000-GL 20/07/05 (^) Robert Dillon, Tadgh McCarthy
