Research methods, computer science homework help

Application Assignment 5  (Microsoft Excel)

Practicing with Excel

  1. Read Appendix A on pages 354-360
  2. Use the data in figure A.2 and enter them in excel and create an exact table with the column titles. Call table A.2.  Save your work for final submission.
  3. Follow the directions to get from Figure A.2 to Figure A.3 .  Use these steps to create table A.3 similar to figure A.3. Save your work for final submission.
  4. Follow the directions to get from Figure A.3 to Figure A.4 . Use these steps to create table A.4 similar to Figure A.4. Save your work for final submission.
  5. Follow the directions to get from Figure A.4 to Figure A.5.  Use these steps to create table A.5 similar to figure A.5. Sort your data in Table A.5 by the Person Number in ascending order. Make sure your highlight all the table area when you do the soting.  Save your work for final submission.
  6. Use columns M and N  (RtScore  and  PerfScore) and create a scatter chart of the PerfScore vs  RtScore (i.e. a on the x axis the RtScore and on the Y axis the PerfScore. Save the graph In the file and make sure the graph is shown. All tables and the graph should be all in one spread sheet.in one file.  
  7. Write your class #, your last and first name at the beginning of the file. Save your excel file as  class# Last name, first – application Assignment 5 and submit on Moodle.by the due date and time.

Refer textbook here
https://bookshelf.vitalsource.com/#/

"Order a similar paper and get 100% plagiarism free, professional written paper now!"

Order Now