Welcome to Macao's Blog

Current Trends in Information Technology

2011-11-22T19:46:00.000-08:00

Current Trends in Information Technology

1. E-commerce:

Models of E-commerce, Application with respect to models, BPR & E-commerce, Creation of Ecommerce

sites (ethics) commercial/ edu / org sites.

2. Information system Security:

Threats and implications, security policy, Biometric, facial and smart cards, RFID, DSA,

Firewalls:

Kinds of firewalls: packet filters, distributed firewalls

Building firewalls (only steps).

3. Knowledge management:

W hat is KM (Components and type of knowledge), knowledge building models, KM cycle and

architecture, KM tools, KM approaches- Mechanist, cultural/ be/ heuristic, systematic.

4. GIS:

W hat is GIS, Nature of geographic data, spatial objects and data models, getting map on

computers, GIS standards, and Standardization process of GIS-development, implementation, and

deployment phases.

5. BCP / BPO:

What is BPO/BCP, Why it is required, Guidelines, Merits/De-Merits, Lows of BPO -Non

disclosure agreements, SLA (Service Level Agreements), Call center – brief perspective

technology wise?

6. E- Banking:

ICIICI. Com, HDFC.com, Electronic Payments, Securities in E-banking

Services Provided

- ATM

- ECS (Electronic Clearing System) e.g. Telephone, Electricity bills (6 hrs.)

7. E- Speak:

E- learning- Models (WBT, CBT, distance learning), LMS & LCMS,

Video Conferencing, Chat, bulleting, building inline community,

Asynchronous/Synchronous Learning

E- Logistics – Maharashtra.gov.in, Logistics & Supplier Chain Management, Warehousing

Management, Transportation Management, Information & Communication Technology, How set

up layers (Extranet, Intranet, Internet), Dynamiclogistics.Com , Samsung.com

E-Governance - What is E- Governance, Models (G2B, G2C, C2G, G2G), Challenges to EGovernance,

Strategy and tactics for implementation of E- Governance.

8. IT Act 2000(14 countries included IT act ):

Cyber law - Issue of Computer Access, Hacking & cracking, Types of Computer criminals &

crimes, Software /Hardware Piracy

9. Mobile Computing:

Difference between desktop and mobile computing, Mobility, Components,

WAP Architecture, Applications & Services, Security.

10. Embedded Systems:

Features & types of embedded systems, Components of Embedded system,

Applications of Embedded system, Palm devices.

11. Data mining and data Ware housing:

Architecture, OLTP & OLAP

Steve Jobs

2011-10-05T20:11:00.000-07:00

Steve Jobs is dead. The Apple chairman and former CEO who made personal computers, smartphones, tablets, and digital animation mass-market products.

Steven P. Jobs passed away on Wednesday, October 5th, 2011 after a long struggle with pancreatic cancer.

http://gizmodo.com/

Internet

2011-09-26T21:46:00.000-07:00

The Internet ranks as a "top source of information for most" local matters of interest — from housing to jobs.

A new report finds. "The rise of search engines and specialty websites for different topics like weather, job postings, businesses and even e-government have fractured and enriched the local news and information environment,” said Lee Rainie, a co-author of the study and director of the Pew Internet & American Life Project.

more info. visit the link below
http://pewinternet.org/Reports/2011/Local-news.aspx
http://pewinternet.org/

Software Freedom Day

2011-09-20T17:47:00.000-07:00

The College of I.T. and Engineering, Notre Dame of Midsayap College participate in the celebration of Software Freedom Day, September (17) 19, 2011 at University of Southern Mindanao, Kabacan, Cotabato, Philippines.

This is the power of free and open-source software contribution. share...share...share...

2011-08-15T22:20:00.000-07:00

CITE Students use and check our project and have comments.

take you first quiz!

click on the right side E-learning Project (MRS-DJA)

thanks!

PHP

2011-08-15T21:51:00.000-07:00

Adding Records to a MySQL Database with PHP

The only thing that needs to change is your SQL statement. The steps we're going to be taking are these:

Open a connection to MySQL
Specify the database we want to open
Set up a SQL Statement that can be used to add records to the database table
Use mysql_query( ) again, but this time to add records to the table
Close the connection

We've already done steps 1 and 2 on the list. So we can move straight to Steps 3 to 5

Set up a SQL Statement to add records to the database

In our previous script, we used some SQL to grab records from our Address Book database table. We then used a While loop to print all the records out. Because we're now going to be adding records to the Address Book table, we need some different SQL. Here's the script. The new line is in blue (The double and single quotes need to be entered exactly, otherwise you'll get errors when you run the code):

$user_name = "root";
$password = "";
$database = "addressbook";
$server = "127.0.0.1";

$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

$SQL = "INSERT INTO tb_address_book (First_Name, Surname, Address) VALUES ('bill', 'gates', 'Microsoft')";

$result = mysql_query($SQL);

mysql_close($db_handle);

print "Records added to the database";
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}
?>
You met all of this code from the previous section. The only difference is the new SQL statement! What the code does is to set up some variables, open a connection to the database, and then execute the SQL query. Let's have a look at the new, and rather long, statement.

INSERT INTO … VALUES

To add records to your database, you can use the INSERT statement. There are plenty of ways to use this statement, but we'll stick with something simple: adding
new values to all of our table columns.
You start by typing the words "INSERT INTO". This can be in any case you like: upper, lower or a mix. It's easier for you to read if it's in uppercase letters.
The next thing you need is the name of a table to insert your new values into. For us, this is the table that we've called tb_address_book.
Following the name of your table, type a pair of round brackets. Inside the round brackets, you can type the names of the columns in your table:

INSERT INTO tb_address_book (First_Name, Surname, Address)

Notice how we haven't included the ID column from our table. That's because the ID column was the one we set up to be an auto-incrementing number. We don't need to worry about this column because MySQL will take care of adding 1 to this field for us.
Now that you've specified which table you want to insert values into, and specified your column names, you can add the values you want to insert.
To add values, you type the word "VALUES" after the round brackets of your column names:

INSERT INTO tb_address_book (First_Name, Surname, Address) VALUES

After the word "VALUES", you type another pair of round brackets. Inside of these brackets, you can type your values. Each value should be separated by a comma. You can use either direct text, like we've done, or variables. You can even get these values straight from your HTML form, which we'll see how to do later.
So our whole line reads:

$SQL = "INSERT INTO tb_address_book (First_Name, Surname, Address) VALUES ('bill', 'gates', 'Microsoft')";

Notice how we've surrounded all of our text with double quotes. But inside of the values round brackets, we've used single quotes.
The syntax is really this (The SQL keywords are in blue):

INSERT INTO table_name ( Columns ) VALUES ( values for columns)

But try your code out now, and see if it's all working properly. You should find that you now have two records in your database table.

Exercise
Replace the values 'bill', 'gates', and 'Microsoft' with values of your own. Run your script again to add your new record to the database. Now run your other script to read the values back out.

thanks to: http://www.homeandlearn.co.uk/php/php13p3.html

Web Programming

2011-08-01T23:03:00.000-07:00

HTML5
Tutorials

List of Projects

2011-07-13T17:13:00.000-07:00

List of Projects Titles

# Development of a feature-rich, practical online leave management system (LMS)
# Development of a practical Online Help Desk (OHD) for the facilities in the campus
# Development of an auto-summarization tool
# Development of an agent-based information push mechanism
# Development of a feature-rich, practical online on-request courses coordination system (ORS)
# Development of an online Library Management System (LiMS)
# Development of an online Sales and Inventory Management System (SIMS)
# Development of a feature-rich, Employee Transfer Application
# Development of a feature-rich, Resume Builder Application

# Development of a safe and secure Internet banking system( Java based) OR Banking System in Visual Basic( Stand Alone)
# Development of a feature-rich, practical online intranet knowledge mgmt system for the college (KMS).
# Development of a feature-rich, practical online application for the Training and Placement Dept. of the college
# Development of a Repository and Search Engine for Alumni of College (RASE)
# Development of a split screen application for the data entry of the shipments.
# Development of a Campaign Information System
# Development of an e-Post Office System
# Development of a Lost Articles and Letters Reconciliation System

# Student Project Allocation and Management with Online Testing System (SPM)
# Development of a user friendly ,feature-rich, practical Online Testing System (OTS).
# Development of a feature-rich, practical Resource Management System (RMS)
# Development of a feature rich, practical online Tickets reservation system for Cinema halls.
# Development of a feature rich, practical Time table generation system for a college.
# Development of a user friendly ,feature-rich, practical Appraisal Tracker
# Development of Effort Tracker System

Want To Learn Web Programming? Write A Blog Engine

2011-05-25T22:35:00.000-07:00

Want To Learn Web Programming? Write A Blog Engine

What is the best way learning any kind of programming? Write programs! I sincerely believe that a blog engine is one of the rare pieces which employs all the basics of Web programming but can be simple enough to understand. More importantly you can even choose to learn more than programming – about the concepts, modern technologies and architecture of the Web.
One of the problems that a novice faces is where to start from. All the aspects are so interleaved that it might be difficult to start from just one end. It can get quite frustrating to write a sample application as most of the times you lose the motivation for it down the line. Here are some reasons why even a minimal blog engine for yourself is a better candidate.

