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
8th Nov 2022
KRA PIN NUMBERS FOR ALL COMPANIES IN KENYA MOTOR VEHICLES 3843 ASSOCIATED VEHICLE ASSEMBLERS LIMITED P000619379O 3843 B
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
23rd Nov 2022
National Hospital Insurance Fund being a government state corporation provides health insurance to the citizens which includes easy acce
Nhif portal, Nhif registration, Nhif selfcare, Nhif payment, Nhif customer care, Nhif online registration, Nhif selfcare portal, Nhif website, Nhif hospitals Nhif number, Nhif customer care number, Nhif aplication, Nhif online, Nhif payment via Mpesa, Nhif online registration for self-employed, Nhif card, Nhif forms, Nhif toll free number, Nhif comprehensive cover
Comments (0)
Leave a Comment