Structured Query Language (SQL) Introduction

Image courtesy of Master isolated images
/ FreeDigitalPhotos.net

This is the first session in a series on SQL. In this session Barry Collier looks at analysing data in preparation for creating a database and then creating the database using SQL.

The session covers the following points: analysing data in terms of how it would be applied in a database creating a database using SQL loading data from a text file generated from a spreadsheet running SQL in a command line environment (MySQL Server 5.6)

Students will find the content of this Adobe Connect session most helpful for unit ICAPRG425A in both our Certificate IVs and Diploma courses.

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

Installation and Evaluation

Image courtesy of Robert Cochrane
/ FreeDigitalPhotos.net

This is the ninth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers installation and evaluation.

The session covers the following points: videoing the installation evaluation

Students will find the content of this Adobe Connect session most helpful for Support Assessment E.

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

User Requirements

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This is the eight session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers user requirements.

The session covers the following points: user requirements hardware selection and purchase installation plan

Students will find the content of this Adobe Connect session most helpful for Support Assessment D.

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

Resolve Software Problems

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This is the seventh session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers undertaking software maintenance procedures.

Jeremy looks at the whole process from undertaking software maintenance according to maintenance procedures maintain accurate records according to orgainsational guidlines resolve a defined range of equipment and software problems flow charts

Students will find the content of this Adobe Connect session most helpful for Support Assessment C.

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

Diagnostics & Maintenance

Image courtesy of cooldesign
/ FreeDigitalPhotos.net

This is the sixth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers diagnosing and maintaining a personal computer

Jeremy looks at the whole process from recommendation location and maintenance guidelines diagnostic and maintenance functions updating software and developing a maintenance schedule

Students will find the content of this Adobe Connect session most helpful for Support Assessment A.

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

Dreamspark - Downloading Windows 7v2

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This session run by Jeremy Kilpatrick covers everything you wanted to know about Microsoft's Dreamspark offer but were afraid to ask.

View the session to learn how to download and install free software from Microsoft which is only available to students of the Western Sydney Institute TAFE NSW.

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

Troubleshooting & Diagnosing Windows

Image courtesy of dan
/ FreeDigitalPhotos.net

This is the fifth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers troubleshooting Windows 7.

He also covers using diagnostic tolls for both Windows and Ubuntu as well as viruses and virus removal.

Students will find the content of this Adobe Connect session most helpful for Operating Systems Assessment D.

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

Creating User Accounts in Linux with Terminal

Image courtesy of stockimages
/ FreeDigitalPhotos.net

This is the fourth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers creating user accounts in Linux.

Jeremy demonstrates this using Terminal which is command line utility.

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

Installing a Virtual Machine

Image courtesy of arztsamui
/ FreeDigitalPhotos.net

This is the third session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers installing a virtual machine (VM).

He actually covers two different VMs: VMPlayer and Virtual Box. Also Jeremy covers installing Linux Ubuntu and Windows 7 in a virtual machine. He wraps up the session covering users and groups in Linux and Optimising Windows.

Students will find the content of this Adobe Connect session helpful for Operating Systems Assessment C.

Click on the link to the right to view the recording of the session.

Software Audit - Belarc / Backup

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This is the second session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers using auditing software from Belarc as well performing backups and restores in Windows 7 & 8.

Students will find the content of this Adobe Connect session most helpful for Operating Systems Assessment F.

Click on the link to the right to view the recording of the session.

Users & Groups / Group Policy / Set file permissions

Image courtesy of renjith krishnan
/ FreeDigitalPhotos.net

This is the first session in a series of sessions on Certificate III Information, Digital Media & Technology - Support. In this session Information Technology Teacher, Jeremy Kilpatrick provides an in depth look at setting up user accounts in Windows 7 and 8.

Students will find the content of this Adobe Connect session most helpful for Operating Systems Assessment E.

Click on the link to the right to view the recording of the session.