Friday 22 March 2013

Lesson 4 and 5 - Developing a model further and creating graphs

Charts (called Graphs in Maths lessons) are used to present information - numbers or data - in a way that is easier to read. There are different types of charts, the most common are pie charts, bar charts and line charts. We can use different types of charts to show us different things.


In today's lesson we are learning:


  • to understand what happens if we change the values of variables
  • to understand why different charts can be useful for different things
  • be able to create a chart to represent the data in your spreadsheet model.

Tasks:



  1. Complete your shop model to include both a 'costs' table and a 'revenue' table. 
  2. Calculate the profit you would make on selling your products.
  3. Identify variables and rules in your model using labels.
  4. Use the chart wizard to make a chart that shows you what revenue each product is making.
  5. Make a copy of this Spreadsheet Charts document and answer the questions.


Extension:

Consider how many visitors you may get to your shop. Is it realistic to expect millions of visitors in one month? Imagine for example I was selling my sweets to Year 7 only. There are approximately 300 students in year 7. I should adapt my spreadsheet model to include this information. Do I have enough stock for them? Will they buy from me every day?

Friday 15 March 2013

Lesson 3 - Developing a Model


In today's lesson we are learning to:


  • Identify variables and rules
  • Make adjustments to a spreadsheet model
  • Add correct formula to a spreadsheet model


Tasks:


1. You are starting you own shop in which you can sell any range of stock. For example you might want to run a sweet shop, or a shoe shop.

2. Once you have chosen your stock, using google search shopping find some stock and the cost price for each item. You need at least 6 items. For example, Haribo, Skittles, Mars Bars, etc.

3. Using Robert Clack Apps, Create a spreadsheet model for your shop, by clicking Create and Spreadsheet.

4. You will need to include a column for:

  • Products
  • Price per item
  • Number of items
  • Total Revenue

5. Calculate the total revenue using a formula.

Extension:


Underneath your completed model add a table with these column headings:

  • Costs
  • Cost per item
  • Number of items
  • Total Costs
Calculate the total costs using a formula. Then calculate your profit using a formula. Remember Profit = Costs - Revenue

Friday 8 March 2013

Lesson 2 - Costs and Profit





A business can use a spreadsheet model to work out its costs and profit. 
  • Costs are what a business has to pay out for stock, wages, and rent for example.
  • Profit is the money the company makes from sales after the costs have been covered.

In today's lesson we are learning to:

  • Understand how businesses use models to predict what might happen
  • Be able to add formulae to a spreadsheet to work out costs and profit.


Tasks:

  1. Make a copy of Miss Philbin's Costs and Profit and calculate the costs using a formula.
  2. Next, we need to calculate the profit. 
  3. Create a new Google Doc, and write a definition for the following terms:
  • spreadsheet model
  • revenue
  • variable
  • costs
  • profit


Homework:


What is VAT? Write a definition and then explain what Miss Philbin will need to pay VAT on in her shop?


Friday 1 March 2013

Lesson 1 - The Basics of Formulae



Make a copy of the 'Guess the secret message' worksheet and follow the instructions.


In today's lesson we are learning:

  • to recognise and use cell references
  • to create simple working formulas.


Tasks:

1. Log into Robert Clack Apps
2. Make a copy of Miss Philbin's Shop.
3. Using Fill Colour, Font Colour and Boarders, make the spreadsheet model look more attractive.
4. Enter a formula to calculate revenue for all the products in the model.
5. Enter a formula to calculate the total revenue.
6. Extra Challenge: Can you think of a function that would work out the Maximum and the Minimum revenue figures?

Extension Task:


Answer these questions about Miss Philbin's Shop Revenue Model

Homework:

Look at the table in this picture and answer the questions: