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