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

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

Nosūtīja A S
Atbilžu skaits: 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

Vidējais novērtējums: -
Atbildot uz A S

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

Nosūtīja 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.

Atbildot uz A S

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

Nosūtīja G. M.

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

Front page

Atbildot uz G. M.

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

Nosūtīja 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

Atbildot uz A S

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

Nosūtīja 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>

 

Atbildot uz G. M.

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

Nosūtīja Christian Herman

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

Atbildot uz A S

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

Nosūtīja Rick Jerz
Particularly helpful Moodlers attēls Testers attēls

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.

 

Pielikums Excel01.jpg
Pielikums Excel02.jpg
Atbildot uz G. M.

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

Nosūtīja 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

Atbildot uz A S

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

Nosūtīja 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!