TECHNOCEO TECHNOLOGY PROJECT
| PowerPoint and
Excel Lesson Plans |
 |
Teacher Guide - Student Workbook -
Resource Files
 |
In this technology project, students assume the
role of Chief Executive Officers. They create a PowerPoint
presentation describing the financial success of their
company to attract potential investors. |
Are you looking for a way for your students
to learn presentation and spreadsheet skills using a
real life model?
In the TechnoCEO project, students use
detailed
PowerPoint and Excel lesson plans to prepare a
professional looking presentation. Students learn technology
skills in a real world simulation. Computer applications are
integrated and used as tools to manipulate, calculate and
organize data and then create a slide
show.
TechnoCEO provides teachers
with all the tools they need. When you order TechnoCEO, you will
receive:
- teacher guide
- student workbook
- review questions
- detailed lesson plans
- skill reviews
- extension activities
- marking sheet
- templates
- sample files
|
 |
Beginners Can Learn Advanced
Presentation Skills
Easy-to-follow instructions,
including pictures and examples of finished work, help students
to complete a professional looking project using Microsoft
PowerPoint. Themes, WordArt, graphic organizers, and
animation are some of the creative, useful and highly motivating
techniques introduced in this project. The final presentation
includes:
- original logo created using
WordArt
- organization chart
- product sales bar graph
generated from spreadsheet calculations
- company performance summary
Become a CEO
To begin, students are guided
through the planning process of setting up a company.
Informative hints and questions help the students to understand
the role of the CEO. Next, they name the company, decide on the
type of product and are shown how to set prices.
Organize Your Corporate
Structure Using PowerPoint
| Next, students learn
about the roles and responsibilities of the main
positions in the hierarchy of a company. Following
illustrated instructions, they plan, create and format an
organization chart in Microsoft PowerPoint. |
 |
Calculate Financial
Information Using Excel
In TechnoCEO, beginners are
introduced to Microsoft Excel. They are guided through basic
spreadsheet skills and move on to learn advanced techniques as
they calculate their company's operating expenses and sales
revenue.
1. Organize Spreadsheet Data
Using a provided template,
students learn how to:
- format borders, headings,
and text
- add color to make data
clear and easy to understand
2. Calculate Company
Expenses
As they calculate net
sales, students learn how to use:
- Autosum to
automatically calculate the sum for a range of cells
- Autofill to
copy values or formulas
- Formulas
to add, subtract or multiply a range of data
- Format Painter
to copy formatting
- Insert Function
to build a formula
|
Click to view a sample spreadsheet |
3. Graph Financial Results
Click to view a sample bar graph |
Next, the students
convert the data into a bar graph comparing the sales
revenue from 3 different product lines. They learn to:
- add text to the
graph
- change the axis
categories
- choose a chart
layout
- label the axes
|
4. Prepare the Company
Summary Report
As they prepare to summarize
their year end data, students learn power user skills, such as:
- how to set the print area
- adding headers and footers
- setting page breaks
Convince Your Investors
Finally, the student CEOs get
ready to complete their presentations for the potential
investors. The graph is copied to the
PowerPoint slide show, the financial data is analyzed and a year
end summary is written.
The last step in making the
slide show interesting and convincing is to add animation.
Detailed directions show students how to animate objects, make
the animations play automatically and adjust the speed. All
students find this session lots of fun!
Assessment Tools Included
A complete marking sheet
is provided for the teacher. Each requirement of the
presentation is examined and assessed, providing a final mark
for each student. In addition, the teacher may choose to use the
optional reviews at the end of each session to evaluate student
understanding and skill attainment.
Optional PowerPoint and
Excel Activities
Included in the package are a
number of fun activities
that provide extra practice as well as advanced techniques and
tips. These include:
- Company Slogans
- Spreadsheet Quiz
- Family Tree
- Customize Sheet Tabs
- Power User Tricks
|
 |
TechnoCEO is
Affordable
The TechnoCEO
technology project is great value
for your money. When you order TechnoCEO, you will receive a teacher guide,
student workbook, and customizable resource files
for a
price that is affordable.
Software: Microsoft
PowerPoint. Microsoft Excel
Version: Microsoft Office
2000, XP, 2003, and 2007
With TechnoCEO, instead of preparing PowerPoint
and Excel lesson plans
for computer class, you can spend your time with
students having fun in the computer lab completing
meaningful activities.
|
