Gateway Of Information Technology

Assignment on QBASIC

2017-08-21T11:48:00.004+05:30

Computer Assignment Class 7th

Chapter THREE (More on QBASIC)

Read the Quick Ride, Key Terms and all the back exercise for Half Yearly Exam

Q1. Explain the following terms?

MOD Function
LEN function
LEFT$ Function
RIGHT$ function
SPACE$ Function
MID$ Function
SQR Function

Q2. Explain LINE command with example?

Q3. Explain CIRCLE command with example?

Q4. What is the EXIT command?

Q5. Write the program to add 3 numbers?

Q6. Write the program to print table of 2.

Q7. How many total color codes are there in QBASIC?

Q8. Write the name of screen modes.

Assignment on FLASH

2017-08-21T11:48:00.002+05:30

Computer Assignment Class 7th

Chapter FOUR (More on FLASH)

Read the Quick Ride, Key Terms and all the back exercise for Half Yearly Exam

Q1. Explain the following terms?

Hand Tool
Lasso Tool
Pen Tool
Gradient
Selection Tool
Zoom Tool
Linear Gradient

Q2. What is Radial gradient?

Q3. Name the tool to create point-to-point selection of an object?

More on Flash

2017-08-21T07:49:00.000+05:30

Chapter 4 More on Flash

Answer to back exercise

1. Thick the correct option.

a. (ii)
b. (iii)
c. (iii)
d. (i)
e. (iii)

2. Fill in the blanks.

a. Selection
b. Lasso
c. Color
d. double-click
e. Linear

3. Write T if the given statement is true and F if it is false.

a. F
b. T
c. T
d. F
e. T

4. Answer the Questions:

a. The Lasso Tool is used to create a point-to-point selection of an object.

b. A gradient is a multicolour fill in which one colour gradually changes to another colour. Flash provides two types of gradients they are.
(i) Linear gradient: In this gradient the colour changes either horizontally or vertically.
(ii) Radial gradient: In this gradient the colour changes in an outward direction starting from a central point.

Zoom Tool	Hand Tool
The zoom tool is used to zoom in (enlarge) and zoom out (reduce) the display.	When the stage is magnified, it may not be possible to view the entire stage at once. The Hand Tool allows to move the stage so that the objects can be viewed.

f. To select multiple objects, click the selection tool on the Tools panel and drag a rectangle such that the objects to the desired angle.

More on QBASIC

2017-08-19T17:36:00.001+05:30

Chapter 3

More on QBASIC

Answers to back Exercise

1. Tick the correct option

A. iii

b. i

c. ii

d. ii

e. i

f. iii

2. Fill in the Blanks

a. exit
b. string
c. Resolution
d. FOR ... NEXT
e. text mode, graphics mode

f. 16

3. Write T if the given statement is true and F if it is false

a. F

b. T

c. F

d. T

e. T

f. F

4. Answer the questions.

a. The working of the following iterative commands is as follows:
(i) WHILE...WEND: This loop is used when you want to execute a set of instructions as long as the given condition is true.
(ii) DO...LOOP UNTIL: This loop executes a block of instructions repeatedly until the specified condition becomes true.
(iii) FOR...NEXT: This loop is used to repeatedly execute a statement or a block of statements for the specified number of times. This loop is a Fixed Loop.

b. The String functions available in QBASIC are given below.

LEN: This function finds the number of characters in a string.
LEFT$: This function extracts the specified number of characters from the left side of the string.
RIGHT$: This function extracts the specified number of characters from the right side of the string.
MID$: This function extracts the specified number of characters from anywhere in between the string.
SPACE$: This function is used to insert a blank space between the given strings.

c. The screen modes enable the user to adjust the screen resolution according to the requirement. the 2 basic types of screen modes are available in QBASIC. they are the Text mode and the Graphics mode.

d. The LINE command is used to draw a line between two given coordinates. the syntax of LINe command is as follows:
LINE (50,50)-(200,200), 13

The CIRCLE command is used to draw a circle or an ellipse. This command requires to specify the coordinates of the centre, the radius of the circle and the colour. The syntax of the CIRCLE command is as follows:
CIRCLE (175,150),100,14

e. The exit command is used to terminate any loop before it execute the expected number of times.

f. QBASIC allows to use one loop inside another loop. This is known as nesting of loops and such loops are called nested loops.

More on Microsoft Excel

2017-07-25T08:04:00.004+05:30

Chapter Two

URL and its components

2017-05-16T12:19:00.003+05:30

Components of Email Address

2017-05-16T12:13:00.001+05:30

Class 10 Chaper 1 Internet

2017-05-16T11:49:00.004+05:30

Very Short Answer Questions

Expand the Following abbreviations

ARPANET - Advance Research Projects Agency Network
DARPA - Department of Defense Advance Research Projects Agency
TCP/IP - Transmission Control Protocol and Internet Protocol
WWW - World wild Web
HTTP - Hyper Text Transfer Protocol
FTP - File Transfer Protocol
LAN - Local Area Network
URL - Uniform Resource Locator
HTML - Hyper Text Markup Language
SGML - standard Generalised Markup Language

Long Answer Questions

Q1. Read the following paragraph. Find five network and communication related abbreviations and give their expanded forms along with a one-line definition for each of them:

RBI is planning to expand its connectivity with all major banks of India. The plan includes providing TCP connectivity through HTTP for easy access points and seeking help from some ISPs to join hands in this venture. Also, there is a plan to setup IIS and SMTP servers. Some banks will go for DSL line, while others will use leased line connectivity to access these services. RBI is also taking the help of IIT professors in this venture.

Ans: Different communication terms are as follows:

TCP: The full form of TCP is Transmission Control Protocol. TCP is responsible for the formation of packets and delivery of the packets to destination computer.

