spreadsheet

Project Description:

n the lab lab 3: using a template and importing data note: to complete this task, you will be required to use the data files for students. see the inside back cover of this book for instructions on downloading the data files for students, or contact your instructor for information about accessing the required files. problem: you work as a teacher at a private school. you teach every subject to the four students in your gifted class except for art, computers, and physical education. to help you in determining a student’s grade for a semester, you ask the art, computers, and physical education instructors to send you grades for your four students, although each data set is in a different format. the art teacher sends you a web page from the school’s web system. the computer teacher, who uses an access database to maintain data, queried the database to create a table for you. the physical education teacher typed all the information in a word table. at the conclusion of the instructions, the grades summary worksheet should appear as shown in figure 7–95. figure 7–95 perform the following tasks: 1. open the template lab 7-3 alistarr academy template from the data files for students. save the template as a workbook using the file name, lab 7-3 alistarr academy complete. make sure excel workbook is selected in the ‘save as type’ list when you save the workbook. 2. select cell b4. import the web page, lab 7-3 art.htm, from the data files for students. select the html table containing the art grades. in the import data dialog box, click the properties button. in the external data range properties dialog box, do not adjust the column width. import the text data to cell b4 of the existing worksheet. delete row 4. 3. select cell b8. import the access database file, lab 7-3 computer, from the data files for students. choose to view the data as a table, and insert the data starting in cell b8 in the existing workbook. accept all of the default settings to import the data. right-click any cell in the table, point to table, and then click convert to range. click the ok button to permanently remove the connection to the query. delete row 8. copy the format from b7:d7 to b8:d11. 4. start microsoft word, and then open the word file, lab 7-3 physical education, from the data files for students. copy all except the first column of data in the table. switch to excel. select cell b18, and then use the paste special command to paste only the text into the grades summary worksheet. close word without saving any changes. copy the range b18:e20. select cell b12, and then use the paste special command to paste and transpose the data. adjust the column widths as necessary to display all of the data. 5. delete the range b18:e20, and then delete row 16. copy the formatting of cells c11:d11 and apply the formatting to the range c12:d15. copy the formula in cell e11 to the range e12:e15. 6. change the document properties as requested by your instructor. change the worksheet header to include your name, course number, and other information as specified by your instructor. 7. print the worksheet, and then save the workbook. 8. submit the task as requested by your instructor. cases and places apply your creative thinking and problem solving skills to design and implement a solution. note: to complete these tasks, you may be required to use the data files for students. see the inside back cover of this book for instructions on downloading the data files for students, or contact your instructor for information about accessing the required files. 1: create a cover sheet academic you are competing to design a cover sheet for your school’s department to include in their workbooks when they send out school statistics. open your web browser and view the web page for a department at your school. create a workbook and turn off the viewing of gridlines for the first sheet. insert a screen shot of the department web page and size it appropriately. insert a smartart bulleted list to highlight three or four of the best qualities of your department. below the bulleted list, add a screen clipping of the school’s logo. finally, next to the logo add your name and format it so that it appears as a title. below your name, in a smaller font, insert the course name. 2: create a smartart graphic with photos personal you decide to create a workbook with pictures to chronicle your favorite activity, such as skiing or cooking. find five digital photos that convey your experience in your favorite activity. create an excel workbook. insert a titled picture blocks smartart in a worksheet. add your five photos and enter a title for each one as well as a caption that describes the photo. 3: import and analyze sales data professional open the template case 7-3 securityenablers template. save the template as a workbook named case 7-3 securityenablers. import the data from the sales table in the case 7-3 securityenablers database to a table starting in cell a4. import the data from the text file case 7-3 security enablers text starting in cell a16. replace all instances of northcentral with central. if necessary, copy the formula in cell f4 to the range f5:f23, and format the data appropriately. update the totals in the range c24:f24. (
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 4
1 Current viewersl
16 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.9
    59 Jobs 52 Reviews
    $0 in 0 Day
  • 4.6
    647 Jobs 468 Reviews
    $0 in 0 Day