Financial model work

For this next part of the project, you need to create a financial model using Google Sheets.  Spreadsheets are used to work out the costs, revenue (income) and whether the company is making a Profit or a Loss.  If the company is making a loss, then changes can be made, eg raising the ticket prices, extending opening hours, etc.

The costs for Mayhem Manor is the building of the new log flume ride.

The revenue is the money coming in from ticket sales.

The link below takes you to a Google Sheet which I have set up as a template and has hints on how to calculate totals, and the Profit/Loss. There is also a link to the data or figures / numbers needed to input into the financial model

Link to spreadsheet

Link to document of data for financial model spreadsheet

You will need to make a copy of the spreadsheet before you can use it (File - Make a Copy).

When you have completed it, please share it correctly (Share - Advanced - change from Private to Anyone at Cooper School with the link).

Copy/paste the link to your blog post with the website link already on it.

Update/Publish

Theme Park Unit

In this unit you will be producing work as though you were working for a theme park company.

Here is a link to my slideshow which explains all the tasks you have to do, plus providing the info you need for each task.

This is the only post for this unit as you will be working through the slideshow tasks at your own pace (within reason - I'll be nagging those who, in my opinion, are working too slowly!).

Link to slideshow of tasks and info

Networks unit test

Here is the link to the Networking unit test....

Networks test

Networks Lesson 5 - Computer Laws

In this lesson you will learn what the 3 laws are that affect computer use.

Objectives and Outcomes

• be able to explain what the 3 computing laws are (band 4)
• be able to apply this knowledge to create a poster (band 5)
• be able to link this knowledge with the work you do in school and what you should do to ensure you stay within the law (band 6)

You are to create a poster for secondary school students about these three Laws.  You will be using Google slides.

All information and tasks for this work is explained further in this slideshow....

Computer Laws and lesson tasks

Networks Lesson 4 - The Internet

In this lesson, you are going to learn how the internet started, how it works and exactly how data is transmitted.

Objectives and Outcomes

• be able to explain what the internet is, how it started and how it works (band 4)
• be able to apply this knowledge by creating a slideshow that explains this in detail (band 5)
• be able to link this knowledge to the need for internet protocols (band 6)

Here is a link to my slideshow with information you will need, plus the tasks for the lesson....

Slideshow about the internet

Networks - Lesson 3 Network Topologies

In this lesson, you'll learn about network topologies.  You'll have to read through the slideshow to find out what these are!

Objectives and Outcomes

• be able to explain what a network topology is (band 4)
• be able to apply this knowledge by describing the 3 main topologies (band 5)
• be able to link this knowledge to advantages and disadvantages of each topology and make recommendations according to an organisation's needs (band 6)

Here is a link to my slideshow on network topologies, including the tasks for this lesson!


Slideshow about network topologies

Networks - Lesson 2

In this lesson, you will learn about WANs and how they differ from LANs.

Objectives and Outcomes

• be able to explain what a WAN is (band 4)
• be able to apply this understanding to creating a slideshow explaining how they work (band 5)
• be able to link this knowledge to real life by giving specific examples of how a WAN works (band 6)

Here is the link to my slideshow about WANs........

Link to slideshow on WANs

Bronze - create a slideshow with images that explains what a LAN and a WAN is and the differences.

Silver - create a slideshow with images that explains what a LAN  and a WAN is and the differences, plus an explanation of how data is transmitted.

Gold - As for silver but include animations and link the band 6 work, giving specific real-life examples of how a WAN works.

HTML Test

Here is the link to the HTML test.

Make sure you read the questions carefully and answer all of them.

https://docs.google.com/forms/d/e/1FAIpQLSftIH2X5jVHi3LCTN33BMhE4Kht2K2XNeDkZIcMYXlHghFUPA/viewform?usp=sf_link

HTML Tags Revision

Here are the tags we used in the HTML unit and you need to remember!

To start and end the program   <html> </html>

To create a labelled ‘internet’ tab at the top of the page

<head>

<title>    </title>

</head>

To make a main heading on the page  <h1> </h1>

To make a sub-heading on the page <h2>   </h2>

To make a new paragraph   <p> </p>

To make a line break  <br> There is no closing tag for this one

To change the font style   <font face =”name of font”> </font>

To change the size of font  <font size = “size of font”>  </font>

To change the colour of font < font color=”colour name or hexadecimal code”>   </font>

To align the font on the page (ie left, centre or right)  <font align = “position”>   </font>     Remember to spell it ‘center’  - American style!

To add an image <img src=”image address”>    </img src>

To add a hyperlink to aother page <a href = “name of page”>    </a>

To embolden the font <b>   </b>

To turn the font italic <i>   </i>

To underline the font <u>   </u>

Networks - Lesson 1

This lesson you will be learning about how computers can be networked together and the advantages and disadvantages of doing so.

Objectives and Outcomes

• Be able to describe what a computer network is (band 3)
• Be able to explain how computers can be linked together (band 4)
• Be able to apply your knowledge stating the advantages and disadvantages of networking computers (band 5)

Here is a link to my slideshow which provides information, the tasks for the lesson and states the evidence I need to see for this lesson.

Slideshow for Networks Lesson 1

HTML Lesson 4 onwards

You're carrying on adding more content to your web pages and adding more pages!

Task 1
You need to open this worksheet   HTML code worksheet.

Make a copy (file - Make a copy), complete it, share it to Anyone with the link, and copy/paste the link to a new post titled the same as this one.

Task 2

Add more content and pages!

Check out this slideshow for more help on adding extra info and tags to your pages   Extra web page ideas and tags

You can also go back to my previous posts for slideshows on adding content (images, formatting text, etc) and tags for hyperlinking pages


Evidence 
Get your 'Share' link from your repl.it and copy/paste it to your post, underneath your link to your completed worksheet.

Publish  at the end of the lesson!

Bronze - at least 2 pages of content, at least 1 image and pages hyperlinked together

Silver - at least 2 pages of content, at least 1 image on each page, pages hyperlinked and text formatted

Gold - as above but more pages, more images, formatted text, external hyperlink

HTML Lesson 3

In this lesson you are continuing to add more information to your webpages, make sure they are linked and also add some images.

Objectives and Outcomes

• Be able to explain how text can be formatted in HTML (band 4)
• Be able to apply new skills to adding images to your page (band 5)
• Be able to link this work by showing on a webpage of your choice, where the images are coded in HTML for that page (band 6) (Copy/paste a screenshot to a Google slide, label it and share and link to your post.)

Today's tasks

1.  Make a new post for this lesson and title it the same as this one.

2.  Log into your repl.it account and load up the pages you made last lesson.

3.  A recap on what you've learned so far....

Go to this worksheet..... Recap worksheet
Make a copy of it and fill it in (you can use my slideshow from last lesson or your webpage coding to remind you).
Share it to Anyone with the link and copy/paste the link to today's blog post.

4.  Go to this slideshow....... HTML Lesson 3 slideshow
Read through all the slides and complete the tasks. 

Don't forget to get your repl.it Share link and copy/paste it to your blog post (along with Band 6 Google doc if done) and publish!

HTML Lesson 2

Objectives and Outcomes

• Be able to explain what the tags you have used today do on a webpage (band 4)
• Be able to apply your learning to your webpage design (band 5)
• Be able to link this learning to other webpages on the internet, identifying where the tags you have learned have been used (band 6)

Here is the link to my slideshow.  Work your way through the tasks, providing evidence as asked on the final slide.

Link to HTML Lesson 2 slideshow

Bronze - create a webpage that uses the following tags: <html></html>, <head></head>, <title></title>, <h1></h1>, <body></body>, <p></p>.  Also, try to centre-align a heading.

Silver - create 2 webpages that include all the above tags, plus change the font style (font face) and font colour. 

Complete the written work on slide 16 on your blog post as well as adding the shared link to your repl.it work.

Gold - all of silver, plus line breaks <br> and at least 2 different headings.

Complete all the written work as stated in silver, but also, complete the Band 6 work as explained on slide 16.

HTML Lesson 1

In this unit you are going to learn how to program in HTML.  This is the programming language used to create webpages.

Lesson Objectives and Outcomes

• be able to explain what HTML coding is and what it is used for (band 4)
• be able to apply your learning to create a webpage (band 5)
• be able to link this to other programming languages you have used and compare the two (ease of use, how the commands differ, etc) (band 6)

Here is the link to my slideshow that has all the information, links, screenshots and tasks that you'll need for this lesson...

HTML lesson 1 slideshow

Don't forget to publish your blog post at the end of the lesson!

Overview of Computing GCSE - information for options

Here is a link to a slideshow giving some information about GCSE Computing.

For any more information about the subject, you will need to speak to Mr Malins

https://docs.google.com/presentation/d/1gYUeM70PX6sS227VjBEts9bjHlsuNlz-7nUp-RxyTWY/edit?usp=sharing

Python assessment test

Here is the link to the test.  It's in Google forms. Just fill it in and, hopefully, it'll work this time!


Python test

Python Consolidation Lesson 5

This lesson is about consolidating all that you have learned in this unit about programming in Python.

Here is a link to my slideshow which has screenshots of programming we have used for different tasks, plus the tasks for you to do this lesson....

Slideshow of reminders and tasks for the lesson

Bronze - you can choose any task

Silver - you can choose any tasks, except Task A

Gold - you can choose any task, except Tasks A and B

I will come round and check your progress.  As you complete each Task, put your hand up to show me that the program works and I'll mark it off.
I shall expect to see at least 2 ticks per person n my mark book by the end of the lesson!

First lesson back after half term - you have  a test on Python!

Python Lesson 4 - Selection

In this lesson you are going to learn how to use 'selection' in a program.  You've used simple selection before in your Scratch Pacman program last year, eg making a blob disappear when the Pacman touched it and the score changed by 1.

Objectives and Outcomes

• Be able to explain why selection is useful in a program (giving an example will help with this) (band 4)
• Be able to apply this by creating a 'virtual barman' program in Python (band 5)
• Be able to link this to an example of where you have used selection in a program last year (band 6)

Tasks

1.  Open a new blog post and title it the same as this one.

- Explain on your post why selection is useful in programming, giving an example to help your explanation.

2.  Complete the task/s set on Slide 16 of my slideshow - creating your own 'virtual barman' Python program.

Link to slideshow

Don't forget to paste screenshots to a Google doc as evidence of your work for this lesson!

3.  Complete the extension programming task on Slide 16.

4.  Link this work to Scratch programming last year to achieve band 6 - do this on your blog post.

5.  Share your Google doc correctly (Advanced - change from Private to Anyone with the link) and copy/paste link to your post, underneath your writing for Task 1.

Publish!!

Python Lesson 3

In this lesson, you are going to learn how to program maths calculations in Python

Objectives and Outcomes

• To understand that data comes in different 'types'.
• To be able to describe a types of data (band 3)
• To be able to explain why a computer needs to know what the data type is for a given input / variable (band 4)
• To be able to apply this knowledge to create a program that performs arithmetic calculations (band 5)

1.  Open a new blog post and title it the same as this one.

2.  On your post, explain why we have to tell the program what type of data is being stored in a variable.  My slideshow will help you with this...

Here is the link to my slideshow that explains all of the above

Data types and maths in Python

Here is the link to the summary sheet (page 1) and the Maths Programming Tasks (page 2)

Programming Maths Tasks

All programs, once run and working, need to be screenshotted and pasted to a Google doc, one after the other.

Bronze - complete Tasks 1 -3 

Silver - complete Tasks 1 - 4

Gold - complete Tasks 1 -5

Those wanting to opt for Computer Science GCSE, try to do the Extension task as well

Share Google doc (Click Advanced - change from Private to Anyone with the Link) and copy/ paste link to your blog post underneath your writing.

PUBLISH!!

Python - Lesson 2

This lesson you are going to learn how to print questions and print the user's answers on the screen.  The user's answer is stored in a 'variable' (like a box) in the RAM of the computer; it's called a variable as it can change depending on who is answering the question and what they choose to answer.

Objectives and Outcomes

• Be able to describe what a 'variable' is (band 4)
• Be able to apply this knowledge by writing a program in Python that uses variables (band 5).
• Be able to link this idea of variables and inputs to previous work in other programming, eg. Scratch (band 6).

1.  You will need to open a new blog post titled the same as this one.

2.  Open a tab for my blog and go to my post for this lesson.

3.  Open up the Python programming site  https://repl.it/ 

4.  Go to my slideshow for this lesson which has info and tasks...

Python Lesson 2 slideshow

5.  Read through the slideshow, completing tasks as you go.  It will tell you where and how you should evidence your work for these tasks.

6.  Complete task 1 (slide 7), task 2 (slide 8), task 3 (slide 11)

7.  Also complete task 4 (slide 11), task 5 (slide 12)

8.  Also complete task 6 (slide 14)

9.  Share your Google doc (Advanced - change form Private to Anyone with the link) and copy/paste the link to your blog post.

Publish!

Python - Lesson 1

Objectives and Outcomes

• Be able to explain what Python is and why it is important (band 4)
• Be able to apply your understanding to create short programs using Python (band 5)
• Be able to link your work today to work from previous units, eg Scratch (band 6)

Python is a programming language.  Unlike Scratch that you have used to program where the programming is done by placing 'blocks' in the correct sequence (order), Python is text-based programming ie the sort of programming that goes on behind the 'blocks'.  It is a general purpose programming language created in the late 1980s.  It is used by thousands of people to do things from testing microchips at Intel, to powering Instagram, to building video games with the PyGame library.

The written instructions will only work if they are in the correct order, correctly spelt, correctly lined up on the page and have the correct punctuation symbols.  All of this is called 'syntax' and makes it just like any language where it will only make sense if the words are in the correct order in the sentence for that language, and punctuation and spelling are correct.

Open a new blog post and title it the same as this one.

On the post, explain what the words 'sequence' and 'syntax' mean.



If you are using a Chromebook, you will need to go to this link.....
https://repl.it/     and search for Python 3.

If you are on desktop PCs, there should be a link to this in the Comp Sci folder in 'Start' menu.

Now you need to go to my worksheet with screenshots and tasks for this lesson.....

Link to Python Worksheet - Lesson 1

Follow the instructions and tasks on the worksheet.

Bronze - Task 1

Silver - Tasks 1 & 2

Gold - Tasks 1, 2 and 3

To achieve Band 6, you will also need to link this work to work you did in Scratch.  Describe, in detail, similarities and differences between the two.

Once you have completed all the tasks you can in the lesson time, share your Google doc (Advanced - change from Private to Anyone with the Link - copy/paste the link to your post).
Publish!