Using Microsoft Excel To Keep Track Of Monthly Payments

826 words - 3 pages

As Miss White needed help to keep track of monthly payments made by the 10 pupils in her group and to keep a monthly record of individual payments, a running total for each pupil, the overall total collected each month and the average amount per pupil collected each month. The overall cost of the trip is £500 per pupil between the months of October to March excluding December.

Choice of Application Used

To do this I needed to use the software Microsoft Excel 2003 as it was easier to use than other software products. As well Microsoft Excel can perform more useful functions such as Absolute Cell Reference, Functions (MIN, MAX and AVERAGE),Conditional Formatting and many more. Each of these useful in a case such as this.

Information Access

The information was found for this spreadsheet by using the database used in the previous Assignment B2 by running a query in the pupil database to find Miss White’s pupils, although in the assignment descriptions it mentions that there are 10 pupils and once the query was run 11 pupils were found. As Jenny Vance was added into the previous Assignment she was removed for the following.


Report
Validation
As the values are being inputted and the pupils aren’t allowed to give up more than £100 a month to stop this from happening I used validation to make sure that if a value was added a warning sign to stop you from inputting that value.


To do this I highlighted the cells which need this function of validation used and went to the data toolbar and validation.

After this the screenshot as below showed up and I was able to tell this tool to let any values being put in more than £100.

After this was done the warning as shown below in this screenshot showed up after I inputted £101 in a cell and validation wouldn’t allow it as no more than £100 could be put in.

Conditional Formatting

To make the spreadsheet more applicable and to make it easier, with the use of conditional formatting the user could see which pupil has still yet not paid for the trip and how much they still have to pay. Both of these are under the heading, “Total,” and, “Outstanding Balance.
By choosing a suitable colour which would make it more evident for the user to see which pupils still have to pay and how much they need to pay.

Formula View

After the values were inputted and the correct formulas/functions...

Find Another Essay On Using Microsoft Excel to Keep Track of Monthly Payments

EFFECTS OF USING COMPUTERS TO CHILDREN

1915 words - 8 pages ________ Year __2014___ LECTURER NAME BRYAN M. CUBELO ASSESSMENT /ESSAY TITLE EFFECTS OF USING COMPUTERS TO CHILDREN DUE DATE 22./02/2014 DATE OF POSTING 28/02/2014 APPLIED FOR EXTENSION? X YES NO N/A REFERENCE NUMBER: ….....….....…..... KEEP A COPY If you have submitted assessment work electronically please make sure you have a backup copy. PLAGIARISM Plagiarism is the presentation of the work of another

The Failure of the League of Nations to Keep Peace in the Nineteen-Thirties

2934 words - 12 pages The Failure of the League of Nations to Keep Peace in the Nineteen-Thirties After World War One in 1919 the allies created the League of Nations. It had a simple "raison d'etre", that was to prevent war. Its chief architect was President Woodrow Wilson of USA. However, upon its creation the United States did not join. Throughout its years the league faced many problems and struggled, however it managed to stay together

The Historical Origins of the Second Amendment’s Protection to keep and Bear Arms

1452 words - 6 pages constitution was for the people’s protection. According to Howell, Jardine and Cobbett, the right to keep and bear arms originated from the English bill of rights formulated in 1689. There were several other individual rights specified in this Bill of Rights (367-368). Although these rights were specified in the Bill of Rights, people never thought of using them to fight for their rights. People never acknowledged that they had rights independent

Using the Laws of Physics to Decrease Car Collisions

1719 words - 7 pages crashes into a wall represents a collision where the car goes from having some magnitude of velocity to have a velocity of 0, therefore the force of the system can be determined using newton’s second law. Using newton’s second law, we can predict the outcome that the car is going to be stopped when it hits the wall. We know that because as the car exerts a force on the wall, it will also exert an equal and opposite force on it, and since the wall

The Disadvantage of Using English to Teach Mathematics and Science

1504 words - 6 pages but what can be seen, the lack of PPSMI has overcome all the benefits of PPSMI. Many people do not agree to the implementation of PPSMI. There are disadvantages of using English language to teach Mathematics and Science the effect to Malaysia language, lower student achievement and increase a lot of cost to education. PPSMI been enshrined as a policy decision of the Malaysian government as a result of the Special Cabinet meeting on July 19, 2002

Using futures contracts to take advantage of the January Effect.