HTTP: Hyper Text Transfer Protocol is standard set of rules that is used to access web pages found in the web server.

IIS: Internet Information Server is a web server provide by Microsoft.

SMTP: Simple Mail Transfer Protocol is used to send and receive mail form client to server and vice- versa.

DSL: Digital Subscriber Line is a technology for bringing high bandwidth information over ordinary copper telephone lines.

Q2. Shravan Joshi is a student of Political Science and is a keen researcher of Political issues related to various countries and states. He wants to share his research and his opinions on these issues on a day-to-day basis with everyone on World Wide Web. He is also interested in collecting views of others to enhance his research and knowledge related to his area of interest. He belongs to a middle class family and cannot afford his own website. Being a non-technical person, he cannot create a dynamic website to deal with day-to-day inputs either.

(a) Suggest an easy way for Shravan to achieve his goals.
(b) Name the two popularly used (and free) services that can help Shravan.

Ans:
A) Shravan should develop a blog, because it’s free and there is no technical knowledge require to create it.
B) Twitter and Blogger from Google.

Q3. As life gets busier, it becomes difficult to stay in touch with school and college friends, old neighbours and favourite teachers. It is important to keep in touch with all your near and dear ones. Sometimes, people sitting miles away doing a similar activity or solving similar kind of problems can help you achieve your goals faster by sharing their experiences. Similarly, people belonging to different socio-economic backgrounds can change your perspective and enhance your understanding of various cultures.

a) Suggest the real time toots that are suitable for the above mentioned activities
b) What is the generic name used for such tools?
Ans:
a) Facebook and Twitter
b) Social Networking

Q4. Laleema Chkradhar wants a broadband connection to access mails and stay updates with the latest happenings in the field of Biotechnology. Can you suggest two internet Service Providers that can be approached for the same?

Ans: Airtel and VSNL

Q5. Identify domain names(s) and URL(s) from the following list:

a) yoga@yoga.com
b) doYogaEveryday.com
c) www.doyogaeverydau.com/old/index.html
d) www.performingarts_schools.org/backlink.htm
e) 192.287.3.5
f) http://cbse.nic.in

Ans:

a) Email Address

b) Domain Name

c) URL

d) URL

e) IP Address

f) Domain Name

Q6. Anila works in a multinational company and needs to work online from home also. She therefore requires a fast Internet connection. Which type of Internet connection would be best suited for her? Apart from browsing, she would also need to upload and download files to/from remote sites. Which protocol will help her perform this activity?

Ans: Type of Internet connection she would uses are Broadband or ADSL line

The protocol used for uploading and downloading file from remote sites is FTP (File Transfer Protocol).

Q7. Explain the terms URL and ISP in brief. Give one example for each.

Ans:

1. URL is a web address. Uniform resource Locator is the global address of documents or web pages.

2. ISP -> Internet service Provider is any company that provides Internet services, including personal and business access to the Internet.

Chapter One Class VII

2017-04-28T08:42:00.001+05:30

Chapter One

Computer Networks

Answer the Questions

Q1. Define a computer network. List its three advantages and disadvantages.

Ans: It is an interconnected system of two or more computers and other hardware devices by some communication channel.

Three advantages of computer network are:

Speed
Information sharing
Cost effective

Three disadvantages of computer network are:

Security issues
Dependency on server
Rapid spread of computer viruses

Q2. How is the Internet different from the intranet?

Internet

It is the largest network that connects millions of computers worldwide to share information and services.

Intranet

It is a private computer network owned by a company or an organization and is accessible only to its employees.

Q3. Explain different types of computer networks.

Ans: Four different types of computer networks are PAN, LAN, MAN, WAN.

PAN (Personal Area Network) is the smallest possible network intended for one person.
LAN (Local Area Network) is a network that covers a relatively small area such as residence, a building or a campus.
MAN (Metropolitan Area Network) is a network that is formed by connecting multiple LANs.
WAN (Wide Area Network) is a network that spans a large geographical area such as several cities or even countries.

Q4. What is meant by data transmission media? Differentiate between guided and unguided media.

Ans: Data transmission media refers to the medium used for transmitting data among the devices connected in a network. It can be guided or unguided.

Difference between guided and unguided media is

Guided Media

A guided media is also called wired media provides a physical path between the communicating devise in a network

Examples are: Twisted pair cable, Coaxial Cable, Fibre optic cable

Unguided Media

An unguided media is also called wireless media is a type of transmission media that sends or receives the data through air or space.

Examples are: Radio Waves, Microwaves, Infrared, Bluetooth, Wi-Fi

Q5. Define the network topology? Briefly describe the different types of topologies.

Ans: Network topology refers to the way in which the network components (cables, computers and other peripheral devices) are connected together in a network.

Different topologies are Bus, Star and Ring.

Bus topology: In this topology the computers and other devices are connected to a single cable called the bus or backbone.
Star topology: In this topology the workstations are not directly connected to each other, rather they are connected to a centralized network device known as hub or switch.
Ring topology: In this topology the computers and other devices are connected to each other in such a way that they form a closed loop or ring.

Q6. Write short notes on the following.

Modem, Hub, NIC

Ans:

Modem: A modem (an acronym of modulator/demodulator) is a device that enables a computer to transmit data over telephone line. The job of a modem is to convert data from digital to analog format and vice versa.

Hub: A hub is a small rectangular device that connects multiple devices on a network so that they can communicate with one another.

NIC: The Network Interface Card, commonly referred to as Ethernet card, is a hardware device that enables a computer to connect to a network.

Sample Project file Plus 2 IP

2016-12-20T13:05:00.001+05:30

Copy and Paste the following Pages in your project file and do the changes according to your needs

Page -> 1

SMS (Student Management System)

A PROJECT REPORT

Submitted by

