Microsoft project

Microsoft project

Final Project Instructions & Rubric Project Overview

The course final project is designed for you to apply the software application skills you acquired during the term. For this project, you will use all four of the Microsoft Office applications to create a unified project on a single topic. The instructions below are not step-by-step instructions–as part of the previous assignments you’ve already learned how to carry out various functions in Word, Excel, PowerPoint, and Access. Instead, the information below details the requirements for the final project. If you need assistance with “how to do something in one of the Office applications” return to your ebook or training materials.

Software Requirements

You must use the following software applications to create the final project: • Microsoft Word 2019

• Microsoft Excel 2019 • Microsoft PowerPoint 2019 • Microsoft Access 2019

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 of these applications available for your use.

Project Topic

You may select any topic that is of interest to you. The course instructor must approve your topic before you begin working on it–be sure to obtain his/her permission sooner rather than later. Remember that your project will cover ONE topic. You will use ALL of the Office applications to create content related to your chosen topic.

Some examples of past project topics include: • develop a business

• highlight attending HCC • your favorite sports team

2019/2020

Page 1 of 6

CGS 1000 Final Project

Dale Mabry Campus

• your favorite sport • dream car • moving out on your own • researching your planned career • planning a vacation • planning a wedding • highlight your native country or culture • your passion in life, etc.

Project Minimum Requirements

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

1. Eachapplicationcomponentisvaluedat65pts.
2. Thereare40points(10ptseachapplication)allocatedforprofessionalism,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 or not 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:

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

o adding additional graphics or pictures, o applying varying color schemes, o creative formatting of the Excel chart, o using various design backgrounds with presentation slides, o creating your own slide background instead of using a design template, o adding a border to the Microsoft Word document component,

o graphically editing pictures and other graphics, o adding external sounds or movie clip in the PowerPoint component, etc.

2019/2020

Page 2 of 6

1. Thisprojectmustbeanoriginalcreation,notacopy‘npastefromthissemester’s assignments. All rules concerning Academic Dishonesty and Plagiarism will be strictly enforced.
2. The project must be based on your original work.

Microsoft Access – (65 points)

___1. Create a database and name the file using your last name_final project ___2. Create a table ___3. Create a minimum of 6 fields in table ___4. Create a minimum of 5 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 4 fields – your choice of fields

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

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

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

Microsoft Excel – (65 points)

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

___2. Create a worksheet with a minimum of six columns and six rows

___3. Create a minimum of 6 column titles, Arial 10 pt, Bold, use a font color other than black

___4. Create a minimum of 6 row titles, Arial 10pt, 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 six cells

2019/2020 Page 3 of 6

___8. Format title with Arial, 14 pt, bold, italics, using a font color other than black ___9. Apply borders to merged cells ___10. Rename the Sheet Tab using your last name ___11. Apply color to Sheet Tab

___12. Create a chart on separate sheet using the data on the main sheet; name the sheet tab Chart

___13. Apply Conditional Formatting to at least five cells ___14. You must include a picture of your face

Microsoft PowerPoint – (65 points)

___1. Create a presentation and name the file using your last name_final project ___2. Use a minimum of 10 slides ___3. Select a design theme or create your own theme ___4. First slide must be title slide layout with your name, course and section number ___5. Add a picture of your face on the title slide

___6. Add a picture style to the picture of your face ___7. One slide must have two levels of bullets ___8. Add a slide title to each slide ___9. Add a footer to the presentation with the date of development or slide number ___10. Add Clip Art or other graphic to a minimum of 3 slides

___11. Add WordArt to at least one slide ___12. Apply slide transition to all slides in the presentation ___13. Use a SmartArt Diagram ___14. Create the background for one slide from a picture ___15. Add entrance effects to at least 1 text and/or 1 piece of Clip Art ___16. Create a table with a minimum of 2 columns and 2 rows ___17. Create a simple column chart ___18. Animate the chart

2019/2020

Page 4 of 6

___19. Use high contrast font color based on the color of the slide background ___20. Last slide must indicate that the presentation is ending

Microsoft Word – (65 points)

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

___2. Set margins to 1 inch top and bottom and 1.25 inch left and right

___3. Set line spacing to 1.5

___4. Create a header with your full name aligned left and the course number & section number aligned right

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

___6. Create a bulleted list, or numbered list, with a minimum of 2 items in list

___7. Add a picture of your face

___8. Apply a picture style to the picture of your face

___9. 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

___10. Add a table to the document a minimum of 2 columns and 2 rows ___11.Format the table by applying a table style ___12. Adjust the column widths of the table to Auto Fit content ___13.Center the table to the page

___14.Document must be no less than 150 words

The post Microsoft project appeared first on best homeworkhelp.

 

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”