Unit 15 – Software Development
This page describes creating a basic website that links to a database, allowing the user to book tables at a restaurant for a specific date. It does not cover aesthetic concerns. These can be found in the unit on website development.
It filters the list of tables offered to users so that two people can’t book the same table at the same time, and offers a ‘reservations’ view, so that a user can view their reservations.
It also implements a user/password scheme; without this, it would not be possible to log on to the site and record who was making the booking.
A couple of keywords that are important to this:
- Session variables – a website is different to an application, in that variables cease to exist once the page is served to a user. This makes tracking things between pages difficult. The solution is to use session variables: variables that are stored on the web server, and kept between successive page requests. A separate copy of the variables is stored for each user of the website.
- OleDb – a technology that allows any data source to be queried as if it was a database. In this example we are using an Access database as the datastore, and using OleDb to connect to it.
- Database/persistence – you will need to use some form of database to ensure data persistence. Without it, booking details would be lost.
The information below applies to an ASP.NET WebForms project, using C#.
Structure of database
The database contains a table for each entity being tracked. For the restaurant, we are interested in: customers, tables, and bookings. Therefore we have three tables to store our data, each with a primary key. See the access file for exact details.
This is the first page that appears when the website is visited. It contains two text boxes for the username and password, and a button which the user can click in order to validate their credentials.
This page shows the user a list of all bookings they have made, which is displayed as a table within a DIV element on the page. It also contains a button which when clicked directs the user to the MAKE BOOKING page.
This is the most complex page; it allows the user to pick when they are looking to make a booking, and it then lists the tables available, which is the list of tables in the restaurant, but not including any that already have a booking for the current date. AutoPostback is enabled on the calendar (properties in VS), which allows the code to be run every time the date is changed, resulting in an up to date list of available tables.
The page contains a calendar item for selecting the date, and a dropdown list called DropDownList1 which is used to hold the details of the available tables.
Issues and implications of web coding
The request-response model
Uses, applications and implications of client side processing and scripting
Uses, applications and implications of server side processing and scripting
You may find the W3Schools website helpful if you get stuck on the HTML or CSS sections.
An HTML course for beginners.
A CSS course for beginners.
Rename the file as a .zip file, and extract.
CSS for animation
Web technologies, ai in healthcare, cyberattacks – preying on coronavirus panic.
Search code, repositories, users, issues, pull requests...
We read every piece of feedback, and take your input very seriously.
Use saved searches to filter your results more quickly.
To see all available qualifiers, see our documentation .
Computing Unit 15 Assignment 2
Folders and files, repository files navigation, unit 15 assignment 2.
This is no-longer maintained and the business it describes (HBWS) is entirely fictional.
This branch is no-longer in sync with master and contains out-of-date information. It was a test to try different images on the home page that was scraped before submission.
This branch does not contain the same disclaimers as master (the current branch) so is not hosted on gh-pages.
This branch is no-longer in sync with master and was created during the early development stages of this website.
It contains another take on the design of my information pages (i.e /pages/about.html) - it was scrapped in favour of the current (seen in this branch) after asking class mates for their opinions.
Unit 15 assignment 2 (Information that needs to be on the website …
- Designs for the web site
- A profile for the company itself
- Profiles of existing trainee web developers
- Job specifications and required qualifications
- An online application form
- Links to web development courses
- Identify user requirements
- Visual designs for the pages
- Alternative design options
- Technical documentation
- Justifications of the design decisions
- Annotated screen shots of the completed web site
- Evidence of testing including test plans and data, user feedback and details of the changes made in response to testing
- Annotated screen shots of the optimised web site
- Evaluation of the design and development of the web site
- Evidence of individual responsibility, effective time-management including a time plan and witness testimony from your tutor.
- Outline of the logo
- In Between the outline and the bean
- The hot bean itself
- Large logo is 465px x50
- Small logo is 150px x 150px
- Top half should be navigation bar
- Middle should be basic information
- Sides should either be colour / images or plain to make it look simple
- Tahoma Bold
The Computing Tutor
"inspiring students to succeed".
100% Student Pass Rate at AQA A Level!
STEM Learning Support Specialist in GCSE Maths, L2 & L3 BTEC IT and A Level Computer Science. Online 1:1 support available to the whole of the UK!
NEW ARRIVAL! A Complete Scheme of Work Resource for the
Level 3 BTEC IT Unit 2 Exam Parts A and B
The BTEC Computing Unit 15 Website Development is an optional unit for all certification levels from the Extended Certificate upwards
Here is a complete 35 Lesson scheme of work for the BTEC Computing Unit 15 Website Development.
The Scheme of Work includes a brand new scenario that students can use to practice the coursework requirements for Learning Aim B and C before attempting the Assignment.
The resources include: Learning Aim A Lessons covering all specification content theory including: • Class tasks covering the purpose and requirements of websites. • Class tasks covering the principles of website design. • Class Tasks on media, obejcts and the golden ratio. • Class tasks on SEO. • Class tasks on factors affecting website performance. • Offline web archives of the lesson exercise websites. • Consistent use of website examples within the lessons to promote student understanding. • Lots of practice questions with suggested answers.
Learning Aim B Lessons covering all specification content theory including: • How to create a problem definition statement with suggested Answers. • How to design a website to support a given scenario with suggested Answers. • How to review and refine website designs with suggested Answers. • How to create a test plan for the example scenario with suggested answers. • A new scenario with full worked answers is included for students where they can practice their design & documentation skills before attempting the assignment. • Lessons on basic HTML including: • Introduction to HTML • Coding inline Styles • HTML Navigation • Page layout using tables • Page layout using DIVS • Use of multimedia • Simple form operations Each lesson contains numerous worked examples and suggested code solutions.
Each lesson includes: • A teacher presentation with learning objectives, lesson content and end of lesson review. • A range of class tasks, from worked examples to discussion activities. • Student Worksheets for all class tasks. • Suggested answers for the class tasks to encourage and promote discussion and further learning. • Resource links to relevant websites and videos that can be used in lesson.
Also included is a full outline Scheme of Work for all suggested 35 lessons, which includes: • Learning objectives. • Lesson overview. • Assessment opportunities. • EDI considerations. • Homework suggestions. • A format that can be used for SLT inspections. • Teacher notes on resource content with suggested ideas for unit delivery
BTEC Computing Unit 15 Complete Scheme of Work
Due to the long file names generated by the creation of offline web archive files, to ensure that the dowload extracts successfully, the file should be unpacked at a root directory location. Please see your IT department.