Docstoc

Grouping - Excel

Document Sample
Grouping - Excel Powered By Docstoc
					    Matric No                        Name                   Prog    Course
    085296      NOOR SAKINAH ANIZA BT ZAKARIA             ICT      IFM2243
A
    084833      ILHAM BT MOHAMAD BAKHIR                   ICT      IFM2243
    084940      NUR AZRIN BINTI ABD MALEK                 ICT      IFM2243
B
    085501      IRYANI BT ISHAK                           ICT      IFM2243
    085317      AYU SYAFIKA BINTI SHAHEMI                 ICT      IFM2243
C
    085503      NURUL'IZZAH BINTI ZAIDI                   ICT      IFM2243
    084724      NUR SHAFINAZ BINTI MD SHARIL              ICT      IFM2243
D
    085289      NUR NAZIHAH BINTI RAHIM                   ICT      IFM2243
    093653      NUR SYAHIDA BINTI ZAINAL ABIDIN           ICT      IFF1444
E
    094156      QURRATU'AINI BINTI ZAINI                  ICT      IFF1444
    074484      AHMAD SYAZZWAN HAFFIZ B MOHD NOOR         ICT      IFM2243
F
    074868      MUHAMMAD FAUZI B. OTHMAN                  ICT      IFM2243
    074879      MUHD HARITH B ABD RAZAK                   ICT      IFM2243
G
    074892      MUHAMMAD IZWAN B CHE OSMAN                ICT      IFM2243
    084761      FAMIEZA AZIEMA BINTI ABDUL AZIZ           ICT      IFM2243
H
    085512      NORAKMAL BT MOHD MAZLAN KUSHAIRI          ICT      IFM2243
    084208      AHMAD DZIAULHAQ BIN AHMAD                 ICT      IFM2243
I
    084830      MUHAMMAD UZAIR IZZAT AMIR BIN MUHAMMAD    ICT      IFM2243
    084992      ILIA HAZWANI BINTI AMRAN                  ICT      IFM2243
J
    085658      NOR MADIHAH BINTI DAMLA                   ICT      IFM2243
    085601      CHE SITI FATIMAH BINTI CHE HASAN          ICT      IFM2243
K
    085654      NIK TASNIM BT NIK KAMARUZAMAN             ICT      IFM2243
    085651      NASSIR SAID NASSIR                        ICT      IFM2243
L
    085633      MOHD KHAIRIUL UMMAH BIN ABU BAKAR BAKRI   ICT      IFM2243
    085775      MASTURAH BINTI HAJI RASHID                ICT      IFM2243
M
    085809      SITI SAFURA BT IBRAHIM                    ICT      IFM2243
    084441      NURHIDAYAH BINTI MOHD HASBI               ICT      IFM2243
N
    082707      NUR AMIRAH BINTI TAHIR                    ICT      IFM2243
    084596      HAFIZAH BINTI YAHYA                       ICT      IFM2243
O
    085671      NUR MUNIRAH MAHMOOD                       ICT      IFM2243
    084618      NORFAEZAH BT CHE ROSLE                    ICT      IFM2243
P
    084623      NIK DALILA BT MOHD RONI                   ICT      IFM2243
    084615      NUR AINAA BINTI BORHAN                    ICT      IFM2243
Q
    084631      HALWANI BT ABDUL KADIR                    ICT      IFM2243
    084649      MUHD ARIEF HAFIDZI ASHAARI                ICT      IFM2243
R   084765      AZIZUL JABBAR B ABDULLAH THANI            ICT      IFM2243
    084814      MUHAMMAD SYAFIQ B MOHD MAJID              ICT      IFM2243
    084664      NOR HAMIDAH BT RAMLI                      ICT      IFM2243
S
    084674      NUR AMIRA FATIN BINTI ZAKRI               ICT      IFM2243
    084707      MOHAMMAD RAZIN MOHAMMAD                   ICT      IFM2243
