Design Program Logic
Level III
Prepared by Moges Tesfaye(MSc in ICT)
Learning Outcomes and Assessment Criteria
Unit of Competence : Design Program Logic
Module Title EIS DBA3 M06 0517Designing Program Logic
LO 1 Select the program logic design approach
Assessment Criteria Program flow, states or conditions are checked
for interfaces and compliance to design
documentation requirements
Feedback/input is gained from appropriate person as
needed
LO 2 Document the program logic or design
Assessment Criteria Diagrams of program flow and modules are
structured according to project standards
Program scope and limits are documented
according to project standards
Special routines or procedures are documented
or referenced according to project standards
References for tables, files, inputs, outputs, and
other program functionalities are identified and
revised according to program requirements
Templates are used as applicable
LO 3 Validate the design
Assessment Criteria Design documentation is obtained and the
requirements for the programs are reviewed and
clarified.
Design approach to be taken in coding and the
modules and links required is determined
Training Mechanics
The Outcome-Based Training is one form of an independent learning approach. This
approach enables trainees to be master of their own environment and in charge of their
learning. It is also characterized by the integration of theory and application as two
dimensions of an effective learning process. The outcome-based system is consists of a
combination of lecture-discussion, individualized learning activities, mentoring, field
immersion and feedback.
In this competence the trainees will be given individual learning guide to go through and
accomplish. They will be instructed through this learning guide to accomplish learning activities as
part of the mechanism to transfer learning from the training situation to the job situation. For this
competence area, trainees will formulate a specific learning plan as a guide for applying their
learning to work setting and for their own continuing self-development. At this point, your role as
a trainer/facilitator is to guide the trainee in preparing and accomplishing their plan.
Lecture and discussion of the topics outlined in the session plan should be performed first before
the trainees are instructed to go to the workshop. You are also required to demonstrate the correct
steps/procedures and techniques to your trainees before you let them practice. Insure that they are
practicing safely.
Most part of the training activities will be conducted in the workshop for better development of
specific skills. Aside from motivating them to relate concepts and skills to their own work
situations, make sure to provide the necessary opportunity for competence practice and better
internalization of such concepts and techniques. The trainees should also be provided the
opportunity to blend with the actual working unit in the industry.
In this system, it is important to develop a sustained relationship with the trainees through a
continued involvement, where you are to offer support, guidance and assistance as the trainee go
through the learning activities and actual work.
With the mentoring approach, the trainees are grouped in learning teams with one facilitator-mentor
per team. Before learning session or workshop start in the morning, each team and mentor meets to
give feedback regarding their work, or how the group improves, acquire set of skills for the
members to become more effective trainees. You are also to asses them at the end of each module.
However, they have to be ready before the assessment and it should be them to request for it.
Before the training start you should conduct an orientation session to brief the trainees on how the
training will proceed.
Session Plans
Session Plan1 (EIS DBA3 03 0811)
Unit of Competency : Design Program Logic
Module Title : Designing Program Logic
LO 1 : Select the program logic design approach
Session Objectives: At the end of this session the learners shall be able to –
Obtain Design documentation
Review and clarify requirements for the program
Determine Design approach
Nominal
Activities 20hour Methods
Duration
Sessions 10 mins Recapitulation Question & Answer
10hr Obtaining Design documentation Lecture-discussion
Reviewing and clarifying Lecture-discussion and
6:30hr requirements for the demonstraion
program
Determining Design approach Lecture-discussion and
2hr
demonstration
Evaluation 1 hr Accomplishment of LAP Test Individual Activity
Discussion of LAP Test
Summary 20 mins Wrap-up and Feedback
Answers
Resources Job specifications
Safety manual and guide
Reference Books
Journals/publications/magazines
SET BY: Moges Tesfaye--------------------------
Signature ------------- Approved by-------------------------------
Signature ------------------------
LAP test
Lap test Demonstration
Name:____________________
Date:_________________
Instruction: Answer all the questions listed below, if you have some
clarifications- feel free to ask your teacher.
Question 1
The following pseudocode describes an algorithm which will accept a number from the keyboard
and calculate the sum of n numbers and design the corresponding flowchart.
Question 2
The following pseudocode describes an algorithm which will accept two numbers from the
keyboard and calculate the sum and product displaying the answer on the monitor screen
SET BY: Moges Tesfaye--------------------------
Signature ------------- Approved by-------------------------------
Signature ------------------------
DATABASE ADMINISTRATION SERVICES
Level III
Unit of Competence : :-Design Program Logic
Module Title : :-Designing Program Logic
LO1: Select the program design approach
LO1: Select the program design approach
1.1 Obtaining design documentation and requirement for the program clarification
Pseudocode
In computer science and numerical computation, pseudocode is an informal high-level description
of the operating principle of a computer program or other algorithm.
- An outline of a program, written in a form that can easily be converted into real
programming statements.
- It cannot be compiled nor executed, and there is no real formatting or syntax rules. It is
simply an important step in producing the final code.
An algorithm is a procedure for solving a problem in terms of the actions to be executed and the
order in which those actions are to be executed.
- An algorithm is merely the sequence of steps taken to solve a problem. The steps are
normally "sequence," "selection,” "iteration," and a case-type statement.
The "selection" is the "if then else" statement, and the iteration is satisfied by a number of
statements, such as the "while," " do," and the "for," while the case-type statement is satisfied by
the "switch" statement.
Algorithm vs Pseudocode
Both Algorithm and Pseudo code more or less describe the logical sequence of steps that follow in
solving a problem
Pseudocode consists of short readable and formally-styled natural language that used to explain
specific tasks within a program's algorithm while an Algorithm is a group of instructions or a set of
steps applied to solve a particular problem. - A Pseudo code is a method used to define an
algorithm.
- An algorithm is written in a natural language while pseudo code can be written in high
level
programming languages.
- Pseudcode cannot be executed on a real computer, but it models and resembles real
programming code,
and is written at roughly the same level of detail.
Example: The following pseudocode describes an algorithm which will accept two numbers from
the keyboard and
calculate the sum and product displaying the answer on the monitor screen.
Solution: Use variables sum, product, number1, number2 of type real
Display “Input two numbers”
Accept number1, number2
Sum = number1 + number2
Print “The sum is “, sum
Product = number1 * number2
Print “The Product is “, product
End program
Flow charts
A flowchart is a type of diagram that represents an algorithm or process, showing the steps as
boxes of various kinds, and their order by connecting those with arrows.
This diagrammatic representation can give a step-by-step solution to a given problem.
Flowcharts are used in analyzing, designing, documenting or managing a process or program in
various fields.
A flow chart can be used to:
Define and analyze processes.
Build a step-by-step picture of the process for analysis, discussion, or communication.
Define, standardize or find areas for improvement in a process
Session Plan2 (EIS DBA3 03 0811)
Unit of Competency : Design Program Logic
Module Title : Designing Program Logic
LO 2 : Select the program logic design approach
Session Objectives: At the end of this session the learners shall be able to –
Structure Diagrams of program flow and
Document Program scope and limits
Document or reference Special routines or procedures
Nominal
Activities 20hour Methods
Duration
Sessions 10 mins Recapitulation Question & Answer
Lecture-discussion and
5 hr Structuring Diagrams of program demonstraion
flow and modules
Documenting Program scope and Lecture-discussion and
5hr
limits demonstration
3:30hr Documenting or referencing Lecture-discussion
Special routines or procedures
Identifying and revising
5hr References for tables, files, Lecture-discussion
inputs, outputs, and other
program functionalities
Evaluation 1 hr Accomplishment of LAP Test Individual Activity
Discussion of LAP Test
Summary 20 mins Wrap-up and Feedback
Answers
Resources Job specifications
Safety manual and guide
Reference Books
Journals/publications/magazines
SET BY: Moges Tesfaye--------------------------
Signature ------------- Approved by-------------------------------
Signature ------------------------
Operation sheet
Operation title: create drawing aflow chart
Module code: EIS DBA3 M06 0517
Purpose: -to draw flow chart using visio
Condition or situations for the operations:
- Install visio 2007
Equipment tool& materials
a computer
Procedure
Step 1: Choose and open a template
. Start Visio 2007.
. In the Template Categories list:
* Click Flowchart to Design flowchart.
* Click Basic diagram to Design the ERD for a database.
* Click software to develop data flow diagram, and so on.
Step 2: Drag and connect shapes
Step 3: Add text directly to a shape
Quality Criteria:
- Follow procedures in step by step
- The project must be functional
- Finishing on time
SET BY: Moges Tesfaye--------------------------
Signature ------------- Approved by-------------------------------
Signature ------------------------
Lap test demonistration
Name:____________________
Date:_________________
Instruction: Answer all the questions listed below, if you have some
clarifications- feel free to ask your teacher.
Algorithm and flow chart using Visio
Problem area on:-
Add two numbers entered by the user.
Find the largest among three different numbers entered by the user.
Find the area of a Circle of radius r
Write an algorithm to read two numbers and find their sum
Convert temperature Fahrenheit to Celsius\
SET BY: Moges Tesfaye--------------------------
Signature ------------- Approved by-------------------------------
Signature ------------------------
LO2. Document the program logic or design
2.1 Structuring diagrams of flow and modules
Visio
Visio is a Microsoft tool for drawing diagrams, including database diagrams (ERDs).
It is a diagramming tool that can be used to visually communicate technical as well as non-
technical representations of ideas, processes, concepts, structures, layouts, software models,
blueprints, etc.
- Visio software eliminates the laborious (difficult or lengthy) process of creating diagrams
by providing the tools to create complex diagrams in a user friendly manner.
Smart Draw
Smart Draw is a visual processor used to create flowcharts, organization charts, mind maps,
project charts, and other visuals.
I.e.:- It is a tool used to help you create visuals for reports, presentations, business functions, and
any other reason you may need visuals.
Smart Draw is unique in three key ways:
1. It is automated. Smart Draw is the only software that makes it possible for anyone to create
presentation-quality visuals in minutes. Instead of forcing you to draw visuals manually, it
draws for you, ensuring a professional result every time.
2. It is comprehensive (complete). Smart Draw is the only software that allows you to create
every kind of visual-more than 70 different types-including flowcharts, timelines, org
charts, mind maps, floor plans, marketing charts and more.
3. It is integrated. Smart Draw works seamlessly (effortlessly) with Microsoft Office.
Create a drawing in 3 basic steps
There are many kinds of Visio drawings, but you can use the three basic steps to create nearly all of
them:
- Choose and open a template.
- Drag and connect shapes.
- Add text to shapes.
The following steps show how to create a basic flowchart.
Step 1: Choose and open a template
. Start Visio 2007.
. In the Template Categories list:
* Click Flowchart to Design flowchart.
* Click Basic diagram to Design the ERD for a database.
* Click software to develop data flow diagram, and so on.
Example: To create a flowchart, in the Flowchart window, under Featured Templates, double-click
Basic Flowchart.
Session Plan3 (EIS DBA3 03 0811)
Unit of Competency : Design Program Logic
Module Title : Designing Program Logic
LO 3 : Validate the design
Session Objectives: At the end of this session the learners shall be able to –
Check Program flow, states or conditions for
interfaces and compliance to design documentation
requirements
Gain Feedback/input from appropriate person
Nominal
Activities 10hurs Methods
Duration
Sessions 10 mins Recapitulation Question & Answer
Checking Program flow, states or
5 hr conditions for interfaces and Lecture-discussion
compliance to design
documentation requirements
3:30hr Gaining Feedback/input from Lecture-discussion
appropriate person
Evaluation 1 hr Accomplishment of writeen Test Individual Activity
Discussion of writeen
Summary 20 mins Wrap-up and Feedback
Test Answers
Resources Job specifications
Safety manual and guide
Reference Books
Journals/publications/magazines
SET BY: Moges Tesfaye--------------------------
Signature ------------- Approved by-------------------------------
Signature ------------------------
Writeen test
Self – Check Written Test
Name:____________________
Date:_________________
Instruction: Answer all the questions listed below, if you have some
clarifications- feel free to ask your teacher.
Question 1
How to Checking program flow, states or conditions ?
SET BY: Moges Tesfaye--------------------------
Signature ------------- Approved by-------------------------------
Signature ------------------------
LO3. Validate the design
Checking program flow, states or conditions
Testing aimed at ensuring that a product or system fulfils the defined user needs and specified
requirements, under specified operating conditions.
3.1.1 Interfaces and compliance to design documentation requirement
An interface control drawing or interface control document describes the interface or interfaces to a
system or subsystem. Ensuring the compliance of individual projects with the enterprise
architecture is an essential aspect of architecture governance.
Program flow, states or conditions are checked for interfaces and compliance to design
documentation requirements
Gaining feedback or input
Gaining feedback from appropriate person enables you to revise the designed system again to
satisfy your customers. By getting customer feedback, you can make your customers happier.
