12/26/2019 0 Comments Introduction :: Computer ScienceIntroduction ============ I have been asked to create a solution to computerise a system for Super Sports who sell sports shoes. The system that I will create will follow the specification given to me. I will include some hand drawn sketches of the forms I will create. I hope for the system to be user friendly and easy to navigate throughout. The new system will have to store data, calculate totals and quantities. I will make use of command buttons and macros within excel to navigate and to record data. I will also make se of the following advanced functions. Macro’s Linked to Command Buttons On-Screen Help Filtering Data Use of the IF Function Pivot Tables The VlookUp Function I also need to make a web page that has pictures of all the available shoes with details and descriptions of all for sale. Also on the page I will give all these details plus the company’s contact details. I will include relevant documentation for this solution in the form of a user guide, this guide will aim to train the staff in using the software. Description of Development. I started off with a black spreadsheet form Microsoft Excel. I changed the background colour of the whole sheet. I added a selection of command buttons to the form to navigate through the system; I also added a title to the page. I then renamed the sheet to “Welcome Page†I than added some more sheets as I thought I would need them as I progressed through the application. I then moved onto the second sheet, which I called “Cost†On this form I used the “VlookUp function to link the shoe type with price, this will make sure tat the quality, shoe and price are all correct. I also used some validation on this form, in the type of list validation, this allows the user to select data from this list box only. I added a Command button to this page to navigate back to the welcome screen. I then created a total sheet, all this sheet does is hold the total amount of shoes sold. I then created the sheet called “Shoes†This shoes hold the prices per pair of shoes and the increment for the quality sole. The next sheet I made was the Orders Sheet, this sheet holds all the details of orders placed. It also has a graph which I have made to display the amount of orders placed. The final sheet is called customer Details, I have set this sheet up to store the details of all customers that place orders through super sports. Throughout this project I have used the following advanced features:
0 Comments
12/13/2019 0 Comments The Summer of My 15th BirthdayThis summer was the best summer ever, because it was my 15th birthday. I celebrated on a cruise with 3 of my friends. When I got to the airplane I was very excited. Then I started to watch a movie on the airplane. The movie that I saw was one of my favorites Leap Year.
When we landed to Miami, Florida I was more excited because I always wanted to go to Miami. When we got there my cousin picked us up on the airport. Then we went to the most famous place to have fun with friends called Lincoln Road. There we went to the apple store were my cousin works. Later we ate at a Cuban restaurant very delicious. There I order the most famous plate, which has “congri†rice with pork. Then we were so tired and went to the apartment. The next day we wanted to go to bay side. A very famous place in Miami with lots of stores. Like for example the one that all girls like, Victoria secret. There we ate at a famous restaurant called the Knife also very delicious. We stayed all day there and later went to a boat with music and had a lot of fun. The next day we had breakfast at IHOP. There I ate the best breakfast that is called the pancake combo. That has egg, 2 pancakes, bacon, and hash brown. Later after the breakfast we went to the most famous mall that has all kinds of expensive stores like Dolce and Gabanna, Channel, Louise Vitton, Carolina Herrera, Tiffany and Co., Etc. There I loved it because there it was all my favorites’ stores. From there we started to go to all Miami. The next day we went to the duck boat that goes in the road and then goes into the water. The tour goes to Palm Island and Star Island where the famous people live. The next day was the day to get on the cruise. I was very excited because I knew we were going to have lot of fun. We got in the cruise and first went to do the fun things like rock claiming, the flow rider and ice skating. In the flow rider I fell a lot but that’s part of the experience. When we got to the rock claiming was better because I’m good at it and I did all stages. Then we got to dinner, the next day we went to Haiti there we went to the beach went to a rollercoaster very cool and had a lot of fun. There we ate and the food very delicious. Later we didn’t have too much to do there so we went to the cruise. We stayed there just relaxing and getting some tan. That night we were walking the entire cruise to see it and look for the fun and cool places to go. The next day we were going to Ocho Rios, Jamaica. There we went to a cascade very cool that was slippery and we fell a lot of times but we all laugh we each other and didn’t care. The water was very cold but was a very fun experience. From there we went to a part where there was lots of little stores selling lots of cool thing from there of Jamaica. We went again to the cruise and the next day we went to Grand Caimans Island there we went to the beach and went on a banana boat. That was very funny we rented kayaks and just being in the beach and having some tanning. The next day we went to Cozumel, Mexico and there my father was very happy because his favorite beer is the corona. And there in Mexico were very cheap were at 1 dollar each. There we went to the beach and went snorkeling. We ate Mexican food and it was very spicy but also delicious. That was the last place we went. The next day we stayed all day on the cruise we went ice skating and my friend Bernadette fell, but very funny and I couldn’t stop laughing thank God it didn’t hurt and we all started laughing, that day was very funny she made my day. Bernadette and I every day went to an ice cream machine and at least we ate like 3 ice creams a day that was the best. The next day was the day we had to leave but this vacation was the best. I had a lot of fun and was the best birthday ever I loved it because I did so many things and went to so many cool places. I also had a very good experience in the places that I went, his is a vacation I’ll never forget. |