tag:blogger.com,1999:blog-61589950559848498852024-03-18T20:22:02.108+08:00Sir Sherwin's Computer TutorialSherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.comBlogger50125tag:blogger.com,1999:blog-6158995055984849885.post-79839982343045573892022-02-27T13:12:00.005+08:002022-02-27T13:12:54.853+08:00 How to LINK data from one Google Sheet Workbook to another Google Sheet Workbook. How to LINK data from one Google Sheet Workbook to another Google Sheet Workbook. 1. Open the Google Sheet Workbook, in this example, A Google Sheet Workbook of my school forms name as "School Forms and Grades TEMPLATE"- SCHOOL FORMS TEMPLATE- ELECTRONIC CLASS RECORD FOR SENIOR HS2. Make a copy of these two Wotkbook and save it on your own Google Drive Folder. I suggest that you use Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com6tag:blogger.com,1999:blog-6158995055984849885.post-82445145628362420592022-02-06T13:14:00.003+08:002022-02-06T13:14:41.976+08:00Generate your own Automated Report Card with these formulasAutomate your Report Card with these easy Google Sheet formula. In this lesson you will learn how to use the formula INDEX and MATCH in Google Sheet. In order for you to do the tasks, I provided a sample TEMPLATE of SUMMARY and REPORT CARD which we are using in our centralized grading system in our school. Here are the Steps:1. Open your Summary in Google Sheet. In our school we alreadySherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com12tag:blogger.com,1999:blog-6158995055984849885.post-7287136845723311452022-02-03T21:55:00.000+08:002022-02-03T21:55:26.958+08:00RECORD YOUR GOOGLE MEET FOR FREE If you want to record your Google Meeting for free, there are different ways to do it. In this tutorial you will learn how to stream it on your private FACEBOOK GROUP and record it at the same time.Here are the requirements: 1. A Facebook Group set to private settings where only your students are added as members. 2. OBS Software - A free software used for live streaming.&Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com13tag:blogger.com,1999:blog-6158995055984849885.post-19480075925134397462022-02-01T22:36:00.003+08:002022-02-01T22:36:54.498+08:00Student Automated Report Card Request using Google FormThis tutorial will teach you how to make a automate the report card distribution on your students. This will lesson will require you the following 1. Create a Google form Request - A Google form where students will enter their Name and LRN. Once the LRN is entered, it will automatically trigger the form to retrived the Grades from SUMMARY GRADE SHEET of the adviser which is also located in Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com1tag:blogger.com,1999:blog-6158995055984849885.post-90916462370861117492022-01-18T09:58:00.002+08:002022-01-18T10:44:01.440+08:00Managing Gmail - Simple Steps Too many messages on your inbox? Try these simple steps to manage your email in your Google Accounts. Steps: 1. Log in to your Google account and go to your Gmail App. 2. Click the Settings icon located at the upper right corner of your window4. Click the See all settings button 5. Select Inbox then under Categories, check all the boxes (Social, Promotion, Updates and Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com1tag:blogger.com,1999:blog-6158995055984849885.post-56892642328828343272021-03-06T22:02:00.008+08:002021-03-06T22:02:50.581+08:00GIMP Tutorial - How to Remove Background There are many ways on how to remove background in GIMP, one way is to use the Free Select Tool. This tools is similar with the selection tool of Adobe Photoshop, but the only difference is this tool is just like a combination of Lasso Tool and Path tool of Adobe Photoshop. Here is my video tutorial on how to remove a background in GIMP. Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com4tag:blogger.com,1999:blog-6158995055984849885.post-73357066140267934882021-03-06T19:30:00.000+08:002021-03-06T19:30:11.104+08:00GIMP Tutorial - How to download and install GIMP is an image editing software, an alternative for Adobe Photoshop. You can install it on Operating System like GNU/Linux, OS X, Windows and more. GIMP is an Open Source software, meaning, you can change its source code and distribute your changes.If you are a photographer, animator, graphic designer, illustrator, programmer, GIMP is truly a good choice because it has Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com3Quezon City, Metro Manila, Philippines14.6760413 121.0437003-13.634192536178846 85.8874503 42.986275136178847 156.1999503tag:blogger.com,1999:blog-6158995055984849885.post-51922063324188773572020-09-22T20:24:00.006+08:002020-09-23T18:17:28.752+08:00How to download and Install O365 in your own computer How to download and Install O365 in your own computer According to Microsoft website, Microsoft 365 is the productivity cloud designed to help users accomplish tasks with best-in-class Office apps, intelligent cloud services, and advanced security.If you want to download and install the Office 365 in your computer, you need to know first if your computer specification is compatibleSherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com5tag:blogger.com,1999:blog-6158995055984849885.post-82603814086100789322020-09-18T21:04:00.004+08:002020-09-18T21:23:50.078+08:00How to log in your DepEd O365 Account Step by Step How to log in your DepEd O365 Account Step by Step According to DepEd, every DepEd personel will receive a Microsoft Office (O365) account. The following are the licenses currently assigned to each DepEd Personnel: Office 365 A3 for facultyInformation Protection for Office 365 - StandardEducation AnalyticsInsights by MyAnalyticsMicrosoft Kaizala ProWhiteboard (Plan 2)Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com25Philippines12.879721 121.774017-15.430512836178846 86.617767 41.189954836178842 156.93026700000001tag:blogger.com,1999:blog-6158995055984849885.post-84654164129616200902020-07-23T08:01:00.003+08:002020-07-23T08:01:36.070+08:00Computer Systems Servicing NCII in PowerPoint format
POWERPOINT LESSON FOR COMPUTER SYSTEMS SERVICING NCII TEACHERS
To all Computer Systems Servicing NCII teachers, trainers and students, here are my customized PowerPoint Presentations of my lessons in Computer Systems Servicing NCII. Feel free to download it here. You get it free, so share it to others too. Cheers fellow teachers and CSS Trainers!Just click the link below.
PowerPoint Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com13tag:blogger.com,1999:blog-6158995055984849885.post-34667073123575064972020-06-23T07:45:00.000+08:002020-06-23T10:27:32.137+08:00Utilizing Blogger in Teaching
Teachers can use Blogger as a medium for their teaching online. Since Blogger is a free app of Google that enables the user to create unique content and interact with its viewers, this Google app is one of the popular tools by teachers.
Creating a Blogger account requires Google account, so follow the steps in this video in creating a Google Account.
Next, once you have Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com8tag:blogger.com,1999:blog-6158995055984849885.post-72985650847980401082020-03-04T19:58:00.000+08:002020-03-05T07:08:16.336+08:00Graduation Program in easy to edit and Customize file in PSD (Photoshop) format. Free!
To my fellow ICT Coordinator needing a ready made Graduation Program, here is my easy to edit and Customize file in PSD (Photoshop) format.
Design: Blue wave - Front and Back (2 Fold)
Download it here
Design: Blue wave - Inside (2 Fold)
Download it here
Design: Orange wave - Front and Back (2 Fold)
Download it here - Design: Orange wave - Front Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com16tag:blogger.com,1999:blog-6158995055984849885.post-17805435460548775402012-07-23T22:51:00.004+08:002022-02-01T22:47:51.506+08:00TABLE OF CONTENTS
COMPUTER SYSTEMS SERVICING NCII
Course Outline in CSS NCII
List of suggested activites for CSS NCII
Download CSS NCII Android App V. 1 by Sir Sherwin
INTRODUCTION TO COMPUTER
Parts of Desktop Computer
Setting Up a Desktop Computer
Parts of System Unit
Storage DeviceWhat is a Video Card Adapter?
Types of Memory
Parts of Motherboard
How to get Motherboard Manufacturer Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com24tag:blogger.com,1999:blog-6158995055984849885.post-2318896756194166202012-06-30T00:28:00.000+08:002013-11-01T11:37:29.803+08:00Best Online Web Page design tutorial for students and teachers
One of my student in high school ask me about the best website that they could use as a reference in web page designing. So as response to his question, I decided to post here some of the best website I am currently using as my references in teaching. These websites are also good for those who are studying alone.
W3schools
This website is a good reference for those who are Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com7tag:blogger.com,1999:blog-6158995055984849885.post-19815445588112282872012-05-27T08:47:00.000+08:002012-05-27T08:47:48.943+08:00Testing the Hard Disk Drive
Hard Disk Drive is also known as hard drive. This is the computer's main storage device used to store all data on the computer permanently. Commonly, hard drives are permanently place in an internal drive bay at the front of the system case and are connected with either ATA, SCSI, or a SATA cable and power cable. Some Hard drives nowadays are portable which use USB ports and USB cable for Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com9tag:blogger.com,1999:blog-6158995055984849885.post-72982622937495871372012-05-26T10:16:00.003+08:002012-05-26T10:33:41.121+08:00Testing The Memory
Memory failure can cause different problem on your computer. You have learned that the memory will be the one to handle the program that will enable the computer to start so if it is not working you might experience the following problems.
1. Computer has no display and you get a beep code. In some motherboards it is a long beep sound.
2. Computer always restart that might Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com2tag:blogger.com,1999:blog-6158995055984849885.post-85019162878767266672012-05-22T20:05:00.001+08:002012-05-22T20:10:55.128+08:00Use DirectxDiagnostic Tool to diagnose your computerDiagnostics is done by a computer technician to test a computer hardware or software to make sure that it is working as it should be. It is important to test the hardware and software are installed.
To measure the computer hardware and software performance, a benchmark is done. Benchmark is a type of test where results are used to compare how well a product may do against Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com1tag:blogger.com,1999:blog-6158995055984849885.post-51829113242726109612012-05-01T23:53:00.004+08:002012-05-02T00:00:11.356+08:00Know the Fn key function on your Laptop Keypad!
Most Laptop and Mini-laptop computer have the Fn key or function key on their keypad. This key is usually located below the keypad, beside Ctrl Key. It is usually used primarily to activate special laptop function together with other keys marked by special icons and are color coded. Below is the Fn Key between Ctrl and Windows Logo key.
The image below is the key used to combine to Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com3tag:blogger.com,1999:blog-6158995055984849885.post-78740150375792798542012-04-24T14:23:00.000+08:002012-09-21T09:54:01.460+08:00Manage Wireless Security on your router
What is Wireless?
Wireless or Wi-Fi technology is another way of connecting your computer to the network without using wires. Wi-Fi uses radio frequency to connect wirelessly, so you have the freedom to connect computers anywhere in your home or offce network.
Some of my friends who own a wireless router at home always ask me how they could assign wireless security, because Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com10tag:blogger.com,1999:blog-6158995055984849885.post-33941198147853779482012-04-24T10:52:00.002+08:002014-06-15T23:08:44.238+08:00How to access the router
This tutorial will give you basic knowledge about router, the different types, brand and model . It is important for a computer technician to be familiar with routers. So let us discuss first the types of router.
The role of router is to route packets to other networks until that packet ultimately reaches its destination. One of the key features of a packet is that it not only Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com21tag:blogger.com,1999:blog-6158995055984849885.post-77769280414822161442011-10-19T00:50:00.000+08:002011-10-19T00:52:44.872+08:00Using Deep Freeze on your computer - A guide to computer technicians
Most of my students in Xavier Technical Training Center always ask me how they could maintain their computer running smoothly, and prevent the downtime on their units. Some of them were asking how they could prevent others who also use their laptop or desktop computers from changing any settings on it, installing some programs they don't want for example. In computer maintenance solution, aside Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com8tag:blogger.com,1999:blog-6158995055984849885.post-87205223790580823662011-10-04T23:58:00.002+08:002013-11-01T08:06:11.254+08:00Common cause of Blue Screen of Death (BSOD)
What is Blue Screen of Death?
Blue Screen of Death or BSOD for short is also known as a bluescreen because of a full blue screen generated by Microsoft Windows Operating System.
What are the cause of Blue Screen of Death and how to Fix it? BSOD in computers might be a cause of Hardware or Software issue. Here are some of the cause of blue screen of death.
1. Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com3tag:blogger.com,1999:blog-6158995055984849885.post-75917060493330963112011-09-05T23:12:00.001+08:002011-10-06T06:43:26.625+08:00Detect if your username has been hackedDo you want to know if your e-mail or social networking account has been hacked? More often, a computer user has the same password on more than one web page, So in order to know if your account was been used by other people try this website. ShouldIChangeMyPassword.com. This is a good website that has a database of several hundred thousand publicly posted hacked accounts and will report if your Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com3tag:blogger.com,1999:blog-6158995055984849885.post-79569890600330507632011-08-05T02:43:00.002+08:002014-10-03T07:47:09.214+08:00How to Maintain a Public School Computer Laboratory without extra expenses
Maintaining a Public School Computer Laboratory is a big challenge to us. In our school, and I know other schools had this same problem. How they will maintain the computers being donated to them without any technical support or any financial support? Computer programs and computer parts do malfunction, and when they do, we in a public school do not have any fund to buy for a replacement, pay Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com2tag:blogger.com,1999:blog-6158995055984849885.post-61464198707413466762011-05-06T10:58:00.001+08:002011-10-06T06:47:17.551+08:00Creating Disc image file with Nero
Most of my students always ask me how they could back up their installation disc. I recommended them to use Nero or any ISO converter so they could create an image file of their installers and other important files. An CD image file usually have a filename extension .iso, .nrg, .tib depending upon the software you use to create the image file.In this tutorial Nero burning software is used to Sherwin Maningashttp://www.blogger.com/profile/04647488373092575707noreply@blogger.com2