I need help with my assignment
Assignment Brief
The local village hall has recently been refurbished and has been available to hire for a few months. There is a hall, a small kitchen and toilet facilities. A committee has been formed to oversee the facilities and booking.
It costs £10 per hour to hire the venue which is available from 8:00am until 10:00pm weekdays and 10:00am-5:00pm at weekends. There is a 10% discount for frequent hirers.

It is expected that the hirer will leave the facilities clean and tidy ready for the next event.

You have been asked to prepare some information for the committee after the first four weeks of use.

Task 1
You need to show the committee the income that has been generated by hiring the facilities over the last 4 weeks.
Use the information below to create a spreadsheet showing, on one sheet, the income from regular bookings and on another the income from ad-hoc bookings for a month. These should include the amount paid to hire the hall and totals for each week and the 4 weeks.
Using the information on these 2 sheets create a 3rd sheet to show totals and types of usage, using charts to help. This should include types of booking regular/ad-hoc, and busy times.

Regular Bookings
The hall is hired from 8:00am – 12:30pm every weekday by the local pre-school.
A local diet group hire the hall on Monday and Wednesday evening from 6:00pm – 9:00pm
The local scout movement hire the hall for Beavers and Cubs on Tuesday evening from 6:00pm – 9:00pm
A local church hire the hall on Sunday from 10:00am – 13:00pm.
A group of local people hire the hall once every four weeks on a Wednesday afternoon for a ‘craft and cake’ event from 2:00pm – 4:00pm.

Ad-hoc Bookings.
The hall has been booked on for other events as follows:
Week 1
Monday 3:00-5:00pm
Friday 6:00pm-10:00pm
Saturday 1:00pm-3:30pm
Week 2
Monday 1:00pm-2:00pm
Saturday 12:00pm-2:30pm, 1:00pm-5:00pm
Sunday 2:00pm-5:00pm
Week 3
Wednesday 3:00pm – 5:30pm
Saturday 10:00am-11:30am
Week 4
Tuesday 3:00pm-5:30pm
Friday 6:00pm-10:00pm
Saturday 10:00am-12:00pm, 2:00pm-4:00pm
Sunday 2:00pm-5:00pm

Task 2
You have been asked to speak to committee to show them the income figures you have produced along with information about the usage of the hall.
Use the information from Task 1 to create a short presentation to show the hall committee at their next meeting, you will have about 5 minutes at the meeting for this. The presentation should include links to the spreadsheet so that any updates will be reflected and some images to add interest.
Write a short report that contains this information that the committee members can take away. This should include some of the charts produced in task 1 but should be no more than 1 side of A4.
(Indicative word count <1000)

Just prior to the meeting you realise you have missed a booking from the information.
Add a booking for week 3 on Friday evening from 6:30pm-10:00pm. Ensure that the report and presentation are using the up-to-date information.

Task 3
The committee are keen to see the hall being used more, especially by local people.
Create a flyer (A4 or A5) that could be used to advertise the hall and its facilities.

Task 4
Assemble a portfolio of evidence.

Include evidence of Tasks 1-3. This must include a spreadsheet with at least three sheets, presentation slides and notes, a written report and leaflet.

All your files should be stored in folders with appropriate file names so that they can be easily found and retrieved. Include a screen shot showing how you have stored files.

Explain some different file formats, particularly for document and image storage, with reference to their usage and size.
(Indicative word count: 300)

Write a short report that evaluates the different software you have used for Tasks 1-3, this should include word processing, graphics, spreadsheet, and presentation software. Explain some of the functions you have chosen to use in the software packages and why they were appropriate, annotate your work to show these.
(Indicative word count: 500