Business Applications Lab

Standards (Things you should know)

• Demonstrate a knowledge of ethical considerations, computer crimes and licensing agreements.

Standards (Things you should know)

• Define terms related to hardware and software systems
• Identify the major components of hardware systems
• Manage files (i.e. naming, sorting, deleting directories/folders)
• Proper care of hardware and software systems
• Perform and respond to operating system commands

Standards (Things you should know)

• Describe the objects of the Windows desktop
• Use the functions of the minimize, maximize, restore and close buttons
• Move and size a window
• Discuss the function of a dialog box
• Use My Computer to locate a file
• Describe the different views for My Computer
• Create a new folder
• Recover a deleted file from the recycle bin

Standards (Things you should know)

• Identify major uses of websites
• Define terms related to web design
• Create a web page
• Organize a web page
• Add images to pages
• Create links
• Add background to pages
• Add text to pages
• Change text size
• Change fonts
• Change the page title
• Create easy to navigate pages
• Demonstrate consistency in design
• Use tables and frames
• Identify the audience

Part 1: What are my interests and skills?

1. Setup an account in the Kansas Career Pipeline. See instructor for the School Access Code
2. Login to the Kansas Career Pipeline
3. On the Home page select "Learn about my interests"
4. Complete the assessment
5. Go to the Home page and select "Learn about my skills"
6. Complete the assessment.

Part 2:  Choose Careers

1. On the Home page select "View results from my assessments"
2. Choose "Kuder Interests and Skills Composite Report"
3. Review the career clusters and compare your interests (blue) with your skills (yellow)
4. You can add career clusters you are interested in to your portfolio by selecting the yellow star in the right column
5. Select the career cluster name to explore the cluster further
6. This will open a page with more information about the cluster
7. Choose "Career Pathways, Programs of Study, and Career Specialties"
8. Select a career pathway from the list
9. A table will open below with programs of study and career specialties associated with those programs of study
10. Choose a career specialty and select "more..."
11. This will take you to a page with detailed information about the career including a video, characteristics, skills and abilities, education and income
12. If you like this career, you can add it to your portfolio by choosing the yellow star at the top of the page next to "Save to my portfolio"

Assignment:  Research your top career clusters and choose at least 3 career clusters and add them to your portfolio.  Under each career cluster you selected, research career specialties and choose at least one occupation in each of the 3 career clusters and add them to your portfolio.

Part 3:  Compare Careers Using Microsoft Excel

1. Open Microsoft Excel
2. Create a spreadsheet comparing three of the occupations you added to your portfolio
3. For each occupation include job title, one skill needed, one ability that is important, US median income, average job openings each year and the amount of education needed
4. The spreadsheet should be landscape, fit to one page, headings are 14 point font, bold and centered, use a 12 point font for text and numbers in the spreadsheet, numbers should be formatted correctly, categories being compared should be in column A and left aligned and bold. 
5. Column width for A is 22, Columns B,C,D is 30
6. Wrap text to make sure information is aligned in the cells properly
7. Color code each row used with a light color
8. Include a border around the outside of cells for each job
9. Add a header with the title Career Comparison. This should be 16 point font, bold and centered.
10. Add a footer in the right section with your first name and last initial. Use a 12 point font.
11. Save as a PDF to the Student Drive>Quarter3>Hand>Hour>CareerComparison

Spreadsheets

Standards (Things you should know)

• Identify major uses of spreadsheets
• Define terms related to spreadsheets
• Open a spreadsheet program
• Build a spreadsheet
• Go to a specific cell
• Enter text/labels
• Format a spreadsheet
• Insert/delete rows and columns
• Enter and format numbers
• Enter formulas
• Prepare a graph/chart from data
• Save a spreadsheet
• Print a worksheet and chart
• Sort range of data
• Get external data

Part 4:  Create a Database with Employer Information

1. Open Microsoft Access
2.  

Databases

Standards (Things you should know)

• Identify major uses of databases
• Define terms related to databases
• Design and create database files
• Perform save and retrieve features
• Design and print database reports
• Edit records
• Sort records

Internet

Standards (Things you should know)

• Identify various types of searches
• Identify uses of the Internet in individual and family life
• Describe how the Internet has changed the breadth and level of information access
• Describe how new developments in information distribution through the Internet affect the job market
• Define terms related to the Internet

Part 5:  Write a block letter to an employer

1. Open Microsoft Word
2.  

Word Processing

Standards (Things you should know)

• Identify major uses of word processing
• Define terms related to word processing
• Create documents
• Perform save and retrieve features
• Print a word processing document
• Set line spacing
• Set margins
• Use spell check/thesaurus
• Change font type and size
• Add borders and shading to paragraphs
• Create headers and footers
• Save a document
• Use tabs and indent
• Use copy/paste
• Add comments
• Use the mail merge feature

Part 6:  Create a presentation about one career

1. Open Microsoft PowerPoint

Presentation Software

Standards (Things you should know)

• Launch presentation software
• Create a new presentation
• Access a blank template
• Change the color scheme and or background shading
• Add textual information
• Add slide objects (graphics, sound, video)
• Insert a table on a slide
• Add text with special effects on a slide
• List the views in PowerPoint; describe the unique features of each view
• Set up an electronic slideshow
• Add transitions to all slides
• Name and save a presentation to a folder
• Demonstrate presentation skills

Part 7:  Create business cards

1. Open Microsoft Publisher

Desktop Publishing

Standards (Things you should know)

• Define terms related to desktop publishing
• Identify tools in toolbars and palettes
• Apply tools in toolbars and palettes
• Determine the most appropriate type of desktop publication based on the purpose of the publication
• Create a text block
• Use text objects and associated features (word wrap, drop caps, sizing, color)
• Import graphics from various sources
• Manipulate graphics
• Edit graphics
• Print a document
• Create a documents (i.e. brochure, newsletter, flyers)