Excel CA

There is a 15% Excel Test in Week 12 in the usual lab times and venues:

  • IT1-A , Thursday 12:00 in C128
  • IT1-B, Wednesday at 16:00 in C125

 I recommend that you come as early as possible and get your machine started up.

In the lab itself, I will hand you out a Test A or a Test B — and email you an Excel file that you can use as a template.

Here is the Sample Test including the Excel template.

Here is a scanned copy of the solutions and here is the Excel file used to support the solutions.

Labs 1 & 2 are here and here (data). The other lab is here.

This is an open book assessment — and any information which you can access on your workstation you are free to use — but you must not look at your neighbour’s work.

Student Feedback

If you would like to submit anonymous feedback on this module/lecturer, you may take the do so here. This link will be open until May 12.

Week 11

On Wednesday we worked on binomial and Poisson Distribution exercises. On Thursday we started talking about the normal distribution.

Week 12 — Excel Test

We will work on the normal distribution.

Week 13 — Revision

There is an exam paper at the back of your notes — I will go through this on the board in the lecture times in the normal rooms.

We will also have tutorial time in the tutorial slots. You can come to any or both tutorials. Again in the normal (computer lab) rooms.

Maths Online & Numbas

If you are subscribed to CIT MathsOnline you will have free access to the mathematical training tool Numbas:

Self-enrolment for Maths Online

1.           Log into Blackboard Learn

2.           Click on the Courses tab button at the top of the screen. Go to Course Search and type Maths Online in the box.

3.           Once you’ve found the course, click on the action link button next to the course and click on Enrol. This should take you to the Self Enrolment page.

4.           Your Access Code is mathsonline (lower case, no spaces).

5.           After you’ve finished click Submit. You should now see a message that says your enrolment was successful.

Once you’ve enrolled, select Maths and Statistics by Module, then STAT6000. There are then three training tools for you to check out.

Diversions

We have briefly mentioned

Study

Please feel free to ask me questions about the exercises via email or even better on this webpage.

Student Resources

Please see the Student Resources tab on the top of this page for information on the Academic Learning Centre, etc.

Advertisement