Final Project

June 10-17

Summative Assignment

 

NOTE:   You are not allowed to collaborate or share in this assignment – this summative assignment is an individual task that must be completed within the timelines given (you will hand in whatever is completed by the end of June 17th class).  All submitted pages of the assignment must have your names or initials on each printout.  If the same work is handed in by more then one student, both students will receive a 0 on the task.  

 

Create a table as outlined below and keep the table up to date as you work through this assignment.

 

Summative Assessment Tracking Table

Task  Date Completed  Software Used 
Task 1 – Cereal Box Cover           June 11th  Adobe in design                              
Task 2 – Brand Comparison Spreadsheet   June 13th  Excel
Task 3 – Competition Comparison   June 14  Access
Task 4 – Website   June 17th  Dream weaver
Task 5 – Presentation to the Board   June 18th  Power point

 

 

June 18-19

Exam Review

Notebook Link Check

Unit 7 – Microsoft Access Database

May 28-29

Lesson:  Database Terms – Database, Data Record, Data Field

Microsoft Access Terms:  Tables, Forms (Design View, Layout View, Form View), Reports

Other Terms:  Query, Sort

Login at:  http://resources.elearningontario.ca/

To Login use:

Student userid:  AMDSBstudent

Student password:  oerbs

and the click on this link to review database terms

1) Choose the content tab and then click on the “Video Lesson”

2) Answer the following questions (type your answers after each question):

a) What is a database field?  Give an example.

b) What is a database record? Give an example.

c) What are some advantages associated with an electronic database (name at least 3)

d) What are the steps to create a database table?

e) What is a form?  What is it used for?

f) What is a query (or a search)?  What is it used for?

g) What is a sort?  What is it used for?

h) What is a report?  What is it used for?

3) Choose the Assignment Tab and click on the “The Database True False Quiz”.  Try the quiz.

Record your mark on the quiz here: _______ / 10

Assignment: 

Task 1:  Create a simple database for our class, storing information about students in our class.  Field names to be used are: last name, first name, age, address, city, province, postal code, gender, favourite sport, favourite food.

Steps:

1) Design a database entry form

– outline which fields are going to be used in the database (Layout View)

– add titles and other items to make your database entry form attractive

2) Enter your personal information into the database (Form View Mode)

3) Print a copy of your completed data entry form (Print from Layout View)

4) Enter  records from the other members of class (at least 10 records need to be entered)

Task 2:    Database Exercise 2 (page 267) and Database Exercise 9 (page 274)

May 30

Lesson:  Database Features – Reports, Sorts and Queries

Database Reports

A database report presents information found in the database in a formatted, attractive manner.  The information presented may be the database as entered, a database of sorted records,  or only  certain records of the database as found in a search (query).

Reports generally show multiple records per page in table format – with one record being displayed per row of the table.  The columns of the table are the fields of information.  Not all fields need to be displayed in each report.  You may choose which fields to display, the order of the fields and whether a search has taken place.

To create a report:

1) Perform the sort or query as required

2) Create Report

3) Choose the fields to keep in the report – you can decide which fields to delete – this only deletes from the report not from the database

4) In Design View – make the report attractive, add titles – there should be a main title which is the name of the database and a secondary title which is what has been done to the database:

5) Use Print Preview to print the report

eg.

Class Database – sorted by last name

or

Class Database

Sorted by Last name

To Sort

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Advanced Filter Sort   – Enter the sort criteria (the first sort is the primary sort, and subsequent sorts break ties – for example – first sort is last name and break ties with first name)

2) Perform the Sort:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

To Query

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Filter by Form  – Enter the search criteria (for example – last name is Smith)

2) Perform the Query:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

Assignment:

Task 1: For the BTA 3O Class Database create the following reports:

1) All students listed in alphabetical order by last name.

2) All students listed in order by age (oldest to youngest)

3) All students that have a last name that starts with A-J

4) All students that like hockey as their favourite sport

For each report decide which fields to display (do not display all fields in all reports)

Task 2: Exercises 17, 22, 25, 34 of database section

 

May 31

Lesson:  Database Features – Reports, Sorts and Queries

 

Database Reports

A database report presents information found in the database in a formatted, attractive manner.  The information presented may be the database as entered, a database of sorted records,  or only  certain records of the database as found in a search (query).

 

