How To Extract Season From Date in Excel

The easiest way is to use the CHOOSE function with the following formula:


Remember to replace the A2 with where the date is on your sheet.

E-commerce security plans

Divide yourselves into groups of 3-4 to discuss company e-commerce security plans from a management perspective.You should try to answer the following questions:

1. How important is a corporate security policy? Why?

Technology on its own is not enough, the business requires staff policies to impliment security prosedures eg lock work stations when not present, limit access to server rooms and enable logs of phisical access to servers. ensure that data is limited to need to know bases and acess to these files reflect this

2. Can technology be the only answer in managing the risks of e-commerce?

  • Policies & procedures
  • Legal framework / Enforcement (eg. etransactions)

3. Identify the challenges encountered in setting up a corporate security policy.

  • Prioritise info risks
  • Carry out risk assessment
  • Set goal / targets to achieve
  • Personnel responsible for

4. What are the main issues an e-commerce security plan should address?

  • eTransactions (online payment systems)
  • Customer Databases
  • Confidential company documents and accounts

5. Based on the above, what are the steps a company should take in order to develop an e-commerce security plan?

  • Riskassessment
  • Design and Development Policies
  • Impliment Security Policies
  • Create a security organization (education and training of users,Keep up-to-date with new risks & Technolgies, Administer access controls)
  • Security Audit
  • reassess

Relationships, Journalism & PR


There seems to be a common misunderstanding among people about the nature of journalism and public relations. It seems as though journalists are often being viewed as purveyors of truth, where PR practitioners don’t care too much about truth. This is a vast misconception.

In fact both sides often have their own agenda. Whether it is a newspaper trying to portray a political party or organisation in a certain light, or the PR practitioner trying to portray their client in the best light possible, the individual agendas are there. However it is up to the practitioner/organisation to identify where the agendas overlap and tailor the story/pitch/press release in recognition of any overlap, so that they may effectively put across their point of view. Below is a diagram which only gives a rough idea of how little the agendas of journalism and PR actually overlap.

I’ll leave you with a parting thought.

“Damn the torpedoes! Four bells. Captain Drayton, go ahead! Jouett, full speed!”

David Farragut, 1801-1870

Summer of semester: social media

Enterprise Social Networks

Objectives (remember?)

The module aims to provide you with:

an   understanding   of   trends   in   online   collaboration   tools   and communication technology;

an overview of social networks taxonomy;

knowledge of how the social networking impacts on different business processes in an enterprise;

knowledge of how to identify and evaluate social networking sites to improve business performance;

an awareness of how to formulate a social media strategy of an enterprise;

What we covered

Web technologies &
social media applications

Web 2.0
The web seen as a platform serving web applications to end-users where data is the driving force

Social media
Media designed to be disseminated through social interaction and created using collaborative, accessible and scalable publishing techniques

Enabling technologies
Blogs, wikis, social networks, crowdsourcing, RSS, aggregators & mashups, Ajax, media sharing, tagging & folksonomies, tagclouds & the long tail.

Marketing and SEN

Online marketing environment

(suppliers, distributors, stakeholders, competitors)

(political, economic, societal, technical)

Brand awareness & reputation, lead generation, new customers and product development

Reach, Richness, Range

Web 2.0 & apps
Visibility, popularity, find-ability (SEO & paid inclusion)

Low, medium & high impact indicators
Frequency-Reach-Yield method

SEN in the Public Sector


  • According to contact
  • (eLearning communities, blended learning communities)
  • According to relationship
  • (knowledge-based, practice-based, task-based)
  • According to focus
  • (personal aspects, process, technology)


  • Electronic health records, telemedicine, consumer health informatics, health KM, virtual healthcare teams, mHealth, healthcare IS


  • G2C, G2B, G2E, G2G, C2G
  • mGovernment

Edge: a Social Intranet


  • Insurance, intellectual property, outsourcing, real estate
  • 66 partners, 200 lawyers, 60 secretaries, 100  bus. support

KM programme

  • a new social way of working


  • News reader (Attensa)
  • Wiki (Confluence)
  • Blog (Confluence)
  • Profiles & microblogging (The Box)
  • Groups  (The Box, Confluence, Attensa)
  • Activity streams  (The Box)

but also: engagement, training, use

The Scope & Role of SN/SM

The nature of networking

  • Opportunities
  • Reactions
  • Reputation

Institutional thinking V Network thinking

  • CSC
  • ORS

Business Applications

