Capstone Project Assignment
In the capstone project you will incorporate Word, Excel, Access, and PowerPoint.
The Guidelines listed below describe the features that must be included in your final Capstone Project submission:
I uploaded my topic in the file box.
For the Word document:
1. Utilize a Word document theme other than the default Office theme
2. Change the font and font size to something other than the default at least once within your document
3. Incorporate graphics (at least one) in addition to the text in the form of pictures, clip art, shapes, etc
4. Center and format the document title
5. Adjust margins and line spacing to something other than the default settings
6. Include a bulleted list
7. Include a table with a header and a table style applied to it
8. Include at least two lines of text - (different from the one with bullets) - that incorporate two or more custom tab stops (other than left tabs).
For the Powerpoint presentation:
1. Include at least five slides
2. Apply a theme other than the default Office theme and change it's default colors by selecting a variant of the theme that you selected
3. Insert a Word Art Style
4. Apply a texture like Newsprint to at least one slide.
5. Add at least one picture or Clip Art
6. Add a bulleted list with multiple levels of indentation
7. Insert a SmartArt graphic
8. Incorporate both animations and transitions in your presentation.
9. Incorporate at least one speaker note and in that note identify the theme and the slide numbers on which your WordArt, SmartArt, and texture appear. An example of a speaker note: " Wisp theme applied. WordArt - slide 1, SmartArt - slide 3, texture - slide 4"
For the Access database file:
1. Include two tables - a primary table with a related secondary table that permits a one-to-many relationship. You can construct each table in Access or you may import from Excel if your spreadsheet design includes two related tables
2. Identify the primary key for each table
3. Design at least one form
4. Design at least one report
5. Design and save queries of the following types:
o a) AND query
o b) OR query
o c) Parameter query
o d) Query using a wildcard
o e) Query which displays an aggregate function such as AVERAGE
o f) an ACTION query such as UPDATE or DELETE query
6. Create a Lookup Field in one of your tables
7. Include a validation rule with validation text for one of your fields
8. Establish a one-to-many relationship with referential integrity
For the Excel spreadsheet:
1. Include more than one worksheet.
2. Use both relative and absolute cell references somewhere in your formulas where the cell reference type is appropriate
3. Utilize at least three functions selected from NOW, SUM, MAX, MIN, AVERAGE, COUNT, COUNTIF
4. Utilize an IF function
5. Utilize a custom theme (something that is different from the default Office theme)
6. Utilize conditional formatting
7. Cells must have enough width to display all information
8. Cells ranges must be formatted appropriately for the contents.
9. Construct a chart and locate the chart on a separate chart sheet.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Download:- Capstone-Project-Idea.rar