fbpx

Data Analytics and Math Applications Using Microsoft Excel (Level 1 & 2)

masterstudy_placeholder
masterstudy_placeholder
course_pre-ib-math
course_pre-ib-math
Slide1
Slide2
Slide3
Slide4
previous arrow
next arrow

Course Concept

Data is only as valuable as we make it.  As the amount of data in the world increases, the ability to extrapolate meaning and influence through analysis  has put varieties of demands for Math in the modern world. Mathematics today includes statistical literacy, algorithmic thinking, and modelling of data. Many jobs and university courses across the Sciences and Humanities  programmes now call for competence in applied mathematics. Students of high school also need skills to be able to use and analyse data for their research work in various subject disciplines. The course will help students with these skills required in their rigorous pre university courses like the IB Diploma, or further in their University studies.

Microsoft Excel is a wonderful application tool for data analysis and can be used to achieve some of the above student learning outcomes. Utilising a powerful spreadsheet-oriented technique in teaching reinforces mathematical concepts, and has further enabled us to integrate information technology into the mathematics curricula. It helps individuals accurately assess situations and make better decisions. 

Visual representations of information provide an accessible way to identify trends, patterns, and outliers—all of which help to tell the story within the data. This course helps you unlock the power of data using the data analysis and visualization tools built into Excel. Active student engagement is at the heart of the course. Bringing visual, hands-on exercises into the learning process will turn students from almost passive spectators into active participants. 

Each teaching module includes practical examples that show how to apply the techniques to real-world problems that require data handling and analysis. We start teaching with the foundational concepts, including basic statistical calculations. We then teach how to visualize data, relationships, and future results with Excel’s histograms, graphs, and charts. Finally, we will consolidate your learnings through a Finale Task that you will present in front of your parents.

* Level 2 course further enables students to learn advanced mathematical concepts and solve problems through math simulations.

*To meet the new demands on Math, significant changes have been made in the IB DP Mathematics curriculum in 2019 so that it continues to be relevant and rigorous, and the new course MAI Math Applications and Interpretation has been introduced. IB Diploma Math students have to write a research report on a topic of their choice called math exploration, which makes heavy use of data analysis skills; even the best of math students find this challenging, having not learnt these skills in middle and high school. The course will help students to use data meaningfully in their research work, investigations, and math explorations.

COURSE OBJECTIVES

LEVEL 1

1

Excel Basics

2

Visualization of Data

3

Understanding trends based on types of charts

4

Introduction to Data Analysis-  Mean, Median, Mode, Quartiles and Outliers

5

Working with Percentiles and Frequency Curves

6

Introduction to Probability & Logical Statements

7

Working with sample data and Case Studies

ADDITIONAL LEVEL 2

1

Probability Distributions

2

Correlation

3

Simple regression analysis and curve fitting

4

Math modelling – using excel to stimulate math problems

* Students who will complete level 1 - can join the last two days of Level 2 at any time when it is offered in April or June - July.

Course Details

Level 1

Ideal for

Grade 6 - 8

Duration

6 days

Total hours

23 hours

Break-up

  • This course is intended for students of national and international boards
  • The course will be delivered across 6 days on Saturdays & Sundays
  • 18 hours of teaching sessions 
  • 5 hours of continuous assessment, feedback, parent orientation & progress reports

Dates

Batch 1

2nd, 9th, 16th, 23rd Jan

(All Saturdays)

10:00am to 12:30pm

26th & 30th Jan

10:00am to 2:00pm

Batch 2

17th, 18th, 24th, 25th April

09:30am to 2:00pm

1st & 2nd May

10:00am to 12:30pm

(All Saturdays & Sundays)

Level 2

Ideal for

Grade 9 - Pre-University

Duration

6 days

Total hours

23 hours

Break-up

  • This course is intended for students of national and international boards from Grade 9 to Pre-University. 
  • The course will be delivered across 4 days on Saturdays & Sundays.
  • 18 hours of teaching sessions 
  • 5 hours of continuous assessment, feedback, parent orientation & progress reports

Dates

Batch 1

19th, 20th, 26th, 27th June

10:00am to 2:00pm

3rd & 4th July

10:00am to 2:00pm

(All Saturday and Sunday)

