Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
IT1010 Fundamentals of Computer Science
Instructions
1. Excel Data Analysis Assignment
Objective:
Apply the data analysis techniques introduced in class to explore business insights using Excel Pivot Tables and charts.
Instructions
1. Download the dataset:
Download the file “YorkU Boba Shop Raw Data (1 week).xlsx.”
2. Recreate the analysis (Sheets 1–3):
Follow the tutorial to reproduce the same tables and charts demonstrated in the lecture.
You may also refer to lecture slides 9–10 for examples of the final chart format.
3. Design your own analysis (Sheet 4):
Create one additional analysis of your choice.
Your analysis should include:
o At least one Pivot Table
o At least one chart that visualizes your findings
4. Summarize your insights:
After completing your analysis in Excel, create one PowerPoint slide summarizing your key findings and recommendations.
o You can refer back to the three business strategies discussed in class:
(a) increasing customer count,
(b) increasing order frequency, or
(c) increasing order size.
o Choose a metric or idea that supports one of these goals.
Examples include:
• average preparation time
• refund rate by city
• customer ratings
• or any other variable that provides actionable insights for the business.
o Refer to lecture slides 9–10 for example layouts.
5. Submission format:
o Save your final Excel workbook as:
StudentID_FirstName_excel.xlsx
o Save your PowerPoint summary slide as a PDF file named:
StudentID_FirstName_summary.pdf
o Example: 210012345_Kevin_excel.xlsx
2. Python Programming Assignment
Objective:
Practice basic Python programming skills by completing code exercises in Google Colab.
Instructions
1. Download the notebook:
Download the file “IT1010_Python_Programming_Assignment.ipynb.”
2. Open in Google Colab:
Upload and open the .ipynb file in Google Colab.
3. Complete the exercises:
Write the correct Python code in the designated code cells provided in the notebook.
Ensure that all cells execute successfully and display the correct outputs.
4. Submission format:
o Download your completed notebook from Colab as a .ipynb file.
o Rename the file as:
StudentID_FirstName_python.ipynb
o Example: 210012345_Kevin_python.ipynb
Marking Criteria (10 marks in total)
Excel pivot tables and plots (4 marks)
o 3 marks -Recreate the analysis in in sheets 1–3.
o 1 mark- Design your own analysis in sheet 4.
One slide summarize of your analysis (1 marks)
Python programming exercises (5 marks)
o 2 marks- Complete exercises #1 - #8.
o 3 mark- Complete exercises #9.