1. Table Creation for Data Store
a. Create a table in MS Excel as following (Column names contain no space) by copy the bellowed table to a worksheet of a Microsoft Excel file.
a. Set StudentID column to be text.
b. Set studentName to be text.
c. Set score column to be number.
d. Set grade column to be text.
e. Set register_date column to be date
2. Data input
a. Input a new record with this row manually
b. Input date with different format (8/5/14, 08/05/2014, 8-5-2014,8-5-2557), show the result.
c. Delete the row bellowed from the table.
3. Data processing
a. Use Max function to find the highest score.
b. Use MIN function to find the minimum score.
c. Use AVERAGE function to find the average score.
4. Data Output (Making report)
a. Order the list from the most score to the least score for each major.