CASE+STUDY+2011

=CASE STUDY 2011=

EXCELLENT

Student groups:
Stefan, Thabang and Charlotte. Gregory, Fabian, Kyay, Stanley. Bongi Gorata, Evan and Jaco.

Each group has to create a WIKI.

**EthioGift - An Introduction to the Case Study **

Big Thanks to the Western Academy of Beijing for this initiative.

==== The purpose of this project/activity is to introduce students to the Case Study for May/Nov 2011 by examining an existing e-commerce site using the information in the case study. Students will be introduced to the technical terminology which can then be expanded and built upon. This gives the students a firm and concrete example as a basis for the case study. ====

· Read through the case study and highlighted any terms that you do not understand (there will be lots!)

Population
2010 estimate: 85,237,338  2007 census : 73,918,505  Area : 1,119,683 sq km  Density 79/km2  divided into 9 subcountries

 Average annual income: $110  Population below poverty line ($0.50 per day): 50%  Life expectancy: 41 years (US 76 years)  Literacy rate: 42.7%  Completed primary school: 2.6%

**Medical ** 1 medical doctor per 100,000 people  practice female genital mutilation <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Child mortality: 123 per 1,000 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Births per female: 5.4

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Communication ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Number of cell phones: 410,600 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Number of television stations: 1

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Language ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Official language is Amharic. It is the second most spoken Semitic language after Arabic.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Culture ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">80 different ethnic groups each have their own language <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> It is an old country: culture and traditions date back 3000 years! <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Land of origin for first human beings <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Ethiopia was said to be one of the first places where upright, walking humanoids lived.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Religion and Roles ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">It is arguable that rastafariaism has its roots in ethiopia. As they worship their former emperor Haile Salasie <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Ethopia has an Ethopian Orthodox Church which operates as its own entity <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Christianity: 62.8% <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Islam: 33.9% <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Traditional: 2.6% <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Ethiopians celebrate a Christmas called "Ganna" on January 7th

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Societal roles and cultural norms are very traditional between men and women. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Men are responsible for providing for the family while women are usually homemakers.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Transport ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">When you take taxi, bargain before you get on it! <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Bus --tours > many take it <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Have differculity developing their railways due to their geograhpical location and terrain. But government have plans to upgrade their railroad transportation to help the country develop.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Ports and Habours ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">None. Ethiopia is landlocked and was by agreement with Eritrea using the ports of Asseb and Massawa; since the Eritrean-Ethiopian War, Ethiopia has used the port of Djibouti for nearly all of its imports. Only one river, the Baro is used for transport.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Airports ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">There were an estimated 84 airports in 2005, only 14 of which had paved runways as of 2005. The Addis Ababa airport handles international jet transportation. Before the civil war, the national carrier, Ethiopian Airlines, flew to numerous African, Asian, and European cities, and had sole rights on domestic air traffic. In 2003, about 1.147 million passengers were carried on domestic and international flights.

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Airports - with paved runways <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> total: 14 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> over 3,047 m: 3 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> 2,438 to 3,047 m: 5 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> 1,524 to 2,437 m: 5 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> 914 to 1,523 m: 1 (2003 est.)

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Airports - with unpaved runways <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> total: 68 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> over 3,047 m: 3 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> 2,438 to 3,047 m: 2 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> 1,524 to 2,437 m: 13 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> 914 to 1,523 m: 27 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> under 914 m: 23 (2003 est.)

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Other Facts ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">the ethiopian alphabeat consists of 33 letters each with 7 characters; has its own alphabet and numbers <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> ethiopia uses the julian calender

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> It has savanah grasslands with zebras <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> less that 500 ethiopian wolves left

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Favourite sports: athletics and football <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> there are modern buildings in Addis Ababa

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Visitors are advised to avoid Tigray and Afar regions at present.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Economics ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">GDP per person: $390 <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Currency: Br <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Close economical ties with China. Interested in getting their raw materials <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Trade Parners include the United States, Italy, Saudi Arabia <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> ‚Ä¢Major export items: Coffee, Hides & Skins, Oil Seeds and Pulses, natural gum, live animals, tea etc <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> ‚Ä¢GDP Makeup: <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> -Agriculture 45% <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> -Industry 11% <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> -Services 44%

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Government and politics ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Ethiopia works with a federal country governing system where the prime minister is head of the country and decisions are made by two debating groups in what is called the freedom house.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Historical Sites ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Rock-Hewn Churches, Lalibela <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> The Blue Nile Falls (also called Tissisat) are one of the most spectacular waterfalls in Northern Africa.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Cuisine ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">consists of various vegetable or meat side dishes and entr√©es, usually a wat, or thick stew, served atop injera, a large sourdough flatbread made of teff flour. One does not eat with utensils, but instead uses injera to scoop up the entr√©es and side dishes. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> NO pork or shellfish

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Weather ** · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">tropical, monsoon · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Examined the website ethiogift.com

