Database Design Concepts

Image courtesy of ddpavumba
/ FreeDigitalPhotos.net

In this session Barry Collier covers some of the basic principles of database design. Primarily he looks at the reasons for developing a database and then uses a sample of raw data as the basis of establishing database tables and the relationship between them. The topics he covers are tables, forms, relationships (between tables) including primary and foreign keys. Select the link to the right called Database Design Concepts to view the recording of this session.

Orientation & Sustainability Assignment

This session, delivered by Eve Gray provides an orientation to Cert III IT students in the first half of the session. The remainder of the session is devoted to the assignment for the sustainability unit. See the link to the right on Orientation & Sustainability Assignment.

Resumption of Online Sessions

At long last the Information Technology Teaching Section at OTEN has resumed running online sessions. These will be a mixture of orientation and specialist sessions. This blog site will be devoted to providing links to the specialist sessions.

Image courtesy of Ohmmy3d /
FreeDigitalPhotos.net

e-Waste
The first of these sessions was run by our resident sustainability expert Eve Gray. In this session Eve covered 'What is e-Waste?' and 'What can we do about it?' Select the link to the right (near the top of the page under the heading Adobe Connect Session Recordings) for some insights into managing e-Waste.

VLOOKUP() Funtion

The recording to the right covers the VLOOKUP() function in Excel. This particular session was recorded some time ago and it was presented by Eve Gray one of our Information Technology teachers. It was the last session the section did in 2011 and was essentially a closed one as no students were invited to attend. Consequently there is no student interaction in the chat pod there is however an attempt to scribe what is being presented for our audibly impaired students.

Connect Sessions Suspended

All Information Technology Connect Sessions Have Been Suspended

It is with regret that the Information Technology Teaching Section at OTEN has had to halt delivery of its Connect Sessions for the time being. This is due to a resourcing issue to ensure that the sessions are accessable for all students who wish to participate.

It is anticipated that once this issue has been resolved the sessions will resume. Thank you for support and we hope that we can continue to provide these sessions in the near future. We are hopeful that the sessions will resume in Semester 2, 2011.

Date	Session Title	Description	Relevant Unit/s	Course
08/06/2011	Mail Merge	This session will cover setting and running a Mail Merge using MSWord 2010.	ICAU1129 & ICAU2013	Certificate II & III IT
15/06/2011	VLOOKUP Function	This session will cover the VLOOKUP() function in an Excel spreadsheet.	ICAD2012	Certificate II IT
22/06/2011	Developing Web Pages using HTML	This session will build on the first two sessions on HTML and will explore developing some of building elements of HTML.	ICAB4135	Certifcate III IT
29/06/2011	Developing a website	This session will provide examples developing a website using a web authoring tool.	ICAB4169	Certificate III IT

Session Date Incorrect on Invitation

Apologies are in order. The invitation for Session 4 on Python went out with the wrong date on it. It stated the 19th May 2011 when it should've stated the 18th. The IT Teaching Section sincerely apologises to those students who missed out on attending the session this week. Please find the link to the recording of this session to the right.

The Adobe Connect sessions run by the IT Teaching Section are usually run on a Wednesday at 11:00am which can be accessed via the Live link to the right.

Revised Adobe Connect Sessions - Term 2 2011

NB The schedule has been amemded 2nd May 2011

The OTEN IT Teaching Section has yet again revised the schedule for the series of Adobe Connect sessions this semester. The new proposed schedule is shown below. They will still be run on a Wednesday from 11:00 am for approximately 45 to 60 minutes. Sessions have been scheduled for the remainder of the Semester, i.e. to the end of Term 2. No sessions have been scheduled for Semester 2 at this stage.

Date	Session Title	Description	Relevant Unit/s	Course
27/04/2011	Python Basics - Session 1	This session will provide an introduction to the Python programming language.	ICAB4225	Certificate IV IT
04/05/2011	Python Basics - Session 2	This session continues of from Session 1.	ICAB4225	Certificate IV IT
11/05/2011	Selection Statements in Python	This session will provide examples of constructing selection statements using Python	ICAB4225	Certificate IV IT
18/05/2011	Iteration in Python	This session will cover constructing programming loops using Python.	ICAB4225	Certificate IV IT
25/05/2011	File Handling using Python	This session will provide examples of file handling using the Python programming language.	ICAB4225	Certificate IV IT
01/06/2011	Creating - Using Styles in MS Word	Learn how to create and apply styles in MS Word.	ICAB3018	Certificate III IT
08/06/2011	Mail Merge	This session will cover setting and running a Mail Merge using MSWord 2010.	ICAU1129 & ICAU2013	Certificate II & III IT
15/06/2011	VLOOKUP Function	This session will cover the VLOOKUP() function in an Excel spreadsheet.	ICAD2012	Certificate II IT
22/06/2011	Developing Web Pages using HTML	This session will build on the first two sessions on HTML and will explore developing some of building elements of HTML.	ICAB4135	Certifcate III IT
29/06/2011	Developing a website	This session will provide examples developing a website using a web authoring tool.	ICAB4169	Certificate III IT