Week01 & 02 (1/12, 1/19): Introduction, Tables, & CSS
Link to Syllabus
* Hour of code in Kahn Academy
* Intro to programming in Kahn Academy (up to coloring)
* Table
Table lecture 01
Table lecture 02
Table lecture 03
Table lecture 04
*Table resoruce files
week0102/tables/ani1.gif
week0102/tables/ani2.gif
week0102/tables/border.htm
week0102/tables/fieldset.htm
week0102/tables/sman1.gif
week0102/tables/sman2.gif
week0102/tables/table6.htm
week0102/tables/table7.htm
* CSS
CSS lecture 01
CSS lecture 02
CSS lecture 03
CSS lecture 04
*CSS resoruce files
week0102/css/back1.htm
week0102/css/back2.htm
week0102/css/bg58.jpg
week0102/css/box2.htm
week0102/css/box4.htm
week0102/css/css1.htm
week0102/css/css2.htm
week0102/css/css4.htm
week0102/css/css5.htm
week0102/css/css6.htm
week0102/css/css8.htm
week0102/css/font12.htm
week0102/css/font13.htm
week0102/css/font15.htm
week0102/css/layer3.htm
week0102/css/mystyle.css
week0102/css/sopum1.jpg
week0102/css/sopum2.jpg
week0102/css/sopum3.jpg
week0102/css/text3.htm
week0102/css/text4.htm
* CSS and onion skins
http://www.alistapart.com/articles/onionskin/ : onion skin drop down shadow
* CSS and Dreamweaver
CSS and Dreamweaver
* CSS Round Edge Background
CSS Round Edge Background
Resource Site:
http://www.devwebpro.com/25-rounded-corners-techniques-with-css/
* Free HTML editor recommendation site
http://www.techsupportalert.com/best-free-html-editor.htm
* Popular web hosting compaies used by previous students are
1and1, bluehosting, dreamhost, yahoo, hostgator, etc.
* FTP and WIYIWYG
Free HTML editor installation
How FTP works
Free HTML editor and FTP
Dreamweaver and FTP
Quiz week
Week03(1/26): HMTL, CSS, Photoshop & Illustrator, Javescript 01
* Intro to programming in Kahn Academy (up to arrays)
* http://www.codecademy.com/learn (Web Developer Skills: Make A Website. )
* free photoshop software
GIMP
* Photoshop Basics
Photoshop Basics 01
Photoshop Basics 02
* Javascript
Javascript 01
Javascript 02
* jQuery
jQuery 01
Quiz Week
Week04(2/02): Personal Project proposal
* Catch ups. * http://www.codecademy.com/learn (--> if you have never coded before, you will need to use this week to catch up coding skills. check out the language skills section and work on HTML & CSS)
Personal Project proposal due (02/02, in class)
Personal Project prototype due (02/02, in class)
* Proposal templates
Template 01
Template 02
Week05(2/09): Javescript 02
* Javascript
Javascript 03
Javascript 04
* jQuery menu
jQuery menu
* http://www.codecademy.com/learn (Make an Interactive Website)
* http://www.codecademy.com/learn (Language skill section Javascript) --> Finish Javascript lesson, Object I and II might be a bit difficult for some of you. In that case, just try to understand the concept. Within the scope of this class, I am not going to ask you to fully understand or implement the concept in your projects. But, if you like challenges, you are welcome to work on it.
Quiz week
Week06(2/16): Database & forms
* Database
Datebase 01
Datebase 02
Datebase 03
Datebase 04
* Resource files
week08/Db_Mysql_lecture.ppt
week08/access_database_test.mdb
week08/confirm.asp
week08/form.htm
* W3 School SQL
http://www.w3schools.com/sql/
* http://www.codecademy.com/learn (Learn SQL)
* Kahn Academy Hour of Databases (https://www.khanacademy.org/computing/hour-of-code/hour-of-sql/v/welcome-to-sql)
Quiz Week
Week07(2/23): PHP 01
* PHP intro
PHP intro 01
PHP intro 02
PHP intro 03
PHP intro 04
PHP intro 05
PHP intro 06
PHP intro 07
* Resource files
week10/example_01/formcgi.php
week10/example_01/index.php
week10/example_02/index.php
week10/example_02/index2.php
week10/example_03/index.php
week10/example_04/index.php
week10/example_05/index.php
week10/example_06/index.php
week10/example_07/index.php
Week08(3/01): Social Media Campaign Group Project 1
Instruction video on how to conduct GOMC in this class
Click here to view the GOMC content.
GOMC website ( https://www.google.com/onlinechallenge/ )
Advice on the role of each group member ( http://theresabclarke.com/gomc-roles )
Quiz Week (Quiz based on key points of GOMC content)
Week09(03/08): Spring recess
Spring Recess
Week10(3/15): Social Media Campaign Group Project 2
Click here to see in class project completion to-do-list.
Week11(3/22): Social Media Campaign Group Project 3
Select a couple of benchmark proposals from the previous winners and reference them to complete the pre-campaign proposal. Submit the proposal during the class.
Personal Project progress report (03/22, in class)
Group Project pre-campaign report due (03/22, in class), GOMC kicks off. --> Submit the pre-campaign report on Canvas and GOMC site.
Week12(3/29): Social Media Campaign Group Project 4
Click here to view the GOMC content.
Quiz Week (Quiz based on key points of GOMC content)
Week13(04/05): PHP2
* PHP variables
PHP variables 01
PHP variables 02
PHP variables 03
* Resource files
week11/variableExample/01.php
week11/variableExample/02.php
week11/variableExample/03.php
week11/variableExample/04.php
week11/variableExample/05.php
week11/variableExample/phpVariableExample.zip
* PHP condition
PHP condition 01
PHP condition 02
PHP condition 03
PHP condition 04
* Resource files
week11/conditionExample/01.php
week11/conditionExample/02.php
week11/conditionExample/03.php
week11/conditionExample/04.php
week11/conditionExample/05.php
week11/conditionExample/06.php
week11/conditionExample/07.php
week11/conditionExample/phpConditionExample.zip
week11/conditionExample/test.txt
* PHP function
PHP function 01
PHP function 02
PHP function 03
PHP function 04
* Resource files
week12/functionExample/01.php
week12/functionExample/02.php
week12/functionExample/03.php
week12/functionExample/04.php
week12/functionExample/05.php
week12/functionExample/06.php
week12/functionExample/06_01.php
week12/functionExample/07.php
week12/functionExample/07_01.php
week12/functionExample/08.php
week12/functionExample/09.php
week12/functionExample/10.php
week12/functionExample/11.php
week12/functionExample/12.php
week12/functionExample/13.php
week12/functionExample/14.php
week12/functionExample/15.php
week12/functionExample/16.php
week12/functionExample/17.php
week12/functionExample/18.php
week12/functionExample/19.php
week12/functionExample/20.php
week12/functionExample/21.php
week12/functionExample/22.php
week12/functionExample/23.php
week12/functionExample/24.php
week12/functionExample/phpFunctionExample.zip
PHP include
* Resource files
week12/include/bgscIncludeFunction/example/Archive.zip
* PHP include and Google analytics
PHP include and Google analytics
* http://www.codecademy.com/learn (finish PHP)
* Video lecture about PHP XML & AJAX (click here)
Quiz Week
Week14(04/12): CMS
Personal Project progress report (03/22, in class)
Group Project pre-campaign report due (03/22, in class), GOMC kicks off.
* Joomla installation
Joomla installation 01
Joomla installation 02
Joomla installation 03
Joomla installation 04
* Word Press Installation
Word Press installation
Word Press Multiple domains parking in subfolder installation
Word Press Theme installation
Change Home page on Word Press 01
* http://www.codecademy.com/learn (Make A Rails App)
* phpBB installation
phpBB installation 01
phpBB installation 02
phpBB installation 03
phpBB installation 04
phpBB installation 05
phpBB installation 06
phpBB installation 07
phpBB installation 08
phpBB installation 09
* Word Press modification
Change home page on Word Press 02
Week15(04/19): Social Media Campaign Group Project 5
GOMC presentation and preparation for post-campaign report
Week16(04/26): Personal and group project presentations
Personal project presentations.
Personal and group project due (05/03, Midnight)
Extra Credits (Google analytics academy), due on May 3rd.
* How to get extra credits
* Google analytics academy
Project cases
* Bowling Green Skating Club Website
* CSS and Dreamweaver
* BG High School Theatre Project social media campaign
Extra topics
Personal and group project 2nd review due (04/19, in class)
* rss Builder from source forge
rss builder 01
rss builder 02
rss builder 03
rss builder 04
* rss php update
rss php update 01
rss php update 02
rss php update 03
rss php update 04
rss php update 05
rss php update 06
rss php update 07
rss php update 08
rss php update 09
rss php update 10
rss php update 11
rss php update 12
rss php update 13
rss php update 14
rss php update 15
rss php update 16
rss php update 17
rss php update 18
* Resource files
week15/002_rss_php_update/example/checkIn.php
week15/002_rss_php_update/example/index.php
week15/002_rss_php_update/example/rssPHPUpdateSource.zip
week15/002_rss_php_update/example/feedupdate/feedDelete.php
week15/002_rss_php_update/example/feedupdate/feedDeleteForm.php
week15/002_rss_php_update/example/feedupdate/feedModify.php
week15/002_rss_php_update/example/feedupdate/feedModifyForm.php
week15/002_rss_php_update/example/feedupdate/feedPost.php
week15/002_rss_php_update/example/feedupdate/feedPostForm.php
week15/002_rss_php_update/example/feedupdate/index.php
week15/002_rss_php_update/example/include/include.admin.session.php
week15/002_rss_php_update/example/include/include.connect.db.php
* Rss parser
rss parser in php
* Rss parser in Wordpress
Implementing rss parser in Wordpress