[Informatics] Gantt Project Planner using Excel

[Mark]

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>
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
>
> [image: Monterey_Secondary_College_logo]
>
> Silvertop Street
>
> Frankston North
>
> Victoria, Australia
>
>
>
> *From:* 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
> 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
http://vceit.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20160520/b917df6b/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 32834 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20160520/b917df6b/image001-0001.png