Qatar University
Foundation Program
Math & Computer Department
Computer Placement Test
Name: (First, Father, Family) Computer Student Number: ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ Name of High School:(New students only) Specialty in QU: Engineering □ Date (D/M/Y): ____/_____/200___ Science □ Business Male □ Female
□
□
Others □
Test Lab.: Floppy No.:
Version No.:
Please fill in all the information above. Use the Admission Form of the Computer Placement Test to get your Computer student Number. Check the floppy disk provided for floppy disk number.
Instructions:
1. This test is divided into two sections (Section-I and Section-II). Section-I covers the contents of Computer 1 Course and Section-II covers the contents of Computer 2 Course. أﺳﺌﻠﺔI-(. ﻳﻐﻄﻲ اﻟﺠﺰءII- واﻟﺠﺰءI-ﻳﺘﻀﻤﻦ هﺬا اﻻﺧﺘﺒﺎر ﺟﺰأﻳﻦ )اﻟﺠﺰء أﺳﺌﻠﺔ ﺗﺘﻌﻠﻖ ﺑﻤﻘﺮرII-ﺗﺘﻌﻠﻖ ﺑﻤﺤﺘﻮﻳﺎت ﻣﻘﺮر ﺣﺎﺳﺐ 1، وﻳﻐﻄﻲ اﻟﺠﺰء .2 ﺣﺎﺳﺐ 2. Each Section of this test is out of 100 points, with the passing score of 60 points. اﻟﻌﻼﻣﺔ اﻟﻜﻠﻴﺔ ﻟﻜﻞ ﻣﻦ هﺬﻳﻦ اﻟﺠﺰأﻳﻦ هﻲ 001 ﻧﻘﻄﺔ، وﻋﻼﻣﺔ اﻟﻨﺠﺎح هﻲ .06 ﻧﻘﻄﺔ 3. Partial & full exemption rules:ﻗﻮاﻋﺪ اﻻﻋﻔﺎء اﻟﺠﺰﺋﻲ واﻟﻜﻠﻲ
You will be placed in Computer 1 if your score is less than 60 in part I of the test. .ﺳﺘﺴﺠﻞ ﻓﻲ ﻣﻘﺮر ﺣﺎﺳﺐ 1 إذا آﺎﻧﺖ درﺟﺘﻚ أﻗﻞ ﻣﻦ 06 ﻓﻲ اﻟﺠﺰء اﻷول ﻣﻦ هﺬا اﻻﺧﺘﺒﺎر You will be placed in Computer 2 if your score is 60 or more in part I of the test and less than 60 in part II of the test. ﺳﺘﺴﺠﻞ ﻓﻲ ﻣﻘﺮر ﺣﺎﺳﺐ 2 إذا آﺎﻧ ﺖ درﺟﺘ ﻚ 06 أو أآﺜ ﺮ ﻓ ﻲ اﻟﺠ ﺰء اﻷول ﻣ ﻦ ه ﺬا اﻻﺧﺘﺒ ﺎر .وأﻗﻞ ﻣﻦ 06 ﻓﻲ اﻟﺠﺰء اﻟﺜﺎﻧﻲ ﻣﻨﻪ You will get exempted from Computer 1 & Computer 2 courses if you pass both parts with score of 60 or more. ﺳﺘﻌﻔﻰ ﻣﻦ ﻣﻘﺮري اﻟﺤﺎﺳﺐ 1 & 2 إذا آﺎﻧﺖ درﺟﺘ ﻚ 06 أو أآﺜ ﺮ ﻓ ﻲ اﻟﺠ ﺰأﻳﻦ اﻷول واﻟﺜ ﺎﻧﻲ .ﻣﻦ هﺬا اﻻﺧﺘﺒﺎر
5.
6.
7.
8.
9.
4.
Attention! Part II of this test will not be graded unless you pass Part I of this test (get 60 or better in Part I).
ﻳﺮﺟﻰ اﻻﻧﺘﺒﺎﻩ اﻟﻰ أن اﻟﺠﺰء اﻟﺜﺎﻧﻲ ﻣﻦ هﺬا اﻻﺧﺘﺒﺎر ﻟﻦ ﻳﺼﺤﺢ ﻣﺎﻟﻢ .ﻳﺤﺼﻞ اﻟﻄﺎﻟﺐ ﻋﻠﻰ 06 أو أآﺜﺮ ﻓﻲ اﻟﺠﺰء اﻷول ﻣﻦ ﻧﻔﺲ اﻻﺧﺘﺒﺎر The test duration is 2 hours (120 minutes). No students will be allowed to enter the Test Lab. after 15 minutes from the start of the test and this student will not be given any extra time to complete the test. ﻣﺪة اﻻﺧﺘﺒﺎر ﺳﺎﻋﺘﺎن )021 دﻗﻴﻘﺔ(، وﻟﻦ ﻳﺴﻤﺢ ﻷي ﻃﺎﻟﺐ/ﻃﺎﻟﺒﺔ ﺑﺪﺧﻮل ﻗﺎﻋﺔ اﻻﺧﺘﺒﺎر ﺑﻌﺪ ﻣﺮور 51 دﻗﻴﻘﺔ ﻣﻦ ﺑﺪء اﻻﺧﺘﺒﺎر وﻟﻦ ﻳﻌﻄﻰ ﻟﻬﺬا .اﻟﻄﺎﻟﺐ/اﻟﻄﺎﻟﺒﺔ أي وﻗﺖ اﺿﺎﻓﻲ ﻹﻧﻬﺎء اﻻﺧﺘﺒﺎر Bring your Test Admission Form and a valid photo ID to the test Lab. ﻗﻢ ﺑﺈﺣﻀﺎر آﻞ ﻣﻦ وﺻﻞ اﻟﺘﺴﺠﻴﻞ اﻟﺨﺎص ﺑﺎﻻﺧﺘﺒﺎر وﺑﻄﺎﻗﺔ ﺷﺨﺼﻴﺔ .ﺧﺎﺻﺔ ﺑﻚ ﻏﻴﺮ ﻣﻨﺘﻬﻴﺔ اﻟﻤﺪة )ﻋﻠﻴﻬﺎ ﺻﻮرﺗﻚ( إﻟﻰ ﻣﻌﻤﻞ اﻻﺧﺘﺒﺎر No Mobiles or test materials are allowed in the test labs. ﻻ ﻳﺴﻤﺢ ﺑﺈدﺧﺎل اﻟﻬﻮاﺗﻒ اﻟﻤﺤﻤﻮﻟﺔ أو أﻳﺔ ﻣﻮاد ﻟﻬﺎ ﻋﻼﻗﺔ ﺑﺎﻻﺧﺘﺒﺎر إﻟﻰ .ﻣﻌﻤﻞ اﻻﺧﺘﺒﺎر Use black or blue pen to fill in your personal details on the cover page of the test and to answer multiple choice questions. ﻗﻢ ﺑﺎﺳﺘﺨﺪام اﻟﻘﻠﻢ اﻷﺳﻮد أو اﻷزرق ﻟﺘﻌﺒﺌﺔ اﻟﻤﻌﻠﻮﻣﺎت اﻟﺸﺨﺼﻴﺔ اﻟﻤﺘﻌﻠﻘﺔ .ﺑﻚ ﻓﻲ ﺻﻔﺤﺔ اﻟﻐﻼف ﻣﻦ اﻻﺧﺘﺒﺎر وﻟﻺﺟﺎﺑﺔ ﻋﻦ أﺳﺌﻠﺔ اﻟﺨﻴﺎر ﻣﻦ ﻣﺘﻌﺪد Write your name and your computer student number on the floppy disk provided and DON’T format it – This floppy disk contains materials related to the test. اآﺘﺐ اﺳﻤﻚ ورﻗﻢ اﻣﺘﺤﺎن اﻟﺤﺎﺳﺐ اﻟﺨﺎص ﺑﻚ ﻋﻠﻰ اﻟﻘﺮص اﻟﻤﺮن، وﻻ ﺗﺤﺎول ﺗﺠﻬﻴﺰ هﺬا اﻟﻘﺮص )ﻓﺮﻣﺘﺘﻪ( ﻷﻧﻪ ﻳﺤﺘﻮي ﻋﻠﻰ ﻣﻌﻠﻮﻣﺎت ﺗﺘﻌﻠﻖ .ﺑﺎﻻﺧﺘﺒﺎر
----------------------------------- For Official Use Only --------------------------------------Placement Test Section - I Section - II
Marker's Name:.............................................. Marker’s signature: ......................................
Score
Qatar University
Foundation Program
Math & Computer Department
--------------------------------- Beginning of Sample Test ---------------------------------------
Section I
A. Essential Computing and Internet:
1. 2.
How many bytes are there in 1 GB?...............................
(20 Marks)
Tick the right answer:
Data stored on a disk as a. An image................................................................................ □ b. Characters .............................................................................. □ c. Magnetic spots ....................................................................... □ A pixel is. a. Programmable point on screen............................................... □ b. A unit to measure Screen Size ............................................... □ c. The cursor you see on your screen ......................................... □ Which of the following is an input device? a. VDU....................................................................................... □ b. Joystick .................................................................................. □ c. Plotter..................................................................................... □ BIOS is. a. A secondary storage device.................................................... □ b. A ROM. ................................................................................. □ c. A RAM. ................................................................................. □ On a keyboard function keys are used for? a. Installing software programs.................................................. □ b. Ending program execution ..................................................... □ c. To perform simple command by different software............... □ HTML is. a. A language ............................................................................. □ b. An email message .................................................................. □ c. A document............................................................................ □ IP address is composed of. a. Numbers and characters separated by a period ...................... □ b. Four numbers separated by a period ...................................... □ c. Two numbers separated by a period....................................... □ To add a friend email to your mailing list you a. Add his/her email to safe list.................................................. □ b. Add his/her email a contact.................................................... □ c. Import your favourite email message..................................... □ a. Right click and delete............................................................. □ b. Select text and delete.............................................................. □ c. Select check box and press button delete ............................... □
3.
4.
5.
6.
7.
8.
9.
10. To delete an email from your inbox.
Computer Placement Test - SAMPLE This is only a sample test to make you familiar with the test style and contents
2 of 8
Qatar University
Foundation Program
Math & Computer Department
B. Windows XP:
QUESTION 1: DISK MANAGEMENT 1. [15 MARKS]
(25 Marks)
Create the following Folder structure in your floppy disk:
2. 3. 4. 5.
Create the following two Microsoft Word Documents into the root directory of A:\ Charges Safety Move the file Safety into the folder. Technology Copy the file Charges into the folder Electricity. Change the name of the file Charges in the folder Electricity to Static Charges [10 MARKS]
QUESTION 2: USING ONLINE HELP • • •
Use Online Help to find information about how to Save a file with a different name. Copy the information you have found, and Paste it into a New word document, Add your name and current date at the end of the file, and Save the file as “Save_To_Different_Name” on the root of Drive A:\..
Computer Placement Test - SAMPLE This is only a sample test to make you familiar with the test style and contents
3 of 8
Qatar University
Foundation Program
Math & Computer Department
C. MS Word XP:
(55 Marks) [10 MARKS]
QUESTION 1: TABS
Create the following document using Tab Stops. Consider the following: For the Titles (the first line): • Set a Left Tab: at 3cm and Right Tab at: 11cm. • Underline the title line For the Table columns: • Set a Left Tab: at 3cm and a Decimal Tab with tab leader at 10cm. Set line spacing to 1.5 for all lines. FirstName Nejla Seeta Mariam Address Money Due 100 Rayan St.................................... $120.00 58 Al-Sadd St .................................. $256.50 1234 Salwa Rd................................... $10.00
Save the document as Word_Ver5 on A:\ QUESTION 2: TABLES & BORDERS [10 MARKS]
Create the following table in a new page of the same file: Word_Ver5 Title in the first row (Forecast) is Centred, Arial, Bold and 22pt Data in all Cells are Centred, 12pt and Bolded as shown below. Use Formula to calculate the Average High and the Average Low in the shaded cells Borders for the table are exactly as shown in the figure.
Forecast
Today
High: Low: Mostly Clear 75 61
Tomorrow
Sunny 76 60
Average
Save your document and Keep the file open.
QUESTION 3: EQUATION
[10 MARKS]
Write the following Formula in a new page of the same file: Word_Ver5:
∑
2
hk
=
1 N
∑
N −1
H
2 n
n = 0
Save the document and Close it.
Computer Placement Test - SAMPLE This is only a sample test to make you familiar with the test style and contents
4 of 8
Qatar University
Foundation Program
Math & Computer Department
QUESTION 4: EDITING
[25 MARKS]
Produce the following FLYER in a new file by using Ms Word.
1. 2. 3. 4. 5.
Choose a suitable font size and style Use WordArt to insert the Title Insert the picture from ClipArt (picture of any building), resize to fit. Add a header that contains your name at the Centre section Save the document as Editting5, and then close it.
Computer Placement Test - SAMPLE This is only a sample test to make you familiar with the test style and contents
5 of 8
Qatar University
Foundation Program
Math & Computer Department
Section II
A. MS Excel XP:
QUESTION 1: [50 MARKS]
(70 Marks)
Open the File “Lulu_Price5.XLS” from your floppy desk. Worksheet1 looks like the following table, which represents the sales for the Computer section in the LULU center:
1. Save the file as (Lulu_Price5_Solution.XLS) on the root of the Exam disk A:\, then do the following: 2. Calculate the Total, Maximum, Minimum, and Average of the Price column. Put results in Cells B11, B12, B13 and B14 respectively. 3. Use nested IF function to find the Discount Rate (Put results in cells C4:C8) according to the following criteria. If the price was >=600, 40% Else, If the price was >=400, 30% Else, If the price was >=200, 20% Otherwise, 15% the Discount rate is the Discount rate is the Discount rate is the Discount rate is
Computer Placement Test - SAMPLE This is only a sample test to make you familiar with the test style and contents
6 of 8
Qatar University
Foundation Program
Math & Computer Department
4. Use VLOOKUP function to find the discount rate (in cells D4:D8) according to the table D10:E14. 5. Using IF Function to show whether there is a bonus or not (Put results in cell F4:F8) according to the following criteria The bonus is DVDs if the item is Computer or DVD Player Else, the bonus is None. 6. Use appropriate functions to count the Number of items. Put result in cell C16 7. Use appropriate functions to count the Number of items with price more than 500. Put result in cell C17 8. Calculate the Price after Discount (= Price - Price * Discount rate). 9. Add the $ currency with one decimal place to all cells which contain price: (B4:B8), (E4:E8), (B11:B14) and (D11:D14). 10. Make the following Format changes to the sheet • Merge and Center the cell (A1: F1). • Format the title (Lulu Center Discount) as Arial, Bold, size 20, and font color: Blue. • Format the cells E11:E14 as a Percentage style with 1 decimal place. • Change the name of the sheet to “Discount Offers”. 11. Save the file on your Exam disk and keep it open.
QUESTION 2:
[20 MARKS]
Sheet2 from the same file (Lulu_Price5_Solution.XLS) looks like the following:
1. Sort the data in the range (A1-D9) in ascending order according to field Males. 2. Goal seeks the total in cell D5 to 300 by changing the value in cell B5. 3. Create a copy of sheet 2 and name it “Goal_Seek”. 4. Create a chart showing the population for each country including males and females, with the following attributes:
Computer Placement Test - SAMPLE This is only a sample test to make you familiar with the test style and contents
7 of 8
Qatar University
Foundation Program
Math & Computer Department
Chart type: Chart title: Category (X) axis: Value (Z) axis : Legend: Data labels: Location / Chart name:
Clustered column with 3D visual effect Population Year 2000 Countries Population in Millions Show legend , Right Show Value New sheet / Population
5. Use page setup for the Population sheet as the following: • • • Set the orientation to landscape Set the margins 3cm left and 3 cm right and center the page horizontally Custom the header and the footer as follows In the right section of the header, insert the current date and time In the center section of the footer write your name. 6. Save your work on your Exam Disk and close it.
B. Power Point:
(30 Marks)
QUESTION 1: Create a PowerPoint presentation for a Construction Company using the information supplied in the file “Presentation.Doc” stored on your floppy disk. Slide Number 1. Company Name and logo. 2. A brief introduction about the company, and previous work done by the company. 3. Company Organizational chart. 4. Current Construction work. 5. Future plan. 6. Final slide is the company Logo and an invitation to visit company head quarter. Add the following template, animation, slide transition, and time rehearsal to our Presentation. 1. Design template is Radial. 2. Slide No. 1, Apply slide transition Cover-Left up. 3. Slide No. 2, Apply animation scheme Elegant. 4. Slide No. 3, Apply slide transition Wipe Left. 5. Slide No. 4 and 5 Apply slide transition Checkerboard Across. 6. Slide No. 6, Apply Slide transition Wedge. 7. Add the date that will update automatically, slide number and your name to slide footer. Display the footer on all slides. 8. Save the file under the name of Construction on your floppy disk. -------------------------------------End of Sample Test -------------------------------------------
Computer Placement Test - SAMPLE This is only a sample test to make you familiar with the test style and contents
8 of 8