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

# Excel Spreadsheet project

Extracts from this document...

Introduction

Evaluation The Excel Spreadsheet project I am making is to make a practical and sufficient way of calculating the calorie expenditure and calorie consuming and working how much weight can be lost over a time space. I chose to use Excel Spreadsheet instead of the other solutions because it had many appealing qualities some of the qualities were: - Neater - Quicker to use - Easier to use - Can be saved on disk - Helps customer to calculate caloric intake - Helps customer to calculate caloric expenditure - Cannot be damaged - Can be printed out if needed to. Before making the Excel Spreadsheet project I had created 10 quantitative objectives to help me create the Excel Spreadsheet and meet the user requirements. Here is a list of the user requirements and how I met the quantitative objectives. 10 Quantitative Objectives Here are the 10 Quantitative objectives that I will use in order to create the system. - Fat Fighters Logo on Spreadsheet - This wasn't very hard to do as I saved the picture onto a word document, and copied and pasted the image into the spreadsheet, ...read more.

Middle

- Should look professional - by the layout, color and images. I fulfilled this objective by taking out questionnaires when designing the layout of the spreadsheet and asking questions about what colors and images would be used and how to make the spreadsheet look professional. - Drop Down lists of exercises/activities and Foods should be sorted alphabetically - The drop down list of exercises/activities and Foods sorted alphabetically was a hard thing to do as I did not have the information to sort it out in an automatic way so I had to type them out manually, although this was time consuming the objective was met successfully. - Should be easily changeable - This was not a hard objective to meet as the information and formulas were easily changed. -Easy to use - instructions, or just being easily typed in and finding out the answer straight away. - Questionnaires were asked to find out if the spreadsheet was easy to use. The questionnaire results were positive meaning that the objective was met. ...read more.

Conclusion

To make the spreadsheet a success I would add more images onto each spreadsheet page, e.g. on the calculator pages, which would improve the quality of the spreadsheet by making it more interesting therefore helping to meet one of my objectives. I would have designed the layouts on what they had ended up to be in the first place, this was because I thought it looked better and this would have saved time and made me have more time to work on something else to do with spreadsheet, and I would have had more time to improve it. I would have also used more verification and validation formulas to decrease the chances of error. I would have also used less Word art as it was an unpopular choice, I would have maybe chosen a different type of Word art which was more popular with the user/customers. In order to find out what was popular I could have made a questionnaire using a sample of Word Art types and ask which ones were their favourites. ...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 Software 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 Software essays

1. ## The aim of my project is to make the task of the allocation of ...

Most choices can easily be selected via drop down menus, and a simple click will change the whole sheet according to the pre-determined pricing of the item selected. To test this we will check that the drop down menus work.

2. ## Spreadsheet Technical report. My task was to produce a grade book for primary ...

Validation is useful as it automatically tells you if you have typed in a wrong value, this helps you to not insert incorrect data. This warning is to let users know what type of data is to be entered e.g.

1. ## AQA GCSE ICT Specification B

This would find many of the fields lacking in data validation. Criteria 6 Criteria Details The user must be able to print every output from the output viewing page. Evaluation This test failed, the outputs do not have print buttons on them.

2. ## Powerpoint review project

The use of ICT in solving this problem. The problem will be solved by creating a PowerPoint Presentation because it is good for organisation and is more exciting. A PowerPoint presentation is the most suitable medium for my purpose because it is exciting, good to use and explains everything step by step.

1. ## Spreadsheet for a basketball company

counts the number of adult and child seats booked. From these results I can use the formula =SUM(P12:P14) which simply adds the three results together to calculate the total occupied seats. Than to get the number of available seats the formula =147-Q12 can be employed where 147 is the number of seats altogether and Q12 is the cell reference of the total number of occupied seats.

2. ## Payments Spreadsheet task. - formulas and fomatting

Description of formatting used:- > The formatting used in this spreadsheet are formatting cells into currency since this is a payment spreadsheet, formatting alignment of cells so the text fits perfectly into the cell and changed ways of text alignment for e.g.

1. ## spreadsheet project

Finally it must have the amount of money owed to the manager, by having a list of all the trips and activities that are available and whether the family is going on them, this should then include the type of payment which the customers wish to pay.

2. ## Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

Later after every few months one of the employees has the enjoyment of typing out all our sales and purchases, in great detail, this makes it very time consuming and I hope to improve on that substantially. In order to obtain good results I have set up questionnaires and sent

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