. I’m going to do my final project on the social issue of diversity and inclusion in the tech industry and underrepresentation of certain ethnic groups. One aspect I will delve into is the gender gap and racial/ethnic diversity gap in the tech industry.

• Title Slide (1 slide) – includes your name and the presentation title.
  
• Introduction Slide (1 slide) – should be something catchy and explain why this issue is important.
  
• Body/Content Slides (8-14 slides) – must be interesting, well organized, and presented clearly. Slides should not contain full sentences/paragraphs.
• Summary Slide (1 slide) – may also include a way for others to get involved, help, or get more information.
• Reference Slide (1 slide) – must be in APA style and be a minimum of 3 resources. When including hyperlinks in the reference list, they must be hyperlinked. (Milestone 4)
  

PowerPoint Elements:

Include the following PowerPoint elements:

• Apply a single theme or design template.
• Apply a transition to each slide.
• Do NOT use animation.
• Provide at least one hyperlink to a video or useful online article, this does not include hyperlinks in citation/reference slide.
  
• Use at least 5 open or royalty free images, cite the image on the bottom of the slide where the image exists (Milestone 6)
• Use smart art at least one time.
• Include an original graph, copied and pasted from Excel (do not include it as a picture, be sure to copy and paste from Excel). (Milestone 5)
• Include a footer on each slide with the slide number and your last name.
  

Narration:

To earn full points, your presentation must be narrated. Do NOT read word for word from your slides. Slides should only contain bulleted information, but full sentences should be spoken. The narration audio should start automatically when you start the slideshow and should continue through the entire presentation.

Submission:

Please upload your completed PowerPoint project.

Final Narrated PowerPoint Presentation on Social, Cultural, and Ethical Issues PROJECT (Overview)

IT MUST BE YOUR ORIGINAL WORK AND RELATED TO YOUR CAREER PATHWAY. The final PPT project is comprised in part of milestone work completed.

In this course, you have to complete one big PowerPoint project which is made up of your incremental assignments accomplished along the way in this course. It starts with you identifying a topic based on your career pathway. You research it, cite references, find royalty-free pictures, chart figures (e.g. of pay in your field)  in Excel, etc. Then you will submit a final narrated PowerPoint file at the end for review.

The PowerPoint Project is one of the last items you will submit.  The project is designed to be completed by demonstrating and using your knowledge and skills gained and the assignment built during this course.

Some of the larger requirements of the project have been broken down into milestones. Milestones help you complete some of the tasks ahead of time as well as receive feedback from your instructor before the final project needs to be submitted at the end of this course.  It is important for you to keep track of your submissions and feedback from your instructor.  Each milestone is graded and is worth points, so it is important that you complete each one. And because each part will be used in the final project, it is also important that you read, understand, and update your work using the feedback provided. 

For your Final Project, you will create an ORIGINAL PowerPoint presentation based on a topic from your current field of study. Since this is a fully online course and we do not meet in person in a traditional classroom setting, you will need to narrate this presentation so it can be viewed electronically.

To assist in the completion of your Final Project, some of the required pieces are included in this course as Milestones. These Milestones are completed throughout the course by the student, to help the student better the overall quality of their project. If you miss turning in an assignment just keep it ongoing. See below where the milestones align with the Final Project requirements.

Topic:

Choose a social, cultural, or ethical issue related to your current major or field of study. Choose ONE area to focus on. For example, you can address ethics in healthcare (not HIPPA), public safety, or IT in general. Have focus. You would need to pick a single ethical issue to discuss and not just ethics in general. (Milestone 1 & 2). The topic has to be directly related to your career pathway. No canned or prepared slides (or graphs/ charts) are allowed. Cite all references properly using APA format. Use the resources (including free tutoring services) that are available to you BEFORE submitting final work to be graded.

Research:

Conduct a search using both internet and library database resources. You must use at least three sources, one of which must be from the library database. Keep track of these sources! You will need to include a properly formatted reference slide at the end of your presentation. (Milestone 3)

