Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.


Math Forum » Discussions » Inactive » nysmathab

Topic: VLOOKUP
Replies: 3   Last Post: Jun 26, 2008 9:45 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
Andrew Janovsky

Posts: 36
Registered: 2/28/05
VLOOKUP
Posted: Jun 25, 2008 1:26 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply
att1.html (8.8 K)

Using Excel to Convert Raw Score to Scale Scores



Please reply to janovsky1@optonline.net



If you have your raw scores for Integrated Algebra in an Excel spreadsheet,
the procedure below can be used to convert the raw scores to scale scores.



After doing the conversion, proofread your data to check for mechanical
errors.



Backup your Excel spreadsheet



Click the link below.



http://emsc32.nysed.gov/osa/regentsexams/6-08/home.html



Click HTML for the Integrated Algebra Conversion Chart.



Select whole table starting with the highest raw score and ending with the
lowest scale score.



Paste into your Excel spreadsheet starting in cell G1. The table should
appear in columns G to N.



Select the data in columns J and K, and paste it below the data in columns G
and H.



Select the data in columns M and N, and paste it below the data in columns G
and H.



Select columns G and H and sort them Ascending using Column G as the Key.



If raw scores start in cell C2, in cell D2 enter the formula



=VLOOKUP(C2,G$1:H$88,2)



Copy this formula into the other cells in column D.



The correct scaled score for each student should appear in column D.



You can use the name box to name column C "raw" and cells G1 to H88 "conv"



Using named ranges, the formula for column D would be:



=VLOOKUP(raw,conv,2)



Andy Janovsky

Yeshiva Ohr Hameir

Peekskill, NY












Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.