Unit 2B Applied Information Technology
week 1
Task 1
Scenario
Along with two others you have decided to start a graphic design business that will produce web sites, animations and print materials. Your first step is to apply to a bank for a loan to setup the business. When looking for a business loan from a bank or financial institutions you need to submit a loan proposal. Your loan proposal must answer the following questions:
- Who are you?
- How much do you need?
- How are you going to pay it back?
- What happens if you can't pay it back?
At this stage you are going to focus on question 2, "How much will you need"
You have decided to split the business into three areas;
- Web Site and Animation Management,
- Print Media Management
- Financial and Sales Management
Each person will need a computer with specialised software and the three computers will connect to a server via a hub on a star network. Also on the network will be a high quality colour printer and a spare computer to allow for future expansion of the business.
There will also be a router and a fast Internet connection through an Internet Service Provider (ISP)
How to set up a Network (This annimation sets you through building a network)
What you have to do
Listed below are the hardware and software requirements for each of the computers, the server and the printer. your task is to use Microsoft Excel to prepare a costing for each of these items plus and a total amount required to borrow.
Web site and Animation Management
Desktop computer - highest specification possible under $2,500
Microsoft Office Suite
Website design software (e.g. Dreamweaver)
Image editing software (e.g. PhotoShop)
Animation software (e.g. Flash)
Video Editing software (e.g. Premiere)
Audio Editing software
Financial and Sales Management
Desktop computer - highest specification possible under $2,500
Microsoft Office Suite
Accounting software (e.g. MYOB)
Print Media Management
Desktop computer - highest specification possible under $2,500
Microsoft Office Suite
Image editing software (e.g. PhotoShop)
Vector Graphics Editor (e.g. Illustrator)
Desktop Publishing software (e.g. InDesign)
Spare Computer
Desktop computer - highest specification possible under $2,500
Microsoft Office Suite
Server
Server computer - highest specification possible under $4,000
Web server software
Exchange server software (email)
Firewall and security software
Printer
Colour laser printer that can be networked - highest specification possible under $1,500
You also want to network the computers to the server and to the internet so additional hardware and software will be required.
.
Layout of Costing Spreadsheet
Item Number |
Description |
Unit Price |
Quantity |
Total Price |
1 |
Desktop computer |
$2,500 |
4 |
$10,000 |
2 |
Microsoft Office 2010 Suite |
$1,000 |
4 |
$4,000 |
Proposal to Bank
At this stage your proposal will have three parts;
1. A covering letter outlining your business and why you need to borrow the money Example
2. The spreadsheet showing the breakdown of items and costs
3. A glossery of technical terms used (e.g. server, network, etc) Example
Unit 2B AIT