Reports generally show multiple records per page in table format – with one record being displayed per row of the table.  The columns of the table are the fields of information.  Not all fields need to be displayed in each report.  You may choose which fields to display, the order of the fields and whether a search has taken place.

 

To create a report:

1) Perform the sort or query as required

2) Create Report

3) Choose the fields to keep in the report – you can decide which fields to delete – this only deletes from the report not from the database

4) In Design View – make the report attractive, add titles – there should be a main title which is the name of the database and a secondary title which is what has been done to the database:

5) Use Print Preview to print the report

 

eg.

Class Database – sorted by last name

or

Class Database

Sorted by Last name

 

To Sort

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Advanced Filter Sort   – Enter the sort criteria (the first sort is the primary sort, and subsequent sorts break ties – for example – first sort is last name and break ties with first name)

2) Perform the Sort:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

 

To Query

1) Set up the sort Criteria:  Home / Sort and Filter / Advanced / Filter by Form  – Enter the search criteria (for example – last name is Smith)

2) Perform the Query:  Home / Sort and Filter / Advanced / Apply Filter Sort

3) Create a report

 

June 3

Assignment:

Task 1: For the BTA 3O Class Database create the following reports:

1) All students listed in alphabetical order by last name.

2) All students listed in order by age (oldest to youngest)

3) All students that have a last name that starts with A-J

4) All students that like hockey as their favourite sport

 

For each report decide which fields to display (do not display all fields in all reports)

 

Task 2: Exercises 17 (full database report), Exercise 22 update (do not print reports) and Exercise 34 (3 reports) of database section

 

June 4

Database Integration

 

When creating a business presentation it is often necessary to use more than one piece of software to accurately, efficiently and effectively display all information.  Often the use of a word processor is required for the structure of a report, but a database or spreadsheet is used to accurately and efficiently manipulate data.  The integration of software is a useful tool.  To enhance word processing documents it is often necessary include  reports, data or charts from a database or spreadsheet program.

 

Example: Records/Report exported from Database

Doe Tom 15
Jones Sally 18
O’Brien Susie 17
Smith Jane 14
Smith John 17

 

Steps to Export Data and use reports in other applications (Excel or Word):

1. Complete sorts/queries in database program and create a report to display the data

2. Choose Export in the Report Menu (Right click on filename and choose export) and export in format required (Excel or Word)

3. Open the report in required program (Excel or Word) and use as required

 

Assignment:  Create a title page and hand in the following 2 tasks:

Task 1: Exercise 9 on page 393

Task 2:  Create a form letter to everyone in class which outlines information (as outlined below) about our class

– Introduce your letter in paragraph 1

– Paragraph 2 – outline what is being shown in the following charts:

All students in the database sorted by last name in a simple table.

– Paragraph 3 – outline what is being shown in the following table and graph

All student ages displayed in table and a spreadsheet line graph showing the ages graphically

– Provide a conclusion in paragraph 4

– End your letter with an appropriate closing section (ie.  Sincerely,        your name)

– Merge the letter with our class database for names and addresses (print only the first 3 letters of the form letter merge)

 

June 5

Work Period – finish all database assignments and prepare for Thursday’s test

 

June 6

End of Unit:  Database Test

Unit 6: Word processing

Unit 6 – Microsoft Word Wordprocessing

 

May 2-10

Complete the following wordprocessing exercises (from Computer Applications for Business) using MICROSOFT WORD.  If you have difficulty with a concept use Microsoft Word built in program help screens or Google Searches on Microsoft Word concepts.

 

Day 1:  Exercise 2 (page 7), 3, 4, 5, 6, 8, 9, 10, 11, 12, 13

 

Day 2:  Exercises 15, 16, 19, 20, 22, 25, 26, 27, 29

 

Day 3:  Exercises 31, 36, 37, 39. 42. 43, 45, 46, 48, 49

 

Day 4: Exercises 53, 56, 58, 60, 63, 65, 66, 78, 83

 

Day 5:  Exercises 90, 92, 93

 

May 13

Wordprocessing Assignment 1 due

1)  Create a title page for Wordprocessing Assignment 1 (your name, date, name of assignment)

