COMP SCI 2207 - Web & Database Computing
North Terrace Campus - Semester 1 - 2024
-
General Course Information
Course Details
Course Code COMP SCI 2207 Course Web & Database Computing Coordinating Unit Computer Science Term Semester 1 Level Undergraduate Location/s North Terrace Campus Units 3 Contact Up to 6 hours per week Available for Study Abroad and Exchange Y Prerequisites COMP SCI 1102, COMP SCI 1202, COMP SCI 2009, COMP SCI 2202 or (COMP SCI 1013 and COMP SCI 1015) Incompatible COMP SCI 1003, COMP SCI 1105, COMP SCI 2002 Assessment Written exam and/or assignments Course Staff
Course Coordinator: Manish Gupta
Course Timetable
The full timetable of all activities for this course can be accessed from .
-
Learning Outcomes
Course Learning Outcomes
On successful completion of this course students will be able to:
1 Understand and apply web application architecture 2 Design and implement accessible and user friendly graphical user interfaces 3 Manipulate data from databases and web applications 4 Identify and discuss basic security and confidentiality issues in the development of web applications 5 Interpret online web programming documentation (e.g., APIs) 6 Design and implement a web application
The above course learning outcomes are aligned with the Engineers Australia .
The course is designed to develop the following Elements of Competency: 1.1 1.2 1.3 1.4 1.5 1.6 2.1 2.2 2.3 3.2 3.3 3.6
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) Attribute 1: Deep discipline knowledge and intellectual breadth
Graduates have comprehensive knowledge and understanding of their subject area, the ability to engage with different traditions of thought, and the ability to apply their knowledge in practice including in multi-disciplinary or multi-professional contexts.
1-6 Attribute 2: Creative and critical thinking, and problem solving
Graduates are effective problems-solvers, able to apply critical, creative and evidence-based thinking to conceive innovative responses to future challenges.
1,2,3,5,6 Attribute 3: Teamwork and communication skills
Graduates convey ideas and information effectively to a range of audiences for a variety of purposes and contribute in a positive and collaborative manner to achieving common goals.
2,6 Attribute 4: Professionalism and leadership readiness
Graduates engage in professional behaviour and have the potential to be entrepreneurial and take leadership roles in their chosen occupations or careers and communities.
2,4,6 Attribute 5: Intercultural and ethical competency
Graduates are responsible and effective global citizens whose personal values and practices are consistent with their roles as responsible members of society.
2,4,6 Attribute 6: Australian Aboriginal and Torres Strait Islander cultural competency
Graduates have an understanding of, and respect for, Australian Aboriginal and Torres Strait Islander values, culture and knowledge.
2,4,6 Attribute 7: Digital capabilities
Graduates are well prepared for living, learning and working in a digital society.
1-5 Attribute 8: Self-awareness and emotional intelligence
Graduates are self-aware and reflective; they are flexible and resilient and have the capacity to accept and give constructive feedback; they act with integrity and take responsibility for their actions.
2,4,6 -
Learning Resources
Required Resources
Students will need access to a computer capable of and configured for running Docker.
All required learning resources for this course will be provided online via the MyUni platform.
Recommended Resources
Interactive Textbook from zyBooks; Signup details available in MyUniOnline 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 https://myuni.adelaide.edu.au -
Learning & Teaching Activities
Learning & Teaching Modes
Each week's concepts are introduced through a series of short pre-recorded videos.
Building on these, the course has two contact activities: lectures and workshops.
Lectures are delivered live online and provide opportunity to engage with the concepts through interactive demonstrations and discussion of web systems, databases and other material. You should expect to attend all of these and participate in small discussions and activities.
Workshops are are an in-lab activity session where you can seek assitance with course concepts, work on the weekly assignments or work on your group project, while receiving feedback from workshop supervisors who are stationed around the lab area. Completing the practical tasks will help set you up to successfully complete the project and final assessment.Workload
The information below is provided as a guide to assist students in engaging appropriately with the course requirements.
Students are expected to spend 10-12 hours per week on this course.
There will be 3-4 hours contact time for learning and teaching activities and students will be working in groups and individually 7-8 hours to carry out the required learning and teaching activities for acquiring the expected knowledge, understanding, and skills in this course.
Learning Activities Summary
Each week consists of approximately 1 hour of concept videos, a 1-2 hour live lecture/discussion and a 1-hour workshop session. Subsequent weeks build on the concepts from earlier weeks.
The outline of course content is:
Week 1: Introduction to HTML Week 2: Style and CSS Week 3: Client Side JavaScript and DOM Week 4: Client-Server interactions and architecture Week 5: Relational Database Schemas and SQL Week 6: UX and Accessibility Week 7: Client-side frameworks and APIs Week 8: Server-side architecture and requests Week 9: Authentication and Server-side APIs Week 10: Web Application Database Integration Week 11: Web Security Week 12: Web Application Architecture and Review -
Assessment
The University's policy on Assessment for Coursework Programs is based on the following four principles:
- Assessment must encourage and reinforce learning.
- Assessment must enable robust and fair judgements about student performance.
- Assessment practices must be fair and equitable to students and give them the opportunity to demonstrate what they have learned.
- Assessment must maintain academic standards.
Assessment Summary
Assessment Task Weighting (%) Individual/ Group Formative/ Summative Due (week)* Hurdle criteria Learning outcomes CBOK Alignment** Weekly Quizzes: 5 Individual Formative & Summative weekly 1, 3, 4, 5 1.1, 1.2, 3.1, 3.2, 4.1 Practical Assignments: 20 Individual Formative & Summative weekly 1 - 6 1.1, 1.2, 3.1, 3.2, 4.1, 4.3, 4.4 Web Application Project: 30 Group Summative 9, 13 2, 3, 5, 6 1.1, 1.2, 3.1, 3.2, 4.1, 4.3, 4.4 Take-home Assessment: 45 Individual Summative 14 40% 1 - 4 1.1, 1.2, 3.1, 3.2, 4.1, 4.4, 5.4 Total 100
This assessment breakdown complies with the University's Assessment for Coursework Programs Policy.
This course has a hurdle requirement. Meeting the specified hurdle criteria is a requirement for passing the course.
**CBOK is the Core Body of Knowledge for ICT Professionals defined by the Australian Computer Society. The alignment in the table above corresponds with the following CBOK Areas:
1. Problem Solving1.1 Abstraction1.2 Design
2. Professional Knowledge2.1 Ethics2.2 Professional expectations2.3 Teamwork concepts & issues2.4 Interpersonal communications2.5 Societal issues2.6 Understanding of ICT profession
3. Technology resources3.1 Hardware & Software3.2 Data & information3.3 Networking
4. Technology Building4.1 Programming4.2 Human factors4.3 Systems development4.4 Systems acquisition
5. ICT Management5.1 IT governance & organisational5.2 IT project management5.3 Service management5.4 Security managementAssessment Related Requirements
*Hurdle Requirement: If your overall mark for the course is greater than 45 F but, your mark for the take-home assessment is less than 40%, your overall mark for the course will be reduced to 45 F.Assessment Detail
Weekly Quizzes are short weekly knowledge check quizzes, each contributing 0.5% to the final grade, with the best 10 scores used.
Practical Assignments are programming and web development activities to practice concepts from each week's topics, each contributing 1-4% to the final course grade.
The Web Application Project is group project in which group members bring together and apply their knowledge and experience to plan and develop a complete web application.
The take-home assessment is a take-home-exam style assessment done over a 32h timeframe with theory and practical questions from across the course content.Submission
Submission details for all activities are available in MyUni but the majority of your submissions will be online and may be subjected to originality testing through Turnitin or other mechanisms. You will receive clear and timely notice of all submission details in advance of the submission date.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 .
-
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
- Academic Integrity for Students
- Academic Support with Maths
- Academic Support with writing and study skills
- Careers Services
- Library Services for Students
- LinkedIn Learning
- Student Life Counselling Support - Personal counselling for issues affecting study
- Students with a Disability - Alternative academic arrangements
-
Policies & Guidelines
This section contains links to relevant assessment-related policies and guidelines - all university policies.
- Academic Credit Arrangements Policy
- Academic Integrity Policy
- Academic Progress by Coursework Students Policy
- Assessment for Coursework Programs Policy
- Copyright Compliance Policy
- Coursework Academic Programs Policy
- Intellectual Property Policy
- IT Acceptable Use and Security Policy
- Modified Arrangements for Coursework Assessment Policy
- Reasonable Adjustments to Learning, Teaching & Assessment for Students with a Disability Policy
- Student Experience of Learning and Teaching Policy
- Student Grievance Resolution Process
-
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鈥檚 disciplinary procedures.
The 成人大片 is committed to regular reviews of the courses and programs it offers to students. The 成人大片 therefore reserves the right to discontinue or vary programs and courses without notice. Please read the important information contained in the disclaimer.