Narrated / Animated PowerPoint Presentation on a Social, Cultural, and Ethical Issues or challenge impacting your intended career/ pathway

 For your Final Project, you will create a PowerPoint (.ppt only format) presentation based on a topic from your current field of study. Since this is a fully online course and we do not meet in person in a traditional classroom setting, you will need to narrate this presentation so it can be viewed electronically. Keep in mind the ppt must be small enough to upload so you may have to edit/ compress pictures.

To assist in the completion of your Final Project, some of the required pieces are included in this course as Milestones. These Milestones are completed throughout the course by the student and the instructor will provide feedback for each Milestone, in order to help the student better the overall quality of their project.  See below where the milestones align with the Final Project requirements.

NOTE: the project in this course calls for the creation of a PowerPoint with audio. The app version of PowerPoint may not provide the ability to record so it is highly suggested that you download a free version of Office 365 that contains the PowerPoint program.

Topic:

Choose a social, cultural, or ethical issue related to your current major or field of study. Choose ONE area to focus on. For example, you cannot talk about ethics in healthcare, public safety, or IT. You would need to pick a single ethical issue to discuss and not just ethics in general. (Milestone 2 & 3) MAKE IT ORIGINAL AND RELEVANT TO YOUR INTERESTS. No canned / copied presentations are allowed.

Research:

Conduct a search using both internet and library database resources. You must use at least 3 sources, one of which must be from the BC online library database. Keep track of these sources! You will need to include a reference slide at the end of your presentation. (Milestone 4)

Content:

Create a NARRATED PowerPoint presentation that contains between 12 to 18 slides. You must add your voice using the narration feature in PPT. Include the following:

• Title Slide (1 slide) – includes your name and the presentation title. (Milestone 2)
• Introduction Slide (1 slide) – should be something catchy and explain why this issue is important. (Milestone 3)
• Body/Content Slides (8-14 slides) – must be interesting, well organized, and presented clearly. Slides should not contain full sentences/paragraphs.
• Summary Slide (1 slide) – may also include a way for others to get involved, help, or get more information.
• Reference Slide (1 slide) – must be in APA style and be a minimum of 3 resources. When including hyperlinks in the reference list, they must be hyperlinked. (Milestone 4)
  NOTE:
• The D2L system cannot handle emails & attachments more than 20 MB. So, “Zip” the file to reduce the file size.
• Also, if the images are too large even after the file or the zip file, you can take a screen shots of the images (a tool you learned previously in the course) and insert the screen shots into the PPT  document, which would be much smaller in file size. If your file size is still to large to upload; edit down your presentation till it fits.

PowerPoint Elements:

Include the following PowerPoint elements:

• Apply a single theme or design template.
• Apply a transition to each slide.
• Use animations or voice over narration.
• Provide at least one hyperlink to a video or useful online article.
• Use at least 5 open or creative commons/ royalty-free/ rights purchased images (Clipart, photos, illustrations, shapes, etc). (Milestone 6)
• Use smart art at least one time.
• Include an original chart.(Milestone 5)
• Include a footer on each slide with the dynamic date (updatable) and your last name.

Narration:

Your presentation should be narrated. Do NOT read word for word from your slides. Slides should only contain bulleted information, but full sentences should be spoken. The narration audio should start automatically when you start the slideshow and should continue through the entire presentation.

Submission:

Please upload your completed PowerPoint (PPT only) project with a filename formatted as:

PowerPoint_SectionProject_yourfirstname_yourlastname.

This is a chance to be creative while learning about application technology.

HOW TO SUBMIT YOUR PROJECT IN D2L:

Go to Assessments Tab -> Select Assignments -> Select Professional PowerPoint Presentation Assignment Upload your project

1. Content

     a. Your information is interesting and engaging

     b. You are well informed on your topic

