• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  • Level: GCSE
  • Subject: ICT
  • Word count: 3721

Ict coursework full

Extracts from this document...

Introduction

SkateUK A GCSE ICT Spreadsheet Project. Steven Burnett, 10H Identify The problem Michael "Nukka" Burnquest opened a skateboard shop back in the summer of '05, in a quiet town in Oklahoma. Business has since boomed, and Mr. Burnquest can afford to revamp the way his shop operates. Regular skaters from the local area often call or visit the shop to order parts for their skateboards. Mr. Burnquest does not have a system to easily access the prices and availability of his stock; he relies heavily on his staff searching through the shop to see what they have in stock, and there is a list of prices behind the counter. This is a very slow and pain-staking process. Mr. Burnquest needs a system that allows him and his staff to promptly check the pricing and availability of items in the store. Manual and alternate solutions There are a few possible solutions to Mr. Burnquests problem. A solution could be to catalog, by hand, containing information on each item that the store sells. This is a great solution, providing the store was a small business. The catalogs could become damaged, and hard to read, or even lost. Another solution to consider is to print off a list of products that the store sells, and tick them off of the list when they are sold. This would mean should the information become lost, that they can simply re-print a copy. Over time, the paper and ink costs would become substantially larger, and everything would be hard to find. The information could, however, be stored on a local computer, found in-store. A word processor could be used to create a table of the items sold by the store. This would take up very little space, and it would be far easier to use, although the pages could become cluttered very quickly, making it hard to read, and it would be a slow process, adding new items. ...read more.

Middle

The copyright information will be black, in size 8 Arial. Input page #3: The logo will be in a green font colour, in size 30 Arial. The slogan will be in a black font colour, size 16 Arial. The product name/price/quantity, buy and currency will be black in size 12 Arial. The copyright information will be black, in size 8 Arial. Contact page #1 (Email): The logo will be in a green font colour, in size 30 Arial. The slogan will be in a black font colour, size 16 Arial. The employee email details (along with their name and position) will be black in size 12 Arial. The copyright information will be black, in size 8 Arial. Contact page #2 (Phone): The logo will be in a green font colour, in size 30 Arial. The slogan will be in a black font colour, size 16 Arial. The employee telephone details (along with their name and position) will be black in size 12 Arial. The copyright information will be black, in size 8 Arial. Output page #1 (Invoice): The logo will be in a green font colour, in size 30 Arial. The slogan will be in a black font colour, size 16 Arial. The items that are currently in the checkout will be listed (along with their prices/quantities/names) in Arial, black, size 10. The shipping details will be in black, Arial size 10. The copyright information will be black, in size 8 Arial. Output page #2 (Receipt): The logo will be in a green font colour, in size 30 Arial. The slogan will be in a black font colour, size 16 Arial. The checkout (displaying sub-totals of prices, quantities and also a list of item names) will be black in Arial size 10. The copyright information will be black, in size 8 Arial. User feedback Person #1: "I liked home page #2. It is simple, and well lay out. I also think that a large space allocated to image navigation makes everything easier to use. ...read more.

Conclusion

At the bottom of the receipt page, the user can print off a receipt for proof of purchase if they so wish. * The important areas of the spreadsheet must be protected in some way, and the whole system must be "Read-only" (or 644CHMOD). The spreadsheet has been assigned a CHMOD of 644 ("Read-only" for Windows users). * The system must be easy to backup, and the backup folder must be secured. To backup the system, simply copy and paste it into a folder. Then CHMOD the folder to 644 ("Read-only"). * The system must contain a navigation column, to direct users around with ease. Yes, the spreadsheet actually contains two navigation menus to help the user navigate the system. Critical comment To improve the spreadsheet, I could spend more time on the design; at the moment, the colours are dull and boring, although the actually layout is very fitting. For example, I could create custom colours to brighten up the spreadsheet. User feedback; letter Dear Steven Burnett, I am writing to you with my thoughts regarding the spreadsheet of which you made for SkateUK. I asked you to create an easy-to-use, simple spreadsheet for my rapidly expanding shop, and you have excelled my expectations. I found the layout to be professionally designed, and very easy to navigate. My employees are now very quick to respond to customer queries. The way that you implemented the shopping cart is ingenious. Although I do appreciate your work for SkateUK, I would like to add this: next time you create a spreadsheet, create a way of editing the stock number. It is still a real pain for me to add/remove stock from the system, although things aren't so bad now. Thank you, - Nukka My response I have taken Mr. Burnquests' feedback into account; next time, I will spend more time on creating new ways of managing stocks, and less time on the design of the system. After all, there is no point of having a pretty system if it doesn't do anything. ?? ?? ?? ?? Steven Burnett, 10H ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    I know this because I used a number of websites to get ideas for the right price and averaged the cost. To make the data more realistic, I should use the same website to find out all the guide prices.

  2. Different types of technology How I use ICT at home and at school

    For someone like me who likes to keep his brain in shape, I like to regularly use the brain training app and being the arrogant, boastful person I am, it gives me the chance to show off my capabilities and strengths to other people.

  1. ICT PROJECT

    ActiveChart .HasTitle = True ChartTitle.Characters.Text = "Average Mark, By Form" 'Edit X axis Axes(xlCategory, xlPrimary).HasTitle = True Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Form" End With 'Hide chart toolbar ActiveChart.Axes(xlCategory).Select ActiveChart.ChartArea.Select Application.CommandBars("PivotTable").Visible = False End Sub McrGender Sub mcrGender() ' ' mcrGender Macro ' Macro recorded 29/01/2007 by 21bor2413j 'removes flash when macro

  2. Creating a computer system for a video rental shop

    Security Security is provided by making sure there are safeguards to ensure that data is not accidentally or maliciously corrupted. Passwords The system will have a password, which prevents the user from changing the design or appearance of forms. All the user will be able to do is enter the appropriate information in the right sections.

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    This tool can be used for when someone is renting out a game and you can easily enter their details. However Word does not have some of the crucial things needed in making the game rental service e.g. being able to check if a game is overdue and being able to import data.

  2. The impact of ICT on a person with special/particular needs

    She can manoeuvre through her whole house, whether to different rooms and floors all by herself. This has boosted her self-esteem and she can work whenever she wants at her own will as she doesn't need to call for an assistant to get to her required method of work at her computer desk on the top floor.

  1. Creating a logo, template letter and a website for a travel agent.

    to reach a global audience at a fast rate Many people just ignore the agencies advertisement because they might be to busy on something else Mainly a lot of people access the internet in which a lot of adverts are posted to catch their attention People think that online advertisement

  2. Ict Powerpoint Coursework

    For Office 2010 there are several advantages like you can insert clip art , videos , sound clips , movies etc ... Also you can make a slide show automatic so there will be less hassle and most things would be at ease with PowerPoint.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work