Dynamic Web Data Querying

HCI

Website Design

HTML/CSS

Databases

PHP with SQL

About | mō

This course is your gateway to understanding the fundamental elements of creating stunning websites. Whether you're a beginner or have some experience, this course will walk you through the basics of design principles, coding, and user experience to help you craft visually appealing and user-friendly websites. This course includes Programming with PHP and/or JavaScript. You will learn a lot of HTML and CSS to allow you to design and build a great website with a database using PHPMyAdmin to store the data.

~~~ BIG IDEAS WEBSITE and DATABASE DEVELOPMENT ~~~

The discipline of Digital Technologies embodies whanaungatanga. Outcomes are made by people, for people, within cultural, social, and environmental contexts

It's all about creating connections and relationships. In the world of video game design, this idea is essential. Games are made by people, like artists, programmers, and storytellers, for people like you, within unique cultural, social, and environmental settings. The characters, stories, and worlds in video games reflect the creativity, values, and perspectives of their creators. When you play a game, you're connecting with the minds and cultures behind it.

Digital outcomes are created for a purpose by following established processes

Every website development follows established processes. Serving as the blueprint for the creation of websites and their databases. From the initial conceptualization to the final launch, a structured approach. It involves planning, designing, coding, and testing. This ensures that each website serves its intended purpose.

The discipline of Digital Technologies embodies auahatanga. Outcomes solve problems and enhance and expand human possibilities.

In the realm of website development, auahatanga, or innovation, is at the core of every outcome. Websites are not digital platforms; they are problem-solving tools that expand human possibilities. Developers strive to create innovative solutions that address challenges and enhance experiences. By pushing the boundaries of creativity and technology, websites offer new solutions. They make tasks easier and broaden the horizons of what users can achieve.

All digital technologies are underpinned by algorithms and computer science principles

In website design, the foundation of all digital technologies lies in algorithms and computer science principles. These concepts serve as the backbone of how websites function. Algorithms, like sets of instructions, say how data is processed and displayed. Computer science principles underpin the way websites are structured, coded, and operated. Understanding these principles is crucial for web designers. It allows them to create efficient, secure, and user-friendly websites.

~~~ OVERVIEW | Tirohanga ~~~

Embark on a comprehensive journey into web development, delving into the foundational elements of CSS and HTML. The course commences with a focus on honing your design skills, incorporating Nielsen's Human-Computer Interface (HCI) heuristics to enhance the usability of websites.

As the course progresses, PHP takes center stage as a pivotal language in the world of programming, making it an ideal starting point foryou. This course is structured to teach and evaluate PHP proficiency aligned with AS92004, a qualification worth 5 credits and assessed in Term 4.

Following an exploration of your capabilities and an understanding of various website programming languages, you'll have the opportunity to conceptualize and decide on a project. Once your project idea is solidified, you'll transition into the design phase, where you'll create a Design Portfolio in preparation for Levels 2 and 3.

The subsequent phase involves transforming your design into a tangible creation. Over approximately 5 weeks, you'll meticulously plan and develop your project, continuously testing and receiving feedback to enhance its quality. Assessment of this practical phase will be conducted by your teacher, aligning with AS92004 - Develop a computer program, granting 5 credits in Term 4.

3. Website_Database Project

~~~ TIMELINE ~~~

~~~ COURSE MATERIAL ~~~

Unit 1: Nielsen's Human-Computer Interaction Heuristics

(approximately 2 weeks)

Involves applying a set of guidelines and principles to evaluate and improve the usability of digital interfaces, providing a foundation for creating user-friendly and effective interactions.

Unit 2: Website Designing and Prototyping

(approximately 1 week)

A brief yet comprehensive overview of the principles and techniques involved in creating effective website layouts and user interfaces. 

Unit 3: Learn the fundamentals of Website Development with HTML and CSS

(approximately 2 weeks)

Exploring the foundational aspects of Website Development, employing HTML and CSS through Grok Academy. 

Unit 4: Database Design with phpMyAdmin

(approximately 1 weeks)

Through phpMyAdmin, you'll master the creation and management of databases, ensuring efficient data organisation.

Unit 5: Data Querying with PHP and SQL

(approximately 3 weeks)

Focusing on Data Querying with PHP and SQL. Engaging in PHP coding, you'll skillfully query databases and present the results in a visually appealing manner on your website.

Unit 6: Using JavaScript for Form Validation (M and E)

(approximately 1 week)

Centered on Form Entries, Unit 6 involves adept JavaScript coding. You'll proficiently validate user inputs, addressing not only valid data but also boundary and invalid cases with skill and precision.

Follow course on Education Perfect in Term 3

Important Software Notes!

~~~ Exemplars of Student Projects ~~~