Buddingbossesataits.files.wordpress.com



Introduction of ComputersAIM: To learn about introduction of computersAbbreviation of Computer: C- CommonlyO- OperatedM- MachineP- ParticularlyU- Used forT- TechnicalE- EducationR- ResearchDefinition of Computer: Computer is an electronic device which stores data and gives the result consistently. The word “Computer” comes from the word “compute” which means calculate. So a powerful computer can handle some million instructions per second.Block Diagram of Computer: Secondary storage Devices A Computer consists of number of components. They are: 1. Input Unit2. Output Unit3. CPU4. Secondary Storage Unit1. Input Unit Input unit is used to send data (or) programs into computer. They are several kinds of input units are available .They are keyboard, mouse, joystick, light pen etc.2. Output Unit Output unit is used to display the results from the computer. They are several kinds of output units are available. They are monitor, printer, projector, speaker, etc.3. Central processing Unit The CPU is most important part of the computer. All devises are connected to CPU. It is also called”processor”. CPU is considered as the brain of the computer. CPU performs all types of data processing operations. It stores data, intermediate results and instructions (program). It controls the operation of all parts of computer. It includes a) Arithmetic and Logical Unit b) Control Unit c) Memory Unita) Arithmetic and Logical Unit: Arithmetic and Logical Unit is used to perform arithmetic and logical operations. Here arithmetic operations like additions, subtractions, multiplications and divisions. Logical operations such as comparing, selecting, matching and merging of data.b) Control Unit This unit controls the operations of all parts of computer but does not carry out any actual data processing operations.Functions of this unit are:It is responsible for controlling the transfer of data and instructions among other units of a computer.It manages and coordinates all the units of the computer.It communicates with Input/output devices for transfer of data or results from storage.It does not process or store data.c) Memory or Storage Unit This unit is used to store data (or) programs. It is also known as internal storage unit or main memory or primary storage or Random access memory (RAM). The primary memories stores data temporarily. Functions of memory unit are:It stores all the data and the instructions required for processing.It stores intermediate results of processing.All inputs and outputs are transmitted through main memory.4. Secondary Storage UnitThe Secondary Storage Unit is used to store data permanently. It can store large amount of data. There are several kinds of Secondary Storage Units. They are hard disk, floppy disk, etc.REGISTRATION FORMAim:To create a document i.e.” Registration Form” with the help of MS-Word (Microsoft word).Procedure: Opening Ms-Word: Click on “Start” button Click on “All Programs” Select the option “Microsoft Office” and click on “Microsoft Word” Page Bordering:Click on “Page layout” menu under that click on “page Borders” option And select the bordering type, which you want to apply to the page.and Click “ok” button. Text Alignment:Select the text where you want to change the text alignment of the text.Click on “Home ” Menu.And choose alignment type {left, right, center} from the toolbar. Change font size:Select the text where you want to change the size of the textClick on “Home menu ”Select the font size i.e., in the form of integers from toolbar Changing format of text: Select the text which you want to change the format of text. Click on “Home Menu” Select the formatting type form toolbar i.e., Time New Roman, alias…..Etc. Inserting Square Box Symbol : Place the cursor where you want to insert “square box” Click on “Insert menu” Chose the option “Shapes” from the toolbar. Select the symbol and place where you want. Inserting Rectangle Box Symbol: Click on “Insert Menu ” Click on “Shapes” option from toolbar Chose the option “Shapes” from the toolbar. Select the symbol and place where you want.Saving a Document: To save a document, we follow some stepsClick “MS-Office Button and drop down list will appear.Click “save” button from drop down list, then “save as “dialog box will appear.Type file nameClick “save” button. Result: The given task i.e. “creating registration form” executed successfully.Output:REGISTRATION FORMName :Father’s name :Occupation :Mother’s name :Occupation :Gender : male femaleDate of birth :Temporary address :Permanent address :Educational qualifications : SSC : INTER :MPC CEC DEGREE :Percentage :ICET rank :Hobbies :Date:Place: SignatureFEEDBACK FORMAim:To create a “Feedback Form” by using Ms- WordProcedure:Opening Ms-Word: Click on “Start” button Click on “All Programs” Select the option “Microsoft Office” and click on “Microsoft Word” Page Bordering:Click on “Page layout” menu under that click on “page Borders” option And select the bordering type, which you want to apply to the page.and Click “ok” button. Text Alignment:Select the text where you want to change the text alignment of the text.Click on “Home ” Menu.And choose alignment type {left, right, center} from the toolbar. Table Creation:To create a table we follow some stepsClick a point on document where we insert a table.Choose “insert” menu and select” table” option on ribbon.Drag the mouse and select rows and columns what do we want?Release the mouse and table will be appeared on document. Cell Merging: Select the rows and columns Click right button And select the merge cell option Inserting Square Box Symbol : Place the cursor where you want to insert “square box” Click on “Insert menu” Chose the option “Shapes” from the toolbar. Select the symbol and place where you want. Apply background color to the cell : Open Home In paragraph dialog box, select “shading” option choose color the back ground behind the selected area.Saving a Document: To save a document, we follow some stepsClick “MS-Office Button and drop down list will appear.Click “save” button from drop down list, then “save as “dialog box will appear.Type file nameClick “save” button.Result: The given task i.e. “creating Feedback from” executed successfully.Output:FEEDBACK FORMFaculty name: subject: year/semester:Student: Roll number: Branch:REVIEW GUDIDELINESComplete this peer review, using the following scale, NA=not applicable 1=unsatisfactory 2=marginal 3=meets requirements 4=exceeds requirements 5=exceptionalEVALUATION5=exceptional4=exceeds requirements3=meets requirements2=marginal1=unsatisfactoryRequired skill and knowledge in the classResponse To QuestionAbility To learn and Teach New skillsMaking students to involve in the class The way syllabus is coveredEnglish speaking skillsMAIL MERGEAim: To create a “Mail Merge” by Using Ms-Word.Procedure To create a mail merge, we follow some steps. They are 1) Select a document type2) Connect the document to a data source3) Edit Recipients4) Insert merges Fields5) Preview your letter6) Complete the merge1) Select a document type:To select a document type, we follow some steps Select the “Mailing Tab” on ribbon. Click the “Start Mail Marge Command” in the “Start Mail Merge Group”, and then drop _down list will appear. Select the type of document you want to create. 2 ) Connect the document to a data source To connect the document to data source, we follow some steps:From the mailing ribbon, click “Select recipients command” in the “Start mail merge Group” then drop down list will appeared The drop down list having three different options, choose one of new address list command then “New address list ” dialog list will appeared We can add address one by one by using “New entry button ” and click ok button, and then save address dialog box will appeared Type the “file name” and click “save” button3) Edit Recipients:To edit the recipients, we follow some steps they are Click the “Edit Recipients list” button in the “Start mail merge group ” and then the “mail merge recipients” window will appear With the use of check box we can select and deselect the recipients from group list.4 ) Insert merge fields:To insert merge fields, we follow some steps, they are position the insert point where we want to insert Click “Insert Merge Filed ” Command in the “write & insert fields group” and then “Insert Merge Filed “ dialog box will appear. Add insert fields one by one by using “Insert” command.Finally click “close” button. 5 ) Preview you letters :To preview your letters click “The preview Results” in the “Preview results group”6 ) Complete the merge :To complete the merge, we follow some steps: click “finish of merge” command in the “finish” group and then drop-down list will appear.In drop-down list, click “Edit individual list” option and then “merge to new Document” will appear.Click “OK” button. OUTPUT:MAIL MERGE TEMPLATETIRUPATHI31-12-2015.FROMAITSTIRUPATI.TO<<FIRST NAME>> <<LAST NAME>><<CITY>>SUB: NEW YEAR WISHES-REGMY DEAR <<FIRST NAME>>“A new year brings not only happiness it makes us happy with a hope to fulfill our dreams or a new year beginning of your life so, anew year is very special to everyone”.HAPPY NEW YEAR!!!YOUR’S FAITHFULLY AITS.MAIL MERGE TEMPLATETIRUPATHI31-12-2015.FROMAITSTIRUPATI.TOAAA ReddyKadapa.SUB: NEW YEAR WISHES-REGMY DEAR AAA Reddy “A new year brings not only happiness it makes us happy with a hope to fulfill our dreams or a new year beginning of your life so, anew year is very special to everyone”.HAPPY NEW YEAR!!!YOUR’S FAITHFULLY AITS. EMPLOYEE SALARY DETAILSAim To prepare the table for “Employee Salary Details” in MS-Excel.Procedure 1. Select” Ms- Excel” from Ms-Office. 2. Select a new work sheet in a work book.3. Type heading as “EMPLOYEE SALARY DETAILS” in a work Sheet 4. Give the field names EMPNO, ENAME, BASIC_SALARY_SALARY_ SALARY, DA, HRA, PF, ITAX, GROSS_SALARY, and NET_SALARY.5. Enter the data into certain fields. EMPLOYEE SALARY DETAILSEMPNOENAMEBASIC SALARYDAHRAPFITAXGROSS SALARYNET SALARY101AAA25000102BBB30000103CCC27000104DDD41000105EEE240006. Use the following formulasDA =BASIC_SALARY*60/100HRA= BASIC_SALARY*40/100PF= BASIC_SALARY *5/100ITAX=BASIC_SALARY * 10/100GROSS_SALARY= BASIC_SALARY+DA+HRANET_SALARY = GROSS_SALARY - (PF-ITAX)7. Finally “save” the work sheet.OUTPUT: EMPLOYEE SALARY DETAILSEmp.NoE.NameBASIC SALARYDAHRAPFITAXGROSS SALARYNET SALARY101AAA250001000015000125025005000046250102BBB300001200018000150030006000055500103CCC270001080016200135027005400049950104DDD410001640024600205041008200075850105EEE24000960014400120024004800044400STUDENT MARKS DETAILSAimTo prepare the table for “Student marks details” in MS-ExcelProcedure:1. Select “MS-Excel” from Ms-Office 2. Select a new worksheet in a work book 3. Type heading as “STUDENMT MARKS DETAILS” in a work sheet4. Give the field names SNO, ROLLNO, SNAME, M1, M2, M3, M4.M5, M6,Total Percentage and Grade.5. Enter the data into certain fields. STUDENT MARK DETAILSSNOROLLNOSNAMEM1M2M3M4M5TOTAL PERCENTAGEGRADE1101AAA54663377992102BBB88556655993103CCC99774523994104DDD66447798995105EEE8899598899 5. To calculate Total, first select the marks and use the option sum in sigma – icon in the home tab6. To Calculate Grade use the formula = IF(AND(D>35,E3>35,F3>35,G3>35,H3>35)“PASS” , “FAIL”)7. Finally “Save” the work SheetOUTPUT: STUDENT MARK DETAILSS.NoROLL NOSNAMEM1M2M3M4M5TOTAL PERCENTAGEGRADE1101KUMAR546633779932965.8FAIL2102BHASKAR885566559936372.6PASS3103RIYAZ997745239934368.6FAIL4104SWAPNA664477989938476.8PASS5105DIVYA889959889943386.6PASSCreating charts in MS-ExcelAim:To prepare charts for “Population of Rayalaeema” by using Ms-Excel.Procedure for creating charts;:1. Select MS-Excel program in MS-Office.2. Select a new work sheet in work book.3. Type heading as “Population of Rayalaseema”.4. Give the field names as district and population.5. Type the data in work sheet. 6. Select the data in work sheet. 7. Click “Insert Tab” on menu bar. 8. Select the “Chart Type” in chart group. 9. Click “Ok” button.OUTPUT:POPULATION OF RAYALASEEMADistrictPopulationY.S.R2882469Kurnool4053463ATP4081148Chitoor4174064PIE-CHART:COLUMN CHART:BAR CHARTCREATING PRESENTATION USING MS-POWER POINTAim:To create a presentation with the help of Ms-Power point.Procedure :1 ) Starting Ms – Power Point:To start Ms – Power Point we follow some steps Click on “Start Button” Click on “All Programs” Select the option “Microsoft Office” and click on “Microsoft Power Point” 2 ) Creating Presentation:To create presentation, we follow some steps Click Ms – Office button, then drop down box will appear. Click “new Button” then new presentation dialog box will be appear. Click “Create” Button.3 ) Saving Presentation :To save a presentation, we follow some steps Click ” Ms- Office” Button and then the drop down box will appear Click “Save” Button and then the “save as” dialog box will be appear Type file name and click “Save” Button.4 ) Opening presentation: To open presentation, we follow some steps Click “Ms-Office” button and then drop down list will appear . Click “open” button and then “open” Dailong box will be appear Choose file name and Click “open “button.5 ) Inserting a new Slide To insert a new slide, we follow some steps Click “New Slide ” on Home Ribbon Select the “Type of slide” which we want Repeat above steps and add another slides 6 ) Adding design to slides , we follow some steps Click “Design” tab on Menu bar Click on the “Design Image ” and automatically change the background of each slide 7 ) Adding slide Transitions: To add slide transitions, we follow some steps Click “ animations” Tab on menu bar Click a slide “transition effect” in the”Transition to this slide” and then add effect of current slide. 8 ) Adding custom Animation To add custom animation, we follow some steps Select the slide to which one wants to apply an animation Click animations tab on menu bar Click “Custom animations” button in animation group, then “Custom animation ” Dialog box will appeared on right of window Click add effect button, then drop down list will appear Select the desired type of effect.9 ) Adding sounds: Top add sounds , we follow some steps Select the slide to which one wants to apply sound Click “insert ” tab on menu bar Click” Sound” Button and then insert sound dialogue box will be appear Choose a sound file and click “ok” button OUTPUT:Slide -1Slide-2Slide-3Slide-5Slide-6 Statistical lab program procedure1. Aim: To calculate correlation co-efficient for the following data:X59131721Y1220253335PROCEDURE:Correlation will be calculated by using the MS-Excel.Open a MS-excel workbook by clicking on start program.Enter the data in the following table, in cell of a new Excel worksheet. With the help of data x and y the correlation will be calculated.To use the formula for correlation click on the formula tab and select the more functions.Select the statistical tab to generate the correlation.The following syntax is used to calculate correlation Syntax:CORREL (array1, array2)The CORREL function syntax has the following arguments:Array1????Required. A cell range of values.Array2????Required. A second cell range of values.The equation for the correlation coefficient is: Whereare the sample means AVERAGE (array1) and AVERAGE(array2).Given data to calculate correlation is xy512920132517332135FormulaDescriptionResult=CORREL(A2:A6,B2:B6)Correlation coefficient of the two data sets in columns A and B.0.9860762492. Aim: To calculate karl-pearson’s co-efficient of correlation for the following data:X37546827Y712881013510PROCEDURE:Karl-pearson’s co-efficient of Correlation will be calculated by using the MS-Excel.Open a MS-excel workbook by clicking on start program.Enter the data in the following table, in cell of a new Excel worksheet. With the help of data x and y the karl-pearson’s co-efficient of correlation will be calculated.To use the formula for karl-pearson’s co-efficient of correlation click on the formula tab and select the more functions.Select the statistical tab to generate the karl-pearson’s co-efficient of correlation.The following syntax is used to calculate karl-pearson’s co-efficient of correlation SyntaxPEARSON(array1, array2)The PEARSON function syntax has the following arguments:Array1????Required. A set of independent values.Array2????Required. A set of dependent values.The formula for the Pearson product moment correlation coefficient, r, is: where x and y are the sample means AVERAGE(array1) and AVERAGE(array2).Given data to calculate karl-pearson’s co-efficient of correlation is xy37712584861081325710FormulaDescriptionResult=PEARSON (A2:A9,B2:B9)karl-pearson’s co-efficient of Correlation coefficient of the two data sets in columns A and B.0.962095745 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download