[Year 12 SofDev] Gantt Chart App

Wed Apr 22 01:03:42 UTC 2020

Hi,

My boys actually have MS Project licences but they hadn't installed it before lockdown and can’t do it from home.  So they had to either get driven to school and sit outside connecting to the school Wifi to install it, or use an Excel version I created.  They don't have rights to install tools from the web that have been mentioned here.

I created my own Excel template with Macros to do most functions like calculating end dates and drawing the bar and milestones.  It's a little bit clunky and doesn’t draw the dependency arrows (maybe next time I feel like a challenge), but is good enough for practice and doing the SAT.  I should acknowledge I got a lot of the steps from someone on you tube but can't remember who!

If anyone wants it I am happy to share and I also have 2 short videos explaining how to use it that I gave my boys.  It probably won't get through this email server due to macros but I can email directly.  I've attached a screenshot.

Simon Dorrat
TEACHER OF DIGITAL TECHNOLOGIES | ROBOTICS AND INNOVATION | MATHEMATICS
Bosco Campus
10 Bosco St Chadstone 3148
T +61 3 9807 2644
F +61 3 9888 1289
E  sdorrat at salesian.vic.edu.au
W salesian.vic.edu.au

-----Original Message-----
From: sofdev <sofdev-bounces at edulists.com.au> On Behalf Of sofdev-request at edulists.com.au
Sent: Wednesday, 22 April 2020 7:04 AM
To: sofdev at edulists.com.au
Subject: sofdev Digest, Vol 179, Issue 15

Send sofdev mailing list submissions to
sofdev at edulists.com.au

To subscribe or unsubscribe via the World Wide Web, visit
http://edulists.com.au/mailman/listinfo/sofdev
or, via email, send a message with subject or body 'help' to
sofdev-request at edulists.com.au

You can reach the person managing the list at
sofdev-owner at edulists.com.au

When replying, please edit your Subject line so it is more specific than "Re: Contents of sofdev digest..."

Today's Topics:

   1. Re: Gantt Chart Apps (James Vella)

----------------------------------------------------------------------

Message: 1
Date: Tue, 21 Apr 2020 21:22:35 +0000
From: James Vella <James.Vella at avemaria.vic.edu.au>
To: Year 12 Software Development Teachers' Mailing List
<sofdev at edulists.com.au>
Subject: Re: [Year 12 SofDev] Gantt Chart Apps
Message-ID:
<ME2P282MB0017926B37F932EFDD3D755FE0D50 at ME2P282MB0017.AUSP282.PROD.OUTLOOK.COM>

Content-Type: text/plain; charset="utf-8"

Gantt Project has always been the one of choice for me.

JV

James Vella
Director of Studies

[cid:EmailBannerApril2020_ff643dec-b1f9-4373-902d-e811dfc206c7.png]

[cid:Twitter_90316226-9586-417c-b51a-5dcf403c377d.png]<https://twitter.com/avemariacollege>[cid:Facebook_f36273d0-08aa-48ea-8b50-29f289005fcf.png]<https://www.facebook.com/avemariacollegeaberfeldie>[cid:Instagram_f0580411-bf13-467b-a97c-de8367973fcc.png]<https://www.instagram.com/avemariacollege/>

DISCLAIMER: This e-mail and any attachments may be confidential. You must not disclose or use the information in this e-mail if you are not the intended recipient. If you have received this e-mail in error, please notify us immediately and delete the e-mail and all copies. Ave Maria College does not guarantee that this e-mail 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 e-mail are not necessarily those of Ave Maria College. Please consider the environment, before printing this email.
From: sofdev <sofdev-bounces at edulists.com.au> On Behalf Of Hagedorn, Jennyfer J
Sent: Tuesday, 21 April 2020 9:14 PM
To: Year 12 Software Development Teachers' Mailing List <sofdev at edulists.com.au>
Subject: Re: [Year 12 SofDev] Gantt Chart Apps

Teamgantt.com is still free if you only want one project. Three people can also see it.

Jen Hagedorn

[cid:image001.jpg at 01D61876.C96ED5E0]
Murtoa College
Webb Street
PO Box 156, Murtoa 3390
Ph: (03) 5382 2381
Web: http://www.murtoasc.vic.edu.au<https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.murtoasc.vic.edu.au%2F&data=02%7C01%7CJames.vella%40avemaria.vic.edu.au%7C686b056d48844ce5780408d7e5e5239f%7C956340187ce14710a21c1fb0b4928006%7C0%7C0%7C637230644621160013&sdata=JaGDFr3Dr3OgBoU6N%2FfrihAF7arG%2B77jgSkrYUDOIIw%3D&reserved=0>

From: sofdev <sofdev-bounces at edulists.com.au<mailto:sofdev-bounces at edulists.com.au>> On Behalf Of Tony Crewe
Sent: Tuesday, 21 April 2020 6:47 PM
To: Year 12 Software Development Teachers' Mailing List <sofdev at edulists.com.au<mailto:sofdev at edulists.com.au>>
Subject: Re: [Year 12 SofDev] Gantt Chart Apps

Ganttproject
Sent from my iPad

On 21 Apr 2020, at 5:41 pm, Victoria Farrell <farrellv at stkevins.vic.edu.au<mailto:farrellv at stkevins.vic.edu.au>> wrote:

G'day!

Today I was faced with coming up with an alternative to MS Project for the SAT Gantt Chart.

The free online Gantt Chart apps I was going to rely on are now FORMALLY free online Gantt Chart apps... so I decided to use Excel templates. The MS Agile Gantt Chart  template is...OK... but it doesn't appear to have a feature to include dependencies.

