COURSE DESCRIPTION:
Students learn how to create and manipulate spreadsheets using Microsoft Excel, a platform where they can organize, analyze and present all kinds of data. The course is focused on the creation of neat-looking workbooks with colors, tables, and simple charts. Also, students learn how to calculate additional data from inputs, and how the results change when inputs are changed. For the duration of the course, students will learn a few topics within basic science & math, and will use them as motivation for the development of an Excel application as a final project.
CERTIFICATION:
MS Excel: Level II.
LEARNING OUTCOMES:
How to create colorful presentations using Excel worksheets.
How to fill text and numbers in a worksheet and how to modify them using formulas and formats.
How to create tables and simple plots, and how to format them.
How to use formulas with numbers and text.
How to create conditions in workbooks.
How to apply conditional formatting to tables.
Course Features
- Lectures 13
- Quizzes 1
- Duration 12 weeks
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
Curriculum
- 12 Sections
- 13 Lessons
- 12 Weeks
- CLASS 1 - EXCEL KILOBYTEStudents learn how to create a workbook, the basic Excel interface and how to load and save documents.1
- CLASS 2 - EXCEL KILOBYTEStudents learn about data entry, number formatting, and practice with a fun data set.1
- CLASS 3 - EXCEL KILOBYTEStudents use the calculator and basic math functions.1
- CLASS 4 - EXCEL KILOBYTEStudents create tables and pie charts.1
- CLASS 5 - EXCEL KILOBYTEStudents learn statistical analysis like mean and range and learn forms or copy and paste.1
- CLASS 6 - EXCEL KILOBYTEStudents learn about conditionals and conditional formatting.1
- CLASS 7 - EXCEL KILOBYTEStudents brainstorm Project ideas and draw out their development plan.1
- CLASS 8 - EXCEL KILOBYTEStudents build plots, bar charts and histograms.1
- CLASS 9 - EXCEL KILOBYTEStudents commence project.3
- CLASS 10 - EXCEL KILOBYTEStudents keep developing their final project and learn to format plots.1
- CLASS 11 - EXCEL KILOBYTECorrections and quality checks on project.1
- CLASS 12 - EXCEL KILOBYTEStudents complete project and present.2
