Welcome to SNU501 Data Analysis

In this unit, students will learn a very powerful data analysis tool in Excel application. Almost all big and small businesses use Excel in their day-to-day functioning for data analysis. This unit offers an introduction of the use of Excel and it is designed to give students a working knowledge of Excel with its usage for more advanced topics in data analysis. Students will learn basic operations such as reading data into Excel using various data formats and organizing and manipulating data for advanced functionality and analysis. With the use of Excel, students will find it easy to understand the given examples and can apply the techniques in the real world. 

💥💥💥💥SNU501 Announcements 💥💥💥💥

• SNU501 Enrolment List: Click here                 (As of 13th August 2024)

• Students are advised to use their OWN student email address to log in when SUBMITTING tutorials, assignments, and major projects, and when making discussions and comments on this website. 

• Students who wish to buy cheap laptops can go to these two computer dealers. They also offer computer repair/install/update services for computers bought in their shops.
• David Airu, Simple Tech, SIDT building Chinatown. Mobile 8818448
• Max Elijah, Betikama Adventist College. Mobile 7341242

👌👌 Lectures, Labs & Student Resources 👌👌

Week 1    [July 22nd to July 27th 2024]

SNU501 Unit Outline: PDF file

Lecture 1: Power-point presentation

Lecture 1: Handouts (PDF)

Lab practice 1: Lab notes , Data set

Statplus Software: Excel Add-Ins ToolPak

Week 2     [July 29th to August 3rd 2024]

Lecture 2: Power-point presentation 

Lecture 2: Handouts (PDF)

Lab practice 2: Lab notes , Data set

CSV file format to import into Excel: CSV file

Week 3    [August 5th to August 10th 2024]

Lecture 3: Power-point presentation 

Lecture 3: Handouts (PDF)

Lab practice 3: Lab notes , Data set

Week 4    [August 12th to August 17th 2024]

Lecture 4: Power-point presentation 

Lecture 4: Handouts 1 (PDF)

Lecture 4: Handouts 2 (PDF)

Lab practice 4: Lab instruction notes , Pivot data set

Week 5    [August 19th to August 24th 2024]

Lecture 5: Power-point presentation 

Lecture 5: Handouts (PDF)

Lab practice 5: Lab instruction note , Whatif Practice

Week 6    [August 26th to August 31st 2024]

Lecture 6: Power-point presentation 

Lecture 6: Handouts (PDF)

Lab practice 6: Lab instruction note ,  VLOOKUP Practice

Week 7     [Sept 2nd to Sept 7th 2024]

Lecture 7: Power-point presentation 

Lecture 7: Handouts (PDF)

Lab practice 7: Lab instruction note ,  Conditional Formula Practice 

Week 8      [Sept 16th to Sept 20th 2024]

Lecture 8: Power-point presentation 

Lecture 8: Handouts 1 (PDF)  ,  Handouts 2 (PDF)  , Handouts 3 (PDF)

Lab practice 8: Lab instruction note ,  CA.TXT 

Week 9      [Sept 23rd to Sept 28th 2024]

Lecture 9: Power-point presentation 

Lecture 9: Handouts  (PDF)  

Lab practice 9: Lab instruction note ,  T-Test Practice 

Week 10      [Sept 30th to Oct 5th 2024]

Lecture 10: Power-point presentation 

Lecture 10: Handouts 1 (PDF)

Lecture 10: Handouts 2 (PDF)

Lab practice 10: Lab instruction note ,  Descriptive Analysis Practice 

Week 11      [Oct 7th to Oct 12th 2024]

Lecture 11: Power-point presentation 

Lecture 11: Handouts (PDF)  

Week 12     [Oct 14th to  Oct 19th 2024]

Lecure 12: Power-point presentation

Lecture 12: Handouts (PDF)

Week 13      [Oct 21st to Oct 26th 2024]

Lecure 13: Power-point presentation

Lecture 13: Handouts (PDF)

Week 14      [Oct 28th to Nov 2nd 2024]

 💦💦   Internal Assessments (100% Course Work) 💦💦

💥   SNU501 Tutorial 1 (10%) Marks:  Click Here                (Release 27/10/2024)

💥   SNU501 Assignment 1 (20%) Marks:  Click Here           (Release 28/10/2024)

💥   SNU501 Tutorial 2 (10%) Marks: Click Here                 (Release 30/10/2024)

💥   SNU501 Assignment 2 (20%) Marks: Click Here          (Release 06/11/2024)

💥   SNU501 Lab Practise (10%) Marks: Click Here          (Awarded to SAS enrolment list - SNU501 Sem 2, 2024)

💥   SNU501 Major Report Writing (30%) Marks:  Click Here       (Marking in progress)