Do some Excel Work

SCENARIO Related lecture activity (taken from the lecture slides in week 2) Imagine you and a few of your classmates decide to become entrepreneurs. Together you have $100,000 seed money. Develop a business idea (e.g., in retail or service) – be as precise as possible. Take notes to describe your business model and related business processes. In this project, you will demonstrate your MS Office skills based on this business idea. Note: 1. This is not a group based assignment and every student needs to submit an individual project. 2. If you do not have a business idea from week 2 or if you do not like the idea that emerged in your group you can also develop another idea or submit an alternative project (see below). PREPARATION Part 1 – MS Excel Develop a business plan to illustrate the financial aspects of a new business of your choice. The Excel workbook should include 5 of the following Excel functions - Absolute References - Relative References - Aggregation Functions (e.g., sum or average) - IF Function - LEFT Function - VLOOKUP Function - Chart 2 - PivotTable - PivotChart - Filters subtotals - Note: You need to include sample data to demonstrate your Excel skills. However, the data and Excel functions should be included for a specific purpose that is relevant for decision makers. This relevance is a substantial part of the marking. The following list gives you some ideas about what you could do to demonstrate the functions above. However, alternatives are possible and welcome! - Overview of start-up cost for the new business - Expected income statement based on different developments (e.g., poor, moderate, good) - Break-even analysis Format your spreadsheet appropriately. You may use colours, styles and fonts of your choice to enhance the readability of your workbook. Formatting is a substantial part of the marking. Limitations: Part one is limited to 5 Excel functions and three sheets (including the original data) . Do not submit more than one Excel workbook. Alternative project: A workbook with sample data is provided for students who prefer not to work based on the business idea developed in week 2. You will find the file “Office project_alternative [login to view URL]” in the project folder under “Assessment” at L@G. Students should complete the above requirements of 5 Excel functions and three sheets using this data. It is also possible to extend the data if necessary. Textual explanation (maximum 150 words): Write a text that explains your business idea briefly. In case you select the alternative project, describe a possible related business. The text should also explain the functions used to demonstrate your Excel skills and why the analysis is relevant for decision makers. Format the text appropriately. Format and presentation are part of the marking. Structure as well as English language capability, including vocabulary, grammar and punctuation will be considered for marking Part 2 – MS Access Develop a database using MS Access for a company of your choice. The database should be created to support specific information needs. - The database should not include more than five tables. - Every table should be filled with some example data. - Create three queries that are useful for your business. - Create a report that is useful for your business. 3 This is an exercise to demonstrate Access skills. Include specific Access knowledge such as referential integrity and make sure that your queries are useful and correct. Limitations: Do not submit a database with more than five tables, three queries and one report.