Transcript Document
Lakeview School The Solution xxxxxxxx Arham Sahu ICT OCR GCSE Unit B062 The Crypt School Centre ID: 57117 Candidate Number: 8091 Lakeview School 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 2 Lakeview School SOLUTION FEATURES Initial Overview Lakeview School • 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 4 Lakeview School 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 wordprocessing software • The files within the solution are all encrypted with a password that you will set so that only authorised individuals can gain access 5 Lakeview School SPREADSHEET SOFTWARE Preview the Spreadsheet Spreadsheet Software Lakeview School • 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 fundraising activities 7 Lakeview School 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 8 Lakeview School Spreadsheet: User Interface User Interface Student Details Finance Income Expenditure Profit Fund Raising Car Wash Cake Sale Bag Packing Fun Run Sponsorship 9 Lakeview School Spreadsheet: UI continued 10 Lakeview School Spreadsheet: Formulas 11 Lakeview School Spreadsheet: Charts and Graphs 12 Spreadsheet: Conditional Formatting Lakeview School 13 Lakeview School Spreadsheet: Goal Seek 14 Lakeview School DATABASE SOFTWARE Preview the Database Database Software Lakeview School • 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. 16 Lakeview School 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 17 Lakeview School Database: User Interface 18 Lakeview School Database: Form 19 Lakeview School Database: Queries 20 Lakeview School Database: Parameter Queries 21 Lakeview School Database: Formulas 22 Lakeview School Database: Reports 23 Lakeview School Database: Import Data 24 Lakeview School Database: Export Data 25 Lakeview School WORD-PROCESSING SOFTWARE Preview the Word Document Lakeview School 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 27 Lakeview School 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 28 Lakeview School Word-processing: Linking Data 29 Lakeview School Word-processing: Mail Merge 30 Lakeview School Word-processing: Headers & Footers 31 Lakeview School Word-processing: Text formatting 32 Lakeview School • I believe the solution has been designed as per your requirements and need • It solves all the problems you currently face • Performs calculations Conclusion • Stores data • Creates documents based on stored data • Is simple and easy to use • Under 50MB Arham Sahu ICT OCR GCSE Unit B062 The Crypt School Centre ID: 57117 Candidate Number: 8091