BTT1O1 – Final Summative
Overview:
· This is your final summative project that will contain parts from a number of the software packages we have used to date.
· This project represents 30% towards your final mark, so ensure that you work efficiently and effectively. All of your work will be done in class within a 8 period block.
· To put this course into a business context, you will assume the position of a new business owner just starting off. The business operation is of your choice.
· This summative project consists of six tasks. Please find the checklist below:
Work Completion Checklist / To Do List / Complete? / Date to finish this part by1. File Management / q / From Start January 7
2. Electronic Communication / q / Monday, January 7
3. Communciting with Spreadhseets / q / Wednesday, January 9
4. Creating a Brochure / q / Monday, January 14
5. Selling it! / q / Wednesday, January 16
6. Database Management System / q / Friday, January 18
The above finish dates are a good guideline. Presentations will start on Monday, January 21nd (beginning of class). You must be ready. No one will be able to work on their presentation
Task 1 – File Management
Create a folder named “Final Exam”. All files for this summative assignment are to be saved to this folder.
File Management Assessment
Criteria / Requirement / MarkApplication / Student is able to successfully:
· Create a Final Exam folder in the correct location
· Save all summative files in the Final Exam folder
· Name all summative files properly
TOTAL / /6
Task 2 – Electronic Communication
Keep in mind that you are the President of your business.For task two, you are to send your teacher an email. To prepare for the email, the following steps must be done.
1. Set up a new email account at www.yahoo.ca under your business name. See Free Sign Up.
2. Create an email signature. Your signature must be in TEXT format and it should consist of: your name in full, your position and the company name.
3. Create a logo of your store at Ms Publisher or MS Word or Photoshop, and save it as “2Logo_BusinessName”.
4. Write a message. In your email tell the teacher the following:
a) Introduction (paragraph 1)
Introduce yourself and your business name.
b) Description (paragraph 2)
Describe what your business does. State the location of your business. Etc…
Explain that you are looking for investors to expand finance your new business (paragraph 3)
c) Attach the logo file at the email.
d) Make sure that your signature is inserted. Be sure to use proper English. No slang and no abbreviations are allowed. Try to write it in a conversational, friendly style. Don’t simply answer the questions
5. Send your prospective new investor an email at with
a. a proper subject title for this email (that starts with BTT YourLastName YourFirstName).
b. the logo that best describes your business attached at the email.
c. your signature
d. proper email etiquette
e. a copy of the email cc to yourself
f. Include a paragraph at the end that explains what BCC is for.
6. Copy and Paste your email into MS Word. Save your email to the “Final Exam” folder and name it as “2email”.
Email Assessment Marking Scheme
Criteria / Requirement / MarkKnowledge / · Email is set up at yahoo.ca and uses proper email etiquette (2)
· Student uses a descriptive and appropriate subject line (1) / /6
Thinking/Inquiry / · Indicates creative thinking in writing and in formatting your email / /4
Communication / · Error free spelling, grammar and punctuation (2)
· Use of proper paragraph structure (1)
· Student signs the email with their creative signature (2) / /5
Application / · Student is able to copy himself or herself on the email (2)
· The logo added as an attachment is creatively designed (8) / /10
TOTAL / /25
[To Do List]
Task 3: Communicating with Spreadsheets
You will be creating a spreadsheet that analyzes sales for your business. Follow the example below but you will have a total of four products. Two bar charts with the same titles have also to be created. You will design your business product offering and come up with 8 original products and prices.
Put your name and the store name on the first row. Save your work as “3spreadsheet” in your final exam folder. Print your work in ONE SIGNLE page.
Formula Hints
· Cost Price = 50% of Sales Price
· Gross Margin = Sales Price -Cost Price
· Projected Sales by item- that is a number you are forecasting. Remember you want to make a decent income!
· Projected Sales 2006 by item = Gross Margin * Projected Sales by item
· Projected Sales in 2007 and 2008, increased from the previous years value by 5%
· Absolute & Relative copying, formulas and functions are clearly and effectively implemented and demonstrated.
Categories / Level 1
(50 - 59%) / Level 2
(60 - 69%) / Level 3
(70 - 79%) / Level 4
(80 - 100%)
Thinking
- Use of processing skills (e.g., creates formulas and functions) / - creates formulas and functions with limited effectiveness / - creates formulas and functions with some effectiveness / - creates formulas and functions with considerable effectiveness / - creates formulas and functions with a high degree of effectiveness
Application
-Transfer of knowledge and skills to new contexts (e.g., accuracy of charts) / - creates accurate charts with limited effectiveness / - creates accurate charts with some effectiveness / - creates accurate charts with considerable effectiveness / - creates accurate charts with a high degree of effectiveness
Communication
- organization of information / –organizes information with limited effectiveness / –organizes information with some effectiveness / –organizes information with considerable effectiveness / –organizes information with a high degree of effectiveness
[To Do List]
Task 4 – Creating a Brochure at Microsoft Publisher or Microsoft Word or PhotoShop
Create and save the following to your summative folder.
You want to educate your employees on the issue of security and privacy. Using one of the wizards at Microsoft Publisher or using MS Word, create a brochure that informs employees of any ONE each of the following topics (or choose another that must be approved by the teacher):
· How to protect against spyware· How to protect your privacy online
· How to protect against viruses
· How to avoid copyright infringement /
Your one-page brochure must:
· Be a single-side three panel brochure
· Have a title and your name on the first page
· Be written in your own words
· Use images, TextArt and other publishing tools
· Provide tips to your staff on the topic chosen
· Consist of the source of Information
Brochure RubricCategories / Level 1
(50 - 59%) / Level 2
(60 - 69%) / Level 3
(70 - 79%) / Level 4
(80 - 100%)
Knowledge
Demonstrate knowledge of the topic chosen / demonstrates limited knowledge of the topic chosen / demonstrates some knowledge of the topic chosen / demonstrates considerable knowledge of the topic chosen / demonstrates thorough knowledge of the topic chosen
Application
Effectively and creatively selects publishing tools that appeals to the appropriate audience / uses polishing tools used with limited effectiveness / uses polishing tools used with some effectiveness / uses polishing tools used with considerable effectiveness / uses polishing tools used with a high degree of effectiveness
Communication
communication of information and ideas (e.g., through writing and visual) / communicates information and ideas with limited clarity / communicates information and ideas with some clarity / communicates information and ideas with considerable clarity / communicates information and ideas with a high degree of clarity, and with confidence
Save your brochure as “4bro” in your final exam folder. Print your brochure.
[To Do List]
Task 5 – Selling it using PowerPoint
Your business had a former employee create a presentation file promoting the business. These slides are not proving to be very effective in selling the product. Your task is to create a new slide show using PowerPoint Presentation advertise your business.
The presentation must be 6 slides long. It should:
§ have your name and the store name and logo on the first slide
§ have text information on each slide
§ have object animations and transitions
§ use images and/or clip art
§ use a consistent slide background
§ be creative
§ follow the rules of “good” presentations - click here
Save your work to the final exam folder as “5slides”.
PowerPoint Rubric-Business Presentation
Category / 50-59%(Level 1) / 60-69%
(Level 2) / 70-79%
(Level 3) / 80-100%
(Level 4)
Application
Font Colour and Size
Transitions/Animations/Audio
Objects (clipart, drawings, bullets, tables, charts) / Limited readability based upon colour, size, and style
Limited enhancement to message
Limited enhancement to message / Some readability based upon colour, size, and style
Some enhancement to message
Some enhancement to message / Considerable readability based upon colour, size, and style
Considerable enhancement to message
Considerable enhancement to message / High degree of readability based upon colour, size, and style
Strong enhancement to message
Strong enhancement to message
Knowledge
Quality of information / Limited quality of information / Moderate quality of information / Considerable quality of information / High quality of information
Thinking & Inquiry
Critical and creative thinking / Uses critical and creative thinking skills with limited effectiveness / Uses critical and creative thinking skills with moderate effectiveness / Uses critical and creative thinking skills with considerable effectiveness / Uses critical and creative thinking skills with high degree of effectiveness
[To Do List]
Task 6: Communicating with Database
You will create a database management system to keep track of your employees and their pay. Save it as “6Employees”. The database file must consist of the following fields and meet the requirement specified:
1. Employee Number (text field – key field)
2. First Name (text field)
3. Last Name (text field)
4. Title
5. Department (text field; drop down menu with 3 choices: Marketing Department, Accounting Department and Sales Department)
6. Date Hired (date field)
7. Address (text field)
8. City (text field; drop down menu with 5 choices: Markham, Richmond Hill, Scarborough, Toronto, and Etobicoke)
9. Province (text field)
10. Postal Code
11. Phone number
Create data file “6Payroll” consisting of the following fields with their corresponding formats:
1. Employee Number (text field)
2. Week Date (date)
3. Hourly Wage (number)
4. Number of Hours Worked (number)
5. Gross Pay (calculation – number: Hourly Wage times Number of Hours Worked)
6. Social Insurance Premium (calculation – number: 2% of Gross Pay)
7. Income Tax (calculation – number: 40% of Gross Pay)
8. Bonus (calculation – number: $100.00 if Number of Hours Worked is greater than 40, $0.00 otherwise)
Relate the file above to the file “6Payroll”.
Create a layout named Check that represents a printout of a payroll check with the print date, employees, full name, full address, and amount of the both in numeric and in long form (word written).
Create enough records in both files to demonstrate that the database system works. (Rubric next page)
[To Do List]
Database RubricCategories / Level 1
(50 - 59%) / Level 2
(60 - 69%) / Level 3
(70 - 79%) / Level 4
(80 - 100%)
Thinking
- Use of processing skills (e.g., creates files as specified, calculation fields) / - creates formulas and functions with limited effectiveness / - creates formulas and functions with some effectiveness / - creates formulas and functions with considerable effectiveness / - creates formulas and functions with a high degree of effectiveness
Application
-Transfer of knowledge and skills to new contexts (e.g., creates files as specified, Srelationships) / - creates accurate charts with limited effectiveness / - creates accurate charts with some effectiveness / - creates accurate charts with considerable effectiveness / - creates accurate charts with a high degree of effectiveness
Communication
- organization of information
(Payroll check layout) / –organizes information with limited effectiveness / –organizes information with some effectiveness / –organizes information with considerable effectiveness / –organizes information with a high degree of effectiveness
[To Do List]
1