Enterprise 2.0 the Concept

  • Taking Social Networks and Social Media into the Enterprise
  • defining the terms
  • issues

Types of Business Use

  • statistics indication usage
  • types of use, purpose, function, sector and examples


  • Issues
  • Obstacles
  • Benefits

Policy Issues

  • Levels and Types of Use
  • Level of SM Maturity – level of development and how are they using it on a customer level view and a B2B or intrabusiness, similar to eCommerce.
  • Abuse and Misuses of SN/SM – same issues as with internet access, same arguments have been made about printing press, mass education and other similar things
  • issues and examples – list of issues (sacked, miss use and talking abt clients, products)


  • Issues and Reasoning for a Policy (their should be a line between personal and professional environment and we expose ourselves to sector regulations )
  • Setting Objectives
  • What to consider
  • people, issues (who or what department monitors and creates policies for SM as computer systems are a closed network for employers, and common sense is not that common

Good Practice

Strategy Issues

Levels and Types of Use

Defining & purpose – setting objectives and distributing resources


Next generation enterprise – change as tech enterprise systems and new socialisation of a business organisation, (formal – informal organisation) sm is centralising the informal organisation

Business transformation

Business Imperatives


employees – customers – the social web **inside employees, customers outside

Focused Strategies

  • Brand ** getting people familiar to the brand (trying to get people to notice us)
  • Marketing ** how push out products (trying to drive sales)
  • Transactions ** how to integrate


The coursework includes independent research, analysis and evaluation of social networking, its impact on enterprise and recommendation for implementation. 

It will explore how to identify the most suitable and effective social media to improve organisation’s reputation and to advance marketing and advertising campaigns.  

The report assignment will encourage students to explore and evaluate different type of social media applications and communication platforms, then analyse, argue and recommend a social media strategy for a given enterprise.


Books: IT for management,


ESN and eGovernment

ESN and eGovernment


This seminar evaluates the contribution of eGovernment to economic objectives and assesses its impact on engaging people in policy making and improving policy outcomes.


1.0 e-Government can help achieve better outcomes in major policy areas. Identify as many of these policy areas as possible and outline how social media can be implemented to this end.

  • Health Policy << Automated online schedule and give health advice online which can possibly decrease the demand on local GP’s and hospitals
  • Fiscal Policy << Benefits and unemployment benefits information centralised on an online system
  • Environmental Policy << Information regarding carbon footprint and business obligations schedule and information of toxic material dumps
  • Taxation Policy << Information regarding tax individuals or businesses which help cut costs
  • Social Policy << Education and benefits, other information relating to local sports and activities and community awareness.
  • Local Government << mostly information relating to local policy and local politics
  • Foreign Policy << support for petitions and foreign affairs, immigration rules and particular information for foreign
  • Education Policy << regarding standardisation of the education system, exams and legal framework on certification.

2.0 – Identify and address as many disadvantages of eGovernment as possible.

  • Internet Access availability – as with any complex system, servers and internet connections can be down (power, maintenance, cyber-warfare).
  • Data protection – information might be easily available for internal staff that should not have access to this information.
  • Privacy – centralised data centres storing health, education, taxation, criminal information about an individual.
  • Loss of information – due to hardware faults, viruses, hackers, accidents.
  • Fraud – Personal identity theft, internal miss inputing of data.
  • Basic IT / literacy skills – some individuals do not have the skills to access a website such as and might not even be able to read the information presented to them.No interpersonal interaction – No customer service representative to lease with your personal issues and not only one person on your case.
  • Cost of eGov design – 
  • Issues of transparency, accountability – 
  • Cyber Warfare – 
  • Hidden Agendas – 

3.0 – The Sandbox is a space for the Digital Communications team of the Department for Business, Innovation and Skills. Ascertain the site’s role and functionality and comment on the use of social media to engage people in policymaking, including how-to guides and methodologies.


Provide brief answers for each of the above questions.

 Further reading


Social Media and Public Sector week 5 lecture

Social media & public sector

  • Initial suspicion towards SM.
  • Lack of, or anecdotal only, evidence.
  • Fear that employees may misrepresent their organisations or disclose sensitive information.
  • According to Socitm survey many councils take a cautious view of social media, with some 90% restricting access in some way and with 67% having a total ban on use.
  • Need to establish organisational policy and protocols for SM use by employees and  managing the organisation’s reputation online.


  • It comprises all forms of electronically supported learning and teaching and is essentially the computer and network-enabled transfer of skills and knowledge.
  • E-learning applications and processes include Web-based learning, computer-based learning, virtual education opportunities and digital collaboration. Content is delivered via the Internet, intranet/extranet, audio or video tape, satellite TV, and CD-ROM.

eLearning 2.0

  • E-learning 2.0 places increased emphasis on social learning and use of social software and virtual worlds.
  • AKA Long Tail Learning
  • It assumes that knowledge is socially constructed, so learning takes place through conversations about content and systematic interaction about problems and actions.
  • Advocates of social learning claim that one of the best ways to learn something is to teach it to others.
  • Social networks have been used to foster online learning communities around various subjects.

Online learning communities

  • Online learning communities address their members’ learning needs by facilitating peer-to-peer learning. People work as a community to achieve a shared learning objective through social networking.
  • Learning objectives may be proposed by the community owner or may arise out of discussions between participants that reflect personal interests.

Categories of OLC ( Online learning community )

According to contact

e-learning communities
(groups interact and connect solely via technology)

blended learning communities
(face-to-face meetings as well as online meetings)

According to relationship

  • knowledge-based
  • practice-based << as in a work environment
  • task-based << usually in work environment as well, a task which needs to be fulfilled and a course is not required but people inside the business will help

According to focus

  • personal aspects << if you are interested in something but you want to learn more
  • process << its a process, a step towards something else which will help me on another thing
  • technology.

Enabling technologies 

  • Synchronous (e.g. instant messaging) < real time response (ask reply, ask reply)
  • Asynchronous
  • (e.g. message boards, Internet forums) << takes a bit longer to reply
  • Blogs <<
  • Wikis
  • Course management tools
  • (e.g. Blackboard, Moodle,  Lectureshare)
  • Social learning (e.g. Babbel, ConnectYard)
  • Social sharing (e.g. and Flickr)


Open Source Course Management System

1113566 registered users (Fri, Oct 21st 2011)

“Activity modules
(such as forums,
databases and wikis)
to build collaborative
communities of learning
around their subject
matter [..] while others
prefer to use Moodle
as a way to deliver
content to students
and assess learning
using assignments
or quizzes.”


  • Also called Health Informatics
  • E- health  is a relatively recent term for healthcare practice supported by electronic processes and communication,
  • Its broad definition covers electronic/digital processes in health
  • A narrower definition covers aspects of healthcare practice using the Internet.

eHealth range of services  

  • Electronic health records: communication of patient data between different healthcare professionals; <<how the NHS stores peoples personal data which is centralised.
  • Telemedicine: treatments at a distance;
  • Consumer health informatics: use of electronic resources on medical topics by healthy individuals or patients;
  • Health knowledge management: overview of latest medical journals, best practice guidelines, epidemiological tracking <<HKM is info abt health for practitioners
  • Virtual healthcare teams: healthcare professionals collaborating/sharing information on patients; << mostly specialised drs.
  • M – health: health services through mobile devices;  << via smart phones and other access
  • Grid medical research: powerful computing and data management capabilities to handle large amounts of heterogeneous data. <<grid is a large number of computers interconnected so that the processing power is increased.
  • Healthcare Information Systems: software solutions for appointment scheduling, patient data management, etc. << NHS direct and other services online

Patient Opinion

Patient feedback for improving UK health services. << this helps research information about the quality of GPs and Dr.s in the UK to give your feedback, it is also linked with eGov.

eHealth Forum
it is online communities where Dr.s and other specialists awser question, but an issue of these communities is that its not regulated and you don’t know the advice with you are getting.

NHS Choices
the NHS online expansion, which includes blogs and articles.

Web 2.0 NHS portal & enabling technologies

Medical Knowledge Management, targeted interactive marketing, education, content, and medical research solutions


Digital interactions between a government and citizens, government and businesses, government and employees, and between government and governments/agencies.

e-Government delivery models (Jeong, 2007)

  • G2C (Government to Citizens)
  • G2B (Government to Businesses)
  • G2E (Government to Employees)
  • G2G (Government to Governments)
  • C2G (Citizens to Governments)


  • Government-to-Citizen is the communication link between a government and private individuals or residents.
  • G2C communication most often refers to that which takes place through Information and Communication Technologies (ICTs)
  • The G2C model applies the strategy of Customer Relationship Management (CRM) with business concept. << it tried to help to create a relationship between Gov to consumer
  • By managing their customer (citizen) relationship, the business (government) can provide the needed products and services fulfil the needs from customer (citizen).

Singapore’s e-citizen Portal << One of the best as it had a enterprise social network aspect and good web design


Government-to-Business is the online non-commercial interaction between local and central government and the commercial business sector.

G2B provides businesses information and advice on e-business ‘best practices’.

G2B transactions include various services exchanged between government and the business community, including dissemination of policies, memos, rules and regulations.

Business services offered include obtaining current business information, downloading application forms, renewing licenses, registering businesses, obtaining permits, and payment of taxes.

Department for Business, Innovation and Skills (BIS)


Government-to-Government is the online non-commercial interaction between Government organisations, departments, and authorities and other Government organisations, departments, and authorities.

G2G systems cab be:

Internal facing – joining up a single governments departments, agencies, organisations and authorities.
Example is the integration aspect of Government Gateway and UK NHS Connecting for Health Data SPINE

External facing – joining up multiple governments IS systems . Example is the integration aspect of the Schengen Information System (SIS), developed to meet the requirements of the Schengen Agreement.


Government-to-employees is the online interactions through communication tools between government units and their employees.

It streamlines internal processes, improves collaboration, knowledge sharing and staff productivity.

It enables employee access to information in regard to compensation and benefit policies, training and learning opportunities and civil rights laws.

G2E services also include software for maintaining personnel information and records of employees.

Setting up a context  

Elements of eGovernment (a)* 

  • Easier access – making it easier for citizens and businesses to find, access and interact with government services. <<collect is using the web and decrease handling costs for gov.
  • Service innovation – making government services more responsive to the needs of individuals and improving the quality of service outcomes. << same thing but user does most of leg work
  • Policy innovation – creating new ways for government to understand unmet needs and develop and implement policy initiatives to address priority problems in a timely and efficient manner << by having all information centralised and feedback you are able to react with the information
  • Better engagement – improving the interactions between government and its many agencies and their citizen, community and business stakeholders.  <<less bureaucracy

Elements of eGovernment (b)*  

  • Better coordination – enhancing the way processes interoperate within government and the way information is used and shared across government agencies. <<with less people involved and all information placed online, which decreases costs and increase efficiency, draw back is people who are unable to use technological services.
  • Shared information – enhancing the way data and information is used to provide an evidence base for policy and service responses and also to enable increased use of public sector information by citizens and businesses to boost innovation and engagement in matters of public interest.
  • Efficient operations – streamlining government operations to reduce duplication and waste and promote reuse and sharing of ICT assets to enable redirection of funds from ‘back room’ activities to the front line of service delivery.

Key questions*

  • Who owns these new social networks and in whose interests are they being operated? <<GOV and that Data protection is essential
  • If key public services are provided using social networking services (e.g. advice to parents, tax guidance), to what extent should government seek to control the services upon which it relies? << who controls the information and who has access and who owns the information
  • What are the rules for privacy, security, trust and consent? <<the consent has to be understood
  • How does the government protect the authority of its information while allowing the conversations and communities to grow and flourish? <<how does the GOV separate information which is private and what is public
  • How can a government set clear measures and metrics to gage the success of fairly new and innovative practices and projects? <<
  • How will social media and Web 2.0 continue to change existing government practices and cultures?


  • Mobile government  is the extension of eGovernment to mobile platforms.

Its benefits include:

  • cost reduction
  • efficiency
  • transformation/modernization of public sector organizations
  • added convenience and flexibility
  • better services to the citizens
  • ability to reach a larger number of people

mGovernment problems 

need development of wireless and mobile networks and related infrastructure, as well as software

mobile phone numbers and devices are relatively easily to hack while wireless networks are vulnerable as they use public airwaves to send signals

overcoming mistrust about misuse of personal data sold to third parties

Public participation
need for user-friendly citizen-oriented services and easy access to mGovernment information in alternative forms

Legal Issues
many countries have not yet adopted legislation for data and information practices

Compatibility and Interoperability
need to overcome technical difficulties by using open not proprietary standards.


  • ESN adoption by the private sector has led to the transformation of organisational structures and the broadening of corporate ecosystems.
  • ESN adoption in the public sector is following, by presenting new opportunities, especially in the areas of health, education and governance.
  • Advantages include cost-effectiveness, agility, transparency, end-user empowering, citizen engagement and innovation.
  • And disadvantages?

Further reading

  • Charlton J (2011) Public sector use of Social Media takes off
  • Learning Sites
  • Della Mea V (2001). What is e-Health (2): The death of telemedicine?
  • eHealth,eLearning,eGov:Recommendations from the eUSER Project

Egov Monitor

Lecture by Fefie Dotsika professor at The university of Westminster