Intro to Office

Budget and Resume using Google Docs

2011-10-12T12:42:00.001-07:00

Instructions here: https://docs.google.com/document/pub?id=1BeLWb_lp4KxJ--SNSw41Oo7vwO4ubm66ZjkdPkbutPY

Submit your resume and budget URL to http://freerschool.com

2011-10-10T13:38:00.001-07:00

Here is the list of terms for your objective test in Excel:Excel Objective Test!
Workbook
Worksheet
CellFormula Box
Name Box
Cell reference
Cell content
Constant Value
Formula
Fill box
Column headings
Range
Active cell
The data that displays in the Formula Bar is referred to as the __________.

Sample picture to show the class!

2010-10-26T15:52:00.001-07:00

Picture of a dog.

Richard's site

2010-08-09T17:09:00.000-07:00

Spreadsheet Comparison

2010-07-06T14:03:00.000-07:00

Link

Apple v. Microsoft Profitability

2010-07-06T14:02:00.001-07:00

Blog URL

2010-06-24T12:58:00.001-07:00

I need you to upload your information here.

My first day of school

2010-06-24T11:51:00.000-07:00

2010-06-24T09:25:00.000-07:00

CRSABX1-427477

To sign into the MyItLab!

2010-03-02T18:38:00.000-08:00

Present your "All About Me!" spreadsheet on Wednesday

2009-11-30T13:04:00.001-08:00

Loading...

Sign up to avoid taking the PowerPoint objective test.

PowerPoint presentation and Google Presentation Assignment

2009-11-25T13:04:00.001-08:00

Here it is!

On your blog...

2009-11-18T13:06:00.000-08:00

In your life, how do you see yourself using Word, Excel, and Access? Which do you enjoy using the most? Which is the most useful?

Download the Excel Worksheet and Word Worksheet

2009-10-21T12:36:00.001-07:00

http://eusesconsortium.org/edu/probabilities_statistics.php#m_and_m

Download the M & M group (Word and Excel)!

2009-10-14T13:58:00.000-07:00

One sheet will be specifically for money coming in minus taxes. Include the date you were paid.

One sheet will be specifically for money going out. Include the date you spent the money.

Include a brief description of the purchase. You'll need this for your graphs.

Within this sheet you will divide purchases into the following categories: Transportation Consumables Entertainment (include cable and Internet) Clothing Rent (include electricity) OtherFinally sum up all purchases.One sheet will calculate the difference (Are you saving the excess or using a credit card to finance your purchases?) and include the following graphs: On this sheet you will create a bar graph of your money spent per day.

Create a pie chart with the five categories and how you much you spent for each.

Create a line graph of your money spent per day.

Objective Test Terminology (Wednesday 9/30)

2009-09-28T12:46:00.000-07:00

Left, center, right justified alignment
Line spacing (single, double)
Format painter
Cutting
Copying
Pasting
Paste options
Bullets
Office Clipboard
AutoCorrect
Footnotes
Works Cited
Hanging Indent
Margins
The placement of paragraph text relative to the left and right margins is known as the ________.
Undo
Redo
To keep two words together as one unit, so that Word does not split them at the end of a line, insert a(n) __________ space.
What is a "Symbol"? How would you access it?
A set of formatting characteristics that can be applied to a paragraph with one shortcut command is known as a 'style'.
A list of information about a reference source, usually including the name of the author, the full title of the work, the year of publication, a Web address, and other publication information, is called ____________.
Document Properties
Insertion point
Title bar
Word wrap
Font
Keyboard shortcut
Live preview
Footer
Scroll box
Scroll bar
Quick Access Toolbar
Formatting marks
ScreenTip
When you select text, the __________ toolbar displays buttons that are commonly used with the selected object.
Selecting text
Bold
Italics
Underline
Which view displays page margins?
How do you quickly access the shortcut menu with the mouse?
Word Art
Floating graphic
Rotate handle
Anchor
Shapes
Leader characters
Tab stop
Cell
Table
Table style
Merge cells
---

Which keyboard shortcut moves to the end of the line? END

tab
paragraph
manual page break : how? what is it?
Word Template
Word Document
PDF
Word 97-2003
Document
Clip art
Formatting marks
Bold, italics, underline
Font
Where is the Print Layout button located?

End of chapter questions:

