Spreadsheet Software
Learning Goal:
Students will be able to use Microsoft Excel to create a variety of business documents
Students will be able to use advanced features in Google Sheets
Microsoft Excel has been the industry standard spreadsheet tool for decades. Some might argue that Excel (or some other spreadsheet software) is the most widely used tool in business. Many organizations will expect that you know how to use Excel as an entry level skill.
We will be using the following site as a resource for learning basic features in Word.
GCFLearnFree - Excel 2016 - Jump to the numbers using this link
In class, we will cover basic Excel skills and options together. We will cover tutorials 5 - 9, 13, & 16 from the GCFLearnFree site linked above. Click on this link to download a spreadsheet you will use to follow along and practice.
The Challenge
Use the GFCLearnFree site linked above to learn about Excel tools and options. Choose at least five lessons to explore and expand your knowledge (the ones we didn't cover together were 10, 12, 14, 15, 17-25, 27, 29, SKIP CHARTS). Create an Excel document and demonstrate the skills from each lesson. Make sure to label what you are demonstrating and which lesson you are covering. Try to use one spreadsheet when possible. When you are finished add your document to this collaborative page.
FALL 2022 - Team up with one other person and complete two tutorials listed above. Show me you were able to apply the skills when finished.
Excel or any spreadsheet software has practical applications outside of the traditional data tracking and analyzing. In class, we will look at how to use Excel to create simple blueprints. We'll look at setting a custom cell size (10 to 20 pixels) and talk about cell borders.
Here is an example blueprint.
The Challenge - Excel Blueprint 12 Pts
Use Excel to create a blueprint or floor plan for your dream house. Make sure to label your plan. Furnish for an extra touch. Show me when you are finished for credit.
It is common for businesses (as a whole or a team) to have many projects going on at one time. Google Sheets can be used to keep track of projects and responsibilities.
The Challenge - Project Planner 20 Pts (assessment)
Your restaurant is new, but business is booming. You are planning to expand your building to accommodate more customers. Use Google Sheets to create a project planner for the business expansion. This document would be shared with other teams members from your business.
We will look at this example in class (yours should look similar except with more tasks).
This link will be your main instruction guide for completing this project. You should complete steps 1.1 - 1.4 & 2.6 from the link. The other steps are optional. Use In Progress, Not Started, and Complete as your status column options, each one should change to an appropriate color. HINT: If you get the drop-down and conditional formatting to work with one cell, you can copy and paste that cell and keep those settings. This link will be helpful for inserting a date picker.
You may work with up to two other people. One person needs to have at least eight tasks, groups of two need fifteen tasks, and groups of three need twenty tasks.
Try searching for "project management tasks" or "business expansion tasks" or something similar for ideas. Tasks can be related to expanding your business beyond just the building. Maybe you are starting a new product line (eg. frozen food), developing partnerships with other businesses, or licensing your brand (eg. coke polar bears movie).
After completing the assignment, use this rubric to self-assess your work. Meet with me to discuss your score. Send a link (Share --> Get shareable link) to your finished project on Classroom.
Google Sheets & Importing Data
We will look at how to pull data into a Google sheet from various sources around the web. This would be helpful if you created a spreadsheet that relied on data that needed to be frequently updated (eg. interest rates).We'll also talk about creating basic charts and their ability to bring data to life.
I searched for "summer movie releases data table" to find this site. We will use this data as an example to practice in class. There will be no number after "table" in our formula (just for this site).
We will also look at how to:
copy the data without the import formula to a new sheet
filter our data (looks like a funnel)
search the Explore tool to analyze our data (lifetime gross over time)
insert a chart (with customizations)
copy charts to other documents
The Challenge - Google Sheets Import Data 10 pts
Use the Excell It! lesson, iPhone Games, as a reference when completing this project.
Find some data that can be imported into Google Sheets. I have given you two searches and data sets below that can be used, but feel free to find something else. Look for sites with data tables like the examples.
Searched for "popular iPhone app data" to find this site
Searched for "popular pizza data chart" to find this site
Use the import function we learned about to bring the data into Google Sheets. Copy the data to a new sheet and format it appropriately (title, font, colors, etc.). Insert a chart and format it using custom colors, correct labels, titles, etc. Add formulas to find column totals where appropriate (would apply to the links I provided).
When you are finished, show me in class and I will put in the grade.
ADD PIVOT TABLES??
