Excel Project (Identify+Analyse) Essay

Published: 2020-04-22 15:24:05
689 words
3 pages
printer Print
essay essay

Category: Microsoft Excel

Type of paper: Essay

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Hey! We can write a custom essay for you.

All possible types of assignments. Written by academics

GET MY ESSAY
Problem:

Create a computerised spreadsheet using Microsoft Excel (a quiz) for a school because in the school they have to make the quiz hand written, and lose it many times and there are too many papers. So to, solve this problem I will create a computerised spreadsheet.

Objectives:

* To have multiple spreadsheets to have different functions

* Contains formulae to carry out the calculations on data and update related cell values

* Need a look up function, in order to link between spreadsheets.

* Make it user friendly so it easy to navigate and clear to understand

* Include a logo

* Make spreadsheet password-protected fro security purposes

* To be able to create graphs based on the scores

* Use freeze panes to facilitate scrolling down records, clearly

* Have conditional formatting to react to the changes in the value in the spreadsheet

* Data Validation to format cells for your data-type (string, currency)

* Size check (shrink) in order for it to fit on the page

* Have commands to run macros for e.g. printing

* Must have a summary sheet (Quiz Questions to let user have an overview or) in order to quickly be able to see the main trends or data (probably a chart)

* To have different font type, colour

* Have a border around the cells so it is clear

Users:

The teacher will use the spreadsheet to make the questions and answers to them. Students might also use the spreadsheet, if the teacher wishes to make the students do the quiz on a computer rather than printing it out, and giving them it to fill in using a pencil or pen. The teacher might need to take some classes in order to fully understand how the spreadsheet works, and how to fill in the questions and answers.

Alternative solutions:

I could have just used paper, a database or just another manufactures software like Microsoft Excel. But I decided to use Microsoft Excel because a spreadsheet will do calculations with a great degree of accuracy. A spreadsheet takes up less room than a filing cabinet. A spreadsheet can automatically generate graphs. However, The disadvantage of computerised systems are that they require training to use and to produce, they rely on electricity and there are security concerns about systems on networks (people can hack them). I didnt use paper because it would take too long, and have many loose papers. I didnt use a database because it is hard to contain formulae and to keep record of it. I didnt use another manufacturer software like Microsoft Excel because I only had Microsoft Excel on my computer.

Analyse

Software:

I will use Microsoft excel a spreadsheet package for making the spreadsheet. This is because Excel is an excellent application for producing graphs and charts and in Excel, you can lock certain areas of the spreadsheet to prevent misuse. I will use Microsoft Word, the desktop publishing for making notes. I will use Internet Explorer for research.

Hardware:

In this project, I will need a Standard PC, and Windows XP installed on it to make the spreadsheet. I will need a modem, to connect with the Internet for research. I will also use a colour monitor, keyboard, mouse and a colour laser printer.

Input:

It is the data that goes in and how. For example, I will input data for the quiz on Microsoft Excel. Some of it goes in by user formulae in cells, headers type etc. Some of input will be by cells by result of updated formulae (calculations)

Output:

It is the Screen for showing us what is happening on computer. Saving your work is also an output. Print outs of spreadsheets is also an output.

Process:

It is a formulae carrying out calculations and updating value of cells.

Validate:

To validate means for computer software to check that the data being input is sensible. An example is validating cells in correct type.

Verify:

Verification is the process of checking that input data is correct. It is normally carried out by a human who visually compares the data with the source document. To check spreadsheet, is an example of verification. Also user feedback is verification.

Warning! This essay is not original. Get 100% unique essay within 45 seconds!

GET UNIQUE ESSAY

We can write your paper just for 11.99$

i want to copy...

This essay has been submitted by a student and contain not unique content

People also read