application sofTware integration
Question description
this is just the rubric once I find a tutor then I give you the lohin info on the file you suppose to work on. it not allowing me to upload because the it says the file is too large Assignment Instructions •Instructions: You will complete the following 2 Capstones: 1.Capstone Case Three: Integrating Access, PowerPoint, and Publisher 2.Capstone Case Four: Integrating Word, Excel, Access, and PowerPoint Upload the completed assignment files in the Assignment area. •Special Instructions: Use the Supporting Materials below to complete the project. •Grading: Please review the rubrics for particulars. Grading Rubrics Project: 3CC Cooking Show Performance Level Exemplary Proficient Developing Performance Element You consistently applied the relevant skills. (5 points) You sometimes, but not always, applied the relevant skills. (3 points) You rarely or never applied the relevant skills. (0 or 1 point) Add default value property A default value and an input mask are added appropriately Either a default value or an input mask is not added appropriately Neither a default value nor an input mask is added appropriately Create SmartArt graphics Two SmartArt graphics are created and display appropriate information One SmartArt graphic is not created or does not display appropriate information No SmartArt graphics are created Insert a note on a slide The note is inserted on the appropriate slide and does not contain spelling or grammar errors The note is not inserted on the appropriate slide or the note contains spelling or grammar errors The note is not inserted Create and format a postcard The postcard contains appropriate text and objects and is formatted to create a professional appearance Some text is inappropriate, at least one object is missing, or the formatting does not create a professional appearance The postcard is not created Insert merge fields from a filtered data source The merge fields are inserted and the data source is filtered using the correct field Not all merge fields are inserted or the data source is not filtered using the correct field No merge fields are inserted and the data source is not filtered Grading Rubrics Project: 4CC Advertising Letter Performance Level Exemplary Proficient Developing Performance Element You consistently applied the relevant skills. (5 points) You sometimes, but not always, applied the relevant skills. (3 points) You rarely or never applied the relevant skills. (0 or 1 point) Import Excel data into an Access database All data is imported to an Access table and displays appropriately Some data is not imported to the Access table or the data does not display appropriately No data is imported to the Access table Create a report The report is created and all data is grouped and sorted appropriately The report is created but either the data is not grouped or it is not sorted The report is not created Create PivotTable and PivotChart reports All PivotTable and PivotChart reports are created and display appropriately At least one PivotTable or PivotChart report is not created or does not display appropriately No PivotTable or PivotChart reports are created Filter the data source for mail merge (Access table) The table is filtered using the correct field and value The table is filtered but does not use the correct field or does not use the correct value The table is not filtered Insert text and merge fields in a letter and in an envelope Text and merge fields are inserted appropriately At least one item is not inserted appropriately No merge fields are inserted Link a PivotChart report in a slide A PivotChart report is linked in a slide and displays appropriately A PivotChart report is linked in a slide but does not display appropriately A PivotChart report is not linked in a slide Supporting Materials i04cc_HVAC_Savings.xlsx (11 KB) i04cc_HVAC_Customers.xlsx (10 KB) i03cc_Cooks_Data.accdb (440 KB) i04cc_Advertising_Letter.docx (12 KB) i04cc_Maintenance_Presentation.pptx (105 KB) i03cc_Cavazos_Logo.bmp (37 KB) Submission