Skip to content
FABE OBE Spreadsheet
About
FABE OBE Spreadsheet Guide
More
Share
Explore
FABE OBE Spreadsheet Guide

icon picker
Spreadsheet v 11.2

Rizal Husin
This is a collection of video on how to use FABE OBE Spreadsheet 11.2

Step 1: Get a copy

You may get a copy of the spreadsheet here:
⁠
PROGRAM SUBJECT NAME Semester 23 TF v11.2c - Make a copy (google.com)
⁠
⁠
⁠
Loading…
⁠
⁠

Naming the File

In order to gain further benefit of the spreadsheet, naming it properly will help us to manage and get the data from it for further analysis by the Head of Program (HOP).

Sharing the file with HOP

It is important to share the file with your HOP or anyone that you think should have certain level of access to the document.
⁠
Loading…
⁠
⁠
⁠

Step 2: Understanding the Spreadsheet

Understanding Interface, spreadsheet use and menu.

Authorization

There is a need to provide an authorization since the spreadsheet is using Google Apps Script to automate some of the process.
⁠
Loading…
⁠
⁠
⁠

Step 3: OBE Custom Menu

There is an OBE Custom menu that specifically written for this spreadsheet.
There might be important to understand the concept of how these were arranged.
⁠
Loading…
⁠
⁠
⁠

Step 4: Subject Info

Subject Info submenu consists of a few tabs
Info (this tab appears in all submenu because the main buttons are here)
COPPA-2
PLO List
PLO-CLO Map

Set up the Subject Information

⁠
Loading…
⁠
⁠

Managing the student list

⁠
Loading…
⁠
⁠
⁠

Step 5: Delivery Plan

Delivery Plan submenu consists of a few tabs;
most of this tabs is useful in planning the Teaching and Learning (TnL) as well as reporting the TnL process.
Info
Plan
Attendance
Attendance Mail
Links

Planning the Delivery

⁠
Loading…
⁠
⁠


Managing the Attendance

⁠
Loading…
⁠
⁠


⁠

Step 6: Assessment Plan

Assessment Plan submenu consists of a few tabs;
most of these tabs are related with Table of Specification (ToS)
Info
ToS Exam
ToS Coursework
ToS Analysis
ToS Analysis Chart

IMPORTANT: Working with the Table of Specifications and ToS Charts

⁠
Loading…
⁠
⁠
⁠

Step 7: Mark Entry and Result

Mark Entry and Result submenu consists of a few tabs
Info
Mark Entry Exam
Mark Entry Coursework
PLO Analysis
CLO Analysis
CQI
Result

Info: Student List

⁠
Loading…
⁠
⁠

Step 1: Get a copy
Naming the File
Sharing the file with HOP
Step 2: Understanding the Spreadsheet
Authorization
Step 3: OBE Custom Menu
Step 4: Subject Info
Set up the Subject Information
Managing the student list
Step 5: Delivery Plan
Planning the Delivery
Managing the Attendance
Step 6: Assessment Plan
IMPORTANT: Working with the Table of Specifications and ToS Charts
Step 7: Mark Entry and Result
Info: Student List
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.