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

Create and check a multi-sheet spreadsheet solution to meet specified user needs that uses a selection of appropriate functions and both simple and complex formulae

Extracts from this document...

Introduction

M1: Create and check a multi-sheet spreadsheet solution to meet specified user needs that uses a selection of appropriate functions and both simple and complex formulae A spreadsheet is also known as a worksheet, as it is made up of tables; it is organized into columns and rows, this makes individual cells. The columns have labels which have letters of the alphabet, whereas the rows are numbered, both of these features enables the cells to have and address, which is the column letter and the row number. � Spreadsheet are used for different types of things, but are most frequently used for storing, manipulating and analysing numeric data. For example: - Storing values: number of sales made in each year. - Manipulating large sets of data: sorting and filtering makes it easier for a certain criteria to be identified. � Spreadsheet are used for different types of things, but are most frequently used for storing, manipulating and analysing numeric data. ...read more.

Middle

= 114.68 Week 3: I cross-checked this by using a calculator: = 64x12.7425 = 815.52 = 1087.36-815.52 = 271.84 = 271.84 Week 4: I cross-checked this by using a calculator: = 63x12.7425 = 802.7775 = 1070.37-802.7775 = 267.5925 (I rounded it up to 2 decimal places) = 267.59 I then highlighted column "profit" and pressed fill handle, to get the rest of the results. I did this for week 2, 3 and 4. Total weekly sales Function: Week 2,3 and 4: I calculated the total weekly sales by entering this formula in the function bar "=SUM(D5:D24)", Using calculator manually: Week 2: I cross-checked this by using a calculator: = 27+88+103+79+43+105+77+54+71+76+75+56+113+90+47+90+57+47+52+73 = 1423 Week 3: I cross-checked this by using a calculator: = 64+61+75+63+28+116+36+55+41+84+36+41+67+73+61+106+51+66+56+94 =1274 Week 4: I cross-checked this by using a calculator: = 63+133+75+67+70+89+41+18+53+103+44+65+82+71+73+79+48+23+66+92 = 1355 Total weekly income Function: Week 2, 3 and 4: I calculated the total weekly income by entering this formula in the function bar "=SUM (F5:F24)" ...read more.

Conclusion

Using calculator manually: Total: I cross-checked this by using a calculator: = 1255+1423+1274+1355 = 5307 Chart Bar chart I produced my bar chart show the total sales of books for each week Step 1: I highlighted week 1, 2, 3 and 4 of the total weekly sales Step 2: I then pressed chart, which opened chart wizard Step 3: Here I inserted the information to produce the chart Step 4: So I clicked the type of chart I wanted; bar chart Step 5: Then clicked columns on the next page. Step 6: Then I a new page came, and I wrote down the chart title, the x axis title and y axis title. Step 7: Then I pressed finished Error checking I checked my errors by pressing "error checking" and it would automatically check if I had any errors in my formulae's: I did this for week 2, week 3, week 4 and weekly analysis. The results for all four of these tables, was that there wasn't any errors in my formulas. ?? ?? ?? ?? Unit 10-M1 Huriya Nazari ...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

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. GCSE Calculator Project

    I will need to buy a calculator. Software What software features do you need? In Microsoft word you can't make any textboxes, buttons, and code to add functionally and present it well. On PowerPoint you can present the work neatly but you can't make buttons textboxes or code to add functionality.

  2. The impact of ICT on a person with special/particular needs

    She can also send SMS messages by saying 'SMS', then saying the name of the contact, then using word prediction she can either spell out letters, say whole words or use an increased text size to write words, made easier via word prediction.

  1. Log Sheet

    The Use of Hardware In this section I looked at how hardware was used in my system, looking at different hardware (i.e printer, monitor etc.)

  2. Describe a wide range of technologies used by an adult in employment, with evaluation ...

    She uses email from her phone by selecting the email inbox from the black berry phone from the main menu. Advantages of email from a mobile and does it meet her needs? The advantage of mobile email is that she can receive and write messages from where ever she will be.

  1. Analysis of Whipps Cross Hospital

    I will then store this information onto the computer. So altogether their will be six rows. For the second table for patients I will put the patients name in the first field, gender in the second field, then the address in the third field and their date of birth in the fourth field etc...

  2. System requirements analysis

    They will just need to click onto the button and a quick description of what the page contains is also included. This makes the software more easy to use. New receptionists and doctors can easily learn how to function the software which will save time.

  1. ICT helping someone with special needs

    breaks o Something's very disturbing o Gets lost o One of the bad thing about Braille Watches is that it only reminds you once and that's bad because maybe the person is fast a sleep and can't hear it so they will mess the alarm How the technology meets their

  2. COMPUTERISING HIGHLANDERS BAKERY 1.1 DESCRIPTION OF THE PROBLEM Highlander's bakery is ...

    Then it shall automatically add everything up, showing how much was made that month and how much of it is profit. 1.3 DESCRIPTION OF EXISTING SOLUTION The cashiers write down all of the day's proceeds in a big book. All the staff members can access this because it's necessary for

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