STUDENT RESULT IN MICROSOFT EXCEL

STUDENT results in Microsoft Excel 
Name
Age
Gender 
Subject 
Tom: Total obtainable mark
Tmo: Total mark obtained 
Average 
Position.
° TOM: = 100×Number of Subject 
° TMO: type =Sum  than double click on Sum and high-key from the to the last subject than you close the bracket and press enter.
° Average: type Average double click on Average and highlight from the first to the last subject then close the bracket and press enter. 
° Position: type Rank a list of option will show then you double click on rank and highlight from the first to the last Average then put your comma, put dollar sign and put the first alphabet write another dollar sign put the first number then you put Column then put dollar sign again and put second alphabet then you close the bracket and press enter.
° Grade: type IF then a list of option will appear double click on IF then you will click on the first Average then write >=100, "A", then write IF again then a list of option will appear double click on IF then you will click on the first Average then write >=60,"B" then write IF again then a list of option will appear double click on IF then you will click on the first Average then write >=50, "C", write IF again then a list of option will appear double click on IF then you will click on the first Average then write >=30,"D", then you write IF again then a list of option will appear double click on IF then you will click on the first Average then write >=20 "F", then you will close bracket six times then you will press enter. 
° Remark = type IF then a list of option will appear double click on If then you will click on the first Average then write >=100,"Distinction". Then write IF again then a list of option will appear double click on IF then you click on the first Average then write >=60, "Upper credit" write IF then a list of option will appear double click on the first Average then write >=50, "lower credit" click on Average write >=40, "Pass" click on Average write >=30, "Poor" click on Average write >=20, "Fail" close bracket six times then enter. 

Comments

Post a Comment

Popular posts from this blog

COMPUTER LECTURE

              COMPUTER LECTURE  Computer: Is an electronic device that is capable of accepting data through the input unit, process the received data in the central processing unit, deliver the result as an information which can be store for future use. It can also be define as a gigo machine which means "Garbage in garbage out". It is an electronic device because it has a connection with an electricity to function. It started as Manuel to Mechanical to Electronical.  Computer has the ability to receive signal and accept it through the system.                   BASIC COMPONENT OF COMPUTER                          HARDWARE   Hardware: is the physical component of computer or other electronic device that we can see, touch, and carry about. It includes all the tangible parts that make up the system, such as: 1. Central Pro...
Read more

COREL DRAW

CORAL DRAW  COURSES UNDER CORAL DRAW  1)  Data processing: Microsoft ware, Microsoft Excel, Microsoft PowerPoint. 2) Desktop publishing:  CorelDRAW,  Adobe Photoshop, Microsoft publishing. 3) Programming: Disk operating system (D.O.S), Q uick beginner's all purpose symbolic instruction code;  " refers to "BASIC" which stands for "Beginner's All-purpose Symbolic Instruction Code" 4) System management and maintenance: Disk operating system and window operating system (W.O.S). 5) Computer peripherals: General computer, typing and keyboarding. 6) Networking: Internet.                            CORAL DRAW  CorelDRAW : is a desktop publishing programme that is used to create good professional looking graphics with the help of tools and logos.    CorelDRAW  is also a popular vector base graphics package/ editor developed by Corel Corporation  It's widely used by gr...
Read more