//<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">We will be working through the following: sometimes in class in group activities and sometimes individually. //

= **<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Stage 1: Making sense of ethioGift.com ** = <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Examine carefully the website ethiogift.com.

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">1.1 Market ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Give a brief overview of ethiogift.com Who owns it? Where is the site located? Who are the customers? What type of products are sold? Are these products perishable or not?

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">1.2 Cultural Significance/Background ** <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">1. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">There are a number of type of categories for gifts. Explain the significance of these categories. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">2. Explain the date system <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">3. Why is the language of the site in English? Is this the main language of Ethiopia? Why <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">4. Prices of the products - do you think these prices are reasonable? <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">5. Currency conversion - why is that there <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">6. Explain/describe the cultural significance of the gifts <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">1. Examine the FAQ: · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">What does FAQ stand for? · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Explain this sentence: "Can I make an order to someone if I know only his/her phone number but not woreda or kebele?" <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">1. Examine the Terms of Service: <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">2. Spot the spelling errors - do these matter? <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">3. Examine the references to the sheep <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">4. Look at the reference to the telephone <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">5. General information - what does this text mean?

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">1.3 Privacy Concerns and Data Storage ** <span style="font-family: Arial,sans-serif; font-size: 11px; line-height: 16px;">Brainstorm the type of data is stored: · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">What personal customer information is stored by the site; what information is required for the delivery. · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Stock control and product information <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Mock up the tables/database structure: give each table a name, and define the type of information stored for each record: name, data type. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Which tables will have relationships (connected)? <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Read the privacy policy: Define the terms - third party, SSL protocol, vis-a-vis <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> What are some of the new services that EthioGift may be able to provide as suggested in the privacy policy.

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">1.4 Social and Ethical Issues - mini assessment ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">In your opinion, examine the 3 most significant issues that the site owners/customers of ethiogift.com need to consider. This response will be assessed using the IB ITGS Paper 2 (d) generic mark scheme. Once you have reviewed that material in the sections above you should spend 30 minutes planning and writing your response.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Step 2: Technical Background ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Making sense of Ethiogift.com web hosting company: []

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">2.1 Market ** <span style="color: green; font-family: Arial,sans-serif; font-size: 9pt; line-height: 12.2pt; margin-bottom: 0cm;">Tasks <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Give a brief overview of ethioLink.com · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Who owns it? · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Where is the business located? · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Who are the customers? · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">What are the services provided? · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">What currency does the company operate in?

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">2.2 Web Hosting Comparisons ** <span style="color: green; font-family: Arial,sans-serif; font-size: 9pt; line-height: 12.2pt; margin-bottom: 0cm;">Tasks <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Compare and contrast the webhosting features: [] with [] · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Domain Disk space (Mb) · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Free Bandwidth (Mb/Month) · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Email accounts Cost per month

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">2.3 Comparison with Case Study - IT systems ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">(Line 16) Current IT systems Carmen’s shop, Foto Creativa, has the following IT resources: · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">two computers, each with a large, high resolution monitor suitable for professional photography and video · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a scanner · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a photo-quality printer · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a “high-end” digital camera and digital video camera · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a laptop suitable for demonstrating and displaying work to customers · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">professional software for photography and video work · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">desktop publishing software · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">web development software · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a small network with a server, including a RAID backup system · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">broadband Internet access · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a spreadsheet for keeping all financial and customer records.

**<span style="color: green; font-family: Arial,sans-serif; font-size: 9pt;">Tasks ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Imagine you are a computer company that will be supplying all the above hardware and software to Carmen. Select a name for your company. You must research each item, price it, find an image and also the configuration/details/specification that is required. You should put these items into a slideshow with the details.

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> You also need to create a spreadsheet (with formulae) to show the pricing of the products you have suggested in your presentation. Remember, if you use currencies other than Euro (remember that Spain uses the Euro), then you need to be able to change the rates (these change daily!) and this will automatically update the spreadsheet. In one column you need to have a link in the spreadsheet for each item. You should put links in the spreadsheet to each item. I have started a spreadsheet here which you could use and build on. Please use formatting tools and add totals etc

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> In class, each team will present and then we will decide which team to go with!

