New! Updated MAPEH V5 ECR! MAPEH is 1 subject now! Not 2 separate subjects! Make sense?
MS Account Checker V1
by BNAHS ICT Coordinator
Download MSAC (xlsm):
For checking if Grade 9/10 learners have MS Account for CB-NCAE Form 2.
Required Files:
SF1 files
MS accounts CSV
Instructions:
Click Import SF1 Files, select all sections, code will scan and copy all names, gender, and LRN arranged in the specified order.
Click Import MS Users CSV, locate your file, code checks if LRN from the checker sheet has a match in csv file.
Copy the generated data (select all names, gender, with account, without account checkboxes), then paste to the link provided by Division ITO after generating. Use Ctrl+Shift+V when pasting to prevent altering the formating in destination sheet.
Screenshot:
Download Instructions:
After download, right click the file, click Properties
2. Check Unblock then click OK.
3. Open the file and click Enable Content.