2)  Print the following exercises (put your initials or name on each printed page) and submit them in this order

Exercises:   11, 19, 22, 27, 36, 43, 48, 53, 56, 63, 66, 90, 92, 93

 

 

May 14

No Class – Assembly

 

May 15

Lesson: Advanced MS Word techniques – Templates, Form Letters, Macros

 

1) Templates in MS Word – why reinvent the wheel – many template available from office.com.  You can browse/download templates within Office 365

 

2) Merge Documents (form letters and similar types of documents):  A merge document (form letter) is a document that is generic and allows insertion of specifics from a data file (recipient list) 

 

Assignment: Exercise 70, Exercise 76

 

3) Macros:  Do you have a series of tasks that you perform over and over again?  If so this can be shorted by creating a macro.

 

A macro is a ‘recording’ of a series of commands that you can playback whenever you want by calling upon the macro

 

Example 1 – if I like all my headings in bold, underlined, Arial 16 then I can create a macro to do this

Example 2 – A closing to a block formatted business letter

 

Steps:  View / Macro / Create

Choose a shortcut menu option or shortcut keys (optional)

Record steps

Stop recording

 

Assignment: Exercise 85, record your own letter closing, any other macro you deem efficient, Exercise 89 part I, use your letter closing and other macros in this exercise

 

Final Wordprocessing Assignment:

Part 1 – Exercise 70, 76  

Part 2 – Exercise 85, record your own letter closing, any other macro you deem efficient, Exercise 89 part I, use your letter closing and other macros in this exercise

Part 3 – Pick one command or process in MS Word you did not know about before the exercises (not one discussed in this lesson – maximum 1 person per command).  Make up a short  (approx 2 minutes) MS Powerpoint presentation explaining that command or process.  Use screen captures to enhance your presentation.    Examples of commands/process: decimal formatting, setting margins, creating a table, list outline (numbered lists), footnotes/endnotes, headers/footers, 

 

Print and hand in parts 1 and 2

Presentation for Part 3 – Tuesday, May 21

 

May 16-17

Work Period – Final Wordprocessing Assignment

 

May 21

Final Wordprocessing Assignment due

Presentations for final wordprocessing assignment – save your powerpoint presentation in folder on S: Drive

Unit 5: videos and youtube

Apr 24

Unit 5 – Creating Videos, Uploading to YouTube and Embedding in Webpages

 

Lesson:  Social Media’s Role in Business Part 1 (From Grade 9)

Lesson:  Social Media’s Role in Business Part 2 – YouTube

 

Your Job:  Be a little gutsy and create a Video that

  • establishes a positive presence for you and your business on the internet
  • is a little gutsy so that people remember it
  • Edutains your viewers
  • is embedded in your website to keep people at your website to increase your google ranking
  • reviews or demonstrates your product, tells a story, is social, gives a behind the scene look, other

 

Hardware:

Use your own Device

Use an IPAD

Use Small Wonder Camera

 

Software:

You can use any video creation software that you are familiar with:

 

Windows Moviemaker

Adobe Premier Pro

Other?

 

Resources:

To Download and Install MS Windows Moviemaker

http://windows.microsoft.com/en-CA/windows-live/movie-maker-get-started#t1=overview

 

Windows MS Moviemaker Tutorials:

http://windows.microsoft.com/en-ca/windows-vista/getting-started-with-windows-movie-maker

 

To Download and Install Adobe Premier Pro:

http://www.adobe.com/cfusion/tdrc/index.cfm?product=premiere_pro&loc=en_us

 

Adobe Premier Pro Tutorials:

http://blogs.adobe.com/kevinmonahan/2011/05/20/getting-started-with-adobe-premiere-pro-cs4-cs5-cs5-5/

 

Apr 25

Work Period – Video Project

 

 

Apr 26

Lesson:  Shooting Footage, uploading footage, importing to video editting software, trimming clips, transitions, titles, effects, saving you final video

 

Apr 29

Lesson:  Uploading to Youtube, Embedding into webpage

 

Video Project due end of class Apr 30th

 

Apr 30

Work Period – Video Project

 

May 1

1)  Share your video at this  link.

2)  Embed your video into your webpage and recopy your webpage folder to S: Drive for evaluation

 

 

 

 

 

May 21

Final Wordprocessing Assignment due

