Introduction to web and software development


Dates:
Start: 23 Mar 2019      End: 30 Apr 2019
Duration:
4 intensive onsite whole-day lectures and tutorials on Saturdays and/or Sundays. Offline work and teacher assessments take place in between classes.
Locations:
Lagos: King's College, Lagos. 3 Catholic Mission Street, Lagos, Nigeria
Kano: TBA
Entry Requirements:
There are no Academic requirements for this course
Course Materials:
Students are encouraged to attend the class with their own laptops as additional costs would apply for use of in-house computers. Furthermore, students are required to do off-site tutorials which would require the use of a computer.
Fee: ₦0.00
Detailed information:
Basic Training: For people who would like to have a good grounding in Internet technologies, web building and/or software development. This course does not involve any examinations or issue any certification.

It is ideal for: Enthusiasts who would like to know more about building and software development; Company bosses and managers who would want a better understanding of IT and how it can be applied to their business. Students who would like to use this as a stepping stone for a certification or a degree course etc etc.
Click for full course schedule >> *** Week 1: HTML/CSS (FRONT END) ****
(0) Introducing the tutors
(1) What the course covers
(2) What materials are required and what you get from the course
(3) Brief history of HTML and browsers
(4) BROWSER WARS: IE Vs the others
(4) Question and answer session
(5) Structure of the basic HTML page (HTML tags only. No JavaScript or CSS etc) [OO]
(6) Basic 'Hello World page' [OO]
(7) HTML Links [OO]
(8) HTML Forms [OO]
(9) HTML Images [OO]
(10) Advanced HTML tags [OO]
(11) Question and answer session
(12) Introduction to CSS
(13) Inline CSS
(14) Internal CSS
(15) Classes, IDs, DIVs and Styles
(16) External CSS and why they are useful
(17) Precedence in CSS conflicts commands (ie which one hold sway when there is a conflict)
(18) Comments for HTML and CSS!!!!
(19) colours: just 'search HTML colour codes' in Google ** or go to: http://htmlcolorcodes.com/
(20) Debugging with chrome
(21) Question and answer session
(22) Tools: The importance of text editors: all students to download and install Notepad++ and view all their pages on it.
(23) Homework 1: give students a list of HTML and CSS tags to study, test and understand
(24) Homework 2: give students a pdf of a basic HTML/CSS page that they must replicate and upload for assessment before the next class [VA TO DO]
* use something with forms etc etc....




*** Week 2: JAVASCRIPT (FRONT END) ****
(1) Tutorial: resolve any problems with the HTML/CSS assignment.
(2) Question and answer session
(3) Any spillovers from last week
(4) Opening talk with graphics: the rise of responsive/Adaptive web page
(5) Build a basic responsive and/or adaptive page for mobile phones from scratch
* Lengthy, hands-on lecture. Must include: Home page; Registration page, Login page; profile page; profile amendment page; contact us page
(6) What Is JavaScript + short history?
(7) Internal and inline JavaScript
(8) External JavaScript
(9) Functions
(10) JavaScript events
(11) Creating external .js files
(12) Strings and String Methods,
(13) Arrays and Array methods,
(14) loops and breaks (important),
(15) debugging with console.log() (as opposed to alert),
(16) arguments in functions
(17) Adding event handlers outside the HTML (eg document.getElementById("myElement").onclick = myFunction ... )
DOM Object (they must be ale to use features like getEtlementById("myElement").innerHTML='xyz' )
(18) A JavaScript forms validation exercise (Use HTML page created by EC, above)
* hands-on with onBlur, onClick and name validation..
(19) Question and answer session
(20) Homework 1: give students a list of JavaScript functions to study, test and understand
(21) Homework 2: An old-style email validation exercise.




*** Week 3: PHP (BACK END) ****
(1) Tutorial: resolve any problems with the JavaScript Tutorial.
(2) Question and answer session
(3) How to publish a web page/upload files to your server
(4) FTP applications: FileZilla
(5) Your free web hosting site details
(6) Upload and view your work uploaded, on the www
(7) Local environment: Installing WampServer
(8) Brief discourse on CGI types and history: ASP, JSP, PERL, PHP
(9) PHP: Introduction to PHP. What is PHP? Why PHP?
(10) PHP in dynamic HTML pages
(11) Basic 'Hello World' page
(12) PHP core functions (eg echo, printf etc)
(13) Variables in php
(14) If statements
(15) for loops (with brief mention of other loops)
(16) Error messages in PHP
(17) More php functions (concentrate on the core/most used)
(18) Linking JavaScript (front End) with PHP (server/back end): Forms with php
(19) Question and answer session
(20) Homework 1: Give students a list of PHP functions to study, test and understand
(21) Homework 2: Give students a pdf of a basic HTML page with dynamic parts to create via php. They must replicate and upload their work for assessment before the next class




*** Week 4: PHP/MYSQL/SQL (BACK END) ****
(1) Tutorial: resolve any problems with the building of the dynamic PHP/HTML pages.
(2) Question and answer session
(3) Databases: what are databases? Why use them?
(4) A short discourse on various types.
(5) create a MySQL database with phpMyAdmin
(6) Explain data types, unique fields, primary fields etc
(7) Linking front end (JavaScript) with back end (PHP) and database (MySQL)
(8) SQL and php queries with SQL
(9) Basic SQL Queries: Select
(10) Basic SQL Queries: Insert
(11) Basic SQL Queries: Update
(12) Basic SQL Queries: Delete
(test all queries with a basic script)
(13) Common SQL errors
(14) Bringing it all together: HTML, PHP, MySQL
(15) Including back end form validation with php
(16) All students to build dynamic HTML form that allows than to insert, update, view and delete from the server
(17) using Ajax with CRUD
(18) Tips and Tools:
* Preventing the reproduction of "Head" and "Navigation"
* useful tools/libraries to build responsive/adaptive page: just a short talk on this. No teaching [EC/OO???]
(19) Question and answer session
What to expect from the course:
1) By the end of the course our students should be able to build a complete web site from end to end
2) They should understand the fundamentals of software development
3) They should have developed a basic computer game all by themselves
4) A certificate of completion will be awarded to everyone who completes the course satisfactorily
5) We will be willing to give references to potential employers for everyone who completes the course satisfactorily
6) Free web space for all students' work (students are free to use this space for up to six months after their courses)