Monday, 4 December 2017

HSC March 2018 IT Sample Paper

Visit the following Web site.



http://www.itonlineexam.com


Go to EXAM menu and choose the required Section Q. Paper sample

Tuesday, 26 September 2017

Lesson No. 4 - Web Browsers, Email, Messengers

Click on the Link if ppt not visible

Lesson No. 4 PART 1 PPT 
Lesson No. 4 PART 2 PPT 







Lesson No. 4 Web Browsers, E-mail Clients and Messenger Utilities           XI Comm. and Science
I Fill in the blanks:

1.      HTTP stands for Hyper Text Transfer Protocol.
2.      WWW stands for World Wide Web.
3.      Bcc section of email indicates that the receivers of the email are unable to see the list of other addresses to whom the email has been sent.
4.      Incoming emails are saved in Inbox in MS Outlook.
5.      Draft folder is used to save any email message that you create but do not send in MS Outlook.
6.      In Shell connection type, internet user will get only textual matter of a web page.
7.      URL stands for Uniform Resource Locator.
8.      DNS stands for Domain Naming System.
9.      Generic top-level domain (gTLD) for non-profit organization is usually  .org
10.  POP stands for Post Office Protocol
11.  Software used to manage your emails : Eudora and Microsoft Outlook.
12.  Option provided while composing email :    To,   Subject,  Cc,  Bcc,
13.  Popular Web browsers:  Mozilla Firefox,  Google Chrome, Internet Explorer
14.  Protocols used while sending and receiving emails:  SMTP,   POP

II  Define:
1) Internet: Internet is a global system of interconnected computer networks using a common protocol (TCP/IP) through telephone wires, fibre optic cables, wireless technologies, satellite links, etc.
2) Web Browser: Web Browser or Internet browser is the program that is used to access internet and view web pages on the computer. It is used to locate, retrieve and display content of the World Wide Web, including Web pages, images, video and other files.
3) Web Server: A Web server is a computer system on Internet that uses HTTP (Hypertext Transfer Protocol) to serve the Web pages to users, in response to their requests, which are forwarded by their computer's browser. It is a computer where the web content is stored. Basically, web server is used to host the web sites but there exists other web servers also such as gaming, storage, FTP, email etc.
4) Email: Electronic mail is the term given to electronic message, usually a form of simple text message that a user types in a computer system and is transmitted over network to another user. You can also attach files to an email.
5) WWW:  World Wide Web  is a an information space where documents and other web resources are identified by Uniform Resource Locators (URLs), interlinked by hypertext links, and can be accessed via the Internet. It is a system of Internet servers that supports documents formatted in mark-up language called HTML that supports links to other documents as well as graphics, audio and video files.

III Write short note on:
1) IP Address: An Internet Protocol address (IP address) is a numerical label assigned to each device (e.g., computer, smart phone, other devices) participating in a computer network that uses the Internet Protocol for communication. It is used to identify itself and communicate with other devices in the IP network. Any device connected to the IP network must have an unique IP address within the network. 
There are two standards for IP addresses: IP Version 4 (IPv4) and IP Version 6 (IPv6).
    IPv4 uses 32 binary bits to create a single unique address on the network. An IPv4 address is expressed by four numbers separated by dots. Each number is the decimal (base-10) representation for an eight-digit binary (base-2) number, also called an octet. For example: 216.27.61.137, 192.168.1.15
    IPv6 uses 128 binary, bits to create a single unique address on the network. An IPv6 address is expressed by eight groups of hexadecimal (base-16) numbers separated by colons, as in 2001:cdba:0000:0000:0000:0000:3257:9652. Groups of numbers that contain all zeros are often omitted to save space, leaving a colon separator to mark the gap (as in 2001:cdba::3257:9652).

2) Domain Naming System:  DNS is a hierarchical, distributed method of organizing the name space on Internet. The DNS is a worldwide system of servers that stores location pointers to Web sites. It translates Internet domain and host names to IP addresses and vice versa.
DNS implements a distributed database to store domain names and their web server's IP addresses on the Internet. The DNS database resides on a hierarchy of special database servers.

Whether you're accessing a Web site or sending e-mail, your computer uses a DNS server to look up the domain name you're trying to access. The proper term for this process is DNS name resolution, and you would say that the DNS server resolves the domain name to the IP address.
For example, when you enter "http://www.howstuffworks.com" in your browser, part of the network connection includes resolving the domain name "howstuffworks.com" into an IP address, like 70.42.251.42, for HowStuffWorks' Web servers.

3) Messenger: Messenger is  an app used for instant messaging to individuals or groups. It allows to share photos, videos, audio recordings and other files. Example: Yahoo Messenger, MSN messenger, Facebook messenger, AOL, gtalk, etc.

4) FTP: The File Transfer Protocol (FTP) is a standard network protocol used to transfer computer files between a client and server on a computer network. It can also be used to send configuration files and software updates for network switches and routers. FTP uses ports for communications and also uses encryption to protect the information being received and sent.

