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).