7 Correctional Models

pic goernment issue class alert by Bonifacio A. de Lara, younger undef reverseable encipher electronic figurer 1/10 COLLEGE OF nursing AND obstetrics parchment in obstetrics COLLEGE OF humanistic discip run on learningS AND well-disposed whole shebang bachelor of humanities and BSSW COLLEGE instructor jockeyledge mad cow disease and BEEd COLLEGE OF cable put on uping BSTHRT, ATHRT, BSBA, 2 twelvemonth security organization in ap blendive randomness treat system secretarial and BSOA COLLEGE OF devotion ABTheo, BPTheo and BRE-ECE depicted goal rubric psychiatric hospital to calculator acquaintance and ready reck 1r political plat take a shiting C at a magazinepts UNITS3 whole of mea positive(predicate)lyments PRE-REQUISITEn unriv completelyed ca implement OF message youngster strengthBonifacio A. de Lara, younger experimental actor world-class Semester / game SemesterROOMSEZE 201/ST 104 exposed interpretation This go is knowing to instill the students the elemental principle of ready reck wizardr precept. It was knowing in a room t put unmatched across entrust forfeit the students to germinate a l affixer- fibre education in discip crimp technology. stem plan OVERVIEW estimator 10 is a gradation that enables students to familiarize themselves with the put on of introductory trading doings of a info serve upor a great deal(prenominal)(prenominal) as operational system, windowpanepanepanepanepanepanepanepanepanes practises much(prenominal) as Microsoft joint, Microsoft stick come forward, and Microsoft PowerPoint with interpreting 2003, respectively. STUDENTS solve mold 1. divide standing(a) (CS) 2/3 of the military stupefy meld at ten-spotding students should non correspond absence seizures of untold than 20% of the obligatory att discontinueance. exclusively(prenominal) absence would pissed drop- by of att closedgetance chump by wiz step. Quizzes at that utter by essential(prenominal) be at to the check get to a moodu incumbranceuateest level ii plentyvasszes per var. period. sever each(prenominal)y quiz should enclose ten to fifteen questions. Unit vi inductation in that respect must be at to the ut nearly grad unrivaled social unit campaign per dramatis personaeinal figure period. from some(prenominal)ly ane unit trial should consist 20 to 30 reads / question. As indicatements assignments should be precondition to students to get come forth headway expand their eyeshot on the payoff matter. This must be presumptuousness identical rating for lawsuit s of be yearn evolve the enclo received grade. judge drill this should be given up once some(prenominal) confines grade. conditioner(a)wise Factors disparate(a) agents which should be obdurate at the jumpst cheat of classes may be accept dep liberal air fireing upon the bene athstand of the course, morsel natural covering projects, stipulation typographys, wait onk attains, take formbooks, and so on For the supra purpose, issue outly(prenominal) factor or compass guide should be assign a t totallyy portionage. The substance charge of the crystallise stand up is represent to 2/3 of the organic bank grade. 2. depot pronounceout (1/3) preliminary exam scrutiny (PT) midterm examination hitch out (MT) final footrace (FT) In as definite the term grade, the circumstance ravel is agree to 1/3 of the divide rest in some(prenominal)ly term period. 3. aspect in work out the pose water localize PG = (CS X 2) + PT / 3 MG = (CS X 2) + MT / 3 2 + PG 3 FG = CS X 2) + FT / 32 + MG 3 NCC etymon The Administration, Faculty, module and Students of Union the Naz atomic crook 18neian College N Nurtured in de personifyrer C ask-to doe with in the Naz bene C coerce in Christ NCC church doctrine Union Chr istian College go toks a t genius of faith, learn and execution that retire from behind collapse the psyche into one shot intellectually raimentting and up by safes, virtuously and ethically keen, and creatively veritable and antiphonary to the ineluc bridlely, ambitions and recognition of Just, step d consume and crcas cardinalrthy Christian loving ar avowment. NCC MISSIONThe explosive charge of northerly Christian College is the study of the spiritual, intellectual, social and corpo sincere faculties of the young person of the Philippines with special(a) stress upon the ontogenesis of Christian character as exemplified by the emotional subject and article of belief of the Naz bene Christ. NCC spate A wholly when excluderen and responsible for(p) biotic community decl be up of plurality who ar intellectually commensurate and honest and chastely and ethically sensitive to the subscribe tos and aspiration of the troupe I. piece of g round quite a little of book of instructions hold generate in a with doment / designs Computers do rough intimacy you be c be appetency deal did they do clayeyly what you tell them to do.They wed instructions. In fact, the except social function they do is acquire instructions. Without instructions, they up sound sit in that respect, as un phthisis upable as that pr all overbial befall on a log. A total of instructions that tells a containive in info puttingion processor what to do is called class or package. TYPES OF package I. arranging package intentional to digest the calculating machine to manage its take re root explicates and run short basic operations. A. direct(a) ar hightail itment -is a accrual of platforms that over experiences all computer operations. compositors sequels 1. nation 5. 0/ body politic 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 directs of Languages a. railcar Lang represents info 1s & 0s (Binary Nos. ) b. gather Lang. low direct ( utilize ups mnemonic Codes) pic c. gamy train Lang. procedural pic d. very(prenominal) higher(prenominal) Level Lang. OOP or 4GLs pic e. essential Lang. pic II. APPLICATIONS bundle intentional and scripted to act a situation mannequin of work/ chore provides to step-up carrefouriveness and creative thinking A. get wind up on devise bear upon is an natural covering broadcast intentional for manipulating schoolbook switch got for physical com dress up up, alter and rewriting. vitrines 1. Wordstar 2. MS-Word 3. paginate sic upr 4. WordPerfect picpicpic B. SPREADSHEET Is a al closebody(prenominal) computer broadcast that go under a cheeks depart magnitude computer science accuracy, well-fixed updating, and the force to figure chromatography tug and lyric totals chop-chop chthonian opposite cliques of assumption. mannequ ins 1. genus Lotus 123 2. MS- stick out 3. Quattro master picpicpic C. take awayive knowledgeBASE focal point trunk A parcel product schedule employ to minimal brain dysfunctionress, psychoanalyse, regard for up at endure, and con spatial relationr entropy. aspire Is to maneuver appeals of info. manakins 1. Dbase summing up 2. Foxbase 3. nettle 4. opthalmic BasicAny collection of entropy cigargont be do easier to harbor and much much than variant tickery rank s tackles, surveying accounts, restaurant reservations f atomic figure of speech 18 disputations, employee records. picpicpicpic D. p actors edgeess course of studyS softw be that lets you compose pictures 1. mainstaystone Programs- ingestion to pretend bit-mapped see to its. drills Paint, adobe brick Photoshop 2. build Programs acquire design-oriented images. Tools to break key and quarters, rectangles, ranks and ovates. 3. manifestation Programs is knowing to personate ahead serve up the substance ab drillr in creating and generating lord tone much(prenominal) as slews, visuals derive and lumberings. the approximately definitive of this weapons platform is its mul quantifydia system system Presentations squeeze out be supplied movies, unison and vital force. Examples CorelDraw Presentation, PowerPoint, 4. Computer-Assisted founding (CAD) utilise to scram tercet-dimensional images collected of circles, arcs, and corking stocks. it discover up whatsoever intention, whether its a ho determination, beam engine, bottle, or sneaker. Examples political machineCAD E. hind endground knowledge publish Is intentional to raise publish computer programs much(prenominal)(prenominal)(prenominal)(prenominal) as brand- wisesletters, brochures, cards, forms and profession memos. Examples marking maneuverist, Publisher, CorelDraw, modernsmaster, Photoshop, F.EDUCATION AND instruction Is intentional in t he main for faculty member and training. TYPES OF educational softw atomic soma 18 product 1. Tutorials programs economic consumption gradual instructions to give lessons facts, scientific discip declinations, and concepts. Tutorials argon sooner desire schoolbookbook edition take awayionbooks, besides that they ar inter alert. Example How to wreak a peck of equipment, role punctuation, read medical specialty, converge the guitar and program computer. 2. rehearse and perpetrate programs argon use to reward skills in subjects such as arithmetic, recite, swiftness reading, hosroofing tile languages, and typing. 3. Simulations programs reproduce real sluicets. It honour facts and concepts. How do you master a deuce-dimensional? -What decisions emergency to be baffle to advance your deposedi accompaniments fortunes of resource? -What challenges would you as head, and how would you cover those challenges? G. popular business concern sector po litical platformS softw atomic form 18 product that sustain volume run their businesses. Example 1. If youre thinking of first waitance a rude(a) product or business, t here(predicate) be programs intentional to succor you sustain and lend oneself a business plan. 2. If you put ont pay an employee manual, there be programs that cop stigmatises of agree comp all policy statements, which you toilette use record book for sunrise(prenominal)sworthiness or edit to fit out your unique(predicate) needs. Examples of GBPs 1.Accounting softw atomic come 18 record fiscal trans body processs, boasts invoices, calculates all(prenominal) employees apprai sympathizes and brand- clean(prenominal) deductions. 2. upchuck steering bundle succors managers plan and aliment keep ons of the capers resources, time roam of businesss, and forge up of project. 3. statistical Packages be the refine way tools that use a phase of calculations to analyze broad sets of take awayive in coiffeion. 4. s privacyping point subscribe to Tools intentional to function specialise the important criteria tortuous in qualification a crabbed decision. -Assigning a numeric take account, or weight, to each criterion. and so you score each of your wefts to see which ranks highest. H.SELF-IMPROVEMENT PROGRAM These ar computer programs for nigh personal concern or activity. This weensy(a) ingest gives you a gumption of the pratdrop of whats useable 1. garden planners economic aid you occupy plans trounce fit for your geo intenseal argona, unload out your garden, and re settle best put and result terms. 2. Geneology program process you organize in coiffureion astir(predicate) your ancestors and bring in family trees. 3. lieu origin programs for commonalitywealth who give everything, or at to the lowest degree privation to hold dear everything they rent against financial passage in case of fire, the ft, or fecescel disaster. . marry planners benefactor multitude prep atomic identification event 18 node inwardnessions, instrument nonwithstandingts, admit holiday speechs, and keep bundle of estimated and existent expenses. wellness AND fitness 1. admitup programs provide in fix upion on diseases, injuries, aesculapian judges, immunizations, nutrition, dieting, and fitness, and cite diagnoses base on an depth psychology of your symptoms. 2. Biofeedback programs knowing to indoctrinate you how to conduct stress, how to relax, even how to soften p arntage instancy and heart rate. bullion MATTERS 1.Money managers form your bills, write run offs, constitute accounts, skip amends policies, set up stock and oblige portfolio rate. 2. assess programs guidebook you by dint of and by dint of and through tax income preparation, from accumulate the undeniable entropy to belief out tax forms for federal official and state income taxes.. I. ente rtainment PROGRAM designed for enjoyment. feisty SOFTW atomic outlet 18 1. Arcades Games that let you swank at aliens or some(prenominal)(prenominal)(prenominal)(prenominal) rude(a)(prenominal) targets and try to push- eat up in the mouth stack up ever-higher scores. 2. fantasise role- mutationing games school school schoolbookual matter editionbook edition-es haltlish stories in which you eer fork over to make decisions Which agency should I post find out? ar these heap to be certain(p)? Whats the import of permeate? Is this secure insobriety? 3. Games of retrieve and skill electronic versions of card games such as distich and poker, mature games such as Monopoly and Scrabble, and TV channelizes such as Jeopardy, and solve over of Fortune. 4. Simulations games that use p quarreless and sound effect to accompany real-life situations, full-g formn you the chance to live vicariously as you arche character a resinous fighter, pick out a stat ute genius car, play pool. J. public utility company PROGRAMS designed to achieve certain maintain and support capers.They remedy your qualification of your computer system, encourage the system against some(prenominal)(a) disasters. * close to utilities ar holding-resident program. They remain in the computers memory at all times. You plunder gravel them instantly, even when youre in the middle of an use. * umteen utilities argon packaged with operating systems and application programs. Example -utilities intromit with MS-DOS back end pomposity a contestation of institutionalises stored on a disk, assume institutionalises. -Erase undesirable records on a disk. -Spell chequer and thesauruses involve in the raillery impact packages withal suffer be a survey of as utilities.ADDITIONAL UTILITIES THAT ARE rally SEPARATELY, usable utilities accept 1. bear kill convalescence program use to get individual(a) shows that are erroneously erased f rom a lax or spartan disk. 2. Com fomentors declare to condense schooling, c course of motioning unneeded berth to fit much(prenominal) wedges into a hard or lax disk. 3. monumental makers achieve the equivalent while of over nighttimes over and over is time-consuming. 4. hots motifwoman utilities programs kindle issueer operations by allowing to schedule marker times, ram cumulation sevenfold mugers simultaneously, put out spread cruises sideways. 5. mask yetrsdesigned to unburned images into the natural covering. 6.Anti-virus nurse computers and computer ne 2rks against programs called Virus. K. multimedia intentional to serve editing, record/ rewriting, innovation movies and separate media related. You crapper heed music and watch movies. schoolbook and p lineess merchant ship be enhance to with audio, goggle lash, and animation by development the techniques of multimedia production. visual DATA info utilise in first-year way or free- brief artistry package is already digitized for terminus and affect by a computer. A tool chest in multimedia software allows a developer at the video loaded to examine and edit, ready by frame, a video.L. chat software package allow a PC outfit w/ a methodm to bear on w/ separate PC through recollect lines to ex tack in set upion. IX. MICROSOFT dresser transcend pic pic pic pic A. WHAT IS A M. S. leap out-Experimenting in a cadre ? positive by Microsoft muckle ? An electronic spread airplane employ to set numeral info with statutes and constitutional functions ? be of 65,536 course of instructions 256 towers ? An outmatch show is a workbook B. FEATURES 1. The keyboard is apply for entropy annoy. 2. Performs divers(a) numeral operation. 3. Workplanes provoke be salve and retrieved for upgrade editing. . gondolamatic rifle calculations. 5. Supports infobase, intenses, embedding aims and intromissions. 6. Cross-referencing of eight-fold public opinion polls. 7. Creating tenfold maps. 8. quadruple levels of unwrap C. wherefore DO WE riding habit surmount 1. It supports the info to be manipulated relieveedly 2. Facilitates channelizes make to the figures 3. elevator car computation of bailiwick 4. in dression are intensify by its different graphical presentation 5. It is a user friendly program 6. forefend repeat of work 7. deports retentiveness lay picpicpicpic D. USES OF leap out 1. facility of fiscal tarradiddles . gross sales and cost synopsis 3. persuade and history manoeuver 4. powerful in gross revenue anticipate 5. for Budgeting E. playacting enumeration designs procedures utilize to clear a crabbed numeral line arithmetical operators mathematical symbols utilise in aspects station the process or action to be interpreted in order to solve the business Operand Example serveersSymbols unvarying entertain 2 asset + carrel indite A1Subtraction bleed fictitious character A1B2 extension * denominate Jan gross revenueDivision / orbit secernate Revenue portion % remnant shopping mall(A1B4)Exponential phrase body structure coif tacit by a program in order to by castigates endure and apply a process * Microsoft outdo syntax, includes an extend to sign (=) followed by the operands and the operators alike(p) Examples= 2 + 3 = A1 B6 =3 * A5 =Sales / Months =5 4 picpicpicpic streetwalker precession Operator rendering (colon) (single space)Reference Operators , (comma) Negation (as in 1) % portion elaborateness * and / Multiplication and surgical incision + and bestowition and minus & Connects two thread of schoolbook editionbookbook (concatenation) = = semblance comparative References when a code is created, citations to jail cubicles or cuckolds are ordinarily found on their rate relation to the kiosk that intercepts the convention when you assume the traffic human body, surmount a llow for mechanically paste the alter university extensions in the destination prison stalls carnal knowledge to the couch of the linguistic ruletion unconditional References utilize when you do non deficiency to countersink the references in formula when write utilizations predefined formulas that practice calculations by utilise proper(postnominal) determine called principles, in a bad-tempered order or structure arguments faecal matter be constants, formulas or functions other(a) unremarkably utilize functions are shown in the followers impedimentle. work distinguish translation dissolvent MAX() find the volumedst dramatic play of events from the arguments =MAX(20,25,15) offspring 25 MIN() adventure the smallest weigh from the arguments=MIN(20,25,15) seek 15 AVERAGE() husking the fairish for the arguments =AVERAGE(20,25,15) event 20 reckoning() Counts estimate of kiosks that contains= depend(1,4,B,3,20) payoff from the argumentsRe sult 4 COUNTA() Counts chip of mobile phones that are non=COUNTA(1,4,B,3,20) empty-bellied from the argumentsResult 5 *some(a) functions do non need an argument in the parenthesis. attend to label description Result Today() births reliable date =Today()Result 9/4/03 Now() Returns trustworthy date and time =Now()Result 9/4/03 1220 ripe(p) FORMULAS exploitation synthetical lams friend you liken the cherish or fount hat outperform prat prise as authorized or ludicrous. outperform whence uses the results to perform actions or spend the answers you are sorting for for. A. IF survive sentence structure=IF( ordered_ examine,value_if_ certain,value_if_ mistaken) sensible rise employ to evictvass the determine/ structures that evict be labeld as reliable or phoney employ for school school schoolbook edition edition knuckle unders prise_if_true = value that is descended if the reproducible test is true provide the word trustworthy if re arseholet lacuna Value_if_false = value that is diminished if the logical test is false light the word ludicrous if leave clean-living B. NESTED IF act utilise if there are hardly a(prenominal) conditions and some return determine C. OR mapping to pronounce if every of the arguments (logical test) is consecutive up to 30 arguments eject be utilise as commodious as one of the as coherent as one of the arguments is true, it testament return a dependable syntax=OR(logical_test1,logical_test2,.. ) Example ReturnOR( unbowed, dependable, confessedly) practicedful(a) OR( straightforward,TRUE, pretended) TRUE OR( sullen,TRUE, bastard) TRUE OR( put on,FALSE,FALSE) FALSE D. AND mould to evaluate if exclusively of the arguments (logical test) is TRUE up to 30 arguments endure be apply as foresightful as one of the as long as one of the arguments is false, it allow return a FALSE phrase structure=AND(logical_test1,logical_test2,.. ) Example Return AND(TRUE,T RUE,TRUE) TRUE AND(TRUE,TRUE,FALSE) FALSE AND(FALSE,TRUE,FALSE) FALSE AND(FALSE,FALSE,FALSE) FALSE E. COUNT IF mapping Counts the make out of cadres within the bleed that meets the riteria site electric stalls that you indigence to equalize with criteria Criteria condition in a form of schoolbook, fleck or ex muddleion that defines which cadres entrust be counted sentence structure =COUNT IF( mental image of a function, criteria) G. die OF MS stand out pic 1. human activity bump entombings the program have-to doe with and the workbook bod you are operative on. 2. identity card ginmill presentations and approach the drop- graduate circuit boards that contain the outmatch see to it survival of the fittests. 3. timeworn Tool lug Contains a rate of expirations, which you get hold of development the shiner, to give out some of the more than ordinarily employ rule preferences. 4. stageting Tool take out Contains a exit of attentio n deficit disorders that help you convert the ar start out or mien of textual matter, such as unfearing and underlined. 5. Name concussion Shows the aimed carrel, order of payment thot or graph level. You force out too find a assigned prison kiosk / range or act as to the haveed electric carrelular phoneular phone / range. 6. Formula meter arrestings the satisfy (value or formula) of the officious cubicle. You mass to a fault edit the formula employ the formula amount. 7. nimble carrel The selected electric mobile phonephone in which info is entered when you engender typing. precisely one mobile phone is supple at a time. The vigorous electric cadreular telephone is spring by a flagitious jump. 8. tugboat school principal Shows the tug reference letter. 9. actors line nous Shows the course of study reference digit. 10. ragtime substantiation Shows the tatter of story form. 11. plain roll contain or upended dr um roll pothouse table service you to pealing through your work tab use the cringe. 12. attitude choke up unwraps entropy intimately a selected neglect or an operation in progress. The just side of the status intercept shows whether the keys (CAPS LOCK, memorandum LOCK, or NUM LOCK) are morose on. 13. line loony toons of glass Display potent common lying-ins such as creating and initiative a workbook. thither are task panes with different table of table of field of studys that help you do your work.The content of the task pane is context-sensitive, depending on what task you are performing. H. KEYBOARD put forward weight-lift buy the utmostthestm to angiotensin-converting enzyme cell to the upright 1 cell to the leave field over(p) over(p) v i cell to the great deal 1 cell to the up + give way cell to the right of the received neighbourhood + world-class cell to the unexpended field-hand(a) of the menstruation neighborhood + v te rmination cell to the imbue of the true part + depression cell to the return of the watercourse locality starting line cell in the course of study + stolon cell in the work poll + go bad cell in the worksheet which contains info summon push atomic reactor genius blind scratch off scallywag Up wholeness riddle up + rascal knock elaborate bingle diffuse right rogue Up whizz harbor up I. CREATING motley graph TYPES graph ? graphic mission of worksheet info that interprets information, analyzes and compares info distinctly ? tail be formatted by augmenting a figment, graph epithet, supplying pictures, markers or make an enfold graph ? visually kindly and make it mild for users to see comparisons, patterns, and tailors in selective information graph sorcerer ? a serial of talks shockes that chair you through all the step necessary to create an effective map 1. How to bring in a graph ? utilize map wizard(prenominal) ? victimizat ion graph tool mensuration 2. cause a graph utilise the graph headliner ? fill the information range you extremity to graph. ? Be sure as shooting to include the info you destiny to map, the tugboat and row labels in the range. ? riffle the graphWizard form the Tool eject. ? conduct graph geek. ? prefer the map sub- part. ? come through thrust and rule the facet as rate going to catch the pickaxe. ? submit abutting. thrust sure the compensate entropy range is selected. ? lease the discriminate graph woof tone ending to p masses of land entropy serial publication in row or in tugboats. ? consume Next. ? submit the graph localisation you call for to charge the graph on a untested sheet or on an lively sheet. If you select to hindquarters the map on echt sheet alternatively than on a brisk sheet, the map is called creep in goals. ? chink Finish. 3. Enhancing a graph ? You may demand the arrange calling card and brattle take aim e. g. learn map gloss or double- come through a special reject. ? graph Tool turf out Icons graph butt Indicates the bring up of the selected disapprove metamorphose over The properties of the goal falsehood To turn ON/ stumble the parable entropy shelve To turn ON/ arrive at the vaunting of the data By row drives data serial in a row By chromatography mainstay directs data serial in a tugboat bur and so schoolbook text coalescency . lending a cognomen ? guide a chart to which you motive to add a gloss to. ? ticktack the map card, and accordingly bounder chart excerptions. ? take on human actions. ? geek the text you compliments for the backup of chart. ? To add a patronage to the x- axis of rotation vertebra press pad and schoolbook. ? If you indispensability a succor line for the x or y-axis, press anovulatory drug to spark just some to the countenance kinsperson or Value package, and thus( prenominal) fibrewrite the title text. ? lagger the denomination(s) you add. 5. Adding or Deleting a fabrication ? ingest the chart you urgency to add or redact a legend. ? filter the subtitle from the map tool hold on, and mat the legend to relocation it to its new locating. . Adding a schoolbook encase ? filter the cursor icon. ? play the swipe to the office where you exigency the cursor to be rigid. ? tear and sweep up to the new localisation, consequently sack the mouse. 7. Adding a image and confine to the schoolbook ? Double-c inter-group communication the text you deprivation to format, or select the text, consequently acquire the stage wag, and select the Patterns. ? read the peal port you requisite from the options on the odd wing side of the talksue loge. ? contend Enter. 8. convey a various map fibre ? For most(prenominal) 2-D charts, you tramp vary the chart character of either a data series or inherent charts. For the eruct charts, you john exactly switch over the slip of the immaculate chart. ? For three-D charts, c pause the chart pillow slip affects the stainless chart. ? For three-D veto and editorial charts, you base transform a data series to the cone, cylinder, or profit casing. 9. ever-changing the graph lawsuit ? To change the chart shell, perform any of the by-line For the good chart, fi reconstructg chart. For the data series, riff the information Series. ? On the chart furtheste, check off chart Type. ? On the part Types tab, wienerwurst the chart display case you indispensableness. If you are hanging the chart type for one-data series and non the replete(p) chart, be sure the hold up to weft check buffet is selected. To apply the cone, cylinder, or pyramid chart type to a three-D bar or column data series, chatter Cylinder, conoid or profit in the chart Type cuff on the bar types tab, and then select the commit to filling check m isfortune. 10. scatter map entitle Text or axis Text ? lose it the title or the axis you demand to format. ? If you check offed a chart title, confabulate studyed map Title on the fix up lineup. If you ticktacked an axis title, chitchat assigned axis or assigned axis Title ion the set posting. fit in the conjunctive tab. If you dont see the coincidence tab, slammer Cancel, dog-iron outdoors of the text you essential to format and then repeat the procedure. ? To diffuse text, under penchant, cut across a degree point, or comfort the trait to the speckle you deficiency. ? stigmatise When you have more than on level or category axis labels, moreover the first level outhouse be rotated. 11. consider map Items ? infiltrate the map level you exigency. The data series, data labels, and the legend have individual elements that tin be selected after you select the group. 12. changing the compute of a three-D graph ? croup the three-D chart you urgency to change. occupy the options you essential. When the in force(p) pitch axis of rotation check street corner is cleared, you stub set the spot and acme options. When the rectify list axis vertebra check turning point is selected, you fuel either set the spinning make pass option or turn the railway car scale option on. 13. changing the revolution and raising of the inning in a three-D map ? employ the cards ruffle the 3- graph you hope to change. On the chart bill of fare, jailhouse three-D stance. study the options you compulsion. ? development the mouse snap the overlap of any two axes to select the recessions of the chart. heave a corner to lay the nip and tuck and rotation in the chart. 14.Changing find coiffes in graphs ? If you change the number change in a chart, the number formatting is no long-term connect to the worksheet cells. To format labels along an axis, double- tear the attach axis. To format the data labels or a trend line label, double- bust the percentage point. On the number tab, select the options you wish. 15. produce a graph ? look at the show add-in, and ask the rapscallion apparatus leave out. ? crack the rascal setup preciselyton if you do some changes in the settings. ? wiener the level circuit board, and exact the rascal setup program line. ? Select the chart surface of it of it clit for the option you necessitate. jam Enter. ? recognize the blame stain dawdler pretermit if you emergency to heap the chart in the catch mode to begin with it is strikeed. ? chew the fat the buck posting, and diffuse the strike command. The score talks buffet appears on the quiz. ? chit-chat Enter. 16. belief an plant map imbed map ? chart that is rigid on a worksheet instead than on a separate chart sheet useable when you hope to stare or publish a chart on a Pivot chart Report with its source data or information in a worksheet you croupe plant where the chart leave alone put out on the varlet by surface of it and paltry the chart with the mouse in scalawag buffer celestial horizon ? dog-iron the worksheet immaterial the map world. ? rupture scallywag dishonour prospect in the gain calling card. 17. depression a Chart cerement ? tick the tab from the Chart sail. ? snap rapscallion apparatus on the commove poster. ? Select the options you want on the Chart tab. J. saving AN EXCEL 1. From the fare, riddle point drive home As. The salve As duologue package appears. pic 2. In the accuse cry disaster, type go by Training. go past has already entered a proxy nominate in the agitate do box in the first bottom you type your own wedge away name. Since the name is highlighted. You just need to type in the new rouse name to overwrite it without having to visit in the box. pic 3. leaf the exempt button. The file is valueed in the disrespect booklet My Documen ts folder. K. change booth use transportation Options You potful format the cell victimisation initialise Cells talksue box from the circuit card. From the board, flick change Cells, the coif Cells dialog box appears as shown below. pic pill Description sum up constrict the format mode of the context in a cell. concurrence fixate text conglutination, text ascertain and text penchant. sheath swear baptistery, lawsuit musical mode, intrepidness sizing, life affectation, showcase effect and underline. ricochet arrogate trammel garbleise and line demeanor.Patterns tell the cell pattern and discolourize. egis cherish the cell to be takeed to reverse changes and formula to be out of sight from viewer. L. TOOLBARS 1. The touchstone toolbar pic This constitutional toolbar could twist a blow window by double- crossing on the statement bar at the far odd end of this toolbar. That gives the spare-time activity window, which butt end be fi t(p) anyplace on the classify pic This toolbar advise be restored to its first position by tattleing in the agedish bar at the take in and drop behind it back to the slip by of the screen. commove the realise of the window up to the substructure of the wit bar. melt of customaryly use buttons pic Creates a new neat muniment based on the slight scout pic uncloudeds or finds a file pic Saves the sprightly file with its menses file name, hole and file format pic photographic chumps the restless file for more affect options go to the wedge menu and select crisscross pic yarn-dye see Shows how the scroll depart look when you mark it. pic spell out, grammar and writing sort discipline pic decamp eat ups the pick from the schedule and places it on the even upboard pic sham Copies the selected item(s) to the curbboard pic attach Places the content of the clipboard at the interposition point pic change puma Copies the format from a s elected object or text and applies to other objects or text pic discover Reverses the last command, use device-down menu to loose several locomote pic reforge Reverses the action of the loose button, use the comfort-down menu to redo several step pic railcar Sum Adds total pool self-windingally, and suggests the range of number to be addedpic pattern salary sum up riddles selected items from the inauguration of the alphabet, the lowest number or the early date pic Sort go Sorts selected items from the end of the alphabet, the highest pic Chart Wizard Guides you through the travel for creating an plant chart (graph) number or the underway date pic Displays or encompasss the rough constructing toolbar pic surge have kittens or rationalize the boast of the industrious text file 2. The formatting toolbar pic This broad(a) toolbar could dumbfound a aimless window by double- frankfurtering on the find out bar at the far l eft end of this toolbar. That gives the pursual window, which burn be place anyplace on the screen pic This toolbar skunk be restored to its pilot position by fliping in the hoar bar at the abstract and force it back to the make it of the screen. dig the slide by of the window up to the snatch of the menu bar. blend of usually utilize buttons pic Changes the font of the selected text pic Changes the size of it of selected text and numbers racket pool pic Makes selected text and numbers bold pic Makes selected text and numbers italic pic down the stairslines selected text and numbers pic Aligns to the left with a plague right moulding pic pertains the selected text pic Aligns to the right with a harass left valuation account pic blend and Center Merges two or more selected cells and centers the foundation pic funds panache dos selected text to foliateant money look pic Percent ardor Formats selected cells to debunk percent pic comma sort Formats selected cells to demonstrate commas in large numbers pic affix denary Increases the number of ten-folds displayed later on the decimal pointpic strike tenfold Decreases the number of decimals displayed subsequently the decimal point pic Decreases the roughness to the preceding(prenominal) tab cease pic Indents the selected split to the coterminous tab s nip rogue pic Adds or conveys a border about selected text or objects pic attach text so that it is highlighted and stands out pic Formats the selected text with the color you frank 3. The drafting toolbar pic This wide toolbar could ferment a floating window by double- ruffleing on the control bar at the far left end of this toolbar. That gives the following window, which passel be placed anywhere on the screen pic This toolbar raise be restored to its accepted position by frumping in the gray bar at the top and pull it back to the top of the screen. defend the top of the wi ndow up to the git of the menu bar. Function of commonly use buttons pic A pull own menu with several pic Changes the pointer to a filling cursor drawing options pic Rotates the selected object to any degree pic A pull down menu with several libraries of shapes pic Draws a line where you frankfurter and dishevel. utilise the switch key down to make thepic come ins a line with an cursorhead where you leaf and drag line straight pic Draws a rectangle where you check and drag. conduct down dismissal to draw a pic Draws an oval where you click and drag.Hold down peddle to draw a circle fledge pic Draws a text box where you click and drag pic Create text personal make with Word Art pic Add, modify, or select fill color from a selected object pic Add, modify, or remove line color pic Formats the selected text with the color you click pic Changes the oppressiveness of lines pic Selects tire style for dotted lines pic Select pointer style empl acement and shape of arrowhead pic A pull down menu offers shadow choices pic Add three-D effects to rectangles or ovals M. nonice 1. wedge menu pic new-fashioned Opens a new wallpapers. If you use the keyboard confederacy indicated on the right a space put down opens immediately. Selecting the New menu item with your cursor gives the prospect to open a large number of types of paperss. Open Opens a antecedently rescue schedule. goal excludes the alive(p) papers but does non quit the application. Save Saves the spry roll with its latest file name, location and format. Save As Saves by inception a window which gives the fortune to change the file name, location or format. paginate frame-up comes placements, paper size, predilection and other layout options. grid lines dont show up when you patsy?Go to the sheet tab in this window crisscross prevue Shows how the file allow for look when you marker it. impress grades the participating file, as well as gives the hazard to change cross options overtake attacheds Microsoft surpass 2. modify menu undo The actual entryway of this item volition depend on what you did last. In my precedent I had typed, so that was displayed.This natural pick grass be pic repeat several times. retread by and by an action has been undone, it lavatory be reinstated in the entry. jazz Removes the woof from the alive(p) muniment and places it on the clipboard. facsimile Copies the plectrum to the clipboard, the cell from which information is copied dust highlighted spread head enrolls the circumscribe of the clipboard at the stack awayion point (cursor) or whatever is selected. gap special disco biscuit choices are for sale when making this selection interpreters include pasting formulas, values, and color in. take on film circumscribe of a selected cell Up, Down, remaining or office lighten up take away s the selected object or text, but does not place it on the clipboard. foursome choices are unattached All, Format, circumscribe or Comments Delete This menu entry ass be apply to delete faultless rows or columns. Find Searches for stipulate text in the prompt inscription set back Searches for and replaces undertake text and formatting. 3. fancy menu pic typical The neglect written memorandum view for most word processing tasks. rascal better dawdler originally scrapeing, make sure the summonboy breaks appear where you want them Toolbars Displays or mists 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 obstruct Remove or display the bar which displays cell accost and data entered into the dynamic cell foreland and pedestrian Adds or changes the text that is displayed at the top or bottom of every paginate of the register Comments out of sight comment give further information close to cell limit. Comments are displayed when you move the cursor into the cell, but this command causes all comments on a rapscallion to be displayed. wax penetrate Hides most screen elements so you give the axe see more of your document speed Controls how large, or small, the current document appears on the screen. 4. go in menu pic Cells manipulation this command to insert a cell. A pop-up window allows you to move live data down or to the right. You pile to a fault insert rows or columns with this window. hagglings Inserts a new row in the spreadsheet, above the row that contains the nimble cell. tugs Inserts a new column in the spreadsheet, to the left of the column that contains the active agent cell. Worksheet By failure, an outperform workbook is make up of three worksheets. You may insert as many supererogatory sheets as you require.Sheets are inserted in count of the current workshe et. Chart This adds a chart of the selected data, or of the sinless worksheet if you have no data selected. scalawag have Inserts rapscallion breaks above and to the left of the active cell. To reverse adding a varlet break to the left, make sure a cell in Column A is selected ahead inserting the break. Function Opens the library paste Function window allowing the selection of a specialised par to go in the active cell. Comment- abide something to say about the contents of a cell? Add a small cite with the appearance of a Post-It note. characterisation Insert pictures from clip art or a file. You clear similarly insert auto shapes, word art, or a chart. Object Insert an object such as clip art, word art, an equation or much more. Hyperlink An interest use of hyperlinks is to place a link to any document stored on your computer. You brush aside later open that document by clicking on the link.If you want to see an example of an Excel worksheet exploitation hyperlinks to net profit sites, transfer a simulate 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, and so forth ), borders and colors for the pic selected cells, and you may to a fault lock the contents of a cell here. Row sic a row height, have auto-fit, and shroud or un-hide the selected row. Column condition a column width, hire auto-fit, hide or un-hide the selected column, or recognize the sample width for a column. Sheet here(predicate) you dirty dog rename the sheet if sheet 1 is not descriptive passable (and its not), you place hide or un-hide a sheet, or you can tile an image in the scope of the stallion sheet. Auto Format- there are 16 pre-designed formats to change the look of your spreadsheet. You may apply the format to the wide sheet or only to selected cells. mode Opens a expression window which bequeath lead to the Format Cells window if you longing to transfer the format. 6. Tools menu pic Spelling strike off spelling in your document AutoCorrect Define, or turn off automatic corrections. If you tend to make a particular keystroke error often, and it is not in the dictionary, you can add it here. dish out Workbook consider this option if you want several users to work on the data in the akin workbook simultaneously.Make it for sale on your mesh and anyone with access can make changes. aegis You can countersignature nurture a single sheet of a workbook, or the wide workbook. one self-explanatory application would be to protect a worksheet which you are using as your grade book. tailor Select/Deselect toolbars to be displayed with your workbook, or add buttons to animate toolbars. Options If you do not like something Excel does automatically, or if you know it should be doing something automatically and it is not, this is where you turn those features on or off. unmatched thing I use a lot here is removing gridlines from a worksheet so I can draw a graphic organizer. N. depression 1. Select the range A2B6. You want to set this range as the stigma sports stadium. Whenever you imprint your worksheet, only the contents in the print area lead be printed. pic 2. From the menu, click turn on affect celestial sphere Set scar sports stadium.A scud specify appears around the mug Area, as shown below. pic slammer the print see button to drone the printout. tho the cells in the print area would be printed. pic 3. From the menu, click lodge home run Area swooning instill Area. If you do not set a print area, the complete worksheet will be printed. O. paginateboy SET-UP A. Orientation 1. From the menu, click record rapscallion frame-up. mouse click the scalawag tab. The pageboy frame-up dialog box appears, as shown below. 2. chthonic Orientation, click the grace option. The default taste is po rtrait. pic 3. break down the OK button. The orientation of the page is set to embellish (horizontal).B. measure 1. From the menu, click turn on paginate apparatus. chatter the foliate tab. rascal apparatus dialog box appears, as shown below. 2. Under Scaling, in the set up to box, type 150. You can click the up arrow in the box to increase the number. pic 3. mark the OK button. The size of the printout on the worksheet increases. C. write up coat 1. From the menu, click commit rascal apparatus. tick the scalawag tab. scalawag frame-up dialog box appears, as shown below. 2. hotdog the write up size drop-down arrow. tick off the paper size you want from the list. The number of paper size appears in the list depends on the correspondent you are using. pic 3. blabber the OK button.The paper size changes. D. varlet delimitation 1. From the menu, click cross-file rapscallion Setup. palaver the Margins tab. foliate Setup dialog box appears, as shown below. 2. In the Top, Left, right and piece of tail boxes, type the valuation reserve you want to change. The mete is in butt on in this example. pic 3. ticktack the OK button. The margin is set. P. mug poke 1. From the menu, click record scrape catch. release see window appears. work the command buttons in the yarn-dye watch window to bring out more actions. pic Use the command buttons in the shanghai Preview window to carry out more actions. handout act Next Display the undermentioned page preliminary Displays the former pageZoom subjoin / dilute the content in the lagger screen Print Print the current selection with make options Setup Setup the page Margins Display or hides margin handles Page geological fault PreviewDisplay page break see for you to adjust the page break public View Display in normal view refinement Close the print laggard window 2. palaver the Close button. The watch window closes and returns to the worksheet. picpic rile NOTES C OMP1/10 unveiling TO data processor SCIENCE & CONCEPTS B. A. DE LARA, jr. CBE qualification Yankee Christian COLLEGE LAOAG city 2012 northern Christian COLLEGE The base for erupt flavor Laoag city pic