Building a Login System with Python From Excel to SQLite DBS for Gr 9/10/11/12 or Yr 10/11/12/13

Part 1: HTML
Learning objectives:
By the end of this lesson, you will be able to learn:
Create index.html / about.html / contact.html/research.html/gallery.html
Use headings, paragraphs, lists, links, horizontal lines
Add a navigation bar on BOTH pages
Use a simple colour theme using style
Produce evidence screenshots

Part 2: Assignment: Add a Contact Form Database to Your Website
Learning Objectives:
By the end of this lesson, you will be able to learn:
In this lesson, you will improve your website by adding a Contact Form into contact.html that visitors can use to send you a message. The messages will be stored automatically in Google Sheets, which works like a database. This means your website will now collect information just like a real website.

Part 3: Create a Simple Login System for My Digital Portfolio
Learning Objectives:
By the end of this lesson, you will be able to learn:
create a login window using Python
create a registration window
save usernames and passwords into Excel
check login details
open their HTML portfolio after successful login
Submission:
First show your project to your teacher to double check your project then take a screenshot for :

• Six pages of your website
• login window using Python
• registration window
• usernames and passwords into your Excel spreadsheet
• login details
• HTML portfolio

Part 4: Introduction to CSS: Improve the Design of Your HTML Website
Learning Objectives
By the end of the lesson, students will be able to:
Understand what CSS (Cascading Style Sheets) is
Explain the difference between HTML and CSS
Add internal CSS using the <style> tag
Change text colour
Change background colour
Change font size and text alignment
Improve the design of their existing HTML website

Part 5: External CSS include Navigation Buttons
Learning objectives:
By the end of the lesson, you will be able to:
understand what external CSS is?
create a file called style.css
link one CSS file to all 6 HTML pages
explain why external CSS is better than repeating CSS
style the navigation menu as buttons
improve the design of their website consistently.

The project can be used as a teaching example, classroom exercise, or starting point for more advanced systems such as database-driven login applications.