There is no strict definition for a blog engine, rather it is flexible enough for you use your set of requirements. At the minimum, it is an application which takes input from you and publishes it.
It involves one of the simplest interactions with the database. Note that the database does not imply a RDBMS, you are free to implement a file based storage for your blog engine. However it will make you think about CRUD and exceptions.
Web interaction involved is minimal and lets you focus and learn the markup basics and specifications.
A blog engine, by default, has at least two contexts – the homepage and a single blog entry. Understanding this is extremely crucial, as you can build your display based on this. Inherently this also means that a navigation system is required to read various blog entries. This can help you understand how contexts map to the navigation systems.

If you extend the definition to build the engine for others, which is a big step, you can explore various content management concepts.

Thinking about the user adding blog entries or managing them makes you design your management space.
You can make various aspects configurable, so that the user can customize.
Other users might want to classify their blog entries, and this will introduce you to categories for blog entries. Interestingly, allowing multiple categories is also a good lesson for basic RDBMS design, if you end up using it.
You can then build a way of accessing these categories in your display system. This introduces you to more contexts. Technically this also makes you think about reusing your code for building archives.

At this point you can start thinking about various readers as well. A blog can have one author, but can have readers in a wide range of environments. Focusing on the display system, you can get exposed to standards and best practices of Web design.

Creating valid markup.
Using CSS for layout and styles. Though you might not be interested in visual design, this gives you enough exposure to how CSS works with markup.
Ensuring all the readers can access the blog entries. This can be your introduction you to the concept of accessibility.
One of the most critical aspects of the current trends in Web 2.0 is interaction with the readers. Introducing a comment system so that they can comment on the blog entries and start a discussion is a milestone in Web development. This makes your application a two-way communication system.

The beauty of a blog engine is that you can use it to understand various concepts. As you continue learning, you can use your knowledge to extend the concept of your blog engine. It is one of the best applications to employ concepts of REST and URL design. You can improve your design knowledge by exploring usability and applying it in your application.
A blog engine is a basic publishing system and most of the Web activity hovers around publishing content. Not only does this let you try out various concepts, but it also lets you expand this into a full-fledged CMS.
Of course, you can also learn a lot by reading code of existing blog engines, there already some very good ones out there. However, as I always say, code represents only the solution, not the problem. Writing an application essentially involves the problem statement and requires its understanding. It involves taking decisions and your design is nothing but a combination of these decisions.
I see a blog engine at core of our Web interactions today, at least technically if not in usage. Its tolerance with its definition, freedom of design choices, programming paradigms and interaction with various users makes it the ideal learning tool. Needless to say that this will also let you build your expertise in the programming language you are using. If you find the choices too overwhelming, start by cloning an existing blog engine, I am sure you will add your originality to it.
Oh, this gives one more advantage. You can always find some good blog engines that come with their source, that is, they are open source. Is there any better way of stepping into the open source world?
Whether your blog engine gets used or not, is liked or not, is evolved or not, it will be the best learning tool you can ever build for yourself.

Thanks to http://ifacethoughts.net

PHP

2011-05-04T22:25:00.000-07:00

Creating Webpage

2011-04-26T00:47:00.000-07:00

Make a free Professional Looking Website Today!

The Easiest way to create a website

The fast, easy and free way to create websites

How to Create a Website

Create a professional website and actually enjoy building it!

Make a free website

Java Database Connectivity (JDBC)

2011-04-13T00:25:00.000-07:00

Getting Started with JDBC

All of the source code, examples, and demonstrations ???

Fisher, M. JDBC Database Access, in The Java Tutorial [online]

Thanks to David Reilly

Web Design using Free CSS Template

2011-04-11T22:09:00.000-07:00

How to Edit your Website Template
What to Edit in the Template HTML
Adding your Logo to the Template

Thanks to Iron Spider

Web Development Strategies

2011-03-27T19:03:00.000-07:00

Web Site Design / Development

HTML, CSS, JavaScript, PHP

WAMP - Apache, MySQL, PHP on Windows

Website Reference for SUMMER 2011 - IT 312 (Web Design/Development)

You can choose other websites for your additional information

Japan

2011-03-11T17:00:00.000-08:00

Take good care of our Mother Nature!

TERRIBLE....Japan hit by 8.9 magnitude quake and tsunami.. let's pray to all the OFW's and all the people in Japan.

Using ADO Data Control

2011-02-23T16:34:00.000-08:00

Using ADO Data Control

View more presentations from Macao1977.

WEB DEVELOPMENT

2011-02-17T18:45:00.000-08:00

TITLE: Web Development
COMMISSION ON HIGHER EDUCATION

COURSE DESCRIPTION:

This course provides the students with the fundamental understanding of developing web-based applications and its corresponding support systems. The course requires the use of different technologies in order to implement various web-based software applications.

COURSE OBJECTIVES (DESIRABLE OBJECTIVES)

At the end of this course, the student should be able to:

   1. know the fundamentals in web-based application architectures and processes;
   2. use Java and related technologies in developing complete web-based applications;
   3. learn how to test, verify, and debug web-based applications

COURSE OUTLINE
I. HyperText Markup Language (Reading Assignment)
II. Cascading Style Sheets
III. JavaScript
IV. Dynamic HTML
V. Servlets
VI. Java Database Connectivity
VII. Java Server Pages
VIII. Java Server Pages
IX. Java and XML
X. Web Services

REFERENCE
Web: w3schools.com

Book: JAVA,HTML Dietel and Dieltel

JUnit and TestNG

2011-02-16T22:42:00.000-08:00

JUnit Framework
TestNG Framework
JUnit 4 and TestNG Comparison

Sunday Class

2011-01-08T17:20:00.000-08:00

Click the URL below for your reference,guide,tutorial. Practice and Explore!!!
Adobe Photoshop CS2
Special Education (SPED) Computer Literacy Program

Photoshop

2010-12-03T18:28:00.000-08:00

IS 112 Students - Here's the list of the reference web address for your Photoshop CS2

1. http://www.garysimon.net/logotutorial/
2. http://ijaar.com/30-awesome-logo-design-tutorials-for-beginners/
3. http://www.ehow.com/how_4804516_design-awesome-logo.html
4. http://www.techtreak.com/web-design-tips/25-best-logo-design-tutorials-using-photoshop/
5. http://pelfusion.com/tutorials/35-logo-designing-photoshop-tutorials/

Software Engineering

2010-11-07T22:55:00.000-08:00

CSE 322 and IT 325
Reference Book: Roger S. Pressman

Simulations

2010-10-16T20:01:00.000-07:00

Monte Carlo Simulations - http://www.chem.unl.edu/zeng/joy/mclab/mcintro.html
Sample Programs - http://omlc.ogi.edu/software/mc/

Summary: This document introduces the concept of Monte Carlo methods by defining the terms and describing a simple example (the determination of pi using a Monte Carlo simulation). Following this introduction is a section on the Monte Carlo experiment, part of the physical chemistry lab at UNL, which computes the population distribution in the rotational energy levels of HCl and DCl.

Introduction to Monte Carlo Methods

The expression "Monte Carlo method" is actually very general. Monte Carlo (MC) methods are stochastic techniques--meaning they are based on the use of random numbers and probability statistics to investigate problems. You can find MC methods used in everything from economics to nuclear physics to regulating the flow of traffic. Of course the way they are applied varies widely from field to field, and there are dozens of subsets of MC even within chemistry. But, strictly speaking, to call something a "Monte Carlo" experiment, all you need to do is use random numbers to examine some problem.
The use of MC methods to model physical problems allows us to examine more complex systems than we otherwise can. Solving equations which describe the interactions between two atoms is fairly simple; solving the same equations for hundreds or thousands of atoms is impossible. With MC methods, a large system can be sampled in a number of random configurations, and that data can be used to describe the system as a whole.
"Hit and miss" integration is the simplest type of MC method to understand, and it is the type of experiment used in this lab to determine the HCl/DCl energy level population distribution. Before discussing the lab, however, we will begin with a simple geometric MC experiment which calculates the value of pi based on a "hit and miss" integration.

Monte Carlo Calculation of Pi

The first figure is simply a unit circle circumscribed by a square. We could examine this problem in terms of the full circle and square, but it's easier to examine just one quadrant of the circle, as in the figure below.
If you are a very poor dart player, it is easy to imagine throwing darts randomly at Figure 2, and it should be apparent that of the total number of darts that hit within the square, the number of darts that hit the shaded part (circle quadrant) is proportional to the area of that part. In other words,
If you remember your geometry, it's easy to show that
If each dart thrown lands somewhere inside the square, the ratio of "hits" (in the shaded area) to "throws" will be one-fourth the value of pi. If you actually do this experiment, you'll soon realize that it takes a very large number of throws to get a decent value of pi...well over 1,000. To make things easy on ourselves, we can have computers generate random* numbers.
If we say our circle's radius is 1.0, for each throw we can generate two random numbers, an x and a y coordinate, which we can then use to calculate the distance from the origin (0,0) using the Pythagorean theorem. If the distance from the origin is less than or equal to 1.0, it is within the shaded area and counts as a hit. Do this thousands (or millions) of times, and you will wind up with an estimate of the value of pi. How good it is depends on how many iterations (throws) are done, and to a lesser extent on the quality of the random number generator. Simple computer code for a single iteration, or throw, might be:

