Scribd
Upload
84 views2 pages

BBIT 201 Exam Paper 2020

The document provides instructions for the University Examinations for the degree of Bachelor of Business in Information Technology. It outlines two questions. Question One involves (a) creating a student database in MySQL and connecting it to a website using PHP, and (b) displaying 10 student names from an array using JavaScript. Question Two involves (a) writing HTML code to display a duty roster table and (b) writing a JavaScript program to allow a lecturer to enter student marks for assignments, a test, and exam and display totals out of 100 for 40 students.

Uploaded by

Quenter Njoroge
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
84 views2 pages

BBIT 201 Exam Paper 2020

The document provides instructions for the University Examinations for the degree of Bachelor of Business in Information Technology. It outlines two questions. Question One involves (a) creating a student database in MySQL and connecting it to a website using PHP, and (b) displaying 10 student names from an array using JavaScript. Question Two involves (a) writing HTML code to display a duty roster table and (b) writing a JavaScript program to allow a lecturer to enter student marks for assignments, a test, and exam and display totals out of 100 for 40 students.

Uploaded by

Quenter Njoroge
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

UNIVERSITY EXAMINATIONS: 2019/2020

EXAMINATION FOR THE DEGREE OF BACHELOR OF BUSINESS IN


INFORMATION TECHNOLOGY
BBIT 201: INTERNET APPLICATION PROGRAMMING
FULL TIME/ PART TIME/DISTANCE LEARNING
DATE: AUGUST, 2020 TIME: 6 HOURS

INSTRUCTIONS: Answer ALL Questions

QUESTION ONE
a) Create a database named KCA in Mysql, create a table called students, fields in the table
should include, Reg_no, surname, Middle name and first name, course , age ,guardian, Telno etc.

10 Marks
b) Connect the database to your website using php 5 Marks
c) Create an array containing 10 students then use the java script for each statement to display
the names on the screen
10
Marks

QUESTION TWO
(a) Write a html Code to produce the following table 10 Marks

DUTY ROSTER FOR LAST TWO DAYS


DAY MORNIN TUESDAY
G

MON JOHN
TUE TOM PETER
WED SIMON

b) KCA University lecturer requires a program to help her enter marks at the end the trimester.
The exam comprises of course work and end of trimester exam. Course work is made up of two
Assignments and a continuous assessment test (CAT). Each assignment is marked out of 5marks,
the CAT is marked out of 20 marks and the end of trimester exam is marked out of 70 marks.
The program should allow the lecturer to enter the two assignments, CAT and end of trimester
exam. The program should display the name of student, total course work, the end of term exam
score and the total score out of 100. The class has 40 students.
Required
Write a program using java script to process the logic above. 15 Marks

You might also like