Modelling System Solutions

Image courtesy of lekkyjustdoit

 

View the recording
Modelling System Solutions 42:46 min

In this session on Modelling System Solutions OTEN teacher, Barry Collier looks at developing a Use Case Diagram.

This session covers the following points: Why Model Unified Modelling Language Use Case Diagram Use Case Diagram Components Documentating

Students will find the content of this Adobe Connect session most helpful for units ICTNWK514 Model perferred system solutions, ICTSAD501 Model data objects & ICTSAD502 Model data processes in the Diploma of Information Technology & Diploma of Website Development courses.

Responsive Spreadsheets

Image courtesy of Howtogeek

 

View the recording
Responsive Spreadsheets 57:14 min

In this session on Responsive Spreadsheets OTEN teacher, Barry Collier looks at setting up a spreadsheet to respond to What If scenarios.

This session covers the following points: What If scenarios Working Figures Absolute Referencing Named References

Students will find the content of this Adobe Connect session most helpful for units ICTSAD506 Produce a feasibility report & ICTICT510 Determine appropriate ICT strategies and solutions in the Diploma of Information Technology & Diploma of Website Development courses.

Using Session Management 2 via a Form

Image Authentication-and-Session-Management-Process courtesy of ResearchGate at ResearchGate

 

View the recording
Using Session Management via a Form 45:11 min

In this session on Using Session Management via a Form OTEN teacher, Barry Collier continues from the previous tutorial and covers using PHP to authorise the session via form.

This session covers the following points: Using a form to authorise the user Confirming the user via a database Checking the isset() function Clearing using the unset() function

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Using Session Management 1

Image courtesy of hackernoon at Hackernoon

 

View the recording
Using Session Management 41:03 min

In this session on Using Session Management OTEN teacher, Barry Collier covers using PHP to establish a session, checking the session variable and clearing it.

This session covers the following points: Establishing a session Setting the session variable Checking the isset() function Clearing using the unset() function

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Updating a Database via Form

Image curtesy of 365datascience at Cloudways

 

View the recording
Updating a Database via a Form 45:54 min

In this session on Updating a Database OTEN teacher, Barry Collier covers updating a MySQL database via a Form using $_POST.

This session covers the following points: Passing Login details Validating the Login Displaying the record associated with the login

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Updating a Database Using PHP

Image courtesy of Formget at Cloudways

 

View the recording
Updating a Database Using PHP 1 hr 15:06 min

In this session on Updating a Database OTEN teacher, Barry Collier covers updating a MySQL database using PHP.

This session covers the following points: Updating usng mysqli_query() Inserting records Inserting records with auto_increment Retrieving the last record added Deleting a record

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Querying a Database Using PHP

Image courtesy of Cloudways at Cloudways

 

View the recording
Querying a Database Using PHP 49:10 min

In this session on Querying a Database OTEN teacher, Barry Collier covers querying aMySQL databse using PHP.

This session covers the following points: Querying usng mysqli_query() Query arguments Returning the number or rows Returning the row values

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Connect to a MySL Database Using PHP

Image courtesy of Cloudways at Cloudways

 

View the recording
Connecting to a Database Using PHP 40:09 min

In this session on Connecting to a Database OTEN teacher, Barry Collier covers connecting to a MySQL databse using PHP.

This session covers the following points: Connecting usng mysqli_connect() Connection arguments Determining a Successful Connection Closing the Connection

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Defining a Website 2

Image courtesy of iStock by Getty Images.

 

View the recording
Defining a Website 2 56:19 min

In this second session on Defining a Website OTEN teacher, Barry Collier covers the steps in exporting a website using Expression Web. He also looks at up the PATH in Window's Environment Variable and Parsing files at the command line.

This session covers the following points: Revising Editing Files Exporting a website as a package Editing the Path in Windows Parsing a file

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Defining a Website 1

Image courtesy of iStock by Getty Images.

View the recording
Defining a Website 1 55:25 min

In this session on Defining a Website OTEN teacher, Barry Collier covers the steps in creating a website using Expression Web.

This session covers the following points: Creating an empty site Importing existing file / folders Enabling hidden meta files option Editing files

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

PHP Include files

Image courtesy of iStock by Getty Images.

View the recording
PHP Include Files 66:29 min

In this session on Using PHP Include Files OTEN teacher, Barry Collier covers aspects of Incorporating PHP Include files using a local web server.

