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 Enrolment List: Click here
- 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
- David Airu, Simple Tech, SIDT building Chinatown. Mobile 8818448
- Max Elijah, Betikama Adventist College. Mobile 7341242
👌👌 Lectures, Labs & Student Resources 👌👌
Lab practice 1: Lab notes , Data set
Statplus Software: Excel Add-Ins ToolPak
Week 2 [August 11th to 17th 2025]
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 18th to 24th 2025]
Lecture 3: Power-point presentation
Lecture 3: Handouts (PDF)
Lab practice 3: Lab notes , Data set
Week 4 [August 25th to 31st 2025]
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 [September 1st to 7th 2025]
Lecture 5: Power-point presentation
Lecture 5: Handouts (PDF)
Lab practice 5: Lab instruction note , Whatif Practice
Week 6 [September 8th to 14th 2025]
Lecture 6: Power-point presentation
Lecture 6: Handouts (PDF)
Lab practice 6: Lab instruction note , VLOOKUP Practice
Week 7 [September 15th to 21st 2025]
Lecture 7: Power-point presentation
Lecture 7: Handouts (PDF)
Lab practice 7: Lab instruction note , Conditional Formula Practice
Week 8 [September 22nd to 28th 2025]
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 [September 23rd to 28th 2025]
Lecture 9: Power-point presentation
Lecture 9: Handouts (PDF)
Lab practice 9: Lab instruction note , T-Test Practice
Week 10 [September 29th to Oct 5th 2025]
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 [October 6th to 12th 2025]
Lecture 11: Power-point presentation
Lecture 11: Handouts (PDF)
Week 12 [October 13th to 19th 2025]
Lecure 12: Power-point presentation
Lecture 12: Handouts (PDF)
Week 13 [Oct 20th to 26th 2025]
Week 14 [Oct 27th to Nov 2nd 2025]
💦💦 Internal Assessments (100% Course Work) 💦💦
Comments
Post a Comment