CP1.pdf

Course LM01-BABA Packet...

Course LM01-BABA Packet 01 0113 Introduction Key Points: What Is Cloud Computing? In this part, you may provide the key points of Course Packet 01 It is the delivery of different services through the Internet. These the topics being presented resources include tools and applications like data storage, servers, databases, in this particular Course networking, and software. Packet. Rather than keeping files on a proprietary hard drive or local storage device, cloud-based storage makes it possible to save them to a remote database. The key points may be As long as an electronic device has access to the web, it has access to the data and bulleted like this: the software programs to run it.  Key point 01  Key point 02 Understanding Cloud Computing  Key point 03 Cloud computing is named as such because the information being accessed is found remotely in the cloud or a virtual space. Companies that provide cloud services enable users to store files and applications on remote servers and then access all the data via the Internet. Definition of Terms: Cloud computing can be both public and private. Public cloud services You may provide provide their services over the Internet for a fee. definition of terms to facilitate better Types of Cloud Services understanding of the Email, Storage, backup, and data retrieval, Creating and testing apps, concepts being presented. Analyzing data, Audio and video streaming, Delivering software on demand You may adopt this format: Types of Cloud Computing  Software-as-a-service (SaaS) involves the licensure of a software application Term. Its definition, to customers. Licenses are typically provided through a pay-as-you-go model mostly technical. or on-demand. This type of system can be found in Microsoft Office's 365. G Term. Its definition, suite (also known as Google Apps) is an example of SaaS. mostly technical. Term. Its definition, mostly technical.  Infrastructure-as-a-service (IaaS) Term. Its definition, mostly technical.  Platform-as-a-service (PaaS) Answer the short exercise before proceeding with the content Hazard Alerts: Pre-Assessment 1. Give 3 examples of Business Industry in the Philippines that This may be in a form of use SaaS. notice, caution, or warning. Include appropriate hazard alert where and when needed. 2. What type of files do you use on a daily basis? On a weekly This should appear basis? before the conduct of an activity. Learning Module: Fundamentals of Business Analytics 8  Course LM01-BABA Packet 01 0113 3. Where are you when you access these files? What devices do you access them with? Course Packet 01 4. Can you think of any files you'd like to sync across multiple devices? 5. Of these files, could you use Google Drive to store them? 6. Think of a few situations when you might need to collaborate on a file with others. 7. Create a Google Slide Presentation of your personal information and activities during quarantine Picture is required to the google slide. Lesson Proper Lesson 01: Introduction to Google Applications Topic Outline: 1. Google Drive 1.1 Getting started with Google Drive / Why use Google Drive? 1.2 Google Drive for desktop and mobile devices 1.3 The Google Drive interface 1.4 How to import Google Sheet File to my selected folder. 1.5 Tips on Sharing Files and Folders with Google Drive. 1.5.1 Share a single item using a hyperlink 1.5.2 Share a single item using a link 1.6 Upload files in google drive 1.6.1 Upload files from your computer Learning Module: Fundamentals of Business Analytics 9  Course LM01-BABA Packet 01 0113 1.6.2 Upload files from your smartphone or tablet 1.6.3 Move file/folder drive to shared folder in Google drive Course Packet 01 2. Google Sheet 2.1 How does it compare to Microsoft Excel? 2.2 Basic terminology 2.3 How to create and find a spreadsheet in Google Drive. 2.4 Google Sheets Interface 2.5 Add and Formatting Data and Cells to Google Sheets 2.5.1 Format data in Google Sheets 2.6 How to use Google Sheets offline 2.7 Google Sheets formulas and functions 2.8 Sort Data in Google Sheets  Review We will begin this lesson by reviewing the several terms associated with file management. It is important to understand these terms in order to successfully organize and find the files you work with on your computer. File Management: The process and act of creating an organized structure in which you store information for easy retrieval. Drive: A drive is a computer storage device that holds information. It is the top-level location (or "Root" directory) for file storage. Drives are usually designated with a letter such as C:\ (which is typically the hard drive of the computer you are working on). Other examples of drives would be the network drive on campus (which is the Z:\ drive) and external USB drives that you may use such as a Flash or Thumb Drive. The letters of these drives vary depending on the computer that you are using. Folder: A folder is a storage location within a drive. Another term for a folder is a “directory”, however the term "folder" has become the term of choice for most. A folder can consist of files or additional folders (called "Subfolders"). Users can create folders that accommodate their method of organization. For example, you may want to store all your work for your English course in a particular area of your computer to make it easier for you to find. To do this you might create a folder on your C:\ drive named "English" and then within the "English" folder create two additional subfolders One for Papers and one for Journals. The folder structure would look like the example to the right. File: A file can be a document, spreadsheet, image, or other type of item that is stored on a computer. Files are typically associated with a program or software application that is needed in order to open the item. File Extension: The file extension appears after the period in the Learning Module: Fundamentals of Business Analytics 10  Course LM01-BABA Packet 01 0113 filename and is used to indicate the type of format the file is in. For example the file extension ".xlsx" indicates that the file is a Microsoft Excel worksheet. A complete filename using this extension may look like this: "Inventory.xlsx" Course Packet 01 Path: The path refers to the exact location of the file and indicates to the computer user the entire sequence that must be followed to find the file. The path begins with the drive and then includes any folders or subfolders that house the file. In the screenshot above, a Microsoft Word document named "paper1.docx" that is stored in the "Papers" folder would have the path: C:\English\Papers\paper1.docx. File Management Utility: A File Management Utility is a computer program that provides a user with a graphical interface in which he/she can organize files and folders on a computer's storage device. Zipping (Compressing): Zipping is the process of packaging a folder that contains multiple files into a single file (called a "Compressed" or "Zipped" folder). In addition to combining multiple files into one, the resulting zipped folder typically takes up less storage space. Knowing how to zip files is especially useful when you need to send multiple files to someone either (example: through email or an online course). A Zip folder has a ".zip" file extension and the icon for the zip folder typically looks like a folder with a zipper. In order for the recipient to view the files, they would first need to unzip (or Extract) the zipped folder to be able to access the individual items inside.  Activity. Let us start on how much you remembered: Create Folder; Open a new File Explorer window. Create a new folder, named lastname_review on your removable disk. Move any images files from the root directory of computer to the new folder. On the new created folder rename the folder as lastname_review_activity. Note: apply this review activity to your smartphone(File explorer is google drive)  Processing of the Activity. This course has a computer laboratory so it will start with a review in how the file is organized in google drive and My Computer.  Brief Lesson. 1. Google Drive It is a cloud-based storage service that allows you to download and upload files. With Google Drive, files can be accessed by you or others at different locations and from different devices. Google Drive is a safe place to keep any file– there are no file type restrictions and all data is encrypted, requiring you to grant permission for others to access, edit, or view the files. The Google Drive storage space you receive for free is 15 GB (Gigabytes) 1.1 Getting started with Google Drive Learning Module: Fundamentals of Business Analytics 11  Course LM01-BABA Packet 01 0113 If you have a Google account, then you already have access to Google Drive by going to http://drive.google.com in your web browser. You can also navigate to Google Drive from any Google page (such as Course Packet 01 Gmail or Google search) by selecting the grid icon near the top-right corner, then clicking Drive. 1.1.1 Google Drive for mobile devices It is a great idea to download the mobile application to enable access to your files regardless of where you go. To use Google Drive on your smartphone or tablet, you must first download the app from the Amazon App Store, Google Play, iOS App Store, or Microsoft Store. 1.2 The Google Drive interface Learning Module: Fundamentals of Business Analytics 12  Course LM01-BABA Packet 01 0113 Course Packet 01 Note: Look then numbers in google drive interface picture for the picture of each part of interface. 1. The Search bar allows you to look for specific files. Whenever you enter a search term, Google Drive will automatically display files that match your search. You can also run an advanced search, which allows you to filter your files by type. Integrated 2. + New Button - Click the New button to create a new document, spreadsheet, presentation, or other Google document. The new file will be saved to your Google Drive automatically. You can also use the New button to create new folders and upload files from your computer. A data warehouse is developed by integrating data from varied sources like a mainframe, relational databases, flat files, etc. Moreover, it must keep consistent naming conventions, format, and coding. 3. Click or tap the View/Layout icon to change the file and folder arrangement from list view to grid view. 4. Click or tap the View Details icon to view file details such as size, type, previews, and shared status. View Details icon also view all the activity in the google drive. 5. Left hand side of the browser window is a sidebar that organizes the content and features in an easy-to-digest layout. Learning Module: Fundamentals of Business Analytics 13  Course LM01-BABA Packet 01 0113  My Drive to view and manage the files stored on your cloud  Shared with me to view and manage other’s files stored on other Google Drive accounts that have been shared with you. Course Packet 01  Recent to view all recent Google Drive activity.  Starred to view all your favorite or important files.  Trash to view or empty items you placed in the trash for 1.3 How to import Google Sheet File to my selected folder On Google Sheet > Select File > Import then select the folder where you import your file. Or on PC using Right Click Close google sheet file then right click the file then select Move to select the folder where you move your file. We have many option in using Right Click Using a Phone Just tap the 3 dotted lines at the right top of the file or folder. 1.5 Tips on Sharing Files and Folders with Google Drive 1.5.1 Share a single item with specific people Use this method when you know the email address of everyone with whom you are sharing.  Open a file in Google Docs, Sheets, or Slides.  In the top right corner, click Share.  Under "People" in the "Share with others" box, type the email address of the person or Google Group you want to share with.  To choose if a person can view, comment, or edit the file, click the Down arrow next to the text box down arrow icon.  Click Done. The people you shared with will get an email letting them know you've shared a file. 1.5.2 Share a single item using a link Use this method when you don’t know everyone’s email address, aren’t sure if they all have a Google account, or simply want a document to be more widely available. You can have the link only available to the analytics community, or to the whole world.  Open a file in Google Docs, Sheets, or Slides.  In the top right corner, click Share.  Click "Get shareable link" in the top right of the "Share with others" box.  To choose whether a person can view, comment, or edit the file, click the Down arrow next to "Anyone with the link." down arrow icon. Learning Module: Fundamentals of Business Analytics 14  Course LM01-BABA Packet 01 0113  A file link will be copied to your clipboard. Paste the link in an email or anywhere you want to share it. Key Points: 1.5.3 Share the folder: Course Packet 01  Select the name of the folder in Google Drive. At the top, click In this part, you may Share. Tip: You can also right-click the folder and choose Share. provide the key points of the topics being presented  Under "People" in the "Share with others" box, type the email in this particular Course address of the person or Google Group with whom you want to Packet. share. Tip: Search for contacts by typing a name in the box.  Make sure their access level is set to “Can Edit.” The key points may be bulleted like this:  Key point 01 Note: See the presentation in our google class for smartphone or tablet.  Key point 02  Key point 03 1.6 Upload files to Google Drive 1.6.1 Upload files from your computer You can upload files a couple of different ways to Google Definition of Terms: Drive. You may provide 1. On your computer, sign in to Google Drive. If you have already set definition of terms to up folders on your Drive, navigate to the folder in which you want the facilitate better understanding of the file to live. If not, you can upload the file to the root of the Drive. concepts being presented. 2. Click the New button on the left side of the screen. 3. Choose File Upload. You may adopt this 4. In the File Upload dialog box, navigate to the file you want to format: upload on your hard drive and click Open. You can select multiple Term. Its definition, files with the Shift or Control key mostly technical. 5. At the bottom of the screen, you see the upload progress box. The Term. Its definition, box will say, “Uploads completed” when finished. mostly technical. Term. Its definition, mostly technical. 1.6.2 Upload files from your smartphone or tablet Term. Its definition, mostly technical. You can use the Google Drive app for iOS and Android to upload files to your Google Drive. First, download the app from the App Store or the Google Play Store, and sign in to your account. Hazard Alerts: 1. After you sign into your Google Drive account in the app, click the This may be in a form of notice, caution, or red circle with the plus sign at the bottom of the screen. warning. 2. Choose Upload. 3. In the Open From dialog box, choose where the file is located, such Include appropriate as Images or Downloads. hazard alert where and 4. Tap the file you want to upload. The file is transferred. when needed. This should appear 1.6.3 Move file/folder drive to shared folder in Google drive before the conduct of an activity. 1. View if the folder is available in shared with me drive. Select the file that you want to send to shared then make copy…The make copy file will send to starred Learning Module: Fundamentals of Business Analytics 15  Course LM01-BABA Packet 01 0113 Note: If folder will be moved; select Folder then add to starred 2. Add File / Folder to starred drive. Use right click in desktop or tap the 3 dotted lines in android. Course Packet 01 3. Click or Tap starred drive to view the file / folder that will be move from a shared file. 4. Right click the file / folder then select move to ------ shared with me then select the folder that shared. 5. Verify if the file/folder sent. Open the folder in shared with me… 2. Google Sheets Google Sheets is a cloud-based spreadsheet program that’s a part of Google’s office suite, called G Suite. Alongside Google’s other cloud-based services like Google Drive, Docs, Slides, and of course, Gmail, G Suite offers a comprehensive productivity platform for businesses and students alike. Google Sheets is a web-based spreadsheet application that allows you to store and organize different types of information, much like Microsoft Excel. 2.1 How does it compare to Microsoft Excel? The best comparison for Google Sheets is Microsoft Excel, which has been the leading spreadsheet program more than three decades. Those with Excel experience will have a much easier timing learning how to use Google Sheets, as it works almost exactly the same. For those who have a large catalog of documents in Microsoft’s program, you’ll be happy to learn that Google Sheets is entirely compatible with Excel files. You can convert the two back and forth with ease. The vast majority of established Excel functions have exact equivalents in Google Sheets. In fact, for the basic data management tasks we cover in this guide there is virtually no difference whatsoever between the two. For very advanced users, Excel offers slightly more powerful charting tools and support for extremely large datasets. Google Sheets is limited to 2 million cells of data. 2.2 Basic terminology Before we get into the nitty gritty of how to use Google Sheets, there are a few key terms you should know. They’re the same terms you’ll find in any other spreadsheet program, so you may already be familiar with them. Cell: A single data point in the spreadsheet, represented by a box. Column: A vertical set of cells. Row: A horizontal set of cells. Range: A specific selection of cells. Function: A built-in operation that can be called to manipulate data, calculate values, etc. Formula: Any combination of functions, cells, ranges, and operators used to calculate a value. Sheet/worksheet: A single “page” of rows and columns. Spreadsheet: A document containing one or more sheets of data. Learning Module: Fundamentals of Business Analytics 16  Course LM01-BABA Packet 01 0113 2.3 How to create and find a spreadsheet in Google Drive. Course Packet 01 To create a new spreadsheet, go to Google Drive. It contains folders and files, and you need to create a new folder by clicking + New on top. Let’s call it Google Sheets for Beginners. Click Create to proceed. After that you can create a new Google Sheet: Go to folder → Click + New on top → Google Sheets → select whether you want to create a blank sheet or use a template. For templates, you can either create and upload templates specific for your organization or use Google templates gallery. Let’s pick a blank sheet now. To create a spreadsheet with sheets new one of the coolest tricks with creating a Google spreadsheet is to use.new. Type sheets.new in your browser, and you get a new spreadsheet created right away! It is automatically saved on your Google Drive. Name the spreadsheet in the top left corner to find it easily next time using search in Google Drive. If you want to organize it, click on the folder icon. Here, you can either create a new folder to store this file or select an existing one. Learning Module: Fundamentals of Business Analytics 17  Course LM01-BABA Packet 01 0113 Course Packet 01 2.4 Google Sheets Interface Now that you’ve created a spreadsheet, it’s time to truly learn how to use Google Sheets. Before we get into entering and manipulating data with formula, take a moment to get familiar with the interface. When you first open a blank document, you’ll see something that looks like the image below. Here’s a brief description of what each element does to help you get more comfortable. 1. Spreadsheet name 2. Menu bar 3. Basic controls (undo, redo, print, format painter) 4. Zoom 5. Number formatting options 6. Text formatting options 7. Cell formatting options 8. Advanced controls and functions 9. Active cell Most of the interface is self-explanatory, but we’ll get more into the individual controls later in the guide. For now, it’s critical to understand how cell numbering works. This is the backbone of everything that a spreadsheet can do. Each column is labeled across the stop with a letter, and each row is labeled on the left with a number. A single cell is named by a combination of the two. For example, the active cell above is A1. A range including the first three Learning Module: Fundamentals of Business Analytics 18  Course LM01-BABA Packet 01 0113 cells on the left would be A1-A3. Note that while the active cell above is blue, the color may be different when multiple people are editing the same document. You will be able to see Course Packet 01 what every editor’s active cell is, which can help prevent mistakes caused by two people editing the same cell at once. It’s also worth mentioning that you can resize any row or column by clicking and dragging the border between it and an adjacent row. You can also add or delete entire rows or columns by right clicking and selecting the appropriate option from the drop-down menu. Cells Cells allow you to both store data and make calculations based on the data in other cells. Each cell has an index – a combination of the column and row indexes. Examples are A1, B2, C3, etc. Indexes are quite useful for selecting different cell ranges. For example, if you need to sum a specific range of cells, you can select them by clicking the first cell and dragging the entire range. However, if you have a much larger dataset to work with, you can type the cell index where the range starts, colon, and the last cell index. Thus, SUM (E2:E243) means that all the values starting from the cell indexed E2 to the cell indexed E243 will be summed. Here are the most common ways to select different ranges: (A2,A5) – to use only the values in A2 and A5. Ctrl (for PC) and click on the cells to select. (A2:A5) – to use all values in the cells from A2 to A5. Click on the first cell and drag to select other cells. (A:A) – to use all numbers in the column. Simply click on the column index to select it. (A3:A) – to use all values from A3 to the end of the column. (2:2) – to use values in row #2. Simply click on the row index to select it. (A2:2) – to use values from A2 to the end of the row. 2.5 Add and Formatting Data and Cells to Google Sheets The first real step to creating a functional spreadsheet is adding data. The easiest way to do this is simply click in a cell and type in the data directly. You can press the Enter key to move down to the next row, or Tab key to move right to the next column. However, this is far from convenient for large data sets. It can take hours to manually enter data (and will take hours to clean up for certain data sets), but you can save that time by importing entire tables at once. There are several ways to do this. The first is to simply select a table, copy it, and paste it directly into your document. You can use this method to copy lists and other data from websites or other sources with ease. The other method is to import an existing spreadsheet or supported file type. Virtually all popular spreadsheet file types are supported. How to import data to Google Sheets Learning Module: Fundamentals of Business Analytics 19  Course LM01-BABA Packet 01 0113 1. Click File, then Import. 2. Select or upload the file to import. Course Packet 01 3. Configure import options as necessary. 4. Click Import data. 2.5.1 Format data in Google Sheets The spreadsheet automatically recognizes the type of data you enter. The text is aligned on the left, numbers and dates – on the right. However, you can adjust the format manually. Use FORMAT to select the type of data you input. The buttons in the menu allow you to convert numbers into $ or %, as well as decrease or increase decimal places. You can manage text wrapping in each cell using this button in the menu. It allows you to overflow, wrap or clip text. Another option is to resize the columns manually. You can also add visible borders using this button in the menu. It is helpful in case you want to print the results. Select the cells you want to have visible Learning Module: Fundamentals of Business Analytics 20  Course LM01-BABA Packet 01 0113 borders and apply the corresponding option: all the borders, internal borders, one border in the top, bottom, left or right, and so on. The design of your borders (color and style) can be tuned as well. Course Packet 01 Merge cells in Google Sheets Merging cells is one of the most basic ways to format your spreadsheets, and it should be one of the first things you learn how to do. Thankfully, it’s also one of the easiest things you can do in the program. All you need to do is select more than one cell and click the merge icon in the upper middle of the toolbar. The icon has two arrows pointing together, and it’s greyed out unless you have more than one cell selected. 2.6 How to use Google Sheets offline One of the scariest things about switching to a cloud-based application is the thought of losing your internet connection. Thankfully, Google Sheets makes it easy to access and edit your spreadsheets, even if you’re temporarily offline. This only works in the Chrome browser, and you will need to sync your Google account to Chrome. To do this, click the People icon in the top right, then Sign in to Chrome. Once you’re signed in, head over to the Google Sheets website. Click the menu icon in the upper left, then Settings. In the middle of the window, you’ll see a toggle for Offline. Flip it and you’re good to go! Here are those steps again in brief: How to use Google Sheets offline 1. Navigate to the Google Sheets website. 2. Open the menu in the upper left and click Settings. 3. Turn on the option for Offline. 2.7 Google Sheets formulas and functions Learning Module: Fundamentals of Business Analytics 21  Course LM01-BABA Packet 01 0113 Formulas and functions are a hugely powerful part of any spreadsheet Course Packet 01 software, and Google Sheets supports both. But before we get into some of the advanced tasks, let’s talk about the difference between a formula and a function. A formula performs simple arithmetic on values or cells that you specify. A function performs a more complex tasks ranging from simple sums to payments on annuity investments or even pulling data from the web. The main thing to know as a beginner is that all formulas and functions start with =. This signals to Google Sheets that what you’re entering is a not simply text or a number. All formulas and functions start with the = symbol. Formulas are the easiest to use. Once you’ve typed =, you can enter specific numbers or refer to values in other cells by typing A1, A2, etc. You can then manipulate these values with +, -, *, and / symbols to perform basic arithmetic. Functions work similarly, but require more specific input. We won’t explain every function in this Google Sheets tutorial (there are hundreds of them), but you can see the full list by clicking on the ∑ symbol in the upper right. You can also search for them by beginning to type the function name after the = symbol in any cell. How to use the SUM function To give you some idea of how these work, let’s have a look at the SUM function. This function simply adds up all of the values in a given range. It looks like this: =SUM(values or range). Those values can be specific cells or numbers such as =SUM(10, A2, A3, 15) or a range =SUM(A1:A10). You can select a range with your mouse once you type =SUM(, then hit Enter when you’re finished and watch the program do the work for you! Use functions by clicking the ∑ symbol, selecting the function, then clicking Learn more at the bottom. Learning Module: Fundamentals of Business Analytics 22  Course LM01-BABA Packet 01 0113 Course Packet 01 2.8 Sort Data in Google Sheets Sorting data is a great way to analyze a data set at a glance, especially when it contains hundreds or thousands of points of data. To sort data in Google Sheets, all you need to do is select the entire table, click Data at the top of the page, then Sort range. Now you can select the column to sort by, but make sure to check the box for Data has header row if applicable. Otherwise it will be sorted with the rest of the data! Using this method, you can quickly sort any kind of data, whether it’s alphabetical, numerical, dates, times, or just about anything else. Here are those steps again in brief: How to sort data in Google Sheets 1. Select the entire table of data to sort, including headers. 2. Click Data at the top of the page, then Sort range. 3. Check the box for Data has header row if applicable. 4. Select the column to sort by. 5. Click Sort.  Enhancement Activity. Please refer to Activity Sheet No. 01.  Application. Refer to your Assessment Sheet 01 Learning Module: Fundamentals of Business Analytics 23