Hello, my name is Mrs. Holbrook and welcome to Computing.

I'm so pleased you've decided to join me for the lesson today.

In today's lesson, we're going to be creating planning documents for a project and then we'll move on to start creating project products.

Welcome to today's lesson from the unit, using IT in project management.

This lesson is called Execute Your Own Project.

And by the end of today's lesson, you'll be able to create planning documents for a project and then use these plans to create project products.

Shall we make a start? We will be exploring these key words in today's lesson.

Let's take a look at them now.

Audience.

Audience, a group of people for whom the prepared media is intended.

Purpose.

Purpose, what the media is being created for.

For example, to entertain.

House style.

House style, a company's preferred manner of presentation.

Look out for these keywords throughout today's lesson.

Today's lesson is split into two sections.

We'll start by creating planning documents for a project and then we'll move on to create project products.

Let's make a start by creating planning documents for a project.

Understanding the project scope helps you to define clear boundaries, set realistic goals, and ensure everyone is aligned on what the project will and won't include.

Now that the initiation stage is complete, you need to start planning for the project.

I have a quick question for you to check your understanding.

Which planning tools can be used to show a timeline of tasks that need to be completed in a specific order? Is it A, a line graph? B, a Gantt chart.

C, a feasibility report, or D, a PERT chart? Pause the video whilst you think about your answer.

Did you spot which ones were correct? Well done.

Both a Gantt chart and a PERT chart are planning tools, which can be used to show a timeline of tasks that need to be completed in a specified order.

The tools you have learned about using to create a time focused plan are Gantt charts and PERT charts, which stands for Programme Evaluation and Review Technique.

Just as a recap, using Gantt charts and schedules helps you to visualise the project timeline, identify task dependencies, so where one task needs to be completed before another and plan your work more efficiently.

You will now create a Gantt or PERT chart to map out the Team Outdoor Obstacles project.

If you are not familiar with the Team Outdoor Obstacles project, the project brief is supplied as an additional resource for this lesson.

It's up to you which planning tool you choose.

You could choose a Gantt chart or you could choose a PERT chart.

There are templates for both Gantt and PERT charts for you to use as additional resources for today's lesson.

Here's the Gantt chart template.

So you can see we've got the title which says Team Outdoor Obstacles Gantt charts, and then we've got spaces for the tasks, the lessons that you're going to complete them in, and the start and end times.

Some conditional formatting has been applied and a function added to indicate if a task is 100% complete.

To activate the conditional formatting, type the full stop symbol into the cell next to the task and it will turn green.

This will activate the IF function to display 100%.

As a note, do not use green as a cell colour when mapping the time on the timeline.

That's because the main tasks are highlighted in green and you won't be able to see the difference between the main task and the sub tasks.

Alternatively, you could use the PERT chart template.

This template has been set up with symbols for you to use as a starting point.

But remember, they won't all be consecutive in a line like they are at the top here.

Depending on how many tasks you've identified, you will most likely need to duplicate some of these symbols.

Continue the numbers so that there is one for each task added to the task list and copy and paste more if needed.

Drag the shapes into position in the order in which the tasks must be completed.

Connect the shapes using arrows to show the direction of the task path.

You will use the Gantt or PERT chart to map the smart goals for the Team Outdoor Obstacles project linked to your lesson timings.

Time to check your understanding.

What does PERT stand for? Is it A, Planning Evaluation and Review Tool? B, Prior Evaluation and Reflection Technique.

Or C, Programme Evaluation and Review Technique? Pause the video whilst you think about your answer.

Did you select C? Well done.

PERT stands for Programme Evaluation and Review Technique.

Okay, we're moving on to our first task of today's lesson.

I'd like you to choose your preferred planning template, so either a Gantt chart or a PERT chart.

I'd like you to use your smart goals to complete the tasks column.

Map out the timings and dependencies for each task.

Remember, if you need to remind yourself about the project objectives for the Team Outdoor Obstacles Project, you can find the project brief as a linked resource for this lesson.

Pause the video here whilst you complete the task.

Okay, so you've created some planning documents for a project.

We're now going to move on to create some project products.

So far, you've completed a time-focused plan that allowed time for the poster and business card sketch planning.

Now, you need to design the poster and business card.

Time to check your understanding.

I have a matching activity for you? In the planning stage, you need to remember the following.

Can you match the words to the definitions? So our words are audience, purpose, and house style.

And our definitions are, what the intention of the product is or what it will do.

Font style and colours associated with the business.

And who the product is for.

Pause the video here while you match the words to their definitions.

How did you get on? Did you manage to match the words to their definitions? Well done.

Let's look at the answers together.

So audience is our first one.

Audience, is who the product is for.

Purpose, what the intention of the product is, what it will do.

And then lastly, house style.

The font style and colours associated with the business.

Remember the key things you need to include on your poster.

One, what obstacles are available.

Two, how many team members are needed per event.

Three, the minimum outdoor area needed.

And four, the type of surface needed for the course to be set up on.

Remember the key things you need to include on your business card.

One, the company logo.

Two, the contact name, which is Dave Venture.

Three, the contact number, which is 07789 901243.

The website address, www.

TOO.

co.

uk.

Remember, you'll also need to consider a house style to create consistency across the project and reinforce the brand image.

So a house style consists of, the colours you choose to use, the fonts you use and the font sizes.

Visual designs.

Use the document provided as an additional resource for the lesson to choose the images that you will use in your designs.

You don't have to use all of the images provided.

You can just choose the ones you want to.

In this document, you'll also find the Team Outdoor Obstacles logo, which you need to use.

Your visual designs must be completed before you can progress to the execution stage.

You have 10 minutes for this activity.

