10106134Software Projects
Course Information
Description
This is a capstone course for the Administrative Professional and Medical Administrative Specialist programs. This course is based upon knowledge learned in previous courses and uses multiple software applications, including but not limited to Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Access. Apply industry-standard formats to business correspondence including, business letters, reports, and publications. Manage information, apply critical-thinking skills to real-world scenarios, research topics, and compose a variety of integrated business documents, spreadsheets, databases, and presentations. This course will use Microsoft Office 2016 or Office 365.
Total Credits
2
Course Competencies
-
Revise documentsAssessment Strategiesby submitting mailable documents with all revisions appliedby submitting documents in an acceptable formatby submitting documents according to written/oral directionsCriterialearner applies proofreader marks to revise documentslearner formats documentslearner follows directions
-
Maintain Access databaseAssessment Strategiesby submitting an updated database with no errorsby submitting a correctly sorted table in the databaseby submitting a table in the database with correct data type and properties for each fieldby submitting a form in the database with appropriate fieldsby submitting a query in the database with correct records based on criteriaby submitting a report in the database that is grouped and sortedby submitting a report in the database that contains a formulaby submitting a formatted report in the databaseCriterialearner adds records to an existing table in the databaselearner sorts records in tables in the databaselearner creates a new table in the databaselearner labels data type and properties to existing and added fields in the databaselearner creates a form in the databaselearner updates existing data in the databaselearner creates queries to meet requested criterialearner creates reports that include grouping, sorting, formulas, and graphics
-
Use ExcelAssessment Strategiesby submitting a completed purchase order with all required informationby submitting a formatted payroll spreadsheet with correct formulas and IF functionsby submitting mailable chartsby submitting user-friendly expense form with correct formulasby submitting a mailable pivot table and pivot chartCriterialearner completes a purchase orderlearner updates existing spreadsheet by adding data and columns and revising formulaslearner creates payroll spreadsheetlearner creates charts from existing datalearner creates a company expense form
-
Use PowerPointAssessment Strategiesby submitting a PowerPoint presentation that incorporates researchby submitting a PowerPoint presentation that includes an Excel chartby submitting a PowerPoint presentation that includes animationby submitting a PowerPoint presentation that includes hyperlinksby submitting a PowerPoint presentation that includes soundby submitting a PowerPoint presentation that includes transitionsby submitting a PowerPoint presentation that is a self-running kioskCriterialearner creates a PowerPoint presentation based on their own researchlearner creates a PowerPoint presentation that includes an Excel chartlearner creates a PowerPoint presentation that includes animationlearner creates a PowerPoint presentation that includes hyperlinkslearner creates a PowerPoint presentation that includes soundlearner creates a PowerPoint presentation that includes transitionslearner creates a PowerPoint presentation that is a self-running kiosk
-
Use WordAssessment Strategiesby submitting mailable letterheadby submitting mailable reportby submitting mailable mail merge documentby submitting mailable surveyby submitting mailable complaint letterby submitting mailable catalogCriterialearner creates company letterheadlearner keys a reportlearner creates a mail merge documentlearner keys a surveylearner composes a complaint letter
-
Manage workAssessment Strategiesby submitting mailable documentsby submitting documents by deadlineby submitting all assignment documentsCriterialearner proofreads all work for mailabilitylearner plans work to meet deadlineslearner completes all work