Question

STEP 1   Open an excel sheet.

STEP 2.                 Save to your desktop and Rename the sheet as follows:   ####### COMP45 13M 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.

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

The proposed class sizes are as follows:-

Grade 7 with 15% of the school's population

Grade 6 will be 18%

Grade 5 will be 15%

Grade 4 will be 15%

Grade 3 will be 18%

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 are fixed as follows: Grades 3,4 and 5 pay $3000.00; grades 6 and 7 pay $3750.00; the Gifted program costs $5000.00 and LDD students pay $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 total earnings for the school for the semester. Your sheet must be easy to read and easy to understand.

You have completed your assignment.

could you please tell me what information do you need? please what you know send me fast I have due in 30 min

Answer 1

Please find the following excel representation screen shot.

1. F2 cell shows the total student strength
2. Students per Grade = F2* grade percentage Example for Grade 7 is =F2*15/100
3. Male 50% = C5/2
4. Female 50% = C5/2
5. Schools Income per semester = F5*C5
6. Schools Total Earning per semester = sum of G5 to G11