Create an IT system for my karate club.
Task Statement For my project I have decided to create a system for my karate club, which I attend. The karate club is in desperate need of an organised system, which will be able to organise the information of the students and also sort out the taking of their details. Competitions take place regularly and the instructor would like a list of the people taking part in each competition and a bill produced for each member so they pay their fees. For this project I have a real end user who happens to be the instructor at the karate club. Sub Tasks I have to firstly design my database and have to find which entities I have to add in and what tables I will need to set up. I will have to make sure that all the information my end user wants in my system is accessible. So I will also have to design queries so that there can be searches for particular data within the database without having to scroll through all the information available in every table in the database. I will also have to design reports for the queries as this makes them look more presentable and easier for the end user to understand and so the results are presented in a clearly way. So my end user can use the system a lot better without having to go through the back end of access I will have to create a front end which is known as the human computer interface. This will allow the user to simply
Database Coursework
Task Description Dazzling DVD's is a DVD rental shop owned by Nicholas Smith, which many people visit when they want to buy or rent DVD's. The shop is situated in Ilford outside the exchange. They have many customers who would like to buy DVD's from there as they have cheap and affordable prices. The shop collects the information of the DVD's via phone calls, but they also get suppliers who come in person to give the DVD details or they get it on the web via emails. The details of the DVD's are taken: Name, age rating, release date, the barcode, the genre, the quantity and the description and the DVD. The details are taken down on a paper-based system by the receptionist. The name and age rating are important in any system to know which DVD's are allowed to be rented to which aged customer; the release date is needed so that the customer can see which DVD's have been released recently. The barcode, the quantity, the description and the genre are needed so that the suppliers can be contacted for any problems which need to be sorted out such as not the right amount has been delivered. Unfortunately, mistakes are common such as writing the wrong details because of bad communication on the phone. This can lead to big problems in the future because when the shop try and contact the supplier, they may end up calling a wrong number because of the receptionist's mistake. Sometimes,
I am going to be looking at Tesco. I will be focusing on what theyre like as a company, the corporations aims for the future, and how ICT is necessary for Tesco to achieve maximum productivity
2B - An ICT System Introduction In unit 2B I am going to be looking at Tesco. I will be focusing on what they're like as a company, the corporation's aims for the future, and how ICT is necessary for Tesco to achieve maximum productivity. Tesco's purpose is to effectively provide a range of groceries to customers. Some of Tesco's main aims are to: * Be energetic, innovative and be first for customers, * Use their strengths to deliver unbeatable value to customers, and customer satisfaction * Strive to do their very best, * Achieve staff satisfaction * Enjoy work, celebrate success and learn from experience, * Appeal to a diverse customer base through providing a range of products, bringing value and offering a range of store formats, * Be easily accessible for the disabled, * Develop store structures to better meet the needs of both customers and staff. * Uphold high standards of animal welfare, * Promote recycling and sustainability, and, * Expand internationally. Tesco are an international, UK based retail chain. It is the largest British retail company, and started out specializing in foods, but has branched out into many more areas such as clothing, cosmetics, DVDs, music, electronics etc. What makes Tesco different is the fact that they strive towards various goals, from things like customer services to being environmentally aware; these sorts of priorities
Impact of ICT on the community
Contents ICT in Society Southall is located in a town of London borough of Ealing it is close to Heathrow airport which is one of the busiest airports in the world, which creates lots of jobs and large number of Southall residents are employed in Heathrow. Southall is quiet a small area but holds a large amount of population. Southall is one of the busiest places in England. In this area the route of communication such as, railways and roads need real improvement because at the moment they are not good enough and doesn't meet the needs of the community really well. There is also project going about trams but our community is not happy with the decision made by the Ealing Council. In Southall it is very difficult to settle down for a person who has just been to this town because there are no enough jobs for people to do and those with jobs are paid very less wages compared to national average wage. Southall also has a very low reputation is attracting the visitors to the town, that's because of the low employment rate. Basically this means that the people with business should give others a chance to work and pay them the same amount of wages like other employees are being paid in other towns and countries. This town is one of the towns in England which has most problems with public transport because there are very few buses to go around and the population is bigger if a bus
System administration report
AS Coursework Task 1: Report Plan The system administration report that I am doing will be based on a four star hotel called the Moat House. There are numerous reasons for the choice of this hotel, as it will give me a chance to find out how a hotel is managed with the aid of ICT. The Moat House operates in the commerce industry where it aims to provide a service to the community. The Moat House is suited in an ideal location close to M25; with scenic surroundings it is a matter of convenience for the customers. As the hotel industry is becoming highly competitive, the hotel aims to offer low rates and high quality service at the same time and build a respectable reputation. It operates in small area and aims to dominate the market in the area they operate. The hotel is busy through out the week, especially on Friday's and the weekends where it is fully booked. The hotel is an ideal place for weddings, parties and conferences with numerous halls and conference rooms. The hotel has also started advance bookings for Christmas and New Year parties. The hotel generates its main revenue from booking and reservations for weddings, conferences, and parties. The Moat house is attractive to a variety of businesses, ranging from small to big companies such as JCB, Argos and GEC for their conference rooms. My investigation will include a schedule of the system administrator daily
ICT Access
Part 1 - IDENTIFY Statement of the problem Mr. Hock is the proud owner of a recently configured estate agent. Mr. Hock invested a large quantity of money obtained from both savings and loans to produce a successful business. Mr. Hock is keen to generate a local estate agent that will enable the delivery of a level of personal service unmatched by larger corporate companies to his clients; he maintains a policy of a personal promise to provide a quality service enabling a stress free move. He employs a mature specially selected local team offering a combined experience of over 125 years in estate agency therefore viewers can be accompanied by staff if required. His employment also extends to Sales Coordinator a specially trained individual member of staff to do all the work for the customer once the sale is agreed and an exchange of contracts is completed ensuring the sale proceeds smoothly to a successful completion. He incorporates competitive sole and multiple agency commission rates representing excellent value for money. When he bought the company 4 months ago he was aware the previous owners earn't a substantial amount, with high profits. He offers a range of affordable housing, enticing many clients. He wants to encourage a constant supply of reliable clients recommending his services to both friends and family. Often users of the website comment on their experience of
drum kit costing system
AQA GCSE ICT Specification B Name: Nick Gibson Candidate Number: Centre Number: 51347 Contents Description of the task to be attempted 3 Analysis 4 Investigation 4 Interview 4 Observation 4 Analysis 4 Interview Analysis 4 Output Requirements 5 Input Requirements 5 Processing Required 6 Possible Solutions 6 Specification 7 Detailed Specification of Solution 7 Evaluation Criteria 7 Design of the ICT System 8 System Flow Chart 8 Implementation 9 Hardware resources required 10 Software resources required 12 Data collection, data capture and input 14 Data verification and/or validation 16 Data and/or program structures 25 Output format 26 Testing 28 Evaluation Criteria 29 Test Plan Error! Bookmark not defined. Testing Against The Test Plan 30 Evaluation 38 Evaluation of the system produced 38 Possible Refinements 40 Description of the task to be attempted Chris Wright owns a drum shop called Drum Gurus. It has been operating for about 5 years and he now wishes to improve the pricing system in order to provide a better service to his customers. He sells drum kits, cymbals, drums, accessories, and parts to customers. As there are more drummers coming onto the scene Chris is selling more and more complete drum kits as opposed to accessories and individual items. The current invoicing system is manual and time consuming. When a customer comes in to
Choosing the best harware for my system.
Hardware Hardware is any physical thing of a computer that you can touch. Monitor Tower Mouse Speakers Keyboard Types of hardware A computer has four main types of hardware in a computer which is: Input An input is a hardware device which is used to store data into the computer. Process Process is a hardware which manipulates the information in order for you to read it Storage Storage is a type of hardware than enables you to save your work or things on your computer. Output An output is an hardware that is used to transfer the computer data in forms so you can be able to read it. There are 9 hardware that I am using, these are the following. Input Keyboard, Scanner, mouse Process Intel Core Duo Processor (2 GHz) Storage RAM, ROM, USB flash drive Output Printer and monitor This table is the hardware that I am going to use and how they work. Name of device Price The way it works Advantages Disadvantages Keyboard £20 A keyboard is an item that you can touch. It has many different buttons each with different letters, symbols and number. Once you press one of these buttons the central processing unit sends message to the monitor and it appears on your screen and for you to understand. The advantage of a keyboard is it comes in several types including QWERTY concept. The disadvantage of a keyboard is that it is portable so you can't take
Mr Ariel Sharon is the owner of a small, but very busy, independent sports' shoes store named "ShoeShop". It is located in the centre of Londonand new and old customers are constantly popping in with questions.
IDENTIFY Statement of the problem Mr Ariel Sharon is the owner of a small, but very busy, independent sports' shoes store named "ShoeShop(c)". It is located in the centre of London and new and old customers are constantly popping in with questions. The most common question is "Is this shoe available in [this] size?" The sales assistants employed at the shop cannot always answer this sort of question very easily because it is very time-consuming and sometimes difficult for the assistant to quickly go and check in the storage room at the back of the shop for the shoe's availability. Currently, a shop assistant has to go to the storage room, then to the particular brand's (e.g. adidas(r)) section, and then start looking for the customer's preferred shoe model and check if the appropriate size is available. It would be even more time-consuming if Mr Ariel Sharon wanted to find out the exact number of shoes remaining for a certain model or size as the shoes would have to manually be counted by the assistant. This is unreliable as the assistant may not search adequately, and may convey the message that the shoe is not available when in fact it is. The customer would also want to know the latest price of the shoe, and the labels which have the price printed on them may have outdated prices which would most likely alter the customer's choice. What Mr Ariel Sharon really needs is
Spreadsheet for a basketball company
MS Excel Project . Identify .1. Introduction 'RoSup' is a company that organises basketball matches. It has one basketball court, which is situated in Surrey and has been operating for nearly a year. They are struggling because the methods they are using appear to be very inapt. I have been requested to undertake the problem with an attempt to introduce an easier but effective scheme, by Mrs Suprabha, the manager. .2. The Real User The actual problem is the method they are using to book seats, gather, and enter information such as customer information. They are using a paper-based system and so the process is very slow as information is slightly different every match. The employees have to keep drawing a new booking system for every match. They would have to keep counting stocks left. The other problems caused from this manual system are that the documents get lost, damaged, can prove to be very difficult in altering, mistakes due to illegible handwriting and forgetting to add or delete data. These files also take up a lot room, as they require being stored in file cabinets and finding certain data will be very much time consuming. Categorising data in lists would be a great burden. As a result, of all these drawbacks from the current scheme, the manager wants a solution that will speed up the process, which would ultimately allow them to focus on other business aspects
