Past questions: Programming for the Web (Year 12)

1: Identifies the correct answer.

Ensuring that parties exchanging information are who they claim to be

1: Identifies the correct answer.

Blue background, white text, border around the heading

1: Correctly matches each characteristic to the appropriate approach.

(1) ORM only. (2) Both ORM and SQL. (3) ORM only.

3: Compares the use of a PWA with an interactive website for the weather app. 2: Outlines features of a PWA and/or interactive website. 1: Identifies a feature of a PWA or an interactive website.

Both PWAs and interactive websites are platform-independent, allowing users to access the app on any device with a browser. PWAs can pre-cache updates to enable offline updates when a stable internet connection is not available but may not provide real time updates for the most recent changes to weather or warnings. Meanwhile, interactive websites require a constant internet connection to provide any updates.

3: Outlines TWO ways, other than a PWA, to minimise load time. 2: Outlines ONE way, OR identifies TWO ways. 1: Some relevant information.

One way would be to provide the option to select lower resolution images or text only display. Another way would be to utilise caching as this would provide high speed access to commonly requested weather data.

3: Explains how metadata and data mining can be used to prevent technical difficulties during the broadcast. 2: Outlines how metadata AND/OR data mining can be used. 1: Identifies a feature of metadata or data mining.

Metadata describes the content, structure and meaning of raw data, enabling more effective, accurate and efficient data mining. Data mining identifies user preferences and viewing patterns from large datasets, helping streaming services personalise recommendations and identify times of predicted high demand. Streaming service management uses this along with real-time user data to balance server loads and deliver smooth playback experiences.

4: Correct SQL query that extracts 'Pending' and 'Escalated' jobs for the 'Software' and 'Hardware' categories, counts the jobs for each status in each category, and outputs results in descending order. 3: Addresses most requirements. 2: Some understanding of the problem. 1: Some understanding of SQL or the problem.

SELECT Category, Status, COUNT(JobID) AS Jobs FROM Issues WHERE (Status = 'Pending' OR Status = 'Escalated') GROUP BY Status, Category ORDER BY Jobs DESC

3: Explains why server-side web programming is needed, with examples from the scenario. 2: Outlines some features, with examples. 1: Identifies a feature and/or relevant examples.

Server-side development will need to be used to provide dynamic information to the front-end (website). There are many dynamic aspects to the website, including the menu which changes along with subscription information and order tracking information. Server-side scripting will need to be written to read the relevant information from storage (most likely, a database) and then provide this information to the front-end.

1: Identifies the correct answer.

A protocol for email transmission

1: Identifies the correct answer.

Popularity of the framework on social media

3: Explains how a developer could test a website for cross-platform compatibility. 2: Outlines how, OR identifies strategies. 1: Some relevant information.

A web developer can use browser developer tools. These tools, built into most modern browsers, allow developers to simulate how their website looks and behaves on different devices and screen sizes. By using these tools, developers can identify and fix any issues related to cross-platform compatibility, ensuring that the website works well across a variety of devices and browsers.

3: Explains how load time can be improved using a PWA. 2: Outlines some features of a PWA and/or issues affecting load time. 1: Some relevant information.

A progressive web app (PWA) can improve load times by pre-caching important resources, allowing files such as image-gallery.js and video-gallery.js to be loaded into memory or cache while the rest of the page loads. PWAs also use service workers to cache resources, ensuring faster load times on repeat visits and offline functionality. Background synchronisation and background fetching can update content in the background, so users see the latest information without slowing down the initial load.

3: Describes the function of protocols in the transfer of data, with reference to a specific web protocol. 2: Describes the function OR provides an example of a web protocol and its use. 1: Some relevant information.

Protocols are important in data transfer as they establish rules for communication between devices connected to a network, such as the internet. HTTP (Hypertext Transfer Protocol) enables browsers to request web content from servers, which respond with the requested data. The protocol defines the structure of requests and the response so that data transfer can occur.

2: Outlines TWO benefits. 1: Some relevant information.

It can provide the same look and feel across the company's websites for consistency and ease of use. Separate html and CSS code can allow developers to work independently on files.

3: Correct SQL query. 2: Addresses some of the requirements. 1: Some understanding of SQL.

SELECT Products.Name AS 'Product', Suppliers.Name AS 'Supplier' FROM Products, Suppliers WHERE Products.SupplierID = Suppliers.SupplierID AND Products.Producer = 'Yumtreats' AND Products.Mass >= 50 ORDER BY Products.Name DESC

2: Correctly completes the SQL query. 1: Correctly selects at least TWO correct options.

SELECT Level, COUNT(StudentID) FROM Students GROUP BY Level;

3: Correctly selects ALL options. 2: At least FIVE options correct. 1: At least TWO options correct.

2: Correctly matches the features to the relevant protocols. 1: At least TWO features correct.

4: Explains how the load time of the web page can be improved. 3: Outlines how some issues affecting load time can be resolved. 2: Identifies issues affecting load time OR outlines how to resolve ONE. 1: Some relevant information.

The images can be resized to 640 x 480 beforehand so that the webpage does not need to load the large 4000 x 3000 images. The multiple CSS style sheets could be converted into a single .css file, reducing the number of HTTP requests the browser needs to send. If the "image-gallery.js" JavaScript file at the top of the source code loads slowly, it can be moved to the bottom just above so that it will not block the rest of the page from loading.

2: Correct output for the SQL query, including the correct ordering of the rows. 1: Some relevant information.

ProductName / ProductPrice: Discovery 1 & 2 (DVD) 26.98; The Plant (DVD) 28.00

3: Correct SQL query. 2: Substantially correct query with at least TWO of: renaming the columns; selecting the three tables; joining the tables. 1: Some understanding of renaming the columns or joining the tables.

SELECT Customers.CustName as 'Customer', Products.ProductName as 'Product', Orders.OrderQuantity as 'Quantity' FROM Products, Customers, Orders WHERE Orders.ProductID = Products.ProductID AND Orders.CustID = Customers.CustID ORDER BY Orders.OrderID ASC