This session covers the following points: PHP tags Running PHP in the browser Using incudes Relativity of links

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

Using a Local Web Server

Image courtesy of iStock by Getty Images.

View the recording
Using a local web server 48:42 min

In this session on Using a Local Web Server OTEN teacher, Barry Collier covers aspects of running a web server on your own computer.

This session covers the following points: different web servers locating the root folder enabling the server localhost security considerations

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

Developing Complex SQL Statements

"Confused Character Means Bewildered Puzzled Or Purplexed" by Stuart Miles Image courtesy of Freedigitalphotos.net

View the recording
Developing Complex SQL Statements 49:02 min

In this session on Developing Complex Select Statements OTEN teacher, Barry Collier continues on from the previous session.

This session covers the following points: joins inner join left join right join full join self join union nested queries

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Developing Select Statements

Image courtesy of study.com

View the recording
Using MySQL Workbench 2 60:03 min

In this session on Developing Select Statements OTEN teacher, Barry Collier continues on from the previous session.

This session covers the following points: Select Statement from Absolute Tables and Databases Alias Where Clause Where Clause Operators Group By Having Clause

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Developing a MySQL Database

Image MySQL logo
courtesy of Oracle

View the recording
Using MySQL Workbench 2 60:56 min

In this session on Developing a MySQL Database OTEN teacher, Barry Collier continues on from the MySQL session Using Workbench 2, delivered on the 20th Feb 2019.

This session covers the following points: Creating tables Foreign Keys Relationships Inserting Values Updating Tables Select Statements

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Pre-loading Images

Image courtesy of istockphoto

View the recording Pre-loading Images

In this session on JavaScript OTEN teacher, Barry Collier covers pre-loading images.

The session will cover some of the assessment tasks for unit ICTWEB502 Create dynamic web pages Practical Assignment B.

It builds on past sessions delivered for this unit. It is directed at Diploma of Website Development students who are working through or about to commence unit ICTWEB502.

JavaScript Functions 3

Image courtesy of istockphoto

View the recording JavaScript Functions 3

In this session on JavaScript OTEN teacher, Barry Collier covers developing a function using JavaScript to assemble image slices.

The session will cover some of the assessment tasks for unit ICTWEB502 Create dynamic web pages Practical Assignment A.

It builds on past sessions delivered for this unit. It is directed at Diploma of Website Development students who are working through or about to commence unit ICTWEB502.

JavaScript Functions 2

Image courtesy of istockphoto

View the recording JavaScript Functions 2

In this session on JavaScript OTEN teacher, Barry Collier covers passing arguments to a function.

The session will cover some of the assessment tasks for unit ICTWEB502 Create dynamic web pages Practical Assignment A.

It builds on past sessions delivered for this unit. It is directed at Diploma of Website Development students who are working through or about to commence unit ICTWEB502.

Using MySQL Workbench 2

Image "Printwebsite Database Symbols" by Bwiselizzy
courtesy of istockphoto FreeDigitalPhotos.net

View the recording
Using MySQL Workbench 2

In this session on Using MySQL Workbench 8.0 OTEN teacher, Barry Collier continues on from the previous session.

This session covers the following points: Creating a database Creating a table secure file priv Importing Data Re-directing output

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Using MySQL Workbench 1

Image courtesy of istockphoto
/ FreeDigitalPhotos.net

View the recording
Using MySQL Workbench 1

In this session on Using MySQL Workbench 8.0 OTEN teacher, Barry Collier covers the rudiments of the interface.

The session covers the following points: launching Workbench connecting to a MySQL instance setting up the interface creating queries running queries saving queries creating a database

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Click the corresponding link in the column to the right to access the recording.

Loops, String Concatenation, Placing Code and Getting Input

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

In this session on JavaScript OTEN teacher, Barry Collier covers setting up counted loops.

The session covers the following points: for loops and nested for loops string concatenation document.writeln() placing code getting input.

Students will find the content of this Adobe Connect session most helpful for unit ICTWEB429 in the Diploma Website Development course.

Click the corresponding link in the column to the right to access the recording.

NB there were issues with the audio for the first 25 minutes of the session. You can drag the playhead to skip the first 25 minutes. The presenter went over the material again from this point. There will be a couple of further brief incidences where the audio drops out.