Group items tagged

Kathy Schrock's Guide for Educators is a categorized list of sites useful for enhancing curriculum and professional growth. It is updated often to include the best sites for teaching and learning.

Teacher Vision is a great website for teachers and parents. I used this website when I was preparing one of my lesson plans for field work. The website includes lesson plans, printables, themes, classroom management ideas, and professional development resources.

Have Blurb publish your own book. Supply the writing and pictures, pay a fee and Blurb does the rest-- a custom, professionally published book by you.

Education World is a search engine site for educational resources for teachers or students. This is a site where teachers can gather and share their ideas for lesson plans, games, technology, school issues, professional development and many more types of research materials. Education world is an easy site for all teachers to use.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports. Once you've created a report-whether through the Report Wizard or the Report command-you can then format it to make it look exactly how you want. In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use formatting options to format text, change report colors and fonts, and add a logo. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about the Report Wizard in Access. THE REPORT WIZARD While using the Report command is a quick way to create reports from the current object, it's not as helpful if you want to create a report with data from multiple objects. The Report Wizard makes it easy to create reports using fields from multiple tables and queries. It even lets you choose how your data will be organized. TO CREATE A REPORT WITH THE REPORT WIZARD: Select the Create tab and locate the Reports group. Click the Report Wizard command. Clicking the Report Wizard command - www.office.com/setup Blogs The Report Wizard will appear. In the procedures below, we'll discuss the different pages in the Report Wizard. The Report Wizard dialog box - www.office.com/setup Blogs STEP 1: SELECT THE FIELDS TO INCLUDE IN YOUR REPORT Click the drop-down arrow to select the table or query that contains the desired field(s). Selecting a table that contains fields to include in the report - www.office.com/setup Blogs Select a field from the list on the left, and click the right arrow to add it to the report. Adding fields to a report - www.office.com/setup Blogs

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: After creating a form, you might want to modify its appearance. Formatting your forms can help make your database look consistent and professional. Some formatting changes can even make your forms easier to use. With the formatting tools in Access, you can customize your forms to look exactly the way you want. In this lesson, you will learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about formatting forms in Access. FORMATTING FORMS Access offers several options that let you make your forms look exactly the way you want. While some of these options-like command buttons-are unique to forms, others may be familiar to you. COMMAND BUTTONS If you want to create a way for users of your form to quickly perform specific actions and tasks, consider adding command buttons. When you create a command button, you specify an action for it to carry out when clicked. By including commands for common tasks right in your form, you're making the form easier to use. Access offers many different types of command buttons, but they can be divided into a few main categories: Record Navigation command buttons, which allow users to move among the records in your database Record Operation command buttons, which let users do things like save and print a record Form Operation command buttons, which allow users to quickly open or close a form, print the current form, and perform other actions Report Operation command buttons, which offer users a quick way to do things like preview or mail a report from the current record TO ADD A COMMAND BUTTON TO A FORM: In Form Layou

A teacher would never be satisfied with her performance if she discovered that the entire back row of her classroom was unable to hear her lecture. In the world of cloud services for business, we see things the same way. With Office 365, every user counts! Google has a different approach. It starts counting downtime only after at least 5 percent of users are affected. Imagine if 100 of your 2,000 users had no access to email. Would you, as an IT professional, be satisfied with your performance? Would your business hold you accountable for your performance? The answers to these questions are clear. Calculating downtime only after 5 percent of your users cannot access email, as Google does, makes it more difficult for you to assess impact to user productivity. Google's approach doesn't help your business with meaningful performance metrics. With Office 365, every affected customer and every service counts when we calculate downtime. Downtime means the total minutes in a month during which service is unavailable, excluding scheduled downtime. For services like email, there is no scheduled downtime, an experience that our many Exchange Server customers have long been accustomed to-system maintenance while they continue to be productive in their Outlook inboxes. In addition to the way it calculates downtime, Google also combines consumer and commercial service availability when reporting the availability of Gmail. This means if you are considering Google Apps for Business, you cannot get accurate information regarding the availability of the commercial service that you need. On the other hand, Microsoft's approach to calculating downtime, which includes every user minute, helps you understand whether your users' productivity is being impacted by downtime of email. Google takes a "use at your risk" approach around Google+, Hangout and Google Voice. These services are not part of Google Apps for Business and are excluded from the SLA. Excluding these serv

