productivity tool

7/26/2019 Productivity Tool

1/37


2/37

WHAT IS THE TOOL ALL ABOUT?

PRODUCTIVITY TOOLSA collection o tool!, con!i!tin" o #$!ine!! %&oce!!e!,

'(&)*(&e o& !ot*(&e +o& ( co#in(tion o t'e!e- t'(t

in)ii)$(l! (n) o&"(ni/(tion! (0 $!e to en'(nce le(&nin",

inc&e(!e %&o)$ctiit0 (n) %&oote c&e(tiit01 (0 #e $!e) to

coll(#o&(te in t'e con!t&$ction o en'(nce) o)el! o&

et'o)!, to %&e%(&e %$#lic(tion! (n) i%&oe

co$nic(tion.


3/37

WHAT IS THE TOOL ALL ABOUT? Productivity software+!oetie! c(lle) personal

productivity softwareo& office productivity software) i!(%%lic(tion !ot*(&e )e)ic(te) to %&o)$cin" ino&(tion,

!$c' (!

)oc$ent!, %&e!ent(tion!, *o&2!'eet!, )(t(#(!e!, c'(&t!,

"&(%'!, )i"it(l %(intin"!, elect&onic $!ic (n) )i"it(l i)eo.

It! n(e! (&o!e &o t'e (ct t'(t it inc&e(!e! %&o)$ctiit0,

e!%eci(ll0 o in)ii)$(l oice *o&2e&!,

&o t0%i!t! to 2no*le)"e *o&2e&!, (lt'o$"' it! !co%e i! no*

*i)e& t'(n t'(t.


4/37

WHAT IS THE TOOL ALL ABOUT?OIC! SUIT!

An office suitei! ( collection o #$n)le) %&o)$ctiit0

!ot*(&e +( !ot*(&e !$ite- inten)e) to #e $!e)

#0 2no*le)"e *o&2e&!. T'e co%onent! (&e "ene&(ll0

)i!t&i#$te) to"et'e&, '(e ( con!i!tent $!e& inte&(ce (n)

$!$(ll0 c(n inte&(ct *it' e(c' ot'e&, !oetie! in *(0! t'(t

t'e o%e&(tin" !0!te *o$l) not no&(ll0 (llo*.


5/37

WHAT IS THE TOOL ALL ABOUT?"#SIC PRODUCTIVITY TOOLS

B(!ic %&o)$ctiit0 tool! (&e co%$te& !ot*(&e %&o"&(!

*'ic' (llo* ( $!e& to c&e(te !%eciic ite! 3$ic2l0 (n) e(!il0

(! o%%o!e) to c&e(tin" t'e !(e ite! #0 '(n).

T'&ee !%eciic %&o)$ctiit0 tool! (&e4

$ord processin%

Spreads&eets

Data'ases


6/37

$ORD PROC!SSI( Wo&) %&oce!!in" i! t'e %'&(!e $!e) to )e!c&i#e using

a computer to create, edit, and print documents. O

(ll co%$te& (%%lic(tion!, *o&) %&oce!!in" i! t'e o!tcoon. To %e&o& *o&) %&oce!!in", 0o$ nee) ( co%$te&,

( !%eci(l %&o"&( c(lle) ( word processor, (n) ( %&inte&. A

*o&) %&oce!!o& en(#le! 0o$ to c&e(te ( )oc$ent, !to&e it

elect&onic(ll0 on ( )i!2, )i!%l(0 it on ( !c&een, o)i0 it #0

ente&in" co(n)! (n) c'(&(cte&! &o t'e 2e0#o(&), (n)%&int it on ( %&inte&.


7/37

$ORD PROC!SSI(* $+Y US!,

T'e "&e(t ()(nt("e o *o&) %&oce!!in" oe& $!in" (

t0%e*&ite& i! t'(t 0o$ c(n (2e c'(n"e! *it'o$t &et0%in" t'eenti&e )oc$ent. I 0o$ (2e ( t0%in" i!t(2e, 0o$ !i%l0

#(c2 $% t'e c$&!o& (n) co&&ect 0o$& i!t(2e. I 0o$ *(nt

to )elete ( %(&("&(%', 0o$ !i%l0 &eoe it, *it'o$t le(in"

( t&(ce. It i! e3$(ll0 e(!0 to in!e&t ( *o&), !entence, o&

%(&("&(%' in t'e i))le o ( )oc$ent. Wo&) %&oce!!o&!

(l!o (2e it e(!0 to oe !ection! o te5t &o one %l(ce to

(not'e& *it'in ( )oc$ent, o& #et*een )oc$ent!. W'en

0o$ '(e ()e (ll t'e c'(n"e! 0o$ *(nt, 0o$ c(n !en)

t'e ile to ( %&inte& to "et ( '(&) co%0.


8/37

$ORD PROC!SSI(* $+!( TO US!,

Wit'in t'e #$!ine!! *o&l), *o&) %&oce!!o&! (&e

e5t&eel0 $!e$l tool!. T0%ic(l $!e! incl$)e4 le"(l co%ie!

lette&! (n) lette&'e()

eo!

&ee&ence )oc$ent!

B$!ine!! ten) to '(e t'ei& o*n o&(t (n) !t0le

o& (n0 o t'e!e. T'$!, e&!(tile *o&) %&oce!!o&!

*it' l(0o$t e)itin" (n) !iil(& c(%(#ilitie! in)

*i)e!%&e() $!e in o!t #$!ine!!.


9/37

$ORD PROC!SSI(* +O$ TO US!,

CR!#TI( L!TT!R+!#D -usin% te.plate)

ST!P /* O%en Wo&). W'en 0o$ o%en *o&), ( !election o

)ie&ent t0%e! o ne* )oc$ent! *ill (%%e(&.


10/37


CR!#TI( L!TT!R+!#D -usin% te.plate)

ST!P 0* Select t'e Lette&'e()! c(te"o&0. T'i! *ill o%en (

li!t o lette&'e() te%l(te!.


11/37

$ORD PROC!SSI(* +O$ TO US!,CR!#TI( L!TT!R+!#D -usin% te.plate)

ST!P 1* C$!toi/e 0o$& lette&'e(). O%en 0o$& te%l(te

in Mic&o!ot Wo&) (n) !t(&t c$!toi/(tion. U%)(te 0o$&

co%(n06! title, cont(ct ino&(tion (n) lo"o


12/37

$ORD PROC!SSI(* +O$ TO US!,CR!#TI( L!TT!R+!#D -usin% te.plate)

ST!P 1* C$!toi/e 0o$& lette&'e(). O%en 0o$& te%l(te

in Mic&o!ot Wo&) (n) !t(&t c$!toi/(tion. U%)(te 0o$&

co%(n06! title, cont(ct ino&(tion (n) lo"o


13/37

ST!P 2* Reie* 0o$&lette&'e() #0 %&e!!in" ESC

to clo!e t'e He()e& (n)

7oote& !ection!3

ST!P 4* S(e 0o$&lette&'e() to 0o$& '(&)

)&ie.



14/37

SPR!#DS+!!TA spreads&eeti! (n inte&(ctie co%$te& (%%lic(tion o&

o&"(ni/(tion, (n(l0!i! (n) !to&("e o )(t( in t(#$l(& o&.

S%&e()!'eet! (&e )eelo%e) (! co%$te&i/e) !i$l(tion! o%(%e& (cco$ntin" *o&2!'eet!. T'e %&o"&( o%e&(te! on )(t(

ente&e) in cell! o (n (&&(0, o&"(ni/e) in &o*! (n) col$n!.

E(c' cell o t'e (&&(0 (0 cont(in eit'e& n$e&ic o& te5t

)(t(, o& t'e &e!$lt! o o&$l(! t'(t ($to(tic(ll0 c(lc$l(te

(n) )i!%l(0 ( (l$e #(!e) on t'e content! o ot'e& cell!.


15/37

SPR!#DS+!!T* $+Y US!,

ast5 #ccurate Calculations

Not onl0 c(n !%&e()!'eet! %e&o& #(!ic ())ition, !$#t&(ction,$lti%lic(tion (n) )ii!ion, t'e0 (l!o (2e ((il(#le (n0

in(nci(l, !cientiic (n) !t(ti!tic(l (t'e(tic(l $nction! (! *ell.

In ())ition, 0o$ c(n %&int 0o$& *o&2 o& !(e it (! ( !%&e()!'eet

o& *o&2#oo2 ile o& &ee&ence o& l(te& $!e.

$&at If ScenariosM(n("e&! co$l) )e!i"n !%&e()!'eet! t'(t %&o8ecte) t'e

con!e3$ence! o t'eo&etic(l c'(n"e! in inento&0, c(%it(l

ine!tent!, *o&2o&ce o& !(le! (n) (&2etin" !t&(te"ie! on t'e

#otto line.


16/37

SPR!#DS+!!T* $+Y US!, Spreads&eet Data'ases

S%&e()!'eet! !to&e ino&(tion $!in" &o*! (n) col$n! t'(t

co&&e!%on) to t'e &eco&)! (n) iel)! $!e) #0 )(t(#(!e!ot*(&e !$c' (! E5cel, O%enOice C(lc o& 9$(tt&o P&o oe&

#$ilt:in !e(&c' o& loo2:$% $nction! to 'el% 0o$ in) t'e )(t( 0o$

nee) 3$ic2l0.

"asic #ccountin% #pplication

B$!ine!! !ot*(&e )eelo%e&! '(e c&e(te) !%&e()!'eet(%%lic(tion! 0o$ c(n %$&c'(!e (n) $!e to %e&o& #$!ine!!

(n("eent, '$(n &e!o$&ce (n) (cco$ntin" %&oce)$&e!.

T'e!e (%%lic(tion! (&e oten c&e(te) $!in" t'e !%&e()!'eet

!ot*(&e;! #$ilt:in (c&o l(n"$("e.


17/37

SPR!#DS+!!T* $+!( US!,

6OD!L I(OR6#TIO(3 T'e (in %$&%o!e o (

!%&e()!'eet i! !to&("e (n) o)elin" o ( )(t( !et. W'(tee$!ine!! !ecto& 0o$ (&e in, 0o$ *ill li2el0 '(e ( !to&e o

ino&(tion t'(t i! %otenti(ll0 o "&e(t (l$e to 0o$.

S%&e()!'eet! o)el in(nci(l, !t(ti!tic(l (n) (n0 ot'e&

n$e&ic(l )(t( *it'in !0!te! o &o*! (n) col$n!.

6#(IPUL#T! D#T#3 In ())ition to !to&in" (n) o)elin")(t(, !%&e()!'eet! c(n (ni%$l(te (n) (n(l0/e )(t( !et!.

Mo!t !%&e()!'eet %&o"&(! (llo* $!e&! to ente& c$!to

o&$l(!, *it' ( &(n"e o coonl0 $!e) %&e!et $nction!

(l!o ((il(#le.


18/37

SPR!#DS+!!T* $+!( US!,

VISU#LI7! R#P+IC#LLY3 S%&e()!'eet %&o"&(! incl$)e tool!

o& )(t( i!$(li/(tion. W'en 0o$ '(e ( )(t( !et !to&e) *it'in (

!%&e()!'eet, 0o$ c(n $!e t'i! )(t( (! t'e #(!i! o& "&(%'ic(l

)i!%l(0! !$c' (! #(& c'(&t!, "&(%'! (n) %ie c'(&t!, *it' ( &(n"e o

c'(&tin" o%tion! 0o$ c(n e)it to !$it 0o$& o*n nee)!.

I(OR6 D!CISIO(S. T'e (#ilit0 to (n(l0/e (n) %&e!ent )(t(

!et! e(n! t'(t !%&e()!'eet! (&e $!e) *it'in (n0 co%(nie! to

ino& t'e )eci!ion:(2in" %&oce!!. An0 eectie $t$&e %l(nnin"

(ctiit0 n(t$&(ll0 nee)! to #e ino&e) #0 ( cle(& %ict$&e o t'e

%&e!ent (n) %(!t, ( t(!2 !%&e()!'eet! (&e i)e(ll0 %l(ce) to (!!i!t.

S%&e()!'eet! (llo* 0o$ to c(&&0 o$t %e&o&(nce e(!$&eent


19/37

ST!P /* Open 6icrosoft !8cel3

SPR!#DS+!!T* +O$ TO US!,


20/37

ST!P 0* !nter your data line 'y line into your spreads&eet3 Leave t&e total

colu.ns 'lan9 for t&e ti.e 'ein%3



21/37

ST!P 1* To %et t&e total5 enter e:ual si%n to indicate you want to

start a function3 C&oose fro. t&e list of e:uations you would li9e to

perfor.5 suc& as su. -for addition or su'traction) or .ultiplication3



22/37

ST!P 2* C&oose your data ran%e t&at you want to add

to%et&er5 if you are usin% t&e ;Su.< function3



23/37

ST!P 4* Press ;!nter< to finis& your e:uation3 T&e

spreads&eet s&ould auto.atically do t&e .at&3



24/37

ST!P =* You .ay .a9e your own Profit and Loss

State.ent3



25/37

D#T# "#S!

A )(t(#(!e i! ( collection o ino&(tion t'(t i!

o&"(ni/e) !o t'(t it c(n e(!il0 #e (cce!!e),

(n("e), (n) $%)(te). In one ie*, )(t(#(!e!c(n #e cl(!!iie) (cco&)in" to t0%e! o content4

#i#lio"&(%'ic, $ll:te5t, n$e&ic, (n) i("e!.


26/37

D#T#"#S! 6#(#!6!(T SYST!6 -D"6S)

A )(t(#(!e (n("eent !0!te +DBMS- i! (

!0!te t'(t !to&e! (n) &et&iee! ino&(tion in (

)(t(#(!e. It i! $!e) to 'el% 0o$ o&"(ni/e 0o$& )(t((cco&)in" to ( !$#8ect, !o t'(t it i! e(!0 to t&(c2

(n) e&i0 0o$& )(t(, (n) 0o$ c(n !to&e ino&(tion

(#o$t 'o* )ie&ent !$#8ect! (&e &el(te), !o t'(t it

(2e! it e(!0 to #&in" &el(te) )(t( to"et'e&.


27/37

D#T#"#S!* $+Y US!,

Re)$ce) )(t( &e)$n)(nc0

Re)$ce) $%)(tin" e&&o&! (n) inc&e(!e) con!i!tenc0 G&e(te& )(t( inte"&it0 (n) in)e%en)ence &o (%%lic(tion!

%&o"&(!

I%&oe) )(t( (cce!! to $!e&! t'&o$"' $!e o 'o!t (n)

3$e&0 l(n"$("e!

I%&oe) )(t( !ec$&it0

Re)$ce) )(t( ent&0, !to&("e, (n) &et&ie(l co!t!

7(cilit(te) )eelo%ent o ne* (%%lic(tion! %&o"&(


28/37

D#T#"#S!* $+!( US!,

T'e ino&(tion i! ( l(&"e (o$nt t'(t *o$l) #ecoe

$n(n("e(#le in !%&e()!'eet o& (n) i! &el(te) to (

%(&tic$l(& !$#8ect.

Yo$ *(nt to (int(in &eco&)! o& on"oin" $!e.

T'e ino&(tion i! !$#8ect to (n0 c'(n"e! +c'(n"e o

())&e!!, %&icin" c'(n"e!, etc.-.

Yo$ *(nt to "ene&(te &e%o&t! #(!e) on t'e ino&(tion.


29/37

ST!P /* Create a spreads&eet in e8cel3 Save t&e spreads&eet

to a location on your &ard drive3 You can also use an e8istin%

e8cel spreads&eet3

D#T#"#S!* +O$ TO US!,


30/37

ST!P 0* Launc& 6icrosoft #ccess3 Open an e8istin%

6icrosoft #ccess data'ase or create a new 'lan9 data'ase3

D#T#"#S!* +O$ TO US!,


31/37

ST!P 1* Clic9 t&e ;!8ternal Date< ta' and select t&e

;!8cel< icon on t&e ri''on3

D#T#"#S!* +O$ TO US!,


32/37

ST!P 2* Clic9 t&e ;"rowse< 'utton to navi%ate to t&e

location of t&e e8cel spreads&eet3

D#T#"#S!* +O$ TO US!,


33/37

ST!P 4* Specify &ow would you li9e t&e infor.ation to

transfer to t&e data'ase 'y selectin% one of t&e followin%

options %iven3

D#T#"#S!* +O$ TO US!,


34/37

ST!P =* Select t&e s&eet you want to i.port fro. t&e

list3

D#T#"#S!* +O$ TO US!,


35/37

ST!P >* Leave t&e c&ec9.ar9 in ;irst Row Contains Colu.n

+eadin%s5< if t&at is t&e case3 If not5 re.ove t&e c&ec9.ar9 and

#ccess will create its own colu.n &eadin%s3 Clic9 ;(e8t3@.

S'oe L(ce!4 Reen$e= [email protected] Co!t= S>.@ Co$"(& P$%!4 Reen$e= S>.1 Co!t= S.

U!e t'e o&$l(, Reen$e Co!t= Tot(l P&oit

productivity tool

Documents