Hello buddy,I upload the instructions file for the project.You must use the following software applications to create the final project:• Microsoft Word 2019• Microsoft Excel 2019• Microsoft PowerPoint 2019• Microsoft Access 2019
final_project_instructions_2019_2020.pdf
Unformatted Attachment Preview
CGS 1000 Final Project
Dale Mabry Campus
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. 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 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
CGS 1000 Final Project
Dale Mabry Campus
3. This project must be an original creation, not a copy ‘n paste from this semester’s
assignments. All rules concerning Academic Dishonesty and Plagiarism will be
strictly enforced.
4. 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
CGS 1000 Final Project
Dale Mabry Campus
___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
CGS 1000 Final Project
Dale Mabry Campus
___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
Sending (uploading) the Project
1. Launch MyHCC/Canvas
2. Navigate to the Final Project Module
3. Upload all files to the Final Project Submission link, be sure all 4 files are
attached before clicking Submit.
2019/2020
Page 5 of 6
CGS 1000 Final Project
Dale Mabry Campus
Grade Point Distribution – 300 Points
Microsoft Access
65
Microsoft Excel
65
Microsoft PowerPoint
65
Microsoft Word
65
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 or not the presentation exceeded the
minimum requirements
o 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.
• This project must be an original creation, not a copy ‘n paste from this
semester’s assignments. All rules concerning Academic Dishonesty and
Plagiarism will be strictly enforced.
40
2019/2020
Page 6 of 6
…
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.