Microsoft Excell/ Access

[Blondie21]

After watching a few vTextbook guides, this Monash advertisment caught my eye

http://www.youtube.com/watch?v=j96C-MDNhKo&index=6&list=PLjZkU1vM_0aXbWGjrQNu2OxlCXc4qYtCg (Yes Monash, your advertisments are working...)

From the 0.44 point, the student talks about how she used excell to plot exam questions.
What is the best way to format the table? How did she plot a graph if there would have been no numbers involved (answers would have been in words)??

I'm currently using a similar method but on Microsoft Access. Is this a better program to be using?

I would appreciate any help. Thanks!

[Fyrefly]

Hmm... it's down to personal preference, really.
I'd personally favour Excel over Access for a task like this, but each to their own.

Generally speaking:
Excel is better for data input where only a small amount of manipulation is required to derive useful information.
Access is better for large databases that require substantial manipulation to extract information.

~~~

For Excel, pivot tables can be very useful and versatile.
You don't have to just use graphs.

If you want to get around the "word answer" issue and use graphs, just allocate a number to each option.

Question Type:
Explanation = 1
Application = 2

[Blondie21]

Hmm... it's down to personal preference, really.
I'd personally favour Excel over Access for a task like this, but each to their own.

Generally speaking:
Excel is better for data input where only a small amount of manipulation is required to derive useful information.
Access is better for large databases that require substantial manipulation to extract information.

~~~

For Excel, pivot tables can be very useful and versatile.
You don't have to just use graphs.

If you want to get around the "word answer" issue and use graphs, just allocate a number to each option.

Question Type:
Explanation = 1
Application = 2

After watching a few tutorial videos on YouTube, the pivot table is exactly what I needed. Thanks so much!!

[Rishi97]

Blondie, show me how your graph looks when finished k?

[Blondie21]

Blondie, show me how your graph looks when finished k?

Haha I will show you on the first day back :-) I'm going to use this for my content based subjects (e.g. PE).. I don't think it will be useful for methods or for chem

[Rishi97]

True... I started compiling all the examiners reports for methods into one document but it didn't get very far. lol. I gave up