This post is brought to you by Seayoung Rhee, Product Marketing Manager in the SharePoint Product Marketing Group. Reliable business intelligence and insight are key to a thriving business. Excel, SharePoint and Office 365 make business intelligence (BI) in the new Office more accessible to everyone across an organization as part of their everyday work. New and enhanced features in familiar tools such as Excel empower everyone in a business to easily explore, model, analyze, and visualize data from various sources. With SharePoint, users of all levels can collaboratively develop and share insights through dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For corporate environments, these features are further enhanced by SQL Server for higher levels of performance and scalability both on-premises and in the cloud with BI Azure. Ultimately with Microsoft BI, anyone in the organization can develop the insights that help drive new discoveries and make better, more informed decisions. EXPLORE YOUR DATA PowerPivot was a popular add-in to Excel 2010, allowing users to create large data models with hundreds of millions of rows in Excel. This feature is now natively embedded in Excel to reduce the hassle of downloads and installation. PowerPivot is also supported in SharePoint with SQL Server Analysis Services where the workbooks with PowerPivot models can be shared broadly across the organization. New features like Quick Explore aid users in navigating their data, and Quick Analysis provides previews of their charts, graphs, and scorecards. Users can: Combine and analyze large datasets with PowerPivot Summarize data and discover trends with Quick Explore Instantly preview charts and pivot tables with Quick Analysis www.office.com/setup VISUALIZE YOUR INSIGHTS Introduced with SQL Server 2012, Power View provided a canvas to create visual dashboards in SharePoint. Now this feature is embedded into Excel and SharePoint so

Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for various key business assignments. You can check out Liam's previous articles at www.sumproduct.com/thought, where you can also subscribe to the monthly tips and tricks newsletter. Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? This article provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems. The functionality is best explained by walking through an example: Ivana: Car Sales has four divisions, cunningly called North, South, East and West. Each quarter, the four divisions are required to submit sales reports detailing the month of sale, the sales person, the car color and the price the car was sold for. www.office.com/setup The question is: how can you determine how many red cars Charlie sold in February in total across all four divisions? The answer would be fairly straightforward if the data were all on one worksheet. For a single criterion, SUMIF would cope admirably well, while for several criteria, SUMPRODUCT could be used to generate the answer (for further information see my blog posts on the SUMPRODUCT function and approaches to addressing multiple criteria in one worksheet).

Whether you are a novice user of Microsoft Project 2013 or you want to learn about IT Professional or developer topics, please consider our new quick start training for Project 2013-it's free and available on demand! www.office.com/setup You get over 9 hours of content divided into 13 modules. Don't have much time? Don't worry, each module is broken down into individual videos so you can go at your own pace.

While we are lucky enough to work with extremely innovative clients that are eager to embrace the latest technology, we always advise them not to adopt the latest version of software until after the kinks are worked out. For a consumer it's not a big deal to be test driving new features and experimenting with the latest version. For a business user, if there's a bit of a learning curve, buggy features or errors that make an application crash, it can be a huge detriment to productivity. That's why we take a lot of time testing out new applications and operating systems before we encourage our clients to adopt them. You may have read that Microsoft recently unveiled Office 2016. We spent some time with it and have some mixed feedback for our business users. Here's the good, bad and the ugly surrounding the Office 2016 suite: The Good: Built to make business better. Word is probably our favorite when it comes to the new suite of products. While there has been minimal change to formatting and structure - the overall design has definitely gotten a facelift. We're all about function, though and when it comes to function we see definite improvements. Word has many more templates. This allows businesses to refine their documents and be more professional without having to go online and download templates to use inside Word. There are also some pretty awesome co-authoring features that we wrote about in this blog. Attachments in Outlook reference recent documents. This is a great feature since it's available on any device that you use Office on. You can easily attach documents in e-mails in Outlook or reference them in an e-mail on your phone. This is really valuable for mobile users or users that work from more than one machine. (Which, lets face is, 90% of the workforce these days does.) OneDrive is also attempting to make its way into the life of business users by making sharing documents, collaborating on documents and authoring documents across devices a l

