MS Excel Graphing Final

Take two series of information and make one graph.

Test. Working in pairs, you will send me one Spreadsheet with three tabs.

Tab 1. Men's Mile time
Tab 2. Women's Mile Record
Tab 3. Combined Mile Run Record
Use these two links for references

Link 1

Link 2

FAQ's, Graphs and Minimum Wage

Today we are graphing the history of the minimum wage in the United States.

Use MS Excel to create a graph. Make the best graph that you can, because tomorrow you will have a MS Excel test on graphing.

Know how to

• Insert a graph
• Format a graph
• Select the correct type of graph
• Insert data

Time Tracking Application

Part 1

Beginning today, we will use a "time tracking computer application." You will continue submitting the Microsoft Excel spreadsheet but today you will also use Toggl (http://www.toggl.com/)

Go to the website and use your GMail account to create your own account.

Part 2

Today, we will also create a graph for the cost of gasoline for California. After you have created a graph for California, you will be able to create one single graph that compares the national cost of gasoline and the cost for California.

You may need to research the price for California and provide a link to your source. I will help if you have questions. Please try to solve the problem first.

BF

Charting: Using MS Excel to Chart Gas Prices

When I bought gasoline at the beginning of the school year, I paid about one dollar a gallon less than I did today.

How much has gasoline changed during the last twenty years?

Go to the R drive/ Excel folder and create a graph for the national averages. Notice that the national averages are much less than Bay Area gas prices.

Perhaps we will graph Bay Area gas prices Wednesday and then compare our graphs with the national prices.

For more information about the resource, please visit this link.


bf

Excelling at Excel

Friday. The End of the first week.

1. Finish your first week of time tracking. Send me the spreadsheet.

2. Research Excel Graphs for at least five minutes.

3. Create a graph and include the sheet with your spreadheet. Call it graphing1. Go to the R Drive, Excel Folder. Graphing 1 Spreadsheet.

For my students and parents who want more information, see my post at my other class blog.

Formatting MS Excel

In the Farley R Drive, there is a Folder called "excel." In this folder, there is a spreadsheet named 4-21.

Open the file.

There are 25 cells numbered 1 through 25. Today you will format those cells.

I want each row to have a border. I want you to color the entire 25 cells, and the border. I also want you to resize the columns and rows.

Send me the file and tell me what size you have made the rows and columns. Include this spreadsheets with your timesheet. I only want you to send one MS File today, so you may need to learn how to "Move and Copy" spreadsheets.

Send to my school email at the end of the class.

BF

Tracking Time in MS Excel

On Monday, you began tracking how you spent time in class. You also began using a new computer application: Microsoft Excel. 

Today, you have three activities.

• Answer the questions at the bottom and post in a blog.

• Two, Build your spreadsheet for the remainder of the school year. Try to create formulas that calculate total time spent on each category daily and weekly.

• Third, as required for the rest of the year, send the spreadsheet to me at the end of class completely filled out. Please identify the assignment and class period in the email subject line. 

Questions to consider:
How should the form look?
What categories should be included?
How will you track your time?
How can you be accurate?
What are the obstacles to being honest and accurate?
Is this difficult?

Tracking your time

Beginning today, students are going to track how much time they spend working on projects. This is a standard activity in many professions. For example, lawyers bill clients in six minutes increments. Accounting firms also bill clients based on an hourly rate, but rarely work a complete hour. Computer consultants bill clients too. Many visual artists also track their time, even if the artist is not billing a client, so that the artist knows whether a project is potentially profitable.

You will begin using a Microsoft Excel Spreadsheet to track how you spend your time in class each day. At the end of each class, send the MS Excel spreadsheet to me. Use the same spreadsheet for the rest of the year.

What categories should be included? How should the form look? Do you organize by week? How can you calculate the amount of time? What are the obstacles about being honest?

BF

Re-Do Large Group Photoshop

On Monday, we worked in groups of 3-5. We chose a photo and filter. Created layers, and often lost our work.

Today, see if it helps if you save your work as soon as possible.

Group Photo Shop

Four People

One Photo

Assignment. Sit in groups of four. Each person chooses a different photoshop effect (filter, transform, et al).

Your group chooses a photo.

Create a background layer. Rename layer to the person and filter.

Continue the process until there are five layers.

Save psd file in your drive.

Describe process and attach jpg to blog with description. Save all work.

bf

Group Photoshop

By the end of the day, post your before and after photos that you created yesterday. Send me the link.

Also, finish the post from Wed and include the link with the group photoshop post.

Explain how you changed the photos.

BF