Course Information Undergraduate prospectus

Fundamentals of Database and Web Technologies

Course summary

Course code: COMP1021
Level: 0
Credits: 15
School: Architecture, Computing and Hums
Department: Computing and Information Sys.
Course Coordinator(s): Maria Pretorius

Specification

Pre and co requisites

None.

Aims

1. To provide students of computer related disciplines certain core computer skills to support their studies.
2. To provide students with the skills needed to create personal web pages.
3. To expose the student to database technology.
4. To give students an understanding of computer architecture

Learning outcomes

On successful completion of this course a student will be able to:

1 Be conversant with basic database concepts
2 Create their own personal World Wide Web site
3 Create simple web based multimedia effects
4 Have a good practical understanding of Personal Computer Architecture

Indicative content

• Computer skills: Web authoring: HTML basics; introduction to web authoring tools, use of GIF and JPEG.
• Database concepts: tables, primary keys, queries, referential integrity; forms and sub-forms.
• input data validation; simple code modules.
• Computer Architecture: The anatomy of a microprocessor; history of microprocessor development.
• Computer role of an operating system, I/O devices.

Teaching and learning activity

Concepts will be introduced in lectures, and demonstrated by machine based exercises and computer lab sessions. Students have a total of three contact hours per week which allows for detailed exploration of computer practical skills. For example, students have time to build their first database and first web page in a very controlled and safe environment. This creates a supportive situation for the students to share their struggles in what is otherwise often a lonely and isolating activity. Every week, students have one hour for lecture and two hours for practical work in a computer lab. Students are guided as they undertake the practical skill of building a database and personal web page. This allows student planning to take computing or maths related degree, to conduct some research into their chosen discipline. Students are guided through the process and complete tasks en route to submitting practical coursework.

Assessment

Coursework 1 - 50% weighting, 40% pass mark.
Learning outcome 1.
An individual coursework assessing learning outcomes 1. Requires the development of a database for a given scenario. The database is developed in MS Access. 1,000 words.

Coursework 2 - 50% weighting, 40% pass mark.
Learning outcomes 2, 3 & 4.
An individual coursework assessing learning outcomes 2, 3, 4. Requires the development of a website, using HTML, PHP and Java Scripting. Students are provided with a topic and have the option to develop the website with the help of a web authoring tool of their choice. 1,000 words.

Students are not required to pass all elements of assessment in order to pass the course.

Formative Assessment:
Building a database, using MS Access 2013
Website design using HTML