- The purpose of the course project
- General program requirements
- General paper requirements
- Variants
- References
The purpose of the course project
During the course project you will learn how to analyze the project task, obtain the skills of programm design using UML and developing the program in the object-oriented programming language C #. Also, during the project, you are studying how to create software documentation in accordance with standards.
Necessary software:
- MS Visual Studio Ultimate Edition 2010 or above;
- MS Word;
- MS Excel.
You can get the maximum 100 points to your score. Each student makes assignment according to teacher assigned variant.
General program requirements
Resulting product must be a Windows Presentation Foundation (WPF) on-premise software developed in C# programming language.
General paper requirements
The paper must consist of the following sections:
- Introduction
- Task statement
- Software Project (you should use knowledge and skills obtained in Unit 3 - 5)
- Software Implementation (usefull whould be knowledge and skills obtained in Unit 8, 9)
- Test results (usefull whould be knowledge and skills obtained in Unit 6)
- Conclusions
- References
- Appendixes (project charter, user and instalation manuals)
The volume of the course paper should be 35-45 sheets.
Variants
Variant 1
The task of developing the program:
The program must reads from the MS Excel information about weather, which are known: month, day, temperature, precipitation. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
Also user can select information according to the condition: count the number and display precipitation in all dates when the temperature was above XX degrees. The value of XX is entered by the user in the program form.
User can save selected and counted data to a MS Word file.
Variant 2
The task of developing the program:
The program must reads from the MS Excel information about students, which are known: surname, name, results of latest session (about 5 courses). The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
Also user can select information according to the condition: count the average rate of each student and sort the list by descending.
User can save counted and sorted data to a MS Word file.
Variant 3
The task of developing the program:
The program must reads from the MS Excel information about client of electricity company, which are known: surname, address and amount that the consumer is accused of. The number of records should be not less than 10. If the amount is negative, then the consumer made a certain advance.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select the information about consumers who have made a advance more than XX. The value of XX is entered by the user in the program form.
User can save selected and counted data to a MS Word file.
Variant 4
The task of developing the program:
The program must reads from the MS Excel information about students, which are known: surname, name, group, average rate. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
Also user can select select information according to the condition: for XX group sort the list by rate descending. The value of XX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 5
The task of developing the program:
The program must reads from the MS Excel information about client of water supply company, which are known: surname, address and amount that the consumer is accused of. The number of records should be not less than 10. If the amount is negative, then the consumer made a certain advance.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select the information about consumers who have made a debt more than XX. The value of XX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 6
The task of developing the program:
The program must reads from the MS Excel information about weather, which are known: month, day, temperature, precipitation. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
Also user can select information according to the condition: count the number and display precipitation for all dates when the temperature was lower XX degrees. The value of XX is entered by the user in the program form.
User can save selected and counted data to a MS Word file.
Variant 7
The task of developing the program:
The program must reads from the MS Excel information about product range of shoes store, which are known: article, name, number, cost of one pair. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
Also user can select information according to the condition: the cost and number of shoes article XX. The value of XX user is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 8
The task of developing the program:
The program must reads from the MS Excel information about trains departure from the station, which are known: train number, destination station, departure time, time on the road, availability of tickets. The number of records should be not less than 10. If the amount is negative, then the consumer made a certain advance.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select the information about availability of train tickets with number XX. The value of XX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 9
The task of developing the program:
The program must reads from the MS Excel information about weather, which are known: month, day, temperature, precipitation. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
Also user can select according to the condition information: count the number and display temperature for all dates when it was raining.
User can save selected and counted data to a MS Word file.
Variant 10
The task of developing the program:
The program must reads from the MS Excel information about real estate, which are known: address, realtor, owner, area. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select the information about estates with area bigger then XX. The value of XX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 11
The task of developing the program:
The program must reads from the MS Excel information about book collection, which are known: the book number, the author's last name, title, year of publication, location (shelving number and shelf number). The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select the information about location of the book by author XX. The value of XX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 12
The task of developing the program:
The program must reads from the MS Excel information about subscriber's phone numbers. Each record has fields: the name of the subscriber, year of installation of the phone, phone number, address. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select phone number by subscriber's name XX. The value of XX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 13
The task of developing the program:
The program must reads from the MS Excel information about patients of the surgical clinic. Each record has fields: last name of the patient, gender, age, place of residence (city), diagnosis. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select a list of patients older than XX years old, diagnosed with U. . The value of XX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 14
The task of developing the program:
The program must reads from the MS Excel information about trains departure from the station, which are known: train number, destination station, departure time, time on the road, availability of tickets. The number of records should be not less than 10. If the amount is negative, then the consumer made a certain advance.
User can review all information from Excel file in program interface. He can add records and edit the available information.
The program should select the information about availability of train tickets to station XXXX. The value of XXXX is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
Variant 15
The task of developing the program:
The program must reads from the MS Excel information about product range of discount store, which are known: article, product name, number, cost of item. The number of records should be not less than 10.
User can review all information from Excel file in program interface. He can add records and edit the available information.
Also user can select information according to the condition: all information about item by article XX. The value of XX user is entered by the user in the program form.
User can save selected and sorted data to a MS Word file.
References
- Schildt, Herbert. C# 4.0: The Complete Reference / Herbert Schildt - McGraw-Hill/Osborne Media, 2010. - 949 pp.
- Troelsen, Andrew. Pro C# 5.0 and the .NET 4.5 Framework/ Andrew Troelsen - 6th edition. Apres, 2012.- 1560 pp.
- C# Guide. https://docs.microsoft.com/en-us/dotnet/csharp/index
- Ian Sommerville Software Engineering, 9th Edition, 2011. https://www.academia.edu/31140292/Ian_Sommerville_Software_Engineering_9th_Edition_2011_1_
