Introduction to Information and Computers (ICTS) (GSDR2111)
Higher Institute of Transport and Logistics (HITL)
Semester: First Semester
Level: 200
Year: 2017
School/Faculty: HITL DEPARTMENT: General Studies LECTURER(S): Dr. DADA Jean-Paul
Option: All options SEMESTER: Exams Academic Year: 2016/2017
COURSE CODE: TLGS1111 COURSE TITLE: Transport and Sustainable Development
DATE: 2017 HALL: …………… TIME: 2 hours
Instructions: Answer all questions.
THE UNIVERSITY OF BAMENDA
P.O BOX 39 Bambili
REPUBLIC OF CAMEROON
Peace-Work-Fatherland
0 .
. 17 0
r.
Exercise 1: Let consider the figures (12 marks):
1) What can you do with those two materials? (2 marks)
2) Name each material (4 marks)
3) The material (A) has 3.845GB available memory while (B) has 1.44 MB. How many
(B) materials can contain the same data as one (A) material? (6 marks)
Exercise 2 (18 marks): A hard disk has 40GB as capacity. You want to save in this hard
disk folders named: My courses (4,5Go); my images (27Go); my documents (7Go); my
music (15Go); my photos (20Go).
1) Give two lists of folders to register with at least three folders. (6 marks)
2) Give two lists of folders you can not to register in this hard disk. (6 marks)
3) What association of folders will occupy maximum space in this hard disk? (3 marks)
4) What association of two folders will occupy maximum space in this hard disk?(3
marks)
Exercise 3: (25 marks). Let us consider the table below giving some computer
characteristic
Type
Screen
RAM
HDD
OS
Webcam
Bluetooth
Wifi
A Dual Core
1024*768
pixels
2GB 360GB Windows 7 Yes Yes Yes
B
Core 2 Duo
1024*768
pixels
4GB 500GB Windows 8 Yes Yes Yes
C PIV
940*768
pixels
512MB . 40GB
Windows XP
SP3
No No No
D 13
1024*768
pixels
4GB 500GB Windows 8 Yes Yes Yes
E
15
1024*768
pixels
4GB 1000GB Windows 8 Yes Yes Yes
www.schoolfaqs.net
1) List two things you can you do with WIFI in a computer? (4 marks)
2) Give the importance of RAM, Webcam, HDD and OS (6 marks)
3) What is the meaning of 1024*768 pixels? (2 marks)
4) You want to buy a computer to help an enterprise in charge of transport, hat is
the cheapest computer to be bought only for office automation? Why? (2 marks)
5) The company wants to track the position, at each moment, of many engines
around the country, using GPS. What computer can you suggest to this enterprise?
Why? (2 marks)
6) A computer is designed for Windows 7 and you install Windows 8 inside. List three
consequences t. computer will have. (3 marks)
7) A company in charge of logistics in maritime port wants to buy computers. What can
you suggest to this enterprise since it will be using a scanner and many files are to be
stored per day? Why? (3 marks)
8) What computer can you buy if the task given is just to manage student marks? Why? (3
marks)
Exercise 4: Spreadsheet (15 marks). Let us consider the figure below:
1. Let us take T as the total for entries and X, the interest of Christoffel member. Give the
relation between T, X, 30000F and 4250F (3 marks)
2. Give the formula to be used to fill cells C IO, D5 and E5 (6 marks)
3. What is the difference between relative and absolute reference? (2 marks)
4. Give one difference between relative and absolute references (2 marks)
5. What can you do to copy D5 formula to the other cells of the same column
automatically (without retyping formulas)? (2 marks).
www.schoolfaqs.net
