Project Samples

Welcome to the Virtual Business

The video was removed due to the technical issue from youtube.com. Please click Computer Applications in Room 309 to go back to the first page. Sorry for the inconvenience.

Newsletter Projects (Excellent Student's Project)

From Car Newsletters

From Car Newsletters

From Car Newsletters

From Car Newsletters

From Car Newsletters

From Car Newsletters

Excellent Father's Day PowerPoint Projects

What is the relationship between technology and society?

Complete the following questions:

1) What do you think are the three most important or interesting inventions since 1950?

2) Do you think using cell phones too much is bad for our physical or mental health?

Why?

3) What changes have social changes have cell phones made?

4) What are good and bad points of using computers?

5) Do you think modern technology reduces or increases stress? Why?

6) Do you think money should be spent to explore space or is it better spent helping

people on earth? Why?

7) What is your opinion about teenagers playing violent video-games or computer

programs?

The computer system components

Create the following diagram using Microsoft Word

Excellent Students' Restaurant Menus

From Restaurant Menus

From Restaurant Menus

From Restaurant Menus

From Restaurant Menus

From Restaurant Menus

Creating Restaurant Menu using Microsoft Word

Excellent Students' Dream Bedroom Projects (mastering Excel features: mathematical functions, AutoSum, and AutoFormat)

Excel Project (Building your dream bedroom for period 8)

1) Use Microsoft Excel to list the items that you need to build your dream bedroom.

2) Create a poster demonstrating your dream bedroom

For example: bed, windows, chairs, tables, clock...

The first row in the excel should be (with an example):

First Row:
Item Name Quantity $ per one Total Price Where to buy Description

Second Row:
Bed 1 400 400 Home Depot Red, long bed

Requirements:
1) At lease 15 items are listed in your Excel
2) AutoFormat is applied in your Excel
3) Addition Formula is applied in your Excel
4) AutoSum is applied in your Excel
5) The format of poster is title, picture, and description

Samples:











Computer Skills:

Entering a Formula in a Cell:

1. Select the cell in which you want to enter the formula.

2. Type an equal sign = to activate the Formula Window and type the formula if you already know it. In the figure above, a formula for the sum of Field1 and Field2 is created as Field3.

3. After this formula is typed in and is pressed, the result is immediately shown in Field3.

To Create a overall Total:

1. Click AutoSum and select the cell where you want to insert the sum and, Excel's default formula is sum.

2. Press ENTER.

Online Excel Tutorials

Go to http://spreadsheets.about.com/od/excel101/ss/080610basic2003.htm and complete the Basic Excel 2003 Spreadsheet Tutorial.

Go to http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm and complete the Excel Formulas Step by Step Tutorial.


Go to http://spreadsheets.about.com/od/excelfunctions/ss/sum_autosum.htm and complete the Sum and AutoSum Step and Step Tutorial.


Go to http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm and complete the Excel IF Function Step by Step Tutorial.

Go to http://spreadsheets.about.com/od/excelcharts/ss/bar_graph_2.htm and complete the Excel 2003 Bar Graph Chart Tutorial.

Go to http://spreadsheets.about.com/od/excelcharts/ss/pictograph_2.htm and complete Create a Pictograph in Excel 2003

Go to http://spreadsheets.about.com/od/excelcharts/ss/90216piechart03_2.htm and complete the Pie Chart Tutorial.

Question: How many kinds of chart are available in Excel?

Go to http://spreadsheets.about.com/od/datamanagementinexcel/ss/create_list_2.htm and complete the How to Create List in Excel.

Go to http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm and complete the Using the Excel VLOOKUP Function.

Go to http://spreadsheets.about.com/od/excelfunctions/ss/hlookup.htm and complete the Using the Excel HLOOKUP Function.

Question: What is the difference between VLOOKUP and HLOOKUP?

Go to http://spreadsheets.about.com/od/advancedexcel/ss/excel_macro_2.htm?once=true& and complete the Excel 2003 Macro Tutorial.

(Extra credit / Optional / Very hard) Go to Excel Macro and complete the Introduction to using macro in Microsoft Excel.

New Utrecht High School Map

Excel Project: Should I play video games in the class?

Step 1: Input the following data to Excel (look at the Excel Sample)


Excel Sample