Term 4 Assessment

Term 4 Assessment

1. Prescribed Criteria

   • You must be able to CREATE, READ, UPDATE and DELETE records from your database
     • Can variables be created on the website?
       • Create page
     • Can records be viewed on the website
       • Read page
     • Can records be edited on the CRUB application?
       • Update page
     • Can records be removed from the CRUD application?
       • Delete function
   • Your results must be displayed in a Flask Web Application
     • Are the front end and back end connected?
       • Python, SQL, HTML and CSS
     • Are there records in the SQL table?
   • You must have a minimum of 5 records in your CRUD application
     • Is the back end connected to the front end?
       • Working flask program
     • Does the CRUD application store records?
       • Records in SQL table
   • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements
     • Are there visual HTML and CSS elements relevant to the user persona?
     • Are there changes to the website application?
       • HTML, CSS and Python

2. Self Determined Criteria

   • Web application is able to create, display, modify and remove information on six electrical blue rocks.
     • Is the SQL table modified for the data for the user problem?
       • Adjusted heading names and records
     • Are there aspects of the website made regarding the user problem summary?
       • Images, text and records

3. CRUD

   • Create
     • The website can make records
   • Read
     • Records can be viewed on the website
       • 'Insert into' in SQLite database
   • Update
     • The records can be modified
       • 'Update records Set...' in SQLite database
   • Delete
     • Records can be removed
       • 'DELETE FROM records WHERE...' in SQL

4. Changes you will make

   • Colours
     • background
   • Images
     • Pictures / website elements
       • Pictures of the blue lightning rocks
     • Background
   • Text
     • Colour
       • Theming
         • blue
     • Font

5. Sample data

   • SQLite
     • records
       • ID
         • 1
       • Stone
         • Sigma stone
       • Location
         • J04
       • Coordinates
         • 123