Project Management

GANTT CHART

A Gantt Chart is a type of bar chart that illustrates a project schedule. Gantt charts illustrate the start and finish dates of the terminal elements and summary elements of a project. Terminal elements and summary elements comprise the work breakdown structure of the project. Some Gantt Charts also show the dependency (i.e, precedence network) relationships between activities. Gantt charts can be used to show current schedule status using percent-complete shadings and a vertical "TODAY" line.

Although now regarded as a common charting technique, Gantt charts were considered revolutionary when they were introduced. In recognition of Henry Gantt's contributions, the Henry Laurence GAntt Medal is awarded for distinguished achievement in management and in community service. This chart is used also in Information Technology to represent data that has been collected.

Advantages and Limitations

Gantt charts only represent part of the triple constraints of projects, because they focus primarily on schedule management.

Moreover, GAntt charts do not represent the size of a project or the relative size of work elements, therefore the magnitude of a behind-schedule condition is easily miscommunicated. If two projects are the same number of days behind schedule, the larger project has a larger impact on resource utiization, yet the Gantt does not represent this difference.




WORK BREAKDOWN STRUCTURE (WBS)

A tool used to define and group a project's discrete work elements (or tasks) in a away that helps organize and define the total work scope of the project.

A work breakdown structure element may be a product, data, a service, or any combination. A WBS also provides the necessary framework for detailed cost estimating and control along with providing guidance for schedule development and control. Additionally the WBS is a dynamic tool and can be revised and updated as needed by the project manager.

The work BREakdown Structure is a tree structure, which shows a subdivision of effort required to achieve an objective; for example a program, project, and contract. In a project or contract, the WBS is developed by starting with:

• the end objective and
• successively subdividing it into manageable components
• in terms of size, duration, and responsibility (e.g., systems, subsystems, components, tasks, subtasks, and work packages)
• which include all steps necessary to achieve the objective
  

S-CURVE

Important project management tool. They allow the progress of a project to be tracked visually over time, and form a historical record of what has happened to date. Analyses of S-Curves allow project managers to quickly identify project growth, slippage, and potential problems that could adversely impact the project if no remedial action is taken.

How is an S-Curve Generated?

To generate a Baseline S-Curve, a Baseline Schedule is required. The Baselline Schedules should contain the following information for each task:

• Baseline Start Date, Finish Date
• Baseline Man Hours and/or Costs
  

To generate Actual and Target S-Curves, a Production Schedule is required. The production schedules should contain the following information for each task:

• Actual Start Date, Finish Date
• Actual Man Hours and/or Costs
• Actual Percentage Complete
  

PERT/CPM

The final network models we discuss are the PERT and CPM models for project scheduling. The successful management of large projects, be the construction, transportation, financial, or what-have-you, relies on careful scheduling and coordinating of various tasks. CPM (Critical Path Method) and PERT (Project Evaluation and Review Technique) attempt to analyze project scheduling This allows for better control and evaluation of the project.

CPM and PERT have been used in a wide variety of projects , from designing and producing computers to scheduling a complex surgery. The essential ideas behind these techniques are quite straightforward

CPM uses a project network to portray graphically the relationships among the tasks in a project.

Each arc of the project represents a task, or activity. This is the activity on arc(AOA) representation. Each node represents an event. The direction of the arcs gives the sequences in which activities must be achieved. An event must precede the beginning of succesive activities, and an event occurs only when all the activities immediately preceding it occur.

The Program Evaluation and Review TEchnique (PERT) is a network model that allows for ramdomnes in activity completion times. PERT originally was an activity on arc network, in which the activities are represented on the lines and milestones on the nodes. OVer time, some people began to use PERT as an activity on node network.

Daily Top 5 Ngayon at Hindi Kahapon

"Daily top 5 ngayon at hindi kahapon" is one of Campus Radio's Programs who's top priority is the listener's most requested songs. Here in this program, the Disc Jock ranks FIVE of the most demanded songs both foreign and local and in any given genre. The said program comes about every Monday to Saturday, 12 noon until 1 PM (Philippine Time). Assigned during that time from Monday to Thursday and Saturday is Papa Joey while Papa Dick takes over every Friday when Papa Joey is having his day off. Also equpped in the program are widely known disco and slow hits, local or foreign, of the 70's, 80's and 90's.

This will be our ranking for Today's
Daily Top 5 Ngayon at Hindi Kahapon..

5. This is me - ung isang version papa dick
4. Kung sakali - Ogie d Pogi
3. Sa'yo lamang - Aiza Seguerra
2. Yugto - Rico Blanco
1. Paano na kaya - Bugoy