Presentations for final wordprocessing assignment – save your powerpoint presentation in folder on S: Drive

E-commerce

sing your knowledge of E-Commerce and your HTML knowledge, create an E-Commerce website for a product of your choice. Follow the steps below and research the following areas as necessary. Good planning will lead to good results!

1. Pick a Product
Pick a product type or line (ie. books, electronics, CD’s, DVD’s, bikes, shoes, clothes, etc.) that you would like to sell online. Remember to keep in mind which products are most likely to be sold in an online retail environment. Research the range of items you wish to sell and the possible sale prices you can foresee for these products. Find and store pictures, prices and other information about your products for use in your website.

Soccer store
Where to Start:
Online Purchases by Canadians: http://www.statcan.gc.ca/pub/88f0006x/2009005/t001-eng.htm
Disadvantages of Online Business:http://www.powerhomebiz.com/vol90/disadvantages.htm

To Hand in Before Step 2
• Post a response outlining which product you wish to sell and the reason why. Only one person per product type is allowed.

2. Decide on Payment Methods: What payment methods are available – how will your customers pay?  Paypal- MasterCard

Paypal is very popular and secure. With your bank or credit card you can set up an account and make easy secure payments. If you do not want Paypal and dont trust it, you can try to do it on your own and send it your credit information through master card.

 How much will an online payment service cost you?

Paypal is $35 a month, and MasterCard will be free as long as I use it enough, only the one paying me will have to pay any fee.

How are you going to report this to your customers?

I will have logos of Paypal and MasterCard on every page, as well as advertising what we accept. Also when you try to make a payment it will be on the purchasing page and you must fill out which one you have. Before purchasing you must confirm on information about which method you have and are using.

Where to Start:
http://www.moneris.com/index.php
http://www.paypal.com/
http://www.braintreepaymentsolutions.com/blog/where-do-credit-card-fees-come-from-cc/
http://www.merchantselect.com/
http://www.websitemarketingplan.com/payments/Credit-Card-Merchant-Account.html
http://www.thestar.com/Business/article/520125

3. Decide on Shipping Methods and Costs:  How will you get your product to your customers – what are your options?
Research how you will ship your products. How much does a parcel containing a paperback book or a CD or your product weigh?

A paperback book weighing 5 ounces will cost 2.41$, 1 pound would b 2.53$ and about 2 pounds would be 2.98$

How much will it cost to ship one item?

https://eshiponline.purolator.com/ShipOnline/Estimates/Estimate.aspx?lang=e

Above $200 – regular shipping, will have a set rate (per item) that will arrive through ordinary mail by way of Purolater in approx 4 buisness days.

British Columbia

Purolator Ground Base Cost $29.10

Declared Value Surcharge $4.50

Fuel Surcharge $3.93

GST/HST $1.88

$39.41

Or you can get premium shipping with extra packaging and will get there faster by the end of the next day, this will have what ever the rate of regular shipping is plus $15 because of packaging, with an option of placing insurance on the item for $10.

Purolator Express Base Cost= $34.55

Declared Value Surcharge= $4.50

Fuel Surcharge= $4.66

GST/HST =$2.19

Packagaing= 15

$60.90

Below $200 – what ever the regular shipping cost is from Purolater to ship. No premium shipping.

Purolator Express( approx $100) Base Cost $34.55

Fuel Surcharge $4.66

GST/HST $1.96

$41.17

Out of Canada – will have either options of under or over $200, but an added $10, plus (depending on distance) extra fees.

Florida

Purolator Express U.S. Base Cost $58.15

Fuel Surcharge $7.85

Company Charge $10

$76.00 

Purolator Ground U.S. Base Cost $21.15

Fuel Surcharge $2.86

Company charge $10

$34.01

What other shipping costs are there?

Duty, will be paid by customers if any apply. Depending on the amount being shipped, weight may be an issue as well as size, but each item must be ordered separately and will be shipped separately. So this will no be an issue, just more boxes and items being shipped to one place if a lot get ordered, they will just pay for each Separately.

How are your going to report this to your customers?

This will be on the same page as the purchasing of the item, right after you choose your method of payment, you must fill out your shipping method.
Where to Start:
http://www.canadapost.ca/
http://www.purolator.ca/

