Data Management Services for Linfield College

This document describes the data management services available to researchers at Linfield. For researchers who would like to be able to copy and paste sections from this document for use in their data management plans, please download the version in Microsoft Word, available from the additional files section

Forecasting Pre-K Enrollment in Georgia Counties

This report provides a manual that documents the forecasting methodology and provides the actual forecast of Pre-K enrollment by county for 2007-2011. FRC Report 15

Changes Coming: How Information Literacy and Presentation Software Intersect

Information literacy should promote changes in a person’s attitude and actions regarding an issue. Learning how to access and use resources is ineffective if changes do not occur in communicating more effectively. This paper focuses on eight changes: audience, storyboard, master views, handouts, action , control keys, bullets, and photography

A Primer on Spreadsheet Analytics

This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model. It discusses the terminology of spreadsheet analytics, how to prepare a spreadsheet model for analysis, and a hierarchy of analytical techniques. These techniques include sensitivity analysis, tornado charts,and backsolving (or goal-seeking). This paper presents native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation are briefly discussed. The paper concludes by calling for empirical research, and describing desired features spreadsheet sensitivity analysis and spreadsheet optimization add-ins.Comment: 12 Pages, 8 Colour Figure

Depicting the analyses of the first National Maltese Childhood BMI study

Introduction Obesity is a chronic disease that often commences in childhood. Several publications have shown that a quarter to a third of Maltese children are overweight or obese. Malta will be the first country to measure height and weight (and hence Body Mass Index) for all school children in order to quantify the extent of the problem. Methods This study would include 46,000 children in 150 schools. This would be the first time that any country measured its entire childhood cohort, as opposed to sampling. Hence, it was decided to attempt to facilitate data collection and analysis with the use of bespoke spreadsheets. Results This paper will demonstrate how standard Microsoft Excel was used to accomplish this, greatly speeding up the data analysis process. Conclusion Software should be prepared in advance in anticipation of large amounts of data that need to be analysed and summarised. Particular care must be taken in order to prepare the requisite graphs and tables in advance so as to process the data once and present it in a suitable format for consumption and evaluation.peer-reviewe