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
Starter Activity: Mean, Median, Range ANSWERS
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
Assessment RESIT Documents (Please upload both answer sheets to the previous topic Excel Assessment Upload)
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)
Apprenticeship – Diploma in Hospitality for Emiratis
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)
Apprenticeship – Diploma in Hospitality for Emiratis
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
