🌟 Hit star button to save this repo in your profile
Google Sheets is a versatile and user-friendly tool for data analysis, enabling you to input, cleanse, visualize, and glean insights from your data. It encompasses essential functionalities like data cleansing, chart generation, fundamental and advanced formulas, as well as data filtering and sorting, coupled with pivot tables and conditional formatting, rendering it exceptionally well-suited for a broad spectrum of analytical endeavors. With its real-time collaborative features, sharing capabilities, and the capacity to construct interactive dashboards, Google Sheets represents an outstanding choice for individuals and teams alike, aiming to undertake data analysis within a collaborative and easily accessible framework, especially when dealing with modest datasets and straightforward computations. This assignment necessitates performing data analysis using Google Sheets' tools.
📊 Begin by thoroughly reading the provided case study and the following instructions to gain a clear understanding of the task at hand. The primary objective of this assignment is to process and visualize data using Google Sheets. You will work on two distinct case studies: one involving Examination results and the other concerning Sales performance. The case study information is as follows:
| No | Case Study | Instruction | Dataset |
|---|---|---|---|
| 1. | Examination results |  |
 |
| 2. | Sales performance | |
|
🚀 Form project teams comprising a minimum of three and a maximum of four students. Teamwork is essential for this assignment. Please complete the Google Sheets page with your group information here.
🚫 Uphold the highest standards of academic integrity. Any candidate suspected of cheating in the assignment will face disciplinary action, which may include suspension or expulsion from the University. Moreover, any materials or devices found to be in violation of examination rules and regulations will be confiscated.
📝 Prepare a comprehensive document that outlines the step-by-step process for creating the case study. This document should include details about the formulas used. Additionally, you must submit a Google Sheets file containing the results of the case study's execution.
The deadline for submission is October 26, 2023, at 3:30 PM. Late submissions will not be accepted and will be disregarded.
You must place your file in the submission folder. Within the submission/ass1/ folder, create a folder called your group. Name the default file as readme.md. You can refer to the documentation template here. Suggested folder structure for this project:
assignment/your_group/
├── 📁 case_study1a/
│ ├── 📄 readme.md
│ └── 📄 google_sheets
└── 📁 case_study1b/
├── 📄 readme.md
└── 📄 google_sheets| No | Group | File |
|---|---|---|
| 0. | Sample |  |
| 1. | DEADPOOL | |
| 2. | ohSheet | |
| 3. | GPS | |
| 4. | sheemart | |
| 5. | ATG | |
| 6. | KHUCHIN | |
| 7. | GanTheGang | |
| 8. | 3H | |
| 9. | HANY | |
| 10. | ByteNav | |
| 11. | SEK KITO | |
Please create an Issue for any improvements, suggestions or errors in the content.
You can also contact me using Linkedin for any other queries or feedback.