6) Gateway Access:  Gateway Access is also known as Level-One connection. The gateway allows two different types of networks to communicate with each other. A network gateway can be implemented completely in software, completely in hardware, or as a combination of both. Depending on the types of protocols they support, network gateways can operate at any level of the OSI model. For example within India, all access to Internet from India are through BSNL gateway.

7) Dial-up Connection: Dialup connection is also known as Level Two connection. It provides connection through a dial-up terminal connection.
It is a form of Internet access that uses the facilities of the public switched telephone network (PSTN) to establish a connection to an Internet service provider (ISP) by dialing a telephone number on a conventional telephone line. The user's computer uses an attached modem to encode and decode information into and from audio frequency signals, respectively.
When connecting, the modem will pick up the phone and dial a number that is attached to Internet Service Provider's computer(host). After the connection has been made the computer can check e-mail, browse the Internet, and share files.
It allows users to surf the Web at 56 Kbps speed. The types of dial-up connection are:
a) Shell Connection                 b)  TCP/IP Connection             c) ISDN connection

IV Answer the following:
1) Explain the fields available while composing an Email. Answer on Page No. 108 / 104(Science Textbook)
2)  Explain the different Email Protocols.   Answer on Page No. 109  / 105(Science Textbook)
3)  Give the applications(uses) of Internet.   Answer on Page No. 101  /  98(Science Textbook)
 



Lesson No. 2 Office Suites - Ms Excel


Lesson No.  2 Office Suites - MS Excel


Fill ups/MCQ
1.  There are 10,48,576 rows and 16,384columns in Excel 2007.
2.  In excel cells are formed by rows and columns.
3.  To add the values in a selected row, columns or cells Autofill option is used.
4.  The default number of worksheets present in a Excel file are three.
5.  In excel 2007, the mathematical expressions are referred to as Formulas.
6.  A cell is formed due to the intersection of a row and a column and it is identified by a unique address.
7.  To specify date in Excel, special symbols Forward slash and hyphen are used.
8.  Line chart is used for Scientific data analysis.
9.  In Excel 2007, Functions are in-built formulas.

Write Navigation Shortcuts
Ctrl + Home – Takes you to the first cell in the spreadsheet.
Ctrl + End – Takes you to the last non-empty cell in the spreadsheet.
Ctrl + Left arrow () – Takes you to the last column in the sheet.
Ctrl + Down arrow – Takes you to the last row in the sheet.
Tab key – Move to the next cell on the right.
Shift + Tab – Move to the next cell on the left.
Page Down – Move down one screen
Page Up – Move up one screen.

Define the following:
1) Spreadsheet - A spreadsheet is grid of rows and columns used to store, organize and analyze numerical or financial data.

2) Worksheet -  A An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A.

3) Cell - An intersection of a row and column in a worksheet is called cell.

4) Cell Pointer - The cell pointer in Excel is the active cell or the selected cell and is highlighted by a bolder rectangle. The location of the cell pointer is listed below the tool bar to the left of the formula bar.

5) Name box - Name box is located above the worksheet area, which displays the cell reference or the name of the active cell. Active cell is the cell where cell pointer is placed.

6) Formula bar - Formula bar is located above the worksheet area on the right of the Name box and displays the contents of the active cell. It can also be used for entering or editing data and formula.

7) Cell References – A cell reference in a formula is the address of a cell, or the addresses of a range of cells. It tells the program where to look for the values or data to be used in a formula. There are two types of cell references:

i) Absolute Reference: It is the cell address in the formula that is fixed. They do not change if you copy a formula from one cell to another. It is given by preceding both column and row number by the dollar sign($). Example- Formula =$A$1*B1,   If it is copied down a column it will change to =$A$1*B2

ii) Relative Reference: It automatically changes when the formula is copied to a new location. The changed cell address will be relative to the address of the cell containing formula. Example the formula =A1*B1 is copied down a column it will change to =A2*B2

Answer the following:
1.         What are functions? List some functions and their usage.
Ans.  A function in Excel is a built-in formula that is used to perform calculations and return value of the result. Excel has a rich collection of functions which are categorized into Financial, logical, text, logical, date-time, lookup reference, Math-trigonometry, statistical, engineering, cube, etc.
MAX() – Returns the maximum value from a range of values.
MIN() – Returns the minimum value from a range of values.
SUM() – Returns the sum or total of a set of numbers.
AVERAGE() – Returns the average or arithmetic mean of a set of numbers.
POWER()– Raises a number to a specified power.
SQRT() – Returns the square root of a positive number.
NOW() – Returns the system date and time or the serial number of the date and time.
DATE() – Returns the date after inputting year, month, day.
DAY() – Returns the day of a date as an integer ranging from 1 to 31.
IF() – Evaluates a condition, if true returns the second argument and for false returns the third argument.
ROUND() – Rounds a number to a specified number of digits.

