Skip to main content
BNS06005RU24 Use Excel to Analyse and Visualise Data:7:20243
0%
Previous
Course data
General
Announcements
Lecture Slides
Lecture Slides
Lecture Materials - Histograms (Mean, Median, Range)
Starter Worksheet
Histogram Worksheet (To Print)
Seminar 1: Basic Functions in Excel
Seminar 1 Class Notes
FizzPop Data for Seminar 1
Excel Cheat Sheet
Worksheet 1 Data
Worksheet 1 Questions
Worksheet 1: Completed
Seminar 2: IF Statements
Seminar 2 Class Notes
FizzPop Data
Worksheet IF Formula Practice
Worksheet COUNTIF and SUMIF
Additional Practice - IF Statements
Seminar 2 Upload
Seminar 3: The Ethics of Predictive Analytics
Seminar 3 Class Notes
Seminar 4: Charts
Seminar 4 Class Notes
Charts Worksheet Data
Charts Worksheet Questions
Sorting and Filtering Worksheet Data
Sorting and Filtering Worksheet Questions
Seminar 5: VLOOKUPs
Seminar 5 Class Notes
Sales Data Raw
Worksheet 1 VLOOKUP Practice
Worksheet 2 VLOOKUP Practice DATA
Worksheet 2 VLOOKUP Practice Questions
Extra Practice Worksheet 1 VLOOKUPS
Extra Practice Worksheet 2 VLOOKUPS
Seminar 6: Pivot Tables
Seminar 6 Class Notes
Seminar 6 Pivot Table Data
Seminar 6 Pivot Table Data with Pivot Table and Chart
Pivot Table Worksheet 1
Seminar 7: Histograms
Seminar 7 Class Notes
Starter Activity: Mean, Median and Range
Events Test Results Data
Example 1 Sales Time Series
Example 2 Sales Time Series
Stretch Yourself Worksheet: Histograms
Seminar 8: Distributions and Trend lines
Seminar 8 Class Notes
Data Set 1 for SD and ND
Worksheet 1 Distribution Practice
Assessment 1
Assessment Presentation Upload
Assessment Brief (1 of 2)
Assessment 2
Excel Assessment Upload
Part 1 Menu Item Sales October 23_Student Name
Part 2 Soft Drink Product Behaviour_Student Name
Excel Assessment Upload Pt2
Assessment RESIT Documents (Please upload both answer sheets to the previous topic Excel Assessment Upload)
RESIT_Part 1 Menu Item Sales October 23_Student Name
RESIT_Part 2 Soft Drink Product Behaviour_Student Name
Instructor Resources
Next
Side panel
Categories
All categories
Academic Year 2024
2024 Trimester 1
Level 4 Certificate
Hospitality HO20241
Culinary Arts CA20241
Events EV20241
Tourism T20241
Level 6 Advanced Diploma 20241
2024 Trimester 2
Level 4 Certificate
Level 6 Advanced Diploma 20242
2024 Trimester 3
Level 4 Certificate
Events
Hospitality
Tourism
Culinary Arts
Level 6 Advanced Diploma
Apprenticeship
Apprenticeship - Certificate 4 in Culinary Operations 2024
Employer Feedback Form and Self-Reflection
Block 1 (At DCT)
Block 2 (At Industry)
Block 3 (At DCT)
Block 4 (At Industry)
Block 5 (At DCT)
Term 1_2025
Apprenticeship – Diploma in Hospitality for Emiratis
Term 1
Term 2
Apprenticeship - Certificate 4 in Culinary Operations (DWTC- Emiratis only)
Term 1
Certificate 4 in Culinary Operations EKFC Apprenticeship
Term 1
Academic Year 2020
20201 Trimester
Hospitality
Retail Business
Events
Tourism
Diploma
20202 Trimester
Culinary Arts
Retail Business
Events
Hospitality
Tourism
BA
20203 Trimester
Culinary Arts
Retail Business
Events
Hospitality
Tourism
DCT Year 3
Home
Search
Search
Search
Search
Close
Toggle search input
Log in
Categories
Collapse
Expand
All categories
Academic Year 2024
2024 Trimester 1
Level 4 Certificate
Hospitality HO20241
Culinary Arts CA20241
Events EV20241
Tourism T20241
Level 6 Advanced Diploma 20241
2024 Trimester 2
Level 4 Certificate
Level 6 Advanced Diploma 20242
2024 Trimester 3
Level 4 Certificate
Events
Hospitality
Tourism
Culinary Arts
Level 6 Advanced Diploma
Apprenticeship
Apprenticeship - Certificate 4 in Culinary Operations 2024
Employer Feedback Form and Self-Reflection
Block 1 (At DCT)
Block 2 (At Industry)
Block 3 (At DCT)
Block 4 (At Industry)
Block 5 (At DCT)
Term 1_2025
Apprenticeship – Diploma in Hospitality for Emiratis
Term 1
Term 2
Apprenticeship - Certificate 4 in Culinary Operations (DWTC- Emiratis only)
Term 1
Certificate 4 in Culinary Operations EKFC Apprenticeship
Term 1
Academic Year 2020
20201 Trimester
Hospitality
Retail Business
Events
Tourism
Diploma
20202 Trimester
Culinary Arts
Retail Business
Events
Hospitality
Tourism
BA
20203 Trimester
Culinary Arts
Retail Business
Events
Hospitality
Tourism
DCT Year 3
Home
Academic Year 2024
2024 Trimester 3
Summary
Course info
BNS06005RU24 Use Excel to Analyse and Visualise Data:7:20243
Teacher:
Miles Entwistle
Skill Level
:
Beginner
