1 / 33

The Solution

The Solution. xxxxxxxx. Introduction. In this PowerPoint presentation, I will present to you my solution that I have designed to meet your requirements and needs I have included screenshots of various different parts of the solution showing the features at work

hao
Download Presentation

The Solution

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Solution xxxxxxxx

  2. Introduction In this PowerPoint presentation, I will present to you my solution that I have designed to meet your requirements and needs I have included screenshots of various different parts of the solution showing the features at work I will also give an insight as to how the solution solves your problems and accomplishes a variety of tasks

  3. Solution Features

  4. Initial Overview • The solution has been designed making sure that it is: • Easy to use • User-friendly • Requires no training to use • Secure and restricted access • The solution has also been designed keeping in mind your user requirements and needs: • It can store different types of data • It can make automatic calculations • It can generate various documents

  5. A Closer Look The solution utilises a combination of different software that all share data between them and use this data accordingly The solution incorporates spreadsheet software, database software, and word-processing software The files within the solution are all encrypted with a password that you will set so that only authorised individuals can gain access

  6. SpreadSheet Software Preview the Spreadsheet

  7. Spreadsheet Software • This solution uses Microsoft Excel 2010 as the spreadsheet software • Combines both basic and advanced level features of the software such as: • Formulas • Conditional Formatting • Lookup function • Importing data from other applications • What-if scenarios • This part of the solution will help you to manage and keep track of your group’s finances and fund-raising activities

  8. Spreadsheet Features User Interface with macro-based buttons Formulas have been used to perform automatic calculations Conditional formatting rules have been included to give a visual reference Tools such as ‘Goal Seek’ have been used to model What-if scenarios

  9. Spreadsheet: User Interface User Interface Student Details Finance Expenditure Profit Income Fund Raising Cake Sale Fun Run Car Wash Bag Packing Sponsorship

  10. Spreadsheet: UI continued

  11. Spreadsheet: Formulas

  12. Spreadsheet: Charts and Graphs

  13. Spreadsheet: Conditional Formatting

  14. Spreadsheet: Goal Seek

  15. Database Software Preview the Database

  16. Database Software • The solution uses Microsoft Access 2010 as the database software • Combines different features such as: • Tables • Forms • Reports • Calculated Fields • The database will help you to store any information that is required for you to use. It will store the student details and any other details that you may need.

  17. Database Features Form created to make viewing and entering data more efficient and user-friendly Queries that combine data from multiple tables, and also feature parameters Formulas used to create calculated fields using stored data Reports created using stored and specified data Data imported and exported to and from other applications

  18. Database: User Interface

  19. Database: Form

  20. Database: Queries

  21. Database: Parameter Queries

  22. Database: Formulas

  23. Database: Reports

  24. Database: Import Data

  25. Database: Export Data

  26. Word-processing software Preview the Word Document

  27. Word-processing Software • The solution uses a Microsoft Word 2010 as the word-processing software • It combines a variety of different features such as: • Importing data from other applications • Mail Merge feature • Text formatting • This part of the solution will help you to notify and alert the other group members about the progress they are making and any upcoming fundraising events

  28. Word-processing Features Linking data from other applications for use within a document Mail merge field which automatically update according to the data source specified Headers and footers used to give extra information Emboldening parts of text to draw reader’s attention

  29. Word-processing: Linking Data

  30. Word-processing: Mail Merge

  31. Word-processing: Headers & Footers

  32. Word-processing: Text formatting

  33. Conclusion • I believe the solution has been designed as per your requirements and need • It solves all the problems you currently face • Performs calculations • Stores data • Creates documents based on stored data • Is simple and easy to use • Under 50MB

More Related