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 5th 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.