3.🕸️Website Development
About
You may choose a common theme throughout this project:
develop a WEBSITE,
develop a GAME or GUI application,
create a DATABASE either connected to a Python GUI or PHP website using SQL with Dynamic Data Querying.
You must keep a Development Logbook to show Iterative Processes from your initial concept, planning, designing, and testing.
~~~ OVERVIEW | Tirohanga ~~~
This comprehensive year-long course is an immersive journey into the realms of software engineering, encompassing three major project units: website development, with the establishment of a sophisticated database connected to either a Python GUI or PHP website with SQL for dynamic data querying, game or GUI application creation. The overarching theme throughout this project-based course revolves around the development of intricate digital solutions, encouraging you to think critically and creatively as you design, code, and manage your projects.
The course is punctuated with checkpoints to keep you on track, and the culmination of this ambitious undertaking is set for the end of Term 3. You are encouraged to maintain a detailed Development Logbook, serving as a testament to their iterative processes, including initial concepts, planning, designing, and testing. This holistic approach equips you with a well-rounded skill set, preparing you for the challenges and opportunities in the dynamic field of software engineering
~~~ TIMELINE | Rārangi Wā ~~~
~~~ Exemplars of Student Projects ~~~
Rentalo Car Rental Service
by Benjamin Scott (2023), developed with ProjectSpace
Jamz - Personal Music App
by Sanithu Nakandala (2023), developed with ProjectSpace (used Figma for wireframe designs)
JHC Coffee Ordering Web App
by Michael Clincket and Forrest Lung (2023), developed with ProjectSpace
Connect a website/python to a SQL relational Database using PHP (3.3) with queries
Want to brush up on your SQL statements?
(A) Python Program - Flask/Python/sqllite
If you decide to go this route then you could do 3.8, 3.7 and this 3.3.
So you have a coffee shop? Build a python program to handle the database using Flask and sqllite. Here are some really great resources to start your journey.
The Backpack Project Video Tutorials- some Python Lists and how Flask works
(B) Dynamic Data Querying Website (PHP and mySQL)
Similar to Level 2 Database/Website course. See what's new in Internal Overview for Complex Database and Complex Website.
Internal's Overview
Complex techniques will include a selection from:
structuring the data using multiple tables or nodes
creating queries which insert, update or delete to modify data
creating customised data displays from multiple tables or nodes (e.g. reports, PDFs, web pages, dashboards, program interfaces)
dynamically linking data between the database and a front-end display
applying data access permissions as appropriate to the outcome.
Examples of complex techniques include:
non-core functionality
sophisticated digital effects
applying industry standards or guidelines
responsive design for use on multiple devices
integration of original media assets
dynamic data handling and interactivity
automation through scripts.
A complex computer program:
uses variables storing at least two types of data (e.g. numeric, text, Boolean, object)
uses sequence, selection and iteration control structures
takes input from a user, file, sensors, or other external source
produces output
uses two or more complex programming techniques.
Examples of complex programming techniques include:
programming or writing code for a graphical user interface (GUI)
reading from, or writing to, files or other persistent storage
object-oriented programming using class(es) and objects defined by the student
using types defined by the student
using third party or non-core API, library or framework
using complex data structures (e.g. stacks, queues, trees).