Skip to main content

Disco Faver - Worksheet

This IT activity has been prepared by F. Beeby while on a four year B.A. in Business Education with Information Technology (QTS) at Brighton School of Education. Follow the links below to access the various different parts of the case study.

NOTE: You will require Microsoft Excel Version 7 or later to use the spreadsheets in this case study.



Disco Fever

It is made up of:

  1. Three activities about 'Disco Fever' - a mobile disco business with various spreadsheets to analyse and complete, along with help and guidance about using spreadsheets.

  2. A worksheet - analysing disco costs. This worksheet gets you to set up your own spreadsheet for a disco to be held at school.

  3. A teacher guide to the case study.

There are 3 separate spreadsheets needed for the Disco fever activities and you can either download all 3 spreadsheets at once or individually as you work through the activities.

Using this material on a local network

You can if you want to download the whole case study package for use on a local network. To do this, use the "Save Link As" function on your web browser to save each of the following files to the same directory on your local computer. Alternatively, visit each page in turn and use the "Save As" function.

Instructions | Spreadsheet Guidance | Student Worksheet | Spreadsheet Specification | Tutor Version | DscoFull.XLS

Remember to also save this index page to the same directory (using the "Save As" function").

NOTE: Some of the material by this author was drawn from ideas in 'Spreadsheets for Mathematics and I.T.', by Andrew Rothery, John Murray Publishers, London, (1991)

Comments

Popular posts from this blog

Interactive Worksheet: The Accounting Equation

by Ken Delaney-Moore, Sheffield Hallam University Aims: This worksheet deals with: The accounting equation. The accounting concepts of 'business entity' and 'dual aspect'. The effects of transactions on the balance sheet. After having completed the worksheet you should be better able to perform to syllabus specifications relating to these points. When you are done, please fill-in the on-line evaluation form in order for us to monitor the quality of the materials we provide for you. Tell us what we're doing right and wrong. It takes very little time, and your opinions are valued - thank you. A business start-up Imagine that 'Jim Sayers' puts £5,000 of his personal savings into a business bank accoun...

MEMBUAT DATABASE APLIKASI AKUNTANSI DENGAN MICROSOFT ACCESS 2007

Microsoft Office Access 2007 merupakan aplikasi pembuatan database yang diciptakan Raksasa Microsoft Corporation, Hingga saat ini banyak sekali perusahaan menggunakan aplikasi ini dalam membuat database untuk keperluan bisnisnya, baik dengan menggunakan 100% access, maupun dengan memanfaatkan enginenya dan menggabungkan dengan aplikasi visual lainnya seperti Visual Basic, dsb. Access 2007 merupakan dipenyempurnaan dari access 2003. Berikut ini kita akan mencoba membuat database sederhana untuk keperluan akuntansi. Untuk membuat aplikasi database akuntansi tentu diperlukan banyak tabel, query, dan report yang harus dipersiapkan. Apalagi jika akuntansi untuk perusahaan dagang, dan manufaktur. Untuk lebih memudahkan bagi pemula yang ingin belajar membuat aplikasi dengan menggunakan Microsoft office access 2007, maka disini saya akan mencoba membahas aplikasi database akuntansi sederhana untuk perusahaan jasa. dalam menyusun suatu database tentu sebelumnya kita harus menyusun normalisas...

The Current Ratio

The Current Ratio The current ratio is also known as the working capital ratio and is normally presented as a real ratio. That is, the working capital ratio looks like this: Current Assets: Current Liabilities = x: y eg 1.75: 1 The Carphone Warehouse is our business of choice, so here is the information to help us work out its current ratio. Consolidated Balance Sheet 31 March 2001 25 March 2000 £'000 £'000 Total Current Assets 315,528 171,160 Creditors: Amounts falling due within one year 222,348 173,820 As we saw in the brief review of accounts section with Tesco's financial statements, the phrase current liabilities is the same as Creditors: Amounts falling due within one year . Here's the table to fill in. OK, so we've done this one for you! Current Ratio For the Carphone Warehouse 31 March 2001 Current Assets: Current Liabilities 315,528: 222,348 1.42: 1 25 March 2000 Current Assets: Current Liabilities 171,160: 173,820 0.98: 1 Math...