Pause your video here whilst you go and create your visual designs or sketches for your poster and your business card.

How did you get on with your visual designs? Did you manage to sketch out some ideas? Well done.

Let's have a look at Aisha's sketches.

So this is Aisha's poster design.

So she's got the Team Outdoor Obstacles logo at the top.

She's used a green and yellow colour scheme, which matches their logo, so that's a really good idea.

We've got some house style there.

She has got a picture of an obstacle and the name of the business, fairly big at the top of the leaflet.

And then at the bottom she's got some information about how to book, what the obstacles are available for, et cetera.

Let's now have a look at Aisha's Business card design.

So again, the same colour schemes have been used and she's included the Team Outdoor Obstacles logo.

She's got the name of the contact, which is Dave Venture with the contact telephone number and the website address, which is www.

TOO.

co.

uk.

Okay, we are now moving on to think about the execution stage.

You now have three products to develop.

One, the sale sheet.

Two, the poster.

And three, the business card.

You have been provided with two documents to support the execution stage.

One, the sale sheet spreadsheet.

And two, the image sources that you can use for your products.

Remember, this includes the Team Outdoor Obstacles logo as well.

Let's quickly recall the objectives for the sales sheet spreadsheet.

One, the sales price is calculated after 33.

3% profit is added to the cost price.

Two, a visual indication if any of the items are out of stock on-site.

Three, a total of monies made from sales for each item.

Four, an indication, numerically or textually of profit or loss.

Five, a total profit for the day.

And six, a charitable donation of 5% from the profit made on the day.

So here's an example of the blank sale sheet that you've been provided.

So you can see we have the merchandise type.

With things like T-shirts, mugs, lanyards, et cetera.

We have the cost and then we have some empty columns, which you're going to need to populate.

The highlighted areas are where you will apply functions and formulas.

So total stock, profit added per item, sale price, out of stock on-site, total sales, profit or loss are all calculated using either a functional formula.

The stock on-site and number of items sold tabs are where you will enter values to check that the formulas and functions work correctly.

So you can just add some test values in here if you need to.

Okay, time to check your understanding.

Can you explain what this formula does? So it's =B7-C7.

Pause the video whilst you have a think.

(no audio) Did you manage to explain what the formula does? Well done.

Let's have a look at a sample answer together.

Aisha says, this formula subtracts the value in C7 from the value in B7.

Well done Aisha.

That's correct.

Can you now explain what this formula does, =B7*C7? Pause the video Whilst you have a think.

well done.

Let's have a look at a sample answer together.

Aisha says, this formula multiplies the value in B7 by the value in C7.

So remember, we use the asterisk for multiplication in a spreadsheet.

Can you explain what this function does, =sum(J7:J15)? Pause the video whilst you have a think.

Did you manage to explain what the function does? Well done.

Let's look at a sample answer together.

Aisha says, this function calculates the sum of the values in cells J7 to J15.

So it's going to add all of the values in those cells up.

Well done Aisha.

Let's have a look at this next one.

Can you explain what this function does? So, =B7*33%.

Pause the video whilst you have a think.

(no audio) Did you spot it? Well done.

This formula calculates 33% of the value held in B7.

This is gonna be really useful for our spreadsheet because we need to add a profit of 33% to our selling price.

Let's have a look at this last one together.

Can you explain what this function does? This one's a bit longer than the others.

So, =IF(J7>0,"PROFIT","LOSS") Can you remember what the IF function does? Maybe pause the video whilst you have a think.

Did you manage to explain what the IF function does? Well done.

Let's look at a sample answer together.

Aisha says, this function returns PROFIT if the value in J7 is greater than zero, or LOSS if not.

So remember, the first value in speech marks, if the value is true.

And then the second value in speech marks is if the value is false.

Okay, we're moving on to our second task of today's lesson, task B, and you've done a fantastic job so far, so well done.

For part one, use the sales sheet template to create a working spreadsheet for the business.

For part two, use your designs to create a poster to advertise the services that Team Outdoor Obstacles can offer at a competitive and/or charitable event.

And then for part three, use your designs to create a business card.

Pause the video here whilst you complete the task.

How did you get on? Did you manage to create your products? Well done.

Let's have a look at some solutions together.

So here's an example of the spreadsheet solutions.

Because this screenshot is quite small, you can access the solutions as an additional material for this lesson.

But you can see here, we've added a formula or function to each cell in the spreadsheet, and our conditional formatting is working if the product is out of stock on-site.

Here's an example, poster design.

So Aisha's turned her initial sketch into a finished product.

And it looks really professional.

Well done Aisha.

So we've got Team Outdoor Obstacles, logo at the top, and we've got the name of the business in a fairly big, bold font.

We've got a picture of the inflatables and then we've got some information about how to book, including the company's website.

And now here is Aisha's Business card design.

Again, she's converted her initial sketch into a finished product and this looks really professional.

So we've used the Team Outdoor Obstacles logo.

We've got a suitable graphic from the file provided, and we've got the right contact details.

So we've got Dave Venture.

The telephone number, 07789 901243, and the website, which is www.

TOO.

co.

uk.

Great job Aisha.

Well done.

Were your Business card and poster as successful as Aisha's? I'm sure they were.

Well done.

Okay, we've come to the end of today's lesson, Execute your own project.

Let's summarise what we've learned in this lesson.

Understanding the project scope helps you to define clear boundaries, set realistic goals, and ensure everyone is aligned on what the project will and won't include.

Using Gantt charts and schedules helps you to visualise a project timeline, identify task dependencies, and plan your work more efficiently.

Keeping clear product documentation helps you to record decisions, facilitate future updates, and support users or developers.

I hope you've enjoyed today's lesson and I hope you'll join me again soon.

Bye.