Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,150,596 members, 7,809,156 topics. Date: Friday, 26 April 2024 at 01:50 AM |
Nairaland Forum / Emymeeky's Profile / Emymeeky's Posts
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (of 31 pages)
Politics / Re: Fresh Explosion Rocks Borno State by emymeeky: 2:45pm On Nov 08, 2016 |
It is a gas explosion . Bokoharam has been decimated such that they cannot carry out any attack . They have been technically defeated. The dead are soft targets and calls for no concern . Jonathan did not buy any weapon. The soldiers are using their bare hands to capture and kill insurgents because the money for the weapons were looted by the past administration. The insurgents have resorted to the use of IEDs. Therefore , we have won . The soldiers killed and buried yesterday were sleeping on duty . A bomb mistakenly detonated by a careless soldier killed them. #LieMuhammed 48 Likes |
Jobs/Vacancies / Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 10:48pm On Nov 07, 2016 |
lalasticlala: Oh .. didn't know I defaulted ... Did that innocently ... Can I get a FP for my second video? |
Jobs/Vacancies / Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 7:59pm On Nov 07, 2016 |
franciskaine:updated . Check the link to the second video above |
Jobs/Vacancies / Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 7:54pm On Nov 07, 2016 |
semasir: Lol. Guess lalasticlala is yet to see it |
Jobs/Vacancies / Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 7:53pm On Nov 07, 2016 |
Didoris: You're welcome... Thanks for reading! |
Politics / Re: Names Of 7 Soldiers To Be Buried At National Cemetery In Abuja Today by emymeeky: 2:26pm On Nov 07, 2016 |
Rip askibee: I think you should first check the meaning of snitches before you condemn him 9 Likes |
Politics / Re: Soldier: Forgiving Boko Haram Is Left To God But Sending Them To God Is Our Job by emymeeky: 2:23pm On Nov 07, 2016 |
davodyguy: These children of hate give you nightmares to the extent that you have to lift a Bible verse to buttress your point 1 Like |
NYSC / Re: NYSC Batch B Redeployment From Camp!!! by emymeeky: 6:29am On Nov 07, 2016 |
07068097535 |
Jobs/Vacancies / Re: Simple Continuous Assessment Program Using Microsoft Excel For Jobseekers(video) by emymeeky: 11:36pm On Nov 06, 2016 |
Didoris: Just to demonstrate how we shall be displaying the grades in my next post. It'll be relevant in the next tutorial. Thanks for reading. |
Webmasters / Re: CNN: Mark Zuckerberg Lost $3 Billion In A Single Day After Facebook Warning by emymeeky: 8:45pm On Nov 06, 2016 |
Too bad |
Webmasters / Re: Why Do Most Nigerians Use Instead Of The Alternatives? by emymeeky: 9:22am On Nov 06, 2016 |
Fedric: Spot not sport ... Meanwhile FTC 5 Likes 2 Shares |
Jobs/Vacancies / Re: Simple Continuous Assessment Program Using Microsoft Excel For Jobseekers(video) by emymeeky: 8:33am On Nov 06, 2016 |
Thanks for reading |
Business / Re: Egypt Devaluation To Test CBN Resolve On Naira by emymeeky: 7:22am On Nov 06, 2016 |
Car Talk / Re: You Too Can Identify A Hybrid Car by emymeeky: 6:56am On Nov 06, 2016 |
@ trygo . You mentioned hybrid cars don't use alternators. What then charges the batteries when the engine is running? |
Jobs/Vacancies / Re: Simple Continuous Assessment Program Using Microsoft Excel For Jobseekers(video) by emymeeky: 10:44pm On Nov 05, 2016 |
StepTwo:And I'll be doing just that |
Jobs/Vacancies / Re: Simple Continuous Assessment Program Using Microsoft Excel For Jobseekers(video) by emymeeky: 9:43pm On Nov 05, 2016 |
Lalasticlala seun can I get a FP? |
Jobs/Vacancies / Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 9:24pm On Nov 05, 2016 |
Watch part 2 video here>> https://www.nairaland.com/3448833/simple-continuous-assessment-program-using |
Jobs/Vacancies / Re: Simple Continuous Assessment Program Using Microsoft Excel For Jobseekers(video) by emymeeky: 9:23pm On Nov 05, 2016 |
StepTwo:Very good. It is shorter but then , it doesn't explain the arithmetic behind the formula .... Will introduce it when we have a larger table |
Jobs/Vacancies / Re: Simple Continuous Assessment Program Using Microsoft Excel For Jobseekers(video) by emymeeky: 9:17pm On Nov 05, 2016 |
If we have to do that of Jane, we shall be entering in cell G3 without spaces =D3+E3+F3 and then hitting the enter button. But then we may have a long list that entering the formulas into their corresponding cells may be strenuous. To avoid this, we simply place our cursor on the bottom-right corner of cell G2, then hold down your left-click button and drag down to cell G13 . See image below. Alternatively, instead of holding down the button, we simply double click. [img]http://3.bp..com/-rgonTZ9TRgE/WBtTHeNuuEI/AAAAAAAAEIg/XzYqF9f-oTkW7V463jhwQYz1N44ZoQkPQCLcB/s640/continuous.png[/img] Now fill in the assignment, test and exam cells and you'll see the Total automatically update! In my next blog post, we shall be displaying the students' grade on column H. This column will tell us when a student's score is an A, B, C, D, E or an F automatically. This can be achieved by using the IF STATEMENTS. When you learn the IF STATEMENTS properly, you can call yourself a programmer Follow me on https://www./profile/christian-nwodo to keep tab on my updates WATCH VIDEO BELOW https://www.youtube.com/watch?v=9dlkYQjKPi4 |
Jobs/Vacancies / Simple Continuous Assessment Program Using Microsoft Excel For Jobseekers(video) by emymeeky: 9:02pm On Nov 05, 2016 |
In my last blog post, we dealt on how to create a simple list using Microsoft Excel. We learnt how to identify the ranges of cells. We were able to differentiate rows from columns. In this blog post, we shall be learning how to use the table we created to create an automated continuous assessment table. A common continuous assessment table will have the following features as shown in the image below [img]http://3.bp..com/-faVElwNoBbI/WBsdBUJgLvI/AAAAAAAAEHU/YLtJU5qMAB8NlNaleG384w1GHcpeveDVACLcB/s640/continuous.png[/img] As you can see, I added extra columns to the table we created in my previous post. So you have to adjust your table to look like mine mine by adding Assignment , Test, Exam, Total, Grade columns to your table. Also, create the second table on the right with headings From and To. While I wait for you to add the extra columns, I will fill in the names, ages and gender as shown in the picture below [img]http://3.bp..com/-vgv7o2x1Mhs/WBshSGNZFcI/AAAAAAAAEHg/Ya64ym3JfrciBpxt9rpIOI7m4fD23ADewCLcB/s640/continuous.png[/img] Here comes the sweetest part . As you know, the Total is the addition of the Assignment, Test and Exam. So we would want a situation where the total score is automatically displayed once the values for assignment,test and exam have been entered. For example, I want the value under Total to display 40 if the values under Assignment ,Test and Exam are 10, 18 and 12 respectively. Got it? This will surely save us the time and stress of having to punch our calculator each time we want to fill in the total scores. To achieve this, we will have to give excel a simple instruction. Let Us take Amaka as an example. I would like to display Amaka's total score in cell G2 by summing up the values in D2, E2 and F2 as illustrated in the table below. [img]http://2.bp..com/-TtjCUlR5jNA/WBsw_1NUUgI/AAAAAAAAEHw/kb5gs-_w02UROHGg-h7AiG7odhCr_DkMwCLcB/s640/continuous.png[/img] So to display the total in cell G2, simply click on cell G2 and type without spaces =D2+E2+F2 and hit the enter button. [img]http://3.bp..com/-Tm5TNlfmQbs/WBs4SCjOAhI/AAAAAAAAEIE/jx-qOTnRh30_C93Bu4dHTOyYfsF3zjfwwCLcB/s640/continuous.png[/img] Viola! You'll have your answer as displayed in the image below! [img]http://1.bp..com/-pZ4JNtd2270/WBs6gozBSII/AAAAAAAAEIQ/bDAoRgLT9ug5m4VZI-hzn0K95DKTglvXgCLcB/s640/continuous.png[/img] |
Politics / Re: Muhammad Abu Ali Killed By Boko Haram by emymeeky: 7:15pm On Nov 05, 2016 |
Unblockable: You don't mean it
|
Jobs/Vacancies / Re: EFCC Ignores Federal Character In Staff Recruitment - The Authority by emymeeky: 4:00pm On Nov 04, 2016 |
Binb: Sorry to disappoint you. Not everybody is as poor as you are. To answer your question... I'm rich |
Jobs/Vacancies / Re: EFCC Ignores Federal Character In Staff Recruitment - The Authority by emymeeky: 3:07pm On Nov 04, 2016 |
Ahmadabd: But you remain poor 2 Likes
|
Politics / Re: I Will Treat All Nigerians Equitably - Buhari by emymeeky: 8:55am On Nov 04, 2016 |
sarrki: Even your mother tongue de affect your writing 2 Likes
|
Politics / Re: Reps Want Adeosun, Emefiele To Resign by emymeeky: 8:35am On Nov 04, 2016 |
. |
Politics / Re: Reps Want Adeosun, Emefiele To Resign by emymeeky: 8:29am On Nov 04, 2016 |
sarrki: Hahaha hah ... The home economics teacher is trying to fix the biggest economy in Africa?Are you kidding me ? 1 Like
|
Business / Re: You No Longer Need A Lawyer To Register Your Business - CAC by emymeeky: 6:59am On Nov 04, 2016 |
Romance / Re: Checkout These Lovely Pre-wedding Pictures Of A Cute Nigerian Couple by emymeeky: 9:01pm On Nov 03, 2016 |
Ginaz: I don't wear rings in the night either |
Romance / Re: Checkout These Lovely Pre-wedding Pictures Of A Cute Nigerian Couple by emymeeky: 8:56pm On Nov 03, 2016 |
Ginaz: U don't need to see my ring ... Marriage is written all over my face |
Romance / Re: Checkout These Lovely Pre-wedding Pictures Of A Cute Nigerian Couple by emymeeky: 8:51pm On Nov 03, 2016 |
Ginaz: Nope .... I'm already married |
Romance / Re: Checkout These Lovely Pre-wedding Pictures Of A Cute Nigerian Couple by emymeeky: 8:30pm On Nov 03, 2016 |
Ginaz: Next 10 years |
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (of 31 pages)
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 35 |