2. Organization

     a. Ideas are organized in a logical manner

     b. Focus, do not get off-topic

3. Graphics/Media

     a. Graphics/media improved the presentation and their placement was creative

4. Layout and Design

     a. Slide balance (6×6 text Rule and rules of thirds for photos)

     b. Good colors/contrast

     c. Font size

5. Delivery

     a. Maintain eye contact when presenting in person

     b. Do not read off your slides

     c. Speak loud and clearly

How to record audio in a PPT file.

To record audio in a PPT file. Make sure you have a microphone connected and working properly.

     Open the PowerPoint file you want to add audio to.

     Go to the INSERT tab> select MEDIA drop-down arrow> select  Audio>Record Audio… > Press the Red circle button to start > press the orange square button to stop. If you do not see this function available download the full version for free from the BC website and try again.

PS The final module requires you to reflect and state your learning in this course. Start keeping a learning log now. 

Conduct a short internet job search for the type of position you will be applying for once you have completed your education. Consider your work experience in this search. For example, if you have no experience in field, please search for entry level positions or the type of position someone with your background could reasonably qualify for. Look for three positions that include wage/salary information. Once you have found 3 job ads that include salary information, determine the average starting salary and use this as the basis for your household budget.
Create an Excel spreadsheet of your own design to breakdown your household budget. List monthly expenses and monthly income. You will need to list your expenses for 12 months (so you should have columns for each month).  Remember your expenses are not always the same every month (for instance your electric bill could fluctuate based on how hot it is). Be sure to format the expenses and income as currency using one of the formatting options in Excel. Do NOT use an online template. The designs must be easy and logical to read.  You should start from a blank, clean, Excel document.

Requirements of the assignment

• Title your spreadsheet with a meaningful title, in bold, at least 16 point size, centered above your spreadsheet content and is centered over more than 3 columns. Use “Merge & Center” provided in Excel. The rest of the document should be in 12 point font.  All data that represents money is formatted as currency.
• Write your job title and the city and state you will live in
• Include 3 job titles, locations, and starting salaries from the job search you performed.  Find the average starting salary (using the AVERAGE function) Calculate and label your monthly income by dividing the annual income cell (reference the cell) by 12. Please make sure that your salary realistically and accurately matches your skill set (for instance, you will not start an engineering job making 90,000 a year).
• Include at least 8 expense items such as electricity, telephone, gas, groceries, rent/mortgage, car payment, student loan payments, credit card payments, entertainment allowance, clothing allowance, etc.
• Make all negative numbers appear in red using automatic formatting or conditional formatting provided in Excel. Choosing RED as the choice for the font color is not correct. Apply this formatting to the entire worksheet.  You must have a negative somewhere in your calculations
• For the following items, you MUST use an Excel function. You cannot calculate the values and enter a number. Excel functions include SUM, AVERAGE, MIN, MAX, etc. You must choose the correct Excel function and then use it properly to get full credit.
• Using an Excel function, calculate the average of each type of expense category for the months you have listed. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
• Calculate a subtotal for each expense category, using a function provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
• Calculate a subtotal for each month, then a grand total of all the months, using functions provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
• Calculate your monthly income after expenses. For each month, subtract the monthly expenses from the monthly income.  Use an absolute reference to reference the cell of the monthly income. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
• Include a pie chart to display the breakdown of expenses. Use the expense categories you have listed and the monthly totals you have calculated to create your pie chart.  Put the pie chart on its own worksheet labeled “Chart”.  Please note, the chart values should be from the budget page of the worksheet.  Do not copy the values into the new worksheet.
• Make sure your spreadsheet is clearly organized and well formatted. For example, no values should display as ##### so make sure your columns are of the correct width for the data.
• Check your spelling
• Create a footer displaying the filename.
• Save your completed file with the filename formatted as Excel_Budget_yourfirstname_yourlastname.xls. An Excel document should be uploaded to D2L.