3018 words - 12 pages consists in buying stock index futures contracts. Indeed, buying futures maximizes the evolution of the index. Using futures, you can bet more money than you have. It may also help to minimize transactions costs which are a significant point for small investors.Investor could use futures only on one index (i.e., an intra-market spread,). This strategy requires an initial margin of $20,000. Or, they could also use a spread contract (i.e., go long on the

Example of Using a Lobby Group to Help the Community

815 words - 4 pages canvassing. One of the members suggested using social media and the United Way offered to help by placing a thread on their web page. The six members share their personal stories via a video on the website. The website would be filled with current information about the effects on society when there is lack of adequate resources in a city and have a discussion forum and sign up tab. They decided to take advantage of the fact an election was imminent in

Using The Mythology of Love to Analyze Amy Foster

1027 words - 4 pages Using The Mythology of Love to Analyze Amy Foster   In Amy Foster, Joseph Conrad has written a great story that shows the different types of love felt between Amy and Yanko as described by Joseph Campbell in his essay on The Mythology of Love. The relationship of Yanko and Amy is dynamic and changes as the story progresses. At first, Amy feels compassion for Yanko; she does not see the differences between him and the English

Using example to analyse the five philosophies of marketing.

1865 words - 7 pages 1. IntroductionAs the development of economy, recently more and more people focus the importance of concept of Marketing because it has already improved the people's viewpoint which how to deal the business. However, one of the most persistent conceptual problems in marketing is its definition. In the light of Philip Kotler, marketing definition consist of social definition and managerial definition. (Kotler, 2000, p7-8). According to the

With more than 4,000 of its 27,000 employees already millionaires, Microsoft faces the challenge of figuring out how to motivating its employees though means other than pay raises.

646 words - 3 pages With more than 4,000 of its 27,000 employees already millionaires, Microsoft faces the challenge of figuring out how to motivating its employees though means other than pay raises. While this problem is not unique to Microsoft, the circumstances under which this problem evolved however, are. As a company that must caters to the needs of the 'professional' worker, Microsoft's motivational strategy should center around recognition of individual

Using Lies to Define Morality of Characters in Adventures of Huckleberry Finn

1431 words - 6 pages for merely self-serving and immoral initiatives. Mark Twain also uses the lies of Huckleberry Finn to show the essentially good and righteous nature that Huck possesses. This aspect of the novel shows the rare, moral side to telling lies. Twain shows this early in the novel when Huck lies on behalf of Jim: ?Set her back, John, set her back!? says one. They backed water. ?Keep away, boy ? keep to looard. Confound it, I just expect the wind

Similar Essays

Benefits Of Using Microsoft Excel Essay

1700 words - 7 pages physical education assessments evaluations. Physical education teacher always test students in different areas of physical fitness. With a software program like Microsoft Excel physical education teachers can easily analyze both the class and an individuals’ testing score. David Kahan (2002) describes this as an excellent way to track student progress and by using this method teacher save a lot of time. In a world in which technology is

Using Gps To Track A Particular Person

3344 words - 13 pages , a person in need is not able to talk or give an exact location; however, with GPS their location would already be known. When a child is kidnapped, or runs away, they are likely to have a cell phone on them. In such a circumstance, one could easily track the location using the GPS chip in the phone. The Government is looking into GPS systems in cell phones to track suspected terrorists. In the after-math of 9-11, security has been

Internet Writing How To Keep One's Attention Using The Internet As The Medium.

807 words - 3 pages increase our time management and they're by save money.With the hundreds of thousands websites available for viewing, we do not have the time to go through each and every one. Surfing becomes our way out of this information overload. By tailoring your site to meet the following criteria; Write concise text, write skimmable text, Clear hyperlinks to provide users with direction, Write objective and clear text, and write with design in mind. By using these guidelines you will be able to effectively sell your product or present your information in a clear and concise manner.

Stock Trade Project. Choose A Particular Stock And Keep Track The Performance Of This Stock During The Term. Write A Summary Of The Stock's Movement.

1163 words - 5 pages Stock track projectDanone GroupINTRODUCTIONDANONE Group is a producer of fresh dairy products, packaged water, biscuits and cereal products. The Danone group is the worldwide leader in water and fresh dairy products and ranks second in biscuits.Over the years, Danone has taken strategic steps to achieve a worldwide presence and focus on three business lines: dairy products, biscuits and water. The Company's portfolio of brands and products