-- phpMyAdmin SQL Dump -- version 2.11.9.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 01, 2011 at 05:13 PM -- Server version: 5.0.67 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `fouram` -- -- -------------------------------------------------------- -- -- Table structure for table `chat_messages` -- CREATE TABLE IF NOT EXISTS `chat_messages` ( `message_id` int(11) NOT NULL auto_increment, `username` varchar(255) NOT NULL, `message` text NOT NULL, PRIMARY KEY (`message_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `chat_messages` -- INSERT INTO `chat_messages` (`message_id`, `username`, `message`) VALUES (1, 'PDsNn', 'hi'), (2, 'PDMNa', 'hi'), (3, 'Brian Willy Aine', 'tell me'), (4, 'Barry Harry', 'tell you?'), (5, 'Brian Willy Aine', 'yeah...'), (6, 'Brian Willy Aine', 'nmnbnbbbbbbbbbbbbb nnnnnnnn jjjjjjjj juuuuuuuuuuuu ko hhhhhhhhhhhh huuuuuuuuuuuuuuuuuuuuuuuu ggggggggggggggggg'), (7, 'Brian Willy Aine', 'ASsadd'), (8, 'Brian Willy Aine', 'fghf'), (9, 'Brian Willy Aine', 'hgjgj'), (10, 'Brian Willy Aine', 'mkll;k'), (11, 'Brian Willy', 'vghgv'), (12, 'Brian Willy', 'gfh'); -- -------------------------------------------------------- -- -- Table structure for table `cid` -- CREATE TABLE IF NOT EXISTS `cid` ( `mole` varchar(20) NOT NULL, `action` text NOT NULL, `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `cid` -- INSERT INTO `cid` (`mole`, `action`, `date`) VALUES ('0782644698270452', 'uploaded notes coded: PD8bv', '2010-12-30 11:47:58'), ('0782644698270452', 'Deleted announcement: PDjn3', '2010-12-30 11:42:29'), ('0782644698270452', 'Uploaded file number: PDeE6', '2010-12-30 11:34:49'), ('0782644698270452', 'Created admin account number PDGOU', '2010-12-30 11:20:33'), ('0782644698270452', 'Created admin account number PDTSK', '2010-12-26 12:06:42'); -- -------------------------------------------------------- -- -- Table structure for table `connecter` -- CREATE TABLE IF NOT EXISTS `connecter` ( `a_con` varchar(20) NOT NULL, `b_con` varchar(20) NOT NULL, `state` varchar(12) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `connecter` -- INSERT INTO `connecter` (`a_con`, `b_con`, `state`) VALUES ('PDJSL', 'PDA8F', 'connected'), ('PDlY', 'PDJSL', 'connected'), ('PDlY', 'PDA8F', 'connected'), ('PDA8F', 'PDlY', 'connected'), ('PDMNa', 'PDJSL', 'connected'), ('PDMNa', 'PDA8F', 'pending'), ('PDMNa', 'PDlY', 'connected'), ('PDIRi', 'PDsNn', 'connected'), ('PDMNa', 'PDsNn', 'pending'), ('PDsNn', 'PDJSL', 'pending'), ('PDsNn', 'PDlY', 'ignored'), ('PDgEJ', 'PDMNa', 'connected'), ('PDgEJ', 'PDIRi', 'ignored'); -- -------------------------------------------------------- -- -- Table structure for table `file` -- CREATE TABLE IF NOT EXISTS `file` ( `file_number` varchar(15) NOT NULL, `file_name` varchar(100) default NULL, `title` varchar(100) NOT NULL, `author` varchar(100) NOT NULL, `subject` varchar(50) NOT NULL, `format` varchar(20) NOT NULL, `institution` varchar(50) default NULL, PRIMARY KEY (`file_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `file` -- INSERT INTO `file` (`file_number`, `file_name`, `title`, `author`, `subject`, `format`, `institution`) VALUES ('PDnAI', 'e_waste_mgt.doc', 'this is hhjk', 'Francis', 'PDNVB', 'Word Document', 'ardfs'), ('PDJ5W', 'Factors_Curriculum_Devpt[1].doc', 'bmnvxdfg', 'mnvxf', 'PDNVB', 'Word Document', 'nams'), ('PDa0x', 'ABARIHAMWE ASSOCIATION APPLICATION.docx', 'thecfgbe', 'jkhjhfgh', 'PDNVB', 'Excel Sheet', 'UMU'), ('PDeE6', '2nd International Conference on Information and Multimedia Technology.doc', 'kj', 'kj', 'PDNVB', 'Word Document', 'kj'); -- -------------------------------------------------------- -- -- Table structure for table `login` -- CREATE TABLE IF NOT EXISTS `login` ( `userid` varchar(20) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(30) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `login` -- INSERT INTO `login` (`userid`, `username`, `password`) VALUES ('PDA8F', 'pp', 'll'), ('PDJSL', 'hh', 'jj'), ('PDlY', 'nn', 'nn'), ('0782644698270452', 'admin', 'admean'), ('PDMNa', 'ba', 'ba'), ('PDsNn', 'uh', 'uh'), ('PDIRi', 'na', 'na'), ('PDTSK', 'ed', 'ed'), ('PDgEJ', 'mk', 'mk'), ('PDGOU', 'oom', 'oom'); -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE IF NOT EXISTS `messages` ( `msgid` varchar(20) NOT NULL, `subject` text NOT NULL, `msg` text NOT NULL, `sender` varchar(20) NOT NULL, `receipient` varchar(20) NOT NULL, `date_sent` date NOT NULL, `state` varchar(12) NOT NULL, PRIMARY KEY (`msgid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `messages` -- INSERT INTO `messages` (`msgid`, `subject`, `msg`, `sender`, `receipient`, `date_sent`, `state`) VALUES ('PD7bW', 'sub sub top', 'is it?', 'PDlY', 'PDA8F', '2010-11-14', ''), ('PD5A0', 'nbtrevc', 'yews', 'PDlY', 'PDJSL', '2010-11-15', 'read'), ('PDAv7', 'gwe', 'weart', 'PDJSL', 'PDA8F', '2010-11-14', 'read'), ('PDGkD', 'Here', 'it was', 'PDlY', 'PDJSL', '2010-12-13', 'read'), ('PDtVu', 'Re: Here', 'right?', 'PDJSL', 'PDlY', '2010-12-13', 'read'), ('PDBwT', 'general announcement', '

jmhbscgfbd

', '0782644698270452', 'general public', '2010-12-15', 'unread'), ('PDxv', 'general announcement', '

jhbnsg

', '0782644698270452', 'general public', '2010-12-15', 'unread'), ('PDVFC', 'Re: mbcgfcx', 'cytsgrad', 'PDMNa', 'PDJSL', '2010-12-15', 'read'), ('PDYRP', 'fsvfgfd', 'xzcd', 'PDMNa', 'PDJSL', '2010-12-30', 'read'), ('PDiSu', 'kjui', 'bnnbbnnb', 'PDJSL', 'PDMNa', '2010-12-30', 'read'), ('PD2gi', 'Re: kjui', 'sqwsdwqe', 'PDMNa', 'PDJSL', '2010-12-30', 'read'), ('PD1BD', 'fghf', 'ghfhgfhgf', 'PDMNa', 'PDgEJ', '2010-12-30', 'read'); -- -------------------------------------------------------- -- -- Table structure for table `notes` -- CREATE TABLE IF NOT EXISTS `notes` ( `n_id` varchar(15) NOT NULL, `extracted_from` varchar(90) NOT NULL, `n_title` varchar(90) NOT NULL, `notes` longtext NOT NULL, `date_uploaded` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`n_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `notes` -- INSERT INTO `notes` (`n_id`, `extracted_from`, `n_title`, `notes`, `date_uploaded`) VALUES ('PDjaF', 'PDJ5W', 'jgdbshjg', '\r\n

\r\n\r\n \r\n \r\n \r\n \r\n \r\n
OVERVIEW
\r\n

\r\n

The task and process of developing curricula is involving and demanding. Here below are some points which can serve as background information, reference material and in some cases as guidelines.

\r\n

1.      The process however, must take into account the regulations and publications of the National Council for Higher Education (NCHE). In this regard, one will find very useful information in NCHE’s “Guidelines for accreditation of programmes” which is given at the end of this short presentation. Another useful document is NCHE’s “Quality Assurance Framework for Uganda Universities” of October 2006. A copy is herewith provided in appendix A.

\r\n

2.      Since USJM’s courses are coming from different institutions and people, there is need for harmonising and rationalising them taking into account USJM’s vision and objectives. [See B below].  A list of the courses which have been sent to the NCHE is herewith attached. The initial work should consist in identifying commonalities and thereafter groups should be formed with somebody chosen to take the lead in giving the required details about the different courses.

\r\n

3.      The entry requirements will have to consider the minimum set by NCHE. In this regard, we should remember that is some cases USJM will have to determine equivalences, and mature entrance exams must be accredited by USJM.

\r\n

4.      Harmonisation will have to take into account the courses that all students enrolled in USJM must take. Those which have been identified so far are: 

\r\n

·         Communication  and Writing Skills

\r\n

·          Computer Literacy

\r\n

·         Research Methodology [Components of this will have to take into account the nature of categories of courses].

\r\n

·         Ethics [The title of this course could be better put as “Ethics and Society”]

\r\n

 

\r\n

4.      USJM will put emphasis and develop policies for streaming the following:

\r\n

·         Environmental management and Education for Sustainable Development (ESD)

\r\n

·         HIV/AIDS

\r\n

·         Gender

\r\n

·         Poverty Eradication

\r\n

 

\r\n

5.      In addition to NCHE’s points to consider when developing curricula. USJM has to specify for each course the time and frequency of delivery, that is: full time, part time, weekend, distance learning/open education etc. In the mode of delivery for distance learning we should agree on the type of method to use. Some institutions use modules, others use readers. The former are written for the purpose and the latter can include photocopies of articles or chapters of books.  If well used, readers might be easier to develop.

\r\n

 

\r\n

6.      Right from the beginning, we should agree on the minimum number of courses needed for getting an academic award. Students tend to ask for more courses and in the end they do not get time to do personal reading and research.

\r\n

 

\r\n

Assessment must take into account one of USJM’s objectives “to provide… practical university education” and the importance of creating an interface between USJM and the community.

', '0000-00-00 00:00:00'), ('PDGY', 'PDnAI', 'Wat it in', '

EXPERIENCE

\r\n

Wide experience of applications / hardware / software, operating systems, scripting with PHP, JAVA, JavaScript, AJAX and HTML, database development with MySQL. Experience covers software development and system troubleshooting, within strict deadlines. Has programmed with all the above languages since 2006. Has been volunteering at the former African School of Open Education (ASOE) as ICT facilitator since July, 2007. Has a Master of Science Degree in Information Systems of Uganda Martyrs University.

', '0000-00-00 00:00:00'); INSERT INTO `notes` (`n_id`, `extracted_from`, `n_title`, `notes`, `date_uploaded`) VALUES ('PDcP2', 'PDnAI', 'in tyhs', ' \r\n

Wide experience of applications / hardware / software, operating systems, scripting with PHP, JAVA, JavaScript, AJAX and HTML, database development with MySQL. Experience covers software development and system troubleshooting, within strict deadlines. Has programmed with all the above languages since 2006. Has been volunteering at the former African School of Open Education (ASOE) as ICT facilitator since July, 2007. Has a Master of Science Degree in Information Systems of UMU.

', '2010-12-25 23:00:54'), ('PD8bv', 'PDeE6', 'nw', '

hgtye

', '2010-12-30 11:47:58'), ('PDA7k', 'PDnAI', 'kjdsvhgsdnbo', '

vbsajhg

', '2010-12-24 11:10:38'), ('PDieb', 'PDnAI', 'iouevghejug', '

cvnhvcb

', '2010-12-24 11:11:48'); -- -------------------------------------------------------- -- -- Table structure for table `notice_read_log` -- CREATE TABLE IF NOT EXISTS `notice_read_log` ( `reader` varchar(20) NOT NULL, `logged_msgid` varchar(20) NOT NULL, `status` varchar(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `notice_read_log` -- INSERT INTO `notice_read_log` (`reader`, `logged_msgid`, `status`) VALUES ('PDlY', 'PDBwT', 'seen'), ('PDlY', 'PDxv', 'seen'), ('PDlY', 'PDBwT', 'seen'), ('PDlY', 'PDBwT', 'seen'), ('PDlY', 'PDxv', 'seen'), ('PDlY', 'PDBwT', 'seen'); -- -------------------------------------------------------- -- -- Table structure for table `posts` -- CREATE TABLE IF NOT EXISTS `posts` ( `postid` varchar(20) NOT NULL, `post` text NOT NULL, `author` varchar(20) NOT NULL, `date_of_post` date NOT NULL, PRIMARY KEY (`postid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `posts` -- -- -------------------------------------------------------- -- -- Table structure for table `rboard_members` -- CREATE TABLE IF NOT EXISTS `rboard_members` ( `thread_code` varchar(15) NOT NULL, `userid` varchar(15) NOT NULL, `status` varchar(15) NOT NULL default 'not on board', `subject` varchar(15) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `rboard_members` -- -- -------------------------------------------------------- -- -- Table structure for table `rboard_messages` -- CREATE TABLE IF NOT EXISTS `rboard_messages` ( `message_id` int(11) NOT NULL auto_increment, `username` varchar(255) NOT NULL, `message` text NOT NULL, `thread_code` varchar(15) NOT NULL, PRIMARY KEY (`message_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `rboard_messages` -- -- -------------------------------------------------------- -- -- Table structure for table `subject` -- CREATE TABLE IF NOT EXISTS `subject` ( `sbjid` varchar(12) NOT NULL, `bsubject` varchar(30) NOT NULL, PRIMARY KEY (`sbjid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `subject` -- INSERT INTO `subject` (`sbjid`, `bsubject`) VALUES ('PDNVB', 'mbcbfhh'), ('PDwUu', 'rtyewgyh'), ('PDg1w', 'Bios'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `userid` varchar(20) NOT NULL, `fname` varchar(30) NOT NULL, `lname` varchar(30) NOT NULL, `school` varchar(70) NOT NULL, `i_o_status` varchar(20) NOT NULL, PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` -- INSERT INTO `user` (`userid`, `fname`, `lname`, `school`, `i_o_status`) VALUES ('PDJSL', 'gughiu', 'hugj', '', 'logged out'), ('PDA8F', 'bnmbkiu', 'vhfgh', '', ''), ('PDlY', 'dsxeds', 'xcvxgf', '', 'logged out'), ('PDMNa', 'Brian Willy', 'Aine', 'bugz', 'logged in'), ('PDsNn', 'Barry', 'Harry', 'UMU', 'logged out'), ('PDIRi', 'gfcdshg', 'cgffgjhg', 'nams', 'logged out'), ('PDgEJ', 'Moses', 'Kizito', 'Namilyango', 'logged out'); -- -------------------------------------------------------- -- -- Table structure for table `vcfiftytwo` -- CREATE TABLE IF NOT EXISTS `vcfiftytwo` ( `vcid` varchar(20) NOT NULL, `fname` varchar(20) NOT NULL, `lname` varchar(20) NOT NULL, `title` varchar(50) NOT NULL, `level` varchar(15) default NULL, `status` varchar(15) default NULL, PRIMARY KEY (`vcid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `vcfiftytwo` -- INSERT INTO `vcfiftytwo` (`vcid`, `fname`, `lname`, `title`, `level`, `status`) VALUES ('0782644698270452', 'Big', 'Brother', 'administrator', NULL, 'logged out'), ('PDTSK', 'cvbnnv', 'cgffgjhg', 'ed', 'assistant', 'logged out'), ('PDGOU', 'oom', 'oom', 'oom', 'assistant', 'logged out');