2.         List the parts of Excel 2007 window
Ans. Title bar, Tabs and Ribbons, Office button, Quick Access toolbar, Worksheet area, Formula bar, Name box, Scroll bars, Split bar, View buttons, Zoom Slider, Status bar, etc.

3.         Give the advantages of Spreadsheet.
The advantages of spreadsheet are as follows:
a)         All the calculations can be done by using formulae and which automatically recalculates every time the data is changed.
b)         It provides handy tools for analyzing the data and can be represented in the form of graphs and charts.
c)         A spreadsheet program has a large collection of in-built functions for doing calculations.
d)         An electronic spreadsheet has the obvious advantages of processing speed and storage capacity of a computer.

4.         Write a note on Graph or Chart.
A graph or chart is a graphical presentation of data. A chart is visually appealing and makes it easy for users to see comparison, patterns and trends in data. In Excel 2007 there are 11 categories of charts: Column, Line, Pie, Bar, Area, XY Scatter, Stock, Surface, Doughnut, Bubble and Radar. For data arranged in columns and rows can be plotted in Column, line, bar, area, XY scatter, etc. type of charts. Data that is arranged in one column or row only on a worksheet can be plotted in a Pie chart. Excel provides variety of chart tools for formatting the chart.

Wednesday, 6 September 2017

Lesson No. 2 Office Suites - MS Word


Lesson No.  2 Office Suites
Types of Office Applications à Word processors, Spreadsheet, DBMS, Presentation,
                                                        Publishing software, etc.

Microsoft Office Suite
 Collection of Application software combined into one unit.
Applications available are:  Word, Excel, PowerPoint, Access, Outlook Express, One Note, Publisher, Groove, InfoPath and Microsoft Tools à Picture Manage, Clip art, etc..
Versions of Office Suiteà Office 97, 98, 2000, xp, 2003, 2007, 2010, 2013, 2016, 2018

Answer the Following
1)     What is Word processor?    Page No.  9
2)     Define Word processing.    Page No.  9
3)     Define Word processing system.  Page No.  9
4)     What are the applications of Word processor/MS Word? Page No. 9

5)     List the names of ribbons tabs in Word.  
Home, Insert, Design, Layout, References, Mailings, Review, View

6)     List the name of commands and groups of Home ribbon.
   Group Name                                            Commands
a)     Clipboard                                    Cut, Copy, Paste, Format Painter
b)     Font                                             Font, Font size, ………
c)     Paragraph                                  Bullets, Numbering, ………
d)     Styles                                           list of styles
e)     Editing                                         Find, replace, select

7)     Write the steps to do mail merge in Word.    Page No. 16
8)     Write the steps to Insert Table in Word.   Page No. 17
9)     Write the steps to insert columns in a Table in Word  Page No. 18

Textbook Exercises Answers  Page No. 52   (new textbook)
Fill ups                                                               Old textbook  (Commerce Section)
1.   Show Readability Statistics                1. Show Readability Statistics               
2.   Replace                                              2. Landscape    
3.   Auto correct                                       3. Replace
4.  Mail Merge                                         4. Auto Correct
                                                                 5. Mail merge

True or False
1.      False
2.      True
3.     False
4.     True
5.     True

MCQ  Single correct answers
1.      Status
2.      Toolbar
3.     Upper Right
4.     Size
5.     Copy

MCQ   Select two answers
1.       A   and  D
2.      A and B
3.      A and B
4.      A and  D
5.      A and B

MCQ  select three answers
1.      A, B and D
2.     A, C and D
3.     A,B and C
4.     A, B and D
5.     A,B and D


Rearrange the following

1. In Word 2007, the procedure to "Zoom in" to get a close-up view of our document or "Zoom Out" to see more of the page at a reduced size is _________
Ans. dcba
    a. Drag the Zoom slider to left to Zoom Out till we get the desired result.
    b. Drag the Zoom slider to right to Zoom In till we get the desired result.
    c. In the Zoom Slider bar, Click on the slider.
    d. Point to the Lower right corner of the Word document.

5. Procedure for saving a copy of document involves __________
Ans. bdac
    a. Type a new name for the document in the filename box.
    b. Open the document whose copy is to be made.
    c. Click on Save button.
    d. Click on Save As

2. Steps for starting with creation of new template involve _______
Ans. baced
    a. Click Blank document, and then click Create.
    b. Select new option from file menu.
    c. Make the changes that you want to the margin settings, page size and orientation, styles, and other
    d. Give the new template a file name, select Template in the Save as type list, and then click Save
    e. Click the Microsoft Office Button and then click Save As.

4. Procedure for finding a particular text from documents _________
Ans. bcda
    a. Click on Find next button.
    b. Select the edit menu.
    c. Select find tab to find the text.
    d. In the find what text box type the text you want to find.