NOTE: Due to a snowstorm on 2/9 (Week #3), we will finish Week #3's Material before beginning this content.
This week we will discuss scheduling, PERT/CPM & Gantt Charts and an introduction to some of the software which can be used to help create effective schedules.
Here's some background links project management scheduling. I believe you may have to Register on their website to access the links below.
Project Management Tools & Strategies
PERT - Program Evaluation Review Technique which is also similar to CPM - Critical Path Method.
Gantt Charts.
In general, PERT charts show dependencies better than Gantt charts, but can be difficult to read for complex tasks. Gantt charts offer a better method to show project status but dependencies are more difficult to represent.
Here's a handout presenting an Overview of Project Management and Scheduling:
A common scheduling chart is called a Gantt Chart. Here is Wikipedia on Gantt Charts.
Here's a YouTube Video on How to Create a Gantt Chart in Excel. Watch this video before next week's class. There is a homework assignment attached below which should be completed by 3/3/17. Here's the Excel Spreadsheet similar to what is used in the video:
How to estimate completion time:
When estimating completion times, the weighted average formula Ta = (a + 4m + b)/6 is sometimes used.
where:
Ta = the actual time estimate you will use
a = the most optimistic estimate
b = the most pessimistic estimate
m = the most realistic estimate
Example: If the most optimistic estimate is 1 hour (a = 1), the most pessimistic estimate is 8 hours (b = 8) and the most realistic estimate is 4 hours (m=4), then the best time estimate (Ta) would be:
Ta=(1+4*4+8)/6=(1+16+8)/6=25/6= 4.17 hours or 4 hours & 10 minutes.
When using this formula, all estimates must be in the same units (minutes or hours or days).
Here are a couple examples of scheduling software MS Project Pro for Office 365 and jxProject. jxProject is a freeware program available for Windows, Linux & Mac operating systems. It's not as feature rich as MSProject, but it is free. (MS Project Pro has a monthly cost of $30/month per user, but requires MIcrosoft Office which is $6/month per user. Microsoft is moving away from their "one time purchase" options for software.)
YouTube Video on MS Project Training
Some additional training info to be added soon.
In addition here's a link to 6 other "open source" Project Management Software programs.
In next week's class we'll introduce some "cloud based" solutions in our discussion of Online Collaboration.
HOMEWORK ASSIGNMENT:
The assignment below should be completed & all work submitted by Friday, March 3, 2017..
1.) Follow the YouTube Video link "How to Create a Gantt Chart in Excel" above and recreate the Gantt chart as done on the video. Your finished file should look similar to this:
2.) Create your own Gantt chart using the technique presented in the video above for a scheduling process with which you are familiar. It should have about 8-12 steps in the process.
3.) Using the Gantt Chart created in step 2, recreate the chart using MSProject .
4.) When you are done with the Gantt Charts created in steps 2 (& 3), create a printout of each file with your name on each sheet (electronically, not hand-written) and submit the hard copy to your instructor. (NOTE: If you need to create a pdf from any Windows program, download and install BullZip. This program will then appear to be a "printer" in your available printers list. When you select it and print, it will print a pdf file to the location you specify. I use this to create all of my Windows pdf files.) Then e-mail each file to your professor. Your e-mail should contain two files for each Gantt Chart. One file should be in the native program format (Excel and Project) and then you should create and include a pdf of each sheet as well. So your e-mail should have 4 files attached.
5.) When you have completed the assignment, post a "Reply" to this post stating that you have completed the assignment.
Week #4: (2/13-17) Scheduling & Gantt Charts, Software. HW Assignment
-
- Posts: 2393
- Joined: Fri Sep 04, 2015 6:59 pm
Re: Week #4: (2/13-17) Scheduling & Gantt Charts, Software. HW Assignment
Post by jariopelle »
I have completed the assignment.
Re: Week #4: (2/13-17) Scheduling & Gantt Charts, Software. HW Assignment
Post by arbeben0001 »
Completed
Re: Week #4: (2/13-17) Scheduling & Gantt Charts, Software. HW Assignment
Post by Dswaldron »
completed
-
- Posts: 13
- Joined: Tue Sep 12, 2017 6:16 pm
Re: Week #4: (2/13-17) Scheduling & Gantt Charts, Software. HW Assignment
Post by kakerr0001 »
Kevin Kerr completed week #4
Return to “EET-255 Lecture (Public)”
Jump to
- Electronics Systems - General Information
- ↳ Instructor Information
- ↳ Career Related Links and Information
- ↳ Career Information (General)
- ↳ Interviewing Skills
- 2024 Spring
- ↳ EET-250 Control Systems
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T./Automation
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ Information for All Students
- ↳ Progress Reports for Sorting Group
- ↳ Progress Reports for Vending Group
- ↳ Progress Reports for HVAC Group
- Previous Semesters
- ↳ 2023 Fall
- ↳ EET-101 PCs, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-120 Fluid Power Technology
- ↳ EET-200 Solid State Electronics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ 2023 Spring
- ↳ EET-250 Control Systems
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T./Automation
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ Progress Reports for Golfball Group
- ↳ Progress Reports for Car Assembly
- ↳ Lab Information for All Students
- ↳ 2022 Fall
- ↳ EET-101 PCs, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-120 Fluid Power Technology
- ↳ EET-200 Solid State Electonics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ EET-235L-D03 PLCs 2 Lab
- ↳ 2022 Spring
- ↳ EET-250 Control Systems
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T./Automation
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ Lab Information for All Students
- ↳ Automated Greenhouse - Weekly Progress Reports (Individual)
- ↳ 2021 Fall
- ↳ EET-101 PCs, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-120 Fluid Power Technology
- ↳ EET-200 Solid State Electronics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ 2021 Spring
- ↳ EET-120 Fluid Power
- ↳ EET-250 Control Systems
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T./Automation
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ End of Semester Project Requirements
- ↳ Allen Bradley Information
- ↳ Conveyor Information
- ↳ Dobot Information
- ↳ EP-250 Pneumatic Trainer Info
- ↳ Fanuc Information
- ↳ Keyence SZ-01S Laser Safety Scanner
- ↳ Misc. Knowledge Base
- ↳ Misc. Lab Equipment Documentation
- ↳ Really Old Forums
- ↳ 2020 Fall
- ↳ Linux - General help
- ↳ EET-101 PCs, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-120 Fluid Power
- ↳ EET-200 Solid State Electonics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ ELE-111L Internet of Things Lab
- ↳ Basic Subnetting
- ↳ 2020 Spring
- ↳ EET-120 Fluid Power
- ↳ EET-240 Robotics & Automation
- ↳ EET-250 Control Systems
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T./Automation
- ↳ EET-260 Micro-Processor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ Lab Information for All Groups
- ↳ Weekly Progress Reports - Carwash Project
- ↳ Weekly Progress Reports - Filling Project
- ↳ 2019 Fall
- ↳ CSE-110 Information, Reading and Video List
- ↳ CSE-110 - General Information
- ↳ EET-101 PCs, Robots & Programming
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-104/5/6 Safety, Diagrams, Troubleshooting
- ↳ EET-104 Safety & Health in Industry (Mondays)
- ↳ EET-105 Technical Diagrams for Automation (Wednesdays)
- ↳ EET-106 Troubleshooting (Fridays)
- ↳ EET-120 Fluid Power
- ↳ EET-200 Solid State Electronics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital & Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ EET-250 Control Systems
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-260 Micro-Processor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ 2019 Spring
- ↳ EET-101 PC's, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-120 Fluid Power
- ↳ Fluid Power (Public)
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ EET-235 PLCs 2
- ↳ EET-235 Lecture
- ↳ EET-235 Lab
- ↳ EET-250 Control System Theory
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T./Automation
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265L Lab - Day
- ↳ Weekly Progress Reports - Cold Beverage Dispenser
- ↳ Weekly Progress Reports - Warehouse Storage/Retrieval
- ↳ EET-265L Lab - Evening
- ↳ ELE-111 Internet of Things
- ↳ ELE-111 General Information
- ↳ ELE-111 Reading List
- ↳ ELE-115L - Bigos
- ↳ General
- ↳ Mech-Elec WFD Training
- ↳ Mech-Elec (Public)
- ↳ Mech-Elec WFD Training -Cohort 2
- ↳ 2018 Fall
- ↳ CSE-110 Intro to Comp (A+)
- ↳ CSE-110 General Information
- ↳ EET-101 PC's, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-104/105/106 Safety & Health, Tech Diagrams, Troubleshooting
- ↳ EET-104 Safety & Health in Industry
- ↳ EET-105 Technical Diagrams for Automation
- ↳ EET-105 Public
- ↳ EET-106 Developing Troubleshooting Skills
- ↳ EET-200 Solid State Electronics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ 2018 Spring
- ↳ CSE-110L-Intro To Comp
- ↳ CSE-110L General
- ↳ CSE-220 Security Reading List
- ↳ EET-120 Fluid Power Technology
- ↳ EET-120 Fluid Power (Public)
- ↳ EET-250 Control System Theory
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in EET/Automation
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ Weekly Progress Reports - Post Weekly Progress Reports here.
- ↳ 2017 Fall
- ↳ CSE-110 Intro To Computers (A+)
- ↳ CSE-110 Information
- ↳ EET-101 PCs, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-104/105/106 Safety/Tech. Diagrams/Troubleshooting
- ↳ EET-104 Safety & Health in Industry
- ↳ EET-105 Technical Diagrams for Automation
- ↳ EET-106 Developing Troubleshooting Skills
- ↳ EET-200 Solid State Electronics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ 2017 Spring
- ↳ General Resouces
- ↳ CSE-110 Intro to Comp
- ↳ CSE-110 Reading List & General Information (Public)
- ↳ CSE-160 Intro To Programming (Python)
- ↳ CSE-240 Resources
- ↳ EET-120 Fluid Power
- ↳ EET-250 Control System Theory
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T.
- ↳ EET-255 Lecture (Public)
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ Allen-Bradley Micro820 PLC Info
- ↳ Trail Mix Vending Machine - Evening
- ↳ Progress Reports
- ↳ Support Information
- ↳ Team Fluid Processing - Day
- ↳ Progress Reports
- ↳ Support Information
- ↳ Team Warehouse Stocking/Retrieval - Day
- ↳ Progress Reports
- ↳ Support Information
- ↳ ELE-111 Internet of Things (IOE)
- ↳ General Information
- ↳ 2016 Fall
- ↳ CSE-140 Operating Systems 1
- ↳ General Information
- ↳ CSE-110 Intro To Computer Systems
- ↳ General Information
- ↳ CSE-150 Linux Command Line and Shell Programming
- ↳ General Information
- ↳ CSE-160 Intro To Programming Using Python
- ↳ General Information
- ↳ CSE-220 Computer and Network Security
- ↳ General Information
- ↳ CSO-205 Cisco Scaling Networks
- ↳ EET-101 PCs, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-104/105/106 Safety, Tech. Diagrams & Troubleshooting
- ↳ EET-104 Safety & Health in Industry
- ↳ EET-105 Reading Technical Diagrams
- ↳ EET-106 Developing Troubleshooting Skills
- ↳ EET-200 Solid State Electronics
- ↳ EET-200 Lecture
- ↳ EET-200 Lab
- ↳ EET-210 Digital and Linear Circuits
- ↳ EET-210 Lecture
- ↳ EET-210 Lab
- ↳ EET-250 Control System Theory
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ ELE-110 Electronics For Techs 1
- ↳ General Information
- ↳ ELE-120 Printed Circuit Design
- ↳ General Information
- ↳ ELE-130 Intro To Project Management
- ↳ General Information
- ↳ ELE-210 Circuit Theory
- ↳ General Information
- ↳ ELE-250 Research and Development
- ↳ General Information
- ↳ 2016 Spring
- ↳ CSE-110 Intro To Computer Systems
- ↳ CSE-110 General Information
- ↳ Linux and Programming
- ↳ CSE-150 Linux and Shell Programming
- ↳ CSE-150 General information
- ↳ CSE-160 Introduction to Programming with Python
- ↳ CSE-160 General
- ↳ CSE-220 Computer and Network Security
- ↳ CSE-220 General Information
- ↳ CSE-240 Operating Systems 2 (Windows 2012 Server)
- ↳ CSE-240 General Information
- ↳ CSE-260 Application Servers
- ↳ CSE-260 General
- ↳ ELE-111 Internet of Everything (IOE)
- ↳ ELE-111 General
- ↳ ELE-115 Electronics for Techs 2
- ↳ ELE-115 General Information
- ↳ ELE-265 Senior Projects
- ↳ EET-120 Fluid Power Technology
- ↳ EET-130 Fundamentals of Motor Controls
- ↳ EET-135 PLCs 1
- ↳ EET-140 Fundamentals of Robotics
- ↳ EET-250 Control System Theory
- ↳ EET-250 Lecture
- ↳ EET-250 Lab
- ↳ EET-255 Advanced Topics in E.E.T.
- ↳ EET-260 Microprocessor Applications
- ↳ EET-260 Lecture
- ↳ EET-260 Lab
- ↳ EET-265 Advanced Automation
- ↳ EET-265 Lecture
- ↳ EET-265 Lab
- ↳ 2015 Fall
- ↳ 2015 Fall
- ↳ CSE-110 Intro to Computer Systems
- ↳ CSE-110 General
- ↳ CSE-140 Operating Systems 1
- ↳ CSE-140 General
- ↳ CSE-150 Linux Command and Shell Programming
- ↳ CSE-150 General
- ↳ CSE-155 Intro to Programming
- ↳ CSE-155 General Information
- ↳ CSE-220 Computer and Network Security
- ↳ CSE-220 General
- ↳ CSO-105 Cisco Networking
- ↳ CSO-105 General
- ↳ CSO-205 Cisco 3 Reading List
- ↳ ELE-111 Internet of Everything
- ↳ ELE-111 General
- ↳ ELE-111 Reading List
- ↳ ELE-121/2/3 Documentation
- ↳ ELE-121/2/3 General
- ↳ ELE-130 Intro to Project Management
- ↳ ELE-130 - General
- ↳ ELE-210 Circuit Theory
- ↳ ELE-210 General
- ↳ ELE-210 Lab (Private)
- ↳ EET-101 PCs, Programming & Robots
- ↳ EET-101 Lecture
- ↳ EET-101 Lab
- ↳ EET-104 Safety & Health in Industry
- ↳ EET-105 Technical Diagrams for Automation
- ↳ EET-106 Developing Troubleshooting Skills
- ↳ EET-120 Fluid Power Technology
- ↳ EET-135 PLCs 1
- ↳ Lecture
- ↳ Lab
- ↳ EET-140 Fundamentals of Robotics
- ↳ Lecture
- ↳ Lab
- ↳ EET-200 Solid State Circuits
- ↳ Lecture
- ↳ Lab
- ↳ EET-210 Digital & Linear Circuits
- ↳ Lecture
- ↳ Lab
- ↳ EET-240 Robotics/Automated Systems
- ↳ Lecture
- ↳ Lab
- ↳ EET-265 Advanced Automation
- ↳ Lecture
- ↳ Lab/Project
- ↳ E-Makers's Club
- ↳ E-Makers General information
- ↳ Meeting schedule and locations.