1. NUMBER SYSTEM CONVERSION AND BINARY ARITHMETIC
Aim :
To perform Binary to Decimal conversion and vice versa and do Binary addition , subtraction , multiplication and division using calculator application in PC.
Procedure :
1. Click on Start -> All Programs and open Calculator application program.
2. Click on View menu and select Programmer mode.
3. With the 4 Radio buttons ( Hex , Oct , Dec and Bin ) , we can convert between number systems and perform binary arithmetic operations like addition , subtraction and multiplication and division.
4. Thus, Calculator application program is used for doing Number systems conversions and binary arithmetic operations.
( Use only Pencil )
Left Hand Side :
Decimal to Binary :
( 125 ) 10 = ( ) 2
Binary to Decimal :
( 11101100 ) 2 = ( ) 10
Binary Addition :
( 11101011 ) 2 + ( 01110111 ) 2 = ( ) 2
Binary Subtraction :
( 10011101 ) 2 – ( 10000111 ) 2 = ( ) 2
Binary Multiplication :
( 11011 ) 2 x ( 100111 ) 2 = ( ) 2
Binary Division :
( 11110111 ) 2 ( 1110 ) 2 = ( ) 2 èQuotient
2. MIXED CELL REFERENCING IN EXCEL 2013
Aim:
To create multiplication tables of different numbers up to 15.
Procedure:
1. Open Microsoft Excel 2013 from Start-> All Programs.
2. Click on Blank workbook.
3. In sheet 1 of workbook, enter the multiplicands in Row2 i.e from B2 to E2 and multiplicators in column A i.e from A3 to A17.
4. Enter the mixed referencing formula in cell B3. =$A3*B$2.
5. Copy the formula to all the adjacent cell by clicking and dragging the bottom right corner of the cell.
Result :
Thus, the multiplication tables of the required set of numbers was easily calculated.
3. USING FORMS, SORTING & FILTERING, ADVANCED DATA FILTERING IN EXCEL 2013
AIM:
To use forms for entering data in Excel sheet and perform Sorting & Filtering, advanced data filtering in Excel 2013
PROCEDURE:
1. Open Excel 2013 from Start -> All Programs.
2. Click on File -> Options -> Customize Ribbon -> Commands not in the Ribbon ->Form and add it to a New Group under Home tab and Click Ok.
3. Type the Heading for the Excel database. Click on the Forms button .
4. Do the data entry for all the records in the database as shown in Pg.42 of textbook.
5. Sort the data in the Descending order of Customer Names by selecting any cell in Customer Names column and using Home tab -> Sort & Filter -> Sort Z to A option.
6. Filter the data by choosing Home tab -> Sort & Filter -> Filter option . Select the Product drop-down list box and deselect all except Washing Machine and Click ok.
7. Clear the Filter by using Clear option.
8. Copy the column headings to some another location and type a criteria to filter under any heading.
9. Click on Data tab and choose Advanced under Filter Group . Select the Radio button Copy to Another Location. The list range as the entire table . The criteria range as the column headings along with any values and the copy to location as some cell in the worksheet. Click Ok to see the copied filter list.
Result : Thus the usage of Forms , sorting , filtering records and performing Advanced filter was done in Excel Sheet.
4. CONSOLIDATING DATA AND CREATING CHARTS
AIM :
To prepare a consolidated report of the car sales data in the first quarter of 2 consecutive years and create line chart for both the data.
PROCEDURE :
1. Open MS-Excel from Start -> All Programs.
2. Create a Blank New workbook.
3. Create 3 sheets -> Sheet1 , Sheet2 and Sheet3 .
4. Group the sheets by clicking on Sheet1 and press Shift and click on Sheet 3.
5. Enter the common heading , months in columns and cars name in rows.
6. Ungroup the worksheets by right-clicking on any one sheets and selecting Ungroup sheets.
7. Enter the values for car sales data.
8. Click on Sheet 3 tab , and select Consolidate option from the Data tab.
9. Add the sheet references of the car sales data in Sheet1 and Sheet2 and press Ok.
10. The consolidated report of the car sales data is displayed in Sheet3.
11. Create a line chart by selecting the data and pressing F11 key. Give suitable chart heading , axis titles , apply background color for the chart , add gridlines and change their color.
RESULT :
Thus , consolidation of data and creating charts was done in Excel 2013.
5. DRAWING SHAPES IN QBASIC
Aim : To draw a smiley , concentric color filled circles and a hut shapes using the command learnt in QBasic.
Procedure :
Open qb.exe from QB45 or QB64 folder and type the following coding to draw the shapes :
(i)Smiley face :
SCREEN 12
CIRCLE (320, 240), 70, 5
PAINT (320, 240), 5
CIRCLE (320, 255), 30, 15, 3.3, 6.13
CIRCLE (285, 215), 10, 15
CIRCLE (355, 215), 10, 15
END
(ii) Concentric colour filled circles :
SCREEN 12
CIRCLE (320, 240), 100, 2
PAINT (320, 240), 2
CIRCLE (320, 240), 50, 4
PAINT (320, 240), 4
(iii)Hut shape
SCREEN 12
LINE (260, 180)-(320, 60), 4
LINE (320, 60)-(380, 180), 4
LINE (380, 180)-(260, 180), 4
PAINT (320, 80), 4
LINE (260, 180)-(380, 300), 9, BF
6. HTML BASICS
Aim :
To create a HTML document with the basic structure and apply a background color , font-name , color and size .
Procedure :
1. Open Notepad and type the following HTML code.
<!doctype html>
<html>
<head>
<title> Class 7 </title>
</head>
<body style=”background-color : #00ff00 ; font-size : 35px ; font-family : Algerian ; color : green”>
This is my first web page.
</body>
</html>
2. Save the file as File1.html and choose Save As type as All Files in Documents folder.
3.Open the Documents folder and double-click on File1.html to open it in any web browser.
Result :
Thus , the HTML document with the basic structure is created and formatting styles were applied.
7. INSERTING IMAGES , HYPERLINKS AND SCROLLING TEXT IN HTML
Aim :
To create a HTML document that displays images , links to other webpage and scrolling text.
Procedure :
1. Open Notepad and type the following HTML code.
<!doctype html>
<html>
<head>
<title> Class 7 </title>
</head>
<body>
<h1><center><u>This Webpage contains Images , links and scrolling text</u></center></h1>
<center><img src=”NewYear.png” width=300 height=300 /></center>
<br>
<hr>
<a href=”File1.html”> Click Here to see Activity 6 </a>
<hr>
<br><br><br><br><br>
<marquee bgcolor=”yellow”> <h1>Flash News !!! </h1></marquee>
</body>
</html>
2. Save the file as File2.html and choose Save As type as All Files in Documents folder.
3.Open the Documents folder and double-click on File2.html to open it in any web browser.
Result :
Thus , the HTML document with images , hyperlink and scrolling text was created and formatting styles were applied.
ANNUAL PORTIONS COMPLETED
Computer Notes 2019-20 