listed below

Software Requirements

You must use the following software applications to create the final project:

Microsoft Word 2021/365 Microsoft Excel 2021/365 Microsoft Access 2021/365 (MS Word 2021/365 Worksheet) Microsoft PowerPoint 2021/365

No other versions of Office may be used. If you’re missing any of the above applications, keep in mind that the computers in the Open Computer Lab (DTEC 462) have all these applications available for your use.

Project Topic

After reading through the Careers in the Business Disciplines websites, you will select a career. This will be the focus of your final project. You will use ALL the Office applications to create content related to your chosen topic.

Project Research Links

Select a career in the business disciplines to use as the topic for your final project. Research Careers in the Business Disciplines to make your selection. Use the following sites:

• Ferguson’s Career Guidance Center
• U.S. Bureau of Labor Statistics
• Careers and Business
• Any other site of interest

Project Minimum Requirements

The minimum requirements for each of the four applications are detailed in the checklists below.

1. Each application component is valued at 65pts.
2. There are 40 points (10 pts each application) allocated for professionalism, effort, and creativity.

• Professionalism is assessed in evaluation of proper use of the required skills (e.g. competent in tables), grammar, spelling, and overall appearance.
• Effort is assessed in whether the presentation exceeded the minimum requirements
• Students who meet only the minimum requirements for each software application may not receive the 40 points for professionalism, effort, and creativity.
• Creativity is demonstrated by applying the software skills acquired during the term.
• Creativity is measured in various ways, including:

oapplying additional skills covered in the course but not listed as a minimum requirement,

oadding additional graphics or pictures,

oapplying varying color schemes,

ocreative formatting of the Excel chart,

ousing various design backgrounds with presentation slides,

ocreating your own slide background instead of using a design template,

oadding a border to the Microsoft Word document component,

ographically editing pictures and other graphics,

oadding external sounds or movie clip in the PowerPoint component, etc.

1. This project must be an original creation, not a copy and paste from this semester’s assignments. All rules concerning Academic Dishonesty and Plagiarism will be strictly enforced.
2. The project must be based on your original work.

Final Project Part 1: Microsoft Word – (65 points)

Video Instructions–

Written Instructions–

___1. Create a document and name the file using your last name_final project_part1 (File > Save As)

___2. Apply a document theme that is different from the default “Office” theme (Design tab)

___3. Set margins to 1.25-inch top and bottom and 1.50 inch left and right (Layout > Margins > Custom)

___4. Set line spacing to double (Home > Paragraph section)

___5. Create a header with your full name aligned left and the course number aligned right (Insert > Header)(Highlight course number, Home > Right Justify)

___6. Create a footer with the page number centered to the page

___7. Create a title for your document: font of your choice, 14pt or larger, bold, italics, color (change from default of black), and centered to the page

___8. Create a subtitle for your document: format it using the Subtitle Style

___9. Create a bulleted list with a minimum of 2 facts relating to your career choice

___10. In a minimum of 150 words, describe your future career and why you are interested in pursuing it

___11. Add a picture of your face

___12. Insert a comment within the document

___13. Using the Advanced Document Properties, add a Title, Subject, and update the Author to Your Name

Final Project Part 2: Microsoft Excel – (65 points)

Video Instructions–Written Instructions–

___1. Create an Excel workbook and name the file using your last name_final project_part2

___2. Create a worksheet with a minimum of 5 columns and 7 rows

___3. Create a minimum of 5 column titles, Times New Roman 12pt, Bold, use a font color other than black

___4. Create a minimum of 7 row titles, Times New Roma 12pt, do not bold

___5. Create formulas in no less than 4 cells, these are separate from the functions in #6 and must be 4 different formulas

___6. Use the MIN, MAX, and AVERAGE functions

___7. Create a title for the worksheet merging and centering the text using a minimum of 5 cells

___8. Format title with font of your choice, 14 pt, bold, italics, using a font color other than black

___9. Rename the Sheet Tab using your last name

___10. Apply color to Sheet Tab

___11. Create a chart using the data on the main sheet

Microsoft Access – (65 points)

Video Instructions–Written Instructions–

You can complete this MS Word document

Actions

or use MS Access to create your database. Note, Mac users must use the Word document.

___1. Create a database and name the file using your last name_final project

___2. Create a table

___3. Create a minimum of 5 fields in table

___4. Create a minimum of 6 records in table

___5. Assign a primary key (note the primary key must be unique for all possible data)

___6. Create a form based on table

___7. Create a query containing 3 fields – your choice of fields

___8. Create another query containing 4 fields – sort the query on your choice of field

___9. Create a query with at least 3 fields and restrict the query results with your choice of criteria

___10. Create a report based on table or one of queries

Microsoft PowerPoint – (65 points)

Video Instructions–Written Instructions–

___1. Create a presentation and name the file using your last name_final project

___2. Use a minimum of 7 slides

___3. Select a design theme or create your own theme

___4. First slide must be title slide layout with your name and course prefix / number (CGS 2100)

___5. Add a picture of your face on the title slide and apply a style to the picture

___6. Add a slide title to each of the remaining slides

Here are some suggestions you may use for slide titles but do not have to:

• Slide 1: My Career
• Slide 2: Qualifications for entering this career
• Slide 3: My plan for achieving these qualifications
• Slide 4: Average Yearly Income
• Slide 5: Career Outlook
• Slide 6: Opportunities for Advancement
• Slide 7: Short Term Steps (The End)

___7. Use the Notes Pane to add a slide note to at minimum 1 slide

___8. Add a footer to the presentation that includes the date and slide numbers

___9. Add Online Pictures or other graphics to a minimum of 4 slides

___10. Add WordArt to at least one slide

___11. Apply at least 2 slide transitions

___12. Use a SmartArt Diagram

___13. Add entrance effects to at least 1 text and 1 picture

___14. Last slide must indicate that the presentation is ending

Submit the Project Components

Video Instructions for submitting all 4 Final Project Parts–