x=(random#)
 y=(random#)
 dist=sqrt(x^2 + y^2)
 if dist.from.origin (less.than.or.equal.to) 1.0 
  let hits=hits+1.0

Monte Carlo Computation of Population Distribution

The actual Monte Carlo method used in this lab to determine the population distribution among rotational energy levels is simpler than the two-dimensional example of the estimation of pi, as only one random number is generated for each "throw." This will be apparent shortly.
For this lab, the Boltzmann distribution can be solved analytically, and it is in fact used in determining the Monte Carlo distribution. As such, this is not a particularly informative simulation (you could just solve the Boltzmann equation for however many energy levels you wished and look at those numbers). However, this lab allows you to watch how changing the number of throws affects the results, and it automates the examination of the effects of temperature and isotope on population of energy levels.
The process used by the computer program for this lab is quite simple.

The input information is used to solve the Boltzmann equation for some number of energy levels. For a maximum of J=4, the relative populations might look like the figure to the right.
The rest of the simulation is easier to understand if you imagine laying the peaks in the "spectrum" side-by-side, as shown below. If we generate random numbers along that line, whenever a number falls within the range of a particular J value, it counts as a "hit" for that energy level. Obviously, for shorter lengths (J=0) the number of "hits" will be smaller than for longer lengths (J=2).
Since random number generators typically produce numbers on the range of zero to one, the population distribution is normalized so that the total "length" is equal to 1.0.
For each "throw," or random number produced, the computer determines which energy level range it belongs to, and calls it a "hit" for that J value. After the computer completes all throws, the number of hits (or relative number of hits) for each energy level are given. It is up to you to compare this output to the theoretical distribution produced by the Boltzmann equation, as described in the Lab Report Instructions.

* Computer-generated numbers aren't really random, since computers are deterministic. But, given a number to start with--generally called a random number seed--a number of mathematical operations can be performed on the seed so as to generate unrelated (pseudorandom) numbers. The output of random number generators is tested with rigorous statistical tests to ensure that the numbers are random in relation to one another. One caveat: If you use a random number seed more than once, you will get identical random numbers every time. Thus, for multiple trials, different random number seeds must be used. Commercial programs, like Mathematica, pull a random number seed from somewhere within the system--perhaps the time on the clock--so the seed is unlikely to be the same for two different experiments.

Examination Day

2010-10-11T18:44:00.000-07:00

Examination Day - October 13-16

Wednesday 10:30 - 303; 4:30 - 306
Thursday 1:30 - 304; 4:30 - RSB3
Friday 7:30 - 301; 10:30 - 207

Research Topic for Business

2010-10-06T18:47:00.000-07:00

Small Business Failure
Business Management Problem
Effective E-branding Format for Small Business Firms
Small Business Marketing Strategies
Starting A Small Business Venture

Photoshop CS2 Animation

2010-09-15T23:43:00.000-07:00

http://www.ehow.com/how_4447746_animation-photoshop-cs.html

How to Make Animation in PhotoShop CS2

Sometimes we'd like to create a simple animation for our website. You can create an animation in PhotoShop CS2, and save the file as a GIF. Follow these directions to create a simple animation of a moving arrow. Once you learn the basics, you can try something more elaborate.

Read more: How to Make Animation in PhotoShop CS2 | eHow.com http://www.ehow.com/how_4447746_animation-photoshop-cs.html#ixzz0zfjHthqJ

1Go to FILE > NEW > in the menu bar. A new menu will pop up.

2Set the width and height to 600 pixels (in the menu that opened) and set the color mode to RGB Color. Then click OK and the menu will close.

3Click to select the CUSTOM SHAPE TOOL, on the left hand side of the screen, to add an arrow shape to the image.

4Go to the pallet in the lower right hand corner, and click on the PATHS tab, so that the PATHS PALLET appears.

5Click on the small circle with the triangle arrow, in the PATHS PALLET, located to the right of the PATHS tab.

6Click on MAKE SELECTION in the new menu that opened.

7Click OK on the window that opens. That menu will close, and now the line around your arrow should be a dotted line that appears to be moving around the arrow.

8Use your PAINT BUCKET in the left menu, to add color to the arrow.

9Click SELECT > DESELECT > in the menu bar and the dotted line should disappear.

10Go to the pallet in the lower right hand corner, and click on the LAYERS tab, so that the LAYERS PALLET appears.

11Right click on the actual thumbnail image in the LAYERS Pallet, and a new menu will pop up. Click on DUPLICATE LAYER. Another menu will pop up, click OK, and it will close.

12Repeat the previous instruction. You should then have three identical layers.

13Highlight the thumbnail in the first layer.

14Use the MOVE TOOL in the left hand menu to move the arrow in your image to the far left.

15Highlight the thumbnail in the second layer.

16Use the MOVE TOOL in the left hand menu to move the arrow in your image to the center of the image.

17Highlight the thumbnail in the third layer.

18Use the MOVE TOOL in the left hand menu to move the arrow in your image to the far right. The three arrows will appear overlapped, stretched across your image, but they should all be of the same height from the bottom and top of the image.

19In the LAYER PALLET, click the eye next to the thumbnail next to Layer 2 and Layer 3. Your main image should now show just one arrow.

20In the menu bar go to WINDOW > ANIMATION > A new menu will open, showing your animation story board.

21Click on the icon that is DUPLICATES SELECTED FRAMES, which is located directly to the left of the trash can icon, in your animation story board window. A second thumbnail will appear on your story board.

22In the LAYERS PALLET, click on the eye next to LAYER 1, so it disappears. Click on the eye next to LAYER 2, so the eye will appear. (You will notice, your second thumbnail in the story board has changed, to reflect the layer with the visible eye.)

23Click on the icon that is DUPLICATES SELECTED FRAMES, which is located directly to the left of the trash can icon, in your animation story board window. A third thumbnail will appear on your story board.

24In the LAYERS PALLET, click on the eye next to LAYER 2, so it disappears. Click on the eye next to LAYER 3, so the eye will appear. (You will notice, your third thumbnail in the story board has changed, to reflect the layer with the visible eye.)

25Go to FILE > SAVE FOR WEB > A new, larger window menu will open, showing one screen of your image.

26Click on the icon at the bottom of the new menu, which looks like a globe with a question mark. A new window will open, showing what your animation looks like.

27Close menu after previewing your animation and return to the previous window with the globe-like icon.

28Click on the SAVE button in that open window, and save animation on your computer as a GIF.

Projects/Ecommerce Integration/FunctionalSpecifications

2010-09-14T00:14:00.000-07:00

Projects/Ecommerce Integration/FunctionalSpecifications

http://wiki.openbravo.com/wiki/Projects/Ecommerce_Integration/FunctionalSpecifications

Purpose

The purpose of this project is to enable companies to extend their business processes allowing customers to do real-time transactions through an on-line shopping front-end and use Openbravo ERP as a back-end.

Scope

The scope of this project is restricted to extend the current Openbravo web services to integrate Openbravo ERP with ecommerce's solutions and develop a connector for the Magento e-commerce platform as an example of this integration.

User roles & profiles

The system administrator. The person that installs Openbravo ERP, the e-commerce platform and the Openbravo ERP / e-commerce connector. Additionally, this person also setups Openbravo ERP and the e-commerce systems for their operation.

The customer. The person that connects to the on-line e-commerce front-end and browses the product catalog or places an order.

The sales manager. The person is the company that looks after the sales orders and ensures that all the sales operations work correctly.

Business process definition

Search the product catalog.
Browse the product catalog.
Making an order using an on-line front-end.
Notifying the customer that is not enough stock.
Generate an invoice for an order that has been completed.

User stories

Story 1. A customer connects to the e-commerce front-end looking for a product:

The customer starts at the e-commerce front-end main page.
The customer searches in the products catalog for a specific product.
The customer gets information about the product.
The customer decides if she wants to proceed with an order.

Story 2. A customer connects to the e-commerce front-end for browsing the products catalog:

The customer starts at the e-commerce front-end main page.
The customer browser hierarchically the products catalog.
The customer gets information about the product.
The customer decides if she wants to proceed with an order.

Story 3. A customer places successfully an order into the system:

The customer registers or logins into the system.
The customer places an order within the system.
System checks that there is enough stock.
Completes the order successfully.
Decides if she wants an invoice send by mail or shown to her.

Story 4. A customer tries to place an order into the system but the product is out of stock:

The customer registers or logins into the system.
The customer places an order within the system.
System checks that there is enough stock.
The user is informed of the shortage of stock.

Story 5. A customer tracks the status of her orders:

The customer logins into the system.
Browses her historical list of sales orders.
Selects the order for which wants more detail and its status.
Detail of the order is shown.

Functional requirements based on business processes

Customer management
It's a common scenario that a new user registers using the e-commerce front-end to be able to perform a commercial transaction later. It should be possible to:

Check if a customer already exists in Openbravo ERP.
Create new customers in Openbravo ERP.
Modify the information of a customer in Openbravo ERP.

Product catalog
A product catalog contains all the products that a user can view.
General considerations:

Openbravo ERP supports multiple languages for the product name.
All the information about the products in the catalog is stored in Openbravo ERP.

It should be possible for a user to perform the following actions:

Browse the product catalog hierarchically sorted by alphabetically by product name.
Browse the product catalog hierarchically by product category.
Search the product catalog.
Get all the details of a product.

Every product object can contain at least the following details:

Product name.
Product description.
Product category.
Product attributes (weight, color, size, etc).
Product price and tax.

It should be possible for users to query product's inventory availability. This can be displayed when the user is viewing the product information.
Sales order
It should be possible for a user to:

Perform a full sales order.
Modify or cancel an order once it has been created in the system.
Get a list of the products that has bought.
Track the status of his orders pending to be send.

Invoicing
It should be possible for the e-commerce system:

Get access to the full invoice object to render an invoice by itself.
Get a PDF version of an invoice using the default server report.

User Interface Mockups

Technical Requirements

Web services allows applications to be integrated more rapidly and easily. Integration focuses on the XML messages that define the services rather than the protocol used to relay these messages. These characteristics are ideal for connecting business functions across heterogeneous systems.
The integration requirements are:

The e-commerce system makes calls to the Openbravo ERP web service whenever it requires a synchronization.
The definition of these web services should not change from version to version to guarantee the integration with different Openbravo ERP versions.

Non-Functional Requirements

These are general requirements that impact in the technical decisions:

The final system should scale correctly to support high traffic loads.
Security is key since we are performing commercial translations and dealing with confidential data.
It is important that all process within Openbravo ERP are automatic (e.g.: see blocking issue 4322)

Open Discussion Items

Which e-commerce platform is better to do the example integration?

Teaching Strategies

2010-09-04T21:53:00.000-07:00

Seminar Workshop in Teaching Strategies and Preparation of Materials
September 03, 2010

Learning Styles: I am:
1. Pragmatic - like to try new ideas
2. Reflectors - observe and think
3. Theorists - sysmatic
4. Activist - result oriented
-----------------------------------------------------
Tell me and i'll forget
Show me and i may remember
Involve me and i'll understand
-----------------------------------------------------
He who knows not and knows not he knows not, he is a FOOL, shun him
He who knows not and knows, he knows not he is SIMPLE... teach him
He who knows and knows not he knows he is ASLEEP... wake him
He who knows and knows he knows, he is WISE... follow him
----------------------------------------------------

JavaScript Example

2010-08-16T01:15:00.000-07:00

To find the greatest common factor?

2010-07-26T01:52:00.000-07:00

How do you write a program in Java to find the greatest common factor?

import java.util.Scanner;

public class Gcd
{

public static void main(String args[])
{
int temp=0,i;

Scanner s=new Scanner(System.in);

System.out.println("enter 2 numbers");

int a=s.nextInt();

int b=s.nextInt();

for(i=2;i<=a;i++)
{
if(a%i==0)
{
if(b%i==0)

temp=i;

}//end of if

}//end of for

System.out.println("Gcd is:");

System.out.println(temp);

}//end of main

}//end of class

Java

2010-07-26T01:50:00.000-07:00

What is a Java program that finds the greatest common factor of two integers?

If you're interested only in solving the problem, and not in performance, then the simplest way is to simply start by trying to divide one number by the other. If they divide evenly, then that number is the GCF, else subtract it by one and keep trying.

public static int GCF(int a, int b) {

// current will start off as the lesser of the two numbers.
// after each attempt to find a common factor, decrement current
int current = Math.min(a,b);

// loop until current is 1. if this happens, all other possibilities have been
// eliminated and thus a and b share no common factors other than 1
while( current > 1) {

// check factors
if( (a%current) == 0 ) {// check if current is a factor of a
if( (b%current) == 0) { // check if current is a factor of b
// if current is a factor of both a and b, then current
// is the GCF and we can break out of the loop
break;
}
}

--current;
}

return current;

}

// or for a slightly more concise version...
public static int GCF(int a, int b) {

for(int current = Math.min(a,b); current > 1; --current) {

if( (a%current)==0 && (b%current==0) ) {

return current;

}

}

return 1;

}

Again, both of these algorithms perform in O(n) time, which can be quite terrible for large numbers and/or slow machines.

Introduction to Database

2010-07-26T01:29:00.000-07:00

INTRODUCTION TO DATABASE with MS Access 2003

Databases are used every day, sometimes without us realizing. They are everywhere. The most basic example is a telephone book or a library card index. They can store all sorts of information, from phone numbers to map grids and references, score cards from sports games, report cards, etc. They allow quick searching and are great for keeping historical data, for example weather history. Most websites run using a combination of a database and a CMS (content management system).

At the most basic level, databases contain tables. Database tables are used to hold information, for example you may have a database table about ‘authors’ or ‘news’.
Inside a table, you have fields. Table fields tells us what information is being kept in the database. In an authors table, for example, you may keep the person’s name and email address.
Microsoft Access is a computer application used to create and work with databases. that means it’s a Database Management System or DBMS.

A Microsoft Access database is a single file with the file extension *.mdb and is often referred to as a database application.

A database is basically a collection of data or pieces of information. Whether you know it or not, you use databases all of the time. Some examples of commonly used databases might be:
• Address book
• Library catalogue
• Telephone directory
• Stock list

A database isn’t necessarily contained on a computer. A telephone directory is still a database even if it’s in the form of a huge book sitting next to your phone.

Databases are intended for storing and maintaining large amounts of information. The following are examples of the sort of information that can be kept in a database:

• Inventory control
• Payroll systems
• Personnel records
• Music collection catalogue
• Phone and address lists

Database is a collection of related information or data.

DATA VS. INFORMATION

Data – a collection of facts made up of text, numbers and dates:
        Murray       35000       7/18/86
Information - the meaning given to data in the way it is interpreted:
        Mr. Murray is a sales person whose annual salary is $35,000 and whose hire date is July 18, 1986.

•    Data are facts about people, places, things or events. – unprocessed facts
•    Information is a processed data.

BASIC DATABASE CONCEPTS

Table - A set of related records (a set of one or more records)
Record - A collection of data about an individual item
Field - A single item of data common to all records

ACCESS 2003 STRUCTURE
What is Microsoft Access?
•    Powerful Relational Database Management System (RDBMS) design to run in Microsoft Windows. Data can be organized as a set of related tables
•    Integration with other Office applications allows seamless exchange of data with centralized database
What is an Access Database?
•    Collection of data objects stored with filename extension .mdb (Microsoft database)
•    Main Access data objects ( Tables, Queries, Forms, Reports, Macros, Modules, Pages)

DATABASE WINDOW
•    Main database design/management window
•    Displayed when creating or opening an Access database
•    You can use the Objects toolbar to access the different objects that make up a database

TABLES
What is table
•    Basic container for data, arranged as a grid of rows and columns
•    Each row contains a single record
•    Each column represents a field within the record
Access tables
•    Fundamental data objects in Access
–    Forms, queries and reports are all based on tables
•    Table Wizard provides automated table creation
•    Tables can also be created manually for more precise specification
FORMS
What is form
•    Electronic version of paper form
•    Used to simplify entry of data into an Access database

QUERIES
What is a Query?
•    A question asked of the database
•    Used to extract specific information from database
•    Used to extract specific information from database
–    Example:What is the three top-selling products in our company’s product line?
•    Queries are composed of structured query language(SQL) statements
–    Example:
                SELECT Products.[Product #], Products.[Product Name], Products.Price    FROM Products
                WHERE (((Products.Price)<4.75));
•    Access allows queries to be created graphically
•    Hides complexity of SQL language

REPORT
What is report?
–    Formatted template used to print reports of database or query results
–    Allows user to specify fields, grouping levels, arrangement of printed data
MACROS
What is access macro?
–    User-defined sequence of actions to be performed by Access 2000
–    Macros will not be covered
MODULES
What is a module?
–    User-created sections of code which provide sophisticated automation of Access functions
–    Written in Visual Basic for Application(VBA)

CREATING A NEW TABLE IN DESIGN VIEW
For each field in new DATABASE, specify the following items
–    FIELD NAME
•    Descriptive name of field to be used in table
–    64-character maximum
–    Prohibited characters:period(.), accent grave(‘), square brackets([]), exclamation point(!)
–    DATA TYPE
•    Drop-down list displays available data types
–    Number, Date/Time, Currency,Auto number, Yes/No, OLE Object, Hyperlink, Lookup Wizard
–    DESCRIPTION
•    Comment describing details of field. Appears on the status bar in Datasheet view when you click a row in the field's column

SETTING A PRIMARY KEY
What is a primary key?
–    Main index for table
–    Must be unique for each record in table
•    Example: Product number, Employee number, etc.
–    If no such field exist, create a new field with the data type “Autonumber” and specify it as the primary key
•    Access will automatically create unique numbers for this field
Assigning a field as the primary key
–    Select field
–    Click on Primary Key button on toolbar (or use “Edit /Primary Key”)
•    A key symbol will appear next to selected field

Seminar

2010-07-22T22:23:00.001-07:00

Seminar Workshop in Research Capability Enhancement for BSCS Students
Little Theater, Notre Dame of Midsayap College
July 31, 2010

Introduction to Computer

2010-07-19T22:39:00.000-07:00

IS/CSE/IT 111 Introduction to Computer

What is Computer?
Computer is a device that performs mathematical and logical operations based on the database with a minimal human interpretation.
It is a device that accepts data, processes and store these, and produces a result/output.

Four Basic Functions
1.Input
2.Process
3.Storage
4.Output

Typically, a computer system consists:
1.Input Devices – which allows the users to input data for processing
2.Storage Devices – where the processed information are stored
3.Central Processing Unit – which interprets and executes data or instruction
4.Output Devices – where outcomes are displayed

Three Main Elements of Computer System
1.HARDWARE – refers to the physical components of a computer that you can actually touch, such as keyboard, monitor, central processing unit, mouse and printer.
HARDWARE may be classified into:

1. Input Devices – these are external devices that provide information and instruction to the computer.
Common Example: Keyboard,Touch tone device, mouse, joystick, touch screen, light pen, scanning device, Fax Machine, phone card, digital cameras, sensor
2. Output Devices – these are devices that will communicate the result of processing back to the user by converting electrical signals from the Arithmetic/Logic Unit. Output devices that will produce result/output.
Common Example: monitors, Printer, Plotter, speakers
3. Central Processing Unit (CPU) – performs arithmetic and logical operations on data taken from the primary storage or on information entered through any input devices.

Five basic component of CPU:
1. Main Storage – also called memory/primary storage where instructions and data are stored while processing is done.
Two types of memory inside the main storage:
Random Access Memory (RAM) uses to store given instructions which can later be changed or erased. When data are loaded from the RAM it means WRITING data, when data are accessed it means READING data.
All information stored in it are lost or erased when the computer power is turned off or interrupted. This kind of memory is volatile.
Read Only Memory (ROM) contains stored instructions that a computer requires to be able to do its basic routine operations. The instructions still hold even when there is power interruption or shut-off. This kind of memory are non-volatile. It has a data built in by the manufacturer.
2. REGISTERS – part of the CPU that function as fast-accessed temporary memory locations. The bits of information taken from the main memory and those that will be placed in the main memory are temporarily held in the registers while computation are being performed.
3. BUSES – are bundles of tiny wires that serve as the communication path between components of the CPU. The Three most important buses are the Address, Data and Control Buses.
4. Arithmetic Logic Unit (ALU) – performs all the arithmetic and logical calculations of the CPU.
5. CONTROL UNIT (CU) – is responsible for directing the flow of instructions and data within the CPU. It fetches the instructions from the main memory for execution in the CPU. Aside from controlling the input and output devices, it also passes data to the ALU for computation.
4. SECONDARY STORAGE – where data are stored permanently.
Common example hard disk, optical disk (compact disk read only memory (CD), digital versatile disk (DVD)

Two Classes of Secondary Storage:
1. Direct Access Media – (floppy disk, flash memory(usb)) supports sequential of random access where data can be accessed directly)
2. Sequential Access Media – where data are accessed in a specific order. (magnetic tape – traditional medium for long term storage but slowest in terms of retrieval of data)

2.SOFTWARE – is untouchable. It is a set of instructions used to direct the hardware on how to turn data into useful information for people to use.
A set of instructions or program that tells the computer how to do a specific task.

Two types of Software:

1.SYSTEM SOFTWARE – refers to computer programs of library files whose purpose is to help run the computer system.
Example – Operating System (manage the whole operation of the computer), output devices (provides interface to the hardware) Utility Programs (who manage files), Compilers and interpreters (programs that will translate high-level language programs into object code)

2.APPLICATION SOFTWARE – performs specific functions, which make daily activities easier and facilitate the performance of work efficiently and effectively.

Categories of Application Software:

1.Productivity Tools – eg. Software like Word Processing, Spreadsheet, Database, Presentation Graphics, Personal Information Manager Software and Project Management.
2.Graphics and Multimedia –eg. Software like Computer-Aided Design, Desktop Publishing, Web Page Design, Image Editing, Video/Audio Editing, Multimedia Authoring
3.Home, Personal and Educational Use – eg. Software like Integrated software, Personal Finance software, Clip Art/Image Gallery, Legal Software, Educational Software, Entertainment Software.
4.Communications – eg. Software like E-mail Software, Web Browser, Chat client Software, Newsreader Software, Instant Messenger software, Groupware software, Videoconference software.

Three basic types of application software:
1.COMMERCIAL – comes prepackage and is available from software vendors. It must be purchased.
2.SHAREWARE – are software develop a d released as demonstration versions of their commercial product. Each demonstration copy has an expiration date which gives the user ample time to evaluate and decide whether the purchase the product or not.
3.OPEN SOURCE – software that is created by generous programmers and released to the public domain for free and for public use.

3.PEOPLEWARE – who use the computer system, they are the most important factor in a computer system because they manipulate and program the computer system to make it useful.
- The skilled workers in the Information Technology field.
The major compositions of IT Professionals:
1.Management Group – eg. Computer System Manager
2.Systems and Procedures Group – Computer Scientist, Computer Engineer, System Analyst
3.Programming Group – Computer Programmer
4.Computer Operations Group - Computer Operator, Data Encoder, Data Entry Operator, Computer Librarian

CAPABILITIES OF COMPUTER
1.Computer can do repetitive and routine work.
2.Computer can process large amount of data.
3.Computers are reliable and accurate.
4.Computer can store and retrieve large amount of information.
5.Computers have a self-checking ability.
6.Computer can be self-operating.
7.Computers can do remote processing.

LIMITATIONS OF COMPUTER
1.Computers are dependent on instruction and data.
2.Computers cannot generate information.
3.Computers cannot correct wrong instructions.
4.Computers cannot decide specific task. (except if they are programmed)
5.Computers are vulnerable to a virus attack.

Assignment: Note Book (Reference: Introduction to Information Technology by Albano-Atole and other computer books or use Internet)
1.Classifications Computers
2.History of Computing (from 2000 B.C. to present)

Introduction to Computer & Productivity Tools

2010-06-21T16:57:00.000-07:00

click the link below for your reference, other reference will follow.

CSE 111 - Introduction to Computer
CSE 112 - Productivity Tools
Steve's PC Tutorials

Productivity Tools

2010-06-08T22:51:00.000-07:00

100 Terrific Productivity Tools for the Bored or Unemployed CLICK the LINK!!!
From http://www.onlinecollege.org

The College Student's Productivity Guide - 27 Apps, Tools, and Resources CLICK the LINK!!!
From http://oedb.org

100 Free Productivity Tools to Get You Through School

http://www.onlineuniversities.com

Create MONEY here!!!

2010-06-08T22:29:00.000-07:00

Create MONEY here!!! click to REGISTER

Sign Up Notre Damean

2010-06-08T18:36:00.000-07:00

Notre Dame of Midsayap College Connecting Students, Alumni, Teachers, and Friends

Sign Up with the link above The First Notre Dame in Asia - Notre Dame of Midsayap College

Computerized Election 2010

2010-05-11T17:07:00.000-07:00

Thanks!!! PPCRV Volunteers!!! Midsayap, Cotabato 94 clusters... kahit pagod basta para sa Bayan!!! all worth it!

What's on your mind?

2010-04-29T23:45:00.000-07:00

Student's Summer Homepage

2010-04-29T18:48:00.000-07:00

Montemayor, Christian King V.
Masukat, Samid R.
Almazan, Philip G.
Balacano, Joylyn M.
Alcoran, John Michael S.
Fabia, Romelyn S.
Mana-ay, Charmagne Jane M.
Selibio, Arian P.
Casile, Joje L.
Cagang, James Roi V.
Fuerte, Jethro A.
Ariego, Honeylette G.
Cataluña, Clifferd B.
Omalde, Noelle Fenella A.
Alpas, Melanie P.
Daquiado, Jenelyn O.
Arradaza, Fluerdeliz V.
Pahil, David Garth T.
Millena, Quennie Jane P.
Labiao, Mary Cristine N.

Web Devt.

2010-04-28T17:48:00.000-07:00

EmailForm

ChatRoom

EarnMoney

EmailForms&WebContactForms

Vote Wisely!!!

2010-04-15T22:35:00.000-07:00

Vote Wisely!!! (even you dont know who's the BEST!)

During a campaign the air is full of speeches - and vice versa. ~Author Unknown

System Analysis and Design (CSE 314/IT 315)

2010-02-21T18:57:00.000-08:00

INTRODUCTION TO SYSTEM ANALYSIS AND DESIGN http://www.nos.org/htm/sad1.htm

INTRODUCTION
Systems are created to solve problems. One can think of the systems approach as an organized way of dealing with a problem. In this dynamic world, The subject System Analysis and Design (SAD), mainly deals with the software development activities.

OBJECTIVES

After going through this lesson, you should be able to:
understand a system
understand the different phases of system developments life cycle
know the components of system analysis
know the components of system designing

DEFINING A SYSTEM
A collection of components that work together to realize some objective forms a system. Basically there are three major components in every system, namely input, processing and output.

In a system the different components are connected with each other and they are interdependent. For example, human body represents a complete natural system. We are also bound by many national systems such as political system, economic system, educational system and so forth. The objective of the system demand that some output is produced as a result of processing the suitable inputs.
29.4 SYSTEM LIFE CYCLE
System life cycle is an organisational process of developing and maintaining systems. It helps in establishing a system project plan, because it gives overall list of processes and sub-processes required for developing a system.
System development life cycle means combination of various activities. In other words we can say that various activities put together are referred as system development life cycle. In the System Analysis and Design terminology, the system development life cycle means software development life cycle.
Following are the different phases of software development cycle:

System study
Feasibility study
System analysis
System design
Coding
Testing
Implementation
Maintenance

PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE

(a) System Study
System study is the first stage of system development life cycle. This gives a clear picture of what actually the physical system is? In practice, the system study is done in two phases. In the first phase, the preliminary survey of the system is done which helps in identifying the scope of the system. The second phase of the system study is more detailed and in-depth study in which the identification of user’s requirement and the limitations and problems of the present system are studied. After completing the system study, a system proposal is prepared by the System Analyst (who studies the system) and placed before the user. The proposed system contains the findings of the present system and recommendations to overcome the limitations and problems of the present system in the light of the user’s requirements.
To describe the system study phase more analytically, we would say that system study phase passes through the following steps:

problem identification and project initiation
background analysis
inference or findings

(b) Feasibility Study
On the basis of result of the system study, feasibility study takes place. The feasibility study is basically the test of the proposed system in the light of its workability, meeting user’s requirements, effective use of resources and .of course, the cost effectiveness. The main goal of feasibility study is not to solve the problem but to achieve the scope. In the process of feasibility study, the cost and benefits are estimated with greater accuracy.

(c) System Analysis
Assuming that a new system is to be developed, the next phase is system analysis. Analysis involved a detailed study of the current system, leading to specifications of a new system. Analysis is a detailed study of various operations performed by a system and their relationships within and outside the system. During analysis, data are collected on the available files, decision points and transactions handled by the present system. Interviews, on-site observation and questionnaire are the tools used for system analysis. Using the following steps it becomes easy to draw the exact boundary of the new system under consideration:

Keeping in view the problems and new requirements
Workout the pros and cons including new areas of the system

All procedures, requirements must be analysed and documented in the form of detailed data flow diagrams (DFDs), data dictionary, logical data structures and miniature specifications. System Analysis also includes sub-dividing of complex process involving the entire system, identification of data store and manual processes.

The main points to be discussed in system analysis are:

Specification of what the new system is to accomplish based on the user requirements.
Functional hierarchy showing the functions to be performed by the new system and their relationship with each other.

Function network, which are similar to function hierarchy but they highlight the functions which are common to more than one procedure.
List of attributes of the entities - these are the data items which need to be held about each entity (record)

(d) System Design
Based on the user requirements and the detailed analysis of a new system, the new system must be designed. This is the phase of system designing. It is the most crucial phase in the development of a system. Normally, the design proceeds in two stages:

Preliminary or general design
Structure or detailed design

Preliminary or general design: In the preliminary or general design, the features of the new system are specified. The costs of implementing these features and the benefits to be derived are estimated. If the project is still considered to be feasible, we move to the detailed design stage.
Structure or Detailed design : In the detailed design stage, computer oriented work begins in earnest. At this stage, the design of the system becomes more structured. Structure design is a blue print of a computer system solution to a given problem having the same components and inter-relationship among the same components as the original problem. Input, output and processing specifications are drawn up in detail. In the design stage, the programming language and the platform in which the new system will run are also decided.

There are several tools and techniques used for designing. These tools and techniques are:

Flowchart
Data flow diagram (DFDs)
Data dictionary
Structured English
Decision table
Decision tree

Each of the above tools for designing will be discussed in detailed in the next lesson.

(e) Coding
After designing the new system, the whole system is required to be converted into computer understanding language. Coding the new system into computer programming language does this. It is an important stage where the defined procedures are transformed into control specifications by the help of a computer language. This is also called the programming phase in which the programmer converts the program specifications into computer instructions, which we refer as programs. The programs coordinate the data movements and control the entire process in a system.
It is generally felt that the programs must be modular in nature. This helps in fast development, maintenance and future change, if required.

(f) Testing
Before actually implementing the new system into operations, a test run of the system is done removing all the bugs, if any. It is an important phase of a successful system. After codifying the whole programs of the system, a test plan should be developed and run on a given set of test data. The output of the test run should match the expected results.
Using the test data following test run are carried out:

Unit test
System test

Unit test : When the programs have been coded and compiled and brought to working conditions, they must be individually tested with the prepared test data. Any undesirable happening must be noted and debugged (error corrections).
System Test : After carrying out the unit test for each of the programs of the system and when errors are removed, then system test is done. At this stage the test is done on actual data. The complete system is executed on the actual data. At each stage of the execution, the results or output of the system is analysed. During the result analysis, it may be found that the outputs are not matching the expected out of the system. In such case, the errors in the particular programs are identified and are fixed and further tested for the expected output.

When it is ensured that the system is running error-free, the users are called with their own actual data so that the system could be shown running as per their requirements.

(g) Implementation
After having the user acceptance of the new system developed, the implementation phase begins. Implementation is the stage of a project during which theory is turned into practice. During this phase, all the programs of the system are loaded onto the user’s computer. After loading the system, training of the user starts. Main topics of such type of training are:

How to execute the package
How to enter the data
How to process the data (processing details)
How to take out the reports

After the users are trained about the computerised system, manual working has to shift from manual to computerised working. The following two strategies are followed for running the system:

(i) Parallel run : In such run for a certain defined period, both the systems, i.e., computerised and manual, are executed in parallel. This strategy is helpful because of the following:

Manual results can be compared with the results of the computerised system.
Failure of the computerised system at the early stage does not affect the working of the organisation, because the manual system continues to work, as it used to do.

(ii) Pilot run : In this type of run, the new system is installed in parts. Some parts of the new system are installed first and executed successfully for considerable time period. When the results are found satisfactory then only other parts are implemented. This strategy builds the confidence and the errors are traced easily.

(h) Maintenance
Maintenance is necessary to eliminate errors in the system during its working life and to tune the system to any variations in its working environment. It has been seen that there are always some errors found in the system that must be noted and corrected. It also means the review of the system from time to time. The review of the system is done for:

knowing the full capabilities of the system
knowing the required changes or the additional requirements
studying the performance

If a major change to a system is needed, a new project may have to be set up to carry out the change. The new project will then proceed through all the above life cycle phases.

Seminar

2010-01-14T17:59:00.000-08:00

Phillippine Society of Information Technology Educators Foundation, Inc.
Region XII Chapter
IT Reseach and Digital Image Analysis Seminar
January 14-16, 2010, Notre Dame of Kidapawan College

Vladimir Y. Mariano, Ph. D.
Institute of Computer Science
University of the Philippines
Los Baños
Email: vymariano@uplb.edu.ph

Research Areas: Digital Image Processing, Computer Vision, Pattern Recognition

CSE 122 / IT 122 Study and Debug the vb game program (MIDTERM)

2010-01-08T16:49:00.001-08:00

These are the objects: 2 shapes(circle and rectangle), 1 timer(interval=500), 1 label (caption=Score:), 1 command button (caption=&Reset)

Note: Use a prefixes in naming of each objects/controls.
controls that has a code: form_load, form_mousemove,timer,command button

Dim v As Integer, Y As Integer, score As Integer

Private Sub Form_Load()
ball.Left = 2500
ball.Top = 1300
X = -50
Y = -50
End Sub

Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
pad.Left = X - pad.Width / 2
End Sub

Private Sub reset_Click()
ball.Left = 2500
ball.Top = 1300
X = -50
Y = -50
reset..Visible = False
score = 0 ' reset the score
scorecard.Caption = "score:" & score ' show the score on our label
Me.Caption = "score:" & score
Timer1.Enabled = True ' start the timer again to get the ball moving
End Sub

Private Sub Time1_Timer()

ball.Move ball.Left + X, ball.Top + Y

If balll.Top <= 0 Then Y = Y * -1 End If If ball.Left <= 0 Then X = X * -1 End If If ball.Left + ball.Width >= Me.ScaleWidth Then
X = X * -1
End If

If ball.Top + ball.Height >= pad.Top Then
If (ball.Left + ball.Width < pad.Left) Or (ball.Left > pad.Left + pad.Width) Then
'if the ball is to the left or right of the pad then
Me.Caption = "game over" ' set the forms captions to read game over
reset.Visible = True 'make the reset button visible
Timer.Enabled = False ' pause the program

Else
Y = Y * -1.05 'speed up the ball
X = X * 1.05 '
score = score + 1 'add 1 more hit to the score
scorecard.Caption = "score:" & score 'show the score on our label
Me.Caption = "score:" & score ' show the score as our forms caption
If (ball.Left + ball.Width / 2) < (pad.Left + pad.Width / 2) Then 'if the ball is to the left or the pad center then If X > 0 Then ' if it is going to the right
X = X * -1 'make it go left
End If
Else ' the ball must be on the right of the pad
If X < 0 Then 'if it is going left
X = X * -1 'make it go right
End If
End If
End If
End If
endif
End Sub

Design View

Output View

PowerPoint Exercise for SPED

2010-01-06T23:51:00.000-08:00

Soft Eng

2009-12-15T22:54:00.000-08:00

GAMES using c++ and vb6
click the url http://www.cplusplus.happycodings.com/

2009-11-28T16:48:00.000-08:00

~~Maguindanao Massacre~~

PSITS

2009-10-14T17:33:00.000-07:00

Reminder!!!

NDMC PSITS Officers please plan the initial program for our seminar and workshop this coming november.

Our first target will be the CS/IT/IS First year students so that we can build foundation as they go through in programming.

We are going to use the PHYTON software as out basic software tool for beginners.

visit the url below as your reference, this is very simple and easy to understand for beginners.

http://www.sthurlow.com/python/

How to write your paper

2009-10-04T19:19:00.000-07:00

How To Write Your Paper

Your thesis paper documents your work and can serve as a basis for a publishable paper. The most common mistake made by thesis students is to assume that the thesis itself will be easy to write. Consequently, they postpone writing until they have completed their programming. By the time they produce an acceptable copy, they find that a term or two of school has slipped by and they still have not graduated. Important advice is to start writing early and ask your thesis advisor for feedback on your writing. Equally important, do not plagiarize. Plagiarism can result in expulsion from school. You are expected to write your own paper, not copy from what someone else has written. It is okay to use other people's ideas, even their own words, but you must clearly reference their work. Your paper should describe what you did and why you did it.
Everyone makes spelling mistakes, but with spelling checker programs available this type of error should be eliminated. Always run your written work through a spelling checker before you ask someone else to read it. Also, you should find someone who can correct grammatical mistakes in your paper. If necessary, hire someone from the English Department or Language Institute to correct your work before you give it to your advisor.

NOTE:

How to write your paper.
: Do not plagiarize!
: Write a proposal that includes a statement of the problem under study, the software requirements, an indication of how the problem will be solved, and a survey of related literature.
: Use a spelling checker.
: Have someone proofread your paper for grammatical errors.; Write a requirements document that states the requirements your program must meet.
How to write your program.
: Write specification, preliminary design, and detailed design documents that precisely define what the requirements are and how your program will meet the requirements.
: Write the comments first.
: Build a scaffold, which can be removed, that supports the construction of your program.
: Write a user's guide, maintenance manual, and test suite.
: Use a program document formatter such as WEB.

view this link

Creating VB database applications using ADO control

2009-09-30T22:18:00.000-07:00

In this sample, you will create a ADO database application to manage your home library. First of all, create a database in MS Access and name home_Library. In this database, create a table with the following field names;

Title:
Author:
Publisher:
Year:
Category:
and save the table as booktitle.mdb

Design the Interface as follow:

Key in the codes as follows:

Private Sub cmdCancel_Click()
txtTitle.Text = ""
txtAuthor.Text = ""
txtPublisher.Text = ""
txtYear.Text = ""
txtCategory.Text = ""
End Sub

Private Sub cmdDelete_Click()
Confirm = MsgBox("Are you sure you want to delete this record?", vbYesNo, "Deletion Confirmation")
If Confirm = vbYes Then
adoLibrary.Recordset.Delete
MsgBox "Record Deleted!", , "Message"
Else
MsgBox "Record Not Deleted!", , "Message"
End If
End Sub

Private Sub cmdExit_Click()
End
End Sub

Private Sub cmdNew_Click()
adoLibrary.Recordset.AddNew
End Sub

Private Sub cmdNext_Click()
If Not adoLibrary.Recordset.EOF Then
adoLibrary.Recordset.MoveNext
If adoLibrary.Recordset.EOF Then
adoLibrary.Recordset.MovePrevious
End If
End If
End Sub

Private Sub cmdPrevious_Click()
If Not adoLibrary.Recordset.BOF Then
adoLibrary.Recordset.MovePrevious
If adoLibrary.Recordset.BOF Then
adoLibrary.Recordset.MoveNext
End If
End If
End Sub

Private Sub cmdSave_Click()
adoLibrary.Recordset.Fields("Title") = txtTitle.Text
adoLibrary.Recordset.Fields("Author") = txtAuthor.Text
adoLibrary.Recordset.Update
End Sub

Using Crystal Reports in VB

2009-09-30T19:34:00.000-07:00

The crystal report writer is an add-in program that comes with visual basic. You use the Crystal Report Writer to create custom reports, lists, labels and form letters using datga from an existing database. However, most of the time- the Crystal Report Writer is used to create reports.

The crystal report writer can be used with the following programs:

Microsoft Access
dBase
Paradox
FoxPro
Clipper
Btrieve
SQL Server (via ODBC)

To access the crystal report writer (in visual basic 6.0) click on Add-Ins --> Report Designer. This will take you into Crystal Reports.

CREATING A REPORT:

To create a report, open crystal report writer...

click on File --> New (a Create New dialog will appear).
click on the Standard icon (the Create Report Expert dialog box appears).
click on Datafile (the Choose Database File dialog box appears).

To the left you will see a list of files. To the right is the path showing the folder tree, indicating where the file will be stored.

Click on the file you want to open
Click on Add
Click on Done (the Choose Database File dialog box disappears).

SELECTING FIELDS:

Click on 2: FIELD in the create report expert dialog box. This is where you select the fields that you want to appear in your report. You can select the fields individually by clicking on them and then clicking on ADD, or you can click on ALL, which will select all fields. When a field has been selected, it will be displayed in the REPORT FIELDS window.
You can change column headings as well by clicking and highlighting a field in the Report Fields window, and moving down and typing a new heading for that field. Default headings will appear for each field.

SORTING FIELDS:

Click on 3: SORT tab in the Create Report Expert dialog box. Now select the field you want to have the records sorted by (the selected field will be used to sort all of the records in order by the field selected when the report is produced). You can also set the order to have the table sort in descending order by clicking on the array. Ascending order is the default.

TOTALS AND SUBTOTALS:

Your report has the ability to calculate totals for numeric fields. You can add additional fields by clicking the field and then click the add button. And to delete fields, click on the remove button.
Click on 4: TOTAL tab in the Create Report Expert dialog box. Select field by clicking on it to highlight it. This will create subtotals for that field, and will create section breaks in your report for each record and display a total for the selected field. Now click on the Add button, and this will add the field on the right hand side.
Note: if the check box in the lower right-hand corner is checked, you will get grand totals for your report.

FONTS AND FONT SIZE:

If you would like to adjust the font and font size of your report, first select the field you want to change by clicking on it. And if you want to change more than one, hold the CONTROL key and select the fields you want to change. Now click the arrow to the right of the font window, a drop down menu will appear. Select the font you want by clicking on it to highlight it. And click the arrow to the right of the font size, a drop down menu will appear- and select the font size you want by highlighting it.

SPEEDING UP PROCESSING:

This section is used often if you have large files and want conditions set on the key field or other fields in the file where only certain records will be selected for printing. Setting some keys in this section will speed up processing of records for your report since several records will be skipped.
Click on 5: SELECT tab in the Create Report Expert dialog box. Next, click on SPEED TIP button. This will discuss how records will be selected and how reports will be sped up, if not all records will be used for processing. Now click on OK when finnished reading. Click ADD to add the highlighted field to the Select Fields list box.
The highlight button appears next to the key field in the Report Fields list box. This is because the table contains an index for this field. The key field is often used for filtering out records.
At the bottom of the window, there are two other list boxes, one containing the word "is" and the other containing the words "any value". These two list boxes are used to set conditions to filter out records when producing your report.

DETERMINING THE STYLE:

Click on 6: STYLE tab in the Create Report Expert dialog box. On the left will be a list of styles that you can choose your report to appear in. Click on the one you want. Enter a title for your report by typing it in where it says TITLE at the tob of the Select Fields List Box.

PREVIEWING YOUR REPORT:

To preview the 'final product' simply click PREVIEW REPORT. This will take you to your preview screen showing teh actual report that you have created. There are two modes you can look at in preview report, DESIGN mode and PREVIEW mode.

DESIGN SECTION:

The design section shows the layout of each field in the report, along with titles, headings and totals. You can change the position of a field, making it longer or shorter by clicking on it. You can also change the font and font size of that field.
The design tab contains six sections, as described below...

Title -- Contains information you want to display on the first page only.
Page Header -- Specifies information such as the report title, field headings, and the date.
Details -- Contains the body of the report, database records and subtotals (if you include them).
Grand Total -- Shows the grand totals of all numeric fields talked about in "Totals and Subtotals" above. This section will only appear if you included a grand total in your report.
Page Footer -- Contains page number and any other information you want to appear at the bottom of the page.
Summary -- Contains information you want to appear on the last page only.

How to Make a Perfect Thesis Proposal

2009-09-28T19:55:00.000-07:00

Thesis proposal is a paper that aims to provide your suggestions on research you intend to conduct. To write a good thesis proposal, you should think over every issue very carefully and state your thoughts about it on paper.

Making good and qualitative thesis proposals requires being aware of what steps to take. That is why we are eager to present you these steps:

* Choose the problem under consideration. It can be any problem, hypothesis or research question that has never been considered before. Formulate the topic of your thesis proposal;
* Think why your research will be important. Mind that your thesis proposal is a kind of admission to conducting your research. If you do not manage to convince your supervisor in its significance, you may be not allowed to investigate the topic of your thesis proposal chosen;

* Get to know about the prior research of your topic. Perhaps, anyone has touched upon your problem, but it was not covered fully. Tell about it in your thesis proposal;
* Choose the most feasible and applicable methods. It is extremely important for your thesis proposal to present the chosen methodology clearly and comprehensibly, as you are being awaited to demonstrate your research abilities. You can reveal them only by means of applicable methods of investigation;
* Tell about the possible outcomes of your research. In this part of your thesis proposal you should also explain the importance of the results obtained.

In spite of everything, the most challenging task is the choice of your thesis proposal topic. Your research starts with it. That is why you have to try your best to choose the most exclusive and unique topic for your thesis proposal that would give promise of extended study.

Function in C++

2009-09-24T22:21:00.000-07:00

What is a Function?

A function is a block of code that has a name and it has a property that it is reusable i.e. it can be executed from as many different points in a C Program as required.
Function groups a number of program statements into a unit and gives it a name. This unit can be invoked from other parts of a program. A computer program cannot handle all the tasks by it self. Instead its requests other program like entities – called functions in C – to get its tasks done. A function is a self contained block of statements that perform a coherent task of same kind
The name of the function is unique in a C Program and is Global. It neams that a function can be accessed from any location with in a C Program. We pass information to the function called arguments specified when the function is called. And the function either returns some value to the point it was called from or returns nothing.

We can divide a long C program into small blocks which can perform a certain task. A function is a self contained block of statements that perform a coherent task of same kind.

Structure of a Function

There are two main parts of the function. The function header and the function body.

int sum(int x, int y)
{
 int ans = 0;  //holds the answer that will be returned
 ans = x + y; //calculate the sum
 return ans  //return the answer
}

Function Header

In the first line of the above code

int sum(int x, int y)

It has three main parts

The name of the function i.e. sum
The parameters of the function enclosed in paranthesis
Return value type i.e. int

Function Body

What ever is written with in { } in the above example is the body of the function.

Function Prototypes

The prototype of a function provides the basic information about a function which tells the compiler that the function is used correctly or not. It contains the same information as the function header contains. The prototype of the function in the above example would be like

int sum (int x, int y);

The only difference between the header and the prototype is the semicolon ; there must the a semicolon at the end of the prototype.

Fahrenheit to celsius conversion

2009-09-24T22:11:00.000-07:00

CSE 112 Answer to your assignment.
formula:
for -- Celsius=(5/9) * (Farenheit - 32)

for -- Farenheit =(9/5) * ( Celcius + 32)

for loop statements

2009-09-23T17:58:00.000-07:00

CSE 112 Students!!! please review this for loop statement click the url address below.

http://www.hitmill.com/programming/cpp/forLoop.htm

CS 417 Students

2009-09-11T17:26:00.000-07:00

Reminder!!!

pass your documentation on pre-final exam.
documentation defense will on sept. 26 - oct 3, oct 10, oct 17
please be guided with your documentation format.
prepare 3 copies for the panelist.
prepare 1 for your reference.
prepare powerpoint for your presentation .
pass before sept. 26, 2009 including your contri.

gudluck!!!

c++ switch statement example

2009-08-26T21:59:00.000-07:00

1:// This is a single line comment
2:// Demonstrates switch statement
3:// This switch example does not used with the break keyword.
4:#include
5:
6:int main()
7
8:int number;
9:"Enter a number between 1 and 5:
10:
11:switch (number)
12:
13:case 0: "Too small, sorry!";
14:break;
15:case 5:
16:case 4: "Nice Pick!\n"; // fall through
17:case 3: "Excellent!\n"; // fall through
18:case 2: "Masterful!\n"; // fall through
19:case 1: "Incredible!\n"
20:
21:default: "Too large!\n";
22:break;
23:
24:cout "\n\n";
25:return 0

Phases of C++ Programs

2009-08-24T18:07:00.000-07:00

Phases of C++ Programs
1.Edit
2. Preprocess
3. Compile
4. Link
5. Load
6. Execute

how to search and delete a record in vb6

2009-08-22T18:28:00.000-07:00

Option Explicit

Private Sub cmdSearch_Click()

Adodc1.RecordSource = "SELECT * FROM tblStudent where Lastname = ' " '& Text1.Text & " ' "
Adodc1.Refresh

If Adodc1.Recordset.RecordCount = 0 Then
'Timer1.Enabled = True
MsgBox "type the lastname to search wala"
End If

End Sub

Private Sub cmdDelete_Click()

Prompt$ = "Do you really want to delete?"
reply = MsgBox(Prompt$, vbOKCancel, "Delete Record")

If reply = vbOK Then
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
End If

End Sub

sample vb color

2009-08-22T18:13:00.000-07:00

Private Sub Stop_Click()
Shape1.BackStyle = 1
Shape1.BackColor = &HFF&
Label1.Caption = "Please Stop"
End Sub

Private Sub Go_Click()
Shape1.BackStyle = 1
Shape1.BackColor = &HFF00&
Label1.Caption = "you can go now..."
End Sub

Private Sub End_Click()
MsgBox ("This will end the sytem")
End Sub

How to plan and create vb6 projects

2009-08-20T03:49:00.000-07:00

The three steps for planning and creating Visual Basic projects and what happens in each step.
Planning
1.When you plan the user interface, you draw a sketch of the screens the user will see when running your project. On your sketch, show the forms and all of the controls that you plan to use. Indicate the names that you plan to give the form and each of the objects on the form.
2. For each of the objects, write down the properties that you plan to set changed for each project during the design of the form.
3.This is where you plan the procedures that will execute when your project runs. You will determine which events require action to be taken, and plan, step-by-step, what those actions should be.
Programming
After you have completed the planning steps and have agreement from your user, you are ready to begin the actual construction of the project. You will use the same three step process that you used for planning.
1.Define the user interface. When you define the user interface, you create the forms and controls that you designed in the planning stage. Think of this step as all of the objects you will use in your project.
2.Set the properties. When you set the properties of the objects, you give each object a name and define such attributes as the contents of a label, the size of the text, and the words that appear on top of a command button and in the form’s title bar. You might think of this step as describing each of your objects.
3.Write the Basic code. This is where you write the procedures that will execute when your project runs. You will use Basic programming statements (called Basic code) to carry out the actions needed by your program. You will be surprised and pleased by how few statements you need to create a powerful Windows program. You can think of this third step as defining the of your program

how to add and delete record in Visual Basic 6.0

2009-08-20T03:26:00.000-07:00

guys, here are the simple code in vb6 on how to add,delete a record
1. for Add --> adodc1.recordset.addnew
2. for Delete --> adodc1.recordset.delete
note: be sure that you add adodc component.

NDMC Web site

2009-08-19T18:31:00.000-07:00

check this web address www.ndmc.edu.ph

Welcome to Macao's Blog

Current Trends in Information Technology

Steve Jobs

Internet

Software Freedom Day

PHP

Adding Records to a MySQL Database with PHP

The only thing that needs to change is your SQL statement. The steps we're going to be taking are these:

Set up a SQL Statement to add records to the database

INSERT INTO … VALUES

Web Programming

List of Projects

Want To Learn Web Programming? Write A Blog Engine

PHP

Creating Webpage

Java Database Connectivity (JDBC)

Thanks to David Reilly

Web Design using Free CSS Template

Web Development Strategies

Website Reference for SUMMER 2011 - IT 312 (Web Design/Development)

You can choose other websites for your additional information

Japan

Take good care of our Mother Nature!

TERRIBLE....Japan hit by 8.9 magnitude quake and tsunami.. let's pray to all the OFW's and all the people in Japan.

Using ADO Data Control

Top 10 Linked In Etiquette Requests

WEB DEVELOPMENT

JUnit and TestNG

Sunday Class

Photoshop

Software Engineering

Simulations

Introduction to Monte Carlo Methods

Monte Carlo Calculation of Pi

Monte Carlo Computation of Population Distribution

Examination Day

Research Topic for Business

Photoshop CS2 Animation

How to Make Animation in PhotoShop CS2

Projects/Ecommerce Integration/FunctionalSpecifications

Projects/Ecommerce Integration/FunctionalSpecifications

Purpose

Scope

User roles & profiles

Business process definition

User stories

Functional requirements based on business processes

User Interface Mockups

Technical Requirements

Non-Functional Requirements

Open Discussion Items

Teaching Strategies

JavaScript Example

To find the greatest common factor?

Java

Introduction to Database

Seminar

Introduction to Computer

Introduction to Computer & Productivity Tools

Productivity Tools

Create MONEY here!!!

Sign Up Notre Damean

Computerized Election 2010

What's on your mind?

Student's Summer Homepage

Web Devt.

Vote Wisely!!!

System Analysis and Design (CSE 314/IT 315)

Seminar

CSE 122 / IT 122 Study and Debug the vb game program (MIDTERM)

PowerPoint Exercise for SPED

Soft Eng

PSITS

How to write your paper

Creating VB database applications using ADO control

Using Crystal Reports in VB

CREATING A REPORT:

SELECTING FIELDS:

SORTING FIELDS:

TOTALS AND SUBTOTALS: