[Informatics] Gantt Project Planner using Excel

Fri May 20 12:29:37 AEST 2016

I’ve been using Gantter successfully it with my Year 11 and 12.

Not only does it do the job better, it is as close as I can find to what the students might have to use in the workplace without investing ~$600 on Microsoft Project.

Also integrates with Google Drive, so they can tick the collaboration box as well.

One work of warning: save and save often.  If you lose connection to the internet it may not allow the student to save, in which case they will need to export to a local file and re-upload.

B.

Ben Ratcliffe
Teacher, Multimedia & IT
[staff-signature1]
[cid:7E6904C1-140A-41B8-AC4B-4A36ABC45362]

From: informatics-bounces at edulists.com.au [mailto:informatics-bounces at edulists.com.au] On Behalf Of Mark
Sent: Friday, 20 May 2016 11:43 AM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au>
Subject: Re: [Informatics] Gantt Project Planner using Excel

Thanks for the idea, Frank.

In the past I've battled using Excel experimentally for Gantt (albeit without a template), and have never found it very satisfactory.

The problems with using Excel for Gantt, as I see them are:
- is that it's very much harder to update a chart
- there are no dependency arrows
- it cannot easily calculate extra goodies such as total project length, resource double-bookings
- it cannot identify a critical path
- it can't switch to a PERT view

I found that a free and simple dedicated program<https://www.ganttproject.biz/>, online service<https://ganttpro.com>, Google plugin<https://www.smartapp.com/gantterforgoogledrive> or app<https://asana.com/apps/instagantt> does the job better, faster, and more easily. (The links are only examples, not necessarily recommendations).

Cheers
Mark

On 20 May 2016 at 08:39, Russo, Frank R <Russo.Frank.R at edumail.vic.gov.au<mailto:Russo.Frank.R at edumail.vic.gov.au>> wrote:
Hi everyone
Came across this template in MS Excel 2013 online a little different but perfect for what is required for the SAT.
A Little late but perhaps something to play with and future use.

Frank Russo
Mobile: 0409022197
Work: 9781 7700
Daily Organiser
Teacher:- IT, Game Design, Robotics, Maths & Science
AEU Branch President
Consultative & Planning Committee Member
[Monterey_Secondary_College_logo]
Silvertop Street
Frankston North
Victoria, Australia

From: informatics-bounces at edulists.com.au<mailto:informatics-bounces at edulists.com.au> [mailto:informatics-bounces at edulists.com.au<mailto:informatics-bounces at edulists.com.au>] On Behalf Of Litsa Tzelepis
Sent: Thursday, 19 May 2016 6:18 PM
To: Year 12 VCE Informatics Teachers' Mailing List; Year 11 Information Technology Teachers' Mailing List
Subject: [Informatics] Adobe launches SPARK (Cross post apology)

... to replace Voice and Slate

https://spark.adobe.com/about

at the PD now - so much fun

xx

--
Litsa Tzelepis
Mount St. Joseph Girls' College
133 Maidstone Street, Altona, VIC. 3018
htzelepis at msj.vic.edu.au<mailto:htzelepis at msj.vic.edu.au>
P:8398 2000 | F:9398 3498

This Email and any attachments may be confidential and, if you are not the intended recipient, you must not disclose or use the information in this email. If received in error, please notify the sender and Mount St. Joseph Girls' College immediately and delete the Email and all copies. Mount St. Joseph Girls' College does not guarantee that this email is virus or error free. The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The content and opinions in this Email are not necessarily those of Mount St. Joseph Girls' College. Please consider the environment before printing this email.

IMPORTANT! This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Mount St Joseph Girls' College does not represent or warrant that the attached files are free from computer viruses or other defects. The attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The liability of Mount St Joseph Girls' College is limited in any event to either the resupply of the attached files or the cost of having the attached files resupplied. Any representations or opinions expressed in this email are those of the individual sender, and not necessarily those of Mount St Joseph Girls' College.

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training.

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
VCE Informatics Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
http://www.swinburne.edu.au/ict/schools - Swinburne University

--

Mark Kelly

mark at vceit.com<mailto:mark at vceit.com>
http://vceit.com
Disclaimer
This email is intended for the use of the named individual or entity and may contain confidential and privileged information. Any dissemination, distribution or copying by anyone other than the intended recipient of this email is strictly prohibited. Whilst every attempt has been made to ensure material in this email message is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes all responsibility for use of the material transmitted. This message, including any attachments, is provided without responsibility in law for its accuracy or otherwise and without assumption of a duty of care by Yarra Valley Grammar. If this email has been received in error, then please notify Yarra Valley Grammar immediately and destroy the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20160520/ac433064/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 32834 bytes
Desc: image001.png
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20160520/ac433064/image001-0001.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 15830 bytes
Desc: image002.jpg
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20160520/ac433064/image002-0001.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 16923 bytes
Desc: image003.png
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20160520/ac433064/image003-0001.png 