In the attached spreadsheet, you are given homework grades of 25 students. Sheet 1 (hw1) stores the first homework grades, Sheet 2 (hw2) is the second homework grades and so on. Use either xlsread() or readmatrix() to import the given data into Matlab. Once you have the data in Matlab; • 1- Create separate arrays for each homework, name them as hw1, hw2, hw3, hw4, hw5 • 2- Create an average grade array named hwAvg. Store the average homework grade in hwAvg using the below weights Homework 1, 2: each 15% Homework 3, 4 : 20% Homework 5: 30% • 3- Create an array named letterGrade to store letter grades, this will be an array of strings. • 4- Preallocate the letterGrade array. Make sure it has the same length as hwAvg array. • 5- Assign letter grades from hwAvg array using the grading policy shown below 100 - 90 : A <90 - 80 : B <80 - 70 : C <70 - 60 : D <60 :F It is recommended that you download the file, see what it looks like, figure the steps out on Matlab software before you start solving on Grader.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
### Assign Letter Grades

In the attached spreadsheet, you are given homework grades of 25 students.

Sheet 1 (`hw1`) stores the first homework grades, Sheet 2 (`hw2`) is the second homework grades, and so on.

Use either `xlsread()` or `readmatrix()` to import the given data into MATLAB. Once you have the data in MATLAB:

1. **Create Separate Arrays:**

   - Create separate arrays for each homework, naming them as `hw1`, `hw2`, `hw3`, `hw4`, `hw5`.

2. **Create Average Grade Array:**

   - Create an average grade array named `hwAvg`. Store the average homework grade in `hwAvg` using the weights below:
     - Homework 1, 2: each 15%
     - Homework 3, 4: 20%
     - Homework 5: 30%

3. **Create Letter Grade Array:**

   - Create an array named `letterGrade` to store letter grades; this will be an array of strings.

4. **Preallocate Letter Grade Array:**

   - Preallocate the `letterGrade` array. Ensure it has the same length as `hwAvg` array.

5. **Assign Letter Grades:**

   - Assign letter grades from `hwAvg` array using the grading policy:
     - 100 - 90: A
     - <90 - 80: B
     - <80 - 70: C
     - <70 - 60: D
     - <60: F

*It is recommended that you download the file, review it, and outline the steps in MATLAB software before starting on Grader.*

### Script

```matlab
% In Grader you can import a referenced .xlsx file as such
% data=xlsread/readmatrix('filename.xlsx','sheet name')
```
Transcribed Image Text:### Assign Letter Grades In the attached spreadsheet, you are given homework grades of 25 students. Sheet 1 (`hw1`) stores the first homework grades, Sheet 2 (`hw2`) is the second homework grades, and so on. Use either `xlsread()` or `readmatrix()` to import the given data into MATLAB. Once you have the data in MATLAB: 1. **Create Separate Arrays:** - Create separate arrays for each homework, naming them as `hw1`, `hw2`, `hw3`, `hw4`, `hw5`. 2. **Create Average Grade Array:** - Create an average grade array named `hwAvg`. Store the average homework grade in `hwAvg` using the weights below: - Homework 1, 2: each 15% - Homework 3, 4: 20% - Homework 5: 30% 3. **Create Letter Grade Array:** - Create an array named `letterGrade` to store letter grades; this will be an array of strings. 4. **Preallocate Letter Grade Array:** - Preallocate the `letterGrade` array. Ensure it has the same length as `hwAvg` array. 5. **Assign Letter Grades:** - Assign letter grades from `hwAvg` array using the grading policy: - 100 - 90: A - <90 - 80: B - <80 - 70: C - <70 - 60: D - <60: F *It is recommended that you download the file, review it, and outline the steps in MATLAB software before starting on Grader.* ### Script ```matlab % In Grader you can import a referenced .xlsx file as such % data=xlsread/readmatrix('filename.xlsx','sheet name') ```
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Arrays
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education