(Kung gusto mo Papa Dick, iClick mo rin ung advertisement ng Google sa Web page na to,
hayaan mo, di ako kikita dun. Heheehe..)

Theory Of Database Systems (Assignments)

Assignment: Create a Database that will determine an ODD number of Inventory. Use the tblingredients table.
























SELECT ([inventory] MOD 2) AS ODD, *
FROM tblingredients;

/*through the use of this query which can determine the ODD number inventory
by means of the MOD function built in Microsoft Access*/









SELECT ingredientid, name, unit, unitprice, foodgroup, inventory, vendorid
FROM qrymod1
WHERE odd = 1;

/*This gives us the result of the specified ODD numbered inventory at TBLingredients*/

Theory Of Database Systems

Sample Queries

SELECT tblvendors.vendorid, name,
companyname]

FROM tblvendors, tblingredients

WHERE tblingredients.vendorid =
tblvendors.vendorid






SELECT name

FROM tblingredients, tblvendors

WHERE tblingredients.vendorid=tblvendors.vendorid And
companyname='Veggies_R_Us';





SELECT tblstores.storeid, price
FROM tblorders, tblstores
WHERE tblorders.storeid = tblstores.storeid
AND state = 'CA';













SELECT state, SUM(price) AS [Sum]

FROM tblstores, tblorders

WHERE tblstores.storeid=tblorders.storeid

GROUP BY state;





SELECT v.vendorid AS ["Vendor ID"], name

FROM tblingredients AS i, tblvendors AS v

WHERE i.vendorid=v.vendorid And v.companyname In ('Veggies_R_Us','Spring Water Supply')

ORDER BY v.vendorid;




SELECT DISTINCT mi.name, price

FROM tblingredients AS i, tblvendors AS v, tblitems AS mi, tblmadewith AS mw

WHERE i.vendorid=v.vendorid And i.ingredientid=mw.ingredientid And mw.itemid=mi.itemid And
companyname='Veggies_R_Us';





SELECT companyname, MAX(price) AS prices

FROM tblingredients AS i, tblvendors AS v, tblitems AS mi, tblmadewith AS mw

WHERE i.vendorid=v.vendorid And i.ingredientid=mw.ingredientid And mw.itemid=mi.itemid

GROUP BY v.vendorid, companyname;




SELECT DISTINCT (companyname)

FROM tblingredients AS i, tblvendors AS v,
tblitems AS mi, tblmadewith AS mw

WHERE i.vendorid=v.vendorid And i.ingredientid=mw.ingredientid And mw.itemid=mi.itemid And mi.name='Fruit Plate';





SELECT v2.companyname

FROM tblvendors AS v1, tblvendors AS v2

WHERE v1.vendorid = v2.referredby AND
v1.companyname = 'Veggies_R_Us';





SELECT i.name, m.name
FROM tblitems AS i, tblmeals AS m, tblpartof AS p
WHERE i.itemid = p.itemid AND p.mealid = m.mealid;








SELECT i.name
FROM tblingredients AS i, tblmadewith AS mw
WHERE i.ingredientid = mw.ingredientid AND inventory = quantity;






SELECT ingredientid
FROM tblingredients, tblvendors
WHERE name = companyname;


















SELECT *
FROM tblmeals, tblpartof;






SELECT m.name AS meal, i.name AS item

FROM tblmeals AS m, tblpartof AS p, tblitems
AS i

WHERE m.mealid = p.mealid AND i.itemid = p.itemid;






SELECT *

FROM tblmeals AS m1, tblmeals AS m2;








SELECT m.name AS meal, i.name AS item

FROM tblmeals AS m, tblpartof AS p, tblitems
AS i

WHERE i.itemid = p.itemid;










SELECT tblitems.name, ing.name

FROM tblitems, tblmadewith AS mw,
tblingredients AS ing

WHERE tblitems.itemid = mw.itemid AND mw.ingredientid = ing.ingredientid AND (3 * mw.quantity) > ing.inventory;





SELECT a.name

FROM tblitems AS a, tblitems AS q

WHERE a.price > q.price AND q.name = 'Garden Salad';





SELECT DISTINCT (i.name)

FROM tblitems AS a, tblitems AS q, tblmadewith AS m, tblingredients AS i

WHERE a.price > q.price AND q.name = 'Garden Salad' AND i.ingredientid = m.ingredientid AND m.itemid = a.itemid;










SELECT i1.name, COUNT(*) AS rank

FROM tblingredients AS i1, tblingredients
AS i2

WHERE i1.name >= i2.name

GROUP BY i1.ingredientid, i1.name;











SELECT name

FROM tblingredients AS i INNER JOIN tblvendors AS v
ON i.vendorid=v.vendorid

WHERE v.companyname='Veggies_R_Us';