student Student 1 Student 2 Student 3 Student 4 Test1 55 88 0 77 Test 2 77 98 98 Test 3 98 94 88 58 Average 1. Write a main program Main2: • Use the data above-put the data in sheet2. • Main subroutine - Main2 reads the student grades from the spreadsheet above (read and calculate one row at a time). Use activecell.value and activecell.offset(,)select to move across the spreadsheet. • A second subroutine called GAVERAGE that will calculate the average grade. • Call the GAVERGE subroutine in the main program for each student. • You will call the subroutine GAVERAGE 4 times in the Main2 program. • The main program should Output the final grades to the spreadsheet . Program must use Option Explicit and Run with a Run button from the spreadsheet

student Student 1 Student 2 Student 3 Student 4 Test1 55 88 0 77 Test 2 77 98 98 Test 3 98 94 88 58 Average 1. Write a main program Main2: • Use the data above-put the data in sheet2. • Main subroutine - Main2 reads the student grades from the spreadsheet above (read and calculate one row at a time). Use activecell.value and activecell.offset(,)select to move across the spreadsheet. • A second subroutine called GAVERAGE that will calculate the average grade. • Call the GAVERGE subroutine in the main program for each student. • You will call the subroutine GAVERAGE 4 times in the Main2 program. • The main program should Output the final grades to the spreadsheet . Program must use Option Explicit and Run with a Run button from the spreadsheet

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Design and implement a simple interactive Book database for library users. Use the attached library.txt file as the book catalog. In addition to building the base, the program should be able to search a particular book title from the database. If a book is not available, users should receive a meaningful message.
When an author produces an index for his or her book, the first step in this process is to decide which words should go into the index; the second is to produce a list of the pages where each word occurs. Instead of trying to choose words out of our heads, we decided to let the computer produce a list of all the unique words used in the manuscript and their frequency of occurrence. We could then go over the list and choose which words to put into the index. The main object in this problem is a "word" with associated frequency. The tentative definition of "word" here is a string of alphanumeric characters between markers where markers are white space and all punctuation marks; anything non-alphanumeric stops the reading. If we skip all un-allowed characters before getting the string, we should have exactly what we want. Ignoring words of fewer than three letters will remove from consideration such as "a", "is", "to", "do", and "by" that do not belong in an index. In this project, you…
Write a Python program for a movie database management system. The program should allow users to add movies, remove movies, and display the current collection. Each movie has a title, director, release year, and rating. The program should have the following features: 1. A menu-based system that allows users to choose between adding a movie, removing a movie, and displaying the collection. 2. When adding a movie, the user should input the title, director, release year, and rating. 3. When removing a movie, the user should input the title of the movie to be removed. 4. Display the current movie collection with details of each movie, including title, director, release year, and rating. Make sure to include comments that explain the purpose of the program, input and output details, and any complex logic. Use self-documenting variable names, white spaces, and indentation for readability. Test your program with sample data to ensure correct functionality and provide screenshots of two…
rers? Start searching... SPTED Search 1 VitalSource Xx d VitalSource X d VitalSource x * Programmi x O 06 Boyle's LX 6 06 Boyle's x /#/books/9781119321071/cfi/6/354!/4/2@0.00:100 Start over ... 9. In the preceding exercises, you saw how one can use stepwise refinement to solve the problem of translating Wiki markup to HTML. Now turn the pseudocode into code. Complete the convertToHTML and nextSymbol methods in the following class. WikiMarkup.java 1 import java.util.Scanner; 3 public class WwikiMarkup 4 { public static void main(String[] args) { 7. 5 6. Scanner in = new Scanner (System.in); String message = in.nextLine(); System.out.println(convertToHTML (message)); } 8 9 10 11 12 13 /** Converts a message with Wiki markup to HTML. @param message the message with markup @return the message with Wiki notation converted to HTML 14 15 16 17 18 19 20 21 22 23 24 25 public static String convertToHTML (String message) String result = message; return result.replace("\\", ""); /** Finds the…
Octave assignment 1-Introduction to Octave Introduction This assignment is meant to be a gentle introduction to Octave, the free version of Matlab. It assumes that you have no prior coding experience. Objectives Download Octave and run it or use https://octave-online.net/ Learn the basics of the Octave GUI. • Learn how to create a short executable file called an m-file (.m extension) and run it. • Learn what a data type is. • Learn how to declare variables of different data types. • Learn how to create matrices. • Learn how to use several of Octave’s functions for creating objects with random numbers. Instructions 1.) Create a file call it with the form exercise_1_first name_last name. Include the underscores in your file name. At the top of the file add the comment "“My first Octave assignment. I'm so excited, I just can't hide it." 2.) Create the following variables a = 2.3; b = -87.3; A = [1,2; 4,5]; Create a matrix 2 × 2 B using the rand() function. Create two random complex…