Applying Tools of INLS 50:

1. Applying Tools of INLS 50: Learning how to effectively convey information from the first four tasks Justin Mauney

2. Class Organization Chart Justin Mauney

3. What I Will Talk About • Task 1- Word Processing • Task 2- Web Page Creation • Task 3- Spreadsheet Design • Task 4- Relational Databases • Wrap-up- Recommendations and Commendations Justin Mauney

4. Task 1- Word Processing • Take existing book and format it • Insert page numbers • Insert pictures • Make whole project look professional • Good introductory task • Basic formatting skills • Familiarity with computing tools Justin Mauney

5. Task 1- Word Processing This screen shot shows how I had to edit the title, subtitle, author, and insert a picture with a border for Task 1 Justin Mauney

6. What I Will Talk About • Task 1- Word Processing • Task 2- Web Page Creation • Task 3- Spreadsheet Design • Task 4- Relational Databases • Wrap-up- Recommendations and Commendations Justin Mauney

7. Task 2- Web Page Creation • Designing a professional, effective web page • Creating a “web presence” • Learning how to “FTP” files This image fits with web page design because it shows a man trying to get on the information superhighway (the internet) Justin Mauney

8. Task 2- Web Page Creation This is my favorite part of my website. This page shows my favorite 10 movies and songs of all time. Rock on! Justin Mauney

9. What I Will Talk About • Task 1- Word Processing • Task 2- Web Page Creation • Task 3- Spreadsheet Design • Task 4- Relational Databases • Wrap-up- Recommendations and Commendations Justin Mauney

10. EXCEL is EXCELLENT! Task 3- Spreadsheet Design • Using Microsoft Excel to: • Integrate data from different sources • Organize the data to be easily accessible • Filter, sort, and subtotal features Justin Mauney

11. Task 3- Spreadsheet Design This shot shows the Monthly Expenses for BHM Regional Library (this slide was also the basis for the other sheets in Task 3). Justin Mauney

12. What I Will Talk About • Task 1- Word Processing • Task 2- Web Page Creation • Task 3- Spreadsheet Design • Task 4- Relational Databases • Wrap-up- Recommendations and Commendations Justin Mauney

13. Task 4- Relational Databases • Applying Microsoft Access to build a database for book holdings and purchases • Using: • Forms • Relationships • Reports • Queries Image courtesy of: www.mkitravel.com/corporate/corpservices.htm Justin Mauney

14. Task 4- Relational Databases This shot of Microsoft Access shows two forms, query 14, and the orders table. All of these features only work if the relationships are correct. Justin Mauney

15. What I Will Talk About • Task 1- Word Processing • Task 2- Web Page Creation • Task 3- Spreadsheet Design • Task 4- Relational Databases • Wrap-up- Recommendations and Commendations Justin Mauney

16. Wrap-up- Recommendations • Task 1 • Use a shorter book to format • Feels repetitive • Task 2 • Carry “employer” theme throughout • Emphasize professionalism Justin Mauney

17. Wrap-up- Commendations • Task 3 • Like the accounting theme for the Excel assignment • Task 4 • Many skills tested • Queries and reports bring ideas together well Justin Mauney

18. Summary The INLS 50 Equation: Word + Web Page Design + Excel + Access + PowerPoint = $ Better Prepared for the Business World $ Justin Mauney