Any suggestions?

Cheers,
Vic

 [https://docs.google.com/uc?export=download&id=1CX_C7cxq-6LI02k6lCI143-i0KPC5nHv&revid=0B4CjWh8BUhIbdG41cDdhQ2paOVBVa2oxdHZzRmRRTGdKR1c0PQ]

Victoria Farrell
Head of Technology Department

St Kevin's College
P 03 9832 4980

E farrellv at stkevins.vic.edu.au<mailto:farrellv at stkevins.vic.edu.au>
vicfarrell.com.au<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.vicfarrell.com.au%2F&data=02%7C01%7CJames.vella%40avemaria.vic.edu.au%7C686b056d48844ce5780408d7e5e5239f%7C956340187ce14710a21c1fb0b4928006%7C0%7C0%7C637230644621160013&sdata=n%2FwHUqfKC9%2BKBIOfO8J0VaPCRDXn%2F9hOR1JrUDMksv4%3D&reserved=0>
Computer Club<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.skc3.club%2F&data=02%7C01%7CJames.vella%40avemaria.vic.edu.au%7C686b056d48844ce5780408d7e5e5239f%7C956340187ce14710a21c1fb0b4928006%7C0%7C0%7C637230644621169970&sdata=ojE0QotAjmm%2BhMp0CRhWuS85a1r%2FOAxb0CHPH9Q1J7Y%3D&reserved=0>
Software Development Text Book 2020<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.amazon.com.au%2FSoftware-Development-Applied-Computing-Design-ebook%2Fdp%2FB07WJRHPCF%2Fref%3Dsr_1_1%3Fqid%3D1565860890%26refinements%3Dp_27%253AVictoria%2BFarrell%26s%3Ddigital-text%26sr%3D1-1%26text%3DVictoria%2BFarrell&data=02%7C01%7CJames.vella%40avemaria.vic.edu.au%7C686b056d48844ce5780408d7e5e5239f%7C956340187ce14710a21c1fb0b4928006%7C0%7C0%7C637230644621169970&sdata=umDHjLOfI9VCaho5hcBVLfatBv7kF35ewVBt7tStWrA%3D&reserved=0>

This email message does not represent the view of St Kevins College, is intended only for the addressee(s) and contains information that may be confidential and/or copyright. If you are not the intended recipient please notify the sender by reply email and immediately delete this email. Use, disclosure or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient. _______________________________________________
http://www.edulists.com.au<https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.edulists.com.au%2F&data=02%7C01%7CJames.vella%40avemaria.vic.edu.au%7C686b056d48844ce5780408d7e5e5239f%7C956340187ce14710a21c1fb0b4928006%7C0%7C0%7C637230644621179945&sdata=X48H%2FADe0%2Fp4ufnxHeyY828FzF9FnNRFOnd%2Fr27RL9c%3D&reserved=0> - FAQ, Subscribe, Unsubscribe IT Software Development Mailing List 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/sofdev/attachments/20200421/216e9bb5/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3674 bytes
Desc: image001.jpg
URL: <http://edulists.com.au/pipermail/sofdev/attachments/20200421/216e9bb5/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: EmailBannerApril2020_ff643dec-b1f9-4373-902d-e811dfc206c7.png
Type: image/png
Size: 107437 bytes
Desc: EmailBannerApril2020_ff643dec-b1f9-4373-902d-e811dfc206c7.png
URL: <http://edulists.com.au/pipermail/sofdev/attachments/20200421/216e9bb5/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Twitter_90316226-9586-417c-b51a-5dcf403c377d.png
Type: image/png
Size: 606 bytes
Desc: Twitter_90316226-9586-417c-b51a-5dcf403c377d.png
URL: <http://edulists.com.au/pipermail/sofdev/attachments/20200421/216e9bb5/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Facebook_f36273d0-08aa-48ea-8b50-29f289005fcf.png
Type: image/png
Size: 352 bytes
Desc: Facebook_f36273d0-08aa-48ea-8b50-29f289005fcf.png
URL: <http://edulists.com.au/pipermail/sofdev/attachments/20200421/216e9bb5/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Instagram_f0580411-bf13-467b-a97c-de8367973fcc.png
Type: image/png
Size: 608 bytes
Desc: Instagram_f0580411-bf13-467b-a97c-de8367973fcc.png
URL: <http://edulists.com.au/pipermail/sofdev/attachments/20200421/216e9bb5/attachment-0003.png>

------------------------------

Subject: Digest Footer

_______________________________________________
sofdev mailing list
sofdev at edulists.com.au
http://edulists.com.au/mailman/listinfo/sofdev

------------------------------

End of sofdev Digest, Vol 179, Issue 15
***************************************
________________________________________

CONFIDENTIAL INFORMATION

The information in this email and any attachments is privileged and confidential intended only for the use of the intended recipient. This information remains the property of Salesian College and if you are not the intended recipient please delete this message immediately. The views expressed in this email are those of the author and do not represent those of Salesian College unless clearly indicated. Please be advised that any dissemination, distribution or copying of the information is strictly prohibited. Salesian College accepts no responsibility for any viruses this email may contain. This notice should not be removed. If you have received this communication in error, please contact us at welcome at salesian.vic.edu.au<mailto:welcome at salesian.vic.edu.au> .
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Excel Project Planner.PNG
Type: image/png
Size: 50749 bytes
Desc: Excel Project Planner.PNG
URL: <http://edulists.com.au/pipermail/sofdev/attachments/20200422/3857ff83/attachment-0001.png>