Level 2 Web Internals

This exists as a base resource for covering NCEA Digitech at level 2 with 3 chosen Internals which is enough to pass. These resources are freely available under a Creative Commons License and provide resources for students and teachers. This is an opinionated delivery process based on our experience and supported by those who contribute to this Wiki.

The design of this resource is based on project work to teach concepts instead of pure theory with three explore projects, two design projects and the final capstone project which will be used for the internals. These resources are designed with someone with little to no programming experience required but also have escape hatches built in to cover more complex topics.

This covers these 3 internals

Internals:

• 6 credits - Programming - AS91896
• 4 credits - Database - AS91892
• 4 credits - Media (Web) - AS91893

---

14 credits pass

Delivery

This is designed to run for two Terms with the project taking the second half on the second Term. It is recommended that this is over Term 2 and Term 3.

Overview of Skills

Section titled Overview of Skills

This is designed to align with industry standards around Web Development and teach appropriate concepts and skills. You will build a functioning website of your choosing using a database, webpage and backend API.

Topics

Section titled Topics

• Testing
  • Automated Testing
  • Unit Tests
  • Integration Tests
• Web Design
  • Accessibility
• Security
  • Common Web Attacks
    • XSS
    • SQL Injection

Technology

Section titled Technology

These resources use these specific tools and libraries. You do not need to know how to use any of these before this however familiarity with Python is encouraged.

• Frontend
  • HTML
  • CSS
• Backend
  • FastAPI
  • Python 3
  • SQL using SQLModel
  • Jinja 3
  • Pytest
• Development
  • Git
  • GitHub
  • VSCode

Other Technology

This does not mean these tools are the best nor the ony way to do it, often you will choose specific tools depending on what you are doing and these tools can change project to project. This is merely an opinionated set for use in covering these topics and these guides have many escape hatches or resources to other ways of doing it if you so choose.

Projects

Section titled Projects

A repository of the final result of these guides can be found on our github Here if at any point you get completely stuck, take a look at our code!

Base Website

Section titled Base Website

This project goes over the basics of HTML, CSS and FastAPI to build a basic blog.

Databases

Section titled Databases

This adds an SQL Databse to our website, allowing us to add and display blog posts dynamically, without having to edit the file ourselves.

Testing

Section titled Testing

Taking our existing website we extend it to add automated testing.