www.office.com/setup Blogs: Today marks the general availability of Office 2016 for Windows, a suite of desktop applications that together with new mobile and web apps pushes Microsoft's new vision for PC-based productivity. Office 2016 is available immediately to Office 365 subscribers, as well as to individuals who would prefer to buy the software in standalone form. "We see Office 2016 as being just as important as the first release of Office," Microsoft group program manager Shawn Villaron told me in a briefing last week. "In the early days, Office was about bringing really important tools together to empower the individual for personal productivity. That was the way people wanted to work at that time. And for 20 to 30 years, Office fit right in. Today, things are changing. More people collaborate on work as groups and teams, so Office 2016 represents the change from personal productivity to team productivity." And that, really, is Office 2016 in a nutshell. If you're a typical information worker, student, or other person in need of standard productivity tools, Office 2016 of course works fine and represents an obvious and stable evolution from the Office version you're currently using. But the real meat in this release-now and going forward, as Office will of course be updated regularly, like Windows 10-is the designed around this new way of working. Confusing matters somewhat, Office-not Office 2016, but Office generally-is all over the place now. In addition to the classic, full-featured desktop suites on both Windows and Mac, Microsoft has high-quality Office Online web apps, mobile apps for Android, iOS, and Windows/Windows phones-and Office 365-specific solutions that are often available as web apps but are sometimes just integrated into the desktop applications. This ain't your father's Office anymore. Office everywhere: Microsoft Office is available on virtually any device you care to use. - www.office.com/setup Office eve

www.office.com/setup Blogs: YES. Microsoft has some FREE help with the NEW Office 365. One of the places that I send people to first is the Ignite Online training center. How to configure federated identity sign-in model for Office 365 OFFICE 365 GUIDES Exploring the Office 365 Administration Center - In this guide, you will become familiar with the Office 365 Administration Center and learn how to perform key administration tasks. Office 365 Overview for IT Administrators - See how the new Office 365 Administration Center provides improved ease-of-management for IT professionals. There is also a great three part series on how to setup Identity Management. 1. Installing and Configuring Active Directory Federation Services - Learn how to prepare for and install AD FS, which is a preliminary step for the Office 365 federation and hybrid scenarios. 2. Configuring Active Directory Federation Services and Verifying Federation - In this guide, you will learn how to add and verify federated domains in Office 365. 3. Installing and Configuring Active Directory Synchronization - Learn how to install and configure Active Directory Synchronization in Office 365, which is a preliminary step for the Office 365 federation and hybrid scenarios.

www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016. Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite. HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS? Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords. Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files. click browse to import office files - www.office.com/setup Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation. 1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery. 2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc. 3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover. choose attack type - www.office.com/setup Step3. Finally, click "Recov

www.office.com/setup Blogs: Missing a key security signal could mean not catching a breach, but the number of security signals is increasing exponentially. It's becoming impossible to manually prioritize them. That's why Office 365 applies intelligence to help you proactively manage risk and ward off threats. Today, we're pleased to introduce several new capabilities in Office 365 that help you manage risk and stay ahead of threats: Office 365 Secure Score-A new security analytics tool that applies a score to Office 365 customers' current Office 365 security configuration. Office 365 Threat Intelligence Private Preview-Service that leverages billions of data points from the Microsoft Intelligent Security Graph to provide actionable insights to the global threat landscape and help customers stay ahead of cyber threats. Office 365 Threat Intelligence is now in private preview, with general availability planned for later this quarter. Office 365 Advanced Data Governance Preview-Applies machine learning to help customers find and retain the most important data to them while eliminating redundant, obsolete and trivial data that could cause risk if compromised. Office 365 Advanced Data Governance is now in preview, with general availability planned for later this quarter. KNOW YOUR OFFICE 365 SECURE SCORE Do you know how you'd be rated if someone were to evaluate your security configuration? To give you better visibility into your Office 365 security configuration and the security features available to you, we're pleased to introduce Secure Score-a new security analytics tool. Secure Score helps you understand your current Office 365 security configuration and shows you how implementing additional controls can further enhance your security and reduce risk.* Here's how it works: Secure Score Summary-Displays your Secure Score and provides access to view your Score Analyzer. Your Secure Score, the numerator, is the sum of the points associated wi

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A theme is a predefined combination of colors, fonts, and effects. Different themes also use different slide layouts. You've already been using a theme, even if you didn't know it: the default Office theme. You can choose from a variety of new themes at any time, giving your entire presentation a consistent, professional look. Optional: Download our practice presentation. Watch the video below to learn more about applying themes in PowerPoint. WHAT IS A THEME? In PowerPoint, themes give you a quick and easy way to change the design of your presentation. They control your primary color palette, basic fonts, slide layout, and other important elements. All of the elements of a theme will work well together, which means you won't have to spend as much time formatting your presentation. Each theme uses its own set of slide layouts. These layouts control the way your content is arranged, so the effect can be dramatic. In the examples below, you can see that the placeholders, fonts, and colors are different. The Frame theme and the Integral theme - www.office.com/setup If you use a unique slide layout-such as Quote with Caption or Name Card-and then switch to a theme that does not include that layout, it may give unexpected results. Every PowerPoint theme-including the default Office theme-has its own theme elements. These elements are: Theme Colors: There are 10 theme colors, along with darker and lighter variations, available from every Color menu. Theme Colors - www.office.com/setup Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts. Theme Fonts - www.office.com/setup Theme Effects: These affect the preset shape styles. You can find shape styles on the Format tab whenever you select a shape or SmartArt graphic. Theme Effects - www.office.com/setup When you switch to a different theme, all of these elements will update to reflect the new them

