• 0

Word And Excel (object Linking And Embedding...)

Asked by techquilla,

 Share

Question

Veteran

techquilla

Posted
Posted

" Project 6 due Dec. 3

--Use Microsoft Excel to import a student grade file and compute average

for each student, home work, or examination.

--Sort students by decreasing order of total score.

--Type one page of Word document and import the grade histogram chart.

--Demonstrate the difference of object linking and embedding with

histogram chart.

?@

Download the excel file"

this is my homework that i got to do........the thing i don't understand is the difference between object linking and embedding and how do i show the difference.....?

thanks....

16 answers to this question

Recommended Posts

  • 0
Grand Master

Spyder Veteran

Posted
  • Veteran
Posted

object linking is when it leaves an icon in the document. when you click the icon, the respective program loads.

object embedding is when that specific program itself is embedded (or inserted) within the document itself. see the attached pic. thats Excel embedded inside the word document.

  • 0
Veteran

techquilla

Posted
  • Author
Posted

thanks alot..... Spyder....!!

now i got another problem.....

the project asks me to create a historgram chart from the table in the excel file........i can get the right format of the chart so that the ID numbers, which are not continuous, be on the y-axis, and the grades for each category(seprated by series) be on the x -axis.....can i help me on that...? thanks alot.....BTW....this the link for the excel file.....^^

http://www.cmlab.csie.ntu.edu.tw/~locking/Book1.xls

  • 0
Grand Master

hurting101

Posted
Posted
i can get the right format of the chart so that the ID numbers, which are not continuous, be on the y-axis, and the grades for each category(seprated by series) be on the x -axis

I'm not quite sure what you mean by that... can you clarify?

Is this what you want? (see attachment). If so, get it by doing this:

select data cells > click Chart Wizard > (select type) > Next > Series in: Columns, instead of Rows.

post-7-1038635124.png

  • 0
Veteran

techquilla

Posted
  • Author
Posted

nope, that is not it,......

the first column of table is the ID of each student, starting from the second column are the grades for test and homeworks....so basically, it is like a gradebook.....what i gotta do is ilustrate it with a graph using excel...

the ID tag should be treated like names of student not numbers like the one on your graph, the graph should illsutrate the grade (1-100) of each student for every work done........

thanks anyways for trying...i appreciated it......^^ i know this is very complicated cuz i just cannot get so many things on a single graph......

  • 0
Grand Master

hurting101

Posted
Posted

I'm not sure exactly how to do it, but you can force the student IDs to be treated names by putting a # infront of them (not sure if you're allowed to do this or not). I couldn't get the IDs on the far left (y axis), though. See attachment.

For example, the ID column would look like this:

#880514

#880516

#880535

#880719

#880732

...

post-7-1038640491.png

  • 0
Veteran

techquilla

Posted
  • Author
Posted

thanks to cheekymonkey and hurting101......

ckeekymonkey, yes, the one you did is almost like how i wanted it except that the grades for each work should be on a seperate bar......can you do that......

anyways....thanks alot....!!

BTW, how do you do this object linking and embedding thinggy......^^

This topic is now closed to further replies.
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.