{"id":73755,"date":"2022-06-22T03:21:20","date_gmt":"2022-06-22T03:21:20","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/access-powerpoint-excel-word-pro\/"},"modified":"2022-06-22T03:21:20","modified_gmt":"2022-06-22T03:21:20","slug":"access-powerpoint-excel-word-pro","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/access-powerpoint-excel-word-pro\/","title":{"rendered":"Access, powerpoint, excel, word pro"},"content":{"rendered":"
\n

Project Overview<\/h2>\n

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 \u201chow to do something in one of the Office applications\u201d return to your SIMnet MS Office textbook. You can access this via the “Library” link in the top right-hand corner of SIMnet.<\/p>\n

Software Requirements<\/h2>\n

You must use the following software applications to create the final project:<\/p>\n

\u2022 Microsoft Word 2019<\/p>\n

\u2022 Microsoft Excel 2019<\/p>\n

\u2022 Microsoft Access 2019<\/p>\n

\u2022 Microsoft PowerPoint 2019<\/p>\n

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.<\/p>\n

Project Topic<\/h2>\n

Your project topic is your intended major\/career.\u00a0 You should begin developing your project after researching your intended major and career via the Careers in IT<\/em> sections of the textbook and websites linked in Module 13.\u00a0 This is the focus of your final project. You will use ALL the Office applications to create content related to your chosen topic.\u00a0<\/p>\n

Project Minimum Requirements<\/h2>\n

The minimum requirements for each of the four applications are detailed in the checklists below.<\/p>\n

    \n
  1. Each application component is valued at 65pts.<\/li>\n
  2. There are 40 points (10 pts each application) allocated for professionalism, effort, and creativity.<\/li>\n<\/ol>\n
      \n
    • Professionalism is assessed in evaluation of proper use of the required skills (e.g. competent in tables), grammar, spelling, and overall appearance.<\/li>\n
    • Effort is assessed in whether the presentation exceeded the minimum requirements<\/li>\n
    • Students who meet only the minimum requirements for each software application may not receive the 40 points for professionalism, effort, and creativity.<\/li>\n
    • Creativity is demonstrated by applying the software skills acquired during the term.<\/li>\n
    • Creativity is measured in various ways, including:<\/li>\n<\/ul>\n

      o \u00a0applying additional skills covered in the course but not listed as a minimum requirement,<\/p>\n

      o \u00a0adding additional graphics or pictures,<\/p>\n

      o \u00a0applying varying color schemes,<\/p>\n

      o \u00a0creative formatting of the Excel chart,<\/p>\n

      o \u00a0using various design backgrounds with presentation slides,<\/p>\n

      o \u00a0creating your own slide background instead of using a design template,<\/p>\n

      o \u00a0adding a border to the Microsoft Word document component,<\/p>\n

      o \u00a0graphically editing pictures and other graphics,<\/p>\n

      o \u00a0adding external sounds or movie clip in the PowerPoint component, etc.<\/p>\n

        \n
      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.<\/li>\n
      2. The project must be based on your original work.<\/li>\n<\/ol>\n

        Microsoft Access – (65 points)<\/strong><\/h4>\n

        ___1. Create a database and name the file using your last name_final project<\/p>\n

        ___2. Create a table<\/p>\n

        ___3. Create a minimum of 5 fields in table<\/p>\n

        ___4. Create a minimum of 6 records in table<\/p>\n

        ___5. Assign a primary key (note the primary key must be unique for all possible data)<\/p>\n

        ___6. Create a form based on table<\/p>\n

        ___7. Create a query containing 3 fields \u2013 your choice of fields<\/p>\n

        ___8. Create another query containing 4 fields \u2013 sort the query on your choice of field<\/p>\n

        ___9. Create a query with at least 3 fields and restrict the query results with your choice of criteria<\/p>\n

        ___10. Create a report based on table or one of queries<\/p>\n

        Microsoft Excel – (65 points)<\/strong><\/h4>\n

        ___1. Create an Excel workbook and name the file using your last name_final project<\/p>\n

        ___2. Create a worksheet with a minimum of 5 columns (title each) – apply formatting other than Excel’s default.<\/p>\n

        ___3. Add a minimum of 7 rows to the worksheet (title each) – apply formatting other than Excel’s default. and 7 rows<\/p>\n

        ___4. Create formulas in no less than 4 cells, these are separate from the functions in #5 and must be 4 different formulas<\/p>\n

        ___5. Use the MIN, MAX, and AVERAGE functions<\/p>\n

        ___6. Create a title for the worksheet merging and centering the text using a minimum of 5 cells – apply formatting other than Excel’s default.<\/p>\n

        ___7. Rename the Sheet Tab using your last name and apply color to the sheet tab.<\/p>\n

        ___8. Create a chart on separate sheet using the data on the main sheet; name the sheet tab Chart<\/p>\n

        ___9. Add Sparklines to one or more pieces of data<\/p>\n

        ___10. Change the Number Formatting from General to a Number Format of your choosing to one or more rows\/columns of data<\/p>\n

        Microsoft PowerPoint – (65 points)<\/strong><\/h4>\n

        ___1. Create a presentation and name the file using your last name_final project<\/p>\n

        ___2. Use a minimum of 10 slides. Each slide must have a title.<\/p>\n

        ___3. Select a design theme or create your own theme. \u00a0Use high contrast font color based on the color of the slide background.<\/p>\n

        ___4. First slide must be title slide layout with your name, course and section number<\/p>\n

        ___5. Add a picture of your face on the title slide and apply a style to the picture<\/p>\n

        ___6. Use the Notes Pane to add a slide note to at minimum 1 slide<\/p>\n

        ___7. Add a footer to the presentation with the date of development or slide number<\/p>\n

        ___8. Add Online Pictures or other graphics to a minimum of 4 slides<\/p>\n

        ___9. Add WordArt to at least one slide<\/p>\n

        ___10. Apply slide transition to all slides in the presentation<\/p>\n

        ___11. Use a SmartArt Diagram<\/p>\n

        ___12. Add entrance effects to at least 1 text and 1 piece of Clip Art<\/p>\n

        ___13. Create a table with a minimum of 2 columns and 3 rows<\/p>\n

        ___14. Create a simple column chart<\/p>\n

        ___15. Add a title to the chart<\/p>\n

        ___16. Last slide must indicate that the presentation is ending<\/p>\n

        Microsoft Word – (65 points)<\/strong><\/h4>\n

        ___1. Create a document and name the file using your last name_final project<\/p>\n

        ___2. Apply a document theme that is different from the default \u201cOffice\u201d theme<\/p>\n

        ___3. Set margins to 1.25-inch top and bottom and 1.50 inch left and right<\/p>\n

        ___4. Set line spacing to double<\/p>\n

        ___5. Set paragraph spacing to before: 6, after: 6<\/p>\n

        ___6. Create a header with your full name aligned left and the course number & section number aligned right<\/p>\n

        ___7. Create a footer with the page number centered to the page<\/p>\n

        ___8. Create a bulleted list, or numbered list, with a minimum of 2 items in list<\/p>\n

        ___9. Add a picture of your face<\/p>\n

        ___10. Create a title for your document: font of your choice, 14pt or larger, bold, italics, color (change from default of black), set to Small Caps, and centered to the page<\/p>\n

        ___11. Create a subtitle for your document: format it using the Subtitle Style<\/p>\n

        ___12. Document must be no less than 150 words<\/p>\n

        ___13. Insert a comment within the document<\/p>\n

        ___14. Using the Advanced Document Properties, add a Title, Subject, and update the Author to Your Name<\/p>\n

        Sending (uploading) the Project<\/strong><\/h4>\n
          \n
        1. Launch MyHCC\/Canvas<\/li>\n
        2. Navigate to the Final Project Module<\/li>\n
        3. Upload all files to the Final Project Submission link, be sure all 4 files are attached before clicking Submit.<\/li>\n<\/ol>\n

          Grade Point Distribution \u2013 300 Points<\/strong><\/p>\n

          Microsoft Access<\/strong><\/p>\n

          65<\/strong><\/p>\n

          Microsoft Excel<\/strong><\/p>\n

          65<\/strong><\/p>\n

          Microsoft PowerPoint<\/strong><\/p>\n

          65<\/strong><\/p>\n

          Microsoft Word<\/strong><\/p>\n

          65<\/strong><\/p>\n

          Professionalism, effort, and creativity<\/strong><\/p>\n

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

            Creativity is measured in various ways, including:<\/strong><\/p>\n

              \n
            • applying additional skills covered in the course but not listed as a minimum requirement,<\/li>\n
            • adding additional graphics or pictures,<\/li>\n
            • applying varying color schemes,<\/li>\n
            • creative formatting of the Excel chart,<\/li>\n
            • using various design backgrounds with presentation slides,<\/li>\n
            • creating your own slide background instead of using a design template,<\/li>\n
            • adding a border to the Microsoft Word document component,<\/li>\n
            • graphically editing pictures and other graphics,<\/li>\n
            • adding external sounds or movie clip in the PowerPoint component etc.<\/li>\n<\/ul>\n

              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.<\/p>\n

              40<\/strong><\/p>\n

              Total Points<\/strong><\/p>\n

              300<\/strong><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-73755","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/73755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=73755"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/73755\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=73755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=73755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=73755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}