COMP SCI 1105 - Web & Database Computing

North Terrace Campus - Semester 2 - 2015

A modern introduction to designing and creating web-based applications. The course covers client-server architecture, database fundamentals and the principles behind writing software that functions over networks. Widely used web development languages and environments are compared and will be used by students to implement their own applications.

  • General Course Information
    Course Details
    Course Code COMP SCI 1105
    Course Web & Database Computing
    Coordinating Unit School of Computer Science
    Term Semester 2
    Level Undergraduate
    Location/s North Terrace Campus
    Units 3
    Contact Up to 6 hours per week
    Available for Study Abroad and Exchange Y
    Incompatible COMP SCI 2002
    Course Description A modern introduction to designing and creating web-based applications. The course covers client-server architecture, database fundamentals and the principles behind writing software that functions over networks. Widely used web development languages and environments are compared and will be used by students to implement their own applications.
    Course Staff

    Course Coordinator: Dr Amali Weerasinghe

    Course Timetable

    The full timetable of all activities for this course can be accessed from Course Planner.

  • Learning Outcomes
    Course Learning Outcomes
    1. An understanding of the architecture of web applications including:
      • the roles of clients and servers
      • the use of protocols for interaction
    2. An ability to design interfaces following UI design principles

    3. An understanding of the structuring, storage and retrieval of data from databases and the language used to interact with databases.

    4. An understanding of basic security and confidentiality concerns in the development of web applications

    5. The ability to source, analyse and interpret online documentation (APIs, tutorials)
    6. An ability to implement a program that makes use of key components of web applications:
      • user interface with client side programming
      • server side programming
      • data interchange formats
      • storing and extracting data from a database
      • use of public APIs for interacting with other sources of web data
    University Graduate Attributes

    This course will provide students with an opportunity to develop the Graduate Attribute(s) specified below:

    University Graduate Attribute Course Learning Outcome(s)
    Knowledge and understanding of the content and techniques of a chosen discipline at advanced levels that are internationally recognised. 1,3,6
    The ability to locate, analyse, evaluate and synthesise information from a wide variety of sources in a planned and timely manner. 5,6
    An ability to apply effective, creative and innovative solutions, both independently and cooperatively, to current and future problems. 1,2,3,4,5,6
    Skills of a high order in interpersonal understanding, teamwork and communication. 5
    A proficiency in the appropriate use of contemporary technologies. 1,2,3,4,5,6
    A commitment to continuous learning and the capacity to maintain intellectual curiosity throughout life. 5
    A commitment to the highest standards of professional endeavour and the ability to take a leadership role in the community. 4,5
    An awareness of ethical, social and cultural issues within a global context and their importance in the exercise of professional skills and responsibilities. 4
  • Learning Resources
    Required Resources
    All resources used for the course are freely available online.  Please see course online site for details
    Recommended Resources
    This course involves the use of:

    javascript
    html
    css
    json
    node.js / express framework
    mysql (sql)
    third party APIs - e.g. google maps, facebook graph

    Free online tutorials are available for all of these and are linked from the main course site.  If you prefer to have hard copy books, you may wish to purchase introductory books on the above.

    We do not have a specific recommendation - there are many to choose from.  If unsure, we recommend looking at reviews at online book sales sites.
    Online Learning
    This course involves significant online activities both within and outside of contact time.  We request you bring a device with internet access to all scheduled activities.

    Full details of the course including all assessments, notes, schedule, etc can be found by following the appropriate semester link at http://cs.adelaide.edu.au/users/first/wdc/
  • Learning & Teaching Activities
    Learning & Teaching Modes
    This course follows a "blended learning" model, which means you will be learning both online and in face to face activities.

    Peer learning is encouraged and you will be given clear guidance on which activities you can work with another student and which activities must be done on your own.
    Workload

    The information below is provided as a guide to assist students in engaging appropriately with the course requirements.

    As a 3-unit course, you are expected to devote 10-12 hours each week to the course.  The workload is spread evenly across the semester and you are responsible for allocating your time so that you are able to keep up with the course.

    As the material does build, it is critical that you do not fall behind and if you find yourself falling behind take action urgently.  If you are unsure what to do to catch up, speak to your lecturer who can assist you with planning, but you must do this early.  Don't plan to catch up during breaks - this seldom works.

    Each week you are expected to:

    1) attend lectures (3 hours per week)
    2) attend tutorial (1 hour every fortnight starting week 3)
    3) attend practical sessions (2 hours per week starting week 2)

    The remaining 4-7 hours each week (depending on whether prac/tutes are on) will be spent in online reading, online tutorial exercises and working on practical milestones.


    Learning Activities Summary
    Lectures - these will vary between informational, problem solving activities, feedback and practice.  Student progress will be monitored and student feedback taken to identify particular areas to revise or discuss during lectures.

    Tutorials - tutorials will be an opportunity to present and discuss work in a small group setting.  feedback can be used to improve the design and implementation of practical work as well as clarify concepts.

    Practicals - practical sessions are an opportunity to have practical work marked off, ask questions related to application design and implementation and a dedicated time to work on peer activities.

    Online activties - reading, online exercises will be assigned each week and are to be completed outside the scheduled class times.
  • Assessment

    The University's policy on Assessment for Coursework Programs is based on the following four principles:

    1. Assessment must encourage and reinforce learning.
    2. Assessment must enable robust and fair judgements about student performance.
    3. Assessment practices must be fair and equitable to students and give them the opportunity to demonstrate what they have learned.
    4. Assessment must maintain academic standards.

    Assessment Summary
    Practical milestones - 20% (each milestone is equally weighted) group assessment
    Practical exams - 10%
    Final Exam - 70%
    Assessment Related Requirements
    There is a 25% reduction in the maximum mark available for each day late. After 4 days, the mark is capped at 0.

    The only exception to the above is on Medical or Compassionate grounds with a formal application.  The forms and details of evidence required can be found at: http://www.adelaide.edu.au/student/exams/mod_arrange.html

    The form, or equivalent information and evidence, should be e-mailed to the course coordinator.
    Assessment Detail
    Practical Milestones - 20%

    This course involves the development of a web application over the course of the semester.   The development is expected to be done in pairs and is group assessed.

    Milestones are outlined in the course schedule.  Each of the milestones represents ability in a key learning outcome:
    1. Interface design (HTML, CSS, UI)
    2. Client side interaction (javascript)
    3. Server side interaction (node.js)
    4. Database (SQL) and data interchange (json)
    5. API interaction (google maps)
    6. Testing and review
    Practical Exams - 10%

    Practical exams will be held during practical sessions.  The practical exams are summative assessment of the learning outcomes of practicals.

    Final exam - 70%

    The final exam will be held during the University examination period.  The final exam will assess aspects across all the learning outcomes.
    Submission
    Submission will be through one of two forms:

    Moodle site:

    There will be hand in links for each assessment on the course Moodle site to submit your work.

    Web Submission System
    https://cs.adelaide.edu.au/services/websubmission/index.php?menu=Navigation

    Code which is automatically evaluated will be submitted through the web submission system.

    Each assessment item will state how to submit.
    Course Grading

    Grades for your performance in this course will be awarded in accordance with the following scheme:

    M10 (Coursework Mark Scheme)
    Grade Mark Description
    FNS   Fail No Submission
    F 1-49 Fail
    P 50-64 Pass
    C 65-74 Credit
    D 75-84 Distinction
    HD 85-100 High Distinction
    CN   Continuing
    NFE   No Formal Examination
    RP   Result Pending

    Further details of the grades/results can be obtained from Examinations.

    Grade Descriptors are available which provide a general guide to the standard of work that is expected at each grade level. More information at Assessment for Coursework Programs.

    Final results for this course will be made available through Access Adelaide.

  • Student Feedback

    The University places a high priority on approaches to learning and teaching that enhance the student experience. Feedback is sought from students in a variety of ways including on-going engagement with staff, the use of online discussion boards and the use of Student Experience of Learning and Teaching (SELT) surveys as well as GOS surveys and Program reviews.

    SELTs are an important source of information to inform individual teaching practice, decisions about teaching duties, and course and program curriculum design. They enable the University to assess how effectively its learning environments and teaching practices facilitate student engagement and learning outcomes. Under the current SELT Policy (http://www.adelaide.edu.au/policies/101/) course SELTs are mandated and must be conducted at the conclusion of each term/semester/trimester for every course offering. Feedback on issues raised through course SELT surveys is made available to enrolled students through various resources (e.g. MyUni). In addition aggregated course SELT data is available.

  • Student Support
  • Policies & Guidelines
  • Fraud Awareness

    Students are reminded that in order to maintain the academic integrity of all programs and courses, the university has a zero-tolerance approach to students offering money or significant value goods or services to any staff member who is involved in their teaching or assessment. Students offering lecturers or tutors or professional staff anything more than a small token of appreciation is totally unacceptable, in any circumstances. Staff members are obliged to report all such incidents to their supervisor/manager, who will refer them for action under the university's student’s disciplinary procedures.

The University of Adelaide is committed to regular reviews of the courses and programs it offers to students. The University of Adelaide therefore reserves the right to discontinue or vary programs and courses without notice. Please read the important information contained in the disclaimer.