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