[Year 12 SofDev] Project Plan in a Spreadsheet

[Paragreen, Chris J]

Hi Simon,

Here's a version I used to use as a demo in my early years. These days I'm encouraging my students to use Gantt Project for the actual Gantt chart itself, but I still get them to build the task table in Excel (and import it to GP.) The formulas for automatically calculating the end times and start times based on dependencies are very useful. I also find using Excel first gets students to focus on the tasks involved, rather than the software tool itself.

Chris


From: sofdev-bounces at edulists.com.au [mailto:sofdev-bounces at edulists.com.au] On Behalf Of Tyler, Simon J
Sent: Monday, 7 March 2016 10:12 AM
To: Year 12 Software Development Teachers' Mailing List <sofdev at edulists.com.au>
Subject: [Year 12 SofDev] Project Plan in a Spreadsheet

Hi everyone,

At the SofDev SAT professional learning event in Coburg, quite a few people said that they'd get their students to create their project plan / Gantt chart in Excel or Sheets. I've had a play with this but am not satisfied with the results.

Does anyone have any resources / examples on creating a plan in a spreadsheet?

Thanks,

Simon

Simon Tyler
Classroom Teacher
Footscray City College

 [Image removed by sender. Footscray City College] <http://www.footscray.vic.edu.au/>

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.

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://www.edulists.com.au/pipermail/sofdev/attachments/20160306/d049061b/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 482 bytes
Desc: image001.jpg
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20160306/d049061b/image001-0001.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ITE_U1_O3_PM_Gantt_demo.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 23721 bytes
Desc: ITE_U1_O3_PM_Gantt_demo.xlsx
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20160306/d049061b/ITE_U1_O3_PM_Gantt_demo-0001.xlsx