Survey Of Computer Information Systems Final Project Rubric

Survey Of Computer Information Systems Final Project Rubricgr

Complete a comprehensive project involving Microsoft Word, PowerPoint, Excel, and Access, demonstrating mastery of course features. The project includes creating documents, presentations, spreadsheets, and databases, with specific tasks such as formatting, data calculation, report generation, and referencing. Each component requires applying particular features, providing descriptive reflections on the experience, and ensuring proper formatting and file naming conventions.

Paper For Above instruction

The final project for the CIS105 Survey of Computer Information Systems encompasses a multifaceted application of essential Microsoft Office tools—Word, PowerPoint, Excel, and Access—designed to evaluate students' proficiency in creating, formatting, and managing digital documents and databases. This comprehensive assessment not only tests technical skills but also emphasizes presentation, self-reflection, and adherence to professional standards in document preparation.

Microsoft Word (15 points): Students are tasked with creating a professional business portfolio document. This includes developing a title page with centered personal and course information, inserting a footer with their MEID, and adding a table of contents that automatically updates to include three key sections: PowerPoint presentation, Excel spreadsheet, and Access database. Each section requires writing a descriptive paragraph addressing what worked well, challenges faced, and estimated time taken. Additionally, students must incorporate specific formatting elements—such as bold and italics—to demonstrate text styling skills, and apply an Arial 12-point font throughout. The document should be named "Portfolio_YourName.docx".

Microsoft PowerPoint (15 points): Students will craft a presentation for Buena Vista Apartments focusing on the company’s financial outlook. Tasks include selecting the Trek or Aspect theme, adding a title slide with right-aligned title and subtitle, and adjusting placeholders to align appropriately. Several content slides are required: an overview slide, assessment slide, and slides analyzing growth potential, financial options, and future outlook, each with bulleted points. A relevant business image from Clip Art is to be inserted and resized. Each slide must contain specific content outlined in the instructions, and animations must be applied to enhance presentation dynamics. The presentation is to be saved as "Final Exam Presentation.pptx".

Microsoft Excel (20 points): Students will prepare a detailed monthly sales report for Williams Auto Sales, focusing on January car sales data. The process involves importing data from an existing file, calculating total sales, totals paid and financed, and using the IF function to compute commissions on financed cars at 1% of the sale price. Additional calculations include identifying the most expensive vehicle, inserting a personal comment, and computing summary statistics: total number of cars sold, highest and lowest priced cars, and percentage of financed cars using Excel functions. The worksheet must be formatted with currency and percentage formats, include an appropriate image, and display the current date at the bottom. Personal identification information must be inserted in cell A25; the file is to be saved as "exp07_e02_cpt_02_auto_sol.xlsx".

Microsoft Access (20 points): Students act as database managers for a new cooking show, managing recipe data with an Access database. They must generate a report from the Recipes table that groups entries by category, sorts by recipe name and cooking time, and calculates the average servings per category. A filtered report showing only recipes that serve 10 people is required, along with a total recipe count at the end. The report must include a custom logo, center all data and headers except for specific fields, and be titled “Recipe Database”. Additionally, the student’s name and MEID should appear in the top right corner of the report header. The report layout should be visually appealing, with field sizes and placement adjusted for professional presentation. The database file should be saved as "exp07_a04_case_sol.accdb".

Paper For Above instruction

The comprehensive project outlined for the CIS105 course aims to develop and assess students' proficiency across multiple Microsoft Office applications, simulating real-world professional tasks. This integration of Word, PowerPoint, Excel, and Access tools emphasizes not only technical mastery but also critical thinking about data presentation, document design, and information management. Within this project, students are expected to demonstrate their ability to craft well-formatted documents, compelling presentations, accurate data analysis, and informative reports, all while maintaining consistency and professionalism across all deliverables.

Starting with Microsoft Word, the creation of a professional portfolio unites various formatting skills. Students must develop a polished document featuring a title page, footer, and a dynamically updating table of contents. These features exemplify fundamental Word functionalities that enhance document navigation and professionalism. The reflection paragraphs serve as a skills assessment, encouraging students to critically evaluate their workflow, identify challenges, and estimate time investments. Such self-assessment fosters deeper learning and mastery of Word's advanced features like header/footer manipulation, style application, and effective document structuring.

The PowerPoint component shifts focus to visual communication and presentation skills. Students should design a clear, engaging overview of a company's financial outlook, incorporating themes, visual elements like clip art, and animations to enhance engagement. The structured slide content—covering strengths, weaknesses, opportunities, threats, growth potential, and future outlook—mimics real-world business meetings, requiring students to synthesize information into succinct, impactful slides. Proper alignment, formatting, and design choices demonstrate professionalism, while the ability to apply animations showcases an understanding of presentation dynamics. These skills are crucial in corporate communication contexts where clarity and visual appeal determine message effectiveness.

Excel tasks involve data analysis and calculation, essential skills for handling large datasets and deriving insights. Students are provided with car sales data and required to perform calculations involving totals, totals paid and financed, and commissions based on specific conditions using formulas like IF. The task highlights the importance of formula accuracy and cell referencing, while also emphasizing data presentation through currency and percentage formatting. The inclusion of images and date stamping enhances the report’s completeness, preparing students for real-world data reporting roles that demand precision, clarity, and professionalism.

Lastly, the Access project underscores database management proficiency. Students are tasked with generating a report that groups recipes by category, sorts them logically, and calculates averages and totals, demonstrating an understanding of database relationships and reporting. The additional customization—adding logos, adjusting layout, and customizing headers—reflects professional report design skills. Filtering data for specific criteria (recipes with 10 servings) mirrors common industry practices in data reporting and analysis, vital skills for managing large datasets efficiently and presenting findings clearly. Overall, this multi-application project consolidates core digital literacy skills necessary for modern business environments.

In summation, the CIS105 final project is designed to integrate theoretical knowledge with practical application, fostering skills that are directly transferable to business, administrative, and data management roles. By mastering the outlined tasks, students enhance their digital literacy and become more competitive in a technology-driven workplace environment. Ensuring adherence to formatting, attaching reflective insights, and navigating the multiple tools efficiently demonstrates both technical competence and professional communication—key attributes in any information system discipline.

References

  • Gaskins, R. (2020). Mastering Microsoft Office 365. Pearson Education.
  • Harvey, M. (2018). Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables. Wiley.
  • Microsoft Corporation. (2023). Microsoft Word User Guide. Retrieved from https://support.microsoft.com/en-us/word
  • Microsoft Corporation. (2023). Microsoft PowerPoint User Guide. Retrieved from https://support.microsoft.com/en-us/powerpoint
  • Microsoft Corporation. (2023). Microsoft Excel User Guide. Retrieved from https://support.microsoft.com/en-us/excel
  • Microsoft Corporation. (2023). Microsoft Access Fundamentals. Retrieved from https://support.microsoft.com/en-us/access
  • Richins, M. L. (2021). Data-driven decision making in business. Journal of Business Analytics, 3(2), 112–124.
  • Smith, J. (2019). Effective database reporting techniques. Database Management Journal, 15(4), 45–53.
  • Williams, A., & Taylor, B. (2022). Visual communication strategies for professionals. Business Presentation Review, 9(1), 21–29.
  • Johnson, P. (2020). Designing professional documents in Microsoft Word. Tech Publishing.

Related Assignments