• 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: 750

My users are the tutors for all years. The tutors need a system in which to enter attendance marks to analyse the attendance of their students. The spreadsheet should enable them to enter the attendance marks for each pupil

Extracts from this document...

Introduction

Unit 2 Assignment 4 Spreadsheet Project February 2002 By Christopher Perkins MY REPORT What the user needs My users are the tutors for all years. The tutors need a system in which to enter attendance marks to analyse the attendance of their students. The spreadsheet should enable them to enter the attendance marks for each pupil and work out an average of their attendance, and use it to find out what award they need to be given. The users also need to able to print out all of the attendance figures in alphabetical order, in the form of a chart or graph, to be able to see the results more clearly. Where I will collect my information from. I will need the names of the pupils from each year and each tutor I will ask the year managers for this information. ...read more.

Middle

I started to enter my data into the spreadsheet. I entered the column headings and changed the alignment by changing the text alignment to centre horizontally and vertically. I entered the names of the pupils and their attendance marks for the class. I changed the font size of the headings and made them bold so that they were clear and easily identified. I decided to put borders around the text to make it clearer and easier to read and changed the row height, merged cells and changed column widths, using the format menu. The Average To work out the average attendance I used the average function. I clicked on the = sign on the toolbar and chose "Average" from the list of options. Then I clicked on the R17 block and entered =average(R6:R16) ...read more.

Conclusion

Graphs Graphs allow people to just glance at information and understand it so it is a good idea to have them in your spreadsheet. To put graphs onto the spreadsheet you must first highlight all of the information you want to enter into the graph then click on the chart wizard button on the toolbar. When the chart menu appears you can select what type of graph you would like, I chose the bar chart menu and selected the 3D bar chart option then pressed next. Then you can enter your axis titles and chart title on the next screen. I named by bar chart "Award Chart" and labelled the Z-axis "Number Of Pupils", then pressed OK. After I pressed OK a box titled chart location appeared, in this box I clicked on "As object in Attendance" then pressed finish. Then your chart will be complete. CREATING A SPREADSHEET MY REPORT Christopher Perkins 1 Farnborough School 28352 ...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

See related essaysSee related essays

Related GCSE Software essays

  1. Design a spreadsheet that can be used by a school tuck shop.

    * The following spreadsheets didn't change to fit with new product. * The total expenditure column when added with a SUM function included the new row in its calculations. If certain stock doesn't sell Before After These are the graphs I produced and explained how to make in the implementation.

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

    a glance what the lowest and highest score was, and the class average; from seeing this data she can then tell if the class is doing well or if extra work is required. To calculate the max, min and average, I completed the following steps: 2)

  1. ICT BTEC UNIT 2 - REPORT

    very easy to use and most of them are very quick, they will be quicker depending on the computer. All of the programs have their own system requirements however if your computer specs are higher than the requirements of the program than it's bound to be faster, more efficient and less tedious.

  2. Powerpoint review project

    I will then select the custom animation that I want then edit it to how I want it. Slide Transitions and timings For my slideshow I will be using slide transitions and timings. I will be using these to time how quickly my slideshow runs to the next slide.

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    The first sheet willl have the front page, middle page and the last page. This first sheet will only contain information about the restaurant such as the contact, map, the history of the restaurant etc. the second sheet will also have 3 sides all containing the different dishes their prices.

  2. Excel - Analyse

    The spreadsheet will be saved on to the hard disk but for Buck-up I will also use CD-ROM's. I originally thought I will use Floppy-disks but because of their slow access I have decided to use a Re-writeable CD. Floppy Disk * Not a lot of space, only 1.44MB.

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

    TASK C: Spreadsheet coursework page 1 C: Specification of Solution From the information I gathered I could now finally begin to design my system. I am hoping to produce a spreadsheet that will help, with the organisation of the computer shop.

  2. GNVQ intermediate ict unit 4

    Formulas and Functions that I used The function to calculate new records: New Rec? =IF(C5<B14,"Yes","No") =IF(C6<B15,"Yes","No") =IF(C7<B16,"Yes","No") =IF(C8<B17,"Yes","No") =IF(C9<B18,"Yes","No") The VLOOKUP to calculate the scores and SUM to calculate the final overall score: Event North 100m =VLOOKUP(H14,$D$14:$E$17,2) 200m =VLOOKUP(H15,$D$14:$E$17,2) 400m =VLOOKUP(H16,$D$14:$E$17,2)

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