End of Ch. Questions, pp. 56-57

End of Ch. Questions, pp. 90-91

End of Ch. Questions, pp. 124-125

End of Ch. Questions, pp. 158-159

No notes or book on the Objective Test.

Find an article about technology on Slashdot.org

2009-09-23T13:34:00.001-07:00

Peruse the site slashdot.org

Find an interesting article and summarize the article with at least 100 words and post the review on your blog. Also post a link to the article!

Email me your Answer to the first test question concerning the Internet and business

2009-09-16T12:44:00.000-07:00

david.freer@gmail.com

2009-09-02T14:11:00.000-07:00

This link should work.

You can purchase the access code here.

You will need the following course code:

CRSAB1G-419819

I will go over this next class!

http://www.myitlab.com/

Email me at :

david.freer@gmail.com

I can read over your business plan.

First Objective Test

2009-09-02T13:10:00.001-07:00

Will be on September 14th. Here's the review sheet.

Evaluating hardware

2009-09-02T12:48:00.001-07:00

How much RAM should your computer have? Why?
What speed CPU?
How much storage space?
What is the best operating system for your computer?
What brand will you get?
How much do you expect your computer will cost?
Answer on your blog. Why did you pick the specs you did?

Today's lesson

2009-08-31T16:32:00.000-07:00

First you are going to write a business plan with WordPad. This seems like a good link.

You'll need these categories in your business plan:

1.0 Executive Summary
2.0 Company Summary
3.0 Products
4.0 Market Analysis Summary
5.0 Strategy and Implementation Summary
6.0 Management Summary
7.0 Financial Plan

Second you are going to create a logo with Paint.

Third, use your blog to write a press release about your exciting new business.

Email me a possible idea today to david.freer@gmail.com. Put the subject as "Possible Business Idea for Business Plan!"

Good typing games

2009-08-31T13:48:00.000-07:00

http://apps.facebook.com/typing-maniac/
Beat my score 1.5 million.

http://www.typeonline.co.uk/lesson1.html

Today I would like everyone to test their typing speed using this site:

http://www.typingtest.com/

Marketwatch game

2009-08-31T12:48:00.000-07:00

First go to

http://vse.marketwatch.com

mdcoffice is the game id. Join the game!

Select some stocks that you think will help you win the game!

Mr. Cool

2009-08-31T12:44:00.000-07:00

Computer Basics

2009-08-26T13:57:00.001-07:00

Internet Explorer Presentation

2009-08-26T13:50:00.000-07:00

What do you think of StumbleUpon?

2009-08-26T13:40:00.000-07:00

What do you think of the FireFox add-on StumbleUpon? Give me your impressions on your blog.

Did you find any interesting sites?

Keyboard shortcuts

2009-08-26T12:52:00.001-07:00

Alt + Left arrow to go back
Alt + Right arrow to go forward
Alt + Tab cycles through programs that are open
Windows Key + M = minimizes all the open programs

Alt + D will take you to the address bar using Internet Explorer and Mozilla Firefox

PageRank algorithm

Google Adwords

Do not download unknown .exe files. Do not download unknown office files. Beware of viruses!

Mozilla Firefox (open source)- install StumbleUpon.

Find an interesting article and comment on it your blog

2009-08-24T13:55:00.001-07:00

First visit slashdot.org.

http://slashdot.org/

Pick any article that interests you and write a brief summary on your blog about what it is about.

Write me an email with a bit of information about yourself

2009-08-24T13:39:00.000-07:00

What do you expect out of this class?
What experience do you have with computers?
What is your major?
Any other information that you think is pertinent.

david.freer@gmail.com

Your first post is to summarize what we learned in the first presentation.

2009-08-24T13:32:00.001-07:00

Try to remember as many concepts as you can. I'll post the Presentation up in one minute.

MDC OFFICE

2009-08-24T12:39:00.001-07:00

Welcome to class!

See how fast you can type

2009-07-23T08:32:00.001-07:00

Put your WPM on your blog.

Click here. Do a 1 minute test and copy and paste the results on your blog.

Test completed - here are your results:
Net Speed: 78 WPM
(words/minute)
Accuracy: 98%
Gross Speed: 79 WPM
(words/minute)
Print results

PowerPoint project

2009-07-23T08:13:00.000-07:00

"All About Me!"

