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

Python Session 1 - Variables

The OTEN IT Teaching section resumed its online Connect sessions today with Barry Collier delivering a session on the Python programming language. This will be the first of several sessions on Python which will be delivered over the remainder of the semester. This particular session will be delivered over two stages with the second half being delivered next Wednesday. You can view a recording of this session by selecting it from the list of recordings to the right.

Datasbase Basics - Session 2

Teacher Kim Prasertsuksom ran the second session on Database Basics yesterday. Once again Kim ran a very informative session on developing Queries By Example (Query Forms) and generating Reports. You can view a recording to the session by selecting the appropriate link to the right.

Revised Online Sessions Schedule

NB The schedule has been amemded 31st March 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 30 to 45 minutes. Please note that additional sessions are now proposed for Term 2 also at the moment no sessions are scheduled for the April holiday break but this may change.

Date	Session Title	Description	Relevant Unit/s	Course
23/03/2011	Database Basics - 1	Covers the basics of developing a database using MSAccess 2010.	ICAU1131, ICAD2012 & ICAU2013	Certificate II & III IT
30/03/2011	Database Basics - 2	Covers the basics of developing a database using MSAccess 2010.	ICAU1131, ICAD2012 & ICAU2013	Certificate II & III IT
06/04/2011	Editing Images	This session will cover editing images including using the curve tool as well as optimising images for the web.	ICPMM321	Certificate III IT
27/04/2011	Python Basics	This session will provide an introduction to the Python programming language.	ICAB4225	Certificate IV IT
04/05/2011	Mail Merge	This session will cover setting and running a Mail Merge using MSWord 2010.	ICAU1129 & ICAU2013	Certificate II & III IT
11/05/2011	VLOOKUP Function	This session will cover the VLOOKUP() function in an Excel spreadsheet.	ICAD2012	Certificate II IT
18/05/2011	Windows 7 Backup	This session will go through the steps of backing up and restoring files using Windows 7.	ICAS2017	Certificate II IT
25/05/2011	Selection Statements in Python	This session will provide examples of constructing selection statements using Python	ICAB4225	Certificate IV IT
01/06/2011	Iteration in Python	This session will cover constructing programming loops using Python.	ICAB4225	Certificate IV IT
08/06/2011	File Handling using Python	This session will provide examples of file handling using the Python programming language.	ICAB4225	Certificate IV IT
15/06/2011	Creating - Using Styles in MS Word	Lear how to create and apply styles in MS Word.	ICAB3018	Certificate III 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

Database Basics - Session 1

Todays session was run by Kim Prasertsuksom on developing a database. Kim covered Database Terminology, creating a database in MS Access and also creating a table by importing data from a text (ASCII) file. Her presentation focussed on setting up a table by determining the columns (fields) and their associated data types. Thanks Kim for a really informative session.

Algorithm Design - ICAB4225

There was another Adobe Connect Session today which was run once again by Barry Collier this time on Algorithm Design. This session went relatively smoothly thanks to Barry's support crew (student, Kevin & teacher Eve) who provided timely reminders on recording the session. The session provides an introduction to designing programs albeit with a rather advanced example. You can view it by accessing the link to the right.

Revised Adobe Connect Sessions Schedule

The OTEN IT Teaching Section has revised the schedule for the series of Adobe Connect sessions this term. The new proposed schedule is shown below. They will still be run on a Wednesday from 11:00 am for approximately 30 to 45 minutes. Please note that additional sessions are now proposed for Term 2 also at the moment no sessions are scheduled for the April holiday break but this may change.

