7 Correctional Models

pic cogitation SYLLABUS Prep ard by Bonifacio A. de Lara, Jr. SUBJECT CODE information processing system 1/10 COLLEGE OF NURSING AND MIDWIFERY Diploma in Midwifery COLLEGE OF ARTS SCIENCES AND SOCIAL WORKS bach of Arts and BSSW COLLEGE TEACHER EDUCATION BSE and BEEd COLLEGE OF BUSINESS EDUCATION BSTHRT, ATHRT, BSBA, 2 Year Certificate in Computer Secretarial and BSOA COLLEGE OF THEOLOGY ABTheo, BPTheo and BRE-ECE SUBJECT TITLEIntroduction to Computer Science and Programming Concepts UNITS3 building blocks PRE-REQUISITEN matchless TYPE OF SUBJECTMinor cogencyBonifacio A. de Lara, Jr. TERMSFirst Semester / Second SemesterROOMSEZE 201/ST 104 SUBJECT DESCRIPTION This course is intentional to teach the students the basics of computer education. It was designed in a demeanor that testament allow the students to acquire a l chalk uper- symbol education in information technology. SUBJECT PURPOSE OVERVIEW Computer 10 is a course that enables students to familiarize themselves with the numeral function of basic operations of a computer much(prenominal) as operating system, windows applications such as Microsoft Word, Microsoft outmatch, and Microsoft PowerPoint with version 2003, respectively. STUDENTS PERFORMANCE EVALUATION 1. Class Standing (CS) 2/3 of the TERM GRADE Att abolishance students should non incur absences of more than 20% of the required att shoe experiencers lastance. for each one absence would mean reduction of attendance rate by one step. Quizzes at that place must be at least two quizzes per condition period. Each quiz should contain ten to fifteen questions. Unit Test there must be at least one unit test per term period. Each unit test should contain 20 to 30 points / question. Assignments assignments should be given to students to further gallop their horizon on the subject matter. This must be given equivalent rating for purpose s of computing the term grade. Graded Recitation this should be given once every term grade. ano ther(prenominal) Factors other factors which should be determined at the start of classes may be acknowledged depending upon the nature of the course, desire projects, term papers, re as distinguish works, workbooks, etc. For the above purpose, each factor or tip should be depute a corresponding percentage. The full weight of the Class Standing is equal to 2/3 of the total term grade. 2. Term Test (1/3) Prelim Test (PT) Midterm Test (MT) Final Test (FT) In determining the term grade, the Term Test is equal to 1/3 of the Class Standing in each term period. 3.Formula in Computing the Term Grade 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, ply and Students of Northern Christian College N Nurtured in Christ C Centered in Christ C Committed in Christ NCC CREDO Northern Christian College seeks a life of faith, learning and serveance that will develop the person into becoming intellectually com petent and honest, morally and ethically sensitive, and creatively cognisant and responsive to the necessarily, aspirations and realization of Just, Free and Responsible Christian social evidence. NCC MISSIONThe Mission of Northern Christian College is the didactics of the spiritual, intellectual, social and physical faculties of the y bulge outh of the Philippines with special emphasis upon the development of Christian character as exemplified by the life and teaching of Jesus Christ. NCC VISION A just free and responsible community bother up of people who argon intellectually competent and honest and morally and ethically sensitive to the needs and aspiration of the society I. packet settle of instructions written in a code / curriculums Computers do some thing you probably wish people did they do exactly what you tell them to do.They follow instructions. In fact, the only thing they do is follow instructions. Without instructions, they just sit there, as useless as that proverbial bump on a log. A list of instructions that tells a computer what to do is called PROGRAM or softw atomic matter 18 product. TYPES OF SOFTWARE I. SYSTEM SOFTWARE designed to allow the computer to manage its own re writers and meet basic operations. A. run SYSTEM -is a collection of curriculums that oversees all computer operations. showcases 1. DOS 5. 0/DOS 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 Levels of Languages a. Machine Lang represents needive information 1s & 0s (Binary Nos. ) b. Assembly Lang. low level (Uses mnemonic Codes) pic c. High Level Lang. Procedural pic d. Very High Level Lang. OOP or 4GLs pic e. Natural Lang. pic II. APPLICATIONS SOFTWARE designed and written to perform a particular kind of work/task allows to summation productivity and creativity A. WORD PROCESSING is an application program designed for manipulating text edition editionual matterbo ok employ for writing, trending and rewriting.Examples 1. Wordstar 2. MS-Word 3. scallywag nonplusr 4. WordPerfect picpicpic B. SPREADSHEET Is a microcomputer program that provides increased calculation accuracy, easy updating, and the ability to recalculate column and wrangle totals quickly under different sets of assumption. Examples 1. Lotus 123 2. MS-Excel 3. Quattro Pro picpicpic C. DATABASE MANAGEMENT SYSTEM A softwargon use to organize, analyze, search for update, and retrieve selective information. Purpose Is to organize collections of data. Examples 1. Dbase Plus 2. Foxbase 3. Access 4. Visual BasicAny collection of data shadower be do easier to maintain and much more accessible membership rouses, checking accounts, restaurant reservations mailing lists, employee records. picpicpicpic D. GRAPHICS PROGRAMS softw atomic number 18 that lets you create pictures 1. Paint Programs- apply to create bit-mapped images. Examples Paint, Adobe Photoshop 2. Draw Programs cr eate aspiration lens-oriented images. Tools to draw lines, rectangles, circles and ovals. 3. Presentation Programs is designed to further assist the user in creating and generating professional looking such as slides, visuals issuances and sounds. the well-nigh meaningful of this program is its multimedia Presentations basis be supplied movies, music and animation. Examples CorelDraw Presentation, PowerPoint, 4. Computer-Assisted Design (CAD) utilize to produce three-d images composed of circles, arcs, and straight lines. it create any object, whether its a house, ship engine, bottle, or sneaker. Examples AutoCAD E. DESKTOP publication Is designed to create publishing programs such as newsletters, brochures, cards, forms and business memos. Examples score Artist, Publisher, CorelDraw, Newsmaster, Photoshop, F.EDUCATION AND TRAINING Is designed primarily for academic and training. TYPES OF EDUCATIONAL SOFTWARE 1. Tutorials programs use step-by-step instructions to teach facts, skills, and concepts. Tutorials are rather kindred textbooks, except that they are inter prompt. Example How to operate a piece of equipment, use punctuation, read music, play the guitar and program computer. 2. Drill and practice programs are used to reinforce skills in subjects such as arithmetic, spelling, speed reading, immaterial languages, and typing. 3. Simulations programs imitate real steadyts. It reinforce facts and concepts. How do you pilot a plane? -What decisions need to be do to improve your washstanddidates chances of election? -What challenges would you as head, and how would you handle those challenges? G. GENERAL BUSINESS PROGRAMS Software that help people run their businesses. Example 1. If youre thinking of launching a new product or business, there are programs designed to help you develop and implement a business plan. 2. If you dont have an employee manual, there are programs that contain dozens of company policy statements, which you quarter use verbatim or edit to meet your specific needs. Examples of GBPs 1.Accounting software record financial transactions, prepares invoices, calculates each employees taxes and other deductions. 2. Project counselling Software helps managers plan and preclude track of the tasks resources, time schedules, and cost of project. 3. Statistical Packages are powerful tools that use a variety of calculations to analyze astronomical sets of data. 4. Decision Support Tools designed to help define the of import criteria involved in making a particular decision. -Assigning a numerical nurse, or weight, to each criterion. past you score each of your elections to see which ranks highest. H.SELF-IMPROVEMENT PROGRAM These are computer programs for al roughly personal interest or activity. This small sampling gives you a sense of the scope of whats available 1. Garden planners help you rent plans best suited for your geographical theatre, lay out your garden, and determine optimal pla nting and harvesting dates. 2. Geneology program help you organize information to the highest degree your ancestors and create family trees. 3. Home inventory programs for people who have everything, or at least penury to protect everything they have against financial loss in case of fire, theft, or natural disaster. . Wedding planners help people prepare guest lists, schedule events, postulate honeymoon destinations, and keep tract of estimated and tangible expenses. HEALTH AND FITNESS 1. Medical programs provide information on diseases, injuries, medical tests, immunizations, nutrition, dieting, and fitness, and make diagnoses based on an analysis of your symptoms. 2. Biofeedback programs designed to teach you how to handle stress, how to relax, even how to control blood compress and heart rate. MONEY MATTERS 1.Money managers organized your bills, write checks, reconcile accounts, track insurance policies, set up product line and bond portfolio rate. 2. Tax programs gui de you finished tax preparation, from compiling the necessary data to scratching out tax forms for federal and state income taxes.. I. ENTERTAINMENT PROGRAM Designed for enjoyment. GAME SOFTWARE 1. Arcades Games that let you hire at aliens or some other targets and try to pile up ever-higher scores. 2. Fantasy role-playing games schoolbook-based stories in which you ever have to make decisions Which path should I follow?Are these people to be trusted? Whats the meaning of riddle? Is this safe drink? 3. Games of chance and skill Electronic versions of card games such as bridge and poker, board games such as Monopoly and Scrabble, and TV shows such as Jeopardy, and Wheel of Fortune. 4. Simulations games that use graphics and sound effects to imitate real-life situations, giving you the chance to live vicariously as you pilot a jet fighter, drive a Formula virtuoso car, play pool. J. UTILITY PROGRAMS Designed to perform certain(p) housekeeping and maintenance tasks.They impr ove your efficiency of your computer system, protect the system against conglomerate disasters. *Most utilities are memory-resident program. They remain in the computers memory at all times. You chamberpot access them instantly, even when youre in the middle of an application. *Many utilities are packaged with operating systems and application programs. Example -utilities include with MS-DOS can display a list of archives stored on a disk, copy files. -Erase un postulateed files on a disk. -Spell checkers and thesauruses included in the account book processing packages as well can be a aspect of as utilities.ADDITIONAL UTILITIES THAT ARE SOLD SEPARATELY, profi checkoutle utilities include 1. shoot restorey program used to recover files that are mistakenly erased from a floppy or hard disk. 2. Compressors used to compress data, giving surplus space to fit more files into a hard or floppy disk. 3. Macro makers performing the same(p) sequence of teachings over and over is t ime-consuming. 4. home runer utilities programs enhance shanghaier operations by allowing to schedule print times, drive multiple newspapermans simultaneously, print spread piece of papers sideways. 5. Screen Saversdesigned to unburned images into the covert. 6.Anti-virus protect computers and computer meshings against programs called Virus. K. MULTIMEDIA Designed to perform editing, recording/ rewriting, designing movies and other media related. You can listen music and watch movies. textbook and graphics can be enhanced to with audio, video, and animation by using the techniques of multimedia production. VISUAL DATA Data used in presentation or free-drawing graphics package is already digitized for storage and processing by a computer. A toolbox in multimedia software allows a developer at the video firm to analyse and edit, frame by frame, a video.L. COMMUNICATION SOFTWARE allow a PC equipped w/ a modem to connect w/ other PC through phone lines to ex metamorphose info rmation. IX. MICROSOFT OFFICE travel by pic pic pic pic A. WHAT IS A M. S. EXCEL-Experimenting in a Cell ? Developed by Microsoft Corporation ? An electronic spread ragtime used to forge numerical data with formulas and built-in functions ? Consist of 65,536 lines 256 columns ? An Excel file is a workbook B. FEATURES 1. The keyboard is used for data entry. 2. Performs various mathematical operation. 3. Worksheets can be saved and retrieved for further editing. . Automatic calculations. 5. Supports da ragase, graphics, embedding objects and presentations. 6. Cross-referencing of multiple sheets. 7. Creating multiple graphs. 8. Multiple levels of loose C. WHY DO WE USE EXCEL 1. It helps the data to be manipulated repeatedly 2. Facilitates changes made to the figures 3. Auto numeration of correction 4. Data are enhanced by its various graphical presentation 5. It is a user friendly program 6. Avoid repetition of work 7. Saves storage space picpicpicpic D. USES OF EXCEL 1. Preparat ion of monetary Reports . Sales and Costs Analysis 3. Stock and Inventory Control 4. Effective in Sales foretelling 5. for Budgeting E. PERFORMING CALCULATION Formulas procedures used to solve a specific mathematical problem Arithmetic operators mathematical symbols used in formulas identify the process or action to be taken in fellowship to solve the problem Operand ExampleOperatorsSymbols Constant value 2Addition + Cell savoir-faire A1Subtraction melt reference A1B2Multiplication * Label Jan SalesDivision / Range name RevenuePercent % make for Sum(A1B4)Exponential sentence structure format understood by a program in order to properly execute and implement a process * Microsoft Excel syntax, includes an equal sign (=) followed by the operands and the operators standardised Examples= 2 + 3 = A1 B6 =3 * A5 =Sales / Months =5 4 picpicpicpic Operator precedence Operator comment (colon) (single space)Reference Operators , (comma) Negation (as in 1) % Percent Exponentia tion * and / Multiplication and division + and Addition and subtraction & Connects two strings of text (concatenation) = = Comparison Relative References when a formula is created, references to stalls or gets are usually based on their strength relative to the cellular phone that contains the formula when you copy the formula, Excel will political machinematically paste the changeed references in the destination cells relative to the position of the formula Absolute References used when you do not trust to lay out the references in formula when copying Functions predefined formulas that perform calculations by using specific values called causes, in a particular order or structure arguments can be constants, formulas or functions Other usually used functions are shown in the conterminous table. Function wee verbal description Result MAX() bump the largest number from the arguments =MAX(20,25,15)Result 25 MIN() Find the smallest number from the arguments=MIN(20,25 ,15) Result 15 AVERAGE() Find the average for the arguments =AVERAGE(20,25,15) Result 20 COUNT() Counts number of cells that contains=COUNT(1,4,B,3,20) number from the argumentsResult 4 COUNTA() Counts number of cells that are not=COUNTA(1,4,B,3,20) empty from the argumentsResult 5 *Some functions do not need an argument in the parenthesis.Function NameDescription Result Today() Re twist arounds current date =Today()Result 9/4/03 Now() Returns current date and time =Now()Result 9/4/03 1220 ADVANCED FORMULAS use Logical Functions help you correspond the values or expression hat Excel can evaluate as TRUE or dark. Excel then(prenominal) uses the results to perform actions or return the answers you are looking for. A. IF Function Syntax=IF(logical_test,value_if_true,value_if_false) Logical Test used to compare the values/expressions that can be evaluated as TRUE or FALSE used for text returnsValue_if_true = value that is returned if the logical test is true return the word TRU E if leave blank Value_if_false = value that is returned if the logical test is false return the word FALSE if leave blank B. NESTED IF Function used if there are few conditions and few return values C. OR Function to evaluate if all of the arguments (logical test) is TRUE up to 30 arguments can be used as long as one of the as long as one of the arguments is true, it will return a TRUE Syntax=OR(logical_test1,logical_test2,.. ) Example ReturnOR(TRUE,TRUE,TRUE) TRUE OR(TRUE,TRUE,FALSE) TRUE OR(FALSE,TRUE,FALSE) TRUE OR(FALSE,FALSE,FALSE) FALSE D. AND Function to evaluate if ALL of the arguments (logical test) is TRUE up to 30 arguments can be used as long as one of the as long as one of the arguments is false, it will return a FALSE Syntax=AND(logical_test1,logical_test2,.. ) Example Return AND(TRUE,TRUE,TRUE) TRUE AND(TRUE,TRUE,FALSE) FALSE AND(FALSE,TRUE,FALSE) FALSE AND(FALSE,FALSE,FALSE) FALSE E. COUNT IF Function Counts the number of cells within the incline that meet s the riteria Range cells that you want to compare with criteria Criteria condition in a form of text, number or expression that defines which cells will be counted Syntax =COUNT IF(range, criteria) G. PARTS OF MS EXCEL pic 1. form of plow lay off Displays the program name and the workbook name you are working on. 2. Menu Bar Displays and access the drop- downwards menus that contain the Excel command options. 3. Standard Toolbar Contains a number of buttons, which you polish off using the mouse, to carry out some of the more commonly used command options. 4. formatting Toolbar Contains a number of buttons that help you change the format or push throughance of text, such as bold and underlined. 5. Name Box Shows the selected cell, drawing object or graph item. You can also name a selected cell / range or move to the selected cell / range. 6. Formula Bar Displays the content (value or formula) of the active cell. You can also edit the formula using the formula bar. 7. A ctive Cell The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is move by a heavy border. 8.Column Heading Shows the column reference letter. 9. Row Heading Shows the row reference number. 10. Sheet Tab Shows the sheet name. 11. Horizontal Scroll Bar or Vertical Scroll Bar Help you to scroll through your worksheet using the mouse. 12. Status Bar Displays information about a selected command or an operation in progress. The right side of the status bar shows whether the keys (CAPS LOCK, SCROLL LOCK, or NUM LOCK) are turned on. 13. Task Pane Display useful common tasks such as creating and opening a workbook. There are task back breakers with different contents that help you do your work.The contents of the task pane is context-sensitive, depending on what task you are performing. H. KEYBOARD PRESS Press Move to One cell to the right One cell to the left v One cell to the down One cell to the up + coating cel l to the right of the current land + First cell to the left of the current region + v Last cell to the bottom of the current region + First cell to the flower of the current region First cell in the row + First cell in the worksheet + Last cell in the worksheet which contains data scallywag Down One sort out down scallywag Up One screen up + Page Down One screen right Page Up One screen up I. CREATING VARIOUS CHART TYPES graph ? graphic representation of worksheet data that interprets information, analyzes and compares data clearly ? can be formatted by adding a legend, chart statute title, adding pictures, markers or make an embedded chart ? visually charitable and make it easy for users to see comparisons, patterns, and trends in data graph Wizard ? a serial of negotiation boxes that lead you through all the steps necessary to create an effective chart 1. How to Create a Chart ? Using Chart Wizard ? Using Chart toolbar 2.Create a Chart Using the ChartWizard ? use up th e data range you want to chart. ? Be sure to include the data you want to chart, the column and row labels in the range. ? frank the ChartWizard form the Toolbar. ? Select Chart reference. ? Choose the Chart sub-type. ? contact Press and reach the look at sample button to preview the pickaxe. ? Choose Next. Make sure the correct data range is selected. ? Select the appropriate Chart option button to plot data series in row or in columns. ? Choose Next. ? Select the Chart Location you want to place the chart on a new sheet or on an existing sheet. If you choose to place the chart on existing sheet rather than on a new sheet, the chart is called Embedded Objects. ? slammer Finish. 3. Enhancing a Chart ? You may choose the coiffe menu and maunder Select e. g. Select Chart human action or double-click a particular object. ? Chart Toolbar Icons Chart Object Indicates the name of the selected object Format The properties of the object Legend To turn ON/OFF the legend Data Table To turn ON/ glum the display of the data By row Selects data series in a row By Column Selects data series in a column tip Text Text co-occurrence . Adding a Title ? Choose a chart to which you want to add a title to. ? perforate the Chart menu, and then click Chart options. ? Choose Titles. ? Type the text you want for the title of chart. ? To add a title to the x-axis of rotation press Tab and Text. ? If you want a second line for the x or y-axis, press Tab to move to the second category or Value box, and then type the title text. ? Preview the Title(s) you add. 5. Adding or Deleting a Legend ? Choose the chart you want to add or score out a legend. ? cut across the Legend from the Chart toolbar, and suck up the legend to move it to its new location. . Adding a Text Box ? Click the Arrow icon. ? Move the mouse to the location where you want the pointer to be placed. ? Click and drag to the new position, then release the mouse. 7. Adding a Pattern and Border to the Text ? Double-click the text you want to format, or select the text, then choose the Format menu, and select the Patterns. ? Choose the Border style you want from the options on the left side of the dialog box. ? Press Enter. 8. Select a Different Chart Type ? For most 2-D charts, you can change the chart type of either a data series or replete(p) charts. For the bubble charts, you can only change the type of the entire chart. ? For 3-D charts, changing the chart type affects the entire chart. ? For 3-D bar and column charts, you can change a data series to the cone, cylinder, or gain type. 9. changing the Chart Type ? To change the chart type, perform any of the following For the entire chart, click Chart. For the data series, click the Data Series. ? On the Chart menu, click Chart Type. ? On the Standard Types tab, click the Chart type you want. If you are hanging the chart type for one-data series and not the entire chart, be sure the Apply to Selection check box is sel ected. To apply the cone, cylinder, or pyramid chart type to a 3-D bar or column data series, click Cylinder, retinal cone or Pyramid in the Chart Type box on the Standard types tab, and then select the Apply to Selection check box. 10. Rotate Chart Title Text or Axis Text ? Click the title or the axis you want to format. ? If you clicked a chart title, click Selected Chart Title on the Format menu. If you clicked an axis title, click Selected Axis or Selected Axis Title ion the Format menu. mark off the Alignment tab. If you dont see the Alignment tab, click Cancel, click Outside of the text you want to format and then repeat the procedure. ? To rotate text, under Orientation, click a degree point, or drag the indication to the position you want. ? Note When you have more than on level or category axis labels, only the first level can be rotated. 11. Select Chart Items ? Click the Chart item you want. The data series, data labels, and the legend have individual elements that can be selected after you select the group. 12. Changing the vision of a 3-D Chart ? Click the 3-D chart you want to change. Select the options you want. When the objurgate Angle Axis check box is cleared, you can set the Perspective and Height options. When the Right Angle Axis check box is selected, you can either set the Height option or turn the Auto Scaling option on. 13. Changing the Rotation and Elevation in a 3-D Chart ? Using the menus Click the 3- Chart you want to change. On the Chart menu, click 3-D gain. Select the options you want. ? Using the mouse Click the intersection of any two axes to select the corners of the chart. Drag a corner to adjust the elevation and rotation in the chart. 14.Changing Number Formats in Charts ? If you change the number formatting in a chart, the number formatting is no longer linked to the worksheet cells. To format labels along an axis, double-click the appropriate axis. To format the data labels or a trend line label, double-c lick the item. On the number tab, select the options you want. 15. bell ringering a Chart ? Select the File menu, and choose the Page apparatus command. ? Click the Page frame-up button if you made some changes in the settings. ? Click the File menu, and choose the Page Setup command. ? Select the chart sizing button for the option you want. Press Enter. ? Choose the File bell ringer Preview command if you want to view the chart in the Preview mode to begin with it is printed. ? Click the File menu, and click the Print command. The Print Dialog Box appears on the screen. ? Click Enter. 16. Printing an Embedded Chart Embedded Chart ? chart that is placed on a worksheet rather than on a separate chart sheet useful when you want to view or print a chart on a PivotChart Report with its source data or information in a worksheet you can adjust where the chart will print on the pageboy by sizing and moving the chart with the mouse in page intermission View ?Click the worksheet outsi de the Chart area. ? Click Page Break Preview in the View menu. 17. Printing a Chart Sheet ? Click the tab from the Chart Sheet. ? Click Page Setup on the File menu. ? Select the options you want on the Chart tab. J. SAVING AN EXCEL 1. From the menu, click File Save As. The Save As dialog box appears. pic 2. In the File name box, type Excel Training. Excel has already entered a placeholder name in the File name box before you type your own file name. Since the name is highlighted. You just need to type in the new file name to overwrite it without having to click in the box. pic 3. Click the Save button. The file is saved in the indifference folder My Documents folder. K. Formatting Cell Using Menu Options You can format the cell using Format Cells dialog box from the menu. From the menu, click Format Cells, the Format Cells dialog box appears as shown below. pic Tab Description Number Specify the format style of the context in a cell. Alignment Specify text alignment, text contro l and text orientation. Font Specify grammatical case, font style, font size, font excuse, font effect and underline. Border Specify border color and line style.Patterns Specify the cell pattern and color. valueion Protect the cell to be locked to avoid changes and formula to be hidden from viewer. L. TOOLBARS 1. The Standard toolbar pic This entire toolbar could become a floating window by double-clicking on the control bar at the far-off left end of this toolbar. That gives the following window, which can be placed anywhere on the screen pic This toolbar can be restored to its schoolmaster position by clicking in the gray bar at the aggrandisement and force it back to the top of the screen. Push the top of the window up to the bottom of the menu bar. Function of commonly used buttons pic Creates a new blank archive based on the default template pic Opens or finds a file pic Saves the active file with its current file name, location and file format pic Prints the active file for more print options go to the File menu and select Print pic Print preview Shows how the instrument will look when you print it. pic spell out, grammar and writing style checker pic Cut Removes the selection from the written document and places it on the clipboard pic written matter Copies the selected item(s) to the clipboard pic Paste Places the content of the clipboard at the get intoion point pic Format painter Copies the format from a selected object or text and applies to other objects or text pic Undo Reverses the last command, use pull-down menu to unmake several steps pic Redo Reverses the action of the Undo button, use the pull-down menu to redo several steps pic Auto Sum Adds numbers automatically, and suggests the range of numbers to be addedpic Sort Ascending Sorts selected items from the beginning of the alphabet, the utmost number or the earliest date pic Sort Descending Sorts selected items from the end of the alphabet, the highest pic Chart Wizard Guides you through the steps for creating an embedded chart (graph) number or the latest date pic Displays or hides the Drawing toolbar pic soar up Enlarge or reduce the display of the active document 2. The Formatting toolbar pic This entire toolbar could become a floating window by double-clicking on the control bar at the far left end of this toolbar. That gives the following window, which can be placed anywhere on the screen pic This toolbar can be restored to its schoolmaster position by clicking in the gray bar at the top and dragging it back to the top of the screen. Push the top of the window up to the bottom of the menu bar. Function of commonly used buttons pic Changes the font of the selected text pic Changes the size of selected text and numbers pic Makes selected text and numbers bold pic Makes selected text and numbers italic pic underlines selected text and numbers pic Aligns to the left with a ragged right border pic Centers the selected text pic Aligns to the right with a ragged left margin pic Merge and Center Merges two or more selected cells and centers the entry pic up-to-dateness Style Formats selected text to display currency style pic Percent Style Formats selected cells to display percent pic comma Style Formats selected cells to display commas in large numbers pic Increase Decimal Increases the number of ten-folds displayed after the decimal pointpic Decrease Decimal Decreases the number of decimals displayed after the decimal point pic Decreases the indent to the previous tab stop pic Indents the selected paragraph to the next tab stop pic Adds or deals a border around selected text or objects pic Marks text so that it is highlighted and stands out pic Formats the selected text with the color you click 3. The Drawing toolbar pic This entire toolbar could become a floating window by double-clicking on the control bar at the far left end of this toolbar. That gives the following window, which can be placed anywhere on the screen pic This toolbar can be restored to its original position by clicking in the gray bar at the top and dragging it back to the top of the screen. Push the top of the window up to the bottom of the menu bar. Function of commonly used buttons pic A pull own menu with several pic Changes the pointer to a selection arrow drawing options pic Rotates the selected object to any degree pic A pull down menu with several libraries of springs pic Draws a line where you click and drag. Hold the Shift key down to make thepic Inserts a line with an arrowhead where you click and drag line straight pic Draws a rectangle where you click and drag. Hold down Shift to draw a pic Draws an oval where you click and drag.Hold down Shift to draw a circle square pic Draws a text box where you click and drag pic Create text effects with Word Art pic Add, modify, or remove fill color from a selected object pic Add, modify, or r emove line color pic Formats the selected text with the color you click pic Changes the thickness of lines pic Selects dash style for dashed lines pic Select arrow style placement and shape of arrowhead pic A pull down menu offers shadow choices pic Add 3-d effects to rectangles or ovals M. circuit card 1. File menu pic New Opens a new document. If you use the keyboard combination indicated on the right a blank document opens immediately. Selecting the New menu item with your cursor gives the opportunity to open a large number of types of documents. Open Opens a previously saved document. Close Closes the active document but does not quit the application. Save Saves the active document with its current file name, location and format. Save As Saves by opening a window which gives the opportunity to change the file name, location or format. Page Setup Sets margins, paper size, orientation and other layout options. Grid lines dont show up when you print?Go to the sheet tab in this window Print Preview Shows how the file will look when you print it. Print Prints the active file, also gives the opportunity to change print options Exit Closes Microsoft Excel 2. Edit menu Undo The actual entry of this item will depend on what you did last. In my subject I had typed, so that was displayed.This selection can be pic repeated several times. Redo After an action has been undone, it can be reinstated in the document. Cut Removes the selection from the active document and places it on the clipboard. Copy Copies the selection to the clipboard, the cell from which information is copied the Great Compromiser highlighted Paste Inserts the contents of the clipboard at the insertion point (cursor) or whatever is selected. Paste Special cardinal choices are available when making this selection examples include pasting formulas, values, and comments. Fill Fill contents of a selected cell Up, Down, Left or Right Clear De letes the selected object or text, but does not place it on the clipboard. Four choices are available All, Format, Contents or Comments Delete This menu entry can be used to delete entire rows or columns. Find Searches for specified text in the active document Replace Searches for and replaces specified text and formatting. 3. View menu pic Normal The default document view for most word processing tasks. Page Break Preview Before printing, make sure the page breaks appear where you want them Toolbars Displays or hides 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 Bar Remove or display the bar which displays cell address and data entered into the active cell Header and Footer Adds or changes the text that is displayed at the top or bottom of every page of the document Comments Hidden comment give further information about cell contents. Comments are displayed w hen you move the cursor into the cell, however this command causes all comments on a page to be displayed. Full Screen Hides most screen elements so you can see more of your document Zoom Controls how large, or small, the current document appears on the screen. 4. Insert menu pic Cells Use this command to insert a cell. A pop-up window allows you to move existing data down or to the right. You can also insert rows or columns with this window. Rows Inserts a new row in the spreadsheet, above the row that contains the active cell. Columns Inserts a new column in the spreadsheet, to the left of the column that contains the active cell. Worksheet By default, an Excel workbook is made up of three worksheets. You may insert as many additional sheets as you require.Sheets are inserted in appear of the current worksheet. Chart This adds a chart of the selected data, or of the entire worksheet if you have no data selected. Page Break Inserts page breaks above an d to the left of the active cell. To avoid adding a page break to the left, make sure a cell in Column A is selected before inserting the break. Function Opens the Paste Function window allowing the selection of a specific equation to go in the active cell. Comment- Have something to say about the contents of a cell? Add a small note with the appearance of a Post-It note. Picture Insert pictures from clip art or a file. You can also 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 interesting use of hyperlinks is to place a link to any document stored on your computer. You can later open that document by clicking on the link.If you want to see an example of an Excel worksheet using hyperlinks to Internet sites, download 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. ), bor ders and colors for the pic selected cells, and you may also lock the contents of a cell here. Row Specify a row height, choose auto-fit, and hide or un-hide the selected row. Column Specify a column width, choose auto-fit, hide or un-hide the selected column, or choose the standard width for a column. Sheet Here you can rename the sheet if sheet 1 is not descriptive enough (and its not), you can hide or un-hide a sheet, or you can tile an image in the background of the entire sheet. Auto Format- There are sixteen pre-designed formats to change the look of your spreadsheet. You may apply the format to the entire sheet or only to selected cells. Style Opens a Style window which will lead to the Format Cells window if you wish to Modify the format. 6. Tools menu pic Spelling Check 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, yo u can add it here. Share Workbook Choose this option if you want several users to work on the data in the same workbook simultaneously.Make it available on your network and anyone with access can make changes. Protection You can password protect a single sheet of a workbook, or the entire workbook. One obvious application would be to protect a worksheet which you are using as your grade book. Customize Select/Deselect toolbars to be displayed with your workbook, or add buttons to existing 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. One thing I use a lot here is removing gridlines from a worksheet so I can draw a graphic organizer. N. crossING 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 will be printed. pic 2. From the menu, click File Print Area Set Print Area.A dashed outline appears around the Print Area, as shown below. pic Click the print preview button to preview the printout. Only the cells in the print area would be printed. pic 3. From the menu, click File Print Area Clear Print Area. If you do not set a print area, the entire worksheet will be printed. O. PAGE SET-UP A. Orientation 1. From the menu, click File Page Setup. Click the Page tab. The Page Setup dialog box appears, as shown below. 2. Under Orientation, click the beautify option. The default orientation is portrait. pic 3. Click the OK button. The orientation of the page is set to landscape (horizontal).B. Scaling 1. From the menu, click File Page Setup. Click the Page tab. Page Setup dialog box appears, as shown below. 2. Under Scaling, in the Adjust to box, type 150. You can click the up arrow in the box to increase the number. pic 3. Click the OK button. The size of the printout on the worksheet increases. C. Paper S ize 1. From the menu, click File Page Setup. Click the Page tab. Page Setup dialog box appears, as shown below. 2. Click the Paper size drop-down arrow. Click 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. Click the OK button.The paper size changes. D. Page Margin 1. From the menu, click File Page Setup. Click the Margins tab. Page Setup dialog box appears, as shown below. 2. In the Top, Left, Right and Bottom boxes, type the margin you want to change. The margin is in inch in this example. pic 3. Click the OK button. The margin is set. P. PRINT PREVIEW 1. From the menu, click File Print Preview. Print Preview window appears. Use the command buttons in the Print Preview window to carry out more actions. pic Use the command buttons in the Print Preview window to carry out more actions. Button Action Next Display the next page Previous Displays the previous pageZoom Enlarge / reduce the content in the preview screen Print Print the current selection with printing options Setup Setup the page Margins Display or hides margin handles Page Break PreviewDisplay page break preview for you to adjust the page break Normal View Display in normal view Close Close the print preview window 2. Click the Close button. The preview window closes and returns to the worksheet. picpic LECTURE NOTES COMP1/10 INTRODUCTION TO COMPUTER SCIENCE & CONCEPTS B. A. DE LARA, JR. CBE FACULTY NORTHERN CHRISTIAN COLLEGE LAOAG CITY 2012 NORTHERN CHRISTIAN COLLEGE The Institution for Better Life Laoag City pic