You may present it for extra credit on July 29. Everyone will turn it in on FreerSchool.com by July 30, 2009.

Chapter 15, 16, 17 PowerPoint practice is up if you are interested in preparing for next Thursday's performance exam.

Databases in the news

2009-07-21T08:42:00.001-07:00

First click here:

http://news.google.com/news?hl=en&ned=&q=database

and find an article about databases in the news. Give a brief summary about how the database is being used. Write this on your blog.

2009-07-21T06:59:00.000-07:00

Access "Possessions" Project

For this project you are going to create a database and a table of your most important possessions.

You will need at least 6 different fields with one being numeric.
You will need at least 8 unique records.
You will need at least 4 queries.

UPload to FreerSchool.com by July 27, 2009.

You are done!

Budget Project

2009-07-14T08:14:00.000-07:00

Budget Project:

The purpose of this project is to keep an accurate snapshot of your spending, saving, and earning potential for a ten day period.

You will keep track of your earnings and money spent using Google Documents, specifically Google Spreadsheets.

One sheet will be specifically for money coming in minus taxes. Include the date you were paid.
One sheet will be specifically for money going out. Include the date you spent the money. Include a brief description of the purchase. You'll need this for your graphs.
Within this sheet you will divide purchases into the following categories:
Transportation
Consumables
Entertainment (include cable and Internet)
Clothing
Rent (include electricity)
Other
Finally sum up all purchases.
One sheet will calculate the difference (Are you saving the excess or using a credit card to finance your purchases?) and include the following graphs:
On this sheet you will create a bar graph of your money spent per day.
Create a pie chart with the five categories and how you much you spent for each.
Create a line graph of your money spent per day.

Using spreadsheets

2009-07-14T06:57:00.000-07:00

Today we will be using Google Spreadsheets to compare Google and Yahoo!

Here is the assignment. Add me as a viewer.

Here is a sample from last year.

Today's Excel exercise

2009-07-13T08:11:00.000-07:00

This was the example I did in the beginning of class.

Please read this article about the new version of Office 2010 and comment on your blog. I will check your blog on Friday.

Tomorrow we will work on a budget and do some comparisons about corporations using Excel.

Here is an example of a Word web page

2009-07-08T08:32:00.000-07:00

Here it is.

Objective test Wednesday

2009-07-06T08:38:00.001-07:00

Here's what you need to know for the Word objective test:
Left, center, right justified alignment
Line spacing (single, double)
Format painter
Cutting
Copying
Pasting
Paste options
Bullets
Office Clipboard
AutoCorrect
Footnotes
Works Cited
Hanging Indent
Margins
The placement of paragraph text relative to the left and right margins is known as the ________.
Undo
Redo
To keep two words together as one unit, so that Word does not split them at the end of a line, insert a(n) __________ space.
What is a "Symbol"? How would you access it?
A set of formatting characteristics that can be applied to a paragraph with one shortcut command is known as a 'style'.
A list of information about a reference source, usually including the name of the author, the full title of the work, the year of publication, a Web address, and other publication information, is called ____________.
Document Properties
Insertion point
Title bar
Word wrap
Formatting
Font
Sans serif
Serif
Keyboard shortcut
Live preview
Footer
Scroll box
Scroll bar
Quick Access Toolbar
Formatting marks
ScreenTip
When you select text, the __________ toolbar displays buttons that are commonly used with the selected object.
Selecting text
Bold
Italics
Underline
Which view displays page margins?
How do you quickly access the shortcut menu with the mouse?
Word Art
Floating graphic
Rotate handle
Anchor
Shapes
Leader characters
Tab stop
Cell
Table
Table style
A(n) ___________ symbol indicates the paragraph to which an object is attached.
When a graphic is selected, ___________ display around the edge of the graphic.
A banner is an example of a predefined __________ that can be inserted into a document.
A series of dots following a tab that serve to guide the reader's eyes is known as a dot __________.
To move from cell to cell across a table as you enter text, press ___________.
To create a table in Word, click the ___________ button on the Insert tab.
Shading button and its relation to tables.
To set the alignment of a table on a page, display the Table tab of the ________ dialog box.
Merge cells

**If you answer the questions at the end of chapters 5-8, it will be beneficial for your objective exam on Wednesday! **

Read the following about the housing bubble

