Question

STEP 1   Open an excel sheet.

STEP 2.                 Save to your desktop and Rename the sheet as follows:   ####### COMP45 13Q ASG 2   [####### MEANS STUDENT NUMBER]    (20)

STEP 3.    Read the following text. After reading the text, your task is to convert the data that are stated below into an excel spreadsheet. Make sure that you have recorded the data correctly. Layout your spreadsheet logically. Your sheet must be easy to follow and be viewed in a single frame. (100)

The La Image Private Elementary School has resumed its enrollment for the upcoming school year. There is space for 7363 students.

The proposed class sizes are as follows:-

Grade 7 with 15% of the schools population

Grade 6 will be 18%

Grade 5 will be 15%

Grade 4 will be 20%

Grade 3 will be 13%

There is a Grade 3 Gifted Program which will have 9% of the enrolment. The remainder of the enrolment will be reserved for students with learning difficulties/disabilities (LDD).

It has been debated widely and the School Board has set up the female/male split at 50/50 or as close to 50/50 as possible.

The per semester fees is fixed as follows: Grades 3,4 and 5 pays $3000.00; grade 6 and 7 pays $3750.00; Gifted program costs $5000.00 and LDD students pays $1000.00.

Your task is to set up a spreadsheet that shows the breakdown by grade, by %, and showing student grade total ALSO you must show the split by % by grade and the male/female student count by grade. Your calculations must also show the school’s income for the semester by grades and a total earnings for the school for the semester. Your sheet must be easy to read and easy to understand.

Answer 1

the la image private elementary school has resumed its enrollment for the upcoming school year.

the details are :

Grades	% of students	fees	no.of male/female studens
grade 7	15%	$3,750.00	1104
grade 6	18%	$3,750.00	1325
grade 5	15%	$3,000.00	1104
grade 4	20%	$3,000.00	1472
grade 3	13%	$3,000.00	957
grade 3 gifted program	9%	$5,000.00	662
LDD students	10.05%	$1,000.00	739
total no.of grades=7	total =100%	total fees by grade=$22,500	total students = 7363

earnings for the school based on the students by grade:

Grades	% of students	fees	no.of male/female studens	income by grades of students
grade 7	15%	$3,750.00	1104	$4,140,000
grade 6	18%	$3,750.00	1325	$4,968,750
grade 5	15%	$3,000.00	1104	$3,312,000
grade 4	20%	$3,000.00	1472	$4,416,000
grade 3	13%	$3,000.00	957	$2,871,000
grade 3 gifted program	9%	$5,000.00	662	$3,310,000
LDD students	10.05%	$1,000.00	739	$739,000
total no.of grades=7	total =100%	total fees by grade=$22,500	total students = 7363	total earnings=$23,756,750

screenshot:

WPS Office #######COM4513QASG2.xlsx 2 x + Menu Home Insert Page Layout Formulas Data Review View Tools Q Click to f... = 7 Show All 414 AutoFilter Advanced Y Reapply ĀL Sort Remove Duplicates 를 PivotTable Highlight Duplicates Manage Duplicates Reject Duplicate Entries Fill Valida Text to Columns - 111 B fx F A B D E 1 Grades % of students fees no.of male/female studens income by grades of students 2 grade 7 15% $3,750.00 1104 $4,140,000 3 grade 6 18% $3,750.00 1325 $4,968,750 4 grade 5 15% $3,000.00 1104 $3,312,000 5 grade 4 20% $3,000.00 1472 $4,416,000 6 grade 3 13% $3,000.00 957 $2,871,000 7 grade 3 gifted program 9% $5,000.00 662 $3,310,000 8 LDD students 10.05% $1,000.00 739 $739,000 9 total no.of grades=7 total =100% total fees by grade=$22,500 total students = 7363 total earnings=$23,756,750 10

the total earnings for the school for semester:

total no.of grades=7

total =100%

total fees by grade=$22,500

total students = 7363

total earnings=$23,756,750