1. Adasd

2. Ssdfsdf

3. sdfsdffd

Informatics Practices

Plus Two

Delhi Public School, Amritsar.

March 2015 - 16

Page -> 2

Acknowledgement

Apart from the efforts of me, the success of any project depends largely on the encouragement and guidelines of many others. I take this opportunity to express my gratitude to the people who have been instrumental in the successful completion of this project.

I would like to show my greatest appreciation to Prof. _______________. I can’t say thank you enough for his tremendous support and help. I feel motivated and encouraged every time I attend his meeting. Without his encouragement and guidance this project would not have materialized.

The guidance and support received from all the members who contributed and who are contributing to this project, was vital for the success of the project. I am grateful for their constant support and help.

Page -> 3

CERTIFICATE

I hereby certify that the work which is being presented in the Plus Two Informatics Practices. Project Report entitled “SMS (Student Management System)”, in partial fulfillment of the requirements for final Project submission to the Department of Computer Science of Delhi Public School, Amritsar is an authentic record of my own work carried out during a period from April 2015 to January 2016 under the supervision of Jatinder Singh Randhawa, Technical Head, DPS Amritsar,

This is to certify that the above statement made by the candidate is correct to the best of my knowledge.

Signature of Supervisor(s)

Jatinder Singh Randhawa

Technical Head,

DPS Amritsar.

Page -> 4 and so on.....

Aim of Project:

This project is aimed at developing an application for the Training and Placement Dept. of the college. The system is an application that can be accessed throughout the organization as well with proper login provided. This system can be used as an application for the Centre Head of the college to manage the student information. The proposed system is to make the Centre Information available on system, so that everyone can get information about teachers and students easily. Teachers can easily communicate with the students, and can keep records of every student easily and efficiently. The proposed system could be accessed from any corner of the Centre.

Importance of Project:

Students: This is a separate Module for students.

1. Student can print documents as well.

5. They can view their information.

Administrator: The administrator has the central control over the whole portal.

1. He can access the students and faculties information directly.

2. He will create the student and faculty data which they can later on edit.

3. He can respond to the queries of the faculties.

4. He can post notices which will be accessible to the both the faculties and the students.

5. He will handle the number of students and in case any student or faculty leaves he will edit the record accordingly.

PROFILE OF PROBLEM ASSIGNED

Scope :-

This project has a large scope as it has the following features which help in making it easy to use, understand and modify it:

· Automation of Student and Teacher Registration

· No Need to do Paper Work.

· To save the environment by using paper free work.

· To increase the accuracy and efficiency of the placement procedure.

· Management of Student Data.

This software package can be readily used by non-programming personal avoiding human handled chance of error. This project is used by three types of users

· Students.

· Teachers.

· Centre Head.

Main Points are:-

· Simplified Management of Student Profiles.

· Simplified Management of Teacher Profiles.

· Selection Reports.

· Real-time Information Publishing.

OBJECTIVE OF PROJECT

Our project provides the facility of maintaining the details of the students and details of faculties so that centre head can manage the centre efficiently.

The objectives of the system are-

· To reduce paperwork.

· Reduced operational time.

· Increased accuracy and reliability.

· Increased operational efficiency.

· Data security.

This software package can be readily used by non-programming personal avoiding human handled chance of error. This project is used by three types of users

· Students.

· Centre Head

· Teachers

Administrator can create students accounts and see the data.

Centre Head can maintain daily updates in details and print reports according to need. Administrator is must be an authorized user.

SYSTEM REQUIREMENTS

PRODUCT DEFINITION:- Administration is to make an application for Information Technology Department, so that everyone can get information about teachers, students can easily communicate with teachers from anywhere. Teachers can easily communicate with the students, and can keep records of every student easily and efficiently. The proposed system could be accessed from any corner of the Centre on net.

PROCESSING ENVIRONMENT:

H/W REQUIRED :-

Processor : Pentium III and above

Graphics Card : Inbuilt with 64MB Memory

Display : Color LED,LCD, CRT

S/W REQUIRED:-

· Java

· Netbeans

· MySQL

Front End

CORE JAVA

Introduction to Java Programming

Java is a powerful object-oriented programming language introduced by Sun Microsystems in 1995, which has built-in support to create programs with a graphical user interface (GUI), utilize the Internet, create client-server solutions, and much more. Programs written in Java can run, without change, on any of the common computer operating systems Windows 95/NT, Macintosh, and Unix. A variant of Java programs called applets can be embedded inside a web page and execute on the computer that is viewing the page, automatically and in a secure environment.

As a language, Java is closely related to C++, which is also object-oriented but retains a lot of idiosyncrasies inherited from its predecessor language C. Java has removed the inconsistent elements from C++, is exclusively object-oriented, and can be considered a modern version of C++.[1] Because of its logical structure Java has quickly become a popular choice as a teaching language,[2] and because of its extensive Internet support and the promise of writing programs once and using them on every operating system Java is becoming more and more accepted in industry.

Every Java program must follow these guidelines:

· Java is case sensitive, i.e. the word Program is different from program.

· Curly brackets { and } are used to group statements together.

· An executable Java program must contain at least the following lines as a framework:

public class Name

