{"id":19,"date":"2018-03-05T15:01:21","date_gmt":"2018-03-05T15:01:21","guid":{"rendered":"http:\/\/blogs.kent.ac.uk\/mediacrime\/?page_id=19"},"modified":"2018-04-05T10:44:10","modified_gmt":"2018-04-05T09:44:10","slug":"working-with-the-excell-database","status":"publish","type":"page","link":"https:\/\/blogs.kent.ac.uk\/mediacrime\/working-with-the-excell-database\/","title":{"rendered":"Constructing a Database for a Multi-method Media Analysis"},"content":{"rendered":"<p>Here you will find all info related to building the Newspaper database and generating output.<\/p>\n<p><strong>1. Structure your research<\/strong><\/p>\n<p>Before downloading newspaper articles, getting a set of folders organised on your computer will enable you to store data and writings in a structured way. The structure described here offers\u00a0 some guidelines. There is not just one structure. In fact whatever structure works for you is ok.<\/p>\n<ol>\n<li>Create a folder \u2018Media Analysis\u2019 on your desktop (or any other place on your computer that makes sense to you).<\/li>\n<li>Create within the folder \u2018Media Analysis\u2019 the following sub-folders:\n<ol>\n<li>Data<\/li>\n<li>Writings<\/li>\n<li>Notes<\/li>\n<li>Literature<\/li>\n<\/ol>\n<\/li>\n<li>Download the \u2018codebook\u2019 (WORD-file) and the \u2018Database Grid\u2019 ( Excel-file) on the <a href=\"https:\/\/moodle.kent.ac.uk\/2017\/course\/view.php?id=1884\">Moodle page of SO881<\/a>. Save both documents in the folder \u2018Media Analysis.\u2019<\/li>\n<\/ol>\n<h4>2. Data Collection<\/h4>\n<p>The first step in crafting a database is to develop search terms. The initial search terms will be very straightforward, here we will use \u2018shootings\u2019 in the Headline and \u2018Las Vegas\u2019 in the introduction. However a quick look at the retrieved stories might reveal that while some of the stories focus on the story of mass shooting in Las Vegas, some just mention the concept \u2018shooting\u2019 or \u2018Las Vegas\u2019 and have nothing to do with the principal story of your analysis.<\/p>\n<p>In a second step, scan through the results and articles. Make sure you do this in a structured way, but retrieve only information rich articles (a good number of words, focussed on your topic not a side-line story).<\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/blogs.kent.ac.uk\/mediacrime\/working-with-the-excell-database\/constructing-the-database-part-i\/\">Starting the Database PART I: ID, Newspaper and Methodological Variables<\/a><\/p>\n<p style=\"text-align: center\">Back to the <a href=\"http:\/\/blogs.kent.ac.uk\/mediacrime\/\">main menu<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here you will find all info related to building the Newspaper database and generating output. 1. Structure your research Before&hellip; <a class=\"read-more\" href=\"https:\/\/blogs.kent.ac.uk\/mediacrime\/working-with-the-excell-database\/\">Read more <span class=\"screen-reader-text\">Constructing a Database for a Multi-method Media Analysis<\/span><\/a><\/p>\n","protected":false},"author":54808,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/pages\/19"}],"collection":[{"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/users\/54808"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":11,"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/pages\/19\/revisions"}],"predecessor-version":[{"id":188,"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/pages\/19\/revisions\/188"}],"wp:attachment":[{"href":"https:\/\/blogs.kent.ac.uk\/mediacrime\/wp-json\/wp\/v2\/media?parent=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}