Teaching Web Programming - An Approach Rooted in Database Principles

Francesco Maiorana

Abstract

The World Wide Web has become a medium not only for delivering information but also for providing applications that can be used by a variety of instruments, including mobile devices. For these reasons the importance of teaching these skills as well as the difficulties of organizing a vast amount of concepts and technologies in a fast-paced environment driven by strong industrial interest and competition are widely recognized. This work discusses a case study on teaching web programming, presenting an approach suitable for both high school and university courses. The main innovation of the curriculum is the content presentation, which focuses on small incremental steps, spanning the majority of term lab sessions, as well as a teaching a case study which centres on user login management. The case study covers all the major topics in web programming and teaches students to develop, as well as apply and integrate, major database concepts such as transactions, stored procedures and security issues. This lays the foundation for developing a larger project, which is suggested as the final step of the curriculum.

References

  1. Adams, D. R., 2007. Integration early: a new approach to teaching web application development. Journal of Computing Sciences in Colleges, Vol. 23, No. 1, pp. 97-104.
  2. Anderson, L. W., Krathwohl, D. R., Bloom, B. S., 2005. A taxonomy for learning, teaching, and assessing. Longman.
  3. Association for Computing Machinery (ACM), Association for Information Systems (AIS). IS 2010 Curriculum Guidelines for Undergraduate Degree Programs in Information Systems. Retrieved on August 2013 from http://www.acm.org/education/ curricula/IS%202010%20ACM%20final.pdf.
  4. Association for Computing Machinery (ACM), IEEE Computer Society. Information Technology 2008. Curriculum Guidelines for Undergraduate Degree Programs in Information Technology. Retrieved on August 2013 from http://www.acm.org/education/ curricula/IT2008%20Curriculum.pdf.
  5. Astrachan, O., Briggs, A., 2012. The CS principles project, ACM Inroads, Vol 3, No. 2, pp. 38-42.
  6. Atzeni, P., Ceri, S., Paraboschi, S., Torlone, R., 1999. Database Systems: concepts, languages and architectures. McGraw-Hill, 1999.
  7. Baatard, G., 2007. Teaching PHP with security in mind. In Proceeding of the 5th Australian Information Security Management Conference, pp. 21-27.
  8. Bureau of labor statistics. Occupational outlook handbook. Retrieved September 2013 from http://www.bls.gov/ ooh/computer-and-information-technology/ information -security-analysts-web-developers-and-computernetwork-architects.htm.
  9. Chao, J., Davey, B., 2013. Navigating the Framework Jungle for Teaching Web Application Development. Issues in Informing Science and Information Technology, 10, pp. 95-109.
  10. Connolly, R., 2011. Awakening Rip Van Winkle: modernizing the Computer Science Web Curriculum. In Proceedings of the 16th annual joint conference on Innovation and technology in computer science education (ITICSE, 2011), pp. 18-22, ACM, 2011.
  11. Connolly, R. W., Miller, C. S., 2013. Teaching Web Development. Special Issue of the ACM Journal Transactions on Computing Education. Retrieved on August 2013 from http://toce.acm.org/attachments/ OCE-SE-TW.pdf.
  12. Costanzo, A., Faro, A., Giordano, D., 2013. WI-CITY: living, deciding and planning using mobiles in Intelligent Cities. In 3rd International Conference on Pervasive and Embedded Computing and Communication Systems, PECCS, Barcelona, INSTICC.
  13. CSTA Standards Task Force. 2011. K-12 Computer Science Standards Revised 2011. The College Board, Computer Science: Principles Big Ideas and Key Concepts Learning Objectives and Evidence Statements.
  14. Duffy, T. M., Jonassen, D. H., (Eds.), 1992. Constructivism and the technology of instruction: A conversation. Psychology Press.
  15. Elgamal, A. F., Abas, H. A., & Baladoh, E. S., 2013. An interactive e-learning system for improving web programming skills. Education and Information Technologies, 18(1), pp. 29-46.
  16. Elmasri, R. & Navathe, S., 2011. Fundamentals of Database Systems (6th Edition). Addison Wesley.
  17. Giordano, D., 2004. Shared values as anchors of a learning community: A case study in information systems design. Journal of Educational Media, 29, 3, pp. 213- 227.
  18. Giordano, D., Maiorana, F., 2013 (a). An Interdisciplinary Project in Sustainable Development Based on Modern Visual Programming Environments and Web 2.0 Technologies. Proceedings of the 3rd Interdisciplinary Engineering Design Education Conference, IEDEC 2013, pp. 163-167.
  19. Giordano, D., Maiorana, F., 2013 (b). Giordano, D., Maiorana, F., 2013. Object Oriented Design through Game Development in XNA. Proceedings of the 3rd Interdisciplinary Engineering Design Education Conference, IEDEC 2013, pp. 51-55.
  20. Giordano, D., Maiorana, F., 2013 (c). Teaching database: a pedagogical and curriculum perspective. Proceedings of the International Conference on Information and Communication Technology for Education, (ICTE), in press, 2013.
  21. Gousie, M. B., 2006. A robust web programming and graphics course for non-majors. ACM SIGCSE Bulletin, Vol. 38, No. 1, pp. 72-76.
  22. Grove, R. F., 2007. Trends in teaching web-based development - A survey of pedagogy in web development courses. Proc. 3rd International Conference on Web Information Systems and Technologies, Webist, Barcelona, Spain.
  23. Gundotra, V., 2009. Google I/O 2009 Keynote Day 1. http://www.youtube.com/watch?v=S5aGZIvk&feature =channel.
  24. Gannod, G. C., Burge, J. E., Helmick, M. T., 2008. Using the inverted classroom to teach software engineering. In Proceedings of the 30th international conference on Software engineering, pp. 777-786, ACM.
  25. Hollingsworth, J., Powell, D. J., 2010. Teaching web programming using the Google Cloud. In Proceedings of the 48th Annual Southeast Regional Conference, pp. 76-80, ACM.
  26. Laverty, J. P., 2011. Implementing a dynamic databasedriven course using LAMP. Information System Education Journal (ISEDJ), Vol. 9, No. 7, pp. 33-40.
  27. Liu, Y., Phelps, G., 2011. Challenges and professional tools used when teaching web programming. Journal of Computing Sciences in Colleges, Vol. 26, No. 5, pp. 116-121.
  28. Maiorana, F., 2013 (a). Teaching web programming: critical considerations on pedagogical approach and curriculum content, Proc. of International Conference on Sport Science and Computer Science.
  29. Maiorana, F., Giordano, D., 2013 (b). A constructivist approach to teaching index selection strategies and database design. Proceedings of the International Conference on Information and Communication Technology for Education, (ICTE), in press, 2013.
  30. MySQL 5.6 Reference Manual. Retrieved August 2013 from http://downloads.mysql.com/docs/refman-5.6- en.a4.pdf.
  31. National Science Foundation (US) National Science Board. 2012. Science and Engineering Indicators.
  32. New Zealand Ministry of Education, 2010. Digital technology guideline, dtg.tki.org.nz.
  33. Noonan, R. E., 2007. A course in web programming. Journal of Computing Sciences in Colleges, Vol. 22, No. 3, pp. 23-28.
  34. Olan, M., 2009. Web applications: a test bed for advanced topics. Journal of Computing Sciences in Colleges, Vol. 24, No. 3, pp. 72-80.
  35. Park, T. H., Saxena, A., Jagannath, S., Wiedenbeck, S., Forte, A., 2013. Towards a taxonomy of errors in HTML and CSS. In Proceedings of the ninth annual international ACM conference on International computing education research (pp. 75-82). ACM.
  36. PHP manual. Retrieved August 2013 from http://us3.php.net/get/php_manual_en.html.gz/from/a/ mirror.
  37. Stepp, M., Miller, J., Kirst, V., 2009. A CS 1.5 introduction to web programming. In ACM SIGCSE Bulletin Vol. 41, No. 1, pp. 121-125, ACM.
  38. Tao, Y., Plouff, C., 2010. Work in progress: An opportunistic approach for learning web application development. In Frontiers in Education Conference (FIE), 2010 IEEE (pp. S2D-1), IEEE.
  39. The Computing at School Working Group. Computer Science: A curriculum for schools (2012). Retrieved August 2013 from http://www.computingatschool .org.uk/data/uploads/ComputingCurric.pdf.
  40. The Joint Task Force on Computing Curricula Association for Computing Machinery IEEE-Computer Society. Computer Science Curricula 2013. Ironman Draft. Retrieved Agust 2013 from http://ai.stanford.edu/ users/zsahami/CS2013/ironman-draft/cs2013- ironman-v1.0.pdf.
  41. Wang, X., 2006. A practical way to teach web programming in computer science. Journal of Computing Sciences in Colleges, Vol. 22, No. 1, pp. 211-220.
  42. Wang, Y. D., Zahadat, N., 2009. Teaching web development in the Web 2.0 Era. In Proceedings of the 10th ACM SIGITE conference on Information technology education, pp. 80-86.
Download


Paper Citation


in Harvard Style

Maiorana F. (2014). Teaching Web Programming - An Approach Rooted in Database Principles . In Proceedings of the 6th International Conference on Computer Supported Education - Volume 2: CSEDU, ISBN 978-989-758-021-5, pages 49-56. DOI: 10.5220/0004849300490056


in Bibtex Style

@conference{csedu14,
author={Francesco Maiorana},
title={Teaching Web Programming - An Approach Rooted in Database Principles},
booktitle={Proceedings of the 6th International Conference on Computer Supported Education - Volume 2: CSEDU,},
year={2014},
pages={49-56},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004849300490056},
isbn={978-989-758-021-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Computer Supported Education - Volume 2: CSEDU,
TI - Teaching Web Programming - An Approach Rooted in Database Principles
SN - 978-989-758-021-5
AU - Maiorana F.
PY - 2014
SP - 49
EP - 56
DO - 10.5220/0004849300490056