Simple question: How to incorporate an excel file into Moodle?

Simple question: How to incorporate an excel file into Moodle?

- A S の投稿
返信数: 9

Hi guys,

A very simple question. I want to have some area in my Moodle where I can embed an Excel file or create a table which is just a list of learning resources for my students. This excel file includes different books and websites. It has around 3 to 4 columns. 

 

I don't really want to incorporate it as a course, but just as a study aide?

 

Thanks

A S への返信

Re: Simple question: How to incorporate an excel file into Moodle?

- Jez H の投稿

You could upload the file as a file resource or if you want it rendered in a page paste it into a label, though I have to say pasting from MS documents into any website is problematic as they tend to add weird and wonderful characters, Im not at all sure how well it would work with excel.

A S への返信

Re: Simple question: How to incorporate an excel file into Moodle?

- G. M. の投稿

Enable the Include a topic section option (Administration > Front page settings > Edit settings) and put the table there.

Front page

G. M. への返信

Re: Simple question: How to incorporate an excel file into Moodle?

- A S の投稿

Thank you both. 

 

The front page setting only put this in a corner. And the label option is fine, but again it doesn't retain the excel format? It doesn't have to be excel format, but can it just be a pretty format? Or should I look into a different solution altogether? Is there a moodle plugin which acts as sort of a 'database' where I can just have a list with columns? 

Also, when I copy and paste, it doesn't keep the Excel format? But strangely enough, as I was playing around with this, only once, it allowed me to do the copy and paste successfully. 

I am attaching a sample of the excel file.  I simply want this to be presented to the students in a place called "Learning Resources" etc. 

Thanks

A S への返信

Re: Simple question: How to incorporate an excel file into Moodle?

- G. M. の投稿

In a corner?

Please go to http://demo.moodle.net/ to see a working example (it will only be there till the next reset).

<table style='border:0;border-spacing:3px;'>
<tr>
<td style='padding:3px;background-color:#5B9BD5;color:white;font-weight:700;'><b></b></td>
<td style='padding:3px;background-color:#5B9BD5;color:white;font-weight:700;'><b>Resource</b></td>
<td style='padding:3px;background-color:#5B9BD5;color:white;font-weight:700;'><b>Type</b></td>
<td style='padding:3px;background-color:#5B9BD5;color:white;font-weight:700;'><b>Level</b></td>
<td style='padding:3px;background-color:#5B9BD5;color:white;font-weight:700;'><b>Description</b></td>
</tr>
<tr>
<td style='padding:3px;background-color:#DEEBF6;color:black;font-weight:700;'>1</td>
<td style='padding:3px;background-color:#DEEBF6;color:#0563C1;text-decoration:underline;'>Book 1</td>
<td style='padding:3px;background-color:#DEEBF6;color:black;'>E-Learning</td>
<td style='padding:3px;background-color:#DEEBF6;color:black;'>Student</td>
<td style='padding:3px;background-color:#DEEBF6;color:black;'>Book description</td>
</tr>
<tr>
<td style='padding:3px;background-color:white;color:black;font-weight:700;'>2</td>
<td style='padding:3px;background-color:white;color:#0563C1;text-decoration:underline;'>Book 2</td>
<td style='padding:3px;background-color:white;color:black;'>E-Learning</td>
<td style='padding:3px;background-color:white;color:black;'>Trainee</td>
<td style='padding:3px;background-color:white;color:black;'>Book description</td>
</tr>
</table>

 

A S への返信

Re: Simple question: How to incorporate an excel file into Moodle?

- Rick Jerz の投稿
画像 Particularly helpful Moodlers 画像 Testers

I might not fully understand your need, and at first, I didn't think much about your question because I thought the answer would be simple.

In my Business Statistics course, for every topic, I give students at least one, maybe two Excel files that they can download (see graphic).  However, my technique is different than most.  I actually have these Excel files on my web server, so I just create a URL resource in my Moodle (see second graphic).  I have never had students complain about not being able to get these Excel files.

 

添付 Excel01.jpg
添付 Excel02.jpg
G. M. への返信

Re: Simple question: How to incorporate an excel file into Moodle?

- A S の投稿

Thank you both. 

 

The front page setting only put this in a corner. And the label option is fine, but again it doesn't retain the excel format? It doesn't have to be excel format, but can it just be a pretty format? Or should I look into a different solution altogether? Is there a moodle plugin which acts as sort of a 'database' where I can just have a list with columns? 

Also, when I copy and paste, it doesn't keep the Excel format? But strangely enough, as I was playing around with this, only once, it allowed me to do the copy and paste successfully. 

I am attaching a sample of the excel file.  I simply want this to be presented to the students in a place called "Learning Resources" etc. 

Thanks

A S への返信

Re: Simple question: How to incorporate an excel file into Moodle?

- Perry Way の投稿

Q: Is there a moodle plugin which acts as sort of a 'database' where I can just have a list with columns?

A: Yes, it's called a "Database". It shows up on your list when you try to add an activity! Cheers!