180 likes | 283 Vues
Applying Tools of INLS 50:. Learning how to effectively convey information from the first four tasks. Class Organization Chart. What I Will Talk About. Task 1- Word Processing Task 2- Web Page Creation Task 3- Spreadsheet Design Task 4- Relational Databases
E N D
Applying Tools of INLS 50: Learning how to effectively convey information from the first four tasks Justin Mauney
Class Organization Chart Justin Mauney
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
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
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
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
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
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
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
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
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
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
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
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
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
Wrap-up- Recommendations • Task 1 • Use a shorter book to format • Feels repetitive • Task 2 • Carry “employer” theme throughout • Emphasize professionalism Justin Mauney
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
Summary The INLS 50 Equation: Word + Web Page Design + Excel + Access + PowerPoint = $ Better Prepared for the Business World $ Justin Mauney