LEARNING MODULE 08
TVET-PROGRAMME TITLE: Web Development and Database Administration Level III
MODULE TITLE: Integrating database with a website
MODULE CODE: EIS WDDBA3 M08 0322
NOMINAL DURATION: .90 Hours
MODULE DESCRIPTION: This module describes defines the competency required to skills
and knowledge that define to ensure database is integration with a website
LEARNING OUTCOMES
At the end of the module the trainee will be able to:
LO1. Connect to database
LO2. Retrieve data from database and display on web pages
LO3. Update database data from user input
MODULE CONTENTS:
LO1. Connect to database
1.1. Introduction to web servers, databases and server-side scripting languages
1.2. Identifying user and site data needs from technical requirements
1.3. Identifying and installing web servers
1.4. Connecting to database from web application using a web development language
LO2. Retrieve data from database and display on web pages
2.1 Retrieving data using structured query language (SQL)
2.2 Displaying data in the most appropriate control
2.3 Formatting data to display it in the most effective way
LO3. Update database data from user input
3.1 Updating existing data stored in the database with user supplied input
3.2 Inserting data in the database with user-supplied input
3.3 Deleting data stored in the database
3.4 Including error checking and validation
Learning Methods:
For none Reasonable Adjustment for Trainees with Disability (TWD)
impaired
Low Vision Deaf Hard of hearing Physical impairment
trainees
Lecture- Provide large print text Assign sign language Organize the class Organize the class room
discussion Prepare the lecture in Audio/video interpreter room seating seating arrangement to be
Organize the class room seating Arrange the class room seating arrangement to be accessible for wheelchairs
arrangement to be accessible to trainees to be conducive for eye to eye accessible to users.
Write short notes on the black/white board contact trainees Facilitate and support the
using large text Make sure the luminosity of Speak loudly trainees who have severe
Make sure the luminosity of the light of the light of class room is kept Ensure the attention impairments on their upper
class room is kept Introduce new and relevant of the trainees limbs to take note
Use normal tone of voice vocabularies Present the lecture Provide Orientation on the
Encourage trainees to record the lecture in Use short and clear sentences in video format physical feature of the work
audio format Give emphasis on visual lecture Ensure the attention shop
Provide Orientation on the physical feature and ensure the attention of the of the trainees
of the work shop trainees
Summarize main points Avoid movement during
lecture time
Present the lecture in video
format
Summarize main points
Demonstratio Conduct close follow up use Sign language interpreter Illustrate in clear & Facilitate and support the
n Use verbal description Use video recorded material short method trainees having severe upper
Provide special attention in the process of Ensure attention of the trainees Use Video recorded limbs impairment to operate
guidance Provide structured training material equipments/ machines
facilitate the support of peer trainees Show clear and short method Ensure the attention Assign peer trainees to assist
Prepare & use simulation Use gesture of the trainees Conduct close follow up
Provide tutorial support Provide tutorial Provide tutorial support
(if necessary) support (if necessary
(if necessary)
Group Facilitate the integration of trainees with Use sign language interpreters Facilitate the Introduce the trainees with
discussion group members Facilitate the integration of integration of their peers
Conduct close follow up trainees with group members trainees with group
Introduce the trainees with other group Conduct close follow up members
member Introduce the trainees with Conduct close
Brief the thematic issues of the work other group member follow up
Introduce the
trainees with other
group member
Inform the group
members to speak
loudly
Exercise Conduct close follow up and guidance Conduct close follow up and Conduct close Assign peer trainees
Provide tutorial support if necessary guidance follow up and Use additional nominal hours
provide special attention in the process Provide tutorial support if guidance if necessary
necessary Provide tutorial
provide special attention in the support if necessary
process/practical training provide special
Introduce new and relevant attention in the
vocabularies process/ practical
training
prepare the assignment questions in large Use sign language interpreter Provide briefing
Individual text Provide briefing /orientation on /orientation on the
assignment Encourage the trainees to prepare and the assignment assignment
submit the assignment in large texts Provide visual recorded Provide visual
Make available recorded assignment material recorded material
questions
Facilitate the trainees to prepare and
submit the assignment in soft or hard copy
ASSESSMENT METHODS:
Interview Use sign language interpreter Speak loudly Use written response
Ensure or conform whether Using sign language interpreter if as an option for the
the proper communication necessary trainees having speech
was conducted with the challenges
trainee through the service of
the sign language interpreter
Use short and clear
questioning
Time extension
Written test Prepare the exam in large texts Prepare the exam using short Prepare the exam using short Use oral response as
Use interview as an option if sentences, multiple choices, sentences, multiple choices, true or an option to give
necessary True or False, matching and false, matching and short answers if answer for trainees
Prepare the exam in audio short answers necessary. having severe upper
format Avoid essay writing limb impairment
Assign human reader Time extension Time extension for
(if necessary) trainees having severe
Time extension upper limb impairment
Demonstration Brief the instruction or Use sign language interpreter Provide activity based assessment Provide activity based
/Observation provide them in large text Brief on the instruction of the Brief on the instruction of the exam assessment
Time extension exam Use loud voice Conduct close follow
Provide activity-based/ Time extension up
practical assessment method Time extension
Time extension
ASSESSMENT CRITERIA:
LO1. Connect to database
Identify site data needs from technical requirements
Connect to database from web application using a web development language
LO2. Retrieve data from database and display on web pages
Retrieve data using structured query language (SQL)
Display data in the most appropriate control
Format data so that it is displayed in the most effective way
LO3. Update database data from user input
Update existing data stored in the database with user supplied input
Insert data in the database with user-supplied input
Delete data stored in the database
Include error checking and validation
Annex: Resource Requirements
MODULE CODE: MODULE TITLE:
EIS WDDBA3 M08 0322 Integrating database with a website
Item Category/Item Description/ Quantity Recommended
No. Specifications Ratio
(Item: Trainee)
A. Learning Materials
Trainers made 25 1:1
1. TTLM
handouts
2. Reference Books
Learning PHP, MySQL & Robin Nixon,
2.1 JavaScript: With jQuery, CSS & 2015, 5th 5 1:5
HTML5 Edition
Jennifer
Niederst
2.2 Learning Web Design Robbins, 5 1:5
Fourth
Edition,2012
Adobe Dreamweaver CC Adobe, 2015
2.4 5 1:5
Classroom in a Book® release
B. Learning Facilities & Infrastructure
1. Lecture Room Standard 1 1:25
Library equipped with
2. 1 1:25
database books
Computer lab - 8x12m;
equipped with
3. 1 1:25
computers and
Internet
C. Consumable Materials
1. Blank CD - CD-R/RW 5 1:5
Stationery - Whiteboard
2 marker, printing 1 1:25
paper, printer ink
Flash disk San disk or
3 5 1:5
similar 4GB
D. Tools and Equipment
1. Computer At least 25 1:1
w/15 inch
monitor and 120
GB Hard disk;
RAM size 2 GB;
3Gz or above
with installed
operating system
(windows 7 and
above)
750 Volt 1:2
2 UPS 12
Ampere
American socket 12:25
3 Divider 12
supporter
4 Multimedia projector - LCD 1 1:25
5 Printer Laser Jet 1 1:25
may include:
Internet browsers
Internet Explorer
Firefox Mozilla
6 Software (Web browsers) 5 1:5
Opera
Google chrome
With a latest
version
May include
Dreamweaver
Edit Pad
Edit Plus Front
Page Notepad
Sublime text
7 Web authoring tool 5 1:5
editor
Atomic
Visual Studio
code
With a latest
version