<span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> Discuss which of the above IT systems the authors of the ethiogift.com website may have.

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">2.4 Comparison with Case Study - Web Content Management ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">(Line 39) Web content management <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;"> To run an e-commerce business successfully, Carmen needs a web content management system (Web CMS) to: · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">organize and present information about her products and services through a consistent user interface · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">provide e-marketing · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">interface data from the central database · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">provide secure access to customers to view and upload files · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">provide an e-commerce facility (with a shopping cart service).

<span style="color: green; font-family: Arial,sans-serif; font-size: 9pt; line-height: 12.2pt; margin-bottom: 0cm;">Tasks <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Examine each of the above - to what extent does ethiogift.com's web content management system provide these features/functions?

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">2.5 Comparison with Case Study: E-marketing ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">E-marketing

<span style="color: green; font-family: Arial,sans-serif; font-size: 9pt; line-height: 12.2pt; margin-bottom: 0cm;">Tasks <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Define each of the following and then look for these features in ethiogift.com to see if these are provided. You need to provide evidence, for example an annotated screen shot. Remember, you only have user access. If you can't find the feature, discuss whether the feature be available for the administrator of the site. · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">ad banners · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a blog · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">RSS feeds · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">bulk e-mails · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">site traffic analysis / web-counters · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">multimedia content

**<span style="color: black; font-family: Arial,sans-serif; font-size: 10pt;">2.6 Comparison with Case Study: Technical Requirements ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">However, there are technical requirements that Carmen must meet whether she chooses a free or commercial Web CMS. She will need: · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a domain name · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a hosting account – one of the more popular configurations includes: o <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">MySQL database management system (DBMS) o <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">PHP / other scripting language o <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Linux operating system o <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">Apache web server · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a shopping cart system – purchased or open source · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">a payment merchant account · <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">SSL-encrypted web site pages.

**<span style="color: green; font-family: Arial,sans-serif; font-size: 9pt;">Tasks ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">1. Define each of the above. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">2. Can you find evidence of these features in ethiogift.com? If so, provide evidence, for example an annotated screen shot. Remember, you only have user access. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">3. Discuss whether the feature could be available for the administrator of the site, by looking at the web host features provided by ethioLink.com: [] and [] <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">4. Could Carmen use this service based on her e-marketing and/or technical requirements? If so, how much will this cost her per month in US dollars? <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">5. Now go to to [] <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">6. How does the cost of EthioLink compare with the hosting companies listed here? <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">7. Suggest a web hosting company that may be better for Carmen.

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Challenges **

<span style="color: green; font-family: Arial,sans-serif; font-size: 9pt; line-height: 12.2pt; margin-bottom: 0cm;">Tasks <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-bottom: 0cm;">Look through each of the following challenges that Carmen may face. How may/has ethiogift deal(t) with these challenges? Rank these in order (with justification) from largest to smallest. Remember, if you can propose a solution, this would lesson the challenge. <span style="font-family: 'Times New Roman',serif; font-size: 12pt;">1. <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt;">how customers and potential customers can be informed of new products and offers through the web site or other e-marketing techniques <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">2. different project management techniques to develop the new web site <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">3. how a range of multimedia features can be effectively integrated on the web site <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">4. how products are purchased through the use of an appropriate shopping cart service <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">5. a range of open source and commercial Web CMSs <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">6. methods of payment for goods (and delivery) purchased using the shopping cart, such as PayPal, credit card payments and direct deposit to account <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">7. appropriate privacy and other policies for the web site <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">8. search engine optimization so that the web site appears on the first page of results <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">9. the role of web site traffic analysis <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">10. techniques that can be used to secure a web site <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">11. policies that could lead to a secure web site <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">12. the relationships between the data, the DBMS and applications <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 12.2pt; margin-left: 0cm; text-indent: -18pt;">13. the features offered by a range of web-hosting services

**<span style="color: #e93f4b; font-family: Arial,sans-serif; font-size: 10pt;">Next Steps ** <span style="color: black; font-family: Arial,sans-serif; font-size: 8.5pt; line-height: 115%;">Now that you have completed this activity you need to review all the technical terminology.

<span style="color: black; font-family: arial,helvetica,sans-serif; font-size: 13px; line-height: 19px;">here is a Wiki to help with the current case study questions posed to us, please visit it and use it. <span style="color: black; font-family: arial,helvetica,sans-serif; font-size: 13px; line-height: 19px;"> http://one-billion-and-one-questions.wikispaces.com/ <span style="color: black; font-family: arial,helvetica,sans-serif; font-size: 13px; line-height: 19px;"> One more thing come up with at least one question each for Mr.Veg and then we can combine them and post up the answers on the Wiki afterwards.