К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Spreadsheet Attendance System from Scratch · LearnSpace
Назад в каталог
courseraБизнес

Spreadsheet Attendance System from Scratch

Курс от EDUCBA
Уровень не указан≈ 8.7 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Master Excel VBA by building a complete Attendance Register from scratch. Learn how to automate attendance tracking, reduce manual errors, and create a professional system step-by-step. This hands-on course transforms beginners into confident Excel automation users by guiding them through a real-world project. You will design interactive user forms, implement attendance marking logic, and automate calculations like present, absent, and total counts. Through structured lessons, you’ll learn how to generate student data, manage attendance inputs, and store records efficiently in Excel. By the end of the course, you will have a fully functional attendance management system that can be used in schools, institutes, or organizations. Whether you’re a student, teacher, or professional, this course equips you with practical VBA skills that improve productivity and streamline repetitive tasks.

Навыки, которые вы освоите

Visual Basic (Programming Language)Spreadsheet SoftwareExcel MacrosUser Interface (UI) DesignUI ComponentsAutomationProductivityLESSRecords ManagementData EntryProject Management SoftwareData ManagementFunctional DesignRecord KeepingProject ManagementData StoreUser Interface (UI)Data Storage

Программа курса

5 модулей · 44 учебных материалов

01Project Setup & Foundations10 материалов

Getting Started with Attendance Automation

Introduction to Attendance Register Using Excel VBAВидеоHow to Create Macro Enabled Work Book to SaveВидеоGetting Started with Attendance AutomationЗадание

Project Planning & Initialization

Project Start Session and Details of ProjectВидео

Учитесь у экспертов

EDUCBA

Преподаватель курса

Spreadsheet Attendance System from Scratch
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 8.7 ч

5 модулей

Язык: Английский

Часть программы вашего университета
How to Create Project Interface User FormВидео
How to Save Mark Attendance in ExcelВидео
Project Planning & InitializationЗадание
Setting Up an Automated Attendance System Using Excel VBADIALOGUE
Graded - Project Setup & FoundationsЗадание
Set Up and Initialize an Automated Attendance System in Excel VBADIALOGUE
02Designing the User Interface10 материалов

Building the Interface Layout

How to Design Project InterfaceВидеоHow to Design Project Interface ContinuesВидеоBuilding the Interface LayoutЗадание

Creating Student Data Structure

Generate Serial Number in Attendance RegisterВидеоGenerate Student Id in Attendance RegisterВидеоCreating Student Data StructureЗадание

Adding Core Student Details

Generate Student Name in Attendance RegisterВидеоGenerate Course Detail in Attendance RegisterВидеоAdding Core Student DetailsЗаданиеGraded - Designing the User InterfaceЗадание
03Attendance Marking Functionality7 материалов

Capturing Attendance Inputs

Add Attendance Value using Combo BoxВидеоCreate Attendance Mark Button in Attendance RegisterВидеоCapturing Attendance InputsЗадание

Enhancing Attendance Actions

Attendance Mark Button in Attendance RegisterВидеоAttendance Mark Button in Attendance Register ContinuesВидеоEnhancing Attendance ActionsЗаданиеGraded - Attendance Marking FunctionalityЗадание
04Advanced Controls & Attendance Insights10 материалов

Managing Attendance Controls

Create Attendance Clear Button in Attendance RegisterВидеоHow to Add Image in Attendance RegisterВидеоManaging Attendance ControlsЗадание

Tracking Attendance Metrics

How to Count Present Students in Attendance RegisterВидеоHow to Absent Students in Attendance RegisterВидеоTracking Attendance MetricsЗадание

Monitoring Special Attendance Cases

How to Sick Students in Attendance RegisterВидеоCount Late Students in Attendance RegisterВидеоMonitoring Special Attendance CasesЗаданиеGraded - Advanced Controls & Attendance InsightsЗадание
05Finalization & Data Management7 материалов

Displaying Summary Information

Display Total Enroll Students in Attendance RegisterВидеоDisplay Date and Time in Attendance RegisterВидеоDisplaying Summary InformationЗадание

Saving & Validating Attendance Records

Example of Save Mark Attendance in ExcelВидеоSaving & Validating Attendance RecordsЗаданиеGraded - Finalization & Data ManagementЗаданиеDesign and Deploy an Automated Attendance System Using Excel VBADIALOGUE