2009-07-06T07:48:00.001-07:00

Read this book review/ interview with the author.

Answer the following questions on your blog:

Who do you think is to blame for the housing bubble?
How does the author of the book feel about using government money to promote home ownership?
Alyssa Katz mentions another similar bubble situation. How was it resolved?
What happened in Lehigh Acres ?
Would you invest in real estate now?
Would you be interested in the book?

Stock market update

2009-07-06T07:00:00.000-07:00

On your blog give a snapshot of how your stocks are doing. Are you going to change strategies? What are you going to need to do differently?

summerMDC is the game id and password.

Five links to help write a resume

2009-07-02T06:56:00.000-07:00

Find five links to help your classmates write a better resume and summarize quickly why they are good pages.

View the first page. These samples are tailored for college students and recent graduates. This might be useful for my fellow classmates.

This page describes how important experience is when it comes to finding a job. College students would be advised to take on jobs relevant to their major.

Professional resume writers are willing to shape a resume for you. This site guarantees you will have an interview AND get hired or they'll pay you $50.

The objective statement summarizes what your goals are for your job search. This slideshow describes the process.

This forum is dedicated to people discussing their resumes. It seems like a lively site as there are thousands of posts.

It's a bell curve!

2009-07-01T22:11:00.000-07:00

Please upload your business plan to FreerSchool.com

2009-07-01T08:37:00.000-07:00

First you are going to write a business plan with WordPad. The business plan needs to be at least a page.

Second you are going to create a logo with Paint.

Third, use your blog to write a press release about your exciting new business. The press release should also be approximately a page and should describe how exciting your new business is!

Lastly you will zip up your business plan and logo and upload it to FreerSchool.com.

Thanks.

2009-07-01T07:58:00.001-07:00

Here is my document.

Predict which will influence your life the most...

2009-06-29T08:57:00.000-07:00

Of all the things we did in class today, which will have the biggest impact on your life? Please give me feedback on your blog...

If you wish to purchase the access code

2009-06-29T08:55:00.001-07:00

You may click here. You will need a CC. At Lemox the book is $85 I hear.

2009-06-29T08:50:00.000-07:00

Course ID for myitlab.com :

Course ID: CRSABDS-609862

Find an interesting trend

2009-06-29T08:40:00.001-07:00

Either by location or search volume, using Google trends find an interesting search trend. Post the interesting item on your blog and speculate as to why the trend is as it is.

Google.com/Reader

2009-06-29T08:10:00.001-07:00

Sign up for 5+ blogs using Google Reader. MDCOffice needs to be one of them!

Take a screenshot of your Reader and post it on your blog.

Use Print Screen and Paint.

Online identity

2009-06-29T07:33:00.000-07:00

Create a Google Profile.

Here is where to do it.

Post a link on your blog.

Stocks!

2009-06-29T07:18:00.000-07:00

On your blog:

What stocks did you purchase and why?
What is a stock?
How do you anticipate your stocks will do over 1 month? 1 year? 10 years?

An interesting post about AI

2009-06-28T09:26:00.000-07:00

Simply for your edification.

First objective quiz on Tuesday; first project due Sunday before 11:59pm

2009-06-25T08:46:00.000-07:00

First quiz on Tuesday.

Business Plan before Sunday.

Also check to make sure you have commented on your blog about the following articles/class projects:

Supercomputers and math.
SketchUp home
Dog using Paint.
Describe 5 shortcuts for Windows.
Summarize two technology articles.

Really interesting article about supercomputers

2009-06-25T08:29:00.000-07:00

Read this and comment on your blog.

Business

2009-06-25T08:10:00.000-07:00

Here is a good link. Please email me your business plan by noon and I will give you some feedback!

Here are some sample business plans.

Favorites online

2009-06-25T07:28:00.000-07:00

Try this!

Link to mediafire

2009-06-24T07:53:00.000-07:00

I hope this works.

It does! If you have any questions about how to zip up your plan. Have your business plan/logo/press release done by Sunday at 11:59. This will be your first project grade.

Business plan

2009-06-24T06:59:00.000-07:00

Here is a very detailed outline on how to write a business plan.

Here are the main categories to cover:

These are the categories to explain in your business plan:

1.0 Executive Summary
2.0 Company Summary
3.0 Products
4.0 Market Analysis Summary
5.0 Strategy and Implementation Summary
6.0 Management Summary
7.0 Financial Plan

