Create and develop a complete application using Excel 2016/Excel 2019 that reads information from a database, produces a chart using Excel, and creates a report in Word.
• Write an application overview and documentation in a separate Word document.
• Develop your application using modular programming, error handling and the effective programming techniques discussed throughout the course.
• Develop Custom Userforms
Description: An application for storing student grades. One screen for the application could look like this (it is just an example): Your application should import data from a database, chart some results in Excel and generate a report in Word that displays the chart (for example, class marks of an assignment chosen by the prof). This kind of application should also include averages and standard deviation of grades. Your application should allow user to select a course from the course list and display the details of the students enrolled in this course (first name, last name, student ID) in a separate worksheet. Your application needs to be able to read information from a database that has the same structure as registrar.mdb. Open the database to view the field names of the different tables. The following is an example of the relationship database diagram. 2 / 2 Required Files registrar.mdb Tips: • Import Students - imports the data from database file the user specifies. The software should display a FileOpen Dialog to allow the user to choose the file from any location. • Before you begin your application, you can open the Access table to find the names of each table and field. • Your report must include a histogram of the students’ final grades. • The weighting for the individual assessments is listed below: Grades Breakdown Assessment Weight A1 5% A2 5% A3 5% A4 5% Midterm 30% Final Exam 50% Total 100% The Word Report A typical Word document would report the results of your application in some way. All reports must contain some text explaining what your application did or the results, as well as a chart from Excel. Typical examples would include: • a histogram of student final grades • tables of assignment and lab minimums, maximums, and averages Essentially, the report is the output of your application.
Assignment 5
Assignment 5
University
Wilfrid Laurier University
Course
Windows Application Programming (CP212)
Academic year2022/2023
9th Nov 2022
Visit the TSC online Transfer Portal to file your transfer, check transfer status and see the latest list of transferred teachers Kindly check the st
14th Nov 2022
HOW TO SETUP LIPA NA M-PESA ONLINE API LIPA NA M-PESA PAYMENT INTERGRATION Mpesa is a mobile money payment service by Safaricom based in Kenya. It was re
16th Jan 2023
The 2023 Form one selection exercise for the 2022 KCPE candidates has been completed and the results released. You can check the selections results either
kcpe 2022, 2023 form one selection results, form admission 2023 online downloading,30th Nov 2022
1. How does the Hustler Fund work? a) Provides a digital platform with the best deals on financial products b) Provides digital tools to help cust
21st Nov 2022
Weight Loss after Pregnancy and Child Birth Reclaiming your body after childbirth can be challenging because this is a time when you are trying to learn a
weight loss, post-partum weight, pregnancy, weight loss journey, baby weight, losing weight after childbirth, breastfeeding, healthy diet after pregnancy, home remedies for weight loss
Comments (0)
Leave a Comment