Desktop Publishing - Analysis
Analysis It is important for me to have a good quality colour printer for a magazine. I will also have a larger, good quality screen so that the magazine can be seen easily on the screen. I will also need a good sized hard drive to store numerous graphics. Hardware Processor - I have an Intel Core 2 Extreme Processor QX6700, 2.66 GHz so that I can create the magazine quickly RAM - The computer has 1024mb ram so that the computer can run a lot of programs at the same time. For example, I can open up the magazine and at the same time can manipulate graphics to be put on the magazine. Hard drive - I have a 200 GB hard drive so I can store many graphics. Monitor - I am using a 23 inch monitor so that the whole magazine can be seen on one screen without scrolling down too much. Colour printer - I have an Epson R320 printer so that I can print out the magazine quickly and can also have good quality print-outs. Keyboard and mouse - I will use a Microsoft Wireless Desktop 8000 which includes both a keyboard and a mouse. I will need the keyboard to type the words in the magazine and will use the mouse to copy and paste graphics onto the magazine. Software Word processing - With this I can manipulate the text easily. For example, I can choose different font sizes in different styles or by underlining the text and making it bold. I can put line spacing in easily and put
Planning a spreadsheet database for a gun shop.
Name: Haseeb Ali Choudary Candidate number: 3038 Center number: 11043 GCSE ICT spreadsheet coursework IDENTIFY Identifying the problem: My sister Lisa is the new manager of a small independent Gun shop located in Brighton, which is called BOOMtings it has been running for 10 years now and is a thriving business as any other shop in the market. This shop sells the latest guns at reasonable prices. BOOMtings have an acceptable amount of customers and the shop is earning a reasonable amount of money. Problem: The current system is manual and makes life difficult for my sister so I will be trying to fix it. As my Sister hired me to help out with the accounts, I have found some problems which are: finding the calculations of how many Guns they have, how many they sell over a period of time and the amount of profit or loss that was made weekly or monthly This problem is caused because my sister Lisa is completely unorganised and is always losing important files and scraps of paper, which means she has no idea of what is going on with the company's financial situation. Suggestions: As I am very advanced in software designing and accountancy, I am the best man for the job. I would say the best way to solve this problem is to get a laptop for my sister Lisa, so that we can get Microsoft excel or Microsoft access. I thought it would be a good idea to produce a spreadsheet
Varndean e-Learning
Company: Varndean e-Learning Introduction to the Company, (Overview) Varndean e-Learning is a small educational software company based in a school. The people who run the company were all at one stage teachers at Varndean School. Their company was formed in 2001, when the directors wrote some software to help their students with GNVQ ICT. They Still work from a small office within the school, where they develop software and take orders over the phone. All of their software is thoroughly tested on students from Varndean School before it is marketed as they believe it must be appealing and value the views of the students. They run Sales Seminars in London and Birmingham three times a year where they demonstrate the software to large groups of people on a large screen. They also run Training Sessions three times a year in London and Birmingham where teachers from many schools who use the software go to learn how to use it. Varndean e-Learning may only be a small company now, but they have many plans for the future, which include spreading out into other areas of the School Curriculum and developing software for them to aid the student's learning. Sales John Burton, one of the directors of Varndean e-Learning has many roles within the small company. He works on developing the Interactive Learning Software and within the Finance department, but his main role within the
OCR National - Evaluation of Website
. Suitability for purpose: It was met as it will be obviously decipherable by the user. The main theme of the website is based around the environment and such is shown by the theme/house-style used. The purpose of my website was to make others more aware of environmental issues and this was covered clearly and linked to from the 'Equipment' page for every piece of recycling equipment. Another purpose of the website is to allow those who do not already own any of those pieces of equipment to easily acquire it - this was engaged with the viewer by using a different, larger font size which, when clicked on, will link the user to an external website. The final purpose of the website is to make youngsters aware of global issues and how these can be assuaged. This purpose was successfully communicated by the use of simple words, images and an animation, aiding understand. 2. Suitability for audience: The likely audience of the website is diverse. Some of those may be randomly browsing to see if there is anything is interesting, others may want to find out more on how to use their recycling equipment, others want aid in ordering this equipment and, finally, an audience may even be youngsters. Needs for each different group is provided; those browsing around can use the navigation bar to quickly search for what they may find interesting, those wanting to find out how use their
Evaluation, Application & Effects
Evaluation, Application and Effects . Compare using ICT to create your system rather than creating it by hand. Using ICT makes producing the presentation much easier. This is mainly because you can change, edit and move things at a touch of a button without having to completely redo the piece of work. You can add colour and special effects using specialist programmes, making it look unique to other presentations. Also if you did it by hand, if you made a mistake, you would need to cross it out which would make the look less impressive and professional, but using a computer you can easily correct it and it will still look perfect. Also if you want to reproduce a leaflet it would be extremely time consuming whilst on a computer, it would be simple. When producing a leaflet by hand, I would probably use a template to make straight bigger letters, and write all the information by hand with a medium-sized pen. For the photographs, I would print them immediately from the computer, onto photographic paper and then cut the pictures out. I would then glue the photos onto the paper in suitable place. This could then be photocopied to be reproduced, in either colour or black & white, and these could then be made available in the Health Centre. 2. Justify your use of ICT to create your system for the Health Centre. Using ICT makes producing the presentation much easier. It is
Ict Software
DIFFERENCES BETWEEN A COMPTERISED AND MANUAL SYSTEM:- * Computers take up less space, filing cabinets are not needed. * Searching for records is quicker on the computer. * More than one person can access data at the same time from the network pc. * The data stays within comp memory won't get misfiled or lost. * Fewer staff are needed to look after the computer system * Reports can be generated very quickly- by an automated processing routine rather than manually. * Cabinets take up lot of space. * Searching for records takes long time. * Setting up a computer system is very expensive. Big systems in large organisation cost millions. * Computers need people to maintain and use them. * Training costs are high and money is wasted if a person leaves. * Computers are not perfect, if there is a system failure or power cut then important data could get corrupted or lost. * It can be easy to copy files and so remove confidential information of the system. The system has to be kept secure from unauthorised user's and hackers. * Need to employ clerical staff to look after filing system. * Reports can be written only, they have to transfer information by hand. * It is time-consuming and there are chances of human error. * Only one person can access the data at the same time. * Computer's are faster and manual work is very time-consuming. * It is neater and
I want to design a database that will allow faster and easier sales of cars, it will also help organise them too.
Contents page Section Page > > > > > > > > Car Database project I want to design a database that will allow faster and easier sales of cars, it will also help organise them too. Before I design a database I need to find out what information I will need to include in my database, to this I will produce a questionnaire, which will be sent out to several garages in my local area. When I get the questionnaire results I will then design my database around the wants and needs of other garages I am going to produce a database that will allow salespersons to use a PC to speed up the search process for the customer. If the customer is searching for a particular type of car, i.e. make, model, mileage, year of manufacture. The database, which I have created, will allow the sales person to search for a car meet the customer's requirements. I am doing this because it will be much easier for the salesperson to find a car, which will meet the customer's requirements. Implementation You must use the software to process and store data entered from the questionnaire for required output. You need to produce a report, which describes in simple steps how you created the database using the selected software. This will match your design. Printouts and screen shots are required and the data has to match the data collected from the data capture sheets (one from each
Implementation. In this task I would use Microsoft Office Excel as it would help Hickley Travel to work out the number of passenger and the cost of passenger.
Implantation task 2 In this task I would use Microsoft Office Excel as it would help Hickley Travel to work out the number of passenger and the cost of passenger. I need to set up a system that would count the number to add up the number of adults and children separately and give the total number of passenger separately. I would do so as the company could charge the price of adults full and the price of children half of it. ) First I need to open topics folder Then I need to go in the ict folder Then I need to on in 2011 assessment folder Then I need to open 2011 data files Then I need open the excel file of passenger for Cotswold and scorpion theme park This excel file would appear but now I need to save in my folder I needed to go on file sae as then put I the desired file and I also changed the type from CVS file to Microsoft excel 97-Excel 2003 &5.0/95 workbook (*.xls) Now I need to crate a new heading in Q1 which would be total Now I have added a heading, now I need to insert in a formula so I need to go in insert the go on function This screen would appear I need to choose sum Then another screen would appear so I need to select B2 P2 So I need to click the button so this type screen would appear The I need to click and drag from B2 to P2 so that I could get the total Then I need to press enter the press ok The total appear which is 32 I
ICT project - record system.
GCSE ICT PROJECT MICROSOFT ACCESS STUDENT MARK RECORED SYSTEM WRITTEN BY SUBHAN ALI IDENTIFY Identify the User There is a geography teacher known as Mrs Knight and she works at Kingswood Primary School. Since she has been there, Mrs Knight has kept a record of all her pupils' marks in a register starting from years 7 up to 11. But the problem is that she cannot gain enough information about them, however, accurate and organised the records are. E.g. if a student receives a mark for his exam in a percentage it would also be helpful if the mark they actually received, was visible on the records, this would allow Mrs Knight to observe if a student is progressing or actually getting on with his/her work. Also she would like to see a particular students grades individually without other students marks being visible e.g. on a parents evening she would like to show the students mark but without having to see any other students marks in the record book. Manual Solution Considered One solution Mrs Knight could use is by manually adding a few more columns to her record book, and work out the pupils average by hand and note them down, she would then be able to make a list of the average grades and keep an individuals grades private from being visible to other students. Two Alternative Software Solutions Considered The first alternative solution Mrs Knight could use would
Documentation of video shop database.
Documentation of video shop database User guide For the video shop project I created a database on Microsoft access. To get to the database you have to do the following . Turn computer on and log onto the computer. 2. Then once the computer has loaded up double click on the icon which looks like this: 3. Once the programme has loaded up a window will appear and to carry on to access the video database click on OK. 4. Then this window appears and to access the video shop databases double click on OTHER folder. 5. Then another window appears and shows you what the other folder contains. It shows that the video database is in this folder. To access it just double click on it using the right mouse button. 6. Then another window will appear and you have now accessed the video databases. This window appears and shows all the things available on my data base. The table: The table is the main design point for the database. You decide what field names and what special checks should be done into the database to reduce the amount of mistakes. To view the table form of the database you click on which table you want to view (video table, video taken out table or the member table click on the label that says TABLES and then double click on what table you want to see. (Diagram on the next page) Then a table appears showing all the records in that file. Below is the table for