Naomba msaada jinsi ya Kupanga division na point kwa kutumia excel


Ziltan

Ziltan

JF-Expert Member
Joined
Aug 20, 2011
Messages
1,411
Points
1,250
Age
36
Ziltan

Ziltan

JF-Expert Member
Joined Aug 20, 2011
1,411 1,250
Nitawezaje kupanga divisions kwa kutumia program ya Excel ? Naombeni msaada wakuu.

Natanguliza shukrani.
 
K

Kyatsvapi

JF-Expert Member
Joined
May 15, 2009
Messages
322
Points
225
K

Kyatsvapi

JF-Expert Member
Joined May 15, 2009
322 225
Unaweza kutumia if au if(and( functions.
A. Kutumia if(and( function.
Fikiria mfano huu;
Marks. Divisheni
0-20. F
21-40. C
41-60. B
>60. A

Namna nzuri na rahisi ni kufanya kwa kutumia if(and function sababu yenyewe inaangalia extreme points zote. Formula utakayotumia ni
=if(and(A1>=0,A1<=20),"F",if(and(A1>=21,A1<=40),"C",if(and(A1>=41,A1<=60),"B","A")))

Nimetumia simu kuandika hiyo formula kama itakuwa na ishu usisite kuleta mrejesho.

Kutumia if peke yake next tyme nikiwa kwa keyboard ya pc.


Barikiwa.
 
INGENJA

INGENJA

JF-Expert Member
Joined
Sep 11, 2012
Messages
4,995
Points
2,000
INGENJA

INGENJA

JF-Expert Member
Joined Sep 11, 2012
4,995 2,000
Unaweza kutumia if au if(and( functions.
A. Kutumia if(and( function.
Fikiria mfano huu;
Marks. Divisheni
0-20. F
21-40. C
41-60. B
>60. A

Namna nzuri na rahisi ni kufanya kwa kutumia if(and function sababu yenyewe inaangalia extreme points zote. Formula utakayotumia ni
=if(and(A1>=0,A1<=20),"F",if(and(A1>=21,A1<=40),"C",if(and(A1>=41,A1<=60),"B","A")))

Nimetumia simu kuandika hiyo formula kama itakuwa na ishu usisite kuleta mrejesho.

Kutumia if peke yake next tyme nikiwa kwa keyboard ya pc.


Barikiwa.
ukishatambulisha "if(and("huitaji kuongeza tena IF mkuu,
 
INGENJA

INGENJA

JF-Expert Member
Joined
Sep 11, 2012
Messages
4,995
Points
2,000
INGENJA

INGENJA

JF-Expert Member
Joined Sep 11, 2012
4,995 2,000
kama we ni good expert wa Excel nenda kwenye help wakati mwingine kisha andika unachotaka kufanya kwenye search box,itakuwa vizuri sana kama utakuwa online sababu itakupa many assistance toka kwenye other sites...pia najua lazima utahitaji kufany ranking pia
 
Ziltan

Ziltan

JF-Expert Member
Joined
Aug 20, 2011
Messages
1,411
Points
1,250
Age
36
Ziltan

Ziltan

JF-Expert Member
Joined Aug 20, 2011
1,411 1,250
Unaweza kutumia if au if(and( functions.
A. Kutumia if(and( function.
Fikiria mfano huu;
Marks. Divisheni
0-20. F
21-40. C
41-60. B
>60. A

Namna nzuri na rahisi ni kufanya kwa kutumia if(and function sababu yenyewe inaangalia extreme points zote. Formula utakayotumia ni
=if(and(A1>=0,A1<=20),"F",if(and(A1>=21,A1<=40),"C",if(and(A1>=41,A1<=60),"B","A")))

Nimetumia simu kuandika hiyo formula kama itakuwa na ishu usisite kuleta mrejesho.

Kutumia if peke yake next tyme nikiwa kwa keyboard ya pc.


Barikiwa.
ahsante sana Mkuu,
ngoja nitest ntarudisha feedback
 
Ziltan

Ziltan

JF-Expert Member
Joined
Aug 20, 2011
Messages
1,411
Points
1,250
Age
36
Ziltan

Ziltan

JF-Expert Member
Joined Aug 20, 2011
1,411 1,250
Last edited by a moderator:
Ziltan

Ziltan

JF-Expert Member
Joined
Aug 20, 2011
Messages
1,411
Points
1,250
Age
36
Ziltan

Ziltan

JF-Expert Member
Joined Aug 20, 2011
1,411 1,250
kama we ni good expert wa Excel nenda kwenye help wakati mwingine kisha andika unachotaka kufanya kwenye search box,itakuwa vizuri sana kama utakuwa online sababu itakupa many assistance toka kwenye other sites...pia najua lazima utahitaji kufany ranking pia
inazengua sana Mkuu.
 
Ziltan

Ziltan

JF-Expert Member
Joined
Aug 20, 2011
Messages
1,411
Points
1,250
Age
36
Ziltan

Ziltan

JF-Expert Member
Joined Aug 20, 2011
1,411 1,250
Nyasiro ana software inayoweza kucalculate division for you...

tembelea http://www.nyasiro.com udownload
nangoja umeme urudi niitest mkuu.
 
Last edited by a moderator:
K

Kyatsvapi

JF-Expert Member
Joined
May 15, 2009
Messages
322
Points
225
K

Kyatsvapi

JF-Expert Member
Joined May 15, 2009
322 225
ukishatambulisha "if(and("huitaji kuongeza tena IF mkuu,
@ Ingeja: Ni wapi hapo ambapo if imetambulishwa baada ya if(and?
Nilichoandika hapo ni rahisi kutumia ni suala la kuongeza range kulingana na mahitaji....
Nasubiri mrejesho toka kwa mhusika...
 
Mwl.RCT

Mwl.RCT

Verified Member
Joined
Jul 23, 2013
Messages
7,684
Points
2,000
Mwl.RCT

Mwl.RCT

Verified Member
Joined Jul 23, 2013
7,684 2,000
Code:
=if(d6>=75,"A",IF(d6>=60,"B+",IF(d6>=50,"B",IF(d6>=40,"C",IF(d6>=30,"D",IF(d6>=20,"E","F"))))))
  • Chukulia kwamba alama za wanafunzi zipo COLUMN D
  • Copy na kupaste hiyo kanuni kwenye column E
  • Kisha drag katika column E kuelekea chini, hapo kila mwanafunzi atapata Daraja stahili.
Fanya editing ya kanuni kulingana na excell yako kwa kuondoa herufi "D" na kuweka herufi ya column yanye alama za wanafunzi
Nitawezaje kupanga divisions kwa kutumia program ya Excel ? Naombeni msaada wakuu.

Natanguliza shukrani.
Unaweza kutumia if au if(and( functions.
A. Kutumia if(and( function.
Fikiria mfano huu;
Marks. Divisheni
0-20. F
21-40. C
41-60. B
>60. A

Namna nzuri na rahisi ni kufanya kwa kutumia if(and function sababu yenyewe inaangalia extreme points zote. Formula utakayotumia ni
=if(and(A1>=0,A1<=20),"F",if(and(A1>=21,A1<=40),"C",if(and(A1>=41,A1<=60),"B","A")))

Nimetumia simu kuandika hiyo formula kama itakuwa na ishu usisite kuleta mrejesho.

Kutumia if peke yake next tyme nikiwa kwa keyboard ya pc.


Barikiwa.
ukishatambulisha "if(and("huitaji kuongeza tena IF mkuu,
ahsante sana Mkuu,
ngoja nitest ntarudisha feedback
 
INGENJA

INGENJA

JF-Expert Member
Joined
Sep 11, 2012
Messages
4,995
Points
2,000
INGENJA

INGENJA

JF-Expert Member
Joined Sep 11, 2012
4,995 2,000
@ Ingeja: Ni wapi hapo ambapo if imetambulishwa baada ya if(and?
Nilichoandika hapo ni rahisi kutumia ni suala la kuongeza range kulingana na mahitaji....
Nasubiri mrejesho toka kwa mhusika...
Hapo mkuu uluipo anza na formula ya If(and(...then kuanzia logic zinazofuata hazikuhitaji matu,izi mengine ya If..mfano nikama hapa kwenye formula yako;=if(and(A1>=0,A1<=20),"F",if(a nd(A1>=21,A1<=40),"C",if(and(A 1>=41,A1<=60),"B","A"))),

ilitakiwa kuwa kwamfumo huu..If(and(logic 1),(logic2).......))....Mtazamo wangu huo mwanajamvi
 
INGENJA

INGENJA

JF-Expert Member
Joined
Sep 11, 2012
Messages
4,995
Points
2,000
INGENJA

INGENJA

JF-Expert Member
Joined Sep 11, 2012
4,995 2,000
Code:
=if(d6>=75,"A",IF(d6>=60,"B+",IF(d6>=50,"B",IF(d6>=40,"C",IF(d6>=30,"D",IF(d6>=20,"E","F"))))))
  • Chukulia kwamba alama za wanafunzi zipo COLUMN D
  • Copy na kupaste hiyo kanuni kwenye column E
  • Kisha drag katika column E kuelekea chini, hapo kila mwanafunzi atapata Daraja stahili.
Fanya editing ya kanuni kulingana na excell yako kwa kuondoa herufi "D" na kuweka herufi ya column yanye alama za wanafunzi
hii formula itakuwa ndefu na inaweza isikupe majibu accurate mwalim,hii inafaa pahala ambapo logic zina same relation naweza sema lakini matumizi ya if(and( yenyewe hufanya mgawanyo au uhusioano wa logic moja na nyingine
 
Ziltan

Ziltan

JF-Expert Member
Joined
Aug 20, 2011
Messages
1,411
Points
1,250
Age
36
Ziltan

Ziltan

JF-Expert Member
Joined Aug 20, 2011
1,411 1,250
Code:
=if(d6>=75,"A",IF(d6>=60,"B+",IF(d6>=50,"B",IF(d6>=40,"C",IF(d6>=30,"D",IF(d6>=20,"E","F"))))))
  • Chukulia kwamba alama za wanafunzi zipo COLUMN D
  • Copy na kupaste hiyo kanuni kwenye column E
  • Kisha drag katika column E kuelekea chini, hapo kila mwanafunzi atapata Daraja stahili.
Fanya editing ya kanuni kulingana na excell yako kwa kuondoa herufi "D" na kuweka herufi ya column yanye alama za wanafunzi
nimefanya lakini inaniambia the formula entered contains some error,
then ina highlight kwa black colour kwenye daraja ''A''
 
Ziltan

Ziltan

JF-Expert Member
Joined
Aug 20, 2011
Messages
1,411
Points
1,250
Age
36
Ziltan

Ziltan

JF-Expert Member
Joined Aug 20, 2011
1,411 1,250
hii formula itakuwa ndefu na inaweza isikupe majibu accurate mwalim,hii inafaa pahala ambapo logic zina same relation naweza sema lakini matumizi ya if(and( yenyewe hufanya mgawanyo au uhusioano wa logic moja na nyingine
Code:
=if(d6>=75,"A",IF(d6>=60,"B+",IF(d6>=50,"B",IF(d6>=40,"C",IF(d6>=30,"D",IF(d6>=20,"E","F"))))))
  • Chukulia kwamba alama za wanafunzi zipo COLUMN D
  • Copy na kupaste hiyo kanuni kwenye column E
  • Kisha drag katika column E kuelekea chini, hapo kila mwanafunzi atapata Daraja stahili.
Fanya editing ya kanuni kulingana na excell yako kwa kuondoa herufi "D" na kuweka herufi ya column yanye alama za wanafunzi
nimefanya lakini inaniambia the formula entered contains some error,
then ina highlight kwa black colour kwenye daraja ''A''
 
N

Nyasiro

Verified Member
Joined
Feb 20, 2012
Messages
1,282
Points
1,225
N

Nyasiro

Verified Member
Joined Feb 20, 2012
1,282 1,225
Excel ni spreadsheet yenye nguvu na uwezo mkubwa. Kama ingekuwa inatengenezwa na kampuni ya kitanzania basi hii kitu ingekuwa intergrated kirahisi. Ziltan Mwl.RCT INGENJA na wengine msipate tabu sana. Hii kitu nimeirahisisha kwa kutengeneza program inayoitwa ACSEE Professional ambayo ni spreadsheet program kama excel inafanya calculation hizi kwa ufasaha na haraka, pia ina features nyingine nyingi sana ambazo zinamsaidia mwalimu katika mchakato mzima wa kuandaa matokeo. Kama alivyodokeza C6 na chief-mkwawa mnaweza kudownload program hii kupitia hapa

bado sioni sababu ya watu kutoitumia program hii na kung'ang'ana na excel au bado watu tuna kasumba ya kudharau vitu vya ndani hata kama vinafaa!!!!!

Pia kwa kipindi fulani nimekuwa nikiongeza baadhi ya feature mbalimbali. Kitu cha muhimu ambacho nimekiongeza ni "BRN System" kwa kutumia mfumo huu unaweza kuchagua kutafuta matokeo kwa kutmia mfumo wa zamani au huu wa sasa wa BRN. Kitu kingine cha msingi ni summary ambayo itakusaidia kupata summary ya matokeo mfano div 1 zipo ngapi n.k bila kupoteza muda.

angalia video hii

 
Last edited by a moderator:
INGENJA

INGENJA

JF-Expert Member
Joined
Sep 11, 2012
Messages
4,995
Points
2,000
INGENJA

INGENJA

JF-Expert Member
Joined Sep 11, 2012
4,995 2,000
Excel ni spreadsheet yenye nguvu na uwezo mkubwa. Kama ingekuwa inatengenezwa na kampuni ya kitanzania basi hii kitu ingekuwa intergrated kirahisi. Ziltan Mwl.RCT INGENJA na wengine msipate tabu sana. Hii kitu nimeirahisisha kwa kutengeneza program inayoitwa ACSEE Professional ambayo ni spreadsheet program kama excel inafanya calculation hizi kwa ufasaha na haraka, pia ina features nyingine nyingi sana ambazo zinamsaidia mwalimu katika mchakato mzima wa kuandaa matokeo. Kama alivyodokeza C6 na chief-mkwawa mnaweza kudownload program hii kupitia hapa

bado sioni sababu ya watu kutoitumia program hii na kung'ang'ana na excel au bado watu tuna kasumba ya kudharau vitu vya ndani hata kama vinafaa!!!!!

Pia kwa kipindi fulani nimekuwa nikiongeza baadhi ya feature mbalimbali. Kitu cha muhimu ambacho nimekiongeza ni "BRN System" kwa kutumia mfumo huu unaweza kuchagua kutafuta matokeo kwa kutmia mfumo wa zamani au huu wa sasa wa BRN. Kitu kingine cha msingi ni summary ambayo itakusaidia kupata summary ya matokeo mfano div 1 zipo ngapi n.k bila kupoteza muda.

angalia video hii

sipingani nawewe mzazi ,nafurahi kwa hatua ulioifikia japo sijapata wasaha wakuipitia kiundani zaidi almost umeji bbind kwenye Excel features,still you have done a great job mzee
 
Last edited by a moderator:
michosho

michosho

JF-Expert Member
Joined
Mar 17, 2012
Messages
492
Points
500
Age
7
michosho

michosho

JF-Expert Member
Joined Mar 17, 2012
492 500
Unaweza kutumia if au if(and( functions.
A. Kutumia if(and( function.
Fikiria mfano huu;
Marks. Divisheni
0-20. F
21-40. C
41-60. B
>60. A

Namna nzuri na rahisi ni kufanya kwa kutumia if(and function sababu yenyewe inaangalia extreme points zote. Formula utakayotumia ni
=if(and(A1>=0,A1<=20),"F",if(and(A1>=21,A1<=40),"C",if(and(A1>=41,A1<=60),"B","A")))

Nimetumia simu kuandika hiyo formula kama itakuwa na ishu usisite kuleta mrejesho.

Kutumia if peke yake next tyme nikiwa kwa keyboard ya pc.


Barikiwa.
Mkuu inaonyesha unaelewa vizuri kuitumia excel,....nami naomba unitoe jinsi ya kupanga position.mfano mwanafunzi 1 hadi wa mwisho kama watakuwa wanafunzi 4000. wanapangwa kulingana na wastan wao.
 

Forum statistics

Threads 1,295,919
Members 498,479
Posts 31,228,043
Top