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, histograms and boxplots). Functions using mathematical and statistical tools, conditional sentences and look-up functions, 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 IV.
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, histograms and boxplots.
How to create statistical predictions from numerical data using regression tools.
How to use mathematical, statistical, conditional, text and look-up functions, and how to nest them.
Course Features
- Lectures 12
- Quizzes 9
- Duration 12 weeks
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
- 12 Sections
- 12 Lessons
- 12 Weeks
- CLASS 1 - EXCEL GIGABYTE3 ItemsStudents learn how to create a workbook, the basic Excel interface and how to load and save documents. Students also learn about data entry, number and table formatting and filters.
- CLASS 2 - EXCEL GIGABYTE3 ItemsStudents use the calculator and more advanced math functions. Students also create tables and different charts and learn to label.
- CLASS 3 - EXCEL GIGABYTE3 ItemsStudents learn statistical measures of variation and dispersion. Students also learn about absolute and relative numbers.
- CLASS 4 - EXCEL GIGABYTE3 ItemsStudents build different kinds of line plots and learn on its functionality. Students also learn about different regression formulas.
- CLASS 5 - EXCEL GIGABYTE3 ItemsStudents learn to concatenate, match, and use the VLOOKUP and XLOOKUP functions.
- CLASS 6 - EXCEL GIGABYTE3 ItemsStudents learn about date and time formulae and conditional statements such as ‘if’, ‘or’, ‘and’ etc.
- CLASS 7 - EXCEL GIGABYTE3 ItemsStudents brainstorm Project ideas and draw out their development plan.
- CLASS 8 - EXCEL GIGABYTE3 ItemsStudents learn about conditional formatting and different kind of plots and their formatting.
- CLASS 9 - EXCEL GIGABYTE3 ItemsStudents commence project and learn about error bars.
- CLASS 10 - EXCEL GIGABYTE1 ItemStudents keep developing their final project and learn about pivot tables.
- CLASS 11 - EXCEL GIGABYTE1 ItemCorrections and quality checks on project.
- CLASS 12 - EXCEL GIGABYTE1 ItemStudents complete project and present.
