Courses‎ > ‎Computer Applications‎ > ‎

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

excel logo
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 using this document

The Assignment

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, 17-25, 27, 29). 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



blueprint
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 Assignment

Use Excel to create a blueprint or floor plan for your dream house. Make sure to label your plan. Furnish for an extra touch.

Hall of Fame:



Google Sheets Project Planner

plan
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 Assignment

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 (your's should look similar).

This link will be your main instruction guide for completing this project. You should complete steps 1.1 - 1.4, 2.4, & 2.5 from the link. The other steps are optional. You may work with up to two other people. One person needs to have ten tasks, groups of two need fifteen tasks, and groups of three need twenty tasks. This link will be helpful for inserting a data picker. 

*Points will be awarded/lost based on the Creative/Original Computer Rubric - 25 Pts.

Guiding Questions:
  • Did you add a note to give people directions on using the document?
  • Did you add a date picker to the date column?
  • Are your status items formatted as conditional dropdowns (change color with different words)?
  • Do you have comments on different tasks?
  • Do you have the number of required tasks?
  • Are the tasks related/relevant to a restaurant expansion or addition?
  • Is the spreadsheet formatted appropriately (titles, headings, colors, fonts, etc.)
After completing the assignment, use the 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 Schoology. 



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 and insert a chart (with customizations).

The Assignment - Google Sheets Import Data 10 pts

directionsUse 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. 
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.