T
    084718      NOOR AFIQ BIN WALID                       ICT      IFM2243
    084682      RUSNI BINTI TAJARI                        ICT      IFM2243
U
U
     084779   NURUL FILZAH BT MD SALIH                                   ICT        IFM2243
     084790   NURUL HIDAYAH BINTI MD DAUD                                ICT        IFM2243
V
     085306   NORSHUHADA BINTI MOHD ZALI                                 ICT        IFM2243
     085614   KHIN HAY MAN OO@YASMIN                                     ICT        IFM2243
W
     085620   MAY THU SOE @ FARZANSA                                     ICT        IFM2243
     085621   MG SOW CHIT KAUNG @HOSAI AHAMAD                            ICT        IFM2243
X
     081913   MUHAMMAD ILIYAS BIN MAHADI                                 ICT        IFM2243
     085689   SHADINA BT MOHD TAJUDDIN                                   ICT        IFM2243
Y
     085813   SITI NOR SABIQAH MORSHIDI                                  ICT        IFM2243
     084731   NURUL 'ATIQAH BINTI MD HASAN                               ICT        IFM2243
Z
     085573   NURUL HANIS SOFEA BT ALIAS                                 ICT        IFM2243
     090079   ABDULFATTAH MUHYIDDEEN BIN MUHAMAD RIDZUAN                 ICT        IFF1444
AA
     084436   WAN NAJMI BIN WAN JOHARI                                   ICT        IFM2243
     085672   NUR RUZANNA BINTI MOHD RAUS                                ICT        IFM2243
BB
     084614   NURHAFIZAH MOHD SAPIYAN                                    ICT        IFM2243
     084327   SHUHADA BINTI SULONG                                       ICT        IFM2243
CC
     084773   IRMA BINTI PAMMUSU                                         ICT        IFM2243
     085805   AHMED ADI HATIM B MOHD YASIN                               ICT        IFM2243
DD
     085589   AHMAD ZAMIR BIN AHMAD MUNAWIR                              ICT        IFM2243
     085701   YI YINT WIN / BADR                                         ICT        IFM2243
EE
     085759   MUHAMMAD BIN ABDUL AZIZ                                    ICT        IFM2243
     084813   MUHAMMAD FARID BIN BAHRUDIN                                ICT        IFM2243
FF
     085550   NIK SAIFULANUAR BIN NIK HAZMI                              ICT        IFM2243
     084685   ASH-SHADEEQ AMIN BIN AHAMAD                                ICT        IFM2243
GG
     084736   AHMAD ALIMURTAZA BIN AHMAD IZUDDIN                         ICT        IFM2243
     085286   MUHAMMAD SHOLEH B ABDUL AZIZ                               ICT        IFM2243
HH
     084660   MUHAMMAD MUJTABA BIN HUSAM                                 ICT        IFM2243

II

JJ

              To be assigned groups. (Pls inform madam maznah about your group partner)

     085283   AIN ZULAIKHA BINTI MOHAMMAD ZAKI                           ICT        IFM2243
     085683   PHONE MYINT NAING / MOHD ALI                               ICT        IFM2243
     080863   ILHAM HANAFIAH BIN ABD RAHMAN                              ICT        IFM2243
     084193   ZYED B ZAKARIA                                             ICT        IFM2243
              MOHD RIDZUAN                                               ICT        IFM2243
Group   Question No
  1
            1
  1
  1
            2
  1
  1
            3
  1
  1
            4
  1
  1
            5
  1
  2
            6
  2
  2
            7
  2
  1
            8
  1
  2
            9
  2
  2
            10
  2
  2
            11
  3
  2
            12
  2
  2
            13
  3
  3
            14
  1
  3
            15
  3
  3
            16
  3
  3
            17
  3
  3
  3         18
  3
  3
            19
  3
  3
            20
  3
  3
            21
    21
3
3
    22
1
3
    23
3
3
    24
