Web Applications

Tour with the Internet and the WWW

In the World of Internet and World Wide Web :

The Difference between  the Internet and WWW:

Major Networking and Computing Technologies : Chronological Order

Internet and WWW at Present : An Overview

The graph on your right shows the current situation of connectivity world wide. We can easily understand almost the whole world now having coverage of internet.

On your right, it's an statistic showing number of Websites reached over 165000000 in 2008.

A Web-based System : 

- Uses Dynamic Class Loader and Security Manager to compute server
- Clients are Applet, CGI script, stand-alone
- it also has Logging facilities
- It has searching facilities for computing resources

Internet Infrastructure :

The internet infrastructure include cable and wireless both the networks. It includes the server, user, computer and networks of computer.



Internet is such a system that allows user to send instant message globally.

How Instant Messaging works

Trends in the Internet and WWW

All About Web 2.0 :

Features :  - Use network as a platform as it deliver or receive applications thoroughly via a browser.
                - Users gets, manipuates and cntrolled the data on the site.
                - User can edit or add value to the application according to their requirement.
                - A rich, interactive and user-friendly interface.
                - Enhanced graphical interfaces which is absent in so-called Web 1.0.

Web 2.0 Elements

Categories of Web 2.0 Sites :

There are three categories of Web 2.0 Sites :

1. Social Networking
2. Mashups
3. Aggreators

Social Networking Sites : Web 2.0

Reflections Finally :

A great Concept on Database and Database system

On the track with Database & DBMS

After the Information System we were waiting for another new chapter. And when our lecturer introduced us with it we were eager to learn about it. The topic is Database. From previous course we got to know about Database but never tried ourselves how it actually works. Only theory covered ourselves.

But now even i can give a brief idea on Database. so what is Database? Database is the place to store the data in a system. It's the pool of data.

And Database Management System which is also called DBMS is a system to manipulate the database.

Example of Database System Management Tool: Microsoft Access      









Database Components: It has 4 main components.

1. Data Item : Data is used as a input for database.
2. Relationship : Connection between two or more tables.
                         There are also 3 types of relationship in database:  - 1 to 1
                                                                                                     - 1 to many
                                                                                                     - many to many
3. Constraints : Restriction of the contents of the database
4. Schema : Formal Language to support the database management system. Also to describe the organizational data in database.

Database Management System :
- Has 5 primary functions
- Database uses syntax similar to computer language called DDL (Data Definition Language). It defines the structure of data in database.
- It also uses DML (Data Manipulation Language) to edit, process, manipulate the data.
- Query Database uses SQL (Structured Query Language) to retrieve specific information or data in database.

Database Models: There are 4 types of Database Models.

1. Hierarchical Database: Apply 1 to many relationship concept.
2. Network Database: Many to many relationship.
3. Relationship Database: Connections between rows and tables in database. Apply one to one, one to many and many to many relationship.
4. Object-Professional Database: Object Oriented Programming Language

Special Terminology:

- Field : represents by the columns
- Record : represents by the rows.
- Key Field : the primary key or key field for students is their matric no. For certain subject the key filed is a unique number for the subject.
- Object : the entity of the database.
- Table : the collection of records.

How to Create a Database on MS Access 2010 :

1. First open MS Access 2010 and rename your database and press create button on your right corner.

2. When you press Create button, it will open for you a new page in MS Access. The page you are viewing now is a datasheet view of the database. You may select design view from the Home tab view button

3. Then you can edit your datasheet view depending on your information.








4. Then when you shift to design view it may look like this. But before this select one of the criteria in your database as a primary key to make a relationship with another datasheet.

5. Then you can create another datasheet without closing the MS Access and save and close it by right click on the datasheet tab bar.

6. You may make a relationship by clicking on the relationship button on the table tools Deign Tab.

7. Now you also can create a form like database which will allow you to input data and record it as well. You just have to click on the Form button on Create Tab.

8. You can create Queries and Reports from Queries Wizard and Report Wizard button respectively from Create Tab.






These were glimpse from our lab exercise and test.

Reflections Finally :


1. From the weeks we got to know about Data and Database Management system in brief.

2. We also got to know that Database system is the combination of Database and Database Management System.

3. We also were taught about the advantages of Database System.

4. 4 types of Database models were interesting and we got to know about the example of relationships.

5. Finally Lab Test and Exercise made everything easy to understand and apply on MS Access effectively.

Information System

IT and ICT

Data and Information

Nineth Week on All About Internet

A Brief Concept....Session 1

In 1995 FNC (Federal Networking Council) came out with a definition of the term Internet. It reflected Internet as,

- a global information system

- logically linked together

- based on IP

- using TCP/IP

- used publicly or privately

[Note:  TCP - Transmission Control Protocol;  IP - Internet Protocol]

Backgrounds and History through Timeline

Internet was the result of some visionary thinking by people in the early 1960's in scientific and military fields. After that it went through and resulted as a great network system of the world:

1962 - J.R. Licklider of MIT first proposed for a global networks of computers.

