Gantt Chart

Loading...

来自 Moscow Institute of Physics and Technology 的课程

Grant Proposal

30 个评分

Moscow Institute of Physics and Technology

Grant Proposal

30 个评分

课程 3（共 5 门，Specialization English for Research Publication Purposes）

The course provides guidance on developing a strong application that will allow reviewers to better evaluate the science and merit of your proposal. You will learn how to put your ideas into proper words, arrange a clear and concise paper and search grant market for potential funder. You will also learn how to react to negative feedback from reviewers and resubmit your proposal. The course focuses on useful project management tools and possible budget pitfalls.

从本节课中

MODULE II: READY TO COUNT AND DEMONSTRATE

In this module you will discover tools which help to organise project work in an effective way. Lectures provide basic information about scheduling the project and team management. Another crucial skill you will acquire is how to estimate and justify project costs, as well as describing budget in the narrative. You will also be able to demonstrate information in numbers and visuals, which is a valuable feature of any grant proposal.

Team Management6:40

Gantt Chart7:16

与讲师见面

Elena Bazanova
Director of the Language Training and Testing Center
Moscow Institute of Physics and Technology
Varvara Sosedova
PhD in Philology
Moscow State University of International Relations

[MUSIC]

As we have mentioned in the previous lecture,

Gantt charts are a really helping to in visualizing project timing.

Besides, it's one of the most accessible and effective instruments of planning.

Gantt charts outline all the tasks involved in a project.

And they are ordered shown against the time scale.

This gives you an instant overview of a project, its associated tasks,

and when they need to be finished.

Now there are many software programs that can simplify the whole planning process.

You can find quite a number of them if you type

Gantt Management Software on the Internet.

These are or match ware or some others.

Some of these tools are cloud-based, meaning that you and

your team can access the documents simultaneously from any location.

The majority of such programs are understandably not for free though.

However, if you do not have money to install specialized software,

there is Excel that can easily be a substitute.

In this video,

we would like to demonstrate how to create Gantt chart in Excel.

As you remember from previous lectures, the first and foremost task is to make

the most scrupulous plan, assess timing for each task, and define their ordering.

Don't forget to mark who's responsible for this activity.

First, you list all the activities and their estimated timing as we did earlier,

but now you need add the type of the task.

The chart shows the relationship between the tasks in the project.

Some tasks will need to be completed before you can start the next one,

and until preceding ones have ended.

So for example, if you are creating handouts,

you need to finish the design before you can send them to print.

So, you identify which of your project tasks are parallel and

which are sequential.

In our case, a fragment of such table will look like this,

we mark parallel activities as Ps and sequential activities as S.

And we should define what we mean by at-risk families first.

And only after that, it will be possible to publicize study services and

determine how many hours of assistance participants will receive.

So the latter two are marked with s letter and depend on the first task.

Task three should follow task two,

whereas acquiring office space should go in parallel with it.

Next, when such a table is complete, it's time to get down to Excel planning.

Here, you'll need to state exact task and end date of the tasks.

After that, on the top menu select Insert and then click on the Bar Chart icon.

Choose the flex Stacked Bar chart and

this will insert a blank chart onto your spreadsheet.

Now add start date data.

To do this, you position your mouse over the empty Excel chart and right click.

Then you click on the select data.

The select data source we enter will appear.

And under legend entries you click add.

Click on the icon at the end of the series values field,

this will open the added series window.

Here you need to click on the first start date, and

drag your mouse down to the last start date.

After the right date highlighted,

click on the icon at the end of the edit series form.

The window will close and the previous window will reopen.

Just select OK.

So your start dates are now in the Gantt chart.

Next, you add the durations column using the same procedure you used to add

the start dates.

After that, you can format your chart.

What you have is a stacked bar chart and the starting dates are blue, and

the durations are orange.

Notice your tasks are in reverse order now.

To fix this, you click on the list of tasks to select them.

Then right-click off of the list, and choose Format Axis.

You select the checkbox, Categories in reverse order, and close.

Then highlight the blue portions of this bar.

Clicking on the blue part of any bar will select all of them.

Then right click and choose format data series.

Click on fill and then select no fill.

Click on border column then select no line.

You're almost finished.

You just need to remove the empty white space at the start of your Gantt chart.

To do that, click on the first start date in your data table.

Right-click over it.

Select Format Cells and then General.

Write down the number you see.

And then in the Gantt chart, select the dates above the bars.

Right-click and choose Format Axis.

You change the minimum bound to the number you recorded.

Change the major unit to 2 for every other date.

You can play with this to see what works best for you.

Then you select Close.

If you want to make your Gantt Chart look a little nicer,

remove most of the white space between the bars.

Click on the top orange bar, then right-click and select Format Data Series.

Set gap widths to 10%.

You're done.

Update your chat to indicate changes as soon as they occur.

This will help you to keep your plan and team up to date.

When you create a chart, it's recommended to use different colors for

different stages.

And one color, for example red should be chosen to indicate critical time limit.

So that all team members were aware of emergency and

could be relocated to deal with the most urgent task.

Though these tools might look somehow confusing at first, taking advantage of

computer planning, who help your organized your work in highly effective way.

So time spent on project planning will pay back in accuracy and

clarity of the grant proposal.

探索我们的目录

免费加入并获得个性化推荐、更新和优惠。

Coursera 致力于普及全世界最好的教育，它与全球一流大学和机构合作提供在线课程。

© 2019 Coursera Inc. 保留所有权利。

通过 App Store 下载

通过 Google Play 获取