Oftec 122 Integrated Office Applications Assignment Final Ex

Oftec 122 Integrated Office Applicationsassignment Final Exam Part

Review the assignment instructions provided. You are required to create, save, and print various Office documents related to specific projects, following the specified file naming and folder organization guidelines. The assignment includes preparing a cover page with your name, course, and assignment title, and printing documents with designated formatting details. Additionally, you must merge letters using Microsoft Word, export data from Excel, and include filenames and paths in footers. The instructions emphasize that assignment-specific directives override textbook instructions regarding saving and printing.

Paper For Above instruction

In this comprehensive assignment for the OFTEC 122 course, students are tasked with applying their knowledge of Microsoft Office applications—including Word, Excel, Access, and PowerPoint—by completing multiple projects centered around real-world office tasks. The assignment emphasizes organization, proper file management, and professional presentation, reflecting the skills necessary in business and administrative settings.

The first component involves preparing and submitting a series of documents for the Mount Grant Health Clinic. Students are required to create, save, and print reports, databases, spreadsheets, and RTf files, adhering to specific filenames and directory structures. For example, a report titled "PR I-Mount Grant April Report.docx" must be formatted for double-sided printing, with the filename and path included in the footer. The submission process also involves copying printed documents, organizing them into a cover page with personal and assignment details, and submitting via Blackboard.

Following this, students must work on a project involving Otter Bay Estates, creating similar Word, Access, Excel, and PowerPoint files, each with designated filenames. The tasks include exporting contacts data to Word, creating a mail merge letter, and generating ratings data in Excel. The merge process must be completed by merging to a new document and not directly printing from the merge window, with filenames and paths included in document footers. PowerPoint slides should be exported with specified slide arrangements, and access databases should have proper naming conventions.

Additionally, the assignment requires creating a job search database for a client, involving tables, queries, and forms in Access; generating merge letters; and exporting formatted tables to Word. Another project involves preparing a partnership proposal for Natura Beauty Products, utilizing Access tables, Excel spreadsheets, and Word documents. All files should be correctly named and organized in designated folders, with proper printing instructions, including page layouts and footer information as specified.

Throughout the process, students must pay close attention to the detailed formatting instructions, file organization, and submission guidelines provided in the assignment handout. They must also ensure their work demonstrates proficiency in integrating multiple Office applications, attention to detail, and professionalism in document presentation.

References

• Gaskin, J. (2015). MS Office 2016 Bible. John Wiley & Sons.
• Becker, G. (2013). Microsoft Office 365 Inside Out. Microsoft Press.
• Higgins, R. (2017). Mastering Microsoft Office 2016. Pearson Education.
• Walkenbach, J. (2014). Excel 2013 Bible. John Wiley & Sons.
• Kelley, S. (2016). Access 2016 For Dummies. John Wiley & Sons.
• Johnson, J. (2018). PowerPoint 2016 Step by Step. Microsoft Press.
• Schneider, M. (2019). Business Skills for Administrative Assistants. Pearson.
• Rothermel, T. (2020). Office 365 All-in-One For Dummies. John Wiley & Sons.
• Johnson, J. (2019). Microsoft Word 2019 Step by Step. Microsoft Press.
• Friedrichs, S. (2014). Foundations of Business. McGraw-Hill Education.