http://www.fedex.com/ca_english/

4. Decide on how you would like to setup your website:  What do you like in a website, what will you include in yours?
Research what you like or dislike in websites and setup a ‘site map’ of pages for your website. Before you design your own eCommerce web site you need to consider each element of the web design.
Where to Start:
A) Find an eCommerce site that sells your proposed product (or a product similar) and review their setup
B) Answer the following questions:
1. What makes a good e-business web site?

One that is very detailed. Has multiple pages that are easy to navigate through, buy anything you want , and find anything you need. An attractive website can keep people on your page as well as make them want to there and look. An updated website, not an old or not kept up website will be very bad and people will get angry.

2. What makes a bad web site

One page, hard to work, not easy to navigate. Old website, not updated in years, no new products or prices.

3. Keeping your answers to question 1 and 2 above in mind, answer the following questions for your website
a) For your eCommerce website, what is/are the:
• goals of the site= to get people to buy my products and notice my business.
level of consistency you require –  main colors will be blue and white. will have a home, products, purchase/shipping page, about Soccerworld
target audience(s) for the site – I want the site to be seen as a high end soccer store, only offering the best of the best of equiupment for professionals to get deals and for youth to know where to always get the best at the best price.
• site navigation methods= A table containing link to all pages at the top of every page
graphics= I will have a logo, and put it on every page. I will also have videos on my home page, advertising products and soccer.
• other considerations?

Write a short report of all your web design decisions. This report sets the design for the site and serves as the guide for the creation of all the pages in the site.

I will have a table of contents at the top of every page so you can easily navigate to everypage throughout the whole site. I will have videos advertising the products. I will have an easy to use and pay “purchasing” section and very affordable and great shipping services. I will have all my products on one page describing each one and than stating all the sizes,colors and brands.

b) Create a ‘site map’ of all of the pages of your site ( using SMART Ideas or Prezi). Decide which page will come up first, what it will link to and the interactivity of all pages at your site.  Site map on google docs

To hand in before proceeding to Step 5:
• Reports from Steps 2, 3 and 4

5. Design your website
Using HTML and Dreamweaver design a website using the decisions you have made in parts 1-4 above. Create a separate directory for your website in your personal workspace.  Once completed, make a copy of your website in the S: Drive.  For BONUS:  Upload your website to a service provider.

6. Test your website
Once you feel you have completed your website, test all links and images. Have someone else try your website and ask them to fill out a review of your website. Make changes (if necessary) to make your website more user friendly and error free.  For help creating a review:  http://www.virtualpet.com/industry/howto/wsreview.htm

To hand in by Due Date of ________________________
• Post the address of your website as directed by your teacher
• Share the user review from part 6 with your teacher.

 

Mar 27-Apr 1

Work Period – Travel Brochure Website

HTML Command Explanations – Character Styles, Lists, Horizontal Rule, Mail link, linking images,  Image Maps, File pointing, adding video, …

 

Apr 3

Introduction to eBusiness and eCommerce worksheet:  click here 

Cut and paste the questions into a new document, and then research using the internet to answer the questions. Be sure to follow the instructions at the top of the questions sheet.

 

Apr 4

eCommerce Website Assignment

 

Apr 5

Lesson:  Payment Methods

Continue with eCommerce Website Assignment

 

Apr 8

Lesson:  Shipping Methods

Continue with eCommerce Website Assignment

 

Apr 9

Lesson:  Creating a Site Map  

Sample:   samplesitemap.pdf a sitemap created using Smart Ideas  (you may also use Prezi although it is harder to print)

To Hand in:  Reports and printouts from  parts 1-4 of  eCommerce Website Assignment

 

Apr 10

Work Period: eCommerce Website Assignment  due at end of class Monday, Apr 15

 

Apr 11

No Class – Literacy Test Day

 

Apr 12

No Class – Ice Storm

 

Apr 15

Work Period: eCommerce Website Assignment  due at end of class Apr 16

 

Apr 16

Work Period: eCommerce Website Assignment  due at end of class today

 

Apr 17

Work Period: eCommerce Website Assignment  due at end of class today

 

Apr 18

1.  You have now completed your website, do one last check that all links and images work (in Chrome and/or Internet Explorer)

