ROP / SCHOOL-TO-CAREER PATHWAY
PRESENTS
COMPUTER APPLICATIONS
SYLLABUS
Week 1 Computers and your possible career
Week 2 Word Processing / Desktop Publishing
Week 3 Databases through Spreadsheets
Week 4 Using HTML editors
Week 5 Creating computer slide show presentations
Week 6 Mastering the keyboard, getting up to speed
Week 7 - Creating a portfolio.
Week 8 - Tools to launch a Desktop Publishing/Mail List Business
Week 9 - Direct selling your Computer Business.
Week 10 - Class recap and customer service.
You are expected to complete one lesson per week for 10 weeks. When you have completed the lesson email it and the assignment will be graded and returned within 2-3 school days. Please fill out your course schedule and submit to instructor.
Week 1 Computers and your possible career
Some students are enrolled in Computers Applications ROP to learn about computers for personal or academic use. Other students to get credit for graduation. Even some are exploring computers as a possible career. For whatever your reasons you will find this learning experience valuable and applicable for whatever you do. Well lets get started!
Have you considered a career and how a computer might fit in? Some might use a computer as a tool. For example an auto mechanic will use his hands to repair a transmission, but it will likely be a computer that will tell him it needs repair. A manager of a t-shirt shop will rely on a computer to make sure the store has enough sizes and colors of shirts to keep inventory flowing. How do you see yourself using computers?
Assignment - Using the below hyperlink find 4 jobs in the computer field
and explain why you find these jobs as a possible career path for you. Explain in some detail what the career is and
why it might be good for you. The total
assignment should be 2 pages long, each career
description should be 2-3 paragraphs.
Dont forget the most important element. Why do you think this might be
a good career for you.
Click here to go to
computer.org
Week 2 Word Processing / Desktop Publishing
Microsoft Word is one of the premier word processing programs available today. People use MS Word to do desktop publishing. Desktop publishing entails some of the following items:
· Informal/Formal letters
· Brochures
· Flyers
· Web Pages
· Business cards and stationary
· Most other things considered "documents"
MS Word has many nice features such as spell checker and automatic sorting to make creating documents easy and fun. The best way to learn how to use this program is explore the pull down menus and get excited about the different features available to you.
Assignment Using MS Word write a letter to your principal requesting
permission to hold an ASB fundraiser.
Make sure you outline you plan from beginning to end. You should include all needed supplies and
how you plan to make money. Also include
a sample flyer you plan to put up around campus.
CLICK HERE TO SEE A VIDEO DEMO OF MS WORD
More Demos! - TEXT TABLES CLIPART HYPERLINKS BULLETS UPLOAD COLOR
Week 3 Creating Databases through Spreadsheets
When you open up a checking account at your local bank the first thing the bank does is put you in a database. The bank representative will ask you questions like your name, social security, address and other things. This information is being directly imputed in the bank database and they associate this information to a particular checking account number. The bank will spend millions of dollars each year keeping this database up to date. MS Excel is the most common software program used to keep track of information.
SAMPLE DATABASE
|
NAME |
ADDRESS |
CITY |
STATE |
ZIP |
PHONE |
|
|
Douglas Perez |
1540 |
|
CA |
91766 |
909-397-4485 |
|
|
|
|
|
|
|
|
|
Above is a snap shot of a sample database. Each small area is called a
FIELD. So the name Douglas Perez is in one field and
CRUNCHING NUMBERS
A spreadsheet can also be used to keep track of numbers. So the bank
uses a spreadsheet program to keep track of you and a different spreadsheet to
keep track of your money. These spreadsheets have formulas so that once
you put a number in the total can be automatically computed. Here is a sample
budget:
|
mortgage |
$
1,500.00 |
19% |
|
|
taxes |
$ 250.00 |
3% |
|
|
insurance |
$ 60.00 |
1% |
|
|
second |
$ 300.00 |
4% |
|
|
principle |
$ 150.00 |
2% |
|
|
home maint |
$ 50.00 |
1% |
|
|
until |
$ 300.00 |
4% |
$2,610.00 |
The great thing about a spreadsheet is that when you change a number you do not have to re-compute your numbers. This is done automatically ONCE YOU SETUP THE SHEET. Download a sample of the required sheet.
Assignment 3A Create a database of all the participants in the Week 2
ASB event. Use the above sample to
create a 20 person list.
Assignment 3B Create a comprehensive budget for your ASB event. Include what percent each item is of the
total budget spent.
CLICK HERE TO SEE A VIDEO DEMO OF MS EXCEL
Week 4 Using HTML editors
Microsoft FrontPage is the software program that many people use to create web pages. Using MS FrontPage for a technology survey course is not necessary, but a good habit to start. MS Word can be used to create simple web pages, but if your goal is simply to create a web page, and no other document, this is a good program.
MS FrontPage is very user friendly. Once you have done a flyer in MS Word then there is not much more learning to create a web page in MS FrontPage. To see how easy it is download the online demo to see subtle differences in MS Word and MS FrontPage.
Assignment Using MS FrontPage create a web page for your ASB
events. Make your you have 4 hyperlinks
and 4 email links to help the person looking at the page be able to get more
information if they need.
CLICK HERE TO SEE A VIDEO DEMO OF MS FRONTPAGE
Week 5 Creating computer slideshow presentations
Using MS PowerPoint
PowerPoint creates slide shows for your computer. Slideshow presentations are used in business, primarily to educate people on products and services offered by companies and individuals. In education teachers present lessons in PowerPoint and students often summarize chapters in college as a way of conveying understanding. Using PowerPoint will likely be a lifelong tool.
What's specifically is PowerPoint?
PowerPoint is little mini flyers grouped together. Instead of calling them flyers each piece of the presentation is called a slide. PowerPoint slides usually have text and graphics (pics). Some advanced presentations will have music and video.
Assignment - Using concepts from your flyer, create a MS PowerPoint presentation for a school OR group of products or ASB event. Please have a minimum of 8 slides include text and graphics,
Week 6 Mastering the keyboard, getting up to speed!
Assignment 6A - Using Mavis Beacon Teaches Typing software program learn how to master a standard keyboard. When you have reached 40 word per minute email the final report to the instructor.
Assignment 6B - Using the letter from Week 2 and the
database from Week 3A mail merge the database with the letter to show your
skills in sending one letter to many different people.
Week 7 - Creating a portfolio.
Assignment - Create a web page with 1 graphic and 6 links showing your work from this class (weeks 1-6). All work should be viewable online, not downloadable. Include links from other students work and at least one email link. Use Geocities to upload you files.
Student Samples - 1 2
Week 8 - Tools to launch a Desktop Publishing/Mail List Business.
Assignment - Now that you know how to use computers in the business world it's time to get clients. Find an area within close distance to your home or school that has companies grouped together. Walk in the front door and get information to make a presentation to an owner or manager. Fill out the below table. Make sure that the business looks like it would benefit from using your business computers solution company and MIGHT have the resources to pay for one.
Copy table and paste in MS Word
|
Name of Business |
Address |
Phone |
Email? |
Owner/Manager |
Time Available |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Student Samples - 1 2
Week 9 - Direct selling your Computer Applications Business.
Assignment - Using the information from your table call your 10 companies and try to get an appointment the the manager/owner. First try to sell them on just seeing your work. Second see if they are willing to pay $75.00 to setup a mail merge system. You have the tools, so be confident and go out and try. Supply a log of contacts and be prepared to discuss in detail your efforts.
Week 10 - Class recap and customer service.
Assignment - Provide a MS PowerPoint presentation on the 10 contacts you
made. Describe in detail how each contact went. Explain how you would serve the
client after the sale and set up more paid work after the account is set up. If
you are not able to sell anything, then come up with a plan for when you do
have clients. Keeping clients happy and getting them into new products is as
important as getting the initial account.
Student Samples - 1 2
