Website and Database Development (Indiana Course Code 7185)
About this Course
In the NLPS Review Document, this course is described as “Website and Database Development will provide students a basic understanding of the essential Web and Database skills and business practices that directly relate to Internet technologies used in Web site and Database design and development. Students will learn to develop Web sites using Hypertext Markup Language (HTML) and Cascading Style Sheets (CSS). Additionally students will be introduced to the basic concepts of databases including types of databases, general database environments, database design, normalization and development of tables, queries, reports, and applications. Students will be familiarized with the use of ANSI Standard Structured Query Language. Students will be introduced to data concepts such as data warehousing, data mining, and BIG Data. Students will develop a business application using database software such as Microsoft Access.”
Teaching this Course
There are no specific guidelines from the Indiana Department of Education on how long you should spend on each of the two domains (Website Development and Database Design & Management) or what order you should cover them in. Nextech worked with two Indiana educators who have taught this course to develop a set of projects that students could work through, in order, to help ensure they are learning and mastering the standards for this course. Each project, listed below, has an “Overview and Details” document to walk you through what it is and how it can work in your classroom.
Website and Database Development (7185) Project 1 – Restaurant Website
Website and Database Development (7185) Project 2 – Timeline Website
Website and Database Development (7185) Project 3 – Roster
Website and Database Development (7185) Project 4 – Games and Coasters
Website and Database Development (7185) Project 5 – Golf Course
Website and Database Development (7185) Project 6 – Restaurant Website v2
Additional Resources and Tools to Help Teach this Course
Web Development Resources
Website IDEs
- CodeHS Sandbox
- Replit
- CS50 VSCode
- https://vscodeedu.com/ (VS code education )
Creating a GitHub Account
- If you don’t already have a GitHub account:
-
- Go to https://github.com/
- Enter your email and click on the Sign up for GitHub button
- Follow along with the prompts and verify your account
- Once you have an account (or if you already have one):
- Go to GitHub’s Education page for teachers to get the free teacher benefits
Look at hosting Pages in Github
- Create a new repository.
- Add an index.html file and add some basic content
- (if you are in the repo and press the period key on your keyboard, you will get a virtual VSCode environment)
- Be sure to commit your changes to index.html
Once you have your page set up go back to your repo’s home page:
- Click on Settings
- Choose Pages
- Deploy from GitHub Actions
- Customize
- Save and commit (you don’t need to edit anything)
- Your site will be published as <username>.github.io/<repo name>
Database Curriculum / Tools
- CS50 Introduction to Databases with SQL
- DB and Web resources: https://carterzenke.me/nextech
- Oracle Database
- W3Schools
- CodeHS (Introduction to SQL)