For Schools: Using OneNote without OneDrive

Overview

If you have OneDrive for Business at your school you can easily share your OneNote note book with other Teachers, and Students. If your school has OneDrive for Business, you will see it as an option when opening or creating a Notebook as “OneDrive – My School Name”

Some schools don’t have OneDrive for Business available. So, let’s explore some typical scenarios where you want to share your notebook but you don’t have OneDrive.

Scenarios

How to create my OneNote Notebook so other teachers or staff can collaborate

You’ll need a shared drive that the colleagues who need to collaborate all have access to.

If you need to finely control the access to this content – e.g. some people can read, some can edit, then you’ll need to approach your IT security people with pizza and caffeinated beverages. If you can give them a list of who needs which level of access they can help you with that. (When you get OneDrive for Business you can specify who gets edit or read yourself) Continue reading “For Schools: Using OneNote without OneDrive”

OneNote Sample Notebooks

While training in Office 365, Groups and Planner I have been encountering people new to OneNote. So here are a few resources to start you off, If you are new to OneNote!

Don’t forget you can OneNote for any platform, and there are handy apps (for example explore Office Lens – use it on your smartphone to take photos of receipts or business cards and send them back to OneNote)

These are sample OneNote Notebooks, they can be read online or downloaded.

Also an interesting example of OneNote being used as a distribution medium with the ubiquity of OneNote clients being mentioned as a factor in choosing this format.

More available at:

and don’t forget the old favourites:

That should get people started!!

Steven
IT Trainer

 

 

 

Fresh OneNote resources for Schools

Always looking for new uses of OneNote and found two that I’d like to share with you.

Free eBook for teachers: “Liberating Genius: The First 20 Days” by Angela Maiers – which is an e-book using OneNote as its “host”. This has got me thinking about going beyond my current use of OneNote as a scrapbook for course resources to using it for courseware.

College prep planning resources and virtual event for students use OneNote as a resource to support an online session. Its aimed at american students going to college, but its worth Australian and other schools getting a copy to explore the approach.

PowerPivot Reference Card

This card is an excellent reference for PowerPivot users. Its also free and available Giving Back: “Steal” this Reference Card!

The host web site http://www.powerpivotpro.com/ is also worth bookmarking!

 

Business Metrics for Data-Driven Companies

Signed up for “Business Metrics for Data-Driven Companies” the first course of a 5-course series, the Excel to MySQL: Analytic Techniques for Business Specialization. Enjoyed the Microsoft edX course I did recently, so I thought I’d do more.

Thought it was a fit and should help with the questions I get from Business Analysts on Excel and SharePoint Courses.

Microsoft: DAT206x Excel for Data Analysis and Visualization

Successfully completed (97%) the edX course: Microsoft: DAT206x Excel for Data Analysis and Visualization!

Learned a lot and filled in some gaps in my knowledge especially with Power Query and Power BI. I’d recommend it, keep an eye out for it! Looking forward to my certificate.

Now I am keen to learn more – looking at Excel to MySQL: Analytic Techniques for Business Specialization which is a series of courses and a project. Have to get enrolled by Nov 9 for the first course.

 

Ben Wellington: How we found the worst place to park in New York City — using big data

This is an excellent Ted talk about open data, gives practical examples and raises the need for consistent standards for data provided by Government.

There is a follow on discussion needed here about government making data public and in a form where the public can explore it and draw their own conclusions and effectively debate and discuss government plans and proposals.

If you follow this talk back to Ted, you will find a whole set of Data related talks, I recommend the one by Amy Webb.

 

Add data to you Power Pivot using Power Query in 25 minutes

Lesson Two

Give me 25 minutes and I will show you how to add data to an existing Power Pivot using Power Query. Add data from Excel and CSV files.

This process is useful if you need to periodically add new data e.g. monthly.

Give me 28 minutes to introduce you to Power Pivot

Make your first step into Business Intelligence tools by using data in Excel worksheets and Power Pivot

Learn how to:
– add to data model
– create relationships
– add calculated columns
– create a pivot table
– see one approach for grouping by dates

Lesson One in a series where I aim to introduce you to the “Power Tools” for Excel 2013 and SharePoint

 

Office for Android Tablets – Preview

This is a key step by Microsoft, preview versions of the big three from the Office suite are available for Android Tablets. Not final versions, but worth exploring. So far I have installed them on my old Nexus 7 (with KitKat). I’ve done a few basic tasks in Word, but haven’t checked them out in full (report next week)

If you want to try them out use the links below to get to the Google Play Store

When you get to the Google play store search also for  OneDrive and OneNote (There is even OneNote for Android Wear!)

If you are on any other device you are already catered for MS Office for most devices

So why is this a big deal?

As Office 365 and SharePoint online start to get some traction, users will want to work with content in the field. Android tablets are a cost effective way for business to provide a handy, but functional tool. While there are third party apps for working with Office files, I found this a mixed success and the lack of these apps is what lead me to moving to a windows tablet (and the cost of basic windows tablets becoming competitive).

So when the final apps are released, companies can give staff a good android tablet and use Office 365 (and bank the money they saved vs buying i-Pads).

Steven

Where do I find Office 365 Resources?

Via Mary Jo Foley (of the Windows Weekly Podcast), this a page of free Office 365 Resources –  includes Office 2013 resources, quick reference guides and e-books. Well worth exploring: Office 365 Resources

Focusing on Forms

I needed to find a theme to explore, so driven by:

  • cumbersome experience handling forms from insurance agents, recruiters and clients
  • need to make information gathering more efficient in my own business
  • looking for a theme to tie together study I have to do in a meaningful way!
  • a theme for a series of tutorials to be created using my snazzy new Captivate template, that people will find useful.

I found a direction, so the theme is:

Forms, Data Collection and Processing

Across a range of tools explore the following aspects

  • Ability to create forms using no code or as little code as possible.
  • Adding fields
  • Branding and Formatting
  • Data Validation
  • Controlling navigation (e.g. jump ahead based on a choice)
  • Distribution and Security
  • End User Experience
  • Data collection options, Analysis and Exporting (eg to Excel)

Continue reading “Focusing on Forms”