Testimonials

I haven’t used excel for math before this course. This course was very beneficial for me because I learnt to use excel to solve a variety of math problems. I also learned to visualise data, solve probability questions, graph tables, solve basic calculus questions, create and analyse correlation and regression charts and tables, the usage of pivot charts and many more.The homework helped me assess how well I knew the topics and weather I could apply everything I learned to different questions.

Tulasi Anantharamakrishnan

American International School Chennai (AISC), Chennai, Standard American, 2020

I learnt various excel skills and also learnt how to plot graphs and use excel to simplify math concepts. Our instructor, Mr. Mohit added great value to the course as he is very well-versed in the course content. He is able to make the sessions interesting and is able to keep the attention of the class. He always clarifies doubts and guides us through the difficult topics. The homework tasks provided me with the opportunity to revise and remember the concepts taught during the sessions, which was very helpful.

Karun Mongia

Chirec International School, Hyderabad, Grade 10, CBSE, 2020

This course was very helpful and interesting for me. I learnt about pivot charts and analysis which was fun and will definitely help in the long run.

Rishita Shroff

Bombay Scottish School, Mumbai, Grade 10, ISC, 2020

I have learnt how to use Microsoft Excel effectively but also how to visualise data and plot it well. The homework tasks allowed us to try what we had learned alone and then ask for help so that we could understand to what extent we had understood and what we needed help in. The finale tasks were fun and interesting and allowed us to use all the skills we had learned in these sessions to solve them.

Kyra Roy

Dhirubhai Ambani International School, Mumbai, Grade 10, IGCSE, 2020

Student Voice

How can we help

Please refer to the Contact Us page if you need help deciding courses or have any other inquiries so we can understand your needs. The appropriate team member will get in touch with you shortly.

You May Also Like

Reviews

Average Rating: 5.0 out of 5 (6 votes)
5 stars
6
4 stars
0
3 stars
0
2 stars
0
1 star
0
prisha jani
tech@5pixls.com

Engaging and Informative

Prior to this course, I had no knowledge of how to use the MS excel software, but after this course I feel like I can use the software on a daily basis. My knowledge of data analytics has also increased and I think that I can apply the skills I learnt in my daily life.

5 months ago
Ahana Kanoi, Grade 8, Dhirubhai Ambani International School
tech@5pixls.com

Data and Analysis - Level 1

This course was not only interactive but taught me a lot about excel and math from probabilities to data visualizations. I learnt a lot from all the different ways to use excel. This will help me lots in school and life. The teacher – Mohit Sir – was very fun and made everything interesting. I really enjoyed doing this course!

5 months ago
Raj Chauhan
tech@5pixls.com

Amazing course

When I joined I only knew the basics of ms excel but with this course I discovered many new features and learnt so much. Our teacher was very interactive and helped us whenever we got stuck.I really loved this course

5 months ago
Sumair SIngh
tech@5pixls.com

Data and analysis - level 1

this course was the perfect balance of work and fun. it was very interactive and taught me a lot about excel and how math can be done in many ways I never knew even existed. Overall I would say that is you are looking to learn about excel you should one hundred percent do this course.

5 months ago
Sumair Singh, Grade 8, Dhirubhai Ambani International School
tech@5pixls.com

Data and analysis - level 1

this course was the perfect balance between fun and work it taught me a lot about excel that I would have probably never known had I not done this course. if there is anyone out there that knows nothing about excel and wants to just get a basic understanding of what excel is I would 100% suggest you do this course to help increase your excel knowledge.

5 months ago
Anuradha Shetty
tech@5pixls.com

Microsoft Excel

A very well conceptualised program for the children . Mrs Dhingra ‘s passion towards creating a par excellent educational program so that our children could be on par with the educational system world over is very evident. The children were given tips and short cut methods to solve their problems . This would certainly help them in their Maths solving capabilities moving forward .
Mr Mohit Verma their teacher was extremely patient and was always ready to solve any and all children’s queries no matter how many times it was required to be explained .
Here’s wishing the team all the very best in their endeavour to create a high standard of education for our children .

3 months ago

Review Data Analytics and Math Applications Using Microsoft Excel (Level 1 & 2).

Your email address will not be published. Required fields are marked *