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

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

par A S,
Nombre de réponses : 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

Moyenne des évaluations: -
En réponse à A S

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

par 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.

En réponse à A S

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

par G. M.,

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

Front page

En réponse à G. M.

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

par 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

En réponse à A S

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

par 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>

 

En réponse à G. M.

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

par Christian Herman,

By default the table aligns to the left of the section.  So just select the table and click the center alignment button.

En réponse à A S

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

par Rick Jerz,
Avatar Particularly helpful Moodlers Avatar 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.

 

Annexe Excel01.jpg
Annexe Excel02.jpg
En réponse à G. M.

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

par 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

En réponse à A S

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

par 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!