Date	Session Title	Description	Relevant Unit/s	Course
16/03/2011	Algorithm Design	Covers the basics such as developing an algorithm using a defining diagram.	ICAB4225	Certificate IV IT
23/03/2011	Database Basics	Covers the basics of developing a database using MSAccess 2010.	ICAU1131, ICAD2012 & ICAU2013	Certificate II & III IT
30/03/2011	Mail Merge	This session will cover setting and running a Mail Merge using MSWord 2010.	ICAU1129 & ICAU2013	Certificate II & III IT
06/04/2011	Editing Images	This session will cover editing images including using the curve tool as well as optimising images for the web.	ICPMM321	Certificate III IT
27/04/2011	VLOOKUP Function	This session will cover the VLOOKUP() function in an Excel spreadsheet.	ICAD2012	Certificate II IT
04/05/2011	Python Basics	This session will provide an introduction to the Python programming language.	ICAB4225	Certificate IV IT
11/05/2011	Database Normalisation	This session will attempt to explain the process of normalising a database design.	ICAS4113 & ICAB4170	Certificate IV IT
18/05/2011	Selection Statements in Python	This session will provide examples of constructing selection statements using Python	ICAB4225	Certificate IV IT
25/05/2011	Iteration in Python	This session will cover constructing programming loops using Python.	ICAB4225	Certificate IV IT
01/06/2011	File Handling using Python	This session will provide examples of file handling using the Python programming language.	ICAB4225	Certificate IV IT
08/06/2011	Developing a website	This session will provide examples developing a website using a web authoring tool.	ICAB4169	Certificate III IT
15/06/2011	Uploading with FTP	This session will go through an example of uploading files over the Internet using an FTP client.	ICAS4201	Certifcate III IT
22/06/2011	T. B. A.	To Be Advised.	T. B. A.	T. B. A.

Doctype, Validating & Web Site File Structures

Another Adobe Connect session was run yesterday morning by Barry Collier. This session built on the previous one this time covering HTML topics on the Doctype element, Validating pages and setting up a file structure for a web site. Once again it was well attended with 18 students attending. There were at least 28 accounted for in the previous session by the way.

This time Barry's computer didn't run out of battery (though it nearly did as he hadn't switch the power point on) he did forget however to record the session. Which he didn't realise until the end (talk about the absent minded professor). He was most disappointed about this as I am sure you all were too.

Thankfully one student, John, recorded it on his computer and has made the recording available to OTEN. Thanks John you're a legend and Barry says he is most grateful. It is a AVI file it and runs fine in Windows Media player (the current and previous versions). The catch is it is rather a large file at 160.5 megabytes. You can down load a zipped version of the file using the link to to the right.

Make sure log onto next week's session to see what other mischief Barry gets up to.

Basic HTML

Barry Collier ran a session on HTML this morning which was really well attended and received. During the session Barry's Notebook shut down (battery went flat - don't worry he has given an assurance that he'll make sure that the charger is plugged in next time) but to his supprise everyone remained logged in. A link to a recording of the session is to the right.

Missing Recordings

Where did all of the recordings go? Unfortunately the majority of Adobe Connect Sessions the Information Technology Teaching section has done over the past few years have been lost.

This occured because of a server upgrade. The sessions we are proposing for this Semester will hopefully go some way in addressing our lost recordings. The image identifies which recordings were lost (the ones crossed out).

Adobe Connect Schedule - Term 1 Semester 1 2011

The OTEN IT Teaching Section will be running a series of Adobe Connect sessions this term. They will be run on a Wednesday from 11:00 am for approximately 30 to 45 minutes. The proposed schedule is:

Date	Session Title	Description	Relevant Unit/s	Course
02/03/2011	Basic HTML - Doctype & validation	This session will cover the basic HTML structure with a brief overview of where the layout code is at.	ICAB4135	Certificate III IT
09/03/2011	Web Site File Structure	This session will cover discussion on setting out the actual files and folders of the site.	ICAB4135 / ICAB4169	Certificate III IT
16/03/2011	Algorithm Design	Covers the basics such as developing an algorithm using a defining diagram.	ICAB4225	Certificate IV IT
23/03/2011	Uploading with FTP	This session will go through an example of uploading files over the Internet using an FTP client.	ICAS4201	Certifcate III IT
30/03/2011	Editing Images	This session will cover editing images including using the curve tool as well as optimising images for the web.	ICPMM321	Certificate III IT
06/04/2011	File Handling using Python	This session will provide examples of file handling using the Python programming language.	ICAB4225	Certificate IV IT