Link to my dream home

2009-06-23T08:11:00.000-07:00

Glass house created with SketchUp!

Post a link and embed your work!

Make a dog with Paint

2009-06-23T07:40:00.001-07:00

Upload to your blog. Dog reading literature book.

Business Plan Summer 2009

2009-06-23T07:18:00.000-07:00

First you are going to write a business plan with WordPad.

Second you are going to create a logo with Paint.

Third, use your blog to write a press release about your exciting new business.

Lastly you will zip up your business plan and logo and upload it to

http://www.mediafire.com/

Put a link to it on your blog post with the press release.

Here are some good links. Email me before Sunday and I will give you feedback on your business plan.

Find five more shortcuts for Windows

2009-06-23T07:04:00.000-07:00

Use the Internet to research shortcuts for Windows. Try them out and put them on your blog. Write about what you think is the best shortcut!

Terms from the first week

2009-06-22T08:41:00.001-07:00

Edit
On Tuesday there will be mutliple choice, true-false, and short essay questions.

CD-RW
File extension
Wildcard
Thumbnail
Compress
Icon
Operating System
Windows
Start button
What is Firefox?
When you right click what menu comes up?
What does it mean to 'maximize', 'minimize', and 'restore'?
What are the shortcuts for copying, pasting, and cutting?
How can you alphabetize the files when viewing in 'My Computer'?
What is a hard disk drive? CD-ROM drive?
What is a Web browser?
What is a Web page?
What is an ISP?
What is a URL?
What is a Home page?
What is a Search engine?
What is a Portal?
Think yahoo.com vs. google.com
What are Pop ups?
What is a web site?
What is a hyperlink?
What does "WWW" stand for?
How do government web sites usually end? .gov
How do education related websites usually end? .edu
Commercial websites? .com
What does "History" mean on a browser.
What does your mouse look like when you put it over a hyperlink?
What are tabs used for with browsers?
How can one open a tab with Internet Explorer?
What is a server?
How do protocols relate to the Internet?
What is software?
Computer application?
What is a computer network?
What is network topography?
What is a port?
What is a computer?
What is a laptop/notebook?
What is a PDA?
What are peripherals?
What is the motherboard?
What is RAM?
What is a supercomputer?
Describe INPUT, OUTPUT, PROCESSING, AND STORAGE
The control unit and ______________ logic unit are located in the CPU.
What is the average speed of a modern CPU? What is it measured in?
What is a GUI?
What is a laser printer?
What is dpi as it is concerned with printing?
What is spyware?
What is a cookie?

Taskbar

Title bar

Shortcut menu

Quick launch toolbar

Notification area

Status bar

Folder

Here are the presentations:
Chapter 1

Chapter 3

Possible Short Essay Questions (2-3 paragraphs):

Describe how the Internet has revolutionized business in the last decade and a half.
What is a computer? Explain the essential functions of a computer.
Describe the purpose of a business plan.
You need to explain Internet security to a friend who knows nothing about the subject. What will you warn them about? How can they stay safe online?

Your information

2009-06-22T07:31:00.001-07:00

Summer 2009

2009-06-22T06:56:00.000-07:00

Welcome to class!

Find two articles related to computer hardware and summarize what is going on!

Also provide a link to the articles.

Here is a good way to find current articles about any subject!

http://news.google.com/

Sabbatical from Office

2009-01-04T19:17:00.001-08:00

Hopefully I'll return to my regular posting in Summer. :)

Grades at this point

2008-12-10T17:56:00.001-08:00

Click here for grades.

Worst presentation ever?

2008-12-01T14:36:00.000-08:00

Is this the worst PowerPoint ever?

Microsoft offers tips to people creating PowerPoint presentations!

This blogger has a lot of respect online. His tips are pretty good. Don't think of them as law, of course.

Notice any disagreement between his tips and Microsoft's official website tips?

This is an art, not a science.

By the way, I highly recommend Seth Godin's most recent post.

PowerPoint project due December 10th, 2008

2008-12-01T11:51:00.001-08:00

Here is your PowerPoint project.

View your grades by ID number

2008-11-26T14:48:00.001-08:00

View your grades by ID number.

Extra Credit possibility for students in class next Wednesday

