TASK A Create a table in spreadsheet that records the following data for each student ID Number Last Name First Name Gender Grade Level Add a new column to determine the students school fee based on their Grade level ID: 479797
Download Presentation The PPT/PDF document "Spreadsheets" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
SpreadsheetsSlide2
TASK
“A”
Create a table in spreadsheet that records the following data for each student: ID Number, Last Name, First Name, Gender, Grade Level.Add a new column to determine the students school fee based on their Grade level.Slide3
Insert columns to:
calculate the amount to be paid for tuition
determine the appropriate payment planuse an appropriate function to display the percentages for discount or interest based on the payment plan selected calculate discount or interest due for each studententer the actual amount paid by each studentSlide4Slide5
Calculate totals for all tuition, discount/interest, actual amount
paid
A new student O’Neil Golding has been added to the upper school population, the student’s fee was paid in full.Slide6
The third student was unable to meet the requirement for full payment plan and instead selected the tri-payment plan. Make the necessary changes.Slide7
Task “B”
Insert a column to calculate the remaining balance to be
paid
Sort the data by payment plan in ascending order then by last name in ascending orderSlide8
In
another
section of the spreadsheet use complex criteria to extract all person who opted for bi-payment and tri-payment Slide9
Create a summary table to show total males, total females, total students, total payments received, Total amount owed, maximum amount owed, minimum amount owed, Average Payments Received.Slide10
The principal in a bid to encourage the payment of balances has decided to reduce the interest rate to 6.5%. Make the necessary changes to the spreadsheet.Slide11
Create a pie chart to illustrate the total number of students in each payment plan. Give the chart an appropriate name and place it on a separate sheet.Slide12
Generate a bar graph to show the trend in fee payments for upper school students. Use of appropriate titles and labels. Place the graph in a suitable section on the worksheet.Slide13