Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Re-create the model below that searches the students table and returns the data on the student, given a student id. Download database file Students.csv

image text in transcribed

Re-create the model below that searches the students table and returns the data on the student, given a student id. Download database file Students.csv and import into your workbook (Figure 4). The model works by having the user enter the ID and Excel returns the details stored in the database table. Figure 5: for example, ID k0962 is entered by the user and Excel returns the related Info data. Use the ID value input as the lookup value for VLOOKUP. The solution should be a single 'master' formula that would work for any attribute i.e., the formula that returns the correct Name in the searcher Info is appropriate for being Auto-Filled down the column to return the rest of the attributes available in the Database. Place the searcher at the top of the worksheet if the database and the Searcher components are in the same worksheet. Key functions to use: VLOOKUP, MATCH; possibly INDEX B D E F 1 ID Name Gender Date of Birth Weighted Average Final Grade Remark 2 k0688 Jake 3 k0222 Gab M 10/12/2008 67.47 C Good M 13/12/2008 DEF 4 k0270 5 k0213 Sarah F Pearl F 14/11/2008 74.35 B Very good 26/06/2008 DEF 6 k0120 7 k0494 Parkes M Felicity F 29/06/2008 60.24 04/08/2008 74.65 11 k0678 8 k0366 Harvey M 9 k0283 Jamie M 10 k0214 David M M 29/10/2008 57.76 20/09/2008 70.88 04/04/2008 80.00 Fred 09/09/2008 64.35 12 40980 Wishmo M 17/08/2008 56 53 CBDBACD Good Very good Pass Very good Excellent Good Pass Figure 3 students table Enter ID to search k0962 Name Gender Info Oscar M 25/09/2008 Date of Birth Weighted Average 65.35 Final Grade Remark C Good

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan

15th edition

978-0133428858, 133428850, 133428702, 978-0133428704

More Books

Students also viewed these Accounting questions