Docstoc

Computer Placement Test_Sample Exam

Document Sample
Computer Placement Test_Sample Exam Powered By Docstoc
					      Qatar University                                                     Foundation Program                                  Math & Computer Department




                                                  Computer Placement Test
     Name: (First, Father, Family)
     Computer Student Number: ___ ___ ___ ___ ___ ___ ___ ___ ___ ___                                                               Male □             Female       □
     Name of High School:(New students only)

     Specialty in QU: Engineering □                                  Science □               Business    □      Others □            Test Lab.:

     Date (D/M/Y): ____/_____/200___                                      Version No.:                                              Floppy 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                                      .‫ﻳﺤﺼﻞ اﻟﻄﺎﻟﺐ ﻋﻠﻰ 06 أو أآﺜﺮ ﻓﻲ اﻟﺠﺰء اﻷول ﻣﻦ ﻧﻔﺲ اﻻﺧﺘﺒﺎر‬
            Course and Section-II covers the contents of Computer
            2 Course.                                                                          5.   The test duration is 2 hours (120 minutes). No students
                                                                                                    will be allowed to enter the Test Lab. after 15 minutes
            ‫ أﺳﺌﻠﺔ‬I-‫(. ﻳﻐﻄﻲ اﻟﺠﺰء‬II-‫ واﻟﺠﺰء‬I-‫ﻳﺘﻀﻤﻦ هﺬا اﻻﺧﺘﺒﺎر ﺟﺰأﻳﻦ )اﻟﺠﺰء‬                         from the start of the test and this student will not be
            ‫ أﺳﺌﻠﺔ ﺗﺘﻌﻠﻖ ﺑﻤﻘﺮر‬II-‫ﺗﺘﻌﻠﻖ ﺑﻤﺤﺘﻮﻳﺎت ﻣﻘﺮر ﺣﺎﺳﺐ 1، وﻳﻐﻄﻲ اﻟﺠﺰء‬                            given any extra time to complete the test.
                                                                    .2 ‫ﺣﺎﺳﺐ‬                         ‫ﻣﺪة اﻻﺧﺘﺒﺎر ﺳﺎﻋﺘﺎن )021 دﻗﻴﻘﺔ(، وﻟﻦ ﻳﺴﻤﺢ ﻷي ﻃﺎﻟﺐ/ﻃﺎﻟﺒﺔ ﺑﺪﺧﻮل‬
                                                                                                    ‫ﻗﺎﻋﺔ اﻻﺧﺘﺒﺎر ﺑﻌﺪ ﻣﺮور 51 دﻗﻴﻘﺔ ﻣﻦ ﺑﺪء اﻻﺧﺘﺒﺎر وﻟﻦ ﻳﻌﻄﻰ ﻟﻬﺬا‬
      2.    Each Section of this test is out of 100 points, with the
                                                                                                                             .‫اﻟﻄﺎﻟﺐ/اﻟﻄﺎﻟﺒﺔ أي وﻗﺖ اﺿﺎﻓﻲ ﻹﻧﻬﺎء اﻻﺧﺘﺒﺎر‬
            passing score of 60 points.
                                                                                               6.   Bring your Test Admission Form and a valid photo ID
            ‫اﻟﻌﻼﻣﺔ اﻟﻜﻠﻴﺔ ﻟﻜﻞ ﻣﻦ هﺬﻳﻦ اﻟﺠﺰأﻳﻦ هﻲ 001 ﻧﻘﻄﺔ، وﻋﻼﻣﺔ اﻟﻨﺠﺎح هﻲ‬                          to the test Lab.
                                                                 .‫06 ﻧﻘﻄﺔ‬                           ‫ﻗﻢ ﺑﺈﺣﻀﺎر آﻞ ﻣﻦ وﺻﻞ اﻟﺘﺴﺠﻴﻞ اﻟﺨﺎص ﺑﺎﻻﺧﺘﺒﺎر وﺑﻄﺎﻗﺔ ﺷﺨﺼﻴﺔ‬
      3.    Partial & full exemption rules:‫ﻗﻮاﻋﺪ اﻻﻋﻔﺎء اﻟﺠﺰﺋﻲ واﻟﻜﻠﻲ‬                                        .‫ﺧﺎﺻﺔ ﺑﻚ ﻏﻴﺮ ﻣﻨﺘﻬﻴﺔ اﻟﻤﺪة )ﻋﻠﻴﻬﺎ ﺻﻮرﺗﻚ( إﻟﻰ ﻣﻌﻤﻞ اﻻﺧﺘﺒﺎر‬
    You will be placed in Computer 1 if your score is less than 60 in part                     7.   No Mobiles or test materials are allowed in the test
                                                                     I of the test.                 labs.
     .‫ﺳﺘﺴﺠﻞ ﻓﻲ ﻣﻘﺮر ﺣﺎﺳﺐ 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.         8.   Use black or blue pen to fill in your personal details on
    ‫ﺳﺘﺴﺠﻞ ﻓﻲ ﻣﻘﺮر ﺣﺎﺳﺐ 2 إذا آﺎﻧ ﺖ درﺟﺘ ﻚ 06 أو أآﺜ ﺮ ﻓ ﻲ اﻟﺠ ﺰء اﻷول ﻣ ﻦ ه ﺬا اﻻﺧﺘﺒ ﺎر‬             the cover page of the test and to answer multiple choice
                                                           .‫وأﻗﻞ ﻣﻦ 06 ﻓﻲ اﻟﺠﺰء اﻟﺜﺎﻧﻲ ﻣﻨﻪ‬          questions.
    You will get exempted from Computer 1 & Computer 2 courses if                                   ‫ﻗﻢ ﺑﺎﺳﺘﺨﺪام اﻟﻘﻠﻢ اﻷﺳﻮد أو اﻷزرق ﻟﺘﻌﺒﺌﺔ اﻟﻤﻌﻠﻮﻣﺎت اﻟﺸﺨﺼﻴﺔ اﻟﻤﺘﻌﻠﻘﺔ‬
                                    you pass both parts with score of 60 or more.                     .‫ﺑﻚ ﻓﻲ ﺻﻔﺤﺔ اﻟﻐﻼف ﻣﻦ اﻻﺧﺘﺒﺎر وﻟﻺﺟﺎﺑﺔ ﻋﻦ أﺳﺌﻠﺔ اﻟﺨﻴﺎر ﻣﻦ ﻣﺘﻌﺪد‬
    ‫ﺳﺘﻌﻔﻰ ﻣﻦ ﻣﻘﺮري اﻟﺤﺎﺳﺐ 1 & 2 إذا آﺎﻧﺖ درﺟﺘ ﻚ 06 أو أآﺜ ﺮ ﻓ ﻲ اﻟﺠ ﺰأﻳﻦ اﻷول واﻟﺜ ﺎﻧﻲ‬
                                                                                               9.   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.
      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).                              ‫ﺗﺤﺎول ﺗﺠﻬﻴﺰ هﺬا اﻟﻘﺮص )ﻓﺮﻣﺘﺘﻪ( ﻷﻧﻪ ﻳﺤﺘﻮي ﻋﻠﻰ ﻣﻌﻠﻮﻣﺎت ﺗﺘﻌﻠﻖ‬
                                                                                                                                                               .‫ﺑﺎﻻﺧﺘﺒﺎر‬


----------------------------------- For Official Use Only ---------------------------------------

            Placement Test                                    Score
                 Section - I
                Section - II                                                                   Marker's Name:..............................................

                                                                                               Marker’s signature: ......................................
Qatar University                                       Foundation Program                           Math & Computer Department

--------------------------------- Beginning of Sample Test ---------------------------------------

                                                        Section I
A. Essential Computing and Internet:                                                                               (20 Marks)
  1.     How many bytes are there in 1 GB?...............................
Tick the right answer:
  2.     Data stored on a disk as
         a. An image................................................................................ □
         b. Characters .............................................................................. □
         c. Magnetic spots ....................................................................... □
  3.     A pixel is.
         a. Programmable point on screen............................................... □
         b. A unit to measure Screen Size ............................................... □
         c. The cursor you see on your screen ......................................... □
  4.     Which of the following is an input device?
         a. VDU....................................................................................... □
         b. Joystick .................................................................................. □
         c. Plotter..................................................................................... □
  5.     BIOS is.
         a. A secondary storage device.................................................... □
         b. A ROM. ................................................................................. □
         c. A RAM. ................................................................................. □
  6.     On a keyboard function keys are used for?
         a. Installing software programs.................................................. □
         b. Ending program execution ..................................................... □
         c. To perform simple command by different software............... □
  7.     HTML is.
         a. A language ............................................................................. □
         b. An email message .................................................................. □
         c. A document............................................................................ □
  8.     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....................................... □
  9.     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..................................... □
  10. To delete an email from your inbox.
         a. Right click and delete............................................................. □
         b. Select text and delete.............................................................. □
         c. Select check box and press button delete ............................... □




Computer Placement Test - SAMPLE                                                                                             2 of 8
This is only a sample test to make you familiar with the test style and contents
 Qatar University                            Foundation Program                Math & Computer Department



 B. Windows XP:                                                                               (25 Marks)

 QUESTION 1: DISK MANAGEMENT                              [15 MARKS]
1.   Create the following Folder structure in your floppy disk:




2.   Create the following two Microsoft Word Documents into the root directory of A:\
                              Charges                Safety
3.   Move the file Safety into the folder. Technology
4.   Copy the file Charges into the folder Electricity.
5.   Change the name of the file Charges in the folder Electricity to Static Charges


 QUESTION 2: USING ONLINE HELP                                      [10 MARKS]
 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                                                                       3 of 8
 This is only a sample test to make you familiar with the test style and contents
Qatar University                            Foundation Program                  Math & Computer Department

C. MS Word XP:              (55 Marks)

QUESTION 1: TABS                      [10 MARKS]
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             Address                                       Money Due
Nejla                 100 Rayan St.................................... $120.00
Seeta                 58 Al-Sadd St .................................. $256.50
Mariam                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               Tomorrow
                                 Mostly Clear                Sunny               Average
                   High:             75                        76
                   Low:              61                        60
    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                N −1
                                                      1
                            ∑                                ∑
                                                                                 2
                                     hk         =                     H     n
                                                      N      n = 0

    Save the document and Close it.




Computer Placement Test - SAMPLE                                                                         4 of 8
This is only a sample test to make you familiar with the test style and contents
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.     Choose a suitable font size and style
2.     Use WordArt to insert the Title
3.     Insert the picture from ClipArt (picture of any building), resize to fit.
4.     Add a header that contains your name at the Centre section
5.     Save the document as Editting5, and then close it.




Computer Placement Test - SAMPLE                                                                       5 of 8
This is only a sample test to make you familiar with the test style and contents
Qatar University                            Foundation Program                Math & Computer Department


                                            Section II
A. MS Excel XP:                                                                              (70 Marks)
QUESTION 1:                 [50 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,                                        the Discount rate is
    40%
    Else, If the price was >=400,                                  the Discount rate is
    30%
    Else, If the price was >=200,                                  the Discount rate is
    20%
    Otherwise,                                                     the Discount rate is
    15%



Computer Placement Test - SAMPLE                                                                       6 of 8
This is only a sample test to make you familiar with the test style and contents
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                                                                       7 of 8
This is only a sample test to make you familiar with the test style and contents
Qatar University                            Foundation Program                Math & Computer Department

             Chart type:                          Clustered column with 3D visual effect
             Chart title:                         Population Year 2000
             Category (X) axis:                   Countries
             Value (Z) axis :                     Population in Millions
             Legend:                              Show legend , Right
             Data labels:                         Show Value
             Location / Chart name:               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                                                                       8 of 8
This is only a sample test to make you familiar with the test style and contents

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:713
posted:6/17/2008
language:English
pages:8