2.  Using Microsoft Word create a review form for a peer to use when evaluating your website.  For help creating a review:  http://www.virtualpet.com/industry/howto/wsreview.htm   Print two copies of your review.

3.  Pair up with another student and swap computers.  Complete a review form for the other website.  (Do this twice – pick two partners to swap with)

4.  Reflect on the reviews you have received and make changes you feel necessary.

5.  Upload your website to the BTA handin folder on the S: Drive (* by start of Monday’s class)

 

Apr 22

1.  Final hand in of Ecommerce Website to S: Drive  (Be sure to hand in the forms completed by your reviewers – mark if you made the changes suggested or if you did not make the change outline why)

2.  Complete the HTML Commands Assignment

3.  Study for tomorrow’s test on Ecommerce and HTML

 

Apr 23

Test:  Ecommerce and HTML

To discover more about Dreamweaver click here

 

——————– END OF UNIT ———————————-

Unit Four: Web Pages

Unit 4 – Webpages and Websites

Mar 22

Presentation Wrapup

1)  Hand in peer evaluation form

2)  In an email to your teacher, create three multiple choice questions that are related to your quiz using the template (copy and paste) below:

#)  Question

a) Answer1

b) Answer2

c) Answer3

d) Answer4

Correct Answer:  ______

3)  Presentation quiz will be on Monday

Methods to Create Web Pages (Multiple pages is a website)

1)  Text Based Web Page Creation:  Any program that allows you to type text (including programs like Notepad on Windows Computers) could actually be used to create web pages using a programming language HTML (HyperText Markup Language)

Example of HTML Code
<html>

<head>

<title>

Include a title

</title>

</head>
<body>
<u>About Me</u>
<p>This web page is about me, the sports I like, the food I eat and the things I do
<h1>About Me</h1>
<p>This is some text about me …..
:
:
</body>
</html>

2)  WYSIWYG (What you see is what you get) Web Page Creation:  A web page editing program which provides an editing interface which resembles how the page will be displayed in a web browser.  Many WYSIWYG editors will also allow you to add HTML code.

Popular Web Page Creation Programs

  • dreamweaver
  • coffee cup
  • google sites (online Web 2.0 tool)

These programs allow you to create websites mirrors which you can then upload to a web hosting service so it can be viewed on the internet.  This service may be provided free by your ISP (Internet Service Provider – Hurontel, EastLink etc) or you may have to pay for this service.  There are many web hosts on the intermet such as google sites.

Mar 25

Learning Dreamweaver – A WYSIWYG Editor (not a Web 2.0 tool)

1.      Views of Dreamweaver

  • Design
  • Code
  • Combination

2.     Working with Objects in Preview Mode and viewing code in code mode

Types of Objects:

  • Text Objects (including formatting text)
  • Image Objects
  • Link Objects

Mar 26

3.     Page Properties – background images, page and text colours etc.

4.     Advanced Objects – formatting page setup with tables

5.     Creating a Website of many Webpages

Assignment: file:///H:/travelsite/Index.html

Travel Brochure Website Assignment

Task:
• Create a Travel Brochure Website.
Pick a country that you would like to visit to tell us about.  (only one person per country)

You must include the following:

• As many HTML structures (tags) as you feel necessary.
• Have no less than 3 separate content pages
• Have a navigation structure (links to your homepage, and other pages)
• Include tables
• Include numerous graphics and/or images – one of which you must create yourself
• Include at least one ordered and one unordered list
• Include headings
• Include at least one external link
• Use consistent formatting, colours, and images to create a cohesive website
• Make sure all links work (i.e. that they are not broken)
• Create a sources cited page where you source your information, and acknowledge the original material authors. (This will be a separate page)
• Other additions of your choice – Level 4 submissions will include a number of advanced features such as image maps, horizontal rules, mail links, advanced tables etc.

Your web pages will be saved in a folder called “travelsite” in the BTA 3O directory your H drive. You must call your first page: index.html

Mar 27-Apr 1

Work Period – Travel Brochure Website

HTML Command Explanations – Character Styles, Lists, Horizontal Rule, Mail link, linking images,  Image Maps, File pointing, adding video, …

Apr 3

Introduction to eBusiness and eCommerce worksheet:  click here 

