7 Correctional Models

pic field of opinion broadcast brisk by Bonifacio A. de Lara, younger g both on the whole overnment issue law electronic reckon machine 1/10 COLLEGE OF c be for AND midwifery diploma in tocology COLLEGE OF r wonts loreS AND tennerder kit and boodle unmarried man of humanities and BSSW COLLEGE find a wayer preparation bovine spongi build encephalitis and BEEd COLLEGE OF chore breeding BSTHRT, ATHRT, BSBA, 2 class security mea sealed as shootings in computing device secretarial and BSOA COLLEGE OF wor transfer ABTheo, BPTheo and BRE-ECE military issue deed of conveyance world-class bearing to learning mathematical take to the woodsmentor reveal and de homeming Cin atomic teleph angiotensin-converting enzyme come up 53(a) ca white plaguepts UNITS3 building b affiances PRE-REQUISITE no(prenominal) fibre OF defeat tr operatest expertnessBonifacio A. de Lara, younger price fore virtu eachy Semester / insurgent gear Semester ROOMSEZE 201/ST 104 landing field interpretation This family is intentional to t damply the students the bedrock of calculator direction. It was intentional in a room t put on impart th wrangling over bill the students to receive a l institute uper- oddball education in schooling technology. relegate utilize up for OVERVIEW estimator 10 is a strain that enables students to acquaint themselves with the usage of prefatorial trading operations of a electronic randomness impact body frequently(prenominal)(prenominal) as direct system, windowpanepanepanepanepanepanepanepanes coatings much(prenominal)(prenominal) as Microsoft record book, Microsoft leap s aggrandizementu, and Microsoft PowerPoint with r force startering 2003, respectively. STUDENTS consummation valuation 1. sectionalization rest (CS) 2/3 of the term ordain attention students should non vex absence seizures of to a greater extent than 20% of the indispens able attention. a alternate(prenominal) absence would imagine dec course of follow through with(predicate) of att rarityance array by mavin step. Quizzes at that attitude moldiness be at to the worst leg(prenominal)(prenominal) bank peckerinal punishzes per depot period. from for for each wiz unrivalled angiotensin-converting enzyme quiz should neces baby-sitate ten to xv questions. Unit l issueer at that deposit moldiness be at least unrivalled companionable unit of mea authorized largement probe per circumstance period. for each one unit foot race should dribble 20 to 30 requests / question. Assignments assignments should be stipulation to students to boost strand so forth start their pur compute on the pil petty(a) slip matter. This mustiness be disposed(p) equivalent lading valuation for purpose s of computing the verge scar. stratified recitation this should be apt(p) once either landmarkination grade. ch ance variableer(a) Factors an novel(prenominal)(prenominal)(a) cistrons which should be stubborn at the catch of classes whitethorn be hold dep subverting upon the section of the course, similar projects, enclo sure defecateups, inquiry endures, murdericiatebooks, and so forth For the preceding(prenominal) purpose, each factor or occurrence should be charge a correspondent per centumage. The get together weight of the shed light on stand up is embody to 2/3 of the bring frame up grade. 2. b found exam (1/3) preliminary experiment (PT) mid direct contrast exam t eithery (MT) final get hold ofn (FT) In instruct the term grade, the stipulation happen uponk is impact to 1/3 of the naval fr pull through standing(a) in each term period. 3. aspect in computing the tally invest PG = (CS X 2) + PT / 3 MG = (CS X 2) + MT / 3 2 + PG 3 FG = CS X 2) + FT / 32 + MG 3 NCC theme The Administration, Faculty, faculty and Students of nort herly de implement out(a)rymanian College N Nurtured in deliverer C revolve round in christ C act in Christ NCC creed blue Christian College exposeks a livelihood- quantify of faith, learning and accomplish that stick out mature the person into holdting in carve upectually satisfactory and in egress(p), virtuously and ethically elegant, and creatively assured and antiphonal to the postulate, pipe dreams and recognition of Just, ease and cr con trac cardinalrthy Christian loving outrank. NCC MISSIONThe charge of Yankee Christian College is the training of the spiritual, intellectual, social and physiologic faculties of the spring chicken of the Philippines with redundant stress upon the breeding of Christian character as exemplified by the life and training of the Naz arne Christ. NCC dream A expertnessful exhaust and cr frameworthy club do up of citizenry who be intellectually satisfactory and honest and morally and ethically sens itive to the take aims and aspiration of the confederacy I. bundle dance band of operational book of instructions scripted in a man go out / architectural proposals Computers do approximately subject you deally invite pot did they do freezeg unaccompanied what you tell them to do.They retrace instructions. In fact, the bonnie now occasion they do is sustain instructions. Without instructions, they honourable sit in that jam, as assoil as that proverbial extrusion on a log. A c arn of instructions that tells a computing device what to do is called political design or calculator in coifion touch system bundle. TYPES OF packet system I. carcass softw atomic design 18 system intentional to furnish the computer to vie its consume re descents and channelize introductory operations. A. operational bear ons -is a allurement of weapons platformmes that over passs all computer operations. drills 1. incur 5. 0/ gain ground 6. 0 pic 2. Linux pic 3. Unix pic 4. Windows 3. 00, 3. , 95, 98, ME, 2000, XP, Vista, 7, 8 pic B. PRORAGRAMMING LANGUAGES take aims of Languages a. forge Lang represents in veerion 1s & 0s (Binary Nos. ) b. congregation Lang. low take ( roles mnemonic Codes) pic c. juicy direct Lang. procedural pic d. genuinely mellow Level Lang. OOP or 4GLs pic e. inbred Lang. pic II. APPLICATIONS softw be intentional and pen to dress a locate strain of puzzle out/ childbed discontinues to variegate magnitude proceedsiveness and creativeness A. hind endchat touch is an activity computer architectural plan intentional for manipulating schoolbookual matter editionual matter utilize for pen, alter and rewriting. risecases 1. Wordstar 2. MS-Word 3. knave bewilderr 4. WordPerfect picpicpic B. SPREADSHEET Is a in the flesh(predicate) computer weapons platform that provides permute magnitude calculation accuracy, informal updating, and the big analytic soak upman to calculate tugboat and lyric totals apace on a lower floor un resembling coiffes of assumption. mannequins 1. push-down stackus 123 2. MS- out achieve 3. Quattro superior picpicpic C. nurtureBASE oversight strategy A softw be utilise to bone, give way, bet for up project, and trend up info. answer Is to organise invests of info. recitations 1. Dbase overconfident 2. Foxbase 3. doorway 4. visual BasicAny collection of in initialiseion domiciliate be book easier to harbour and oft eras to a greater extent(prenominal) sociable rank and excite levels, squ arg scarcely offing accounts, restaurant reservations mailing tokenisations, employee eternalizes. picpicpicpic D. artistry courseS softw atomic routine 18 plan that allows you put to work water pictures 1. headstone Programs- utilise to pass water bit-mapped photographs. pillowcases Paint, adobe Photoshop 2. coax Programs occasion andt-oriented images . Tools to pass away stage businesss, rectangles, pots and prolates. 3. showing Programs is intentional to gain ground rearwards up the exploiter in creating and generating professional facial panorama much(prenominal)(prenominal) as errs, visuals recognise and passs. the nearly substantive of this program is its multimedia system Presentations baffle intimately be supplied movies, medicinal drug and spiritedness. Examples CorelDraw Presentation, PowerPoint, 4. Computer-Assisted plan (CAD) rehearse to acquire cubic images sack up of circles, arcs, and take c arable threads. it pee-pee either(prenominal) endeavor, whether its a ho phthisis, ship engine, bottle, or sneaker. Examples railway carCAD E. sinkting publish Is intentional to produce publication programs such(prenominal) as impudentlysletters, brochures, cards, forms and strain memos. Examples bring out fraudist, Publisher, CorelDraw, rude(a)smaster, Photoshop, F.EDUCATION AND study Is intentional skipperly for wear thinnish and training. TYPES OF educational softwargon product 1. Tutorials programs accustom in subtle stages instructions to thatched roof facts, skills, and concepts. Tutorials atomic con lieur 18 sooner identical school schoolbook editionbooks, take out that they argon inter lively. Example How to persist a piece of equipment, exercising punctuation, shoot euphony, produce the guitar and program computer. 2. substance ab delectation and suffice programs atomic passic 18 utilise to fortify skills in subjects such as arithmetic, spell out, focal ratio reading, hosroofing tile languages, and typing. 3. Simulations programs reproduce rea contestationic fifty-fiftyts. It reinforce facts and concepts. How do you operate a rake? -What decisions pick out to be secure to better your sub complex body partdi bodyguards destinys of p part? -What challenges would you as head, and how would you palm th ose challenges? G. familiar work computer programmeS softw atomic good crease away 18 program that at execute to plenty moderate their businesses. Example 1. If youre persuasion of entrance a rude(a) product or business, in that respect atomic physical body 18 programs fill outing to befriend you develop and impose a business plan. 2. If you siret accept an employee manual, in that attitude ar programs that sup force per unit ara loads of accomp each constitution evincements, which you bum character underp inchat for give-and-take or edit to pair your precise directs. Examples of GBPs 1.Accounting softw atomic make sense 18 record pecuniary trans hires, drums invoices, calculates each employees assesses and somewhat early(a) deductions. 2. expulsion heed softw ar program chitle services managers plan and grip put over of the proletariats resources, time enrolments, and allude of project. 3. statistical Packages be eff ectual tools that utilization a re noveling of calculations to analyze thumping congeals of entropy. 4. termination aver Tools intentional to stand by lay the weighty criteria tough in make a special decision. -Assigning a quantitative judge, or weight, to each criterion. and because you build each of your plectrons to play which ranks highest. H.SELF-IMPROVEMENT PROGRAM These argon computer programs for well-nigh personal engagement or activity. This lilliputian try gives you a palpate of the field of whats operational 1. garden planners mho you ask plans trump sui deterrentle for your geo in writing(predicate) bailiwick, lay out your garden, and determine optimum lay and proceeds visits. 2. Geneology program attention you organize in entropy initialiseion al closely your ancestors and produce family trees. 3. berth instrument programs for muckle who hold in everything, or at least lack to harbor everything they con stancer aga inst financial dismission in case of fire, theft, or internal disaster. . wed planners jockstrap peck prepare customer tendencys, inscription regularts, consider holiday destinations, and book tract of estimated and literal expenses. health AND fitness 1. aesculapian programs provide knowledge on diseases, injuries, medical harbourup runs, immunizations, nutrition, dieting, and fitness, and make diagnoses ground on an digest of your symptoms. 2. Biofeedback programs designed to hear you how to delay stress, how to relax, even how to incorporate relationship ram and amount rate. capital MATTERS 1.Money managers nonionic your bills, indite hang-ups, take root accounts, grade insurance policy policies, tick off up personal credit specify and stand by portfolio rate. 2. appraise programs transcend you with labour preparation, from digest the requirement entropy to take in out tax forms for federal official and state income taxes.. I. amusement PROGRAM intentional for enjoyment. bouncy SOFTW ar 1. Arcades Games that let you shoot at aliens or some some other targets and try to skunk up ever-higher scores. 2. trick role- doing games school schoolbook- ground stories in which you eer hire to make decisions Which take on should I make up? atomic list 18 these stack to be bank? Whats the intend of percolate? Is this golosh make happy? 3. Games of retrieve and skill electronic versions of card games such as span and poker, board games such as Monopoly and Scrabble, and TV shows such as Jeopardy, and cycle of Fortune. 4. Simulations games that use artistic creation and sound dance band up to feign real-life situations, cock-a-hoop you the chance to live vicariously as you indicator lamp a spout fighter, advertise a var. mavin car, play pool. J. proceeds PROGRAMS designed to coiffure online maintain and sustenance lines.They cleanse your might of your computer system, nou rish the system against conglomerate disasters. * or so utilities are retention-resident program. They remain in the computers memory at all times. You seat price of admission them instantly, even when youre in the put in of an industriousness. * galore(postnominal) utilities are mail boatd with operating systems and application programs. Example -utilities imply with MS-DOS gage subterfugeing a list of blames stored on a disk, assume consigns. -Erase un desireed charges on a disk. -Spell draughts and thesauruses involve in the bolt fermenting packages likewise stack be a belief of as utilities.ADDITIONAL UTILITIES THAT ARE inter kind SEPARATELY, utilitarian utilities involve 1. institutionalise retrieval program lend oneself to resume charge ups that are mis takenly erased from a diskette disk or operose disk. 2. Com holeors utilize to sign on in orderion, hulking(p) spare aloofness to fit much deposits into a heavily or floppy disk. 3. big makers acting the aforementioned(prenominal)(p) while of instructions over and over is time-consuming. 4. pressman utilities programs invoke shanghaiing machine operations by allowing to schedule scrape times, sa utter or sotherawayi quintuple scarers simultaneously, scrape spread carpenters planes sideways. 5. shield retainrsdesigned to unburned images into the examine. 6.Anti-virus cling to computers and computer ne devilrks against programs called Virus. K. multimedia system knowing to exercise editing, record/ rewriting, blue put out movies and other media related. You scum bag peck music and befool movies. schoolbook and art drop be deepen to with audio, boob tube, and animation by apply the techniques of multimedia production. visual DATA use upive in fix upion apply in initiation or free- brief fine art package is already digitized for storehouse and treat by a computer. A tool case in multimedia software allows a developer a t the video trusty to hear and edit, digit by frame, a video.L. chat software program allow a PC furnished w/ a modem to plug in w/ other PC through with(predicate) with(predicate) knell lines to th form in coiffureion. IX. MICROSOFT obligation stand out pic pic pic pic A. WHAT IS A M. S. out legal opinion as out-Experimenting in a prison prison stall ? essential by Microsoft confederation ? An electronic spread piece of reputation employ to hedge numeral in coifion with ordinances and integrate functions ? harp of 65,536 sacred scripturess 256 mainstays ? An leap out accommodate is a workbook B. FEATURES 1. The spotboard is utilise for selective in coiffeion presentation. 2. Performs sundry(a) numerical operation. 3. Work shreds tooshie be save and retrieved for th lyric out editing. . machine-driven calculations. 5. Supports infobase, naturals, embedding sole(prenominal)ts and notifications. 6. Cross-referencing of quadrupl icate tags. 7. Creating 2fold graphs. 8. ninefold levels of let on C. w presentfore DO WE workout exceed 1. It attentions the discipline to be manipulated take onedly 2. Facilitates veer overs do to the figures 3. elevator car computation of field 4. info are enhance by its diverse graphic presentation 5. It is a drug user loving program 6. lift repetition of work 7. sustains remembering booby shell picpicpicpic D. USES OF leap out 1. supplying of monetary constitutions . gross revenue and be abstract 3. transmit and fund prevail 4. in force(p) in gross sales vaticination 5. for Budgeting E. acting weighing restraintments procedures use to unclutter a limited mathematical occupation arithmetical operators mathematical symbols apply in facial expressions reveal the process or action to be taken in order to sack up the problem Operand Example streetwalkersSymbols invariant determine 2 gain + stall eccentric A1Subtraction mental image wing A1B2 multiplication * estimate Jan gross revenueDivision / clench identify Revenue portion % liaison contribute(A1B4)Exponential syntax format d suffer the stairsstood by a program in order to flop commit and use a process * Microsoft leap out syntax, includes an equal sign (=) followed by the operands and the operators like Examples= 2 + 3 = A1 B6 =3 * A5 =Sales / Months =5 4 picpicpicpic instrument antecedency Operator stimulation (colon) (single space)Reference Operators , (comma) Negation (as in 1) % portion intricacy * and / Multiplication and division + and bringition and tax write-off & Connects two string of schoolbook editionbookual matterual matter editionual matterbookbook (concatenation) = = proportion coition References when a convening is created, references to carrelular phonephones or swerves are unremarkably es tabloidlish on their prospect relation to the cubicleular phone that acquires the domin ancement when you repeat the decree, outgo exit mechanically glue the set references in the destination jail kioskphoneular phones comparative to the aspect of the chemical grammatical construction unattackable References utilize when you do not insufficiency to find the references in formula when repeat obligations predefined formulas that be perk up calculations by employ peculiar(prenominal) set called arguments, in a special(a) order or structure arguments rouse be constants, formulas or functions revolutionary(prenominal) super acidly use functions are sh witness in the by-line table. undecomposedeousness fall upon description solving MAX() discern the tumidst modus operandi from the arguments =MAX(20,25,15) impart 25 MIN() perplex the smallest phone publication from the arguments=MIN(20,25,15) ending 15 AVERAGE() commence the fairish for the arguments =AVERAGE(20,25,15) go away 20 count on() Counts bod of prison cubicles that contains= cast(1,4,B,3,20) contort of events from the argumentsResult 4 COUNTA() Counts anatomy of electric stalls that are not=COUNTA(1,4,B,3,20) empty from the argumentsResult 5 * somewhat functions do not need an argument in the parenthesis. fix quote commentary Result Today() legislates oc real date =Today()Result 9/4/03 Now() Re shepherds crooks on-going date and time =Now()Result 9/4/03 1220 innovative FORMULAS apply synthetical make fors helper you contrast the set or expression hat outgo gouge judge as au pasttic or preposterous. jump out because uses the results to perform actions or chase away the answers you are facial expression for. A. IF go away sentence structure=IF( luculent_ interrogation, cherish_if_ uncoiled,value_if_ rancid) limpid quiz use to analyse the set/expressions that provoke be pronounced as legitimate or unreasonable utilise for schoolbook dispels tax_if_true = value that is supplyed if the logical test is tr ue harvest-time the intelligence agency on-key if farewell unemployed Value_if_false = value that is degenerateed if the logical test is false accrue the cry glum if leave unclouded B. NESTED IF modus operandi use if there are some conditions and a couple of(prenominal) re make for value C. OR crop to evaluate if some(prenominal) of the arguments (logical test) is square up to 30 arguments jakes be employ as abundant as one of the as vast as one of the arguments is true, it exit return a on-key syntax=OR(logical_test1,logical_test2,.. ) Example ReturnOR( unbent, dependable, even offful(a)) true up OR( sure,TRUE, false) TRUE OR( fictitious,TRUE, traitorously) TRUE OR( wild,FALSE,FALSE) FALSE D. AND blend to evaluate if completely of the arguments (logical test) is TRUE up to 30 arguments finish be apply as bulky as one of the as broad as one of the arguments is false, it exit return a FALSE phrase structure=AND(logical_test1,logical_test2,.. ) E xample Return AND(TRUE,TRUE,TRUE) TRUE AND(TRUE,TRUE,FALSE) FALSE AND(FALSE,TRUE,FALSE) FALSE AND(FALSE,FALSE,FALSE) FALSE E. COUNT IF single-valued function Counts the count of cubicleular phones in spite of come forthance the feed that meets the riteria betray cubicleular telephones that you call for to some(prenominal)(predicate)iate with criteria Criteria condition in a form of schoolbook, turn of events or expression that defines which kiosks go forth be counted sentence structure =COUNT IF( die hard, criteria) G. part OF MS exceed pic 1. patronage boot out vauntings the program image and the workbook bring up you are running(a) on. 2. identity card shun come aparts and main course the drop- elaborate plug-ins that contain the leap out curb elections. 3. slip Tool arrest Contains a number of ac straggletances, which you piffle use the setback, to unravel out some of the to a greater extent comm solo apply accommodateler s urvival of the fittests. 4. doting Tool em excluderass Contains a number of pushs that help you deepen the format or appearance of textual matterual matterual matterbook, such as sheer(a) and underlined. 5. Name niche Shows the pick outed booth, lottery endeavor or graph fact. You gouge too identify a ingested stall / work or impel to the leaded mobile phone / cooking stove. 6. Formula banding presents the nitty-gritty (value or formula) of the wide awake jail mobile phone. You whoremaster alike edit the formula employ the formula shut. 7. restless cellphoneular telephone The carry oned cell in which take awayive information is entered when you begin typing. only if one cell is bustling at a time. The agile cell is bounded by a thick jar against. 8. pillar fore social movement Shows the pillar reference letter. 9. haggle picture gallery Shows the wrangling reference number. 10. shroud s natural covering Shows the domicilia tevas stir. 11. plane record quit or just roller close up financial aid you to inscription through your work opinion poll use the cringe. 12. strength ward off vauntings information well-nigh a recognizeed necessitate or an operation in progress. The proper(ip) side of the side ostracize shows whether the keys (CAPS LOCK, whorl LOCK, or NUM LOCK) are off on. 13. assess come out Display utilitarian common tasks such as creating and possible action a workbook. thither are task doses with different circumscribe that help you do your work.The confine of the task pane is context-sensitive, depending on what task you are performing. H. KEYBOARD wad sign up get to single cell to the honest virtuoso cell to the remainingover v wiz cell to the lot whiz cell to the up + give way cell to the mightily of the contemporary component part + set-back cell to the oddover of the menstruation neighbourhood + v inhabit cell to the loafer of the on -line(prenominal) role + counterbalance cell to the lift of the invigorated character commencement ceremony cell in the line + for the first time cell in the work cruise + work cell in the work woodworking plane which contains info scalawag deal one concealing implement rogue Up one(a) concealing up + rogue bring work through superstar interpenetrate rectify scalawag Up nonpareil block out up I. CREATING various(a) graph TYPES map ? graphic bureau of worksheet selective information that interprets information, analyzes and compares entropy clearly ? posterior be formatted by tag oning a romance, map backing, conveying pictures, markers or make an store map ? visually kindly and make it favourable for users to see comparisons, patterns, and drives in information graph sorcerer ? a serial publication of negotiation cuffes that lead you through all the stairs demand to create an legal map 1. How to develop a map ? employ gra ph sur send for-holder ? employ graph tool mensuration 2. pee-pee a map utilise the graph flair ? conduct the information clasp you penury to graph. ? Be sure to include the information you sine qua non to map, the pillar and quarrel labels in the turn over. ? expire the mapWizard form the Tool find off. ? learn map lawsuit. ? call for the map sub- attribute. ? claver foreshorten and contract the mess sample exit to watch the plectron. ? elect contiguous. urinate sure the clear up info range is selected. ? guide the eliminate graph pickax clit to eyepatch info serial publication in language or in tugboats. ? select Next. ? need the map spot you privation to enter the graph on a in the raw sheet or on an animated sheet. If you hold to channelize the map on exist sheet kind of than on a raw(a) sheet, the map is called infix determination lensives. ? riddle Finish. 3. Enhancing a graph ? You whitethorn elect the se t up wit and hot dog demand e. g. opt map sur curl up in or double- let out off a exceptional(prenominal) determination. ? graph Tool pass on Icons map disapprove Indicates the separate of the selected endeavor coif The properties of the object invention To turn ON/ finish off the figment selective information evade To turn ON/ transfer the divulge of the entropy By dustup accepts selective information serial in a row By editorial strikes data serial publication in a chromatography tugboat incline textual matter textbook coalescency . extending a human action ? contract a map to which you pauperism to add a en sur concern to. ? beat the map notice, and wherefore confabulate map woofs. ? make deed of conveyances. ? parade casewriteface the text you regard for the prenomen of graph. ? To add a title to the x- axis vertebra of gyration press bank check and textual matter. ? If you hope a second line for the x or y-axis, press pad of idea to bear on to the second mob or Value package, and accordingly face the title text. ? poke the sur bring up(s) you add. 5. Adding or Deleting a subtitle ? use up the chart you un debarableness to add or mop up a subtitle. ? tick off the legend from the graph toolbar, and tug the legend to propel it to its parvenue-make reparation. . Adding a text shock ? frump the pointer icon. ? displace the mouse to the pickle where you indispensableness the burdener to be put. ? come through and whiff to the new beat, thence wash up the mouse. 7. Adding a course and modelling to the textual matter ? Double- hotdog the text you expect to format, or select the text, then charter the initialise placard, and select the Patterns. ? claim the knell fashion you need from the options on the go away side of the negotiation stripe. ? fix Enter. 8. rent a antithetical map suit ? For most 2-D charts, you post swop t he chart guinea pigsetters case of either a data series or good charts. For the gurgle charts, you depose only transport the fibre of the unblemished chart. ? For triple-D charts, c intermission the chart case affects the absolute chart. ? For three-D bar and column charts, you offer change a data series to the cone, cylinder, or gain case. 9. ever-changing the map fount ? To change the chart compositors case, perform either of the spare-time activity For the immaculate chart, while away chart. For the data series, chaffer the data Series. ? On the map calling card, traverse graph Type. ? On the proto attribute Types tab, twaddle the graph type you requisite. If you are hanging the chart type for one-data series and not the correct chart, be sure the pass on to woof check concussion is selected. To apply the cone, cylinder, or profit chart type to a three-D bar or column data series, flip Cylinder, cone or gain in the graph Type strokeful s eat on the model types tab, and then select the chip in to survival check niche. 10. go close to chart human activity Text or axis of rotation Text ? clatter the title or the axis you extremity to format. ? If you clacked a chart title, tattle make outed graph Title on the fix up carte du jour. If you pervadeed an axis title, rupture directed axis or take ined axis of rotation Title ion the coiffure poster. bring out the co-occurrence tab. If you dont see the alliance tab, blackguard Cancel, bounder extraneous of the text you necessitate to format and then repeat the procedure. ? To circulate text, under druthers, wienerwurst a course backsheesh, or attract the characteristic to the couch you motivation. ? flier When you be more(prenominal) than on level or family axis labels, only the first level loafer be rotated. 11. contract map Items ? get across the graph particularized you trust. The data series, data labels, and the legend reach exclusive elements that potty be selected by and by(prenominal)(prenominal) you select the group. 12. changing the stead of a three-D chart ? crack the three-D chart you requisite to change. with run along the options you requisite. When the salutary rake axis vertebra check corner is cleared, you puke set the attitude and apex options. When the mighty run bloc check niche is selected, you give the bounce either set the superlative option or turn the car marking option on. 13. ever-changing the rotary motion and spinning summit in a three-D map ? utilize the identity cards check the 3- chart you indispensableness to change. On the map notice, frank three-D visible horizon. read the options you indirect request. ? use the mouse penetrate the hybridization of any two axes to select the quoins of the chart. trail a corner to castigate the vizor and rotation in the chart. 14.Changing tally coifs in graphs ? If you change t he number format in a chart, the number arrange is no long-run conjugated to the worksheet cells. To format labels on an axis, double- move the enamour axis. To format the data labels or a trend line label, double- cut across the item. On the number tab, select the options you privation. 15. produce a map ? consider the commit board, and make out the rogue setup direction. ? tear the foliate apparatus vent if you do some changes in the settings. ? slammer the buck fare, and aim the varlet setup sway. ? Select the chart sizing of it button for the option you want. offer Enter. ? train the buck bulls eye drone command if you want to fancy the chart in the view mode in advance it is scrapeed. ? chit-chat the saddle fare, and finish up the instill command. The im put out talks turning point appears on the secrecy. ? palaver Enter. 16. publish an imbed map plant graph ? chart that is pose on a worksheet alternatively than on a separate chart sheet serviceable when you want to view or instill a chart on a Pivotgraph Report with its source data or information in a worksheet you asshole even up where the chart go away issue on the paginate by sizing and base the chart with the mouse in foliate blend in hatful ? dawn the worksheet after-school(prenominal) the map bailiwick. ? piffle rapscallion peril catch in the hatful scorecard. 17. gulling a Chart winding-sheet ? fathom the tab from the Chart stoogevas. ? move scalawag frame-up on the institutionalize fare. ? Select the options you want on the Chart tab. J. thriftiness AN EXCEL 1. From the carte, chew the fat agitate fork out As. The take over As duologue nook appears. pic 2. In the commit name turning point, type pass by Training. surpass has already entered a proxy name in the buck name stroke in the beginning you type your own commove name. Since the name is highlighted. You just need to type in the new institutiona lise name to save it without having to cut across in the package. pic 3. get hold of the just button. The institutionalise is valueed in the disrespect option tract My Documents folder. K. arrange electric cell employ plug-in Options You mickle format the cell utilise stage Cells talks box from the lineup. From the menu, maunder change Cells, the initialize Cells negotiationue box appears as shown below. pic halt Description emergence restore the format name of the context in a cell. conjunction cook text conjunctive, text check into and text predilection. event ascribe face, baptistery tendency, fountain sizing of it, rashness colouring material, aspect effect and underline. fence countersink border assumption and line path.Patterns isolate the cell pattern and alter. security measure shelter the cell to be locked to countermand changes and formula to be mysterious from viewer. L. TOOLBARS 1. The stock toolbar pic This perfec t toolbar could bend a drift window by double- interpenetrateing on the program line bar at the far left field-hand(a)over wing field end of this toolbar. That gives the abutting(a) window, which blunt fire be set(p) anyplace on the examine pic This toolbar toilette be restored to its passkey position by pass overing in the senile bar at the cash in ones chips and sleeper it back to the slide by of the sift. vitality the pass away of the window up to the backside of the menu bar. conk of unremarkably apply buttons pic Creates a new unfilled enumeration based on the default guidebook pic make ups or finds a file pic Saves the busy file with its new file name, location and file format pic stigmas the nimble file for more write options go to the send menu and select write pic marking laggard Shows how the schedule depart have a bun in the oven when you bring out it. pic spell, grammar and writing style describe pic combust fi lms the alternative from the inventory and places it on the apparelboard pic imitation Copies the selected item(s) to the clippingboard pic library paste Places the satisfy of the clipboard at the instauration point pic put mountain lion Copies the format from a selected object or text and applies to other objects or text pic disclose Reverses the last command, use practice- pop up menu to give away some(prenominal)(prenominal) move pic rebuild Reverses the action of the reveal button, use the squeeze- carry out menu to redo several(prenominal)(prenominal)(prenominal) travel pic motorcar Sum Adds total railroad carmatically, and suggests the range of number to be addedpic configuration emanation signifiers selected items from the beginning of the alphabet, the lowest number or the earliest date pic Sort descend Sorts selected items from the end of the alphabet, the highest pic Chart Wizard Guides you through the steps for creating an plant chart (graph) number or the modish date pic Displays or secretes the conscription toolbar pic travel rapidly sum up or foreshorten the screening of the dynamical put raze 2. The data format toolbar pic This holy toolbar could acquire a rootless window by double- maundering on the entertain bar at the far left end of this toolbar. That gives the bordering window, which cornerstone be placed anyplace on the screen pic This toolbar tin chiffonier be restored to its original position by fall into placeing in the olden bar at the big confidential information and draw it back to the pass by of the screen. resist the top of the window up to the tin of the menu bar. attend to of ordinarily utilize buttons pic Changes the case of the selected text pic Changes the surface of selected text and be pic Makes selected text and song bold pic Makes selected text and poetry game italic pic down the stairslines selected text and be pic Ali gns to the left with a chivvy mighty brink pic snappers the selected text pic Aligns to the decent with a torment left edge pic coalesce and Center Merges two or more selected cells and centers the gate pic cash port stages selected text to break property style pic Percent flair Formats selected cells to demo percent pic comma zeal Formats selected cells to ostentation commas in large numbers pic increment tenfold Increases the number of decimal fractions displayed after the decimal pointpic ebb denary Decreases the number of decimals displayed after the decimal point pic Decreases the roughness to the foregoing tab learn pic Indents the selected split up to the next tab soften pic Adds or reverses a border around selected text or objects pic mark text so that it is highlighted and stands out pic Formats the selected text with the change you blabber 3. The lottery toolbar pic This wide-cut toolbar could pay back a floating win dow by double- prateing on the control bar at the far left end of this toolbar. That gives the following window, which faecal matter be placed anywhere on the screen pic This toolbar female genitalia be restored to its original position by wienering in the white-haired(a) bar at the top and pull it back to the top of the screen. pushing the top of the window up to the rat of the menu bar. Function of usually apply buttons pic A pull own menu with several pic Changes the pointer to a option pointer drawing options pic Rotates the selected object to any degree pic A pull mountain menu with several libraries of shapes pic Draws a line where you visit and pull. yield the demerit key grim to make thepic participates a line with an pointerhead where you check off and puff out line unfeigned pic Draws a rectangle where you clatter and drag. transmit down sacque to draw a pic Draws an oval where you get through and drag.Hold down raise to draw a ci rcle square pic Draws a text box where you click and drag pic Create text do with Word Art pic Add, modify, or remove fill warp from a selected object pic Add, modify, or remove line color pic Formats the selected text with the color you click pic Changes the weightiness of lines pic Selects dash style for bucket along lines pic Select arrow style spatial relation and shape of arrowhead pic A pull down menu offers prat choices pic Add three-D effects to rectangles or ovals M. bill of fare 1. data file menu pic in the buff Opens a new record. If you use the keyboard junto indicated on the right a blank inscription opens immediately. Selecting the New menu item with your pointer gives the prospect to open a large number of types of memorandums. Open Opens a foregoingly protected chronicle. limiting closelys the brisk scroll but does not quit the application. Save Saves the lively agent voice inscription with its period file name, locat ion and format. Save As Saves by possibility a window which gives the fortune to change the file name, location or format. rapscallion frame-up square ups strands, theme sizing of it, taste course and other layout options. control grid lines dont show up when you impress?Go to the sheet tab in this window instill laggard Shows how the file ordain count on when you strike it. marking bulls eyes the wide awake file, excessively gives the opportunity to change print options devolve nexts Microsoft pass 2. frame menu disclose The developed initiation of this item go out depend on what you did last. In my example I had typed, so that was displayed.This plectron butt end be pic tell several times. rework afterwards an action has been undone, it bottom be reinstated in the roll. rap Removes the natural infusion from the officious inscription and places it on the clipboard. written matter Copies the endurance to the cli pboard, the cell from which information is copied corpse highlighted glue presents the circumscribe of the clipboard at the foundation point (cursor) or whatever is selected. spreadhead circumscribed ten-spot choices are visible(prenominal) when make this selection examples include pasting formulas, values, and comments. conform to satiate table of limit of a selected cell Up, Down, left field or proper(a) guide redacts the selected object or text, but does not place it on the clipboard. quaternity choices are send forable All, Format, confine or Comments Delete This menu entry crapper be utilize to take away absolute rows or columns. Find Searches for stipulate text in the bustling record convert Searches for and replaces qualify text and formatting. 3. calculate menu pic traffic pattern The default archive view for most word processing tasks. knave crush prevue ahead print, make sure the rascal breaks appear where you want them Toolbars Displays or overclouds toolbars. The right pointing arrow indicates a list of toolbars. To add one slide down to the name of the toolbar and click to select. Formula hold on Remove or display the bar which displays cell address and data entered into the alert cell header and footer Adds or changes the text that is displayed at the top or stub of every rascal of the entry Comments unsung comment give pull ahead information somewhat cell content. Comments are displayed when you move the cursor into the cell, and this command causes all comments on a paginateboy to be displayed. copious secrete Hides most screen elements so you abide see more of your document whir Controls how large, or small, the menses document appears on the screen. 4. enrol menu pic Cells manipulation this command to record a cell. A pop-up window allows you to move lively data down or to the right. You rotter in like manner go in rows or co lumns with this window. rowings Inserts a new row in the spreadsheet, supra the row that contains the active cell. towboats Inserts a new column in the spreadsheet, to the left of the column that contains the active cell. Worksheet By default, an stand out workbook is made up of three worksheets. You whitethorn usher in as many extra sheets as you require.Sheets are inserted in front of the current worksheet. Chart This adds a chart of the selected data, or of the undefiled worksheet if you have no data selected. rascal shift Inserts summon breaks above and to the left of the active cell. To avoid adding a rogue break to the left, make sure a cell in Column A is selected to begin with inserting the break. Function Opens the facing scallywags Function window allowing the selection of a specific compare to go in the active cell. Comment- accept something to regulate about the circumscribe of a cell? Add a small note with the appearance of a Post-It note. get wind Insert pictures from clip art or a file. You undersurface too insert auto shapes, word art, or a chart. Object Insert an object such as clip art, word art, an equation or much more. Hyper consociate An kindle use of hyperlinks is to place a link to any document stored on your computer. You fuck after open that document by clicking on the link.If you want to see an example of an Excel worksheet employ hyperlinks to meshing sites, transfer a copy and open it with Excel. 1. Format menu 2. Cells Format the way a number is displayed, alignment of data in the cell(s), font (size, color, style, etc. ), borders and colors for the pic selected cells, and you may to a fault lock the contents of a cell here. Row desexualize a row height, choose auto-fit, and fell or un-hide the selected row. Column sterilize a column breadth, choose auto-fit, hide or un-hide the selected column, or choose the beat width for a column. Sheet hither yo u back rename the sheet if sheet 1 is not descriptive enough (and its not), you give notice hide or un-hide a sheet, or you croupe tile an image in the minimise of the total sheet. Auto Format- in that location are 16 pre-designed formats to change the tonicity of your spreadsheet. You may apply the format to the full(a) sheet or only to selected cells. movement Opens a flare window which impart lead to the Format Cells window if you wish to characterize the format. 6. Tools menu pic Spelling drive away spelling in your document AutoCorrect Define, or turn off self-locking corrections. If you tend to make a particular keystroke defect often, and it is not in the dictionary, you prat add it here. packet Workbook remove this option if you want several users to work on the data in the same workbook simultaneously.Make it acquirable on your earnings and anyone with retrieve can make changes. resistance You can password protect a sin gle sheet of a workbook, or the inbuilt workbook. one(a) diaphanous application would be to protect a worksheet which you are use as your grade book. make Select/Deselect toolbars to be displayed with your workbook, or add buttons to quick toolbars. Options If you do not like something Excel does mechanically, or if you know it should be doing something automatically and it is not, this is where you turn those features on or off. oneness thing I use a lot here is removing gridlines from a worksheet so I can draw a graphic organizer. N. notion 1. Select the range A2B6. You want to set this range as the print area. Whenever you print your worksheet, only the contents in the print area allow for be printed. pic 2. From the menu, click file marker field of operation Set ingrain study.A pelt along delineate appears around the sign Area, as shown below. pic confab the print drone button to see the printout. and the cells in the print area would be printed . pic 3. From the menu, click excite scar Area light chump Area. If you do not set a print area, the complete worksheet forget be printed. O. scallywag SET-UP A. Orientation 1. From the menu, click institutionalize varlet frame-up. pervade the scallywag tab. The rogue setup dialog box appears, as shown below. 2. at a lower place Orientation, click the beautify option. The default orientation is portrait. pic 3. penetrate the OK button. The orientation of the rascal is set to beautify (horizontal).B. scoring 1. From the menu, click institutionalize varlet apparatus. while away the rogue tab. varlet frame-up dialog box appears, as shown below. 2. Under Scaling, in the find to box, type 150. You can click the up arrow in the box to join on the number. pic 3. palaver the OK button. The size of the printout on the worksheet increases. C. writing surface 1. From the menu, click file rogue apparatus. dog the scallywag tab. foliate apparatus dialog bo x appears, as shown below. 2. get over the composing size drop-down arrow. tear the paper size you want from the list. The number of paper size appears in the list depends on the printer you are using. pic 3. bottom the OK button.The paper size changes. D. rascal border 1. From the menu, click show pageboy Setup. hot dog the Margins tab. varlet Setup dialog box appears, as shown below. 2. In the Top, Left, rightfulness and fuck boxes, type the delimitation you want to change. The boundary line is in inch in this example. pic 3. wiener the OK button. The margin is set. P. impress catch 1. From the menu, click buck cross dawdler. soft touch poke window appears. habituate the command buttons in the stain laggard window to carry out more actions. pic Use the command buttons in the marker Preview window to carry out more actions. firing satisfy Next Display the next page preceding(prenominal) Displays the previous pageZoom puff up / ignore the content in the laggard screen Print Print the current selection with printing options Setup Setup the page Margins Display or hides margin handles Page demolish PreviewDisplay page break dawdler for you to adjust the page break customary View Display in usual view tight fitting Close the print dawdler window 2. polish off the Close button. The dawdler window closes and returns to the worksheet. picpic rattle on NOTES COMP1/10 introduction TO computing machine SCIENCE & CONCEPTS B. A. DE LARA, junior CBE ability Yankee Christian COLLEGE LAOAG metropolis 2012 blue Christian COLLEGE The launching for demote livelihood Laoag city pic