{ public static void main(String args[])

{ ... program code ...

}

· Every statement whose next statement is not a separate group must end in a semicolon.

· A Java program containing the above framework must be saved using the filename Name.java, where Name (including correct upper and lower cases) is the word that follows the keywords public class and the file extension is .java.

· Java does have disadvantages. For example, programs written in Java are generally slower than those in C++ and it is difficult to accomplish system-level tasks in Java.

· Java compilers and tools are available for free, an important consideration for academic and student budgets.

Source Code

A Java source code file is a text file that contains programming code written according to the Java language specifications, resembling a mixture of mathematical language and English. A computer cannot execute source code, but humans can read and understand it.

Java source code files should be saved as Name.java, where Name is the name that appears in the first line of the program: public class Name. That Name is referred to as the name of the class, or program. By convention its first letter is capitalized.

Compiling

Compiling is the process of transforming the source code file into a format that the computer can understand and process. The resulting file is called the byte-code, or class, file. The name of the class file is the same as the name of the program plus the extension .class. The program javac from the Java Developer's Kit is used to transform a source code file into a class file.

Executing a Class File

To execute a Java program the Java Developer's Kit provides a program called java. When executing that program with your class file as parameter the following happens:

· The Java Virtual Machine (JVM) is created inside your computer

· The JVM locates and reads your class files

· The JVM inspects your class file for any security violations

· The JVM executes, or interprets, your class file according to its instructions if possible

Under Windows and Unix, execute a program by typing at the command prompt java Name, where Name is the name of the program (no extension). On a Macintosh, double-click the java icon and select the appropriate class file.

About NetBeans IDE

NetBeans IDE is a free, open source, integrated development environment (IDE) that enables you to develop desktop, mobile and web applications. The IDE supports application development in various languages, including Java, HTML5, PHP and C++. The IDE provides integrated support for the complete development cycle, from project creation through debugging, profiling and deployment. The IDE runs on Windows, Linux, Mac OS X, and other UNIX-based systems.

The IDE provides comprehensive support for JDK 7 technologies and the most recent Java enhancements. It is the first IDE that provides support for JDK 7, Java EE 7, and JavaFX 2. The IDE fully supports Java EE using the latest standards for Java, XML, Web services, and SQL and fully supports the GlassFish Server, the reference implementation of Java EE.

Creating a Project

The first step is to create an IDE project for the application that we are going to develop. We will name our project NumberAddition.

· Choose File > New Project. Alternatively, you can click the New Project icon in the IDE toolbar.

· In the Categories pane, select the Java node. In the Projects pane, choose Java Application. Click Next.

· Type NumberAddition in the Project Name field and specify a path, for example, in your home directory, as the project location.

· (Optional) Select the Use Dedicated Folder for Storing Libraries checkbox and specify the location for the libraries folder.

· Deselect the Create Main Class checkbox if it is selected.

· Click Finish.

Setting Up the Project

To create an IDE project:

· Start NetBeans IDE.

· In the IDE, choose File > New Project, as shown in the figure below.

· In the New Project wizard, expand the Java category and select Java Application as shown in the figure below. Then click Next.

· In the Name and Location page of the wizard, do the following (as shown in the figure below):

· In the Project Name field, type HelloWorldApp.

Leave the Use Dedicated Folder for Storing Libraries checkbox unselected.

In the Create Main Class field, type helloworldapp.HelloWorldApp.

· Click Finish.

· The project is created and opened in the IDE. You should see the following components:

The Projects window, which contains a tree view of the components of the project, including source files, libraries that your code depends on, and so on.

The Source Editor window with a file called HelloWorldApp open.

The Navigator window, which you can use to quickly navigate between elements within the selected class.

BackEnd

MySQL Database

MySQL is a database management system.

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL. Since computers are very good at handling large amounts of data, database management plays a central role in computing, as stand-alone utilities, or as parts of other applications.

MySQL is a relational database management system.

A relational database stores data in separate tables rather than putting all the data in one big storeroom. This adds speed and flexibility. The tables are linked by defined relations making it possible to combine data from several tables on request. The SQL part of MySQL stands for "Structured Query Language" - the most common standardized language used to access databases.

MySQL is Open Source Software.

Open Source means that it is possible for anyone to use and modify. Anybody can download MySQL from the Internet and use it without paying anything. Anybody so inclined can study the source code and change it to fit their needs. MySQL uses the GPL (GNU General Public License) to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to embed MySQL into a commercial application you can buy a commercially licensed version from us.

Why use MySQL?

MySQL is very fast, reliable, and easy to use. If that is what you are looking for, you should give it a try. MySQL also has a very practical set of features developed in very close cooperation with our users. You can find a performance comparison of MySQL to some other database managers on our benchmark page. MySQL was originally developed to handle very large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Though under constant development, MySQL today offers a rich and very useful set of functions. The connectivity, speed, and security make MySQL highly suited for accessing databases on the Internet.

The technical features of MySQL

For advanced technical information, MySQL is a client/server system that consists of a multi-threaded SQL server that supports different back ends, several different client programs and libraries, administrative tools, and several programming interfaces. We also provide MySQL as a multi-threaded library which you can link into your application to get a smaller, faster, easier to manage product.

The Main Features of MySQL

The following list describes some of the important characteristics of MySQL:

· Fully multi-threaded using kernel threads. This means it can easily use multiple CPUs if available.

· C, C++, Eiffel, Java, Perl, PHP, Python.

· Works on many different platforms.

· Many column types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, and ENUM types.

· Full operator and function support in the SELECT and WHERE parts of queries.

· SQL functions are implemented through a highly optimized class library and should be as fast as possible! Usually there isn't any memory allocation at all after query initialization.

· ODBC (Open-DataBase-Connectivity) support for Win32 (with source). All ODBC 2.5 functions and many others. For example, you can use MS Access to connect to your MySQL server.

· Fixed-length and variable-length records.

· Handles large databases. We are using MySQL with some databases that contain 50,000,000 records and we know of users that uses MySQL with 60,000 tables and about 5,000,000,000 rows

· All columns have default values. You can use INSERT to insert a subset of a table's columns; those columns that are not explicitly given values are set to their default values.

· DELETE, INSERT, REPLACE, and UPDATE return the number of rows that were changed (affected). It is possible to return the number of rows matched instead by setting a flag when connecting to the server.

SOLUTION STRATEGY:

Student Module:

Create An profile(Registration):

Create a form where the user can create an enter the details of academics the profile is in editable mode.

Edit Profile:

Student can edit his/her profile at any time

Admin Module:

Add Teacher:

Admin can add teacher to the list of teachers using add teacher module.

Add Student:

Admin can add students. Admin can make any changes in the data

User Management:

In users management section admin can manage the users and teachers password and their types and also can generate reports on the basis of student and teachers.

Report Generation:

In report generation section admin can generate report on the basis of teacher name , student name And admin can also generate the reports of all the students and teacher in the centre.

PROPOSED SOLUTIONS:

To develop a system that would accomplish the following:-

1. Reduce the paperwork and storage area.

2. Improve the output of operators.

3. Improve accuracy in result.

4. Allow easy navigation through Student data.

5. Manage the man and machine resources efficiently.

6.It has user friendly interface having quick authenticated access to documents.

SYSTEM REQUIREMENT SPECIFICATION

A System Requirements Specification (SRS) (also known as a Software Requirements Specification) is a document or set of documentation that describes the features and behavior of a system or software application. It includes a variety of elements that attempts to define the intended functionality required by the customer to satisfy their different users.

Sample HTML Codeing

2015-10-15T10:49:00.002+05:30

Download the files below and open it in one folder

Informatics Practices Class XII

2015-09-18T09:51:00.005+05:30

Informatics Practices Class XII Chapter 1 Solutions.

Chapter 1 Back Exercise Solutions

COMPUTER NETWORKING

MULTIPLE CHOICE QUESTIONS

1. Which of the following topologies is a combination of more than one topologies?

a. Bus b. Tree

c. Star d. None of these

2. Which of the following is used for wireless communication?

a. Optical Fiber b. UTP cable

c. Radio Waves d. Coaxial Cable

3. Which of the following is not a transmission medium?

a. Telephone Network b. Coaxial Cable

c. Modem d. Microwaves

4. IP addresses of two computers on a network:

a. Can be the same b. Cannot be the same

c. Are not defined d. Must match with a third computer

5. Bluetooth can be used for

a. Long distance communication b. Short distance communication

c. In mobile phones only d. None of the above

6. Micro waves are

a. Uni directional b. Omni directional

c. Guided media d. Not used for communication.

7. Snooping is

a. A threat to data security b. Not a threat to data security

c. Good for laptops d. A topology

8. A repeater

a. Regenerates the received signal b. Destroys the received signal

c. Can be used as a hub d. None of the above

9. Satellite links are generally used for

a. PANs b. LANs

c. MANs d. All of the above

10. A domain name maps to

a. A URL b. An IP address

c. A website d. All of the above

ANSWER THE FOLLOWING QUESTIONS

1. 1. What is a computer network? What are its advantages?

Ans. A computer network is a collection of interconnected computers and other

devices which are able to communicate with each other and share hardware

and software resources.

A few of these advantages are:

Resource Sharing

Cost saving

Collaborative user interaction

Time saving

Increased storage

2. What is meant be communication channels? Give two examples of guided media and two examples of unguided media.

Ans. A medium of data transmission over a computer network is called a channel or a transmission medium. Channels may be guided (wired) or unguided (wireless).

Guided Media are Twisted Pair Cable, Co-axial Cable, and Optical Fiber Cable.

Unguided Media are Radio Waves, Microwaves, Bluetooth.

3. Which communication channel(s) is/are suitable in each of the following situations:

a. Setting up a LAN

Wired, Guided, Twisted Pair Cable.

b. Transfer of data from a laptop to a mobile phone.

Wireless, Unguided, Bluetooth.

c. Transfer of data from one mobile phone to another.

Wireless, Unguided, Bluetooth.

d. Creating a remote control that can control multiple devices in a home.

Wireless, Unguided, Infra Red.

e. Very fast communication between two offices in two different countries.

Wireless, Unguided, Satellite links.

f. Communication in a hilly area

Wireless, Unguided, Radio Waves. .

g. Communication within a city and its vicinity where cost of cabling is too high.

Wireless, Unguided, Micro Waves

4. Why is a switch called an intelligent hub?

Ans.: A Switch is an intelligent device that connects several nodes to form a network

and redirects the received information only to the intended node(s). its work faster then the hub.

5. When is a repeater used in a computer network?

Ans.: When the data is transmitted over a network for long distances, the data

signal gets weak after certain distance. some device is required which can re-strengthen the data signal before it gets too weak. Repeater is such a device.

6. Diagramatically show how would you connect 6 PCs, 1 server, 1 printer, and 2

scanners in

a. Star topology b. Bus topology

7. Two engineers in the same room have connected their Palm-tops using bluetooth for working on a Group presentation. Out of the following, what kind of Network have

they formed?

LAN, MAN, PAN, WAN

8. What is a MAC address? What is the difference between a MAC address and an IP

address?

Ans. : Each NIC has a universally unique address assigned to it by its manufacturer. This address is known as the MAC (Media Access Control) address of the card.

Difference between MAC Address and IP is that MAC addresses are 12-digit hexadecimal (or 48 bit) numbers. Example: MM-MM-MM-SS-SS-SS The first half (MM:MM:MM) of a MAC address contains the ID number of the adapter manufacturer. The second half (SS:SS:SS) of a MAC address represents the serial number assigned to the adapter (NIC) by its manufacturer.

An IP address is a group of four bytes (or 32 bits) each of which can be a number

from 0 to 255. A typical IP address looks like this: 59.177.134.72

9. Give some examples of domain names and URLs. How is a domain name different

from a URL?

Ans: http://www.cbse.nic.in/welcome.htm is a URL and in this www.cbse.nic.in is a domain name. A domain name usually has more than one parts: top level domain name or primary domain name and sub-domain name(s). For example, in the domain name , in is the primary domain name; nic is the sub-domain of in; cbse is the sub-domain of nic. URL is the path through which we can open the website in a web browser.

10. What is domain name resolution?

Ans: Domain Name Resolution is the process of getting the corresponding IP address from a domain name.

11. Define Network security? What kind of attacks can be made on data and computer

networks?

Ans: The term Network Security refers to all activities undertaken to protect a computer network from attacks to its security. This covers protection of computers in the premises and data on the network from both internal and external attacks.

Attacks on network security are as follows:

1. Denial of service attacks:

2. Intrusion Problems:

3. Snooping

4. Eavesdropping

12. List some methods which are used for network security.

Ans:

Some methods used for network security are:

1. Login Password.

2. Firewall.

3. Anti Virus Software.

4. File Permissions.

13. Differentiate (with examples wherever possible) between :

a. LAN and MAN b. MAN and WAN

c. Hub and Switch d. Guided and Unguided media

Ans:

LAN and MAN:

A LAN (local area network) is a group of computers and network devices connected together, usually within the same building. By definition, the connections must be high speed and relatively inexpensive (e.g., token ring orEthernet).

A MAN (metropolitan area network) is a larger network that usually spans several buildings in the same city or town.

MAN and WAN

A WAN (wide area network), in comparison to a MAN, is not restricted to a geographical location, although it might be confined within the bounds of a state or country. A WAN connects several LANs, and may be limited to an enterprise (a corporation or an organization) or accessible to the public. The technology is high speed and relatively expensive. The Internet is an example of a worldwide public WAN.

A MAN (metropolitan area network) is a larger network that usually spans several buildings in the same city or town.

Hub and Switch:

A Switch is an intelligent device that connects several nodes to form a network

and redirects the received information only to the intended node(s). its work faster then the hub.

A Hub is an electronic device that connects several nodes to form a network and

redirects the received information to all the connected nodes in broadcast mode.

Guided and Unguided media

Guided media is also know as wired media. A number of various types of cables are used to transfer data over computer networks. These are Twisted Pair Cable, Co-axial Cable, and Optical Fiber Cable.

Unguided media is also know as wireless Media. Electromagnetic waves are used for wireless communication over computer networks. Frequencies of waves are measured in Hertz (Hz). These categories are (in increasing order of frequencies): radio waves, microwaves, infrared radiation, visible light, ultraviolet radiation, X-rays, and Gamma rays.

14. Write one advantage of star topology over bus topology and one advantage of bus topology over star topology.

Characteristics of Star topology:

It is more efficient topology as compared to bus topology.

It is easy to install

It is easy to diagnose the fault in Star topology.

It is easy to expand depending on the specifications of central hub/switch

Characteristics of Bus topology:

It is easy to install.

It requires less cable length and hence it is cost effective.

15. Ishika Industries has set up its new production unit and sales office at Ranchi. The

company compound has 4 buildings as shown in the diagram below:

Distances between these buildings are as follows:

Administrative Office to Factory A 150 m

Factory A to Factory B 50 m

Factory B to Sales Office 100m

Sales Office to Administrative office 200m

Administrative Office to Factory B 125 m

Number of Computers in each of the buildings is follows:

Administrative Office 15

Factory A 25

Factory B 18

Sales Office 15

1. Suggest a cable layout of connections between the buildings so that each building is directly connected to Administrative Office.

Star Topology.

2. Suggest the most suitable place (i.e. building) to house the server of this production unit with a suitable reason.

Administrative Office because it is directly connected to all other building.

3. Suggest the placement of the following devices with justification:

(i) Repeater

(ii) Hub/Switch

Administrative Office to Factory A 150 m Switch

Factory A to Factory B 50 m Switch

Factory B to Sales Office 100m Switch

Sales Office to Administrative office 200m Repeater

Administrative Office to Factory B 125 m Switch

4. The Administrative office of this unit is to be linked with the head office situated in

Patiala (Punjab). What will be the most economical way to do this? Justify your

answer.

WAN we can connect administrative office to head office using internet. Reasons are internet is cheaper and also the distance between the 2 offices is more.

LAB EXERCISES

TEAM BASED TIME BOUND EXERCISES

1. Find the IP addresses of at least five computers in your school.

Command to find the IP address of a computer is ipconfig. To run this command open cmd (Command Prompt) and the type ipconfig there you will find the ip address of a machine.

2. Find the MAC addresses of at least 2 computers in your lab. Then verify their

manufacturer's name on the net.

Command to find the MAC address of a computer is ipconfig /all. To run this command open CMD and type ipconfig /all. In the output you will find the option called Physical Address this is called MAC Address.

3. Find the layout of LAN in your school's labs. If you think some modifications can be done in the layout, note these down in your notebook.

In our school we are using Star topology.

4. Find the name of Internet Service Provider of your school.

iBerry.

5. Find the IP address of your school's web site.

To find the ip address of a website open whois.net website and type the website name, here you will get all the details of that website.

2015-09-10T19:36:00.003+05:30

Lets Learn Loops in C++

While Loop in Different Forms

2015-08-24T11:59:00.000+05:30

Predict the output of the following codes:

1. int i=0;
while(i<10)
{
JOptionPane.showMessageDialog(rootPane,"hello");

}

2. int i=110;
while(i<10)
{
JOptionPane.showMessageDialog(rootPane,"hello");
}

3. int i=0;
while(i<10);
{
JOptionPane.showMessageDialog(rootPane,"hello");
i=i+1;
}

4. int i=0;
while(i<10)
{
JOptionPane.showMessageDialog(rootPane,"hello");
i++;
}

5. int i=0;
while(i<10)
{
JOptionPane.showMessageDialog(rootPane,"hello");
i--;
}

6. int i=0;
while(i==10)
{
JOptionPane.showMessageDialog(rootPane,"hello");
}

7. while(i<10)
{
JOptionPane.showMessageDialog(rootPane,"hello");
}

8. int i=0;
while(i<10)
{
JOptionPane.showMessage Dialog(rootPane. "hello");
}

9. int i=0;
while(i<10)
{
JOptionPane.showMessageDialog(rootPane,"hello");
i=10;
}

10. int i=0;
while(i<10)
{
JOptionPane.showMessageDialog(rootPane,"hello");
i=i+1;
i=i-1;
}

11.

while(1)
{
JOptionPane.showMessageDialog(rootPane,"hello");
}

String Function in JAVA

2015-08-20T20:39:00.000+05:30

Sample HTML Code

2015-08-19T12:30:00.000+05:30

In this HTML code we are learning how to write the tags like

H1 to H6 (Heading)
HR (Horizontal Tag)
B (Bold tag)
U (Underline Tag>
I (Italic tag)
Font (font tag)
Font tag Attributes like FACE, SIZE, COLOR
CENTER (Center tag)
BR (Line Break)

Sample Code of HTML tags

<html>

<head><title>Lets Learn HTML</title></head>

<h1>Heading</h1>

<hr>

Horizontal Rule<br>

<hr>

<br>This is sample <b>BOLD</b> <br>

<br>This is sample <u>UNDERLINE</u><br>

<br>This is sample <i>ITALIC</i><br>

<br>This is sample <font face="Lucida Handwriting" size=10>FONT FACE</font><br>

<br>This is sample <font size=10>FONT SIZE</font><br>

<br>This is sample <font color=red size=10>FONT COLOR</font><br>

<br>This is sample SUB SCRIPT:<font size=10> Log<sub>e</sub></font><br>

<br>This is sample SUPER SCRIPT:<font size=10>X<sup>2</sup></font> <br>

<br>This is sample <br>

<br>This is sample<br>

</center>

</body>

</html>

OUTPUT:

How to write an if construct in java

2015-08-18T20:18:00.002+05:30

User Interface:

Code written on the event of Check age Button:

int age;

age=Integer.parseInt(jTextField1.getText());

if(age<=0)

{

jLabel2.setText("ERROR");

}

else

{

if(age>0 && age<=50 )

{

jLabel2.setText("Young Age");

}

else

{

jLabel2.setText("Old Age");

}

Class X A DPS Amritsar

2014-09-08T13:27:00.001+05:30

Today we have learned How to Create Blog

Database Intro

2013-10-09T18:00:00.001+05:30

Software is a set of instruction to perform a particular task

Database is collection of tables.

Table is a collection of columns which stores information in the form of rows. which refers to a records.

RDBMS or DBMS (Relational Database Management System or Database Management System)

Is a software which is use to manage data.

Operations like Adding new records and modifying old records and delete the old records are performed in Database

Various Databases are like Oracle, Microsoft, MySql.

Microsoft Access is a graphical tool to create database and manage tables in a database.

Simplest Example of a Database operations is a mobile phone Contacts

Mobile-> Database

Contacts-> table

Records of our friends

firstname

lastname

middlename

mobileno

homeno

dob

address

all the above are the columns of a contact table

task on the table

new

modify

delete

How to open MS Access.

Start -> All Programs -> Microsoft Office -> Access

Case Study:

I want to store information about the details of a school.

Information we need to store in a school database.

1. Students

2.Staff

3.Class

4.Exam

5.Subject

Database Name : SchoolDB

Tables in a SchoolDB Database

1. Table Name: Students

2. Table Name: Staff

3. Table Name: Class

4. Table Name: Exam

5. Table Name: Subject

Columns in Students Table:

RollNo.

FirstName

LastName

MiddleName

MobileNo.

HomeNo

FatherName

Mothers Name

DOB

Age

Address

ClassName

LastClassScore

LastSchoolName

FeePaid

Section

Columns in Staff Table:

FirstName

LastName

MiddleName

MobileNo.

HomeNo

Address

Qualification

Post

Exp

Salary

LastSchoolName

Columns in Class Table:

ClassID

Classname

fee

Columns for Exam Table

ClassID

SubjectID

Rollno

Marks

Columns for Subject Table

SubjectID

SubjectName

ClassID

How to create a Blog

2013-09-25T18:22:00.001+05:30

1. Create a Email Id

2. Register in www.blogger.com

3. Follow the steps and create the blog.

4. Create new post on your blog.

5. Publish your Blog.

6. View your blog.

AD Rotator with timer

2013-09-21T14:28:00.001+05:30

Lesson 2 in ASP.NET (using HTML)

2013-09-03T17:03:00.001+05:30

To Create the following layout write the code below

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Online Exam System Help</title>
<style type="text/css">
h1{color:Orange;
}

.style1
{
font-size: xx-large;
font-weight: bold;
}

</style>
</head>
<body>
<div class="header"><img src="images/ID.jpg" atr="Online System"
style="height: 217px; width: 700px" /><br /><font face="Courier New" color="#0066ff" size="100pt">Testing System</font></div>
<div class="sidebar">
<h1>Exams</h1>
<ol>
<li>C++</li>
<li>Java</li>
<li>PHP</li>
<li>MySQL</li>
<li>Oracle</li>
<li>ASP.NET</li>
</ol>
</div>
<div class="content">
<h1>Exam Details</h1>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td valign=top>C++</td>
<td>Details of the Programming with C++ Test are as follows. Principles of Object-Oriented Programming:
Tokens. Expressions and sequences. Functions with C++. Classes and objects, Constructors and destructors, Operator overloading and type conversions.

Inheritance:
Extending classes, Pointers, Virtual functions and polymorphism, Managing console I/O operations, Working with files.

C++ I/O Systems:
C++ I/O basics, Formatted I/O, Manipulators, User defined inserters, Extractors and Manipulators.

</td>

</tr>
<tr>
<td valign=top>Java</td>
<td>Java Exam Details are as follows. Introduction to OOPs AND JAVA, Understanding the Fundamentals, Working with Access Specifiers and Functions, Constructors, Destructors and Inheritance,
Exception Handling, Graphical User Interface Programming (GUI), Event Handling, Working with Threads, File Handling, Collections, Generics and Annotations, Networking with Java, Remote Method Invocation (RMI), Java Database Connectivity (JDBC) and JavaBeans
</td>

</tr>
<tr>
<td valign=top>PHP</td>
<td>PHP Exam Details</td>

</tr>
<tr>
<td valign=top>MySQL</td>
<td>MySQL Exam Details</td>

</tr>
<tr>
<td valign=top>Oracle</td>
<td>Oracle Exam Details</td>

</tr>
<tr>
<td valign=top>ASP.NET</td>
<td>ASP.NET Exam Details</td>

</tr>

</table>

</div>
</body>
</html>

Lesson 1 ASP.NET (Use Of HTML)

2013-09-03T16:59:00.003+05:30

To Create this output write the following code in notepad and run it in Internet Broswer.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Online Testing Website</title>
<style type="text/css">
h1{color:Orange;}
H2{COLOR:RED;}
</style>
<script type="text/javascript">
function selectexam() {

alert('You have select ' + selectExam.value);
mainframe.document.body.innerHTML = "";

if (selectExam.value == "C++") {
mainframe.document.write("You Have Selected C++ Exam");
mainframe.document.body.style.background = "ff3333";

}
if (selectExam.value == "Java"){
mainframe.document.write("You Have Selected Java Exam");
mainframe.document.body.style.background = "66cc33";

}
if (selectExam.value == "PHP"){
mainframe.document.write("You Have Selected PHP Exam");
mainframe.document.body.style.background = "00ff99";

}
if (selectExam.value == "MySQL"){
mainframe.document.write("You Have Selected MySQL Exam");
mainframe.document.body.style.background = "66ccff";

}
if (selectExam.value == "Oracle"){
mainframe.document.write("You Have Selected Oracle Exam");
mainframe.document.body.style.background = "ff00ff";

}
if (selectExam.value == "ASP.NET"){

mainframe.document.write("You Have Selected ASP.NET Exam");
mainframe.document.body.style.background = "ccff33";

}
if (selectExam.value == "C#.NET"){

mainframe.document.write("You Have Selected C#.NET Exam");
mainframe.document.body.style.background = "RED";

}

}

</script>
</head>
<body>
<div id="BodyContent">
<h1>Online Testing System</h1>
<h2>Welcome Students</h2>
<hr />
Please Select The Exam:
<select id="selectExam">
<option value="C++">C++</option>
<option value="Java">Java</option>
<option value="PHP">PHP</option>
<option value="MySQL">MySQL</option>
<option value="Oracle">Oracle</option>
<option value="ASP.NET">ASP.NET</option>
<option value="C#.NET">C#.NET</option>

</select>
<input id="buttonselect" type="button" value="Select" onclick="selectexam()" />
</div>
<div id="Frameid"><iframe id="mainframe" name="mainframe" frameborder=1 width=1300 height=500></iframe></div>
</body>
</html>

Save Button Code in ASP.Net

2013-08-02T13:56:00.002+05:30

First Insert these lines at the top of code bind file

using System.Data;

using System.IO;

using System.Configuration;

using System.Data.SqlClient;

Second step is to write this line inside your class

string _connStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;

Third step is to write this code in save button event

protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
String struserid, strpassword, strfirstname, strmiddlename, strlastname;
String stremailid, strmobilenumber, strcollegename;
struserid = txtuserid.Text;
strpassword = txtpassword.Text;
strfirstname = txtfirstname.Text;
strmiddlename = txtmiddlename.Text;
strlastname = txtlastname.Text;
stremailid = txtemailid.Text;
strmobilenumber = txtmobile.Text;
strcollegename = txtcollegename.Text;
SqlConnection con = new SqlConnection();
con.ConnectionString = _connStr;
String strinsert = "insert into profiledata(userid,firstname,middlename,lastname,emailid,mobile,collegename,password) values('" + struserid + "','" + strfirstname + "','" + strmiddlename + "','" + strlastname + "','" + stremailid + "','" + strmobilenumber + "','" + strcollegename + "','" + fileName + "','" + imageBytes + "','" + strpassword + "')";
con.Open();

SqlCommand cmd = new SqlCommand(strinsert, con);
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception exp)
{
Label1.Text = "Error in inserting Data";
}

}

Sign In Code in ASP.Net

2013-08-02T13:49:00.001+05:30

First Insert these lines at the top of your code bind file.

using System.Data;

using System.Configuration;

using System.Data.SqlClient;

Second step is to write this code in signin button event

protected void btnSignIn_Click(object sender, EventArgs e)
{
String struserid = txtuserid.Text;
String strpassword = txtpassword.Text;
if (struserid == "" && strpassword == "")
{
Label1.Text = "Please Valid User ID";
Label2.Text = "Please Fill Valid Password";
}
else
{
SqlConnection con = new SqlConnection();
con.ConnectionString = _connStr;
String strselect = "select userid,password from profiledata where userid='" + struserid + "' and password='" + strpassword + "'";
con.Open();
SqlCommand cmd = new SqlCommand(strselect,con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["sessionuserId"] = struserid;
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('mygallary.aspx','frame1');", true);

}
else
{
Label1.Text = "Please Valid User ID";
Label2.Text = "Please Fill Valid Password";

}

}
}