2008-11-24T13:05:00.001-08:00

Wednesday, November 26th is possible extra credit for students in class!! We begin PowerPoint on Wednesday.

I opened up the exercises for the PowerPoint chapters. We will be doing all the chapters for PowerPoint.

Chapter 12 and 13 objective test next class

2008-11-17T12:48:00.003-08:00

You may bring in notes from Chapter 12 and 13. The end of chapter questions will be very helpful.

Wednesday November 19th, 2008.

Also the Practice Exam is now available for Access.

Congrats to everyone who did better on the Excel exam.

Chapter 12 and 13 objective test next class

2008-11-17T12:48:00.001-08:00

You may bring in notes from Chapter 12 and 13. The end of chapter questions will be very helpful.

What's your opinion?

2008-11-17T12:36:00.001-08:00

Find an article online in favor of bailing out the automakers (GM, Chrysler, Ford) and find one against. Put links on your blog and write your own impressions.

Here's one article you can cite:

http://money.cnn.com/2008/11/17/news/companies/gm_showdown/?postversion=2008111715

Access Possessions Project

2008-11-12T13:09:00.001-08:00

Info here. Due November 24, 2008.

Database questions...

2008-11-12T12:30:00.000-08:00

What is a database?
What is a table?
What is a primary key?
What would a business use a database for?

http://maps.google.com/

Go to street view.

Access Pets Database on the J Drive

2008-11-10T13:13:00.000-08:00

Put it on the J: Drive with your last name before Pets in the
J:\Access November 10 2008

folder!

Make up test on Friday for Excel!

2008-11-10T12:25:00.000-08:00

You can do a makeup exam (Performance) for Excel in ROOM 9103 on Friday November at 3:15pm.

Work on Chapter 12 Access

2008-11-05T12:55:00.000-08:00

Class,

You may begin Chapter 12A and 12B Access Skill-based training. Also read chapter 12 in your textbook.

See you next week.

You have until Sunday at 11:59 pm to do the Excel Objective

2008-10-29T14:04:00.001-07:00

You have until Sunday at 11:59 pm to do the Excel Objective.

Old Faithful

2008-10-27T12:02:00.000-07:00

Click here and download

Old Faithful - That Trusty old Geyser

Excel files and Word files. You and a partner will complete questions 1-4 in class and submit it for an extra point title it "Old Faithful" on your Hot Dog example.

Please save it as YourLastName and Data in the J:\October 27 Excel folder.

Budget Project

2008-10-22T12:42:00.000-07:00

Here are the instructions.

Due November 10th, 2008.

If statements!

2008-10-20T13:14:00.001-07:00

=IF(P3>=90,"A",IF(P3>= 80,"B",IF(P3>=70,"C",IF(P3>=60,"D","F"))))

Save your Excel worksheet as your last name, here:

J:\Excel October 21 2008\

Grades by ID number

2008-10-20T12:35:00.001-07:00

Grades to this point by ID number.

Comparing Google and Yahoo!

2008-10-15T12:53:00.000-07:00

Here's today's assignment:

http://docs.google.com/Doc?id=dc65q8nz_8412sqjwjdk

Save it on the J: drive in class in the folder called: October 15, 2008 Excel

Save the file as 'YourLastNameGooglevsYahoo' but replacing YourLastName with...your actual last name.

Where to put your money right now

2008-10-15T12:43:00.001-07:00

On your blog, please respond to Mark Cuban's post:
http://blogmaverick.com/2008/10/15/where-to-put-your-money-right-now/

Miami Dade is giving away an iPod

2008-10-01T13:39:00.001-07:00

Make a video about network security and you could win an iPod from Miami Dade. More about the contest.

Here's the resume

2008-09-29T13:18:00.000-07:00

http://docs.google.com/Doc?id=dc65q8nz_1080ddzs7jhs

Resumes

2008-09-29T13:04:00.000-07:00

You will use http://docs.google.com/ to host your resume with current experience. Here's mine for reference: http://www.davidcfreer.com

http://jobstar.org/tools/resume/cletters.php is a good site to learn about resumes.

http://careerplanning.about.com/od/resumewriting/a/resume_writing.htm

Also you will need a cover letter for a specific job.

Add me as a viewer to your resume online.

My email is david.freer@gmail.com Due by October 8th, 2008.