1969 - ARPANET was developed by ARPA (Advanced Research and Project Agency) with four major computers at UCLA, SRI, U.Utah and UCSB.

1969 - Charley Kline at UCLA sent the first packets on ARPANETs.

1972 - E-mail was adapted by Ray Tomlinson of BBN in 1972.

1974 - The TCP/IP models are being proposed by Cerf and Kahn.

1980 - IPv4 was introduced; BITNET connected IBM Mainframes.

1983 - ARPANET adopts TCP/IP

1984 - NSFNET became the backbone network

1989 - Archiver (Index) was created for FTP sites was named Archie.

1995 - The Internet is became completely commercial.

Internet Characteristics

- A computer network consisting of a worldwide network of computers

- World-wide acceptance

- Connects people worldwide to have social network

- Continued exponential growth

- Used for Information and commercial exchange

- Dynamic 

- Self learning tool

- Increasing Quantity of Information

- Storage of Quality Information

- Safety and Security

- Access and resources not equal around the world

In addition, Internet is the largest network in the world which is also popularly known as "Information Highway." It moves your information through Cyberspace the space of elctroninc movement of ideas and information.

The Uses of Internet

- Send e-mail messages

- Upload or download files between computers

- Participate in discussion groups

- Surfing the web

Internet Applications

There are three types of internet applications:

1. Traditional Core apps:

- Email, News, Remote Login

2. The killer apps:

- WWW (World Wide Web)

3. New apps:

- Video-conferencing, internet broadcast etc.

The Underlying Technologies: OSI

OSI (Open System Interconnection) consists of Seven layers which are the following:

- Layer 1 (Physical): Hardware

- Layer 2 (Data Link): Handling errors, flow control and synchronization

- Layer 3 (Network): Switching and routing, logical paths

- Layer 4 (Transport): end-to-end system data transfer

- Layer 5 (Session): Connction between applications

- Layer 6 (Presentation): The Syntax Layer

- Layer 7 (Application): End user process

Hypertext

Hypertext is text which contains links to other texts. The term was coined by Ted Nelson around 1965.

It led to software such as Hypercard.

Example:

HTML

The abbreviation is Hypertext Markup Language. It uses codes or tags, to tell the browser how to display text contained in the documents.

World Wide Web

It was created by Tim Berners in 1989 to help researchers to find information through a linked texts. It used HTTP for protocol and HTML for content of pages.

At present The Web consists of information organized into web pages which contain text and graphic images. It contains hypertext links with highlighted keywords that relates to information.

Website: A collection of linked web pages that has a common theme or focus

Home Page: The main page that all other pages of a website are organized around and linked back to.

Web Browers

The current browsers like Internet Explorer has the following options:

- Browsing

- Email

- HTML Editor

- News reader

- Net Meeting

- File sharing

- Media Delivery over the web

Session 2. ISP, Configuring Internet Connection and Troubleshooting

Internet Connection

1. LAN Servers

Local Servers can provide access to the internet through normal connections (Ethernet)

2. SLIP and PPP

Serial Line Internet Protocol and Point-to-point Protocol allow dial-up connection to the internet and also transmit packets over internet.

3. ISP

Connection via online service provider like Microsoft Network which needs sign-up procedures.

Internet Service Provider (ISP)

A commercial organization with permanent connection to the internet that sells temporary connections to the subscribers.

Examples: America Online, Celcom, Maxis NET etc.

How to Create a New Dial-up Connection

Click Start on your desktop, then click control panel, double-click on network connections, and then click Create a New Connection. Click Set up my Connection manually, click next and then connect using a dial-up modem, then click next. Then type the phone number that was provided to you by your ISP. Then choose the option for shared by all users as you like. Then in the next screen type the logon information and then by clicking next and Finish end your setup process.

IP Addressing

Each computer on the internet has a unique identification number called IP Address. It is a four part number.

For example:  106.38.456.34

IP Address for blogger.com website in command prompt

Domain Name Addressing

Most web browsers use Domain Name Addressing; it is a unique name associated with a specific IP adrees by a program that runs on internet host computer. The program is called DNS (Domain Name System) software and the host computer is called Domain Name Server.

For example, arts (cultural and entertainment activities), gov (government sites) are used as domain name.

URL

To identify web pages exact location, web browsers rely on Uniform Resource Locator (URL). It is also a four part addressing scheme which are, protocol, domain name, pathname and filename.

HTTP

This is the most common transfer protocol known as Hypertext Transfer Protocol is the set of rules that the computers use to move files among computers on the internet.

Other HTTP examples: File Transfer Protocol (FTP), and Telnet Protocol

Reflections Finally:

1. This was our last chapters which gave us a brief but informative lessons from the concepts of internet.

2. We got to know about the definition, history and uses of internet.

3. We learned about OSI model which has7 layers, hypertext, HTML , WWW and web browsers.

4. In our 2nd session we were taught on types of internet connection, especially the abbreviations of SLIP, PPP and ISP.

5. We had been demonstrated on the connections and were described how the routers and modem via telephone line works. This was totally new for me.

