fbpx

Data Analytics and Math Applications Using Microsoft Excel

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.

*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

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 Data Analysis-  Mean, Median, Mode, Quartiles and Outliers

7

Working with Percentiles and Frequency Curves

8

Correlation

9

Simple regression analysis and curve fitting

Course Details

Ideal for

Grade 7 - 10

Duration

6 - 8 days

Total hours

23 - 24 hours

The course includes: teaching, assessments, doubt clarification, homework and progress reports for all Batches

Batches running in January and June – Check our Monthly calendar for course dates

Testimonials

“It was amazing — I really learned a lot from this course as now I feel I’m proficient in excel when I really didn’t know anything before it, and the combinations of content and teachers were just stellar. The virtual classes still retained the level of interaction I would have expected from a physical course while being more convenient.”

Abhimanyu Singh

Oberoi International School, Mumbai, Grade 7, IB, 2021 - Level 1

“I loved the course. It was very informative and helped me learn new things. Both the teachers were very nice and the activities were fun. It was fun to do case studies. The virtual medium allowed us to share screens when we were having a problem and there were no problems. Even the classroom was easy to use and getting files and submitting assignments was manageable.”

Vansh Aggarwal

Dhirubhai Ambani International School, Mumbai, Grade 7, ICSE, 2021 - Level 1

“This course was absolutely amazing and a completely new experience. I have never used Excel properly, and I really felt like I wanted to learn something new. Our instructor, Mr. Mohit really did make an effort to teach us very nicely and I did learn a lot. The course managed to get to the point of each module, and it was very direct, which was great. The probability questions were super fun and it was nice interacting with other students. The homework was also a good way to practice my skills.”

Sofya Mehta

Woodstock School, Mussoorie, Grade 8, IB, 2021 - Level 1

“I had a great experience with this course. There was a lot of interaction, it didn’t feel like we were studying away from the teachers. Excel was a lot of fun and I learnt a lot of new things. Maths became a part of excel which I enjoyed the most. I didn’t get to know when the lesson got over and would love to do it again!”

Pratham Verma

Suncity School, Gurgaon, Grade 8, CBSE, 2021 - Level 1

“This course has greatly expanded my knowledge about Excel, data visualization and a lot about data analysis and statistics. Learning was pretty much the same as physical, as there was a great amount of interaction. Mohit Sir constantly answered my doubts and had great communication skills. Arjun sir too, answered my doubts and he taught the math concepts perfectly. The finale tasks were very interactive and exposed us to great teamwork. They were all creative and summed up everything we learnt about in the past month!”

Vidit Bhimrajka

Dhirubhai Ambani International School, Mumbai, Grade 8, IGCSE, 2021 - Level 1

“I really had so much fun doing the MS Excel course. In the beginning, I had never touched excel before because in school we either draw graphs by hand or make them in google sheets. But I got to learn so many new things to do in excel like equations and charts, and even some simple shortcuts to make collecting data easier, such as how to automatically populate a list. I especially enjoyed the finale task, because we got to work in teams and complete the tasks together.” 

Azadeh Changrani-Rastogi

Oberoi International School, Mumbai, Grade 7, IB, 2021 - 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!”

Ahana Kanoi

Dhirubhai Ambani International School, Mumbai, Grade 7, ICSE, 2021 - Level 1

“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”

Raj Amol Chauhan

Dhirubhai Ambani International School, Mumbai, Grade 7, IGCSE, 2021

“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 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.”

Sumair Singh

Dhirubhai Ambani International School, Mumbai, Grade 8, IGCSE, 2021 - Level 1

“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.”

Prisha Jani

Ascend International School, Mumbai, Grade 8, MYP, 2021 - Level 2

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

“This course really helped me learn a lot, I did not think there was that much to learn about excel. The activities and course content was very planned and it was interesting to learn more. Mr. Verma, our instructor, was very good, you could tell he knew a lot about the subject.”

Nicolas Vucinic

American School of Bombay, Mumbai, Grade 9, IB MYP, 2022. High School Accelerator - 2022

“I feel the learning experience was really fun. Mohit Sir had a lot of knowledge on the topic and learning with Sir was also really fun. The course was well managed, it felt just like learning in class better! actually even better. This really helped me to open up to a different world of data analytics. The finale tasks were really engaging and interesting. I really liked the course and have gained immense knowledge.”

Anirudh Suri

Indian International School, Dubai, Grade 8, CBSE, 2022. High School Accelerator - 2022

“This course has helped me a lot. It has helped me learn data analytics and how to handle excel as a whole a lot better. I think the course was handled in a very professional and good manner.” 

Kyra Mahindru

Dhirubhai Ambani International school, Mumbai, Grade 8, IGCSE, 2022. High School Accelerator - 2022

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 (7 votes)
5 stars
7
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.

2 years 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!

2 years 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

2 years 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.

2 years 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.

2 years 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 .

1 year ago
Anirudh Suri
tech@5pixls.com

Data Analysis - Level 1

This course really helped to open me up to a new world of Excel and its Statistical applications. I really liked the course, especially the Finale the tasks were really engaging but managed to be really fun and exciting at the same time. I will surely continue to work with Excel in my daily life. One thing I can say for sure is that hereafter I will look at Data in another way.

10 months ago

Review Data Analytics and Math Applications Using Microsoft Excel.

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