• 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
• Level: GCSE
• Subject: ICT
• Word count: 4864

# I.T. System for a Newsagents

Extracts from this document...

Introduction

Middle

Conclusion

=SUM (B16-B17) This formula works out the closing balance by subtracting the Opening balance from Net cash flow resulting in the closing balance. Introduction: Now that I have finished creating a system I have to test it, to see if there are any problems. Strategy: There are to different ways I could test my system. Test1- I could test it with the current figures. Check if the formula works and see if the validation is accurate. Test2- I could test it with last year's figures, and see if the totals agree. I will then again see if the validation checks are accurate. I have chosen to do test 1 and I will do this by doing it in a Test plan & results table. The results able will consist of three columns the first is "Test" for what I'm going to test e.g. If the Validation works. The second is "Prediction" e.g. if I put the validation check in Cell C4 that 9>500, it would print error if there was more than 500. The last column is the "Results". It is where you put in he results of your test and to see if your predictions are correct. Test, plan and results table: Test Prediction Results Enter data, 250000 into cell C3 Validation Rule! If (20>4000000) it would Print "error" in cell C3 After inputting data in cell C3, C3 prints "error". My theory was right. Enter data =Sum (B6-B12) into cell B14 Formula After tapping enter in cell B14 and inputting formula cell B14 will print �3.800 After inputting formula and tapping enter in Cell B14, it prints �3.800 Enter data, 65422 into cell C5 Validation Rule! If (40>40000) it would print "error" in cell C5 Cell C5 Prints "error" Leave field "Stock" blank Presence check: Required entry. The Cell Would print "enter value in field." Cell prints "enter value in field." Enter data =Sum (C4:C5) into cell C6 Formula After pressing enter in Cell C6 and inputting formula cell C6 will print �24.300 After inputting formula and tapping enter cell C6 prints �24.300 ...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

# Related GCSE ICT Systems and Application essays

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

This wastes our quality lesson time and also makes working on the computers quite slow and difficult. Computers are extremely restricted. While this is done to prevent trouble, it prevents a lot of normal day computer use from happening. It also makes it harder to deal with errors due to the restricted computer's limited settings.

2. ## Creating a computer system for a video rental shop

Advantages * Good price * 12 month warranty * Have all the essential facilitates required by the leisure centre * Ethernet card included which allows networking later on and fast transfer of data. * Intel Pentium 3 1GHz processor, this is fast possessor that can handle most applications.

1. ## This project is designed to help non-computerized library to easily keep track of their ...

CHAPTER III PROPOSED SYSTEM OBJECTIVES OF THE PURPOSED SYSTEM * Speeding up of the library lending system. * A greatly improve service: the information about the book, the borrower of the books and the reservations should be handled efficiently. * The member should have access to the library 24-hours *

2. ## ICT PROJECT

Data entry and Validation Ms Gammon will input the assignment marks and mock exams in to the system. The information may be edited rarely but it may need to be updated after a while, this is why validation checks would be necessary to limit the amount of errors occurring and to make sure the data being inputted meets certain specifications.

1. ## GCSE Excel Project ICT

=IF(D7>0,VLOOKUP(\$D\$7,HDDTBL,7),"") RAM Make Size Price =IF(D10>0,VLOOKUP(\$D\$10,RAMTBL,2),"") =IF(D10>0,VLOOKUP(\$D\$10,RAMTBL,4),"") =IF(D10>0,VLOOKUP(\$D\$10,RAMTBL,6),"") Make Speed Price =IF(D13>0,VLOOKUP(\$D\$13,GCTBL,2),"") =IF(D13>0,VLOOKUP(\$D\$13,GCTBL,4),"") =IF(D13>0,VLOOKUP(\$D\$13,GCTBL,6),"") Maker Price =IF(B16="None","None", IF(B16="Vista Basic","Microsoft", IF(B16="Vista Premium","Microsoft", IF(B16="Vista Ultimate","Microsoft", IF(B16="XP Home Edition SP3","Microsoft", IF(B16="Medusa","WarlordTF", IF(B16="Mackintosh","Apple Inc.",""))))))) =IF(B16="None","�0", IF(B16="Vista Basic","�120", IF(B16="Vista Premium","�200", IF(B16="Vista Ultimate","�290", IF(B16="XP Home Edition SP3","�150", IF(B16="Medusa","�340", IF(B16="Mackintosh","�280","")))))))

2. ## Spreadsheet Project - computer system for a video hire shop.

I shall use both of these books as the source of data collection. In addition to financial data, I shall be collecting data on the videos and members of the shop. Jack Challis would like clearer information concerning: which are the most popular videos, which videos have not been rented for some time, who his most frequent customers are etc.

1. ## Introduction to information skills and system. An information system is a system that accepts ...

Hardware for collecting different data Text - keyboard, text scanner, voice recognition Numbers - bar code readers, data loggers, keyboard Images - scanner, web cam Video - video recorders, digital cameras Audio - micro-phone, Software for collecting different data Text - Microsoft word Numbers - Microsoft excel Images - scanner

2. ## Ict coursework full

Page #4; Receipt On the receipt page, the items that the customer has bought are listed, along with prices, totals, sub totals and quantity figures. There is a link that will take the user to the invoice page, show above.

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