Key facts

Type	Weekly Classes
Location	Oxford
Address	Ewert House Ewert Place Summertown OX2 7DD
Dates	Wed 16 Jan to Wed 20 Mar 2013 Day: Wednesday Time of meeting: 5.30-8.00pm Number of meetings: 10
Subject area(s)	Computing
CATS points	10
Fees	From £230.00
Application status	Course ended
Course code	O12P607COW
Course contact	If you have any questions about this course, please email ppweekly@conted.ox.ac.uk.

Overview

The Internet has changed the way people shop and traders need to be able to sell their goods online across the world. This course provides a follow-on from the Introduction to Dynamic Websites course by building an online shop onto a content-managed site.

Description

The Internet has changed the way people shop and traders need to be able to sell their goods online across the world. This course introduces the much demanded skills to build an online shop to add to content-managed website.

An intermediate 10-week course that provides hands-on practical knowledge and experience of designing and building online shops as an addition to an existing content-manage website.

This course is for students who have some experience of designing and building dynamic websites using PHP and MySQL such as that provided by the course "Introduction to Dynamic Websites".

During the course students will undertake exercises to develop their understanding and confidence with the core concepts of web development using standards based methods and tools.

Programme details

Week 1: How the Blackjack Gallery CMS operates. Use cases to map scope and boundaries. Crow’s Foot Notation. Use Dreamweaver to edit files and transfer between the desktop and the server.
Week 2: Planning the visual layout. Workflow for the purchase. Database design. Indexing. Data filtering.
Week 3: Creating an extra index. Import/export from phpMyAdmin. Auto-increment. Creating sessions. Creating inclusions. Selecting products. Showing the results.
Week 4: Common programming errors. Formatting numerical displays and real data. Displaying images dynamically. Error messages. Display of dynamic data and calculations. Updating database with user input.
Week 5: Creating bespoke functions. Defining a constant. Password encryption. Self validating forms. Confirming an email address is valid.
Week 6: Self completing forms. Delivery data. Data Protection Act. PayPal.
Week 7: Order confirmation. Passing data to PayPal. Getting success/fail return from PayPal. Destroying the session data
Week 8: Managing orders through payment, fulfilment and despatch. Automatically sending confirmation emails.
Week 9: Enabling customers to access their details.
Week 10: Security of PHP and MySQL; the challenges of guarding against cross-site scripting and SQL injection.

Staff

Course aims

Course Aims:
This course aims to teach the fundamentals of designing, developing and implementing an online shop for the Internet.

Course Objectives:
1. To further develop understanding and experience of the interaction of data, HTML and CSS
2. To further understand and experience building dynamic, data-driven web pages
3. To undertake weekly exercises applying further technologies to address the requirements of creating databases for shopping and selling on the web

Assessment methods

Student's knowledge and understanding of the course material will be assessed through coursework and two short tests during the term. The coursework will be assigned early in the course, and is expected to continue throughout the term. The coursework will account for 80% of the total assessment, with 20% being allocated to class tests.

Assessment will be based on the demonstration of skills and an understanding of the topics, and on the ability to apply these in the creation of a web implementation using appropriate technologies.

Teaching methods

All classes will comprise a powerpoint presentation introducing each topic supported with discussion of some of the major issues and practical applications. Practical work will be assigned each week and this is expected to be continued in the students' own time in preparation for subsequent weeks.

Teaching outcomes

By the end of the course students will be expected to:
1. demonstrate the ability to design and build an online shop using PHP and MySQL
2. demonstrate the key principles of database design for electronic transactions on the web
3. demonstrate knowledge and understanding of current developments in web standards and web design

Fee options

Programme Fee

EU Fee: £230.00

Non-EU Fee: £230.00

Apply for this course