intro to computer and tech project
AHS98
CGSFPinstructions.docxFor this project, you will use all four of the Microsoft Office applications to create a unified project on a single topic.
You must use the following software applications to create the final project:
• Microsoft Word 2016 • Microsoft PowerPoint 2016 • Microsoft Excel 2016 • Microsoft Access 2016
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 |
• an animal or species that interests you |
|
• highlight your educational pursuits |
• Great Wall of China |
|
• your favorite sport or sports team |
• Worst Airplane Disasters |
|
• moving out on your own |
• Big Foot, Sasqwatch, Yeti |
|
• research your planned career |
• The Bermuda Triangle |
|
• plan a vacation, a wedding, or party |
• Aurora Borealis |
|
• highlight your native country or culture |
• A wonder, or a spectacle, a person |
|
• or a place you want to visit |
• An illness, disease, or health condition |
|
• a hobby, your passion in life, etc. |
• the circus, gypsies, a group, a club |
|
• a historic event or a period in history |
• almost anything you can think of |
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:
· applying additional skills covered in the course but not listed as a minimum requirement,
· adding additional graphics or pictures, o applying varying color schemes, o creative formatting of the Excel chart,
· 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,
· graphically editing pictures and other graphics, o adding external sounds or movie clip in the PowerPoint component, etc.
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; minimum 6 fields and 5 data records
___3. Assign a primary key (note the primary key must be unique for all possible data)
___4. Create a form based on table
___5. Create a query containing 4 fields – your choice of fields
___6. Create another query containing 5 fields – sort the query on your choice of field
___7. Create another query with at least 4 fields and restrict the query results with your choice of criteria
___8. Create a report based on table or one of queries
___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
___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; Apply color to Sheet Tab
___11. Create a chart on separate sheet using the data on the main sheet; name the sheet tab Chart; Apply Conditional Formatting to at least five cells ___12. 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; Select a design theme or create your own theme
___3. First slide must be title slide layout with your name, course and section number
___4. Add a picture of your face on the title slide; Add a picture style to the picture
___5. One slide must have two levels of bullets
___6. Add a slide title to each slide; Apply slide transition to all slides
___7. Add a footer to the presentation with the date of development or slide number
___8. Add Clip Art or other graphic to a minimum of 3 slides
___9. Add WordArt to at least one slide
___10. Use a SmartArt Diagram
___11. Create the background for one slide from a picture
___12. Add entrance effects to at least 1 text and/or 1 piece of Clip Art
___13. Create a table with a minimum of 2 columns and 2 rows
___14. Create a simple column chart; Animate the chart
___15. Use high contrast font color based on the color of the slide background ___16. 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” top and bottom and 1.25” left & right; Set line spacing to 1.5
___3. Create a header with your full name aligned left and the course number & section number aligned right; Create a footer with the page number centered to the page
___4. Create a bulleted list, or numbered list, with a minimum of 2 items in list
___5. Add a picture of your face; Apply a picture style to the picture
___6 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
___7. Add a table to the document a minimum of 2 columns and 2 rows
___8. Format table by applying a table style; Adjust column widths to Auto Fit content
___9. Center the table to the page
___10. Document must be no less than 150 words
