• 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
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14

Air Training Corps Information System

Extracts from this document...

Introduction

Spreadsheet Report The USER is the person in charge of the A.T.C (Air Training Corps) squadron who needs to replace the old paper based information about each cadet with a computer spreadsheet The user needs to be able to have relevant personal information on all the cadets, the attendance of each cadet and subscriptions paid, to be able to see the percentage of attendance and subs paid of all the cadets, the total amount paid and attendance with averages, minimums, maximums and range. When the spreadsheet is finished the user will be able to clearly see the information on all the cadets, see how much each cadet has paid and how frequently each cadet attends. The user will be able to see the percentages and totals and the averages, minimums, maximums and range of each cadet's attendance and subs. Also when the spreadsheet is complete the user can update amounts paid and attendance for each month so the totals and percentages change. The user will also be able to use the 'what if' functions to show what happens if the amount of the subs is changed I have decided to separate the information into three tables and the data need for each table is listed below Table 1: Information Second Name First Name Gender Rank Classification Date of Birth 22 L98 D of E level Year Joined This is a table of information about each cadet. ...read more.

Middle

This formula takes the total attendance to date from cell I3, then divides it by the number of cells in that row which have a value entered into it. So after two months the total attendance will be divided by two, after three months it will be divided by three and so on. Column I shows the the number of months to date that each cadet has attended. I have entered the function =SUM(A3:H3) into cell I3 then copied this formula into the cells below it as before. This function gives the total of all the values in the range of cells from A3 to H3 To enter the function, click on the Paste button on the standard toolbar : Then select from the Function name box : I have used the Average function =AVERAGE(I3:I18) to give the average attendance for all cadets. I typed the function into the cell where I wanted the answer to appear. I did this so I could see how much each cadet was attending compared with the average for the squadron. I did this for both the total and percentage columns. I have used the Maximum function =MAX(I3:I18) to show the highest attendance and the Minimum function =MIN(I3:I18) to show the lowest attendance. ...read more.

Conclusion

Using the Sort feature, I can then put the first column (Second Name) into alphabetical order. I did this by clicking on a cell in the column I wanted the rows sorted by, then clicking on the Sort Ascending button on the standard toolbar The New Cadet now appears in the correct alphabetical position. All the information in the row about this cadet has moved with the first column Table 2: Attendance It might be useful to sort the grid by percentage attendance to show who has the highest attendance and who do not attend often. Using the Sort feature, I can put the last column ( % to date) into alphabetical order. I did this by clicking on a cell in the column I wanted the rows sorted by, but this time clicked on the Sort Descending button on the standard toolbar. This will give me the highest percentages at the top of the table Table 3: Subs A similar sort could be done on the % Paid column to show which cadets are behind with their subs Accurate and safe ??? ?? ?? ?? ?? Laurence Malyon G.N.V.Q ICT Center No. Dcc54311 Center Reference CLI8114 Student Ref. T394472 Spreadsheet Report 1 of 2 1414 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Molecules & Cells 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 AS and A Level Molecules & Cells essays

  1. Spreadsheet report

    containing the formula I had just entered and dragged in down ward motion to the bottom of the column. To work out the profits I clicked on the first cell in the profits column, clicked on the functions button as a result a window came up.

  2. spreadsheet report

    I merged the cells by clicking in the formatting toolbar. Merging the cells is when you turn several cells into one. I did this for each group of three cells above the Marks, Grade and Attainment. I then entered Test 1 in the first merged cell.

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