Below you will find the results of end of

i have an assignment on making an excel sheet and frankly I have no clue how to do it. I am an older man taking some classes for myself and thought it would be a challenge. sadly this was a mistake. The assignment is below. I have no clue if I am even reaching out correctly. Thank you

Please read the BACKGROUND/SCENARIO which will provide you with the data you need for the assignment. Then, read YOUR TASK which will describe how to create the PowerPoint. A rubric for evaluation purposes is provided for you at the end of this document.

BACKGROUND/SCENARIO

Below you will find the results of end of year reading testing for the 5^th Grade class designated 5-3 Blue.

Students were given the Gates-MacGinitie Reading Test that measured (1) reading vocabulary and (2) comprehension. Scores are given as Lexile scores.

The Vocabulary Test measured reading vocabulary. Each test word was presented in a brief context intended to suggest part of speech but not to provide clues to meaning. Students were expected to select the word or phrase that meant most nearly the same as the test word. *

The Comprehension Test measured students’ abilities to read and understand different types of prose. All of the passages were taken from published books and periodicals. The content is selected to reflect the type of materials that students are required to read for their schoolwork and choose to read for recreation. Some questions require students to construct an understanding based on a literal understanding of the passage; others require students to make inferences or draw conclusions. The Comprehension tests also measure the ability to determine the meaning of words in an authentic text context. *

The data from the test also yielded a Total Score that combined the Vocabulary and Comprehension scores.

For example, a student could get a Vocabulary Lexile score of 5.8, a Comprehension Lexile score of 6.4, and a Total Lexile score of 6.1.

After the test administration has been completed and scored you have been given the following data:

Class: 5-3 Blue

Test: Gates-MacGinitie, Spring 2015

Name Gender Ethnicity IEP Vocab Comprehension Total Score

Student A M A N 7.1 6.5 7.0

Student B F W N 6.1 8.4 7.2

Student C M A N 4.2 6.5 5.4

Student D F H Y 3.8 7.5 5.7

Student E F H N 6.1 7.7 7.0

Student F M W N 6.1 6.5 6.3

Student G M H Y 2.1 5.1 3.8

Student H M A Y 3.4 5.1 4.3

Student I F W N 4.5 4.8 4.6

Student J F W Y 6.7 3.9 5.7

Student K M W N 5.1 4.7 5.2

Student L F A N 5.1 3.1 4.1

Gender: M = Male F = Female

Ethnicity: A = African American H = Hispanic W = White

IEP: Y = Yes N = No

Gates-MacGinitie Reading Test, Riverside Publishing

YOUR TASK

PART A: SPREADSHEET

Your principal has asked that you create a spreadsheet and a brief PowerPoint presentation, all of which is to be given to a new teacher who will be teaching the class for the first time next year. The contents of the PowerPoint will be discussed below.

Create a spreadsheet that will present all of the data you have been given and is sorted and presented by student name. The columns should be labeled: NAME, GENDER, ETHNICITY, IEP, VOCAB, COMPREHENSION, TOTAL SCORE.

Students should be listed in alphabetical order.

An average score should be computed and entered as the last entry in the VOCAB, COMPREHENSION, TOTAL SCORE columns. Label that line as AVERAGE OF SCORES.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.