Fundamentals of Business Analytics PDF Learning Module 01

LM01-BABA 0113 Learning Module Fundamentals of Business Analytics Knowledge Area Code :...

LM01-BABA 0113 Learning Module Fundamentals of Business Analytics Knowledge Area Code : BSBA Course Code : BABA0113 Learning Module Code : LM01- BABA0113  Learning Module 01 Fundamentals of Business Analytics First Edition, 2020 Copyright. Republic Act 8293 Section 176 provides that “No copyright shall subsist in any work of the Government of the Philippines. However, prior approval of the government agency or office wherein the work is created shall be necessary for exploitation of such work for profit. Such agency or office may, among other things, impose as a condition the payment of royalties. “ Borrowed materials included in this module are owned by their respective copyright holders. Every effort has been exerted to reach and seek permission to use these materials from their respective copyright owners. The University and authors do not claim ownership over them. Published by the Bataan Peninsula State University President: Gregorio J. Rodis, PhD Learning Module Development Team Writers: GATHERZON D. DE LEON, Instructor 1 Evaluators: Evaluator 01 (First Name, Middle Initial, Last Name), Position Evaluator 02 (First Name, Middle Initial, Last Name), Position Evaluator 03 (First Name, Middle Initial, Last Name), Position Quality Management Team: Arlene I. Pascual Focal Person, University Gender and Development Cristina G. Rivera Chair, Oversight Committee on Curriculum Development Arlene D. Ibañez Chair, Oversight Committee on Textbook and Instructional Materials Jesselyn C. Mortejo, EdD Director, Quality Assurance Office Emmanuel C. Macaraeg, PhD, CESE Vice President for Academic Affairs Learning Module: Fundamentals of Business Analytics ii  Netiquette Guide for Online Courses Netiquette Guide for Online Courses It is important to recognize that the online classroom is in fact a classroom, and certain behaviors are expected when you communicate with both your peers and your instructors. These guidelines for online behavior and interaction are known as netiquette. Security Remember that your password is the only thing protecting you from pranks or more serious harm.  Don't share your password with anyone.  Change your password if you think someone else might know it.  Always log out when you are finished using the system. Appearance Bear in mind that you are attending a class, dress appropriately. General Guidelines When communicating online, you should always:  Treat your instructor and classmates with respect in email or any other communication.  Always use your professors’ proper title: Dr. or Prof., or if in doubt use Mr. or Ms.  Unless specifically invited, don’t refer to your instructor by first name.  Use clear and concise language.  Remember that all college level communication should have correct spelling and grammar (this includes discussion boards).  Avoid slang terms such as “wassup?” and texting abbreviations such as “u” instead of “you.”  Use the prescribed font Palatino Linotype and use a size 10-point font.  Avoid using the caps lock feature AS IT CAN BE INTERPRETTED AS YELLING.  Limit and possibly avoid the use of emoticons like :) or J.  Be cautious when using humor or sarcasm as tone is sometimes lost in an email or discussion post and your message might be taken seriously or sound offensive.  Be careful with personal information (both yours and other’s).  Do not send confidential information via e-mail. Email Netiquette When you send an email to your instructor, teaching assistant, or classmates, you should:  Use a descriptive subject line.  Be brief.  Avoid attachments unless you are sure your recipients can open them.  Avoid HTML in favor of plain text.  Sign your message with your name and return e-mail address.  Think before you send the e-mail to more than one person. Does everyone really need to see your message?  Be sure you REALLY want everyone to receive your response when you click, “reply all.”  Be sure that the message author intended for the information to be passed along before you click the “forward” button. Learning Module: Fundamentals of Business Analytics iii  Netiquette Guide for Online Courses Netiquette Guide for Online Courses Message Board Netiquette and Guidelines When posting on the Discussion Board in your online class, you should:  Make posts that are on topic and within the scope of the course material.  Take your posts seriously and review and edit your posts before sending.  Be as brief as possible while still making a thorough comment.  Always give proper credit when referencing or quoting another source.  Be sure to read all messages in a thread before replying.  Don’t repeat someone else’s post without adding something of your own to it.  Avoid short, generic replies such as, “I agree.” You should include why you agree or add to the previous point.  Always be respectful of others’ opinions even when they differ from your own.  When you disagree with someone, you should express your differing opinion in a respectful, non-critical way.  Do not make personal or insulting remarks.  Be open-minded. (Source: http://teach.ufl.edu/wp-content/uploads/2012/08/NetiquetteGuideforOnlineCourses.pdf) Learning Module: Fundamentals of Business Analytics iv  About the Faculty About the Faculty Gatherzon D. De Leon the writer of this module is a graduate of Bachelor of Science in Computer Science at AMA Computer University, Project 8, Quezon City and in Research Project of Master of Information Technology at Technological University of the Philippines, Manila. As fresh college graduate, he worked as Computer Programmer at SRF Security Agencies in Paranaque City. A former Computer Laboratory Facilitator and fulltime faculty of AMA Computer Learning Center, Balanga City and a former part time faculty of Philippines Women’s University, Balanga City. Mr. De Leon is currently Instructor at Bataan Peninsula State University Balanga Campus. Among the subjects he handles are Business Application Software, Fundamentals of Business Analytics, Fundamentals of Data warehousing, Fundamentals of Descriptive Analytics, Fundamentals of Predictive Analytics and Fundamentals of Prescriptive Analytics. A qualified Computer Programmer as assessed under the TESDA Occupation Qualification and Certification System. He passed the 4 modules for granting of the International Computer Driving License. Mr. De Leon attended the training in CISCO Certified Network Associate Boot camp in Manila, R for Business Analytics held at UP Diliman and seminar in Industry- Academy Business Analytics Conference at University of Asia and the Pacific, Pasig. Learning Module: Fundamentals of Business Analytics v  Table of Contents Table of Contents Page Course Packet #01 Introduction to Google Applications 6 Course Packet #02 Business Function VS Business Process 30 Course Packet #03 Understanding Information System 52 Course Packet #04 Business Intelligence (BI) 71 Course Packet #05 Business Analytics 95 Learning Module: Fundamentals of Business Analytics vi  Course Overview Course Overview Introduction This course aims to provide the students with application that help organization develop insight to make decision from current data that maximizes the organization goals. Key Learning Competencies The course provides students with an overview of the current trends to business analytics that drives today's business. The course will provide understanding on data management techniques that can help an organization to achieve its business goals and address operational challenges. Course Details:  Course Code: BABA0113  Course Title: Fundamentals of Business Analytics  No. of Units : 2 lecture units 1 laboratory unit  Classification: laboratory-based  Pre-requisite / Co-Requisite:  Semester and Academic Year: First Semester A Y. 2020-2021  Schedule: BSBA 3OM  Name of Faculty: Gatherzon D. De Leon  Contact Details Email: [email protected] Mobile Number: 09292026983 Viber: Messenger: Gatherzon Gaddy De Leon  Consultation Day: Time: Learning Management System Google Classroom BSBA 3OM Fundamentals of Business Analytics Class Code: Facebook Account: Kompyuter Labtwo Assessment with Rubrics Midterm Examination – Week 9, Coverage Course Packet 1 – 5 Final Examination – Week 18, Coverage Course Packet 6- 9 Final Requirement with Rubrics Data Analysis of the Data collected Learning Module: Fundamentals of Business Analytics 1  Rubrics Meets Approaches Needs Excellent expectations expectations improvement Criteria Course Overview 41-50 31-40 21-30 1-20 A complete Incomplete A complete solution is solutions are A complete solution is tested Procedures implemented on implemented on solutions runs and runs but not the required the required without error. meet all the platform but has platform. Does specifications. logical errors. not run. Collected all Execution the Collected most of Collected some Did not collect appropriate the needed data. meaningful data. meaningful data. data. Most methods Statistical Some methods Statistical were correctly methods were were applied but methods were Methods applied but more fully and with significant completely could have been correctly errors or misapplied or done with the applied. omissions. absent. data. Results and discussion well Analyzed only Entirely missed Discussion focused and Missed some the most basic the point of the included all important points. points. experiment. important points. Grading System Class Standing Percentage Midterm Final Assignment/Activities – Class Standing - Class Standing - 50% Modules 67% 67% Assessment Tasks – After Term Exam - 50% Term Exam - 33% each topic 33% TOTAL 100% Final Rating 60% transmutation will be used. You should Midterm Grade (50%) + Final Grade get at least 60% of the total score. (50%) = Final Rating Learning Module: Fundamentals of Business Analytics 2  Course Policy Course Policy Course Overview 1. Policy on submission of requirements Make sure you joined the google classroom intended for your section. All Assignments, Activities, Assessments and other requirements intended for each lesson should be submitted on our google classroom. They should be submitted on the week they are intended for. Example Week 1 Course Packet 1 – Topic 1 Intended for 1 week, that means August 10-16. Anytime these days you can submit your work or perform the activities. Pre-assessment, activities, assignment, assessments, post-assessment will be posted in our google class. Keep on following instructions 2. If face to face class is not possible, keep yourself updated, communications will be through Facebook Messenger and Google Class. 3. Policies on Student Manual will be implemented. For face to face classes: 4. Students should be responsible for keeping the classroom clean and organize. Class officers will facilitate and initiate the cleaning of classrooms. 5. The use of cellphone and other gadgets is not allowed except if they will be used for classroom activities allowed by the instructor 6. To know their status in the midterm period and how their grades are actually computed, students will be computing their Midterm Grade 7. Attendance Students are expected to attend class and actively participate in class discussions. Every absence will be considered a deduction from your total attendance Be on time, 10 minutes grace period is given but being late for more than 10 minutes will be considered late and will be a deduction on your total attendance. If you are absent during the meeting, you can schedule a consultation with your professor. You will be considered dropped if you incur 20% absences of the total attendance. 6, Assignments/Exercises/Activities Learning Module: Fundamentals of Business Analytics 3  LM01-BABA 0113 Module 1 Overview Introduction Module 1 Overview Business analytics (BA) refers to the skills, technologies, practices for continuous iterative exploration and investigation of past business performance to gain insight and drive business planning. Business analytics focuses on developing new insights and understanding of business performance based on data and statistical methods. In contrast, business intelligence traditionally focuses on using a consistent set of metrics to both measure past performance and guide business planning, which is also based on data and statistical methods  Topic 01: Introduction to Google Apps  Topic 02: Business Function VS Business Process  Topic 03: Understanding Information System  Topic 04: Business Intelligence (BI)  Topic 05: Business Analytics (BA) Learning Outcomes Demonstrate understanding of business intelligence including the importance of data gathering, data storing, and data analyzing and accessing the data. And gain understanding of how managers use business analytics to formulate and solve business problems and to support managerial decision making Minimum Technical Skills Requirement Problem solving skills Critical thinking skills Knowledge of ‘database management systems’ Information systems management skills Knowledgeable in Business application software. Learning Management System Google Classroom BSBA 3OM Fundamentals of Business Analytics Class Code: Facebook Account: Kompyuter Labtwo Duration 18 hours lecture 27 hours Laboratory  Topic 01: Introduction to Google Applications = 4 hours Lecture 6 hours laboratory  Topic 02: Business Function VS Business Process = 3 hours Lecture 3 hours laboratory  Topic 03: Understanding Information System = 3 hours Lecture 6 hours laboratory  Topic 04: Business Intelligence (BI) = 4 hours Lecture 6 hours laboratory  Topic 05: Business Analytics (BA) = 4 hours Lecture 6 hours laboratory Delivery Mode Blended Learning (Synchronous & Asynchronous) Module Requirement with Rubrics Learning Module: Fundamentals of Business Analytics 4  Students are expected to follow instructions on the module and keep themselves updated through the Google classroom. Readings provided in this module or uploaded in Google class is expected to be read and Module 1 Overview understood. Scheduled online classes will be conducted to facilitate further learning. This module will cover the midterm examination. Activities, Assignments, Assessments are provided in Google class for enhanced learning. Learning Module: Fundamentals of Business Analytics 5  Course LM01- BABA Packet 01 0113 Learning Module Fundamentals of Business Analytics Course Packet 01 Introduction to Google Applications Knowledge Area Code : BSBA Course Code : BABA0113 Learning Module Code : LM01- BABA0113 Course Packet Code : LM01- BABA0113 Learning Module: Fundamentals of Business Analytics 3  Course LM01-BABA Packet 01 0113 Course Packet 01 Introduction to Google Applications Course Packet 01 Introduction These topics will cover aims to help students get a good high-level understanding the key concepts of Google Drive and Google Sheet. Objectives At the end of the lesson the students would be able to 1. Able to confidently navigate Google Drive 2. Identify that Google Sheets is a cloud-based spreadsheet program that can use anywhere. Learning Management System Google Classroom BSBA 3 Fundamentals of Business Analytics Class Code: Facebook Account: Kompyuter Labtwo Duration  Topic 01: Introduction to Google Applications = 10 hours (10 hours self-directed learning with practical exercises & assessment) Delivery Mode Asynchronous Assessment with Rubrics An essay type of assessment will be given Requirement with Rubrics No other requirement will be provided aside from the given Activities, Assignment and post assessment. Numerical rating will be used. Readings Refer to your Google classroom for the copy of Instructional Materials – Course Packet 01 and readings applicable to this topic. Learning Module: Fundamentals of Business Analytics 7  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  Course LM01-BABA Packet 01 0113 Course Packet Discussion Forum To be provided in Google class or during scheduled online class. Course Packet 01 Post-Assessment To evaluate your level of mastery in achieving the learning outcomes, validate the concepts learned and provide more opportunities to deepen your learning. You have to take an assessment test/quiz for the topic which will be in Google form and shall be available only for a considerable period of time. The link shall be posted in the LMS/Google classroom. You have to get 60% out of the total number of items to pass. Good luck! References. Books Zapier Inc. (2016), The Ultimate Guide to Google Sheets Online Resources 1. The Essential Google Spreadsheet Tutorial (n.d.). Retrieved from https://www.smartsheet.com/essential-google-spreadsheet-tutorial 2. Google Drive and Docs (n.d.). Retrieved from https://edu.gcfglobal.org/en/googledriveanddocs/ 3. How to create and find a spreadsheet in Google Drive (n.d.). Retrieved from https://railsware.com/blog/google-sheets-for- beginners/ Learning Module: Fundamentals of Business Analytics 24  Course LM01-BABA Packet 01 0113 Activity Sheet Activity Sheet Download the Activity Apple Store Product Sales in our google classroom then follow the instruction. Learning Module: Fundamentals of Business Analytics 25  Course LM01-BABA Packet 01 0113 Assessment Assessment 01 Assessment 1. Create Folder in your Google Drive named BA_Fullname_Section 2. Move any file from your drive to BA_Fullname_Section 3. Share folder name lastname_face in 5 of your classmates then insert the screen shot of their Facebook account to the shared folder including you. 4. Share google slide file in 5 of your classmates then insert their Name, Motto and Goals with explanation on the assign slide of the shared file including you. Note: Slides filename is Lastname_Mygoals_motto Note Different Group of classmates in google slides file and folders. 5. Copy the folders lastname_face and Slides Lastname_Mygoals_motto then paste it on BA_Fullname_Section folder. Write your answer to short bond paper. 1. If you want to display specific files while hiding others, you can __________. switch to Grid view choose a color for a folder download files apply a filter 2. Which types of files does Google Drive allow you to create and edit? Select all that apply. Documents Presentations Games Drawings Forms Spreadsheets 3. Which of the following allows you to easily group and organize your files in Google Drive? Groups Collections Stickers Folders 4. Suppose you share a Google Doc with three specific people. What will they need in order to open the file? A Facebook account Microsoft Office A Google account The document password 5. True or False: You can share a Google Doc without allowing other people to edit it. 6. True or False: Google Sheets saves your changes automatically. 7. A group of cells is called a ________. Multicell chart cell range cell cluster Learning Module: Fundamentals of Business Analytics 26  Course LM01-BABA Packet 01 0113 8. Which of the following features allows you to narrow down the data in your worksheet? Sorting Merge cells Assessment Relative cell references Filters 9. Formulas should always begin with a(n) ________. dollar sign equals sign header hashtag 10. Which of the following symbols are recognized as mathematical operators within Google Sheets? Select all that apply. * + ^ / x @ 11. Which function would you use to add the values of several cells? MAX AVERAGE SUM TOTAL 12. According to the order of operations, which calculation comes first in the following formula? =3^2/5+(12-3) 5+12 12-3 2/5 3^2 Learning Module: Fundamentals of Business Analytics 27  Course LM01-BABA Packet 01 0113 Assignment Assignment 01 Assignment Internet Research Differentiate the following: Business Function VS Business Process Information System VS Information Technology Learning Module: Fundamentals of Business Analytics 28  Course LM01-BABA Packet 01 0113 Learner’s Feedback Form Learner’s Feedback Form Name of Student: __________________________________________________________ Program : __________________________________________________________ Year Level : ______________ Section : __________________ Faculty : __________________________________________________________ Schedule : __________________________________________________________ Course Packet : Code : _________ Title : __________________________________ How do you feel about the topic or concept presented?  I completely get it.  I’m struggling.  I’ve almost got it.  I’m lost. In what particular portion of this course packet, you feel that you are struggling or lost? _____________________________________________________________________________ _____________________________________________________________________________ __________________________________________________________________________ Did you raise your concern to you instructor?  Yes  No If Yes, what did he/she do to help you? _____________________________________________________________________________ _____________________________________________________________________________ __________________________________________________________________________ If No, state your reason? _____________________________________________________________________________ _____________________________________________________________________________ __________________________________________________________________________ To further improve this course packet, what part do you think should be enhanced? _____________________________________________________________________________ _____________________________________________________________________________ __________________________________________________________________________ How do you want it to be enhanced? _____________________________________________________________________________ _____________________________________________________________________________ __________________________________________________________________________ Learning Module: Fundamentals of Business Analytics 29