6. I also got known about the difference between IP address and Domain name and the parts of an URL. A brief concept of HTTP also gave me idea about it.

Eighth Week on MS PowerPoint Video Presentation

Session 1...PowerPoint Basics

What is Microsoft PowerPoint 2010?

It is the latest version developed by Microsoft and being used by learners and teachers for presentation. Shortly known as MS PowerPoint, it is a part in Microsoft Office package suite. It runs on Windows and Mac OS X operating system which is truly an excellent presentation tool.

Dynamic Presentation Tool

Microsoft PowerPoint features all the editing tools as well as an impressive selection of presentation-specific options, such as transitions and animations. You can also add and edit a variety of other non-text elements, such as images, video, audio, hypertext and graphs. Microsoft PowerPoint also supports drag and drop, making adding information and interesting elements to your presentation especially easy.

It gives more ways to create exciting and dynamic presentation with various options and themes. It enables you to post presentation online and to surf it from anywhere in the world as well.

New video creating and sharing option gives the user the same opportunity to create virtual presentation like using other video editing software. It is more easier and efficient as we have been demonstrated in the class following basic steps.


Themes and Features

The following is a class assignment titled "About Myself"have submitted last week.

Creating New Slide

Go to Home tab and press new slide then click it. A drop-down bar will appear and you may choose a slide as you like.

Theme elements drop-down bar

Applying a Theme

Theme Elements - Colors, Fonts and Style

Instructions:

1. Go to Design tab,

2. Locate themes Themes group

3. Then use drop-down arrow to scroll down to view more themes

4. Choose and apply a theme you like

Selecting a theme for slides

Inserting Images

You may insert an image by drag and drop option or you may copy an image and then paste it onto your slide. You may insert clip art and paste screenshots on slides.

Adding an image from file inside computer

Insert Clip art through Clip Art Button

Selecting a default clip-art

 

Result after applying a clip-art into slide

Transition 

You can apply transitions to some or all of your slides by moving to Transitions tab. There are three categories of unique transitions which are Subtle, Dynamic content and Exciting.

Transitions tab view and selecting

Modifying a transition and adding sound

After applying transition the slides are moving in professional way

WordArt and Shapes

WordArt allows the user to create stylized text with effects shadows, outlines and so on.
The user also can insert a variety of shapes such as rectangles, circles, lines and arrows etc.
To create WordArt go to insert tab and select WordArt and then apply the style you like.

Applying WordArt from insert tab

Shapes also can be chosen from same insert tab; then go to shapes and then choose the shapes you like. You may insert text inside a shape. These shapes can be used to make organizational chart, arrow direction and so on.

Applying a pentagon shape on your slide

Animation (Text and Objects)

You can find all marvelous animation for your slides to make it truly virtual. There are four types of animation effects which you can find from animation bar directly.

1. Entrance Effect
2. Emphasis Effect
3. Exit Effect
4. Motion Paths

You may click on the animation pane to edit your animation effect later on. You can select either entrance or exit effects depending on your mode.

Selecting an emphasis effect from animation tab

Working with Video

You can insert a video to your slide from insert tab then clicking on insert video button; or else you can insert it from layout video options as well. after inserting you can trim it and format it's appearance.

Inserting a video from insert tab and layout video option

Trim Video from playback tab

Audio and Sound 

If you want to insert an audio you can do so by clicking on insert tab and then insert audio option.
You can choose your audio from a file inside computer or you can download it from online.

Inserting an audio from insert tab

By going to playback button up on the menu bar, you can select options like "play across slide" or "on click".
If you want to listen music throughout your presentation, click play across slide. And also click hide during show if you want to hide it during presentation.

Audio playback options

Session 2...More on MS PowerPoint 2010

Smart Art Illustration

You can insert and use an smart art from Smart Art button in Insert tab. You can insert the graphics and can modify color and effects; you can use 3D option for more visual attraction.

Smart Art option

Create a Video

After you have finished the presentation you can go to File tab, then save and send, then click on Create a Video. you will see several options for DVD quality and HD quality video. you can choose anyone of them depending on your purpose.

And then click on Create Video button. It will take several minutes to be saved on your desired locations.

Create a Video from MS PowerPiont 2010

Finally we finished to learn the basics of MS PowerPoint 2010 and we were given an exercise to submit  the video burned in a CD/DVD. The title was about Internet and Internet Tools/Applications. We had freedom in choosing a tool or application. I chose Google Chrome, the web browser as an internet tool and included it's concept, usage and features etc.

N.B.:
Internet tools: example - web browser like Google Chrome, Internet Explorer, Mozilla Firefox etc.
Internet Applications: example - Search Engine, messenger and etc.

The movie presentation that we did has been posted below:

Reflections Finally:

This was really a good lesson for me. I had learnt a lot of new things:

1. I learnt about inserting an audio and modifying it through playback option.

2. I also learnt how to insert a video and trim it.

3. Finally i learnt how to create a video from presentation slides in MS PowerPoint 2010. It is great and more easier than any video making software.