building a basic expert system

Hi, using the following article, I am unable build a basic expert system using Microsoft Excel (2010/2013/2016) to answer 3 questions and then produce or display report.  I reviewed a couple of articles online using Microsoft excel but not having much luck.  I am not sure if excel is appropriate.  The goal is to open a spreadsheet, answer the questions (like an survey), and view the results.  When finished click close or exit the spreadsheet.

Article URL:

Question 1: What is your Major?
Response ID1: Math
Response ID2: Technology
Response ID3: English

Question 2: What is is your Grade level?
Response ID Q1: Freshman
Response ID Q2: Sophomore
Response ID Q3: Junior
Response ID Q3: Senior

NOTE: Question #3 is asked if one of the following responses is selected: Sophomore, Junior, or Senior.  If Freshman is selected then the class report is ran.

Question 3:Have you completed your general education English 1&2, Math 1&2, and Science 1&2 level courses?
Response ID Q1: Yes
Response ID Q2: No

---End of Questions---

Class report is generated

Please share any articles and suggestions.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

We don't have enough information to decide which platform would be better.  Personally, I would never use Excel as my first choice for data collection.  If your users are all on the same LAN, then Access would be a good choice.  If your users are not on your LAN, you may want to use one of the web based survey engines.  You may be able to pay by the survey or by the response or by the month.  I'm sure there will be recommendations if that is what you need.
abbas abdullaCommented:
I recommend you to use Google Forms.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
I agree with Abbas on Google Forms; they are very easy to create and can be structured to have different flows depending on answers. I have used Google forms for collecting menu choices for a meal being attended by a large number of people.

If you have an Enterprise Office 365 subscription, you can also use MS Forms.

Both will store the responses to the Questionnaire in a spreadsheet which is created through the form and can then be downloaded.
cesemjAuthor Commented:
All information was helpful by helping me reevaluate my approach.
cesemjAuthor Commented:
All information was helpful by helping me reevaluate my approach.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Programming

From novice to tech pro — start learning today.