MY BLOGG (:
For this project, we will focus on exploring and using excel.
I then improved my first idea and it ended up looking like this:
For this project, we will focus on exploring and using excel.
We started with doing an 'introduction' by creating a booking system for a show for our rockband. The system included a wecome page, booking page, finance page and a records page.
Here is a screen capture of it:
Then the real challenge came in, our aim is to create a booking system on excel for people to join our rock school. I experimented with 2 methods, trying out how I was going to create my booking system.
<-- My first idea was to create something like this:
My second idea was to create a drop box. However, I ended up choosing the first idea as I thought it would be easier to just click macros to book.
I then improved my first idea and it ended up looking like this:
I recorded a macro which will add one to the table to book. However, I had to make many macros as each page had 31 macros! I recorded many MANY macros as I often made mistakes... :S Also, sometimes the macros wouldn't work and I would have to redo them..
- book student (x6)
- book adult (x6)
- book seniors (people over 60 years old) (x6)
- class canceled (x6)
- master reset (x1)
- go to records (x1)
- go to bookings (week 2,3 and 4) (x1)
- go to welcome page (x1)
- go to finance (x1)
I colour coded the page so it matches the colour of the macros and Uncle Bo will know at once which page he is on. I also added something that will let Uncle Bo know when the class is full using Conditional Formatting.
I then did my finance page and as I had 4 weeks which lessons can be booked, I had to create 4 finance pages. I didn't want to do the bother of creating more macros, I did a finance 'main page' and put all the macros for the finance there, that way I didn't have to do as many macros.
For the finance page, again I only did one page and copied and pasted it 3 times and altered it.
For the Total Classes the tutor is coming, I used the formula 'IF statement'.
I typed in something like this: =IF('Bookings Week 3'!E10>11,1,0) Then I added them all together in the "Total Classes" column.
For the Days Tutor is coming, I also used the 'IF statement' formula and typed in something like this:
=IF(I35<1,0,1)
Finally, I did my records page. For that, I made 4 different pages for each week and I made macros which copied the values from the finance page and pastes it on the records page.
For this unit, I have also used a few links and tutorials to help with my booking system. I had had trouble trying to use conditional formatting as I had forgotten how to use it, fortunately this link helped me 'revive' my memory of how to use it. It was quite useful as it included screen captures, however, I thought it included a little more text than I would have liked.
This is also a very useful site on the formulas on excel. It is very clear and include screen captures. This site has helped me a lot during this project.
