Homework answers / question archive / Project for Group 3 Instructions: Gather statistical data about any foreign country, like population sex, age, religion, income, industry, or other demographic data of your choice

Project for Group 3 Instructions: Gather statistical data about any foreign country, like population sex, age, religion, income, industry, or other demographic data of your choice

Statistics

Share With

Project for Group 3

Instructions:

Gather statistical data about any foreign country, like population sex, age, religion, income, industry, or other demographic data of your choice. (You may even make up this data if you like including the "country" because it is only to be used as source for this exercise; therefore, DO NOT spend too much time in this task as it is not really critical for this project!).

Then:

1. PowerPoint (A):
   1. Create a PowerPoint presentation with 4 blank slides and save it as PresentationProject.pptx
   2. Slide 1, this is your Title slide. Here you must simply write the name you want to give to your project.
   3. Slide 2, here you are going to create a bulleted list to show "only" three mayor points regarding the country you chose that may be of interest to potential visitors.
2. Excel:
   1. Create an Excel workbook with only two worksheets, name the first Worksheet Summary and the second Chart, then save the workbook as ExcelProject.xlsx
   2. Select Summary worksheet and create a basic table to show the data you are using for your project.
   3. Select Chart worksheet and using data from the table created in worksheet Summary, create a chart (Pie or Columnar) to show a graphical representation of the data you are working with.
3. Word:
   1. Create a blank Word document and save it as WordProject.docx
   2. Here you need to select the table from the Excel Worksheet created to complete step 2-b and Link it into the Word document. (All I need to see in the Word document is the table linked to the Excel workbook, please DO NOT write anything else) (select the table, copy and then Paste Special into the document if you are using version 2007 or 2010 and if you are using versions 2013, 2016, 365 or any of the new ones select 'Link & keep source formatting' option from the Paste Options of the Paste control/Clipboard Group/Home Tab). This way you will see that each time you make any change or update the table in Excel the table in Word also will change/update automatically. Play with this a little, it is neat!
4. PowerPoint (B):
   1. Slide 3, here you need to embed the Excel Chart created to complete step 2-c.(select the chart, copy and then paste it into the slide).
5. Access:
   1. Create a database containing only one table and that table must contain only four Fields. Save this database as DatabaseProject.accdb. The first field must be the Primary Key (you can use AutoNumber, that is the easier and actually the default data type for a Primary Key unless you need to change it manually because your database design requires that). After you build your table, insert data to be able to generate only five records. Keep this database very simple, “BASIC” just to show that you understand the foundations about creating a database.
6. PowerPoint (C):
   1. Slide 4, open the Access table from step 5 and in Datasheet View select and copy the three first records of the database and paste them as a table into slide 4. (NO a screen shot, NO a picture).

By the end of the project you need to have:

• A PowerPoint Presentation with 4 slides.
• An Excel workbook with 2 worksheets.
• A Word document.
• An Access database.

As you already may have noticed, this is a very simple exercise with very basic components. The learning goal of this project is not based in the complexity of the activity, the main goal is to introduce you to a real industry like online team collaboration scenario just like any you might have in the real industry setting.

To complete this project, you MUST use your group’s private Group Discussion Board. This works just like the weekly threaded discussion room with the difference that only members of your team can access it and everything the group will do will remain recorded there.
In order for you to secure a great grade, I need to see the activity and participation of each group member towards the project completion recorded in the group's room. If you like you can post your phone number and email address where you can be contacted in case of need by your team but remember that activities that can not be logged here can not be counted towards your credit.

Project Evolution:

Let’s say one student is going to be in charge of step 1-a to 1-c of the assignment, then he/she has to be in constant contact with the rest of the team about the progress of his/her work and attach the file to one of the posts when it is completed in order to make this file available to be downloaded and reviewed/used by the rest of the team to complete other step/s and the same goes for the rest of activities with the rest of the group.

Finally, once the project is completed before or by its deadline, the team leader should collect and download all the completed required components of the project and upload them to the respective Group’s Project folder by clicking the Group project link in the Group Assignments Module then follow the instructions there to upload the required files in order to allow me to review them and give your team a grade for the project.

PS: The group leader will earn 5 points as extra credit towards the Final Exam. In case he/she achieves 100% on the Exam then the extra credit will be 1 additional point added to the Final Grade for the course!

I am only responsible for part A