• 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

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