Cut and paste the questions into a new document, and then research using the internet to answer the questions. Be sure to follow the instructions at the top of the questions sheet.

BTA 3O – eBusiness/eCommerce Introductory Questions

Using internet search engines and related websites research e-Business and e-Commerce. Type you answer after each question and print this file for your notes when completed. Include the link where you found the answer immediately after your answer. You can also include images and / or videos in your answers.

1. What is Electronic Commerce (eCommerce)? What is the yearly value of eCommerce in Canada in the most recent data you can find?

2. How does the term eCommerce differ from the term eBusiness?

3. Explain each of the following key terms associated with conducting business online:

a) Business to Consumer (B2C)

b) Business to Business (B2B)

c) Consumer to Consumer (C2C)

d) e-tailer

4. Describe the process (list the steps) required to setup an online business. What are the costs associated with each step?

5. Choose two eCommerce websites (you can choose any website you wish). Answer the following questions about each of the two websites you have chosen:

E-Business 1

a) What is the name of the Business

b) What is the URL (address) of the website

c) What type of Business is it (use terms from question 3 above)

d) Do you find the website of the business effective. Answer this question in detail outlining things you like about the website and things you do not like.

E-Business 2

a) What is the name of the Business

b) What is the URL (address) of the website

c) What type of Business is it (use terms from question 3 above)

d) Do you find the website of the business effective. Answer this question in detail outlining things you like about the website and things you do not like.

6. What are the advantages and disadvantages of the eCommerce format from a consumer’s point of view?

7. What are the financial implications of online purchases. Comment on items such as taxes and duties, exchange rates between currencies, shipping, handling, etc.

8. What are the advantages and disadvantages of the eCommerce format from a business perspective.

9. How has an eBusiness changed conditions of employment for its employees. (Include items such as hours of work, commuting, interpersonal relationships, equipment requirements, home offices etc)

10. What impact has eBusiness had on our economy in the last 10 years. List at least 5 things that have changed as a result of e-Business and outline the impact (whether good or bad) on our economy.

Apr 4

eCommerce Website Assignment

Apr 5

Lesson:  Payment Methods

Continue with eCommerce Website Assignment

Apr 8

Lesson:  Shipping Methods

Continue with eCommerce Website Assignment

Apr 9

Lesson:  Creating a Site Map  

Sample:   samplesitemap.pdf a sitemap created using Smart Ideas  (you may also use Prezi although it is harder to print)

To Hand in:  Reports and printouts from  parts 1-4 of  eCommerce Website Assignment

Unit Three: Digital literacy and Ethics

Unit 3 – Digital Literacy and Ethics Issues

Learning Goals:

  • demonstrate an understanding of the terminology associated with information and communication technology including:
    • workstation termininology
    • network terminiology
    • operating systems and interfaces
    • ergonomics
    • environmental issues and ethics

Feb 28

Digital Literacy Research Assignment

Pick a topic from the linked assignment and reply to the assignment post with the topic you would like to research.    Research your chosen topic and create a presentation that will be given to the class using Microsoft Powerpoint.

Mar 1

Work Period:  Digital Literacy Research Assignment

Mar 5

Spreadsheet Test

 

Mar 6

Work Period:  Digital Literacy Research Assignment

 

Mar 7

Lesson:  Creating Effective Presentations

Work Period:  Digital Literacy Research Assignment

 

Mar 8

Presentation Schedule

 

Mar 16

Task:  Create a Peer Evaluation of Presentations Form:

Prepare a peer evaluation form (using MS Word) to use while viewing classmate presentations.

• Create a chart with 8 columns and 24 rows (1 row for title and one row for each student in class).  At the top of the first column put the heading ‘Name’.  At the top of columns 2-7 put a heading for an item your think that presenters should be aware of when presenting a slideshow.

• Examples might include:  Talking to Audience, Voice, Understanding of Content, etc.

• The last column should be titled ‘Overall’ – which is a sum of the 6 columns you used to evaluate

• Put your name at the top of the page (include Evaluated by Your Name ) and print your evaluation form.

• As the presentations are made, evaluate your peers with a rating system between 1 and 4 for each item.

• Hand in your evaluation form after at the end of presentations

 

Presentation Schedule

 

Mar 17-21

Presentations as outlined in Presentation Schedule