3
3
    25
2
1
    26
3
1
    27
1
2
    28
2
2
    29
2
2
    30
2
2
    31
2
1
    32
1
1
    33
1
1
    34
1

    35

    36



3
2
1
2
2
Question 1

Question 2


Question 3


Question 4

Question 5


Question 6



Question 7


Question 8

Question 9

Question 10


Question 11


Question 12


Question 13


Question 14


Question 15


Question 16

Question 17
Question 18

Question 19



Question 20



Question 21

Question 22

Question 23

Question 24

Question 25


Question 26



Question 27



Question 28


Question 29



Question 30



Question 31


Question 32


Question 33
Question 34


Question 35


Question 36
 Write a program that will make a survey to receive responses to a 5-question questionnaire
from the public and may display the current percentage of the responses and chart the
responses using a correctly scaled bar chart.
Write a random card guessing-game where the program will randomly select five cards from a deck of
cards and the user may guess the total of points for all the five cards. The user may play again when
Write a program of a money changer. The user may enter the amount of money and the program will
list the denominations of notes and coins for that given amount. Take note that the Malaysian currency
(ringgit) is made of RM50, RM10, RM5 and RM1 notes and 50 sen, 20 sen, 10 sen, 5 sen and 1 sen
coins. The program should offer options to automatically assign the change or let the user to choose
Write a program to play the word-guessing game similar to Hangman. The program words are to be
guessed by using for a 10-pin bowling the length of usually have 10 may make up to 5 is based
Calculate score the category given and game, whichthe word. The userframes. The scoreguesses.
on the number of pins knocked down. You are to enter the number of pins knocked down for
each throw for each frame, giving correct extra points for strikes and spares.
Write a program for a memory game that randomly picks seven from a stored array of 100 words. The
words are to be displayed for a limited time, say 10 seconds. The player must recall and type the words
according to the same sequence displayed. The mark is obtained from the correctly spelled word typed
Write a program for a currency exchange agency that trades the currency for 10 different countries,
displaying 10 currencies/countries offered for the customer to choose. Customer can choose the
currency, to buy or to sell for the chosen currency. Based on the amount entered by user, the program
will display the amount based on the exchange rate.
Write a polls program that allows for nomination of five candidates and the voting process that
displays all five candidates and receiving of votes. The program will display of results in ranking of the
Jumbled-Word program: Read a file containing 100 words with at least seven letters, select randomly
one word and jumble up the letters and display the jumbled-up word. The player has to guess the
Write a program that will make a survey: display a 5-question questionnaire, collect responses from the
public and display the current percentage of the responses. Show the responses using a correctly
Write the Matching the Country Game: Display four columns: A - Country, B - Capital, C- Language and
D - Currency to list data of 10 to 15 countries in the jumbled-up or random order. Display option –
Swap, Display, Solve. Swap – two piece of information in the wrong places is swapped; Display – to
A cryptographic Game: Write a program that encodes and decodes messages using any user-supplied
code. The code is to be read from a text file to build encoder/ decoder array. Add spaces and common
punctuation characters in the code.The user is given a menu or choices to encode, decode, or enter a
Write a program that accepts a passage, analyzes the passage word by word, count the occurrences of
each word (regardless of the letter-case used).
Write a program that will read a number between 5 and 20 from the user and display one or more of
various shapes. The shapes that you can display would be a square, a parallelogram, a triangle, a
diamond shape and a straight line. You may let the user choose from a set of symbols, e.g. * or $ or %
Write a program for a saving bank with data of say 50 customers: including the account number, name,
address, and balance amount.
The customer is allowed to make enquiries of his/her account balance, withdraw money from her
Write a program for an Algebre Quiz show. It will read a file of the questions becoming of increasing
difficulty, involving addition, multiplication, subtraction and division. Give the score of correct answers
Write a program that accepts a number, and determine whether number is odd or even, prime or not,
display the number in binary, octal and hexadecimal form, and in words.
Write a program that will play the Lingo game. This game will randomly produce a five-letter word,
displaying just the first letter and letting the player to guess the rest. The player may have only five
Write a memory game program that displays seven random numbers for a limited time, say 1 minute.
The player must recall and type the numbers in any sequence. The mark is obtained from the number
Write a program for a newsstand store that supplies newspaper and magazines to customers within
the area. Keep a database of subscription code, customer names, addresses and magazine ordered.
Keep another database of the magazines that store distributes and the corresponding prices. The
program should be able to get new order from a customer and add the data in the first database,
display the list of invoices to be sent to each customer
Write a program for Multiplication Table. Ask the user to enter any number and check the players
ability to give the correct answers of the multiplication with the numbers 1 to 12.
Write a program to play Tic-Tac-Toe where the user may enter an O or X in a 3-by-3 grid. The game
ends when a straight line can be drawn on the same O or X shape, horizontally, vertically, or diagonally,
Write the Matching card program where you list 10 to 15 pairs of cards. The player may choose a pair
of cards and the program will check if the cards match and will move the matched cards from the
Write a program to accept two three-by-three matrices and do the following: Display the sum of the
two matrices, difference of the two matrices, the determinant of the two matrices, and the inverse
Write a program that accepts a paragraph and analyzes each character in the paragraph to check
number of characters broken down into letters, digits, symbols or spaces, and the number of
Write a program for a memory game that generates seven three-digit numbers. The numbers are to be
displayed for a limited time, say 10 seconds. The program will shuffle the numbers in a randomly
different order. The player must recall and type the numbers according to the original sequence
Write a program for a chongkak game between two players. Each player has 5 bowls with 5 marbles in
each bowl when the program starts and a home bowl at the end. Each user can pick a bowl from his
side and drop marbles from that bowl into consecutive bowls including his home bowl and into
opponent bowls until he run out of marbles. The winner is the user who has the most marbles in his
Write a program for a Trivia game that allow player to identify up to five famous people in history and
have to guess the person correctly based on hints given (maximum 10 hints), one after another, the
player who guess correctly on least number of hints can get more marks. The famous people must be
Write the Find your Match game where you have names of 20 real people, with at least 10 charateristic
like age, nationality, type of hair, colour of eye, personality, etc. The program will ask the player
question about their preferred characteristics of a match and short list candidates that match the
Write a program for a small library that lends out book to library members. The library has data of
books and members. Members can borrow book by stating their code number. A member can borrow
a book for a maximum of 3 weeks. A member who has not returned a book will not be allowed to
borrow another book.make reservation for a alist outflight company that that has not been returned by
Write a program that Finally, the library may small outstanding books flies to a certain destination
two times a week. The passengers can reserve flight seat for Smoking or Non-Smoking, First Class or
Economy Class, Aisle or Window Seat. The program will advise the passenger for the next flight if the
Write a program to play the word-guessing game where where the the category of words are
quotations, title of books and movies. Each line must have a minimum length of 50 characters. The
player wins if he can fill all the letters correctly. The player loses if he/she makes more than 3 mistakes.
Write a Candy Vending Machine program that displays candies and prices. The player can enter money
and select the candy. The program will check if the candy requested is still in stock, and if the player
has enough money to purchase the candy. If there is extra money, the player can choose to reimburse
Write a program using Morse code where a player can send a message and have the message encoded
Into morse code, or have a message in morse code and decoded into English words.
Write a program for a small Holiday Resort. The customers can reserve room based on vacancies.
Additional to the lodging rental, the charges also depend on the number of family members, the
number of trips and games that the family want to participate in.
Write a program similar to Who wants to be a Millionaire where the player can answer questions by
guessing from four choices displayed. The question should be of increasing difficulty and but with
increasing prize money. The player can have two chances of 50-50 lifeline where two wrong answers

				
DOCUMENT INFO