Computer Science, asked by schandanrpcks899, 8 months ago

Create a table using Spreadsheet containing the following:

Roll Number, Name, Name of five subjects, Marks secured in the given five subjects in

final examination and perform the following:

1. Enter record of 10 students.

2. Find the total marks secured by each student.

3. Using formula find out the percentage secured by each student.

4. Using functions find the average marks of each subject.

5. Represent the percentage of marks secured by each student using bar

diagram/Column diagram.

6. Represent the marks secured in each subject by each student using multiple-bar

diagram/ column diagram.

7. Represent the marks secured in each subject by the student with highest pass

percentage and lowest pass percentage using Line-diagram.

Explain the different steps performed in creating the table and the different steps

performed in creating the charts. Use PRINT SCREENS to display the output.

Structure of the table:

Roll

Number Name of Student

Marks Secured Total

Marks

% of

Marks

S1 S2 S3 S4 S5 Secured

Average Marks of Each Subject

Note: S1, S2, S3, S4 & S5 are name of Subjects. (example). Students can enter name of

any subjects.

There will be separate print screens for the table created, and point no: 5, 6 and 7.

Answers

Answered by MeetDattani

Explanation:

HOPE THIS WOULD HELP YOU

PLEASE MARK ME BRAINLIEST

Attachments:

Answered by surajnegi0600

Answer:

Creating the table:

Open a spreadsheet program such as Microsoft Excel or Google Sheets.

Create a table with the following columns: Roll Number, Name of Student, S1, S2, S3, S4, S5, Total Marks, % of Marks.

Enter the record of 10 students, including their roll number, name, and marks secured in each of the five subjects.

Use the formula "=SUM(S1:S5)" to find the total marks secured by each student in the Total Marks column.

Use the formula "=Total Marks/5" to find the percentage secured by each student in the % of Marks column.

Explanation:

Creating the charts:

5. Select the data for the % of Marks column and the Roll Number column and create a bar or column chart to represent the percentage of marks secured by each student.

Select the data for all the subject columns (S1, S2, S3, S4, and S5) and the Roll Number column and create a multiple-bar or column chart to represent the marks secured in each subject by each student.

Select the data for all the subject columns (S1, S2, S3, S4, and S5) for the student with the highest pass percentage and the student with the lowest pass percentage and create a line chart to represent the marks secured in each subject by these students.