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

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

by A S -
Number of replies: 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

Average of ratings: -
In reply to A S

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

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

In reply to A S

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

by G. M. -

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

Front page

In reply to G. M.

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

by 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

In reply to A S

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

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

 

In reply to G. M.

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

by Christian Herman -

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

In reply to G. M.

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

by G. M. -

Here's the screenshot:

Attachment mdl-fp-table.png
In reply to A S

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

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of 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.

 

Attachment Excel01.jpg
Attachment Excel02.jpg
In reply to G. M.

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

by 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

In reply to A S

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

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