COURSE DESCRIPTION:
Students learn how to create and edit spreadsheets using Microsoft Excel. The focus will be on the application’s data manipulation and presentation features, including functions, tables, pivot tables, and multiple types of charts (line, plot, pie chart and histograms). Functions using mathematical and statistical tools, conditional sentences as well as text string and datetime modifiers will be explored. During the duration of the course, students will relate the topics learned with the mathematics and science knowledge from their school grade. Students will also develop an Excel application, using the tools they learned from the course as a final project.
CERTIFICATION:
MS Excel: Level III.
LEARNING OUTCOMES:
How to use tools to create professional-looking presentations using Excel worksheets.
Data entry, processing and formatting in Excel, including data types and conditional formatting.
How to create tables, pivot tables and graphs from processed data, including scatter plots, line plots, pie charts and histograms.
How to create statistical predictions from numerical data using regression tools.
How to use mathematical, statistical, conditional and text functions, and how to nest them.
Course Features
- Lectures 12
- Quizzes 1
- Duration 12 weeks
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
Curriculum
- 12 Sections
- 12 Lessons
- 12 Weeks
- CLASS 1 - EXCEL MEGABYTEStudents learn how to create a workbook, the basic Excel interface and how to load and save documents.1
- CLASS 2 - EXCEL MEGABYTEStudents learn about data entry, number and table formatting and filters.1
- CLASS 3 - EXCEL MEGABYTEStudents use the calculator and more advanced math functions.1
- CLASS 4 - EXCEL MEGABYTEStudents create tables and different charts. Students learn statistical measures of variation and dispersion.1
- CLASS 5 - EXCEL MEGABYTEStudents builds different kinds of line plots and learn on its functionality.1
- CLASS 6 - EXCEL MEGABYTEStudents learn about conditional statements such as ‘if’, ‘or’, ‘and’ etc.1
- CLASS 7 - EXCEL MEGABYTEStudents brainstorm Project ideas and draw out their development plan.1
- CLASS 8 - EXCEL MEGABYTEStudents learn how to use basic formulas with ranges for some short fun apps.1
- CLASS 9 - EXCEL MEGABYTEStudents commence project and learn about box plots.3
- CLASS 10 - EXCEL MEGABYTEStudents keep developing their final project and learn about pivot tables.1
- CLASS 11 - EXCEL MEGABYTECorrections and quality checks on project.1
- CLASS 12 - EXCEL MEGABYTEStudents complete project and present.1
