Skip to main content
SpringerLink
Log in
Book cover

International Conference on Computer Supported Education

CSEDU 2014: Computer Supported Education pp 258–271Cite as

Extending the Database Curriculum: From Design Principles to Web and Mobile Programming

  • Conference paper
  • First Online:

  • 816 Accesses

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 510))

Abstract

The importance of the World Wide Web is evident from the ubiquitous presence of web-related technologies, from database to programming, from semantic to internet of things, in all aspects of everyday life. For these reasons, providing the new generation of students a strong background is crucial for sustainable development in all countries. This work presents a case study on a teaching experience in a web programming course with an approach suitable for both high school and university students. The first part of the paper describes in detail the curriculum which focuses on small incremental steps built around the management of user login and introduces advanced topics such as transaction, stored procedures and security issues, thus laying the foundation for the application of these concepts in larger projects. Finally, on the basis of this experience, the design and reframing of the curriculum in order to include mobile development is presented.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

References

  1. National Science Foundation (US) National Science Board: Science and Engineering Indicators (2012)

    Google Scholar 

  2. Bureau of labor statistics occupational outlook handbook. http://www.bls.gov/ooh/computer-and-information-technology/information-security-analysts-web-developers-and-computer-network-architects.htm. Accessed September 2013

  3. Gundotra, V.: Google I/O 2009 Keynote Day 1 (2009). http://www.youtube.com/watch?v=S5aGZIvk&feature=channel

  4. Connolly, R.W., Miller, C.S.: Teaching web development. Spec. Issue ACM J. Trans. Comput. Educ. (2013). http://toce.acm.org/attachments/TOCE-SE-TW.pdf. Accessed August 2013

  5. CSTA Standards Task Force: K–12 Computer Science Standards Revised 2011. The College Board, Computer Science: Principles Big Ideas and Key Concepts Learning Objectives and Evidence Statements (2011)

    Google Scholar 

  6. The computing at school working group: computer science: a curriculum for schools (2012). http://www.computingatschool.org.uk/data/uploads/ComputingCurric.pdf. Accessed August 2013

  7. New Zealand Ministry of Education: Digital technology guideline, dtg.tki.org.nz (2010)

  8. Astrachan, O., Briggs, A.: The CS principles project. ACM Inroads 3(2), 38–42 (2012)

    Article  Google Scholar 

  9. Association for Computing Machinery (ACM), IEEE Computer Society: Curriculum Guidelines for Undergraduate Degree Programs in Computer Science (20 December 2013). http://www.acm.org/education/CS2013-final-report.pdf. Accessed July 2013

  10. Association for Computing Machinery (ACM), IEEE Computer Society: Information Technology 2008. Curriculum Guidelines for Undergraduate Degree Programs in Information Technology (2008). http://www.acm.org/education/curricula/IT2008%20Curriculum.pdf. Accessed August 2013

  11. Association for Computing Machinery (ACM), Association for Information Systems (AIS): IS 2010 Curriculum Guidelines for Undergraduate Degree Programs in Information Systems (2010). http://www.acm.org/education/curricula/IS%202010%20ACM%20final.pdf. Accessed August 2013

  12. Connolly, R.: 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)

    Google Scholar 

  13. Maiorana, F.: Teaching web programming: critical considerations on pedagogical approach and curriculum content. In: Proceedings of International Conference on Sport Science and Computer Science (2013)

    Google Scholar 

  14. Wang, Y.D., Zahadat, N.: Teaching web development in the Web 2.0 Era. In: Proceedings of the 10th ACM SIGITE Conference on Information Technology Education, pp. 80–86 (2009)

    Google Scholar 

  15. Maiorana, F.: Teaching web programming: an approach rooted in database principles. In: Proceedings of the 6th International Conference on Computer Supported Education CSEDU, pp. 49–56 (2014)

    Google Scholar 

  16. Grove, R.F.: Trends in teaching web-based development - a survey of pedagogy in web development courses. In: Proceedings of 3rd International Conference on Web Information Systems and Technologies, Webist, Barcelona, Spain (2007)

    Google Scholar 

  17. Park, T.H., Saxena, A., Jagannath, S., Wiedenbeck, S., Forte, A.: 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 (2013)

    Google Scholar 

  18. Elgamal, A.F., Abas, H.A., Baladoh, E.S.: An interactive e-learning system for improving web programming skills. Educ. Inf. Technol. 18(1), 29–46 (2013)

    Article  Google Scholar 

  19. Liu, Y., Phelps, G.: Challenges and professional tools used when teaching web programming. J. Comput. Sci. Coll. 26(5), 116–121 (2011)

    Google Scholar 

  20. Laverty, J.P.: Implementing a dynamic database-driven course using LAMP. Inf. Syst. Educ. J. (ISEDJ) 9(7), 33–40 (2011)

    Google Scholar 

  21. Baatard, G.: Teaching PHP with security in mind. In: Proceeding of the 5th Australian Information Security Management Conference, pp. 21–27 (2007)

    Google Scholar 

  22. Noonan, R.E.: A course in web programming. J. Comput. Sci. Coll. 22(3), 23–28 (2007)

    Google Scholar 

  23. Wang, X.: A practical way to teach web programming in computer science. J. Comput. Sci. Coll. 22(1), 211–220 (2006)

    MathSciNet  Google Scholar 

  24. Olan, M.: Web applications: a test bed for advanced topics. J. Comput. Sci. Coll. 24(3), 72–80 (2009)

    Google Scholar 

  25. Tao, Y., Plouff, C.: Work in progress: an opportunistic approach for learning web application development. In: Frontiers in Education Conference (FIE), 2010 IEEE, pp. S2D-1, IEEE (2010)

    Google Scholar 

  26. Hollingsworth, J., Powell, D.J.: Teaching web programming using the Google Cloud. In: Proceedings of the 48th Annual Southeast Regional Conference, pp. 76–80, ACM (2010)

    Google Scholar 

  27. Gousie, M.B.: A robust web programming and graphics course for non-majors. ACM SIGCSE Bull. 38(1), 72–76 (2006)

    Article  Google Scholar 

  28. Stepp, M., Miller, J., Kirst, V.: A CS 1.5 introduction to web programming. ACM. SIGCSE Bull. 41(1), 121–125 (2009)

    Article  Google Scholar 

  29. Adams, D.R.: Integration early: a new approach to teaching web application development. J. Comput. Sci. Coll. 23(1), 97–104 (2007)

    Google Scholar 

  30. Chao, J., Davey, B.: Navigating the framework jungle for teaching web application development. Issues Inf. Sci. Inf. Technol. 10, 95–109 (2013)

    Google Scholar 

  31. Giordano, D., Maiorana, F.: Teaching database: a pedagogical and curriculum perspective. In: Proceedings of the International Conference on Information and Communication Technology for Education, (ICTE) (2013)

    Google Scholar 

  32. Atzeni, P., Ceri, S., Paraboschi, S., Torlone, R.: Database Systems: Concepts, Languages and Architectures. McGraw-Hill, New Delhi (1999)

    Google Scholar 

  33. Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 6th edn. Addison Wesley, Reading (2011)

    MATH  Google Scholar 

  34. Duffy, T.M., Jonassen, D.H. (eds.): Constructivism and the Technology of Instruction: a Conversation. Psychology Press, Hove (1992)

    Google Scholar 

  35. Anderson, L.W., Krathwohl, D.R., Bloom, B.S.: A Taxonomy for Learning, Teaching, and Assessing. Longman, London (2005)

    Google Scholar 

  36. Gannod, G.C., Burge, J.E., Helmick, M.T: Using the inverted classroom to teach software engineering. In: Proceedings of the 30th International Conference on Software Engineering, pp. 777–786. ACM (May 2008)

    Google Scholar 

  37. Giordano, D.: Shared values as anchors of a learning community: a case study in information systems design. J. Educ. Media 29(3), 213–227 (2004)

    Article  Google Scholar 

  38. Giordano, D., Maiorana, F.: An interdisciplinary project in sustainable development based on modern visual programming environments and web 2.0 technologies. In: Proceedings of the 3rd Interdisciplinary Engineering Design Education Conference, IEDEC 2013, pp. 163–167 (2013)

    Google Scholar 

  39. Giordano, D., Maiorana, F.: Object oriented design through game development in XNA. In: Proceedings of the 3rd Interdisciplinary Engineering Design Education Conference, IEDEC 2013, pp. 51–55 (2013)

    Google Scholar 

  40. MySQL 5.6 Reference Manual. http://downloads.mysql.com/docs/refman-5.6-en.a4.pdf. Accessed August 2013

  41. PHP manual. http://us3.php.net/get/php_manual_en.html.gz/from/a/mirror. Accessed August 2013

  42. Maiorana, F., Giordano, D.: A constructivist approach to teaching index selection strategies and database design. In: Proceedings of the International Conference on Information and Communication Technology for Education, (ICTE) (2013)

    Google Scholar 

  43. Hundhausen, C.D., Agrawal, A., Agarwal, P.: Talking about code: integrating pedagogical code reviews into early computing courses. ACM Trans. Comput. Educ. (TOCE) 13(3), 14 (2013)

    Google Scholar 

  44. Bishop, J.L., Verleger, M.A.: The flipped classroom: a survey of the research. In: ASEE National Conference Proceedings, Atlanta, GA (June 2013)

    Google Scholar 

  45. Goodyear, P., Jones, C., Thompson, K.: Computer-supported collaborative learning: instructional approaches, group processes and educational designs. Handbook of Research on Educational Communications and Technology, pp. 439–451. Springer, New York (2014)

    Chapter  Google Scholar 

  46. Hauswirth, M.: Models and clickers for teaching computer science. In: 7th Educators’ Symposium@ MODELS 2011—Software Modeling in Education—Pre-Proceedings (2011)

    Google Scholar 

  47. Simon, B., Cutts, Q.: Peer instruction: a teaching method to foster deep understanding. Commun. ACM 55(2), 27–29 (2012)

    Article  Google Scholar 

  48. Sanders, K., Ahmadzadeh, M., Clear, T., Edwards, S.H., Goldweber, M., Johnson, C., …, Spacco, J.: The Canterbury QuestionBank: building a repository of multiple-choice CS1 and CS2 questions. In: Proceedings of the ITiCSE Working Group Reports Conference on Innovation and Technology in Computer Science Education-Working Group Reports, pp. 33–52. ACM (2013)

    Google Scholar 

  49. Broker, K., Magenheim, J.: Are there competences every computer scientist should have?. In: Global Engineering Education Conference (EDUCON), 2014 IEEE, pp. 999–1002. IEEE (2014)

    Google Scholar 

  50. Sun, Y., Lambert, D., Uchida, M., Remy, N.: Collaboration in the cloud at Google. In: Proceedings of the 2014 ACM Conference on Web Science, pp. 239–240. ACM (June 2014)

    Google Scholar 

  51. Costanzo, A., Faro, A., Giordano, D.: 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 (2013)

    Google Scholar 

  52. Sabitzer, B., Pasterk, S.: Mobile learning for COOL informatics - cooperative open learning in a vocational high school. In: Proceedings of the 6th International Conference on Computer Supported Education CSEDU, Barcellona, Spain, pp. 232–238 (2014)

    Google Scholar 

  53. Cochrane, T.D.: Critical success factors for transforming pedagogy with mobile Web 2.0. Br. J. Educ. Technol. 45(1), 65–82 (2014)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Electrical, Electronic and Computer Engineering, University of Catania, Viale A. Doria, 6, Catania, Italy

    Francesco Maiorana

Authors
  1. Francesco Maiorana
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Francesco Maiorana .

Editor information

Editors and Affiliations

  1. University of Denver, Denver, Colorado, USA

    Susan Zvacek

  2. Faculdade de Engenharia da Universidade do Porto, Porto, Portugal

    Maria Teresa Restivo

  3. School of Engineering, University of Ulster, Newtownabbey, Ireland

    James Uhomoibhi

  4. School of Computing, Dublin City University, Dublin, Ireland

    Markus Helfert

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Maiorana, F. (2015). Extending the Database Curriculum: From Design Principles to Web and Mobile Programming. In: Zvacek, S., Restivo, M., Uhomoibhi, J., Helfert, M. (eds) Computer Supported Education. CSEDU 2014. Communications in Computer and Information Science, vol 510. Springer, Cham. https://doi.org/10.1007/978-3-319-25768-6_17

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-25768-6_17

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-25767-9

  • Online ISBN: 978-3-319-25768-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation