Spreadsheet Analysis By Catherine George

Spreadsheet Analysis By Catherine George

Introduction In this PowerPoint I will be analysing the good and bad points about 2 different spreadsheets. I will be specifically looking at the purpose, what the data shows, what data they have, features of the spreadsheet (formulae), features that would improve productivity, accuracy and usability. I will also give strengths and weaknesses of each spreadsheets and the improvements that could be made to improve these weaknesses.

Purpose of spreadsheet Belgrave School T-Shirts The purpose of this spreadsheet is to show the examination analysis of the students exam results from 2012-2013 in Belgrave School. The purpose of this spreadsheet is to show the profit and loss account of L&C T-shirts up to 2013. The spreadsheet shows the sales turnover, cost of the sales, gross profit, expenses and the net profit. The spreadsheet shows the students name, teacher, the paper marks and percentages, the total marks, whether they passed or failed and how far above or below the national average the students are.

Data they have Belgrave School T-Shirts The data included in this table is the date, the pupils first name and surname, the students teacher, the marks and percentages for paper 1, 2 and 3, the total marks, if they passed or failed, whether they are above or below the national average, what the national average is and the number of students who passed and failed. The data included in this spreadsheet is the sales turnover, cost of sales, gross profit, expenses and the net profit. The sales turnover allows the reader of the spreadsheet to see how much money is made without anything taken off of the total. The cost of sales column allows the reader to see how much it costs to set the business up. The gross profit allows the reader to see how much money is made after the initial costs are taken off. The expenses allow the reader to see how much money is made by the company once all of the expenses has been taken off. The net profit allows the reader to see how much money is made in total. The pupils first name, surname and teacher allows the person reading the spreadsheet to identify the students. The marks and percentages allow the teachers to track whether the students are understanding the work and what marks they got. The grade allows teachers to easily see who has passed or failed.

What does the data show Belgrave School T-Shirts The data in this spreadsheets shows whether the students have passed or failed overall in their exam. It also shows how far away from or above the national average they are. Finally it shows the mark the students achieved for each paper and the percentage which allows the teacher to see which area the students are struggling with. The spreadsheet shows that the majority of students passed however a high percentage of students failed. This data shows the profit and losses made by the t-shirt company. Overall it shows that the company made a profit once all of the expenses were taken off. It also shows that they didn’t make as much profit as they could have done if they reduced the expenses.

Features of Belgrave School This is a function that makes the date appear in the corner of the screen. This is a formula that calculates division, it is used to work out a percentage in this spreadsheet. This is a formula to calculate addition, it is used to add up test scores in this spreadsheet. This is a validation drop down menu that allows the person making the spreadsheet to pick the name of their teacher easily and quickly. These columns have been grouped by colours so that it is obvious to the reader of the spreadsheet that they are related. This layout is used to help the reader to see the information they need quickly. This is also an example of formatting

Features of T-Shirts This is a formula used to calculate the cost of the products needed to run the business. This is a function used to count up all of the expenses needed to run the business. This is an example of formatting as all of the totals have a double line underneath to make it easier to see where the The layout of this spreadsheet is very simple and isn’t very effective. The most effective layout is the 2 last columns. The first column shows the amount of money spent on each aspect of the business. The second column shows the totals such as nett profit, total expenses, sales turnover

Belgrave School- Productivity, Accuracy, Usability In this spreadsheet there are many features that could improve productivity. All calculations needed to be performed are done so using a formula which can be filled down to perform the same calculation for different data. It is very easy to manipulate the data because the spreadsheet is colour coded and organised in alphabetical order. An example of data manipulation in this spreadsheet is the comparison to the national average. Conditional formatting is used in the pass or fail column, making it easy to determine whether a student has passed or failed. Function is used to present the date and formulae is used to do every calculation on the spreadsheet. The features of this spreadsheet also improve accuracy. Data validation is used in the form of a drop down menu. There isn’t any cell protection in this spreadsheet. This spreadsheet uses an IF statement to make accurate decisions as there are only 2 answers available. This spreadsheet has colour coding to help navigate through the spreadsheet quickly. The marks and percentage for each test are grouped together to help associate them as a group in the readers mind. This would help the reader to navigate the spreadsheet quickly and easily.

T-Shirts- Productivity, Accuracy, Usability