www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016. Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite. HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS? Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords. Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files. click browse to import office files - www.office.com/setup Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation. 1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery. 2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc. 3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover. choose attack type - www.office.com/setup Step3. Finally, click "Recov

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Once your slide show is complete, you'll need to learn how to present it to an audience. PowerPoint offers several tools and features to help make your presentation smooth, engaging, and professional. Optional: Download our practice presentation. Watch the video below to learn more about presenting your slide show. PRESENTING A SLIDE SHOW Before you present your slide show, you'll need to think about the type of equipment that will be available for your presentation. Many presenters use projectors during presentations, so you might want to consider using one as well. This allows you to control and preview slides on one monitor while presenting them to an audience on another screen. TO START A SLIDE SHOW: There are several ways you can begin your presentation: Click the Start From Beginning command on the Quick Access Toolbar, or press the F5 key at the top of your keyboard. The presentation will appear in full-screen mode. clicking the Start From Beginning command on the Quick Access Toolbar - www.office.com/setup Select the Slide Show view command at the bottom of the PowerPoint window to begin a presentation from the current slide. Switching to Slide Show view from the Status bar in the lower-right corner - www.office.com/setup Go to the Slide Show tab on the Ribbon to access even more options. From here, you can start the presentation from the current slide and access advanced presentation options. starting a presentation from the Slide Show tab - www.office.com/setup TO ADVANCE AND REVERSE SLIDES: You can advance to the next slide by clicking your mouse or pressing the spacebar on your keyboard. Alternatively, you can use or arrow keys on your keyboard to move forward or backward through the presentation. You can also hover your mouse over the bottom-left and click the arrows to move forward or backward. hovering the mouse to access navigation buttons in Slide Show view - www.office

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Access is a database creation and management program. To understand Access, you must first understand databases. In this lesson, you will learn about databases and how they are used. You will familiarize yourself with the differences between data management in Microsoft Access and Microsoft Excel. Finally, you will get a look ahead at the rest of the Access tutorial. Watch the video below to learn more about databases in Access. WHAT IS A DATABASE? A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easily. They're such a useful tool that you see them all the time. Ever waited while a doctor's receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? If so, then you've seen a database in action. The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above: the database of patient information at a doctor's office. What lists are contained in a database like this? To start with, there's a list of patients' names. Then there's a list of past appointments, a list with medical history for each patient, a list of contact information, and so on. This is true of all databases, from the simplest to the most complex. For instance, if you like to bake you might decide to keep a database containing the types of cookies you know how to make and the friends you give these cookies to. This is one of the simplest databases imaginable. It contains two lists: a list of your friends, and a list of cookies. An illustration of two lists - www.office.com/setup However, if you were a professional baker, you would have many more lists to keep track of: a list of customers, a list of products sold, a list of prices, a list of orders, and so on.

www.office.com/setup Blogs: All cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand. Optional: Download our practice workbook. Watch the video below to learn more about formatting cells in Excel. TO CHANGE THE FONT SIZE: Select the cell(s) you want to modify. Selecting a cell - www.office.com/setup On the Home tab, click the drop-down arrow next to the Font Size command, then select the desired font size. In our example, we will choose 24 to make the text larger. Selecting a font size in the dropdown menu - www.office.com/setup The text will change to the selected font size. The selected cell is a larger font size now - www.office.com/setup You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using your keyboard. The custom font box, increase font size button, and decrease font size button - www.office.com/setup TO CHANGE THE FONT: By default, the font of each new workbook is set to Calibri. However, Excel provides many other fonts you can use to customize your cell text. In the example below, we'll format our title cell to help distinguish it from the rest of the worksheet. Select the cell(s) you want to modify. Selecting a cell - www.office.com/setup On the Home tab, click the drop-down arrow next to the Font command, then select the desired font. In our example, we'll choose Century Gothic. Selecting a font in the dropdown menu - www.office.com/setup The text will change to the selected font. The selected cell is a different font now - www.office.com/setup When creating a workbook in the workplace, you'll want to select a font that is easy to read. Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial. TO CHANGE THE FONT COLOR: Select